DBA Data[Home] [Help]

APPS.IGS_GE_MNT_SDTT dependencies on IGS_GE_S_DSB_TAB_TRG

Line 17: SELECT ROWID , IGS_GE_S_DSB_TAB_TRG.*

13:
14: --- Delete a record from the s_disable_table_trigger
15: --- database table.
16: CURSOR CUR_DISB_TAB_TRG IS
17: SELECT ROWID , IGS_GE_S_DSB_TAB_TRG.*
18: FROM IGS_GE_S_DSB_TAB_TRG
19: WHERE table_name = p_table_name AND
20: session_id = (
21: SELECT userenv('SESSIONID')

Line 18: FROM IGS_GE_S_DSB_TAB_TRG

14: --- Delete a record from the s_disable_table_trigger
15: --- database table.
16: CURSOR CUR_DISB_TAB_TRG IS
17: SELECT ROWID , IGS_GE_S_DSB_TAB_TRG.*
18: FROM IGS_GE_S_DSB_TAB_TRG
19: WHERE table_name = p_table_name AND
20: session_id = (
21: SELECT userenv('SESSIONID')
22: FROM dual );

Line 25: IGS_GE_S_DSB_TAB_TRG_PKG.DELETE_ROW(X_ROWID => DISB_TAB_TRG_REC.ROWID );

21: SELECT userenv('SESSIONID')
22: FROM dual );
23: BEGIN
24: for DISB_TAB_TRG_REC IN CUR_DISB_TAB_TRG loop
25: IGS_GE_S_DSB_TAB_TRG_PKG.DELETE_ROW(X_ROWID => DISB_TAB_TRG_REC.ROWID );
26: end loop;
27: END;
28: EXCEPTION
29: WHEN OTHERS THEN