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_COLUMN_MAPS_PKG dependencies on CN_COLUMN_MAPS

Line 1: PACKAGE BODY cn_column_maps_pkg AS

1: PACKAGE BODY cn_column_maps_pkg AS
2: -- $Header: cncocmb.pls 120.7 2005/09/21 20:51:29 sjustina noship $
3: --
4: -- Public Procedures
5: --

Line 8: X_column_map_id IN OUT NOCOPY cn_column_maps.column_map_id%TYPE,

4: -- Public Procedures
5: --
6: PROCEDURE insert_row (
7: X_rowid OUT NOCOPY ROWID,
8: X_column_map_id IN OUT NOCOPY cn_column_maps.column_map_id%TYPE,
9: X_destination_column_id cn_column_maps.destination_column_id%TYPE,
10: X_table_map_id cn_column_maps.table_map_id%TYPE,
11: X_expression cn_column_maps.expression%TYPE,
12: X_editable cn_column_maps.editable%TYPE,

Line 9: X_destination_column_id cn_column_maps.destination_column_id%TYPE,

5: --
6: PROCEDURE insert_row (
7: X_rowid OUT NOCOPY ROWID,
8: X_column_map_id IN OUT NOCOPY cn_column_maps.column_map_id%TYPE,
9: X_destination_column_id cn_column_maps.destination_column_id%TYPE,
10: X_table_map_id cn_column_maps.table_map_id%TYPE,
11: X_expression cn_column_maps.expression%TYPE,
12: X_editable cn_column_maps.editable%TYPE,
13: X_modified cn_column_maps.modified%TYPE,

Line 10: X_table_map_id cn_column_maps.table_map_id%TYPE,

6: PROCEDURE insert_row (
7: X_rowid OUT NOCOPY ROWID,
8: X_column_map_id IN OUT NOCOPY cn_column_maps.column_map_id%TYPE,
9: X_destination_column_id cn_column_maps.destination_column_id%TYPE,
10: X_table_map_id cn_column_maps.table_map_id%TYPE,
11: X_expression cn_column_maps.expression%TYPE,
12: X_editable cn_column_maps.editable%TYPE,
13: X_modified cn_column_maps.modified%TYPE,
14: X_update_clause cn_column_maps.update_clause%TYPE,

Line 11: X_expression cn_column_maps.expression%TYPE,

7: X_rowid OUT NOCOPY ROWID,
8: X_column_map_id IN OUT NOCOPY cn_column_maps.column_map_id%TYPE,
9: X_destination_column_id cn_column_maps.destination_column_id%TYPE,
10: X_table_map_id cn_column_maps.table_map_id%TYPE,
11: X_expression cn_column_maps.expression%TYPE,
12: X_editable cn_column_maps.editable%TYPE,
13: X_modified cn_column_maps.modified%TYPE,
14: X_update_clause cn_column_maps.update_clause%TYPE,
15: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,

Line 12: X_editable cn_column_maps.editable%TYPE,

8: X_column_map_id IN OUT NOCOPY cn_column_maps.column_map_id%TYPE,
9: X_destination_column_id cn_column_maps.destination_column_id%TYPE,
10: X_table_map_id cn_column_maps.table_map_id%TYPE,
11: X_expression cn_column_maps.expression%TYPE,
12: X_editable cn_column_maps.editable%TYPE,
13: X_modified cn_column_maps.modified%TYPE,
14: X_update_clause cn_column_maps.update_clause%TYPE,
15: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,
16: X_creation_date cn_column_maps.creation_date%TYPE,

Line 13: X_modified cn_column_maps.modified%TYPE,

9: X_destination_column_id cn_column_maps.destination_column_id%TYPE,
10: X_table_map_id cn_column_maps.table_map_id%TYPE,
11: X_expression cn_column_maps.expression%TYPE,
12: X_editable cn_column_maps.editable%TYPE,
13: X_modified cn_column_maps.modified%TYPE,
14: X_update_clause cn_column_maps.update_clause%TYPE,
15: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,
16: X_creation_date cn_column_maps.creation_date%TYPE,
17: X_created_by cn_column_maps.created_by%TYPE,

Line 14: X_update_clause cn_column_maps.update_clause%TYPE,

10: X_table_map_id cn_column_maps.table_map_id%TYPE,
11: X_expression cn_column_maps.expression%TYPE,
12: X_editable cn_column_maps.editable%TYPE,
13: X_modified cn_column_maps.modified%TYPE,
14: X_update_clause cn_column_maps.update_clause%TYPE,
15: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,
16: X_creation_date cn_column_maps.creation_date%TYPE,
17: X_created_by cn_column_maps.created_by%TYPE,
18: X_org_id cn_column_maps.org_id%TYPE) IS

Line 15: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,

11: X_expression cn_column_maps.expression%TYPE,
12: X_editable cn_column_maps.editable%TYPE,
13: X_modified cn_column_maps.modified%TYPE,
14: X_update_clause cn_column_maps.update_clause%TYPE,
15: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,
16: X_creation_date cn_column_maps.creation_date%TYPE,
17: X_created_by cn_column_maps.created_by%TYPE,
18: X_org_id cn_column_maps.org_id%TYPE) IS
19:

Line 16: X_creation_date cn_column_maps.creation_date%TYPE,

12: X_editable cn_column_maps.editable%TYPE,
13: X_modified cn_column_maps.modified%TYPE,
14: X_update_clause cn_column_maps.update_clause%TYPE,
15: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,
16: X_creation_date cn_column_maps.creation_date%TYPE,
17: X_created_by cn_column_maps.created_by%TYPE,
18: X_org_id cn_column_maps.org_id%TYPE) IS
19:
20: X_primary_key cn_column_maps.column_map_id%TYPE;

