Form  PART_PARTNER_DTL

Title: Partner details

Partner detail form making available viewing and editing partner base data (name, sex) and partner address information. The address block is a standard RLB (referencing listing block) of the CORE.

The form uses sequences in the two editing block's ID fields loading values with .nextval.

The object is subclassed.

Subelements:

Triggers

Attached Libraries

Data blocks

Canvases

Object Groups

Parameters

Program Units

Visual Attributes

Windows

Trigger   PRE-FORM  

The object is subclassed. The subclassing takes effect by the owner's (PART_PARTNER_DTL) subclassing properties.

Trigger   WHEN-NEW-FORM-INSTANCE  

The object is subclassed. The subclassing takes effect by the owner's (PART_PARTNER_DTL) subclassing properties.

Trigger   KEY-COMMIT  

The object is subclassed. The subclassing takes effect by the owner's (PART_PARTNER_DTL) subclassing properties.

Trigger   KEY-EXIT  

The object is subclassed. The subclassing takes effect by the owner's (PART_PARTNER_DTL) subclassing properties.

Trigger   ON-CLEAR-DETAILS  

Attached Library   CORE_FRM  

Attached Library   CORE_DTLF  

Data Block   PART_PARTNER  

The object is subclassed.

Subelements:

Triggers( 2 ) Items( 4 )

Relations( 1 )

Triggers

Name	Comment
ON-POPULATE-DETAILS
PRE-DELETE

Items

Name	Comment
ID	The ID of the partner.
FIRST	The first name of the partner.
LAST	The last name of the partner.
SEX	The sex of the partner.

Relations

Name	Comment
PART_PARTNER_PART_PARTNER_ADDR

Trigger   ON-POPULATE-DETAILS  

Trigger properties Value Trigger Style PL/SQL Fire in Enter-Query Mode yes Execution Hierarchy Override	Trigger properties Value Display in 'Keyboard Help' no 'Keyboard Help' Text

Trigger   PRE-DELETE  

Trigger properties Value Trigger Style PL/SQL Fire in Enter-Query Mode yes Execution Hierarchy Override	Trigger properties Value Display in 'Keyboard Help' no 'Keyboard Help' Text

Item   ID  

The ID of the partner. Not shown for the user. Filled out automatically by the form.

Item properties Value Item Type Text Item Enabled yes Justification Start Implementation Class Multi-Line no Wrap Style Word Case Restriction Mixed Conceal Data no Keep Cursor Position no Automatic Skip no Popup Menu Keyboard Navigable yes Mouse Navigate yes Data Type Number Maximum Length 11 Initial Value Required yes Format Mask Lowest Allowed Value Highest Allowed Value Copy Value from Item	Item properties Value Synchronize with Item Number of Items Displayed 0 Database Item yes Column Name ID Primary Key no Query Only no Query Allowed yes Query Length 0 Case Insensitive Query no Insert Allowed yes Update Allowed yes List of Values Validate from List no Editor Visible yes Canvas Tab Page Visual Attribute Group DEFAULT Prompt Id Hint Tooltip

Subelements:

Triggers( 0 )

Item   FIRST  

The first name of the partner.

Item properties Value Item Type Text Item Enabled yes Justification Start Implementation Class Multi-Line no Wrap Style Word Case Restriction Mixed Conceal Data no Keep Cursor Position no Automatic Skip no Popup Menu Keyboard Navigable yes Mouse Navigate yes Data Type Char Maximum Length 36 Initial Value Required yes Format Mask Lowest Allowed Value Highest Allowed Value Copy Value from Item	Item properties Value Synchronize with Item Number of Items Displayed 0 Database Item yes Column Name FIRST Primary Key no Query Only no Query Allowed yes Query Length 0 Case Insensitive Query no Insert Allowed yes Update Allowed yes List of Values Validate from List no Editor Visible yes Canvas MAIN Tab Page Visual Attribute Group DEFAULT Prompt First name Hint Tooltip

Subelements:

Triggers( 0 )

Item   LAST  

The last name of the partner.

Item properties Value Item Type Text Item Enabled yes Justification Start Implementation Class Multi-Line no Wrap Style Word Case Restriction Mixed Conceal Data no Keep Cursor Position no Automatic Skip no Popup Menu Keyboard Navigable yes Mouse Navigate yes Data Type Char Maximum Length 36 Initial Value Required yes Format Mask Lowest Allowed Value Highest Allowed Value Copy Value from Item	Item properties Value Synchronize with Item Number of Items Displayed 0 Database Item yes Column Name LAST Primary Key no Query Only no Query Allowed yes Query Length 0 Case Insensitive Query no Insert Allowed yes Update Allowed yes List of Values Validate from List no Editor Visible yes Canvas MAIN Tab Page Visual Attribute Group DEFAULT Prompt Last name Hint Tooltip

