APPS.CN_TABLE_MAPS_PKG dependencies on CN_TABLE_MAPS

Line 1: PACKAGE CN_TABLE_MAPS_PKG AUTHID CURRENT_USER AS

1: PACKAGE CN_TABLE_MAPS_PKG AUTHID CURRENT_USER AS
2: -- $Header: cncotms.pls 120.4 2005/10/24 00:44:50 apink noship $
3: --
4: -- Public Procedures
5: --

Line 14: X_table_map_id IN OUT NOCOPY cn_table_maps.table_map_id%TYPE,

10: -- Insert a new record in the table.
11: --
12: PROCEDURE insert_row (
13: X_rowid OUT NOCOPY ROWID,
14: X_table_map_id IN OUT NOCOPY cn_table_maps.table_map_id%TYPE,
15: X_mapping_type cn_table_maps.mapping_type%TYPE,
16: X_module_id cn_table_maps.module_id%TYPE,
17: X_source_table_id cn_table_maps.source_table_id%TYPE,
18: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,

Line 15: X_mapping_type cn_table_maps.mapping_type%TYPE,

11: --
12: PROCEDURE insert_row (
13: X_rowid OUT NOCOPY ROWID,
14: X_table_map_id IN OUT NOCOPY cn_table_maps.table_map_id%TYPE,
15: X_mapping_type cn_table_maps.mapping_type%TYPE,
16: X_module_id cn_table_maps.module_id%TYPE,
17: X_source_table_id cn_table_maps.source_table_id%TYPE,
18: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
19: X_destination_table_id cn_table_maps.destination_table_id%TYPE,

Line 16: X_module_id cn_table_maps.module_id%TYPE,

12: PROCEDURE insert_row (
13: X_rowid OUT NOCOPY ROWID,
14: X_table_map_id IN OUT NOCOPY cn_table_maps.table_map_id%TYPE,
15: X_mapping_type cn_table_maps.mapping_type%TYPE,
16: X_module_id cn_table_maps.module_id%TYPE,
17: X_source_table_id cn_table_maps.source_table_id%TYPE,
18: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
19: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
20: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,

Line 17: X_source_table_id cn_table_maps.source_table_id%TYPE,

13: X_rowid OUT NOCOPY ROWID,
14: X_table_map_id IN OUT NOCOPY cn_table_maps.table_map_id%TYPE,
15: X_mapping_type cn_table_maps.mapping_type%TYPE,
16: X_module_id cn_table_maps.module_id%TYPE,
17: X_source_table_id cn_table_maps.source_table_id%TYPE,
18: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
19: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
20: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
21: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,

Line 18: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,

14: X_table_map_id IN OUT NOCOPY cn_table_maps.table_map_id%TYPE,
15: X_mapping_type cn_table_maps.mapping_type%TYPE,
16: X_module_id cn_table_maps.module_id%TYPE,
17: X_source_table_id cn_table_maps.source_table_id%TYPE,
18: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
19: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
20: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
21: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
22: X_notify_where cn_table_maps.notify_where%TYPE,

Line 19: X_destination_table_id cn_table_maps.destination_table_id%TYPE,

15: X_mapping_type cn_table_maps.mapping_type%TYPE,
16: X_module_id cn_table_maps.module_id%TYPE,
17: X_source_table_id cn_table_maps.source_table_id%TYPE,
18: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
19: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
20: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
21: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
22: X_notify_where cn_table_maps.notify_where%TYPE,
23: X_collect_where cn_table_maps.collect_where%TYPE,

Line 20: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,

16: X_module_id cn_table_maps.module_id%TYPE,
17: X_source_table_id cn_table_maps.source_table_id%TYPE,
18: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
19: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
20: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
21: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
22: X_notify_where cn_table_maps.notify_where%TYPE,
23: X_collect_where cn_table_maps.collect_where%TYPE,
24: X_delete_flag cn_table_maps.delete_flag%TYPE,

Line 21: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,

17: X_source_table_id cn_table_maps.source_table_id%TYPE,
18: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
19: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
20: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
21: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
22: X_notify_where cn_table_maps.notify_where%TYPE,
23: X_collect_where cn_table_maps.collect_where%TYPE,
24: X_delete_flag cn_table_maps.delete_flag%TYPE,
25: X_creation_date cn_table_maps.creation_date%TYPE,

Line 22: X_notify_where cn_table_maps.notify_where%TYPE,

18: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
19: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
20: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
21: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
22: X_notify_where cn_table_maps.notify_where%TYPE,
23: X_collect_where cn_table_maps.collect_where%TYPE,
24: X_delete_flag cn_table_maps.delete_flag%TYPE,
25: X_creation_date cn_table_maps.creation_date%TYPE,
26: X_created_by cn_table_maps.created_by%TYPE,

Line 23: X_collect_where cn_table_maps.collect_where%TYPE,

19: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
20: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
21: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
22: X_notify_where cn_table_maps.notify_where%TYPE,
23: X_collect_where cn_table_maps.collect_where%TYPE,
24: X_delete_flag cn_table_maps.delete_flag%TYPE,
25: X_creation_date cn_table_maps.creation_date%TYPE,
26: X_created_by cn_table_maps.created_by%TYPE,
27: X_org_id cn_table_maps.org_id%TYPE);

Line 24: X_delete_flag cn_table_maps.delete_flag%TYPE,

20: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
21: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
22: X_notify_where cn_table_maps.notify_where%TYPE,
23: X_collect_where cn_table_maps.collect_where%TYPE,
24: X_delete_flag cn_table_maps.delete_flag%TYPE,
25: X_creation_date cn_table_maps.creation_date%TYPE,
26: X_created_by cn_table_maps.created_by%TYPE,
27: X_org_id cn_table_maps.org_id%TYPE);
28:

Line 25: X_creation_date cn_table_maps.creation_date%TYPE,

21: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
22: X_notify_where cn_table_maps.notify_where%TYPE,
23: X_collect_where cn_table_maps.collect_where%TYPE,
24: X_delete_flag cn_table_maps.delete_flag%TYPE,
25: X_creation_date cn_table_maps.creation_date%TYPE,
26: X_created_by cn_table_maps.created_by%TYPE,
27: X_org_id cn_table_maps.org_id%TYPE);
28:
29: PROCEDURE lock_row (

Line 26: X_created_by cn_table_maps.created_by%TYPE,

22: X_notify_where cn_table_maps.notify_where%TYPE,
23: X_collect_where cn_table_maps.collect_where%TYPE,
24: X_delete_flag cn_table_maps.delete_flag%TYPE,
25: X_creation_date cn_table_maps.creation_date%TYPE,
26: X_created_by cn_table_maps.created_by%TYPE,
27: X_org_id cn_table_maps.org_id%TYPE);
28:
29: PROCEDURE lock_row (
30: X_table_map_id cn_table_maps.table_map_id%TYPE,

Line 27: X_org_id cn_table_maps.org_id%TYPE);

