The following lines contain the word 'select', 'insert', 'update' or 'delete':
ACTION: DELETE
GENERATED DATE: 03/01/2007 23:13
DESCRIPTION: CONTINUOUS CALCUATION TRIGGER ON DELETE
OF PAY_USER_COLUMN_INSTANCES_F
FULL TRIGGER NAME: PAY_USER_COLUMN_INSTANCES_F_ARD
================================================
*/
--
PROCEDURE PAY_USER_COLUMN_INSTANCES__ARD
(
P_NEW_DATETRACK_MODE IN VARCHAR2
,P_NEW_EFFECTIVE_DATE IN DATE
,P_NEW_EFFECTIVE_END_DATE IN DATE
,P_NEW_EFFECTIVE_START_DATE IN DATE
,P_NEW_USER_COLUMN_INSTANCE_ID IN NUMBER
,P_NEW_VALIDATION_END_DATE
IN DATE
,P_NEW_VALIDATION_START_DATE IN DATE
,P_OLD_BUSINESS_GROUP_ID IN NUMBER
,P_OLD_EFFECTIVE_END_DATE IN DATE
,P_OLD_EFFECTIVE_START_DATE IN DATE
,P_OLD_LEGISLATION_CODE
IN VARCHAR2
,P_OLD_OBJECT_VERSION_NUMBER IN NUMBER
,P_OLD_USER_COLUMN_ID IN NUMBER
,P_OLD_USER_ROW_ID IN NUMBER
,P_OLD_VALUE IN VARCHAR2
) IS
--
/* LOCAL VARIABLE DECLARATIONS */
L_BUSINESS_GROUP_ID NUMBER;
P_STATEMENT => 'SELECT BUSINESS_GROUP_ID FROM
PAY_USER_COLUMN_INSTANCES_F '||' WHERE USER_COLUMN_INSTANCE_ID = '|| P_NEW_USER_COLUMN_INSTANCE_ID||' AND TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE'
);
ACTION: INSERT
GENERATED DATE: 03/01/2007 23:13
DESCRIPTION: CONTINUOUS CALCUATION TRIGGER ON INSERT
OF PAY_USER_COLUMN_INSTANCES_F
FULL TRIGGER NAME: PAY_USER_COLUMN_INSTANCES_F_ARI
================================================
*/
--
PROCEDURE PAY_USER_COLUMN_INSTANCES__ARI
(
P_NEW_BUSINESS_GROUP_ID IN NUMBER
,P_NEW_EFFECTIVE_DATE IN DATE
,P_NEW_EFFECTIVE_END_DATE IN DATE
,P_NEW_EFFECTIVE_START_DATE IN DATE
,P_NEW_LEGISLATION_CODE IN VARCHAR2
,P_NEW_OBJECT_VERSION_NUMBER
IN NUMBER
,P_NEW_USER_COLUMN_ID IN NUMBER
,P_NEW_USER_COLUMN_INSTANCE_ID IN NUMBER
,P_NEW_USER_ROW_ID IN NUMBER
,P_NEW_VALIDATION_END_DATE IN DATE
,P_NEW_VALIDATION_START_DATE IN DATE
,P_NEW_VALUE IN VARCHAR2
) IS
--
/* LOCAL VARIABLE DECLARATIONS */
L_BUSINESS_GROUP_ID NUMBER;
P_STATEMENT => 'SELECT BUSINESS_GROUP_ID FROM PAY_USER_COLUMN_INSTANCES_F '||' WHERE USER_COLUMN_INSTANCE_ID = '|| P_NEW_USER_COLUMN_INSTANCE_ID||' AND
TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE'
);
ACTION: UPDATE
GENERATED DATE: 03/01/2007 23:13
DESCRIPTION: CONTINUOUS CALCUATION TRIGGER ON UPDATE
OF PAY_USER_COLUMN_INSTANCES_F
FULL TRIGGER NAME: PAY_USER_COLUMN_INSTANCES_F_ARU
================================================
*/
--
PROCEDURE PAY_USER_COLUMN_INSTANCES__ARU
(
P_NEW_DATETRACK_MODE IN VARCHAR2
,P_NEW_EFFECTIVE_DATE IN DATE
,P_NEW_EFFECTIVE_END_DATE IN DATE
,P_NEW_EFFECTIVE_START_DATE IN DATE
,P_NEW_OBJECT_VERSION_NUMBER IN NUMBER
,P_NEW_USER_COLUMN_INSTANCE_ID
IN NUMBER
,P_NEW_VALIDATION_END_DATE IN DATE
,P_NEW_VALIDATION_START_DATE IN DATE
,P_NEW_VALUE IN VARCHAR2
,P_OLD_BUSINESS_GROUP_ID IN NUMBER
,P_OLD_EFFECTIVE_END_DATE IN DATE
,P_OLD_EFFECTIVE_START_DATE IN DATE
,P_OLD_LEGISLATION_CODE IN VARCHAR2
,P_OLD_OBJECT_VERSION_NUMBER IN NUMBER
,P_OLD_USER_COLUMN_ID
IN NUMBER
,P_OLD_USER_ROW_ID IN NUMBER
,P_OLD_VALUE IN VARCHAR2
) IS
--
/* LOCAL VARIABLE DECLARATIONS */
L_BUSINESS_GROUP_ID NUMBER;
P_STATEMENT => 'SELECT BUSINESS_GROUP_ID FROM PAY_USER_COLUMN_INSTANCES_F '||' WHERE USER_COLUMN_INSTANCE_ID = '|| P_NEW_USER_COLUMN_INSTANCE_ID||' AND
TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||
''',''DD-MON-YYYY'') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE'
);
Name: AFTER_INSERT
Table: PAY_USER_COLUMN_INSTANCES_F
Action: INSERT
Generated Date: 03/01/2007 23:13
Description: Called as part of INSERT process
================================================
*/
--
PROCEDURE AFTER_INSERT
(
P_EFFECTIVE_DATE in DATE
,P_VALIDATION_START_DATE in DATE
,P_VALIDATION_END_DATE in DATE
,P_USER_COLUMN_INSTANCE_ID in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_USER_ROW_ID in NUMBER
,P_USER_COLUMN_ID
in NUMBER
,P_BUSINESS_GROUP_ID in NUMBER
,P_LEGISLATION_CODE in VARCHAR2
,P_VALUE in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
) IS
l_mode
varchar2(80);
hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_INSERT');
hr_api.g_insert;
hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));
END AFTER_INSERT;
Name: AFTER_UPDATE
Table: PAY_USER_COLUMN_INSTANCES_F
Action: UPDATE
Generated Date: 03/01/2007 23:13
Description: Called as part of UPDATE process
================================================
*/
--
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_USER_COLUMN_INSTANCE_ID in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_VALUE
in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_EFFECTIVE_START_DATE_O in DATE
,P_EFFECTIVE_END_DATE_O in DATE
,P_USER_ROW_ID_O in NUMBER
,P_USER_COLUMN_ID_O
in NUMBER
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_LEGISLATION_CODE_O in VARCHAR2
,P_VALUE_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
) IS
l_mode varchar2(80);
hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_UPDATE');
hr_utility.set_location('AFTER_UPDATE',ABS(SQLCODE));
END AFTER_UPDATE;
Name: AFTER_DELETE
Table: PAY_USER_COLUMN_INSTANCES_F
Action: DELETE
Generated Date: 03/01/2007 23:13
Description: Called as part of DELETE process
================================================
*/
--
PROCEDURE AFTER_DELETE
(
P_EFFECTIVE_DATE in DATE
,P_DATETRACK_MODE in VARCHAR2
,P_VALIDATION_START_DATE in DATE
,P_VALIDATION_END_DATE in DATE
,P_USER_COLUMN_INSTANCE_ID in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_EFFECTIVE_START_DATE_O
in DATE
,P_EFFECTIVE_END_DATE_O in DATE
,P_USER_ROW_ID_O in NUMBER
,P_USER_COLUMN_ID_O in NUMBER
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_LEGISLATION_CODE_O
in VARCHAR2
,P_VALUE_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
) IS
l_mode varchar2(80);
AFTER_DELETE');
hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));
END AFTER_DELETE;