APPS.CNREDF_EVENT_TRIG_PKG dependencies on CN_OBJ_TRIGGERS_V

Line 19: FROM cn_obj_triggers_v trg,

15: BEGIN
16:
17: SELECT trg.name, tab.name
18: INTO X_trigger_name, X_table_name
19: FROM cn_obj_triggers_v trg,
20: cn_obj_tables_v tab
21: WHERE trg.trigger_id = X_trigger_id
22: AND tab.table_id = trg.table_id;
23:

Line 38: UPDATE cn_obj_triggers_v

34: PROCEDURE delete_row (X_trigger_ID number) IS
35:
36: BEGIN
37:
38: UPDATE cn_obj_triggers_v
39: SET event_id = NULL
40: WHERE trigger_id = X_trigger_id;
41:
42: END delete_row;

Line 49: UPDATE cn_obj_triggers_v

45: X_event_id number) IS
46:
47: BEGIN
48:
49: UPDATE cn_obj_triggers_v
50: SET event_id = X_event_id
51: WHERE trigger_id = X_trigger_id;
52:
53: END Insert_Row;

Line 71: FROM cn_obj_triggers_v

67: BEGIN
68:
69: SELECT trigger_id
70: INTO Dumy
71: FROM cn_obj_triggers_v
72: WHERE trigger_id = X_trigger_ID
73: FOR UPDATE OF cn_obj_triggers_v.event_id;
74:
75: END Lock_Row;

Line 73: FOR UPDATE OF cn_obj_triggers_v.event_id;

69: SELECT trigger_id
70: INTO Dumy
71: FROM cn_obj_triggers_v
72: WHERE trigger_id = X_trigger_ID
73: FOR UPDATE OF cn_obj_triggers_v.event_id;
74:
75: END Lock_Row;
76:
77:

Line 92: FROM cn_obj_triggers_v trg,

88: BEGIN
89:
90: SELECT trg.table_id, tab.name
91: INTO X_table_id, X_table_name
92: FROM cn_obj_triggers_v trg,
93: cn_obj_tables_v tab
94: WHERE trg.trigger_id = X_trigger_id
95: AND tab.table_id = trg.table_id;
96: