eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IVL_RKU SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5


procedure AFTER_UPDATE
(P_EFFECTIVE_DATE in DATE
,P_DATETRACK_MODE in VARCHAR2
,P_VALIDATION_START_DATE in DATE
,P_VALIDATION_END_DATE in DATE
,P_INPUT_VALUE_ID in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_ELEMENT_TYPE_ID in NUMBER
,P_LOOKUP_TYPE in VARCHAR2
,P_BUSINESS_GROUP_ID in NUMBER
,P_LEGISLATION_CODE in VARCHAR2
,P_FORMULA_ID in NUMBER
,P_VALUE_SET_ID in NUMBER
,P_DISPLAY_SEQUENCE in NUMBER
,P_GENERATE_DB_ITEMS_FLAG in VARCHAR2
,P_HOT_DEFAULT_FLAG in VARCHAR2
,P_MANDATORY_FLAG in VARCHAR2
,P_NAME in VARCHAR2
,P_UOM in VARCHAR2
,P_DEFAULT_VALUE in VARCHAR2
,P_LEGISLATION_SUBGROUP in VARCHAR2
,P_MAX_VALUE in VARCHAR2
,P_MIN_VALUE in VARCHAR2
,P_WARNING_OR_ERROR in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_EFFECTIVE_START_DATE_O in DATE
,P_EFFECTIVE_END_DATE_O in DATE
,P_ELEMENT_TYPE_ID_O in NUMBER
,P_LOOKUP_TYPE_O in VARCHAR2
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_LEGISLATION_CODE_O in VARCHAR2
,P_FORMULA_ID_O in NUMBER
,P_VALUE_SET_ID_O in NUMBER
,P_DISPLAY_SEQUENCE_O in NUMBER
,P_GENERATE_DB_ITEMS_FLAG_O in VARCHAR2
,P_HOT_DEFAULT_FLAG_O in VARCHAR2
,P_MANDATORY_FLAG_O in VARCHAR2
,P_NAME_O in VARCHAR2
,P_UOM_O in VARCHAR2
,P_DEFAULT_VALUE_O in VARCHAR2
,P_LEGISLATION_SUBGROUP_O in VARCHAR2
,P_MAX_VALUE_O in VARCHAR2
,P_MIN_VALUE_O in VARCHAR2
,P_WARNING_OR_ERROR_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
)is
begin
hr_utility.set_location('Entering: PAY_IVL_RKU.AFTER_UPDATE', 10);

Line: 54


hr_utility.set_location(' Leaving: PAY_IVL_RKU.AFTER_UPDATE', 20);

Line: 55


end AFTER_UPDATE;