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_MODULES_PKG dependencies on CN_MODULES

Line 1: PACKAGE BODY CN_MODULES_PKG AS

1: PACKAGE BODY CN_MODULES_PKG AS
2: -- $Header: cnsymodb.pls 120.6 2006/01/13 04:28:43 apink noship $
3:
4: -- Procedure Name
5: -- sync_module

Line 24: x_module_type cn_modules.module_type%TYPE;

20: x_module_id NUMBER,
21: x_module_status IN OUT NOCOPY VARCHAR2) IS
22:
23:
24: x_module_type cn_modules.module_type%TYPE;
25: x_rc BOOLEAN;
26: x_temp_id cn_modules.module_id%TYPE;
27:
28: BEGIN

Line 26: x_temp_id cn_modules.module_id%TYPE;

22:
23:
24: x_module_type cn_modules.module_type%TYPE;
25: x_rc BOOLEAN;
26: x_temp_id cn_modules.module_id%TYPE;
27:
28: BEGIN
29:
30: SELECT module_type, module_status

Line 32: FROM cn_modules

28: BEGIN
29:
30: SELECT module_type, module_status
31: INTO x_module_type, x_module_status
32: FROM cn_modules
33: WHERE module_id = x_module_id ;
34:
35: END sync_module;
36:

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 132: INSERT INTO CN_MODULES_ALL_TL (

128: X_LAST_UPDATE_LOGIN,
129: X_ORG_ID -- Modified For R12 MOAC
130: );
131:
132: INSERT INTO CN_MODULES_ALL_TL (
133: MODULE_ID,
134: NAME,
135: LAST_UPDATE_DATE,
136: LAST_UPDATED_BY,

Line 158: FROM CN_MODULES_ALL_TL T

154: FROM FND_LANGUAGES L
155: WHERE L.INSTALLED_FLAG IN ('I', 'B')
156: AND NOT EXISTS
157: (SELECT NULL
158: FROM CN_MODULES_ALL_TL T
159: WHERE T.MODULE_ID = X_MODULE_ID
160: AND T.LANGUAGE = L.language_code
161: AND T.ORG_ID = X_ORG_ID
162: );

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 214: FROM CN_MODULES_ALL_TL

210:
211: CURSOR c1 IS SELECT
212: NAME,
213: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
214: FROM CN_MODULES_ALL_TL
215: WHERE MODULE_ID = x_module_id AND
216: ORG_ID = X_ORG_ID
217: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG)
218: FOR UPDATE OF MODULE_ID NOWAIT;

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 298: FROM cn_modules_all_tl

294: org_id = X_ORG_ID;
295:
296: CURSOR cur_tl IS
297: SELECT NAME, last_update_date, last_updated_by,last_update_login
298: FROM cn_modules_all_tl
299: WHERE module_id = x_module_id AND
300: userenv('LANG') IN (LANGUAGE, SOURCE_LANG) AND
301: org_id = X_ORG_ID;
302:

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 431: UPDATE CN_MODULES_ALL_TL SET

427: SELECT Decode(X_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, rec_tl.LAST_UPDATE_LOGIN,
428: Ltrim(Rtrim(X_LAST_UPDATE_LOGIN)))
429: INTO rec_tl.last_update_login FROM sys.dual;
430:
431: UPDATE CN_MODULES_ALL_TL SET
432: NAME = rec_tl.NAME,
433: LAST_UPDATE_DATE = rec_tl.LAST_UPDATE_DATE,
434: LAST_UPDATED_BY = rec_tl.LAST_UPDATED_BY,
435: LAST_UPDATE_LOGIN = rec_tl.LAST_UPDATE_LOGIN,

Line 461: DELETE FROM CN_MODULES_ALL_TL

457: X_MODULE_ID IN NUMBER,
458: X_ORG_ID IN NUMBER
459: ) IS
460: BEGIN
461: DELETE FROM CN_MODULES_ALL_TL
462: WHERE MODULE_ID = x_module_id AND
463: ORG_ID = X_ORG_ID;
464:
465: IF (SQL%NOTFOUND) THEN

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 481: DELETE FROM CN_MODULES_ALL_TL T