23: X_collect_where cn_table_maps.collect_where%TYPE,
24: X_delete_flag cn_table_maps.delete_flag%TYPE,
25: X_creation_date cn_table_maps.creation_date%TYPE,
26: X_created_by cn_table_maps.created_by%TYPE,
27: X_org_id cn_table_maps.org_id%TYPE);
28:
29: PROCEDURE lock_row (
30: X_table_map_id cn_table_maps.table_map_id%TYPE,
31: X_mapping_type cn_table_maps.mapping_type%TYPE,

Line 30: X_table_map_id cn_table_maps.table_map_id%TYPE,

26: X_created_by cn_table_maps.created_by%TYPE,
27: X_org_id cn_table_maps.org_id%TYPE);
28:
29: PROCEDURE lock_row (
30: X_table_map_id cn_table_maps.table_map_id%TYPE,
31: X_mapping_type cn_table_maps.mapping_type%TYPE,
32: X_module_id cn_table_maps.module_id%TYPE,
33: X_source_table_id cn_table_maps.source_table_id%TYPE,
34: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,

Line 31: X_mapping_type cn_table_maps.mapping_type%TYPE,

27: X_org_id cn_table_maps.org_id%TYPE);
28:
29: PROCEDURE lock_row (
30: X_table_map_id cn_table_maps.table_map_id%TYPE,
31: X_mapping_type cn_table_maps.mapping_type%TYPE,
32: X_module_id cn_table_maps.module_id%TYPE,
33: X_source_table_id cn_table_maps.source_table_id%TYPE,
34: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
35: X_destination_table_id cn_table_maps.destination_table_id%TYPE,

Line 32: X_module_id cn_table_maps.module_id%TYPE,

28:
29: PROCEDURE lock_row (
30: X_table_map_id cn_table_maps.table_map_id%TYPE,
31: X_mapping_type cn_table_maps.mapping_type%TYPE,
32: X_module_id cn_table_maps.module_id%TYPE,
33: X_source_table_id cn_table_maps.source_table_id%TYPE,
34: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
35: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
36: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,

Line 33: X_source_table_id cn_table_maps.source_table_id%TYPE,

29: PROCEDURE lock_row (
30: X_table_map_id cn_table_maps.table_map_id%TYPE,
31: X_mapping_type cn_table_maps.mapping_type%TYPE,
32: X_module_id cn_table_maps.module_id%TYPE,
33: X_source_table_id cn_table_maps.source_table_id%TYPE,
34: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
35: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
36: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
37: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,

Line 34: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,

30: X_table_map_id cn_table_maps.table_map_id%TYPE,
31: X_mapping_type cn_table_maps.mapping_type%TYPE,
32: X_module_id cn_table_maps.module_id%TYPE,
33: X_source_table_id cn_table_maps.source_table_id%TYPE,
34: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
35: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
36: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
37: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
38: X_notify_where cn_table_maps.notify_where%TYPE,

Line 35: X_destination_table_id cn_table_maps.destination_table_id%TYPE,

31: X_mapping_type cn_table_maps.mapping_type%TYPE,
32: X_module_id cn_table_maps.module_id%TYPE,
33: X_source_table_id cn_table_maps.source_table_id%TYPE,
34: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
35: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
36: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
37: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
38: X_notify_where cn_table_maps.notify_where%TYPE,
39: X_collect_where cn_table_maps.collect_where%TYPE,

Line 36: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,

32: X_module_id cn_table_maps.module_id%TYPE,
33: X_source_table_id cn_table_maps.source_table_id%TYPE,
34: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
35: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
36: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
37: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
38: X_notify_where cn_table_maps.notify_where%TYPE,
39: X_collect_where cn_table_maps.collect_where%TYPE,
40: X_delete_flag cn_table_maps.delete_flag%TYPE);

Line 37: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,

33: X_source_table_id cn_table_maps.source_table_id%TYPE,
34: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
35: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
36: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
37: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
38: X_notify_where cn_table_maps.notify_where%TYPE,
39: X_collect_where cn_table_maps.collect_where%TYPE,
40: X_delete_flag cn_table_maps.delete_flag%TYPE);
41:

Line 38: X_notify_where cn_table_maps.notify_where%TYPE,

34: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
35: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
36: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
37: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
38: X_notify_where cn_table_maps.notify_where%TYPE,
39: X_collect_where cn_table_maps.collect_where%TYPE,
40: X_delete_flag cn_table_maps.delete_flag%TYPE);
41:
42: PROCEDURE update_row (

Line 39: X_collect_where cn_table_maps.collect_where%TYPE,

35: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
36: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
37: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
38: X_notify_where cn_table_maps.notify_where%TYPE,
39: X_collect_where cn_table_maps.collect_where%TYPE,
40: X_delete_flag cn_table_maps.delete_flag%TYPE);
41:
42: PROCEDURE update_row (
43: X_table_map_id cn_table_maps.table_map_id%TYPE,

Line 40: X_delete_flag cn_table_maps.delete_flag%TYPE);