Line 17: X_created_by cn_column_maps.created_by%TYPE,

13: X_modified cn_column_maps.modified%TYPE,
14: X_update_clause cn_column_maps.update_clause%TYPE,
15: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,
16: X_creation_date cn_column_maps.creation_date%TYPE,
17: X_created_by cn_column_maps.created_by%TYPE,
18: X_org_id cn_column_maps.org_id%TYPE) IS
19:
20: X_primary_key cn_column_maps.column_map_id%TYPE;
21: BEGIN

Line 18: X_org_id cn_column_maps.org_id%TYPE) IS

14: X_update_clause cn_column_maps.update_clause%TYPE,
15: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,
16: X_creation_date cn_column_maps.creation_date%TYPE,
17: X_created_by cn_column_maps.created_by%TYPE,
18: X_org_id cn_column_maps.org_id%TYPE) IS
19:
20: X_primary_key cn_column_maps.column_map_id%TYPE;
21: BEGIN
22:

Line 20: X_primary_key cn_column_maps.column_map_id%TYPE;

16: X_creation_date cn_column_maps.creation_date%TYPE,
17: X_created_by cn_column_maps.created_by%TYPE,
18: X_org_id cn_column_maps.org_id%TYPE) IS
19:
20: X_primary_key cn_column_maps.column_map_id%TYPE;
21: BEGIN
22:
23: IF x_column_map_id IS NULL THEN
24: SELECT cn_column_maps_s.NEXTVAL

Line 24: SELECT cn_column_maps_s.NEXTVAL

20: X_primary_key cn_column_maps.column_map_id%TYPE;
21: BEGIN
22:
23: IF x_column_map_id IS NULL THEN
24: SELECT cn_column_maps_s.NEXTVAL
25: INTO X_column_map_id
26: FROM dual;
27: END IF;
28:

Line 29: INSERT INTO cn_column_maps

