DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.HR_TEMPLATE_ITEMS

Object Details
Object Name: HR_TEMPLATE_ITEMS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_TEMPLATE_ITEMS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID.
TEMPLATE_ITEM_ID NUMBER (15) Yes System-generated primary key using sequence HR_TEMPLATE_ITEMS_B_S.
OBJECT_VERSION_NUMBER NUMBER (9) Yes System-generated version of row. Increments by one with each update.
FORM_TEMPLATE_ID NUMBER (15) Yes Foreign key to HR_FORM_TEMPLATES_B.FORM_TEMPLATE_ID.
FORM_ITEM_ID NUMBER (15) Yes Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The form item must be associated with the same form as the template.
ALIGNMENT NUMBER (10)
The text alignment. Valid values are ALIGNMENT_START, ALIGNMENT_END, ALIGNMENT_LEFT, ALIGNMENT_ CENTER, ALIGNMENT_RIGHT. Applies to display item or text item.
BEVEL NUMBER (10)
The item border bevel. Valid values are RAISED, LOWERED or PLAIN. Applies to chart item, image item, custom item or text item.
CASE_RESTRICTION NUMBER (10)
Specifies the case restriction applied to any text entered in the indicated text item. Valid values are UPPERCASE, LOWERCASE, or NONE. Applies to text item.
DEFAULT_VALUE VARCHAR2 (2000)
Specifies the default value for the item. If for a number or date item it must be in the canonical format.
ENABLED NUMBER (10)
Specifies whether end users should be able to manipulate an item. Valid values are PROPERTY_TRUE and PROPERTY_FALSE. Does not apply to button, chart item or display item.
FORMAT_MASK VARCHAR2 (80)
Specifies the display format and input accepted. Applies to text item.
HEIGHT NUMBER (12)
Specifies the height of the item.
INFORMATION_FORMULA_ID NUMBER (15)
Foreign key to FF_FORMULAS.F_FORMULA_ID. Specifies the identifier of the formula to use to supply extra information about the item. The formula will return a text string which will be displayed to the user. Does not apply to button.
INFORMATION_PARAMETER_ITEM_ID1 NUMBER (15)
Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The second parameter to pass to the information formula. Applies only when an information formula has been specified.
INFORMATION_PARAMETER_ITEM_ID2 NUMBER (15)
Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The third parameter to pass to the information formula. Applies only when an information formula has been specified.
INFORMATION_PARAMETER_ITEM_ID3 NUMBER (15)
Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The fourth parameter to pass to the information formula. Applies only when an informationn formula has been specified.
INFORMATION_PARAMETER_ITEM_ID4 NUMBER (15)
Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The fifth parameter to pass to the information formula. Applies only when an information formula has been specified.
INFORMATION_PARAMETER_ITEM_ID5 NUMBER (15)
Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The sixth parameter to pass to the information formula. Applies only when an information formula has been specified.
INFORMATION_PROMPT VARCHAR2 (80)
Specifies the text to show in the popup-menu to initiate the information formula. Applies only when an information formula is specified. Must be given in this case.
INSERT_ALLOWED NUMBER (10)
In a new record, allows end user to insert items normally when set to PROPERTY_TRUE. Specify PROPERTY_FALSE to specify that the item does not accept modification, but is displayed normally. Applies to check box, custom item, image item, radio button, list item or text item.
LABEL VARCHAR2 (80)
Specifies the VARCHAR2 string that you want displayed as the label of the item. Applies to button, check box or radio group button.
PROMPT_ALIGNMENT_OFFSET NUMBER (12)
Determines the distance between the item and its prompt.
PROMPT_DISPLAY_STYLE NUMBER (10)
Determines the prompt's display style, either PROMPT_FIRST_RECORD, PROMPT_HIDDEN or PROMPT_ALL_RECORDS.
PROMPT_EDGE NUMBER (10)
Determines to which edge the prompt is attached. May be START_EDGE, END_EDGE, TOP_EDGE or BOTTOM_EDGE.
PROMPT_EDGE_ALIGNMENT NUMBER (10)
Determines to which edge the items prompt is aligned. May be ALIGNMENT_START, ALIGNMENT_END or ALIGNMENT_CENTER.
PROMPT_EDGE_OFFSET NUMBER (12)
Determines the distance between the item and its prompt.
PROMPT_TEXT VARCHAR2 (80)
Determines the text label that displays for an item.
PROMPT_TEXT_ALIGNMENT NUMBER (10)
Determines how the prompt is justified. May be ALIGNMENT_START, ALIGNMENT_LEFT, ALIGNMENT_RIGHT, ALIGNMENT_CENTER or ALIGNMENT_END.
QUERY_ALLOWED NUMBER (10)
Specify the constant PROPERTY_TRUE if you want the end user to be able to initiate a query against the item. Specify the constant PROPERTY_FALSE if you want to disallow the use of the item in a query. Does not apply to button, chart item or image item.
REQUIRED NUMBER (10)
Specify the constant PROPERTY_TRUE if you want to force the end user to enter a value for the item. Specify the constant PROPERTY_FALSE if the item is not to be required. Applies to list item or text item.
TOOLTIP_TEXT VARCHAR2 (80)
Determines the ballon text for an item.
UPDATE_ALLOWED NUMBER (10)
Specify the constant PROPERTY_TRUE if you want the end user to be able to update the item. Specify the constant PROPERTY_FALSE if you want the item protected from update. Does not apply to button, chart item or image item.
VALIDATION_FORMULA_ID NUMBER (15)
Foreign key to FF_FORMULAS_F.FORMULA_ID. Specifies the identifier of the formula to use to augment the default validation of the item. This first parameter to the formula will always be the item it is associated with. Does not apply to button, chart item or image item.
VALIDATION_PARAMETER_ITEM_ID1 NUMBER (15)
Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The second parameter to pass to the validation formula. Applies only when a validation formula has been specified.
VALIDATION_PARAMETER_ITEM_ID2 NUMBER (15)
Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The third parameter to pass to the validation formula. Applies only when a validation formula has been specified.
VALIDATION_PARAMETER_ITEM_ID3 NUMBER (15)
Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The fourth parameter to pass to the validation formula. Applies only when a validation formula has been specified.
VALIDATION_PARAMETER_ITEM_ID4 NUMBER (15)
Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The fifth parameter to pass to the validation formula. Applies only when a validation formula has been specified.
VALIDATION_PARAMETER_ITEM_ID5 NUMBER (15)
Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The sixth parameter to pass to the validation formula. Applies only when a validation formula has been specified.
VISIBLE NUMBER (10)
Specifies whether the indicated item should be visible or hidden. Valid values are PROPERTY_TRUE and PROPERTY_FALSE.
WIDTH NUMBER (12)
Specifies the width of the item.
X_POSITION NUMBER (12)
Specifies the x coordinate of the item.
Y_POSITION NUMBER (12)
Specifies the y coordinate of the item.
INFORMATION_CATEGORY VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION1 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION2 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION3 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION4 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION5 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION6 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION7 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION8 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION9 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION10 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION11 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION12 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION13 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION14 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION15 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION16 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION17 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION18 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION19 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION20 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION21 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION22 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION23 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION24 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION25 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION26 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION27 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION28 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION29 VARCHAR2 (150)
Developer Descriptive Flexfield column.
INFORMATION30 VARCHAR2 (150)
Developer Descriptive Flexfield column.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
NEXT_NAVIGATION_ITEM_ID NUMBER (15)
Foreign key to HR_TEMPLATE_ITEMS_B.
PREVIOUS_NAVIGATION_ITEM_ID NUMBER (15)
Foreign key to HR_TEMPLATE_ITEMS_B.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      TEMPLATE_ITEM_ID
,      OBJECT_VERSION_NUMBER
,      FORM_TEMPLATE_ID
,      FORM_ITEM_ID
,      ALIGNMENT
,      BEVEL
,      CASE_RESTRICTION
,      DEFAULT_VALUE
,      ENABLED
,      FORMAT_MASK
,      HEIGHT
,      INFORMATION_FORMULA_ID
,      INFORMATION_PARAMETER_ITEM_ID1
,      INFORMATION_PARAMETER_ITEM_ID2
,      INFORMATION_PARAMETER_ITEM_ID3
,      INFORMATION_PARAMETER_ITEM_ID4
,      INFORMATION_PARAMETER_ITEM_ID5
,      INFORMATION_PROMPT
,      INSERT_ALLOWED
,      LABEL
,      PROMPT_ALIGNMENT_OFFSET
,      PROMPT_DISPLAY_STYLE
,      PROMPT_EDGE
,      PROMPT_EDGE_ALIGNMENT
,      PROMPT_EDGE_OFFSET
,      PROMPT_TEXT
,      PROMPT_TEXT_ALIGNMENT
,      QUERY_ALLOWED
,      REQUIRED
,      TOOLTIP_TEXT
,      UPDATE_ALLOWED
,      VALIDATION_FORMULA_ID
,      VALIDATION_PARAMETER_ITEM_ID1
,      VALIDATION_PARAMETER_ITEM_ID2
,      VALIDATION_PARAMETER_ITEM_ID3
,      VALIDATION_PARAMETER_ITEM_ID4
,      VALIDATION_PARAMETER_ITEM_ID5
,      VISIBLE
,      WIDTH
,      X_POSITION
,      Y_POSITION
,      INFORMATION_CATEGORY
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      INFORMATION21
,      INFORMATION22
,      INFORMATION23
,      INFORMATION24
,      INFORMATION25
,      INFORMATION26
,      INFORMATION27
,      INFORMATION28
,      INFORMATION29
,      INFORMATION30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      NEXT_NAVIGATION_ITEM_ID
,      PREVIOUS_NAVIGATION_ITEM_ID
FROM APPS.HR_TEMPLATE_ITEMS;

Dependencies

[top of page]

APPS.HR_TEMPLATE_ITEMS references the following:

SchemaAPPS
ViewHR_ITEM_PROPERTIES_VL
SynonymHR_TEMPLATE_ITEMS_B
APPS.HR_TEMPLATE_ITEMS is referenced by following:

SchemaAPPS
Package BodyHR_FORM_TEMPLATES_API - show dependent code
Package BodyHR_ITEM_PROPERTIES_BSI - show dependent code
Package BodyHR_TEMPLATE_DATA_GROUPS_API - show dependent code
Package BodyHR_TEMPLATE_ITEMS_API - show dependent code
Package BodyHR_TEMPLATE_ITEM_CONTEXTS_API - show dependent code