eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_OBJ_TRIGGERS_V_PKG dependencies on CN_OBJ_TRIGGERS_V

Line 1: PACKAGE BODY cn_obj_triggers_v_pkg AS

1: PACKAGE BODY cn_obj_triggers_v_pkg AS
2:
3: -- $Header: cnretrgb.pls 115.0 99/07/16 07:15:20 porting ship $
4:
5: --

Line 11: X_trigger_id cn_obj_triggers_v.trigger_id%TYPE,

7: --
8:
9: PROCEDURE insert_row (
10: X_rowid OUT ROWID,
11: X_trigger_id cn_obj_triggers_v.trigger_id%TYPE,
12: X_name cn_obj_triggers_v.name%TYPE,
13: X_description cn_obj_triggers_v.description%TYPE,
14: X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,
15: X_status cn_obj_triggers_v.status%TYPE,

Line 12: X_name cn_obj_triggers_v.name%TYPE,

8:
9: PROCEDURE insert_row (
10: X_rowid OUT ROWID,
11: X_trigger_id cn_obj_triggers_v.trigger_id%TYPE,
12: X_name cn_obj_triggers_v.name%TYPE,
13: X_description cn_obj_triggers_v.description%TYPE,
14: X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,
15: X_status cn_obj_triggers_v.status%TYPE,
16: X_repository_id cn_obj_triggers_v.repository_id%TYPE,

Line 13: X_description cn_obj_triggers_v.description%TYPE,

9: PROCEDURE insert_row (
10: X_rowid OUT ROWID,
11: X_trigger_id cn_obj_triggers_v.trigger_id%TYPE,
12: X_name cn_obj_triggers_v.name%TYPE,
13: X_description cn_obj_triggers_v.description%TYPE,
14: X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,
15: X_status cn_obj_triggers_v.status%TYPE,
16: X_repository_id cn_obj_triggers_v.repository_id%TYPE,
17: X_when_clause cn_obj_triggers_v.when_clause%TYPE,

Line 14: X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,

10: X_rowid OUT ROWID,
11: X_trigger_id cn_obj_triggers_v.trigger_id%TYPE,
12: X_name cn_obj_triggers_v.name%TYPE,
13: X_description cn_obj_triggers_v.description%TYPE,
14: X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,
15: X_status cn_obj_triggers_v.status%TYPE,
16: X_repository_id cn_obj_triggers_v.repository_id%TYPE,
17: X_when_clause cn_obj_triggers_v.when_clause%TYPE,
18: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,

Line 15: X_status cn_obj_triggers_v.status%TYPE,

11: X_trigger_id cn_obj_triggers_v.trigger_id%TYPE,
12: X_name cn_obj_triggers_v.name%TYPE,
13: X_description cn_obj_triggers_v.description%TYPE,
14: X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,
15: X_status cn_obj_triggers_v.status%TYPE,
16: X_repository_id cn_obj_triggers_v.repository_id%TYPE,
17: X_when_clause cn_obj_triggers_v.when_clause%TYPE,
18: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,
19: X_table_id cn_obj_triggers_v.table_id%TYPE,

Line 16: X_repository_id cn_obj_triggers_v.repository_id%TYPE,

12: X_name cn_obj_triggers_v.name%TYPE,
13: X_description cn_obj_triggers_v.description%TYPE,
14: X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,
15: X_status cn_obj_triggers_v.status%TYPE,
16: X_repository_id cn_obj_triggers_v.repository_id%TYPE,
17: X_when_clause cn_obj_triggers_v.when_clause%TYPE,
18: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,
19: X_table_id cn_obj_triggers_v.table_id%TYPE,
20: X_event_id cn_obj_triggers_v.event_id%TYPE,

Line 17: X_when_clause cn_obj_triggers_v.when_clause%TYPE,

13: X_description cn_obj_triggers_v.description%TYPE,
14: X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,
15: X_status cn_obj_triggers_v.status%TYPE,
16: X_repository_id cn_obj_triggers_v.repository_id%TYPE,
17: X_when_clause cn_obj_triggers_v.when_clause%TYPE,
18: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,
19: X_table_id cn_obj_triggers_v.table_id%TYPE,
20: X_event_id cn_obj_triggers_v.event_id%TYPE,
21: X_for_each_row cn_obj_triggers_v.for_each_row%TYPE,

Line 18: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,

14: X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,
15: X_status cn_obj_triggers_v.status%TYPE,
16: X_repository_id cn_obj_triggers_v.repository_id%TYPE,
17: X_when_clause cn_obj_triggers_v.when_clause%TYPE,
18: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,
19: X_table_id cn_obj_triggers_v.table_id%TYPE,
20: X_event_id cn_obj_triggers_v.event_id%TYPE,
21: X_for_each_row cn_obj_triggers_v.for_each_row%TYPE,
22: X_trigger_type cn_obj_triggers_v.trigger_type%TYPE,

Line 19: X_table_id cn_obj_triggers_v.table_id%TYPE,

15: X_status cn_obj_triggers_v.status%TYPE,
16: X_repository_id cn_obj_triggers_v.repository_id%TYPE,
17: X_when_clause cn_obj_triggers_v.when_clause%TYPE,
18: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,
19: X_table_id cn_obj_triggers_v.table_id%TYPE,
20: X_event_id cn_obj_triggers_v.event_id%TYPE,
21: X_for_each_row cn_obj_triggers_v.for_each_row%TYPE,
22: X_trigger_type cn_obj_triggers_v.trigger_type%TYPE,
23: X_seed_trigger_id cn_obj_triggers_v.seed_trigger_id%TYPE) IS

Line 20: X_event_id cn_obj_triggers_v.event_id%TYPE,

16: X_repository_id cn_obj_triggers_v.repository_id%TYPE,
17: X_when_clause cn_obj_triggers_v.when_clause%TYPE,
18: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,
19: X_table_id cn_obj_triggers_v.table_id%TYPE,
20: X_event_id cn_obj_triggers_v.event_id%TYPE,
21: X_for_each_row cn_obj_triggers_v.for_each_row%TYPE,
22: X_trigger_type cn_obj_triggers_v.trigger_type%TYPE,
23: X_seed_trigger_id cn_obj_triggers_v.seed_trigger_id%TYPE) IS
24:

Line 21: X_for_each_row cn_obj_triggers_v.for_each_row%TYPE,

17: X_when_clause cn_obj_triggers_v.when_clause%TYPE,
18: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,
19: X_table_id cn_obj_triggers_v.table_id%TYPE,
20: X_event_id cn_obj_triggers_v.event_id%TYPE,
21: X_for_each_row cn_obj_triggers_v.for_each_row%TYPE,
22: X_trigger_type cn_obj_triggers_v.trigger_type%TYPE,
23: X_seed_trigger_id cn_obj_triggers_v.seed_trigger_id%TYPE) IS
24:
25: X_primary_key cn_obj_triggers_v.trigger_id%TYPE;

