APPS.CN_TABLE_MAP_OBJECTS_PKG dependencies on CN_TABLE_MAP_OBJECTS

Line 1: PACKAGE BODY cn_table_map_objects_pkg as

1: PACKAGE BODY cn_table_map_objects_pkg as
2: /* $Header: cntmobjb.pls 120.4 2005/09/21 20:50:55 sjustina noship $ */
3: PROCEDURE insert_row (
4: X_rowid IN OUT NOCOPY VARCHAR2,
5: X_table_map_object_id IN OUT NOCOPY NUMBER,

Line 13: CURSOR c IS SELECT rowid FROM cn_table_map_objects

9: X_creation_date IN DATE,
10: X_created_by IN NUMBER,
11: X_org_id IN NUMBER
12: ) IS
13: CURSOR c IS SELECT rowid FROM cn_table_map_objects
14: WHERE table_map_object_id = x_table_map_object_id
15: AND org_id = X_org_id;
16:
17: BEGIN

Line 19: SELECT cn_table_map_objects_s.NEXTVAL

15: AND org_id = X_org_id;
16:
17: BEGIN
18: IF x_table_map_object_id IS NULL THEN
19: SELECT cn_table_map_objects_s.NEXTVAL
20: INTO x_table_map_object_id
21: FROM dual;
22: END IF;
23:

Line 24: INSERT INTO cn_table_map_objects (

20: INTO x_table_map_object_id
21: FROM dual;
22: END IF;
23:
24: INSERT INTO cn_table_map_objects (
25: table_map_object_id,
26: tm_object_type,
27: table_map_id,
28: object_id,

Line 63: FROM cn_table_map_objects

59: CURSOR c1 IS SELECt
60: tm_object_type,
61: table_map_id,
62: object_id
63: FROM cn_table_map_objects
64: WHERE table_map_object_id = x_table_map_object_id
65: FOR UPDATE OF table_map_object_id NOWAIT;
66:
67: tlinfo c1%ROWTYPE;

Line 102: FROM cn_table_map_objects

98: -- Added Cursor For R12 MOAC
99:
100: CURSOR l_ovn_csr IS
101: SELECT object_version_number
102: FROM cn_table_map_objects
103: WHERE table_map_id = X_table_map_id
104: AND org_id = x_org_id;
105:
106: l_object_version_number cn_table_map_objects.object_version_number%TYPE;

Line 106: l_object_version_number cn_table_map_objects.object_version_number%TYPE;

102: FROM cn_table_map_objects
103: WHERE table_map_id = X_table_map_id
104: AND org_id = x_org_id;
105:
106: l_object_version_number cn_table_map_objects.object_version_number%TYPE;
107:
108: BEGIN
109:
110: OPEN l_ovn_csr;

Line 127: UPDATE cn_table_map_objects SET

123: end if;
124:
125:
126:
127: UPDATE cn_table_map_objects SET
128: tm_object_type = x_tm_object_type,
129: table_map_id = x_table_map_id,
130: object_id = x_object_id,
131: last_update_date = x_last_update_date,

Line 150: DELETE FROM cn_table_map_objects

146: X_table_map_object_id IN NUMBER,
147: X_ORG_ID IN NUMBER
148: ) IS
149: BEGIN
150: DELETE FROM cn_table_map_objects
151: WHERE table_map_object_id = x_table_map_object_id
152: AND org_id = X_ORG_ID;
153:
154: IF (SQL%NOTFOUND) THEN

Line 187: update cn_table_map_objects_all set

183: ELSE
184: USER_ID := 0;
185: END IF;
186:
187: update cn_table_map_objects_all set
188: ORG_ID = to_number(x_ORG_ID),
189: TM_OBJECT_TYPE = x_TM_OBJECT_TYPE,
190: TABLE_MAP_ID = to_number(x_TABLE_MAP_ID),
191: OBJECT_ID = to_number(x_OBJECT_ID),

Line 204: insert into cn_table_map_objects_all

200: and ORG_ID = x_ORG_ID;
201:
202: IF (SQL%NOTFOUND) THEN
203: -- Insert new record to CN_OBJECTS_TABLE table
204: insert into cn_table_map_objects_all
205: (TABLE_MAP_OBJECT_ID,
206: ORG_ID,
207: TM_OBJECT_TYPE,
208: TABLE_MAP_ID,

Line 254: --CN_TABLE_MAP_OBJECTS_PKG.TRANSLATE_ROW(x_owner);

250: x_OWNER in varchar2)
251: IS
252: BEGIN
253: if (x_upload_mode = 'NLS') then
254: --CN_TABLE_MAP_OBJECTS_PKG.TRANSLATE_ROW(x_owner);
255: -- As this ldt is not required to loaded translated data, you could leave it blank.
256: null;
257: else
258: CN_TABLE_MAP_OBJECTS_PKG.load_row(x_TABLE_MAP_OBJECT_ID,

Line 258: CN_TABLE_MAP_OBJECTS_PKG.load_row(x_TABLE_MAP_OBJECT_ID,

254: --CN_TABLE_MAP_OBJECTS_PKG.TRANSLATE_ROW(x_owner);
255: -- As this ldt is not required to loaded translated data, you could leave it blank.
256: null;
257: else
258: CN_TABLE_MAP_OBJECTS_PKG.load_row(x_TABLE_MAP_OBJECT_ID,
259: x_ORG_ID,
260: x_TM_OBJECT_TYPE,
261: x_TABLE_MAP_ID,
262: x_OBJECT_ID,

Line 276: END cn_table_map_objects_pkg ;

272: null;
273: end if;
274: END load_seed_row;
275:
276: END cn_table_map_objects_pkg ;