36: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
37: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
38: X_notify_where cn_table_maps.notify_where%TYPE,
39: X_collect_where cn_table_maps.collect_where%TYPE,
40: X_delete_flag cn_table_maps.delete_flag%TYPE);
41:
42: PROCEDURE update_row (
43: X_table_map_id cn_table_maps.table_map_id%TYPE,
44: X_mapping_type cn_table_maps.mapping_type%TYPE,

Line 43: X_table_map_id cn_table_maps.table_map_id%TYPE,

39: X_collect_where cn_table_maps.collect_where%TYPE,
40: X_delete_flag cn_table_maps.delete_flag%TYPE);
41:
42: PROCEDURE update_row (
43: X_table_map_id cn_table_maps.table_map_id%TYPE,
44: X_mapping_type cn_table_maps.mapping_type%TYPE,
45: X_module_id cn_table_maps.module_id%TYPE,
46: X_source_table_id cn_table_maps.source_table_id%TYPE,
47: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,

Line 44: X_mapping_type cn_table_maps.mapping_type%TYPE,

40: X_delete_flag cn_table_maps.delete_flag%TYPE);
41:
42: PROCEDURE update_row (
43: X_table_map_id cn_table_maps.table_map_id%TYPE,
44: X_mapping_type cn_table_maps.mapping_type%TYPE,
45: X_module_id cn_table_maps.module_id%TYPE,
46: X_source_table_id cn_table_maps.source_table_id%TYPE,
47: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
48: X_destination_table_id cn_table_maps.destination_table_id%TYPE,

Line 45: X_module_id cn_table_maps.module_id%TYPE,

41:
42: PROCEDURE update_row (
43: X_table_map_id cn_table_maps.table_map_id%TYPE,
44: X_mapping_type cn_table_maps.mapping_type%TYPE,
45: X_module_id cn_table_maps.module_id%TYPE,
46: X_source_table_id cn_table_maps.source_table_id%TYPE,
47: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
48: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
49: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,

Line 46: X_source_table_id cn_table_maps.source_table_id%TYPE,

42: PROCEDURE update_row (
43: X_table_map_id cn_table_maps.table_map_id%TYPE,
44: X_mapping_type cn_table_maps.mapping_type%TYPE,
45: X_module_id cn_table_maps.module_id%TYPE,
46: X_source_table_id cn_table_maps.source_table_id%TYPE,
47: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
48: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
49: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
50: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,

Line 47: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,

43: X_table_map_id cn_table_maps.table_map_id%TYPE,
44: X_mapping_type cn_table_maps.mapping_type%TYPE,
45: X_module_id cn_table_maps.module_id%TYPE,
46: X_source_table_id cn_table_maps.source_table_id%TYPE,
47: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
48: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
49: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
50: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
51: X_notify_where cn_table_maps.notify_where%TYPE,

Line 48: X_destination_table_id cn_table_maps.destination_table_id%TYPE,

44: X_mapping_type cn_table_maps.mapping_type%TYPE,
45: X_module_id cn_table_maps.module_id%TYPE,
46: X_source_table_id cn_table_maps.source_table_id%TYPE,
47: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
48: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
49: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
50: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
51: X_notify_where cn_table_maps.notify_where%TYPE,
52: X_collect_where cn_table_maps.collect_where%TYPE,

Line 49: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,

45: X_module_id cn_table_maps.module_id%TYPE,
46: X_source_table_id cn_table_maps.source_table_id%TYPE,
47: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
48: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
49: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
50: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
51: X_notify_where cn_table_maps.notify_where%TYPE,
52: X_collect_where cn_table_maps.collect_where%TYPE,
53: X_delete_flag cn_table_maps.delete_flag%TYPE,

Line 50: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,

46: X_source_table_id cn_table_maps.source_table_id%TYPE,
47: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
48: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
49: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
50: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
51: X_notify_where cn_table_maps.notify_where%TYPE,
52: X_collect_where cn_table_maps.collect_where%TYPE,
53: X_delete_flag cn_table_maps.delete_flag%TYPE,
54: X_last_update_date cn_table_maps.last_update_date%TYPE,

Line 51: X_notify_where cn_table_maps.notify_where%TYPE,

47: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
48: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
49: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
50: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
51: X_notify_where cn_table_maps.notify_where%TYPE,
52: X_collect_where cn_table_maps.collect_where%TYPE,
53: X_delete_flag cn_table_maps.delete_flag%TYPE,
54: X_last_update_date cn_table_maps.last_update_date%TYPE,
55: X_last_updated_by cn_table_maps.last_updated_by%TYPE,

Line 52: X_collect_where cn_table_maps.collect_where%TYPE,

48: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
49: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
50: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
51: X_notify_where cn_table_maps.notify_where%TYPE,
52: X_collect_where cn_table_maps.collect_where%TYPE,
53: X_delete_flag cn_table_maps.delete_flag%TYPE,
54: X_last_update_date cn_table_maps.last_update_date%TYPE,
55: X_last_updated_by cn_table_maps.last_updated_by%TYPE,
56: X_last_update_login cn_table_maps.last_update_login%TYPE,

Line 53: X_delete_flag cn_table_maps.delete_flag%TYPE,

49: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
50: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
51: X_notify_where cn_table_maps.notify_where%TYPE,
52: X_collect_where cn_table_maps.collect_where%TYPE,
53: X_delete_flag cn_table_maps.delete_flag%TYPE,
54: X_last_update_date cn_table_maps.last_update_date%TYPE,
55: X_last_updated_by cn_table_maps.last_updated_by%TYPE,
56: X_last_update_login cn_table_maps.last_update_login%TYPE,
57: x_object_version_number NUMBER := cn_api.G_MISS_NUM,

Line 54: X_last_update_date cn_table_maps.last_update_date%TYPE,

50: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
51: X_notify_where cn_table_maps.notify_where%TYPE,
52: X_collect_where cn_table_maps.collect_where%TYPE,
53: X_delete_flag cn_table_maps.delete_flag%TYPE,
54: X_last_update_date cn_table_maps.last_update_date%TYPE,
55: X_last_updated_by cn_table_maps.last_updated_by%TYPE,
56: X_last_update_login cn_table_maps.last_update_login%TYPE,
57: x_object_version_number NUMBER := cn_api.G_MISS_NUM,
58: x_org_id cn_table_maps.org_id%TYPE);

Line 55: X_last_updated_by cn_table_maps.last_updated_by%TYPE,

51: X_notify_where cn_table_maps.notify_where%TYPE,
52: X_collect_where cn_table_maps.collect_where%TYPE,
53: X_delete_flag cn_table_maps.delete_flag%TYPE,
54: X_last_update_date cn_table_maps.last_update_date%TYPE,
55: X_last_updated_by cn_table_maps.last_updated_by%TYPE,
56: X_last_update_login cn_table_maps.last_update_login%TYPE,
57: x_object_version_number NUMBER := cn_api.G_MISS_NUM,
58: x_org_id cn_table_maps.org_id%TYPE);
59:

Line 56: X_last_update_login cn_table_maps.last_update_login%TYPE,

52: X_collect_where cn_table_maps.collect_where%TYPE,
53: X_delete_flag cn_table_maps.delete_flag%TYPE,
54: X_last_update_date cn_table_maps.last_update_date%TYPE,
55: X_last_updated_by cn_table_maps.last_updated_by%TYPE,
56: X_last_update_login cn_table_maps.last_update_login%TYPE,
57: x_object_version_number NUMBER := cn_api.G_MISS_NUM,
58: x_org_id cn_table_maps.org_id%TYPE);
59:
60: PROCEDURE delete_row (

Line 58: x_org_id cn_table_maps.org_id%TYPE);

54: X_last_update_date cn_table_maps.last_update_date%TYPE,
55: X_last_updated_by cn_table_maps.last_updated_by%TYPE,
56: X_last_update_login cn_table_maps.last_update_login%TYPE,
57: x_object_version_number NUMBER := cn_api.G_MISS_NUM,
58: x_org_id cn_table_maps.org_id%TYPE);
59:
60: PROCEDURE delete_row (
61: X_table_map_id in NUMBER,
62: X_org_id IN NUMBER);

Line 115: END cn_table_maps_pkg;

111: x_FILTER in varchar2,
112: x_APPLICATION_SHORT_NAME in varchar2,
113: x_OWNER in varchar2);
114:
115: END cn_table_maps_pkg;
116: