DBA Data[Home] [Help]

APPS.CN_OBJ_TRIGGERS_V_PKG dependencies on CN_OBJ_TRIGGERS_V

Line 1: PACKAGE cn_obj_triggers_v_pkg AUTHID CURRENT_USER AS

1: PACKAGE cn_obj_triggers_v_pkg AUTHID CURRENT_USER AS
2:
3: -- $Header: cnretrgs.pls 115.0 99/07/16 07:15:23 porting ship $
4:
5: --

Line 21: X_trigger_id cn_obj_triggers_v.trigger_id%TYPE,

17: -- 16-FEB-94 Devesh Khatu Modified
18: --
19: PROCEDURE insert_row (
20: X_rowid OUT ROWID,
21: X_trigger_id cn_obj_triggers_v.trigger_id%TYPE,
22: X_name cn_obj_triggers_v.name%TYPE,
23: X_description cn_obj_triggers_v.description%TYPE,
24: X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,
25: X_status cn_obj_triggers_v.status%TYPE,

Line 22: X_name cn_obj_triggers_v.name%TYPE,

18: --
19: PROCEDURE insert_row (
20: X_rowid OUT ROWID,
21: X_trigger_id cn_obj_triggers_v.trigger_id%TYPE,
22: X_name cn_obj_triggers_v.name%TYPE,
23: X_description cn_obj_triggers_v.description%TYPE,
24: X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,
25: X_status cn_obj_triggers_v.status%TYPE,
26: X_repository_id cn_obj_triggers_v.repository_id%TYPE,

Line 23: X_description cn_obj_triggers_v.description%TYPE,

19: PROCEDURE insert_row (
20: X_rowid OUT ROWID,
21: X_trigger_id cn_obj_triggers_v.trigger_id%TYPE,
22: X_name cn_obj_triggers_v.name%TYPE,
23: X_description cn_obj_triggers_v.description%TYPE,
24: X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,
25: X_status cn_obj_triggers_v.status%TYPE,
26: X_repository_id cn_obj_triggers_v.repository_id%TYPE,
27: X_when_clause cn_obj_triggers_v.when_clause%TYPE,

Line 24: X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,

20: X_rowid OUT ROWID,
21: X_trigger_id cn_obj_triggers_v.trigger_id%TYPE,
22: X_name cn_obj_triggers_v.name%TYPE,
23: X_description cn_obj_triggers_v.description%TYPE,
24: X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,
25: X_status cn_obj_triggers_v.status%TYPE,
26: X_repository_id cn_obj_triggers_v.repository_id%TYPE,
27: X_when_clause cn_obj_triggers_v.when_clause%TYPE,
28: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,

Line 25: X_status cn_obj_triggers_v.status%TYPE,

21: X_trigger_id cn_obj_triggers_v.trigger_id%TYPE,
22: X_name cn_obj_triggers_v.name%TYPE,
23: X_description cn_obj_triggers_v.description%TYPE,
24: X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,
25: X_status cn_obj_triggers_v.status%TYPE,
26: X_repository_id cn_obj_triggers_v.repository_id%TYPE,
27: X_when_clause cn_obj_triggers_v.when_clause%TYPE,
28: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,
29: X_table_id cn_obj_triggers_v.table_id%TYPE,

Line 26: X_repository_id cn_obj_triggers_v.repository_id%TYPE,

22: X_name cn_obj_triggers_v.name%TYPE,
23: X_description cn_obj_triggers_v.description%TYPE,
24: X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,
25: X_status cn_obj_triggers_v.status%TYPE,
26: X_repository_id cn_obj_triggers_v.repository_id%TYPE,
27: X_when_clause cn_obj_triggers_v.when_clause%TYPE,
28: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,
29: X_table_id cn_obj_triggers_v.table_id%TYPE,
30: X_event_id cn_obj_triggers_v.event_id%TYPE,

Line 27: X_when_clause cn_obj_triggers_v.when_clause%TYPE,

23: X_description cn_obj_triggers_v.description%TYPE,
24: X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,
25: X_status cn_obj_triggers_v.status%TYPE,
26: X_repository_id cn_obj_triggers_v.repository_id%TYPE,
27: X_when_clause cn_obj_triggers_v.when_clause%TYPE,
28: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,
29: X_table_id cn_obj_triggers_v.table_id%TYPE,
30: X_event_id cn_obj_triggers_v.event_id%TYPE,
31: X_for_each_row cn_obj_triggers_v.for_each_row%TYPE,

Line 28: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,

24: X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,
25: X_status cn_obj_triggers_v.status%TYPE,
26: X_repository_id cn_obj_triggers_v.repository_id%TYPE,
27: X_when_clause cn_obj_triggers_v.when_clause%TYPE,
28: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,
29: X_table_id cn_obj_triggers_v.table_id%TYPE,
30: X_event_id cn_obj_triggers_v.event_id%TYPE,
31: X_for_each_row cn_obj_triggers_v.for_each_row%TYPE,
32: X_trigger_type cn_obj_triggers_v.trigger_type%TYPE,

Line 29: X_table_id cn_obj_triggers_v.table_id%TYPE,

25: X_status cn_obj_triggers_v.status%TYPE,
26: X_repository_id cn_obj_triggers_v.repository_id%TYPE,
27: X_when_clause cn_obj_triggers_v.when_clause%TYPE,
28: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,
29: X_table_id cn_obj_triggers_v.table_id%TYPE,
30: X_event_id cn_obj_triggers_v.event_id%TYPE,
31: X_for_each_row cn_obj_triggers_v.for_each_row%TYPE,
32: X_trigger_type cn_obj_triggers_v.trigger_type%TYPE,
33: X_seed_trigger_id cn_obj_triggers_v.seed_trigger_id%TYPE);

Line 30: X_event_id cn_obj_triggers_v.event_id%TYPE,

26: X_repository_id cn_obj_triggers_v.repository_id%TYPE,
27: X_when_clause cn_obj_triggers_v.when_clause%TYPE,
28: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,
29: X_table_id cn_obj_triggers_v.table_id%TYPE,
30: X_event_id cn_obj_triggers_v.event_id%TYPE,
31: X_for_each_row cn_obj_triggers_v.for_each_row%TYPE,
32: X_trigger_type cn_obj_triggers_v.trigger_type%TYPE,
33: X_seed_trigger_id cn_obj_triggers_v.seed_trigger_id%TYPE);
34:

Line 31: X_for_each_row cn_obj_triggers_v.for_each_row%TYPE,

27: X_when_clause cn_obj_triggers_v.when_clause%TYPE,
28: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,
29: X_table_id cn_obj_triggers_v.table_id%TYPE,
30: X_event_id cn_obj_triggers_v.event_id%TYPE,
31: X_for_each_row cn_obj_triggers_v.for_each_row%TYPE,
32: X_trigger_type cn_obj_triggers_v.trigger_type%TYPE,
33: X_seed_trigger_id cn_obj_triggers_v.seed_trigger_id%TYPE);
34:
35: --

