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.PO_DOCUMENT_TYPES_ALL_PKG dependencies on PO_DOCUMENT_TYPES_ALL_TL

Line 158: insert into PO_DOCUMENT_TYPES_ALL_TL (

154: P_CONTRACT_TEMPLATE_CODE , -- POC FPJ
155: p_use_contract_for_sourcing, --
156: p_include_noncatalog_flag); --
157:
158: insert into PO_DOCUMENT_TYPES_ALL_TL (
159: ORG_ID,
160: DOCUMENT_TYPE_CODE,
161: DOCUMENT_SUBTYPE,
162: TYPE_NAME,

Line 186: from PO_DOCUMENT_TYPES_ALL_TL T

182: from FND_LANGUAGES L
183: where L.INSTALLED_FLAG in ('I', 'B')
184: and not exists
185: (select NULL
186: from PO_DOCUMENT_TYPES_ALL_TL T
187: where T.DOCUMENT_TYPE_CODE = X_DOCUMENT_TYPE_CODE
188: and T.DOCUMENT_SUBTYPE = X_DOCUMENT_SUBTYPE
189: and T.LANGUAGE = L.LANGUAGE_CODE
190: and T.ORG_ID = X_ORG_ID) ; -- added

Line 296: from PO_DOCUMENT_TYPES_ALL_TL

292:
293: cursor c1 is select
294: TYPE_NAME,
295: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
296: from PO_DOCUMENT_TYPES_ALL_TL
297: where DOCUMENT_TYPE_CODE = X_DOCUMENT_TYPE_CODE
298: and DOCUMENT_SUBTYPE = X_DOCUMENT_SUBTYPE
299: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
300: and ORG_ID = X_ORG_ID --

Line 524: update PO_DOCUMENT_TYPES_ALL_TL set

520: if (sql%notfound) then
521: raise no_data_found;
522: end if;
523:
524: update PO_DOCUMENT_TYPES_ALL_TL set
525: TYPE_NAME = X_TYPE_NAME,
526: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
527: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
528: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 548: delete from PO_DOCUMENT_TYPES_ALL_TL

544: is
545: X_ORG_ID NUMBER; --
546: begin
547: X_ORG_ID := PO_MOAC_UTILS_PVT.get_current_org_id ; --
548: delete from PO_DOCUMENT_TYPES_ALL_TL
549: where DOCUMENT_TYPE_CODE = X_DOCUMENT_TYPE_CODE
550: and DOCUMENT_SUBTYPE = X_DOCUMENT_SUBTYPE
551: and ORG_ID = X_ORG_ID ; --
552:

Line 572: delete from PO_DOCUMENT_TYPES_ALL_TL T

568: is
569: -- Bug# 4899490: Removing X_ORG_ID, as there is no MOAC context needed
570: begin
571: -- Bug# 4899490: Removing X_ORG_ID, as there is no MOAC context needed
572: delete from PO_DOCUMENT_TYPES_ALL_TL T
573: where not exists
574: (select NULL
575: from PO_DOCUMENT_TYPES_ALL_B B
576: where B.DOCUMENT_TYPE_CODE = T.DOCUMENT_TYPE_CODE

Line 581: update PO_DOCUMENT_TYPES_ALL_TL T set (

577: and B.DOCUMENT_SUBTYPE = T.DOCUMENT_SUBTYPE
578: and B.ORG_ID = T.ORG_ID -- Bug# 4899490: Retaining 11.5.10 behavior
579: );
580:
581: update PO_DOCUMENT_TYPES_ALL_TL T set (
582: TYPE_NAME
583: ) = (select
584: B.TYPE_NAME
585: from PO_DOCUMENT_TYPES_ALL_TL B

Line 585: from PO_DOCUMENT_TYPES_ALL_TL B

581: update PO_DOCUMENT_TYPES_ALL_TL T set (
582: TYPE_NAME
583: ) = (select
584: B.TYPE_NAME
585: from PO_DOCUMENT_TYPES_ALL_TL B
586: where B.DOCUMENT_TYPE_CODE = T.DOCUMENT_TYPE_CODE
587: and B.DOCUMENT_SUBTYPE = T.DOCUMENT_SUBTYPE
588: and B.LANGUAGE = T.SOURCE_LANG
589: and B.ORG_ID = T.ORG_ID -- Bug# 4899490: Retaining 11.5.10 behavior

Line 599: from PO_DOCUMENT_TYPES_ALL_TL SUBB, PO_DOCUMENT_TYPES_ALL_TL SUBT

595: ) in (select
596: SUBT.DOCUMENT_TYPE_CODE,
597: SUBT.DOCUMENT_SUBTYPE,
598: SUBT.LANGUAGE
599: from PO_DOCUMENT_TYPES_ALL_TL SUBB, PO_DOCUMENT_TYPES_ALL_TL SUBT
600: where SUBB.DOCUMENT_TYPE_CODE = SUBT.DOCUMENT_TYPE_CODE
601: and SUBB.DOCUMENT_SUBTYPE = SUBT.DOCUMENT_SUBTYPE
602: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
603: and SUBB.ORG_ID = SUBT.ORG_ID -- Bug# 4899490: Retaining 11.5.10 behavior

Line 609: insert into PO_DOCUMENT_TYPES_ALL_TL (

605: or (SUBB.TYPE_NAME is null and SUBT.TYPE_NAME is not null)
606: or (SUBB.TYPE_NAME is not null and SUBT.TYPE_NAME is null)
607: ));
608:
609: insert into PO_DOCUMENT_TYPES_ALL_TL (
610: ORG_ID,
611: DOCUMENT_TYPE_CODE,
612: DOCUMENT_SUBTYPE,
613: TYPE_NAME,

Line 633: from PO_DOCUMENT_TYPES_ALL_TL B, FND_LANGUAGES L

629: B.CREATION_DATE,
630: B.LAST_UPDATE_LOGIN,
631: L.LANGUAGE_CODE,
632: B.SOURCE_LANG
633: from PO_DOCUMENT_TYPES_ALL_TL B, FND_LANGUAGES L
634: where L.INSTALLED_FLAG in ('I', 'B')
635: and B.LANGUAGE = userenv('LANG')
636: and not exists
637: (select NULL

Line 638: from PO_DOCUMENT_TYPES_ALL_TL T

634: where L.INSTALLED_FLAG in ('I', 'B')
635: and B.LANGUAGE = userenv('LANG')
636: and not exists
637: (select NULL
638: from PO_DOCUMENT_TYPES_ALL_TL T
639: where T.DOCUMENT_TYPE_CODE = B.DOCUMENT_TYPE_CODE
640: and T.DOCUMENT_SUBTYPE = B.DOCUMENT_SUBTYPE
641: and T.LANGUAGE = L.LANGUAGE_CODE
642: and T.ORG_ID = B.ORG_ID -- Bug# 4899490: Retaining 11.5.10 behavior

Line 671: from PO_DOCUMENT_TYPES_ALL_TL

667: -- last_updated_by to 1 when it is -1 so that the record can be updated.
668:
669: select DECODE(LAST_UPDATED_BY, -1, 1, LAST_UPDATED_BY), LAST_UPDATE_DATE
670: into db_luby, db_ludate
671: from PO_DOCUMENT_TYPES_ALL_TL
672: where document_type_code = X_DOCUMENT_TYPE_CODE
673: and document_subtype = X_DOCUMENT_SUBTYPE
674: and ( (X_ORG_ID is null and org_id = -3113 )
675: or (X_ORG_ID is not null and org_id = X_ORG_ID))

Line 681: update PO_DOCUMENT_TYPES_ALL_TL set

677:
678: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
679: db_ludate, X_CUSTOM_MODE)) then
680:
681: update PO_DOCUMENT_TYPES_ALL_TL set
682: type_name = X_TYPE_NAME ,
683: last_update_date = f_ludate,
684: last_updated_by = f_luby,
685: last_update_login = 0,

Line 753: This column is in table PO_DOCUMENT_TYPES_ALL_TL.

749:
750: --Bug 6810625 Start
751: /* Changed table in query from PO_DOCUMENT_TYPES_ALL_B to PO_DOCUMENT_TYPES_ALL_VL
752: because table PO_DOCUMENT_TYPES_ALL_B doesnot contain TYPE_NAME Column.
753: This column is in table PO_DOCUMENT_TYPES_ALL_TL.
754: but view PO_DOCUMENT_TYPES_ALL_VL contains this column as its queries from both
755: the tables PO_DOCUMENT_TYPES_ALL_B and PO_DOCUMENT_TYPES_ALL_TL. */
756:
757: --rec PO_DOCUMENT_TYPES_ALL_B%Rowtype; -- Bug6086648 FP:Bug 5985709

Line 755: the tables PO_DOCUMENT_TYPES_ALL_B and PO_DOCUMENT_TYPES_ALL_TL. */

751: /* Changed table in query from PO_DOCUMENT_TYPES_ALL_B to PO_DOCUMENT_TYPES_ALL_VL
752: because table PO_DOCUMENT_TYPES_ALL_B doesnot contain TYPE_NAME Column.
753: This column is in table PO_DOCUMENT_TYPES_ALL_TL.
754: but view PO_DOCUMENT_TYPES_ALL_VL contains this column as its queries from both
755: the tables PO_DOCUMENT_TYPES_ALL_B and PO_DOCUMENT_TYPES_ALL_TL. */
756:
757: --rec PO_DOCUMENT_TYPES_ALL_B%Rowtype; -- Bug6086648 FP:Bug 5985709
758: rec PO_DOCUMENT_TYPES_ALL_VL%Rowtype;
759: --End Bug 6810625

Line 784: from PO_DOCUMENT_TYPES_ALL_TL

780: -- last_updated_by to 1 when it is -1 so that the record can be updated.
781:
782: select DECODE(LAST_UPDATED_BY, -1, 1, LAST_UPDATED_BY), LAST_UPDATE_DATE
783: into db_luby, db_ludate
784: from PO_DOCUMENT_TYPES_ALL_TL
785: where document_type_code = X_DOCUMENT_TYPE_CODE
786: and document_subtype = X_DOCUMENT_SUBTYPE
787: and ( (X_ORG_ID is null and org_id = -3113 )
788: or (X_ORG_ID is not null and org_id = X_ORG_ID))