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.AMW_PROCESS_NAMES_PKG dependencies on AMW_PROCESS

Line 1: package body AMW_PROCESS_NAMES_PKG as

1: package body AMW_PROCESS_NAMES_PKG as
2: /* $Header: amwprnmb.pls 120.1 2005/06/28 14:26:55 appldev noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 61: cursor C is select ROWID from AMW_PROCESS

57: X_LAST_UPDATE_DATE in DATE,
58: X_LAST_UPDATED_BY in NUMBER,
59: X_LAST_UPDATE_LOGIN in NUMBER
60: ) is
61: cursor C is select ROWID from AMW_PROCESS
62: where PROCESS_REV_ID = X_PROCESS_REV_ID
63: ;
64: begin
65: insert into AMW_PROCESS (

Line 65: insert into AMW_PROCESS (

61: cursor C is select ROWID from AMW_PROCESS
62: where PROCESS_REV_ID = X_PROCESS_REV_ID
63: ;
64: begin
65: insert into AMW_PROCESS (
66: CLASSIFICATION,
67: PROCESS_CODE,
68: REVISION_NUMBER,
69: START_DATE,

Line 173: insert into AMW_PROCESS_NAMES_TL (

169: X_LAST_UPDATED_BY,
170: X_LAST_UPDATE_LOGIN
171: );
172:
173: insert into AMW_PROCESS_NAMES_TL (
174: PROCESS_ID,
175: REVISION_NUMBER,
176: DISPLAY_NAME,
177: DESCRIPTION,

Line 205: from AMW_PROCESS_NAMES_TL T

201: from FND_LANGUAGES L
202: where L.INSTALLED_FLAG in ('I', 'B')
203: and not exists
204: (select NULL
205: from AMW_PROCESS_NAMES_TL T
206: where T.PROCESS_REV_ID = X_PROCESS_REV_ID
207: and T.LANGUAGE = L.LANGUAGE_CODE);
208:
209: open c;

Line 317: from AMW_PROCESS

313: RISK_COUNT,
314: ORG_COUNT,
315: FINANCE_OWNER_ID,
316: APPLICATION_OWNER_ID
317: from AMW_PROCESS
318: where PROCESS_REV_ID = X_PROCESS_REV_ID
319: for update of PROCESS_REV_ID nowait;
320: recinfo c%rowtype;
321:

Line 326: from AMW_PROCESS_NAMES_TL

322: cursor c1 is select
323: DISPLAY_NAME,
324: DESCRIPTION,
325: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
326: from AMW_PROCESS_NAMES_TL
327: where PROCESS_REV_ID = X_PROCESS_REV_ID
328: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
329: for update of PROCESS_REV_ID nowait;
330: begin

Line 507: update AMW_PROCESS set

503: X_LAST_UPDATED_BY in NUMBER,
504: X_LAST_UPDATE_LOGIN in NUMBER
505: ) is
506: begin
507: update AMW_PROCESS set
508: CLASSIFICATION = X_CLASSIFICATION,
509: PROCESS_CODE = X_PROCESS_CODE,
510: REVISION_NUMBER = X_REVISION_NUMBER,
511: START_DATE = X_START_DATE,

Line 563: update AMW_PROCESS_NAMES_TL set

559: if (sql%notfound) then
560: raise no_data_found;
561: end if;
562:
563: update AMW_PROCESS_NAMES_TL set
564: DISPLAY_NAME = X_DISPLAY_NAME,
565: DESCRIPTION = X_DESCRIPTION,
566: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
567: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 582: delete from AMW_PROCESS_NAMES_TL

578: procedure DELETE_ROW (
579: X_PROCESS_REV_ID in NUMBER
580: ) is
581: begin
582: delete from AMW_PROCESS_NAMES_TL
583: where PROCESS_REV_ID = X_PROCESS_REV_ID;
584:
585: if (sql%notfound) then
586: raise no_data_found;

Line 589: delete from AMW_PROCESS

585: if (sql%notfound) then
586: raise no_data_found;
587: end if;
588:
589: delete from AMW_PROCESS
590: where PROCESS_REV_ID = X_PROCESS_REV_ID;
591:
592: if (sql%notfound) then
593: raise no_data_found;

Line 600: delete from AMW_PROCESS_NAMES_TL T

596:
597: procedure ADD_LANGUAGE
598: is
599: begin
600: delete from AMW_PROCESS_NAMES_TL T
601: where not exists
602: (select NULL
603: from AMW_PROCESS B
604: where B.PROCESS_REV_ID = T.PROCESS_REV_ID

Line 603: from AMW_PROCESS B

599: begin
600: delete from AMW_PROCESS_NAMES_TL T
601: where not exists
602: (select NULL
603: from AMW_PROCESS B
604: where B.PROCESS_REV_ID = T.PROCESS_REV_ID
605: );
606:
607: update AMW_PROCESS_NAMES_TL T set (

Line 607: update AMW_PROCESS_NAMES_TL T set (

603: from AMW_PROCESS B
604: where B.PROCESS_REV_ID = T.PROCESS_REV_ID
605: );
606:
607: update AMW_PROCESS_NAMES_TL T set (
608: DISPLAY_NAME,
609: DESCRIPTION
610: ) = (select
611: B.DISPLAY_NAME,

Line 613: from AMW_PROCESS_NAMES_TL B

609: DESCRIPTION
610: ) = (select
611: B.DISPLAY_NAME,
612: B.DESCRIPTION
613: from AMW_PROCESS_NAMES_TL B
614: where B.PROCESS_REV_ID = T.PROCESS_REV_ID
615: and B.LANGUAGE = T.SOURCE_LANG)
616: where (
617: T.PROCESS_REV_ID,

Line 622: from AMW_PROCESS_NAMES_TL SUBB, AMW_PROCESS_NAMES_TL SUBT

618: T.LANGUAGE
619: ) in (select
620: SUBT.PROCESS_REV_ID,
621: SUBT.LANGUAGE
622: from AMW_PROCESS_NAMES_TL SUBB, AMW_PROCESS_NAMES_TL SUBT
623: where SUBB.PROCESS_REV_ID = SUBT.PROCESS_REV_ID
624: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
625: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
626: or (SUBB.DISPLAY_NAME is null and SUBT.DISPLAY_NAME is not null)

Line 633: insert into AMW_PROCESS_NAMES_TL (

629: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
630: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
631: ));
632:
633: insert into AMW_PROCESS_NAMES_TL (
634: PROCESS_ID,
635: REVISION_NUMBER,
636: DISPLAY_NAME,
637: DESCRIPTION,

Line 661: from AMW_PROCESS_NAMES_TL B, FND_LANGUAGES L

657: B.OBJECT_VERSION_NUMBER,
658: B.PROCESS_REV_ID,
659: L.LANGUAGE_CODE,
660: B.SOURCE_LANG
661: from AMW_PROCESS_NAMES_TL B, FND_LANGUAGES L
662: where L.INSTALLED_FLAG in ('I', 'B')
663: and B.LANGUAGE = userenv('LANG')
664: and not exists
665: (select NULL

Line 666: from AMW_PROCESS_NAMES_TL T

662: where L.INSTALLED_FLAG in ('I', 'B')
663: and B.LANGUAGE = userenv('LANG')
664: and not exists
665: (select NULL
666: from AMW_PROCESS_NAMES_TL T
667: where T.PROCESS_REV_ID = B.PROCESS_REV_ID
668: and T.LANGUAGE = L.LANGUAGE_CODE);
669: end ADD_LANGUAGE;
670:

Line 687: delete from amw_process where process_rev_id = x_process_rev_id;

683: begin
684: l_OWNER := fnd_load_util.owner_id(X_OWNER);
685: l_last_update_date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
686:
687: delete from amw_process where process_rev_id = x_process_rev_id;
688: delete from amw_process_names_tl where process_rev_id = x_process_rev_id;
689:
690: INSERT_ROW (
691: X_ROWID => L_ROWID,

Line 688: delete from amw_process_names_tl where process_rev_id = x_process_rev_id;

684: l_OWNER := fnd_load_util.owner_id(X_OWNER);
685: l_last_update_date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
686:
687: delete from amw_process where process_rev_id = x_process_rev_id;
688: delete from amw_process_names_tl where process_rev_id = x_process_rev_id;
689:
690: INSERT_ROW (
691: X_ROWID => L_ROWID,
692: X_PROCESS_REV_ID => x_process_rev_id,

Line 807: end AMW_PROCESS_NAMES_PKG;

803: X_LAST_UPDATE_LOGIN => 0 );
804: */
805: end load_seed_data;
806:
807: end AMW_PROCESS_NAMES_PKG;