25: INTO X_column_map_id
26: FROM dual;
27: END IF;
28:
29: INSERT INTO cn_column_maps
30: (object_version_number,
31: column_map_id,
32: destination_column_id,
33: table_map_id,

Line 54: FROM cn_column_maps

50: X_org_id);
51:
52: SELECT ROWID
53: INTO X_rowid
54: FROM cn_column_maps
55: WHERE column_map_id = X_column_map_id
56: AND org_id = X_org_id;
57:
58: IF (SQL%NOTFOUND) THEN

Line 66: x_recinfo IN OUT NOCOPY cn_column_maps%ROWTYPE) IS

62: END insert_row;
63:
64: /*
65: PROCEDURE select_row (
66: x_recinfo IN OUT NOCOPY cn_column_maps%ROWTYPE) IS
67: BEGIN
68: -- select row based on column_map_id (primary key)
69: IF (x_recinfo.column_map_id IS NOT NULL) THEN
70:

Line 72: FROM cn_column_maps ccm

68: -- select row based on column_map_id (primary key)
69: IF (x_recinfo.column_map_id IS NOT NULL) THEN
70:
71: SELECT * INTO x_recinfo
72: FROM cn_column_maps ccm
73: WHERE ccm.column_map_id = x_recinfo.column_map_id;
74:
75: END IF;
76: END select_row;

Line 79: X_column_map_id cn_column_maps.column_map_id%TYPE,

75: END IF;
76: END select_row;
77:
78: PROCEDURE lock_row (
79: X_column_map_id cn_column_maps.column_map_id%TYPE,
80: X_destination_column_id cn_column_maps.destination_column_id%TYPE,
81: X_table_map_id cn_column_maps.table_map_id%TYPE,
82: X_expression cn_column_maps.expression%TYPE,
83: X_editable cn_column_maps.editable%TYPE,

Line 80: X_destination_column_id cn_column_maps.destination_column_id%TYPE,

76: END select_row;
77:
78: PROCEDURE lock_row (
79: X_column_map_id cn_column_maps.column_map_id%TYPE,
80: X_destination_column_id cn_column_maps.destination_column_id%TYPE,
81: X_table_map_id cn_column_maps.table_map_id%TYPE,
82: X_expression cn_column_maps.expression%TYPE,
83: X_editable cn_column_maps.editable%TYPE,
84: X_modified cn_column_maps.modified%TYPE,

Line 81: X_table_map_id cn_column_maps.table_map_id%TYPE,

77:
78: PROCEDURE lock_row (
79: X_column_map_id cn_column_maps.column_map_id%TYPE,
80: X_destination_column_id cn_column_maps.destination_column_id%TYPE,
81: X_table_map_id cn_column_maps.table_map_id%TYPE,
82: X_expression cn_column_maps.expression%TYPE,
83: X_editable cn_column_maps.editable%TYPE,
84: X_modified cn_column_maps.modified%TYPE,
85: X_update_clause cn_column_maps.update_clause%TYPE,

Line 82: X_expression cn_column_maps.expression%TYPE,

78: PROCEDURE lock_row (
79: X_column_map_id cn_column_maps.column_map_id%TYPE,
80: X_destination_column_id cn_column_maps.destination_column_id%TYPE,
81: X_table_map_id cn_column_maps.table_map_id%TYPE,
82: X_expression cn_column_maps.expression%TYPE,
83: X_editable cn_column_maps.editable%TYPE,
84: X_modified cn_column_maps.modified%TYPE,
85: X_update_clause cn_column_maps.update_clause%TYPE,
86: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE) IS

Line 83: X_editable cn_column_maps.editable%TYPE,

79: X_column_map_id cn_column_maps.column_map_id%TYPE,
80: X_destination_column_id cn_column_maps.destination_column_id%TYPE,
81: X_table_map_id cn_column_maps.table_map_id%TYPE,
82: X_expression cn_column_maps.expression%TYPE,
83: X_editable cn_column_maps.editable%TYPE,
84: X_modified cn_column_maps.modified%TYPE,
85: X_update_clause cn_column_maps.update_clause%TYPE,
86: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE) IS
87: --

Line 84: X_modified cn_column_maps.modified%TYPE,

80: X_destination_column_id cn_column_maps.destination_column_id%TYPE,
81: X_table_map_id cn_column_maps.table_map_id%TYPE,
82: X_expression cn_column_maps.expression%TYPE,
83: X_editable cn_column_maps.editable%TYPE,
84: X_modified cn_column_maps.modified%TYPE,
85: X_update_clause cn_column_maps.update_clause%TYPE,
86: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE) IS
87: --
88: CURSOR c1 IS SELECT

Line 85: X_update_clause cn_column_maps.update_clause%TYPE,

81: X_table_map_id cn_column_maps.table_map_id%TYPE,
82: X_expression cn_column_maps.expression%TYPE,
83: X_editable cn_column_maps.editable%TYPE,
84: X_modified cn_column_maps.modified%TYPE,
85: X_update_clause cn_column_maps.update_clause%TYPE,
86: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE) IS
87: --
88: CURSOR c1 IS SELECT
89: destination_column_id,

Line 86: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE) IS

82: X_expression cn_column_maps.expression%TYPE,
83: X_editable cn_column_maps.editable%TYPE,
84: X_modified cn_column_maps.modified%TYPE,
85: X_update_clause cn_column_maps.update_clause%TYPE,
86: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE) IS
87: --
88: CURSOR c1 IS SELECT
89: destination_column_id,
90: table_map_id,

Line 96: FROM cn_column_maps

92: editable,
93: modified,
94: update_clause,
95: calc_ext_table_id
96: FROM cn_column_maps
97: WHERE column_map_id = x_column_map_id
98: FOR UPDATE OF column_map_id NOWAIT;
99:
100: tlinfo c1%ROWTYPE;

Line 129: X_column_map_id cn_column_maps.column_map_id%TYPE,

125: END lock_row;
126: */
127:
128: PROCEDURE update_row (
129: X_column_map_id cn_column_maps.column_map_id%TYPE,
130: X_destination_column_id cn_column_maps.destination_column_id%TYPE,
131: X_table_map_id cn_column_maps.table_map_id%TYPE,
132: X_expression cn_column_maps.expression%TYPE,
133: X_editable cn_column_maps.editable%TYPE,

Line 130: X_destination_column_id cn_column_maps.destination_column_id%TYPE,

126: */
127:
128: PROCEDURE update_row (
129: X_column_map_id cn_column_maps.column_map_id%TYPE,
130: X_destination_column_id cn_column_maps.destination_column_id%TYPE,
131: X_table_map_id cn_column_maps.table_map_id%TYPE,
132: X_expression cn_column_maps.expression%TYPE,
133: X_editable cn_column_maps.editable%TYPE,
134: X_modified cn_column_maps.modified%TYPE,

Line 131: X_table_map_id cn_column_maps.table_map_id%TYPE,

127:
128: PROCEDURE update_row (
129: X_column_map_id cn_column_maps.column_map_id%TYPE,
130: X_destination_column_id cn_column_maps.destination_column_id%TYPE,
131: X_table_map_id cn_column_maps.table_map_id%TYPE,
132: X_expression cn_column_maps.expression%TYPE,
133: X_editable cn_column_maps.editable%TYPE,
134: X_modified cn_column_maps.modified%TYPE,
135: X_update_clause cn_column_maps.update_clause%TYPE,

Line 132: X_expression cn_column_maps.expression%TYPE,

128: PROCEDURE update_row (
129: X_column_map_id cn_column_maps.column_map_id%TYPE,
130: X_destination_column_id cn_column_maps.destination_column_id%TYPE,
131: X_table_map_id cn_column_maps.table_map_id%TYPE,
132: X_expression cn_column_maps.expression%TYPE,
133: X_editable cn_column_maps.editable%TYPE,
134: X_modified cn_column_maps.modified%TYPE,
135: X_update_clause cn_column_maps.update_clause%TYPE,
136: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,

Line 133: X_editable cn_column_maps.editable%TYPE,

129: X_column_map_id cn_column_maps.column_map_id%TYPE,
130: X_destination_column_id cn_column_maps.destination_column_id%TYPE,
131: X_table_map_id cn_column_maps.table_map_id%TYPE,
132: X_expression cn_column_maps.expression%TYPE,
133: X_editable cn_column_maps.editable%TYPE,
134: X_modified cn_column_maps.modified%TYPE,
135: X_update_clause cn_column_maps.update_clause%TYPE,
136: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,
137: X_last_update_date cn_column_maps.last_update_date%TYPE,

Line 134: X_modified cn_column_maps.modified%TYPE,

130: X_destination_column_id cn_column_maps.destination_column_id%TYPE,
131: X_table_map_id cn_column_maps.table_map_id%TYPE,
132: X_expression cn_column_maps.expression%TYPE,
133: X_editable cn_column_maps.editable%TYPE,
134: X_modified cn_column_maps.modified%TYPE,
135: X_update_clause cn_column_maps.update_clause%TYPE,
136: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,
137: X_last_update_date cn_column_maps.last_update_date%TYPE,
138: X_last_updated_by cn_column_maps.last_updated_by%TYPE,

Line 135: X_update_clause cn_column_maps.update_clause%TYPE,

131: X_table_map_id cn_column_maps.table_map_id%TYPE,
132: X_expression cn_column_maps.expression%TYPE,
133: X_editable cn_column_maps.editable%TYPE,
134: X_modified cn_column_maps.modified%TYPE,
135: X_update_clause cn_column_maps.update_clause%TYPE,
136: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,
137: X_last_update_date cn_column_maps.last_update_date%TYPE,
138: X_last_updated_by cn_column_maps.last_updated_by%TYPE,
139: X_last_update_login cn_column_maps.last_update_login%TYPE,

Line 136: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,

132: X_expression cn_column_maps.expression%TYPE,
133: X_editable cn_column_maps.editable%TYPE,
134: X_modified cn_column_maps.modified%TYPE,
135: X_update_clause cn_column_maps.update_clause%TYPE,
136: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,
137: X_last_update_date cn_column_maps.last_update_date%TYPE,
138: X_last_updated_by cn_column_maps.last_updated_by%TYPE,
139: X_last_update_login cn_column_maps.last_update_login%TYPE,
140: X_object_version_number IN OUT NOCOPY NUMBER ,

Line 137: X_last_update_date cn_column_maps.last_update_date%TYPE,

133: X_editable cn_column_maps.editable%TYPE,
134: X_modified cn_column_maps.modified%TYPE,
135: X_update_clause cn_column_maps.update_clause%TYPE,
136: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,
137: X_last_update_date cn_column_maps.last_update_date%TYPE,
138: X_last_updated_by cn_column_maps.last_updated_by%TYPE,
139: X_last_update_login cn_column_maps.last_update_login%TYPE,
140: X_object_version_number IN OUT NOCOPY NUMBER ,
141: x_org_id IN NUMBER) IS

Line 138: X_last_updated_by cn_column_maps.last_updated_by%TYPE,

134: X_modified cn_column_maps.modified%TYPE,
135: X_update_clause cn_column_maps.update_clause%TYPE,
136: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,
137: X_last_update_date cn_column_maps.last_update_date%TYPE,
138: X_last_updated_by cn_column_maps.last_updated_by%TYPE,
139: X_last_update_login cn_column_maps.last_update_login%TYPE,
140: X_object_version_number IN OUT NOCOPY NUMBER ,
141: x_org_id IN NUMBER) IS
142:

Line 139: X_last_update_login cn_column_maps.last_update_login%TYPE,

135: X_update_clause cn_column_maps.update_clause%TYPE,
136: X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,
137: X_last_update_date cn_column_maps.last_update_date%TYPE,
138: X_last_updated_by cn_column_maps.last_updated_by%TYPE,
139: X_last_update_login cn_column_maps.last_update_login%TYPE,
140: X_object_version_number IN OUT NOCOPY NUMBER ,
141: x_org_id IN NUMBER) IS
142:
143: CURSOR l_ovn_csr IS

Line 145: FROM cn_column_maps

141: x_org_id IN NUMBER) IS
142:
143: CURSOR l_ovn_csr IS
144: SELECT object_version_number
145: FROM cn_column_maps
146: WHERE column_map_id = x_column_map_id
147: and org_id = x_org_id;
148:
149: l_ovn NUMBER;

