c# convert pdf to image ghostscript: Add password to pdf reader software Library dll windows .net asp.net web forms e2296114-part790

Setting the Properties of Widget Objects 12-9

Filter Before Display

If an LOV may show more than one hundred rows, then the user must be prompted to

reduce the list of valid values first (Filter Before Display:Yes).

Never have Filter Before Display set to Yes, and Automatic Refresh set to No, on an

LOV. This combination would cause only the reduced set of rows to be cached if the

user enters something in the reduction criteria window. With Automatic Refresh off,

there is no way of returning to the full set of rows. Typically it is not wise to cache an

LOV that returns more than 100 rows.

Example LOV

The EMP table contains the following columns: EMPNO, ENAME, JOB, MGR,

HIREDATE, SAL, COMM AND DEPTNO. DEPTNO is a foreign key to the table DEPT,

which contains the columns DEPTNO, DNAME, and LOC.

A form view of the EMP table would contain all columns in EMP, denormalize

EMP.DEPTNO, and include the column DEPT.DNAME, as well. It might also include

DEPT.LOCATION and other DEPT columns, and contain records for all past and

present employees:

CREATE VIEW EMP_V AS

SELECT EMP.EMPNO, EMP.ENAME, EMP.JOB, EMP.MGR,

EMP.HIREDATE, EMP.SAL, EMP.COMM,

EMP.DEPTNO, DEPT.DNAME, DEPT.LOCATION

FROM EMP, DEPT

WHERE DEPT.DEPTNO = EMP.DEPTNO;

By contrast, an LOV view of EMP would only include columns EMP.EMPNO and

EMP.ENAME. DEPT information would be included only if necessary to help select an

employee.

Decoding Y/N Values

For Y/N values, decode "Y" to "*" and "N" to null to avoid a join to FND_LOOKUPS.

Example

A table T has columns ID, NAME, and ENABLED_FLAG. ENABLED_FLAG contains

Y/N values. Create your view as follows:

CREATE VIEW T_V AS

SELECT ID, NAME,

DECODE(ENABLED_FLAG, 'Y', '*', NULL)

FROM T;

Dependent Fields

An LOV on a dependent field should use the value in the master field to reduce the list.

For example, if NAME is dependent on TYPE, the entry LOV for NAME's WHERE

clause would include the condition:

Add password to pdf reader - C# PDF Password Library: add, remove, edit PDF file password in C#.net, ASP.NET, MVC, WinForms, WPF

Help to Improve the Security of Your PDF Document by Setting Password

pdf protection remover; add password to pdf file without acrobat

Add password to pdf reader - VB.NET PDF Password Library: add, remove, edit PDF file password in vb.net, ASP.NET, MVC, WinForms, WPF

Help to Improve the Security of Your PDF Document by Setting Password

create password protected pdf online; break password on pdf

12-10 Oracle E-Business Suite Developer's Guide

WHERE TYPE = :MY_BLOCK.TYPE

LOVs in ENTER-QUERY Mode

LOVs in ENTER-QUERY mode should be used sparingly, as Query Find is the

preferred method for a user to locate records.

You should only code them where they dramatically improve the usability of

ENTER-QUERY mode, and you expect this mode to be used regularly despite Query

Find.

An LOV in ENTER-QUERY mode should display all values that the user can query, not

just currently valid values.

EXAMPLE: An LOV for vendors in a purchase order form in enter-query mode shows

all vendors that could ever be placed on a PO, not just the set of vendors that currently

are allowed to be placed on a PO.

Do not reuse the entry LOV in ENTER_QUERY mode unless it provides the correct set

of data for both modes.

Important: WHEN-VALIDATE-ITEM does not fire in ENTER-QUERY

mode. Therefore, you cannot depend on the WHEN-VALIDATE-ITEM

trigger to clear hidden fields when selecting from an ENTER-QUERY

LOV.

Implementation

To enable LOVs in ENTER-QUERY mode on an item, create an item-level

KEY-LISTVAL trigger as follows:

Trigger: KEY-LISTVAL

IF (:SYSTEM.MODE != 'ENTER-QUERY') THEN LIST_VALUES;

ELSE SHOW_LOV('query lov');

END IF;

Return into the LOV Item Only

When implementing LOVs in ENTER-QUERY mode, do not return values into any field

other than the field from which the LOV is invoked. If the LOV selects into a hidden

field, there is no way to clear the hidden field. Clearing or typing over the displayed

field will not clear the hidden field. Users must select another value from the LOV or

cancel their query and start over.

Alerts

Oracle E-Business Suite does not use the native Oracle Forms alert object. The Oracle

C# PDF insert image Library: insert images into PDF in C#.net, ASP

inserting image to PDF in preview without adobe PDF reader installed. Insert images into PDF form field. How to insert and add image, picture, digital photo

protected pdf; add copy protection pdf

XImage.Barcode Scanner for .NET, Read, Scan and Recognize barcode

Add Image to PDF; VB.NET Protect: Add Password to PDF; VB VB.NET Annotate: PDF Markup & Drawing. XDoc.Word for C#; C#; XImage.OCR for C#; XImage.Barcode Reader for

convert password protected pdf to normal pdf online; add password to pdf reader

Setting the Properties of Widget Objects 12-11

Application Object Library Message Dictionary feature is used instead, as it provides

full translation capabilities and handles text larger than 80 characters.

Editors

Do not write special code for the editor. Rely on native Oracle Forms behavior.

Flexfields

For more information on visual standards for descriptive flexfields, see the Oracle

E-Business Suite User Interface Standards for Forms-Based Products.

For information on building flexfields into your forms, see: Overview of Flexfields, page

Usage

All entities should provide a descriptive flexfield to allow customization.

Avoid using the same descriptive flexfield definition in more than one form. Because a

customer can reference any field in their flexfield definition, they may reference a field

that exists in one form but not the others.

Key flexfields should use the "ENABLE_LIST_LAMP" LOV, with the Use Validate from

List property set to No. Descriptive flexfields do not use an LOV.

Setting Item Properties

This section describes item properties Oracle E-Business Suite uses to control how the

user interacts with items when they are in specific states. Oracle E-Business Suite

provides a cover routine to the Oracle Forms built-in routine SET_ITEM_PROPERTY.

This cover routine, APP_ITEM_PROPERTY.SET_PROPERTY, modifies or augments the

native Oracle Forms behaviors for specific properties.

Using APP_ITEM_PROPERTY.SET_PROPERTY helps your forms adhere to the Oracle

E-Business Suite user interface standards and helps simplify coding. Using this routine

also helps to protect your form from future changes in the native Oracle Forms

SET_ITEM_PROPERTY built-in routine.

Using APP_ITEM_PROPERTY.SET_PROPERTY

The APP_ITEM_PROPERTY.SET_PROPERTY cover routine modifies the following

properties:

•

ALTERABLE

VB.NET PDF insert image library: insert images into PDF in vb.net

VB.NET PDF - Add Image to PDF Page in VB.NET. Guide VB.NET Programmers How to Add Images in PDF Document Using XDoc.PDF SDK for VB.NET.

pdf security password; break pdf password online

C# Imaging - Scan Barcode Image in C#.NET

RasterEdge Barcode Reader DLL add-in enables developers to add barcode image dimensional barcode types, such as Code 128, EAN-13, QR Code, PDF-417, etc

annotate protected pdf; change password on pdf document

12-12 Oracle E-Business Suite Developer's Guide

•

ALTERABLE_PLUS

•

ENTERABLE

•

DISPLAYED

•

ENABLED

•

REQUIRED

All other properties are processed with the native Oracle Forms functionality. Oracle

recommends that you call this cover routine even for properties that do not currently

have special behaviors in case they change in the future.

Note that calling APP_ITEM_PROPERTY.SET_PROPERTY and specifying a property

that is not valid for the indicated item will give the same error as the native Forms

built-in routine SET_ITEM_PROPERTY, except where certain conditions are masked as

noted below.

Item Properties with Unique Oracle E-Business Suite Behavior

ALTERABLE

The ALTERABLE property is intended to allow or disallow changes to a specific

instance (one row) of an item regardless of whether the record is a new or queried

record. The item remains keyboard navigable even if changes are not allowed.

The following code:

app_item_property.set_property(itemid, ALTERABLE,

PROPERTY_ON);

is equivalent to:

set_item_instance_property(itemid, CURRENT_RECORD,

INSERT_ALLOWED, PROPERTY_ON);

set_item_instance_property(itemid, CURRENT_RECORD,

UPDATEABLE, PROPERTY_ON);

set_item_property(itemid, INSERT_ALLOWED, PROPERTY_ON);

set_item_property(itemid, UPDATEABLE, PROPERTY_ON);

If the item is currently hidden, no action is taken.

Item and item-instance values are both set to make sure the effect of both of them

produces the desired result.

The following code:

app_item_property.set_property(itemid, ALTERABLE,

PROPERTY_OFF);

is equivalent to:

C# PDF Sticky Note Library: add, delete, update PDF note in C#.net

Evaluation library and components enable users to annotate PDF without adobe PDF reader control installed. Able to add notes to PDF using C# source code in

copy protecting pdf files; adding a password to a pdf using reader

C# PDF: PDF Document Viewer & Reader SDK for Windows Forms

Viewer in C#. In this section, we offer detailed guidance for you to create and add a PDF document viewer & reader in Windows Forms application using C# code.

reader save pdf with password; create copy protected pdf

Setting the Properties of Widget Objects 12-13

set_item_instance_property(itemid, CURRENT_RECORD,

INSERT_ALLOWED, PROPERTY_OFF);

set_item_instance_property(itemid, CURRENT_RECORD,

UPDATEABLE, PROPERTY_OFF);

If the item is currently hidden, no action is taken.

ALTERABLE_PLUS

The ALTERABLE_PLUS property is intended to allow or disallow changes to all

instances of an item (all rows of the block). Setting the property to PROPERTY_OFF

prevents the user from making a change to that item on any row, regardless of whether

each record is a new or queried record. The item remains keyboard navigable even if

changes are not allowed.

The following code:

app_item_property.set_property(itemid, ALTERABLE_PLUS,

PROPERTY_ON);

is equivalent to:

set_item_property(itemid, INSERT_ALLOWED, PROPERTY_ON);

set_item_property(itemid, UPDATEABLE, PROPERTY_ON);

If the item is currently hidden, no action is taken.

The following code:

app_item_property.set_property(itemid, ALTERABLE_PLUS,

PROPERTY_OFF);

is equivalent to:

set_item_property(itemid, INSERT_ALLOWED, PROPERTY_OFF);

set_item_property(itemid, UPDATEABLE, PROPERTY_OFF);

If the item is currently hidden, no action is taken.

ENTERABLE

The ENTERABLE property is designed to simulate disabling a particular instance of an

item (one row). It extends the ALTERABLE property by also controlling the

NAVIGABLE property; however, there is no way to prevent the user from clicking into

the item.

The following code:

app_item_property.set_property(itemid, ENTERABLE,

PROPERTY_ON);

is equivalent to:

C# HTML5 PDF Viewer SDK to view, annotate, create and convert PDF

A powerful PDF reader allows C# users to view PDF PDF editor enable C# users to edit PDF text, image Support to add password to PDF document and edit password

password protected pdf; copy protection pdf

.NET PDF Document Viewing, Annotation, Conversion & Processing

Document Protect. Apply password to protect PDF. Redact text content, images, whole pages from PDF file. Add, insert PDF native annotations to PDF file.

create pdf password; add password to pdf file with reader

12-14 Oracle E-Business Suite Developer's Guide

set_item_instance_property(itemid, CURRENT_RECORD,

INSERT_ALLOWED, PROPERTY_ON);

set_item_instance_property(itemid, CURRENT_RECORD,

UPDATEABLE, PROPERTY_ON);

set_item_instance_property(itemid, CURRENT_RECORD,

NAVIGABLE, PROPERTY_ON);

set_item_property(itemid, INSERT_ALLOWED, PROPERTY_ON);

set_item_property(itemid, UPDATEABLE, PROPERTY_ON);

set_item_property(itemid, NAVIGABLE, PROPERTY_ON);

If the item is currently hidden, no action is taken.

Item and item-instance values are both set to make sure the effect of both of them

produces the desired result.

The following code:

app_item_property.set_property(itemid, ENTERABLE,

PROPERTY_OFF);

is equivalent to:

set_item_instance_property(itemid, CURRENT_RECORD,

INSERT_ALLOWED, PROPERTY_OFF);

set_item_instance_property(itemid, CURRENT_RECORD,

UPDATEABLE, PROPERTY_OFF);

set_item_instance_property(itemid, CURRENT_RECORD,

NAVIGABLE, PROPERTY_Off);

If the item is currently hidden, no action is taken.

DISPLAYED

The DISPLAYED property handles displaying and hiding items as well as resetting

certain properties that Oracle Forms automatically sets when an item is hidden.

The following code:

app_item_property.set_property(itemid, DISPLAYED,

PROPERTY_ON);

is equivalent to:

set_item_property(itemid, DISPLAYED, PROPERTY_ON);

If the item is not a display item then also set:

set_item_property(itemid, ENABLED, PROPERTY_ON);

set_item_property(itemid, NAVIGABLE, PROPERTY_ON);

If the item is neither a display item nor a button then also set:

set_item_property(itemid, QUERYABLE, PROPERTY_ON);

set_item_property(itemid, INSERT_ALLOWED, PROPERTY_ON);

set_item_property(itemid, UPDATEABLE, PROPERTY_ON);

The following code:

app_item_property.set_property(itemid, DISPLAYED,

PROPERTY_OFF);

is equivalent to:

set_item_property(itemid, DISPLAYED, PROPERTY_OFF);

Setting the Properties of Widget Objects 12-15

ENABLED

The ENABLED property is primarily intended to disable an item that will never apply

during the entire session of the form. It differs from the native Oracle Forms behavior in

that when items are re-enabled certain properties that Oracle Forms set automatically

are reset.

The following code:

app_item_property.set_property(itemid, ENABLED,

PROPERTY_ON);

