APPS.CN_MODULES_PKG dependencies on CN_MODULES_ALL_B

Line 88: CURSOR C IS SELECT ROWID FROM CN_MODULES_ALL_B

84: X_LAST_UPDATED_BY IN NUMBER,
85: X_LAST_UPDATE_LOGIN IN NUMBER,
86: X_ORG_ID IN NUMBER) IS -- Modified For R12 MOAC
87:
88: CURSOR C IS SELECT ROWID FROM CN_MODULES_ALL_B
89: WHERE MODULE_ID = x_module_id;
90:
91: BEGIN
92: INSERT INTO CN_MODULES_ALL_B(

Line 92: INSERT INTO CN_MODULES_ALL_B(

88: CURSOR C IS SELECT ROWID FROM CN_MODULES_ALL_B
89: WHERE MODULE_ID = x_module_id;
90:
91: BEGIN
92: INSERT INTO CN_MODULES_ALL_B(
93: MODULE_ID,
94: MODULE_TYPE,
95: REPOSITORY_ID,
96: DESCRIPTION,

Line 205: FROM CN_MODULES_ALL_B

201: LAST_MODIFICATION,
202: LAST_SYNCHRONIZATION,
203: OUTPUT_FILENAME,
204: COLLECT_FLAG
205: FROM CN_MODULES_ALL_B
206: WHERE MODULE_ID = x_module_id AND
207: ORG_ID = X_ORG_ID
208: FOR UPDATE OF MODULE_ID NOWAIT;
209: recinfo c%ROWTYPE;

Line 292: FROM cn_modules_all_b

288: ) IS
289:
290: CURSOR cur_b IS
291: SELECT *
292: FROM cn_modules_all_b
293: WHERE module_id = x_module_id AND
294: org_id = X_ORG_ID;
295:
296: CURSOR cur_tl IS

Line 378: UPDATE CN_MODULES_ALL_B SET

374: SELECT Decode(X_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, rec_b.LAST_UPDATE_LOGIN,
375: Ltrim(Rtrim(X_LAST_UPDATE_LOGIN)))
376: INTO rec_b.last_update_login FROM sys.dual;
377:
378: UPDATE CN_MODULES_ALL_B SET
379: MODULE_TYPE = rec_b.MODULE_TYPE,
380: REPOSITORY_ID = rec_b.REPOSITORY_ID,
381: DESCRIPTION = rec_b.DESCRIPTION,
382: PARENT_MODULE_ID = rec_b.PARENT_MODULE_ID,

Line 469: DELETE FROM CN_MODULES_ALL_B

465: IF (SQL%NOTFOUND) THEN
466: RAISE no_data_found;
467: END IF;
468:
469: DELETE FROM CN_MODULES_ALL_B
470: WHERE MODULE_ID = x_module_id AND
471: ORG_ID = X_ORG_ID;
472:
473: IF (SQL%NOTFOUND) THEN

Line 484: FROM CN_MODULES_ALL_B B

480: BEGIN
481: DELETE FROM CN_MODULES_ALL_TL T
482: WHERE NOT EXISTS
483: (SELECT NULL
484: FROM CN_MODULES_ALL_B B
485: WHERE B.MODULE_ID = T.module_id
486: AND B.org_id = T.org_id);
487:
488: UPDATE CN_MODULES_ALL_TL T SET (

Line 581: UPDATE CN_MODULES_ALL_B SET

577: ELSE
578: user_id := 0;
579: END IF;
580: -- Load The record to _B table
581: UPDATE CN_MODULES_ALL_B SET
582: DESCRIPTION = X_DESCRIPTION,
583: MODULE_TYPE = X_MODULE_TYPE,
584: MODULE_STATUS = X_MODULE_STATUS,
585: EVENT_ID = X_EVENT_ID,

Line 601: INSERT INTO cn_modules_all_b

597: AND org_id = x_org_id;
598:
599: IF (SQL%NOTFOUND) THEN
600: -- Insert new record to _B table
601: INSERT INTO cn_modules_all_b
602: (MODULE_ID,
603: DESCRIPTION,
604: MODULE_TYPE,
605: MODULE_STATUS,