APPS.CN_DIMENSIONS_PKG dependencies on CN_DIMENSIONS_ALL_B

Line 25: insert into CN_DIMENSIONS_ALL_B (

21: X_ORG_ID in NUMBER
22: --R12 MOAC Changes--End
23: ) is
24: begin
25: insert into CN_DIMENSIONS_ALL_B (
26: DIMENSION_ID,
27: DESCRIPTION,
28: SOURCE_TABLE_ID,
29: CREATION_DATE,

Line 118: update CN_DIMENSIONS_ALL_B set

114: begin
115:
116: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
117:
118: update CN_DIMENSIONS_ALL_B set
119: DESCRIPTION = X_DESCRIPTION,
120: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
121: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
122: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 230: delete from CN_DIMENSIONS_ALL_B

226: delete from CN_DIMENSIONS_ALL_TL
227: where dimension_id = X_DIMENSION_ID
228: and ORG_ID = X_ORG_ID;
229:
230: delete from CN_DIMENSIONS_ALL_B
231: where dimension_id = X_DIMENSION_ID
232: and ORG_ID = X_ORG_ID;
233:
234: if (sql%notfound) then

Line 251: from CN_DIMENSIONS_ALL_B B

247: begin
248: delete from CN_DIMENSIONS_ALL_TL T
249: where not exists
250: (select NULL
251: from CN_DIMENSIONS_ALL_B B
252: where B.DIMENSION_ID = T.dimension_id
253: and B.ORG_ID = T.ORG_ID
254: );
255:

Line 342: UPDATE cn_dimensions_all_b SET

338: ELSE
339: user_id := 0;
340: END IF;
341: -- Load The record to _B table
342: UPDATE cn_dimensions_all_b SET
343: description = x_description,
344: source_table_id = x_source_table_id,
345: last_update_date = sysdate,
346: last_updated_by = user_id,

Line 353: INSERT INTO cn_dimensions_all_b

349: AND org_id = x_org_id; --R12 change
350:
351: IF (SQL%NOTFOUND) THEN
352: -- Insert new record to _B table
353: INSERT INTO cn_dimensions_all_b
354: (dimension_id,
355: org_id, -- R12 change
356: description,
357: source_table_id,