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')
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 );
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