Line 32: X_trigger_type cn_obj_triggers_v.trigger_type%TYPE,

28: X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,
29: X_table_id cn_obj_triggers_v.table_id%TYPE,
30: X_event_id cn_obj_triggers_v.event_id%TYPE,
31: X_for_each_row cn_obj_triggers_v.for_each_row%TYPE,
32: X_trigger_type cn_obj_triggers_v.trigger_type%TYPE,
33: X_seed_trigger_id cn_obj_triggers_v.seed_trigger_id%TYPE);
34:
35: --
36: -- Procedure Name

Line 33: X_seed_trigger_id cn_obj_triggers_v.seed_trigger_id%TYPE);

29: X_table_id cn_obj_triggers_v.table_id%TYPE,
30: X_event_id cn_obj_triggers_v.event_id%TYPE,
31: X_for_each_row cn_obj_triggers_v.for_each_row%TYPE,
32: X_trigger_type cn_obj_triggers_v.trigger_type%TYPE,
33: X_seed_trigger_id cn_obj_triggers_v.seed_trigger_id%TYPE);
34:
35: --
36: -- Procedure Name
37: -- select_row

Line 43: PROCEDURE select_row (row IN OUT cn_obj_triggers_v%ROWTYPE);

39: -- Select a row from the table, given the primary key
40: -- History
41: -- 12/15/93 Devesh Khatu Created
42: --
43: PROCEDURE select_row (row IN OUT cn_obj_triggers_v%ROWTYPE);
44:
45:
46: END cn_obj_triggers_v_pkg;

Line 46: END cn_obj_triggers_v_pkg;

42: --
43: PROCEDURE select_row (row IN OUT cn_obj_triggers_v%ROWTYPE);
44:
45:
46: END cn_obj_triggers_v_pkg;