DBA Data[Home] [Help]

APPS.SET_HXT_BATCH_STATES_INS dependencies on HR_GENERAL

Line 4: if hr_general.g_data_migrator_mode <> 'Y' then

1: TRIGGER "APPS"."SET_HXT_BATCH_STATES_INS" AFTER INSERT
2: ON "APPS"."PAY_BATCH_HEADERS" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN
3:
4: if hr_general.g_data_migrator_mode <> 'Y' then
5: INSERT INTO HXT_BATCH_STATES(BATCH_ID, STATUS)
6: VALUES( :NEW.BATCH_ID, 'H');
7: --END GLOBAL
8: end if;

Line 15: if hr_general.g_data_migrator_mode <> 'Y' then

11: DECLARE
12: v_error VARCHAR2(300) := SQLERRM;
13: l_EXCEP_seqno NUMBER; --- the next sequence number for new error record
14: BEGIN
15: if hr_general.g_data_migrator_mode <> 'Y' then
16: SELECT hxt_seqno.nextval
17: INTO l_EXCEP_seqno
18: FROM dual;
19:

Line 36: hr_general.start_of_time,

32: ORA_MESSAGE,
33: PPB_ID)
34: VALUES(
35: l_EXCEP_seqno,
36: hr_general.start_of_time,
37: hr_general.end_of_time,
38: 'Could not insert into HXT_BATCH_STATES. Sqlerror = '||v_error,
39: sysdate,
40: 'HXT_BATCH_STATES_INS trigger',

Line 37: hr_general.end_of_time,

33: PPB_ID)
34: VALUES(
35: l_EXCEP_seqno,
36: hr_general.start_of_time,
37: hr_general.end_of_time,
38: 'Could not insert into HXT_BATCH_STATES. Sqlerror = '||v_error,
39: sysdate,
40: 'HXT_BATCH_STATES_INS trigger',
41: 1,