Line 161: UPDATE cn_column_maps set

157: SELECT DECODE(x_object_version_number, cn_api.G_MISS_NUM,
158: l_ovn,x_object_version_number)
159: INTO l_ovn FROM dual;
160:
161: UPDATE cn_column_maps set
162: destination_column_id = x_destination_column_id,
163: table_map_id = x_table_map_id,
164: expression = x_expression,
165: editable = x_editable,

Line 188: DELETE FROM cn_column_maps

184: X_column_map_id IN NUMBER,
185: x_org_id IN NUMBER
186: ) IS
187: BEGIN
188: DELETE FROM cn_column_maps
189: WHERE column_map_id = x_column_map_id
190: AND org_id = x_org_id;
191:
192: IF (SQL%NOTFOUND) THEN

Line 234: update cn_column_maps_all set

230: ELSE
231: USER_ID := 0;
232: END IF;
233:
234: update cn_column_maps_all set
235: DESTINATION_COLUMN_ID = to_number(x_DESTINATION_COLUMN_ID),
236: TABLE_MAP_ID = to_number(x_TABLE_MAP_ID),
237: LAST_UPDATE_DATE = to_date(x_LAST_UPDATE_DATE, 'DD-MM-YYYY'),
238: LAST_UPDATED_BY = to_number(x_LAST_UPDATED_BY),

