The following lines contain the word 'select', 'insert', 'update' or 'delete':
ACTION: DELETE
GENERATED DATE: 06/11/2008 01:53
DESCRIPTION: CONTINUOUS CALCUATION TRIGGER ON DELETE OF FF_GLOBALS_F
FULL
TRIGGER NAME: FF_GLOBALS_F_ARD
================================================
*/
--
PROCEDURE FF_GLOBALS_F_ARD_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_GLOBAL_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_DATA_TYPE IN VARCHAR2
,P_OLD_EFFECTIVE_END_DATE IN DATE
,P_OLD_EFFECTIVE_START_DATE IN DATE
,P_OLD_GLOBAL_DESCRIPTION IN VARCHAR2
,P_OLD_GLOBAL_NAME IN VARCHAR2
,P_OLD_GLOBAL_VALUE IN VARCHAR2
,P_OLD_LEGISLATION_CODE IN VARCHAR2
,P_OLD_OBJECT_VERSION_NUMBER IN NUMBER
) IS
--
/* LOCAL VARIABLE DECLARATIONS */
L_BUSINESS_GROUP_ID NUMBER;
P_STATEMENT => 'SELECT
'||P_OLD_BUSINESS_GROUP_ID||' FROM SYS.DUAL'
);
ACTION: INSERT
GENERATED DATE: 06/11/2008 01:53
DESCRIPTION: CONTINUOUS CALCUATION TRIGGER ON INSERT OF FF_GLOBALS_F
FULL
TRIGGER NAME: FF_GLOBALS_F_ARI
================================================
*/
--
PROCEDURE FF_GLOBALS_F_ARI_ARI
(
P_NEW_BUSINESS_GROUP_ID IN NUMBER
,P_NEW_DATA_TYPE IN VARCHAR2
,P_NEW_EFFECTIVE_DATE IN DATE
,P_NEW_EFFECTIVE_END_DATE IN DATE
,P_NEW_EFFECTIVE_START_DATE IN DATE
,P_NEW_GLOBAL_DESCRIPTION IN VARCHAR2
,P_NEW_GLOBAL_ID
IN NUMBER
,P_NEW_GLOBAL_NAME IN VARCHAR2
,P_NEW_GLOBAL_VALUE IN VARCHAR2
,P_NEW_LEGISLATION_CODE IN VARCHAR2
,P_NEW_OBJECT_VERSION_NUMBER IN NUMBER
,P_NEW_VALIDATION_END_DATE IN DATE
,P_NEW_VALIDATION_START_DATE IN DATE
) IS
--
/* LOCAL VARIABLE DECLARATIONS */
L_BUSINESS_GROUP_ID NUMBER;
P_STATEMENT => 'SELECT BUSINESS_GROUP_ID FROM FF_GLOBALS_F '||' WHERE GLOBAL_ID = '|| P_NEW_GLOBAL_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: 06/11/2008 01:53
DESCRIPTION: CONTINUOUS CALCUATION TRIGGER ON UPDATE OF FF_GLOBALS_F
FULL
TRIGGER NAME: FF_GLOBALS_F_ARU
================================================
*/
--
PROCEDURE FF_GLOBALS_F_ARU_ARU
(
P_NEW_BUSINESS_GROUP_ID IN NUMBER
,P_NEW_DATA_TYPE IN VARCHAR2
,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_GLOBAL_DESCRIPTION
IN VARCHAR2
,P_NEW_GLOBAL_ID IN NUMBER
,P_NEW_GLOBAL_NAME IN VARCHAR2
,P_NEW_GLOBAL_VALUE IN VARCHAR2
,P_NEW_LEGISLATION_CODE IN VARCHAR2
,P_NEW_OBJECT_VERSION_NUMBER 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_DATA_TYPE
IN VARCHAR2
,P_OLD_EFFECTIVE_END_DATE IN DATE
,P_OLD_EFFECTIVE_START_DATE IN DATE
,P_OLD_GLOBAL_DESCRIPTION IN VARCHAR2
,P_OLD_GLOBAL_NAME IN VARCHAR2
,P_OLD_GLOBAL_VALUE IN VARCHAR2
,P_OLD_LEGISLATION_CODE IN VARCHAR2
,P_OLD_OBJECT_VERSION_NUMBER IN NUMBER
) IS
--
/* LOCAL VARIABLE DECLARATIONS */
L_BUSINESS_GROUP_ID NUMBER;
P_STATEMENT => 'SELECT BUSINESS_GROUP_ID FROM FF_GLOBALS_F WHERE GLOBAL_ID = ' ||P_NEW_GLOBAL_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: FF_GLOBALS_F
Action: INSERT
Generated Date: 06/11/2008 01:53
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_GLOBAL_ID in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_BUSINESS_GROUP_ID in NUMBER
,P_LEGISLATION_CODE
in VARCHAR2
,P_DATA_TYPE in VARCHAR2
,P_GLOBAL_NAME in VARCHAR2
,P_GLOBAL_DESCRIPTION in VARCHAR2
,P_GLOBAL_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');
pay_dyn_triggers.g_dyt_mode := hr_api.g_insert;
hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));
END AFTER_INSERT;
Name: AFTER_UPDATE
Table: FF_GLOBALS_F
Action: UPDATE
Generated Date: 06/11/2008 01:53
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_GLOBAL_ID in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_BUSINESS_GROUP_ID
in NUMBER
,P_LEGISLATION_CODE in VARCHAR2
,P_DATA_TYPE in VARCHAR2
,P_GLOBAL_NAME in VARCHAR2
,P_GLOBAL_DESCRIPTION in VARCHAR2
,P_GLOBAL_VALUE in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_EFFECTIVE_START_DATE_O in DATE
,P_EFFECTIVE_END_DATE_O in DATE
,P_BUSINESS_GROUP_ID_O
in NUMBER
,P_LEGISLATION_CODE_O in VARCHAR2
,P_DATA_TYPE_O in VARCHAR2
,P_GLOBAL_NAME_O in VARCHAR2
,P_GLOBAL_DESCRIPTION_O in VARCHAR2
,P_GLOBAL_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: FF_GLOBALS_F
Action: DELETE
Generated Date: 06/11/2008 01:53
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_GLOBAL_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_BUSINESS_GROUP_ID_O in NUMBER
,P_LEGISLATION_CODE_O in VARCHAR2
,P_DATA_TYPE_O in VARCHAR2
,P_GLOBAL_NAME_O
in VARCHAR2
,P_GLOBAL_DESCRIPTION_O in VARCHAR2
,P_GLOBAL_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_DELETE');
hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));
END AFTER_DELETE;