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_TABLE_MAPS_PKG dependencies on CN_TABLE_MAPS_S

Line 12: X_source_table_id cn_table_maps.source_table_id%TYPE,

8: X_rowid OUT NOCOPY ROWID,
9: X_table_map_id IN OUT NOCOPY cn_table_maps.table_map_id%TYPE,
10: X_mapping_type cn_table_maps.mapping_type%TYPE,
11: X_module_id cn_table_maps.module_id%TYPE,
12: X_source_table_id cn_table_maps.source_table_id%TYPE,
13: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
14: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
15: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
16: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,

Line 13: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,

9: X_table_map_id IN OUT NOCOPY cn_table_maps.table_map_id%TYPE,
10: X_mapping_type cn_table_maps.mapping_type%TYPE,
11: X_module_id cn_table_maps.module_id%TYPE,
12: X_source_table_id cn_table_maps.source_table_id%TYPE,
13: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
14: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
15: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
16: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
17: X_notify_where cn_table_maps.notify_where%TYPE,

Line 15: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,

11: X_module_id cn_table_maps.module_id%TYPE,
12: X_source_table_id cn_table_maps.source_table_id%TYPE,
13: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
14: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
15: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
16: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
17: X_notify_where cn_table_maps.notify_where%TYPE,
18: X_collect_where cn_table_maps.collect_where%TYPE,
19: X_delete_flag cn_table_maps.delete_flag%TYPE,

Line 16: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,

12: X_source_table_id cn_table_maps.source_table_id%TYPE,
13: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
14: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
15: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
16: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
17: X_notify_where cn_table_maps.notify_where%TYPE,
18: X_collect_where cn_table_maps.collect_where%TYPE,
19: X_delete_flag cn_table_maps.delete_flag%TYPE,
20: X_creation_date cn_table_maps.creation_date%TYPE,

Line 27: SELECT cn_table_maps_s.NEXTVAL

23:
24: BEGIN
25:
26: IF X_table_map_id IS NULL THEN
27: SELECT cn_table_maps_s.NEXTVAL
28: INTO X_table_map_id
29: FROM dual;
30: END IF;
31:

Line 80: X_source_table_id cn_table_maps.source_table_id%TYPE,

76: PROCEDURE lock_row (
77: X_table_map_id cn_table_maps.table_map_id%TYPE,
78: X_mapping_type cn_table_maps.mapping_type%TYPE,
79: X_module_id cn_table_maps.module_id%TYPE,
80: X_source_table_id cn_table_maps.source_table_id%TYPE,
81: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
82: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
83: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
84: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,

Line 81: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,

77: X_table_map_id cn_table_maps.table_map_id%TYPE,
78: X_mapping_type cn_table_maps.mapping_type%TYPE,
79: X_module_id cn_table_maps.module_id%TYPE,
80: X_source_table_id cn_table_maps.source_table_id%TYPE,
81: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
82: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
83: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
84: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
85: X_notify_where cn_table_maps.notify_where%TYPE,

Line 83: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,

79: X_module_id cn_table_maps.module_id%TYPE,
80: X_source_table_id cn_table_maps.source_table_id%TYPE,
81: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
82: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
83: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
84: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
85: X_notify_where cn_table_maps.notify_where%TYPE,
86: X_collect_where cn_table_maps.collect_where%TYPE,
87: X_delete_flag cn_table_maps.delete_flag%TYPE) IS

Line 84: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,

80: X_source_table_id cn_table_maps.source_table_id%TYPE,
81: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
82: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
83: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
84: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
85: X_notify_where cn_table_maps.notify_where%TYPE,
86: X_collect_where cn_table_maps.collect_where%TYPE,
87: X_delete_flag cn_table_maps.delete_flag%TYPE) IS
88: --

Line 140: X_source_table_id cn_table_maps.source_table_id%TYPE,

136: PROCEDURE update_row (
137: X_table_map_id cn_table_maps.table_map_id%TYPE,
138: X_mapping_type cn_table_maps.mapping_type%TYPE,
139: X_module_id cn_table_maps.module_id%TYPE,
140: X_source_table_id cn_table_maps.source_table_id%TYPE,
141: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
142: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
143: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
144: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,

Line 141: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,

137: X_table_map_id cn_table_maps.table_map_id%TYPE,
138: X_mapping_type cn_table_maps.mapping_type%TYPE,
139: X_module_id cn_table_maps.module_id%TYPE,
140: X_source_table_id cn_table_maps.source_table_id%TYPE,
141: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
142: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
143: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
144: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
145: X_notify_where cn_table_maps.notify_where%TYPE,

Line 143: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,

139: X_module_id cn_table_maps.module_id%TYPE,
140: X_source_table_id cn_table_maps.source_table_id%TYPE,
141: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
142: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
143: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
144: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
145: X_notify_where cn_table_maps.notify_where%TYPE,
146: X_collect_where cn_table_maps.collect_where%TYPE,
147: X_delete_flag cn_table_maps.delete_flag%TYPE,

Line 144: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,

140: X_source_table_id cn_table_maps.source_table_id%TYPE,
141: X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
142: X_destination_table_id cn_table_maps.destination_table_id%TYPE,
143: X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
144: X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
145: X_notify_where cn_table_maps.notify_where%TYPE,
146: X_collect_where cn_table_maps.collect_where%TYPE,
147: X_delete_flag cn_table_maps.delete_flag%TYPE,
148: X_last_update_date cn_table_maps.last_update_date%TYPE,

Line 172: UPDATE cn_table_maps SET

168: SELECT DECODE(x_object_version_number, cn_api.G_MISS_NUM,
169: l_ovn,x_object_version_number)
170: INTO l_ovn FROM dual;
171:
172: UPDATE cn_table_maps SET
173: mapping_type = x_mapping_type,
174: module_id = x_module_id,
175: source_table_id = x_source_table_id,
176: source_tbl_pkcol_id = x_source_tbl_pkcol_id,