is equivalent to (for a text item or a list item):

set_item_property(itemid, INSERT_ALLOWED, PROPERTY_ON);

set_item_property(itemid, UPDATEABLE, PROPERTY_ON);

set_item_property(itemid, NAVIGABLE, PROPERTY_ON);

If the item is a button, then the APP_ITEM_PROPERTY.SET_PROPERTY call is

equivalent to:

set_item_property(itemid, ENABLED, PROPERTY_ON);

If the item is not a text item, list, or button, then the

APP_ITEM_PROPERTY.SET_PROPERTY call is equivalent to:

set_item_property(itemid, ENABLED, PROPERTY_ON);

set_item_property(itemid, INSERT_ALLOWED, PROPERTY_ON);

set_item_property(itemid, UPDATEABLE, PROPERTY_ON);

If the item is a display item or is currently hidden, then no action is taken.

The following code:

app_item_property.set_property(itemid, ENABLED,

PROPERTY_OFF);

is equivalent to (for a text item or list item):

set_item_property(itemid, INSERT_ALLOWED, PROPERTY_OFF);

set_item_property(itemid, UPDATEABLE, PROPERTY_OFF);

set_item_property(itemid, NAVIGABLE, PROPERTY_OFF);

If the item is neither a text item nor a list then:

set_item_property(itemid, ENABLED, PROPERTY_OFF);

If the item is a display item or is currently hidden, then no action is taken.

REQUIRED

The REQUIRED property sets whether an item is required or not, while adjusting for

whether the field is currently hidden. The REQUIRED property is an item-level

property (affects all rows of the block). If the REQUIRED property must change on a

per-record basis, you must reset the property as the cursor moves between the rows

(typically in the WHEN-NEW-RECORD-INSTANCE trigger). Alternatively, you may

prefer to call the native Oracle Forms built-in routine

SET_ITEM_INSTANCE_PROPERTY to set the REQUIRED property on a row-by-row

basis. Oracle E-Business Suite does not currently provide a cover routine for

12-16 Oracle E-Business Suite Developer's Guide

SET_ITEM_INSTANCE_PROPERTY.

The following code:

app_item_property.set_property(itemid, REQUIRED,

PROPERTY_ON);

is equivalent to:

set_item_property(itemid, REQUIRED, PROPERTY_ON);

If the item is currently hidden, no action is taken.

The following code:

app_item_property.set_property(itemid, REQUIRED,

PROPERTY_OFF);

is equivalent to:

set_item_property(itemid, REQUIRED, PROPERTY_OFF);

Impact of Item-level and Item-instance-level Settings

Oracle Forms supports setting properties such as INSERT_ALLOWED, UPDATEABLE

and NAVIGABLE at both the item level (all records) and item-instance level (just a

particular row). A precedence is applied between these two levels to determine the net

effect to the user. Thus, if a setting is OFF at the item-level, but ON at the item-instance

level, the net effect is that it is OFF. For this reason, exercise caution when setting

properties that involve multiple levels. For example, mixing ALTERABLE and

ENABLED calls on the same widget may not produce the desired effect.

Setting Properties at Design Time

While working in the Form Builder be aware that setting the Enabled property to No on

a text item or list item does not automatically exhibit the same behaviors as the runtime

equivalent set through APP_ITEM_PROPERTY.SET_PROPERTY. Instead, you must set

the Insert Allowed, Update Allowed, and Keyboard Navigable properties of the item to

No, and keep the Enabled property set to Yes.

Behaviors such as ALTERABLE and ENTERABLE can only be achieved at runtime

because they rely on item-instance properties that can only be set programmatically.

Setting Visual Attributes Programmatically

Unlike most Oracle E-Business Suite visual attributes that are applied as part of a

property class or are applied automatically by APPCORE routines, the following visual

attributes must be applied programmatically by the developer.

DATA_DRILLDOWN

The DATA_DRILLDOWN visual attribute makes the contents of a text item appear in

green with an underline. Applied programmatically, this visual attribute can be used to

Setting the Properties of Widget Objects 12-17

simulate a hypertext link for "drilldown" purposes. It only changes the appearance of

the text; it does not perform any linking logic.

DATA_SPECIAL

DATA_SPECIAL applies the color red on white to a field that needs special emphasis

because it contains a value that violates a business rule or requires the user's close

attention. For example, negative values in financial forms should be red on white. This

visual attribute is ordinarily only applied at runtime.

Warning: Any use of color coding should augment an indicator that

functions in a monochrome environment.

DATA_REQUIRED

Oracle E-Business Suite does not use the DATA_REQUIRED visual attribute.

Documents you may be interested

c# convert pdf to image ghostscript : Add password to pdf reader software Library dll windows .net asp.net web forms e2296114-part790