APP_FIELD: Item Relationship Utilities

This section describes utilities you can use to maintain relationships between your form items.

 

연결된 필드들에 대해서 

첫번째 필드 값 변경 시 나머지 필드들에 대하여 CLEAR 할 때 사용

APP_FIELD.CLEAR_FIELDS

procedure  APP_FIELD.CLEAR_FIELDS(

 field1  varchar2, 
                         field2  varchar2 default NULL,
                         field3  varchar2 default NULL,
                         field4  varchar2 default NULL,
                         field5  varchar2 default NULL,
                         field6  varchar2 default NULL,
                         field7  varchar2 default NULL,
                         field8  varchar2 default NULL,
                         field9  varchar2 default NULL,
                         field10 varchar2 default NULL);

Description

This procedure clears up to ten items if the items are not NULL and are not check boxes or required lists.

 

 

연결된 필드들에 대해서

첫번째 필드 값 NULL 시 나머지 필드들에 대하여 CLEAR 할 때 사용

APP_FIELD.CLEAR_DEPENDENT_FIELDS

procedure  APP_FIELD.CLEAR_DEPENDENT_FIELDS(

master_field varchar2,
                         field1  varchar2,
                         field2  varchar2 default NULL,
                         field3  varchar2 default NULL,
                         field4  varchar2 default NULL,
                         field5  varchar2 default NULL,
                         field6  varchar2 default NULL,
                         field7  varchar2 default NULL,
                         field8  varchar2 default NULL,
                         field9  varchar2 default NULL,
                         field10 varchar2 default NULL);

Description

This procedure clears up to ten dependent items if the master item is NULL and the dependent items are not NULL and not check boxes or required lists.

 

master_field	Name of master item
field1 ... field10	Name of dependent item(s).

 

 

https://docs.oracle.com/cd/E26401_01/doc.122/e22961/T302934T462355.htm

Oracle E-Business Suite Developer's Guide