Subelements:

Triggers( 0 )

Item   SEX  

The sex of the partner. Implemented with a combobox.

Item properties Value Item Type List Item Enabled yes List Style Poplist Implementation Class Case Restriction Mixed Popup Menu Keyboard Navigable yes Mouse Navigate yes Data Type Char Maximum Length 1 Initial Value Required yes Copy Value from Item Synchronize with Item Number of Items Displayed 0	Item properties Value Database Item yes Column Name SEX Primary Key no Query Only no Query Allowed yes Insert Allowed yes Update Allowed yes Visible yes Canvas MAIN Tab Page Visual Attribute Group DEFAULT Prompt Sex Hint Tooltip

Subelements:

Triggers( 0 )

Relation   PART_PARTNER_PART_PARTNER_ADDR  

Relation properties Value Relation Type Join Detail Data Block PART_PARTNER_ADDR Join Condition PART_PARTNER_ADDR.PARTNER_ID = PART_PARTNER.ID Delete Record Behavior Cascading	Relation properties Value Prevent Masterless Operations yes Deferred no Automatic Query yes

Data Block   PART_PARTNER_ADDR  

The object is subclassed.

Subelements:

Triggers( 3 ) Items( 6 )

Relations( 0 )

Triggers

Name	Comment
WHEN-NEW-RECORD-INSTANCE
WHEN-NEW-BLOCK-INSTANCE
POST-BLOCK

Items

Name	Comment
ID	The ID of the address item.
PARTNER_ID	The ID of the partner the address belongs to.
ADDR	The street address
CITY	The name of the city.
STATE	The name of the state (US / CAN)
COUNTRY	The name of the country.

Trigger   WHEN-NEW-RECORD-INSTANCE  

The object is subclassed. The subclassing takes effect by the owner's (PART_PARTNER_ADDR) subclassing properties.

Trigger properties Value Trigger Style PL/SQL Fire in Enter-Query Mode yes Execution Hierarchy Override	Trigger properties Value Display in 'Keyboard Help' no 'Keyboard Help' Text

Trigger   WHEN-NEW-BLOCK-INSTANCE  

The object is subclassed. The subclassing takes effect by the owner's (PART_PARTNER_ADDR) subclassing properties.

Trigger properties Value Trigger Style PL/SQL Fire in Enter-Query Mode yes Execution Hierarchy Override	Trigger properties Value Display in 'Keyboard Help' no 'Keyboard Help' Text

Trigger   POST-BLOCK  

The object is subclassed. The subclassing takes effect by the owner's (PART_PARTNER_ADDR) subclassing properties.

Trigger properties Value Trigger Style PL/SQL Fire in Enter-Query Mode yes Execution Hierarchy Override	Trigger properties Value Display in 'Keyboard Help' no 'Keyboard Help' Text

Item   ID  

The ID of the address item. Filled out automatically by the system.

Item properties Value Item Type Text Item Enabled yes Justification Start Implementation Class Multi-Line no Wrap Style Word Case Restriction Mixed Conceal Data no Keep Cursor Position no Automatic Skip no Popup Menu Keyboard Navigable yes Mouse Navigate yes Data Type Number Maximum Length 11 Initial Value :sequence.part_part_addr_id_sq.nextval Required yes Format Mask Lowest Allowed Value Highest Allowed Value Copy Value from Item

Item properties Value Synchronize with Item Number of Items Displayed 0 Database Item yes Column Name ID Primary Key no Query Only no Query Allowed yes Query Length 0 Case Insensitive Query no Insert Allowed yes Update Allowed yes List of Values Validate from List no Editor Visible yes Canvas Tab Page Visual Attribute Group DEFAULT Prompt Id Hint Tooltip

Subelements:

Triggers( 0 )

Item   PARTNER_ID  

The ID of the partner the address belongs to. Filled out automatically by the system.

Item properties Value Item Type Text Item Enabled yes Justification Start Implementation Class Multi-Line no Wrap Style Word Case Restriction Mixed Conceal Data no Keep Cursor Position no Automatic Skip no Popup Menu Keyboard Navigable yes Mouse Navigate yes Data Type Number Maximum Length 11 Initial Value Required no Format Mask Lowest Allowed Value Highest Allowed Value Copy Value from Item PART_PARTNER.ID