477:
478: PROCEDURE ADD_LANGUAGE
479: IS
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

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 488: UPDATE CN_MODULES_ALL_TL T SET (

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 (
489: NAME
490: ) = (SELECT
491: B.NAME
492: FROM CN_MODULES_ALL_TL B

Line 492: FROM CN_MODULES_ALL_TL B

488: UPDATE CN_MODULES_ALL_TL T SET (
489: NAME
490: ) = (SELECT
491: B.NAME
492: FROM CN_MODULES_ALL_TL B
493: WHERE B.MODULE_ID = T.MODULE_ID
494: AND B.LANGUAGE = T.source_lang
495: AND B.org_id = T.org_id)
496: WHERE (

Line 502: FROM CN_MODULES_ALL_TL SUBB, CN_MODULES_ALL_TL SUBT

498: T.LANGUAGE
499: ) IN (SELECT
500: SUBT.MODULE_ID,
501: SUBT.LANGUAGE
502: FROM CN_MODULES_ALL_TL SUBB, CN_MODULES_ALL_TL SUBT
503: WHERE SUBB.MODULE_ID = SUBT.MODULE_ID
504: AND SUBB.LANGUAGE = SUBT.source_lang
505: AND SUBB.ORG_ID = SUBT.ORG_ID
506: AND (SUBB.NAME <> SUBT.NAME

Line 511: INSERT INTO CN_MODULES_ALL_TL (

507: OR (SUBB.NAME IS NULL AND SUBT.NAME IS NOT NULL)
508: OR (SUBB.NAME IS NOT NULL AND SUBT.NAME IS NULL)
509: ));
510:
511: INSERT INTO CN_MODULES_ALL_TL (
512: ORG_ID,
513: MODULE_ID,
514: NAME,
515: LAST_UPDATE_DATE,

Line 533: FROM CN_MODULES_ALL_TL B, FND_LANGUAGES L

529: B.CREATION_DATE,
530: B.CREATED_BY,
531: L.LANGUAGE_CODE,
532: B.SOURCE_LANG
533: FROM CN_MODULES_ALL_TL B, FND_LANGUAGES L
534: WHERE L.INSTALLED_FLAG IN ('I', 'B')
535: AND B.LANGUAGE = userenv('LANG')
536: AND NOT EXISTS
537: (SELECT NULL

Line 538: FROM CN_MODULES_ALL_TL T

534: WHERE L.INSTALLED_FLAG IN ('I', 'B')
535: AND B.LANGUAGE = userenv('LANG')
536: AND NOT EXISTS
537: (SELECT NULL
538: FROM CN_MODULES_ALL_TL T
539: WHERE T.MODULE_ID = B.MODULE_ID
540: AND T.LANGUAGE = L.language_code
541: AND T.ORG_ID = B.ORG_ID);
542: END ADD_LANGUAGE;

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,

Line 642: UPDATE CN_MODULES_ALL_TL SET

638: x_org_id
639: );
640: END IF;
641: -- Load The record to _TL table
642: UPDATE CN_MODULES_ALL_TL SET
643: NAME = X_NAME,
644: LAST_UPDATE_DATE = sysdate,
645: LAST_UPDATED_BY = user_id,
646: LAST_UPDATE_LOGIN = 0,

Line 654: INSERT INTO CN_MODULES_ALL_TL

650: AND org_id = x_org_id;
651:
652: IF (SQL%NOTFOUND) THEN
653: -- Insert new record to _TL table
654: INSERT INTO CN_MODULES_ALL_TL
655: (MODULE_ID,
656: NAME,
657: LAST_UPDATE_DATE,
658: LAST_UPDATED_BY,

Line 678: FROM CN_MODULES_ALL_TL T

674: FROM FND_LANGUAGES L
675: WHERE L.INSTALLED_FLAG IN ('I', 'B')
676: AND NOT EXISTS
677: (SELECT NULL
678: FROM CN_MODULES_ALL_TL T
679: WHERE T.MODULE_ID = X_MODULE_ID
680: AND T.LANGUAGE = L.LANGUAGE_CODE);
681: END IF;
682: << end_load_row >>

Line 708: UPDATE cn_modules_all_tl SET

704: ELSE
705: user_id := 0;
706: END IF;
707: -- Update the translation
708: UPDATE cn_modules_all_tl SET
709: NAME = x_name,
710: last_update_date = sysdate,
711: last_updated_by = user_id,
712: last_update_login = 0,

Line 721: END cn_modules_pkg;

717: << end_translate_row >>
718: NULL;
719: END TRANSLATE_ROW ;
720:
721: END cn_modules_pkg;