Line 261: insert into cn_column_maps_all

257: and ORG_ID = x_ORG_ID;
258:
259: IF (SQL%NOTFOUND) THEN
260: -- Insert new record to CN_OBJECTS_TABLE table
261: insert into cn_column_maps_all
262: (COLUMN_MAP_ID,
263: DESTINATION_COLUMN_ID,
264: TABLE_MAP_ID,
265: LAST_UPDATE_DATE,

Line 341: --CN_COLUMN_MAPS_PKG.TRANSLATE_ROW(x_owner);

337: x_OWNER in varchar2)
338: IS
339: BEGIN
340: if (x_upload_mode = 'NLS') then
341: --CN_COLUMN_MAPS_PKG.TRANSLATE_ROW(x_owner);
342: -- As this ldt is not required to loaded translated data, you could leave it blank.
343: null;
344: else
345: CN_COLUMN_MAPS_PKG.load_row(x_COLUMN_MAP_ID,

Line 345: CN_COLUMN_MAPS_PKG.load_row(x_COLUMN_MAP_ID,

341: --CN_COLUMN_MAPS_PKG.TRANSLATE_ROW(x_owner);
342: -- As this ldt is not required to loaded translated data, you could leave it blank.
343: null;
344: else
345: CN_COLUMN_MAPS_PKG.load_row(x_COLUMN_MAP_ID,
346: x_DESTINATION_COLUMN_ID,
347: x_TABLE_MAP_ID,
348: x_LAST_UPDATE_DATE,
349: x_LAST_UPDATED_BY,

Line 374: END cn_column_maps_pkg;

370: end if;
371: END load_seed_row;
372:
373:
374: END cn_column_maps_pkg;