Item properties Value Synchronize with Item Number of Items Displayed 0 Database Item yes Column Name PARTNER_ID Primary Key no Query Only no Query Allowed yes Query Length 0 Case Insensitive Query no Insert Allowed yes Update Allowed yes List of Values Validate from List no Editor Visible yes Canvas Tab Page Visual Attribute Group DEFAULT Prompt Partner Id Hint Tooltip

Subelements:

Triggers( 0 )

Item   ADDR  

The street address

Item properties Value Item Type Text Item Enabled yes Justification Start Implementation Class Multi-Line no Wrap Style Word Case Restriction Mixed Conceal Data no Keep Cursor Position no Automatic Skip no Popup Menu Keyboard Navigable yes Mouse Navigate yes Data Type Char Maximum Length 100 Initial Value Required yes Format Mask Lowest Allowed Value Highest Allowed Value Copy Value from Item	Item properties Value Synchronize with Item Number of Items Displayed 0 Database Item yes Column Name ADDR Primary Key no Query Only no Query Allowed yes Query Length 0 Case Insensitive Query no Insert Allowed yes Update Allowed yes List of Values Validate from List no Editor Visible yes Canvas MAIN Tab Page Visual Attribute Group DEFAULT Prompt Addr Hint Tooltip

Subelements:

Triggers( 0 )

Item   CITY  

The name of the city.

Item properties Value Item Type Text Item Enabled yes Justification Start Implementation Class Multi-Line no Wrap Style Word Case Restriction Mixed Conceal Data no Keep Cursor Position no Automatic Skip no Popup Menu Keyboard Navigable yes Mouse Navigate yes Data Type Char Maximum Length 100 Initial Value Required yes Format Mask Lowest Allowed Value Highest Allowed Value Copy Value from Item	Item properties Value Synchronize with Item Number of Items Displayed 0 Database Item yes Column Name CITY Primary Key no Query Only no Query Allowed yes Query Length 0 Case Insensitive Query no Insert Allowed yes Update Allowed yes List of Values Validate from List no Editor Visible yes Canvas MAIN Tab Page Visual Attribute Group DEFAULT Prompt City Hint Tooltip

Subelements:

Triggers( 0 )

Item   STATE  

The name of the state (US / CAN)

Item properties Value Item Type Text Item Enabled yes Justification Start Implementation Class Multi-Line no Wrap Style Word Case Restriction Mixed Conceal Data no Keep Cursor Position no Automatic Skip no Popup Menu Keyboard Navigable yes Mouse Navigate yes Data Type Char Maximum Length 100 Initial Value Required no Format Mask Lowest Allowed Value Highest Allowed Value Copy Value from Item	Item properties Value Synchronize with Item Number of Items Displayed 0 Database Item yes Column Name STATE Primary Key no Query Only no Query Allowed yes Query Length 0 Case Insensitive Query no Insert Allowed yes Update Allowed yes List of Values Validate from List no Editor Visible yes Canvas MAIN Tab Page Visual Attribute Group DEFAULT Prompt State Hint Tooltip

Subelements:

Triggers( 0 )

Item   COUNTRY  

The name of the country.

Item properties Value Item Type Text Item Enabled yes Justification Start Implementation Class Multi-Line no Wrap Style Word Case Restriction Mixed Conceal Data no Keep Cursor Position no Automatic Skip no Popup Menu Keyboard Navigable yes Mouse Navigate yes Data Type Char Maximum Length 100 Initial Value Required yes Format Mask Lowest Allowed Value Highest Allowed Value Copy Value from Item	Item properties Value Synchronize with Item Number of Items Displayed 1 Database Item yes Column Name COUNTRY Primary Key no Query Only no Query Allowed yes Query Length 0 Case Insensitive Query no Insert Allowed yes Update Allowed yes List of Values Validate from List no Editor Visible yes Canvas MAIN Tab Page Visual Attribute Group DEFAULT Prompt Country Hint Tooltip

Subelements:

Triggers( 0 )

Canvas   MAIN  

Subelements:

Tab pages( 0 )

Object Group   OBJECT_GROUP11  

Subelements:

Object Group Children( 1 )

Object Group Children

Name	Comment
PART_PARTNER_ADDR	The referred object is documented here

Program Unit   CHECK_PACKAGE_FAILURE  

Base definition:

PROCEDURE CHECK_PACKAGE_FAILURE

Program Unit   QUERY_MASTER_DETAILS  

Base definition:

PROCEDURE QUERY_MASTER_DETAILS

Arguments:

REL_ID	RELATION
DETAIL	VARCHAR2

Program Unit   CLEAR_ALL_MASTER_DETAILS  

Base definition:

PROCEDURE CLEAR_ALL_MASTER_DETAILS

Window   MAIN