Line 22: X_trigger_type cn_obj_triggers_v.trigger_type%TYPE,

18: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,
19: X_table_id cn_obj_triggers_v.table_id%TYPE,
20: X_event_id cn_obj_triggers_v.event_id%TYPE,
21: X_for_each_row cn_obj_triggers_v.for_each_row%TYPE,
22: X_trigger_type cn_obj_triggers_v.trigger_type%TYPE,
23: X_seed_trigger_id cn_obj_triggers_v.seed_trigger_id%TYPE) IS
24:
25: X_primary_key cn_obj_triggers_v.trigger_id%TYPE;
26: BEGIN

Line 23: X_seed_trigger_id cn_obj_triggers_v.seed_trigger_id%TYPE) IS

19: X_table_id cn_obj_triggers_v.table_id%TYPE,
20: X_event_id cn_obj_triggers_v.event_id%TYPE,
21: X_for_each_row cn_obj_triggers_v.for_each_row%TYPE,
22: X_trigger_type cn_obj_triggers_v.trigger_type%TYPE,
23: X_seed_trigger_id cn_obj_triggers_v.seed_trigger_id%TYPE) IS
24:
25: X_primary_key cn_obj_triggers_v.trigger_id%TYPE;
26: BEGIN
27:

Line 25: X_primary_key cn_obj_triggers_v.trigger_id%TYPE;

21: X_for_each_row cn_obj_triggers_v.for_each_row%TYPE,
22: X_trigger_type cn_obj_triggers_v.trigger_type%TYPE,
23: X_seed_trigger_id cn_obj_triggers_v.seed_trigger_id%TYPE) IS
24:
25: X_primary_key cn_obj_triggers_v.trigger_id%TYPE;
26: BEGIN
27:
28: X_primary_key := X_trigger_id;
29: IF (X_primary_key IS NULL) THEN

Line 35: INSERT INTO cn_obj_triggers_v (

31: INTO X_primary_key
32: FROM dual;
33: END IF;
34:
35: INSERT INTO cn_obj_triggers_v (
36: trigger_id,
37: name,
38: description,
39: dependency_map_complete,

Line 68: FROM cn_obj_triggers_v

64: X_seed_trigger_id);
65:
66: SELECT ROWID
67: INTO X_rowid
68: FROM cn_obj_triggers_v
69: WHERE trigger_id = X_primary_key;
70:
71: IF (SQL%NOTFOUND) THEN
72: RAISE NO_DATA_FOUND;

Line 79: row IN OUT cn_obj_triggers_v%ROWTYPE) IS

75: END insert_row;
76:
77:
78: PROCEDURE select_row (
79: row IN OUT cn_obj_triggers_v%ROWTYPE) IS
80:
81: BEGIN
82:
83: IF (row.trigger_id IS NOT NULL) THEN

Line 85: FROM cn_obj_triggers_v

81: BEGIN
82:
83: IF (row.trigger_id IS NOT NULL) THEN
84: SELECT * INTO row
85: FROM cn_obj_triggers_v
86: WHERE cn_obj_triggers_v.trigger_id = row.trigger_id;
87: END IF;
88:
89: END select_row;

Line 86: WHERE cn_obj_triggers_v.trigger_id = row.trigger_id;

82:
83: IF (row.trigger_id IS NOT NULL) THEN
84: SELECT * INTO row
85: FROM cn_obj_triggers_v
86: WHERE cn_obj_triggers_v.trigger_id = row.trigger_id;
87: END IF;
88:
89: END select_row;
90:

Line 92: END cn_obj_triggers_v_pkg;

88:
89: END select_row;
90:
91:
92: END cn_obj_triggers_v_pkg;