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_B

Line 55: cursor C is select ROWID from PO_DOCUMENT_TYPES_ALL_B

51: p_org_id IN NUMBER
52: )
53: is
54: X_ORG_ID NUMBER;
55: cursor C is select ROWID from PO_DOCUMENT_TYPES_ALL_B
56: where DOCUMENT_TYPE_CODE = X_DOCUMENT_TYPE_CODE
57: and DOCUMENT_SUBTYPE = X_DOCUMENT_SUBTYPE
58: ;
59: begin

Line 63: insert into PO_DOCUMENT_TYPES_ALL_B (

59: begin
60:
61: X_ORG_ID := p_org_id;
62:
63: insert into PO_DOCUMENT_TYPES_ALL_B (
64: ORG_ID,
65: WF_CREATEDOC_ITEMTYPE,
66: DOCUMENT_TYPE_CODE,
67: DOCUMENT_SUBTYPE,

Line 286: from PO_DOCUMENT_TYPES_ALL_B

282: DOCUMENT_TEMPLATE_CODE, -- Bug # 3274065
283: CONTRACT_TEMPLATE_CODE, -- Bug # 3274065
284: USE_CONTRACT_FOR_SOURCING_FLAG, --
285: INCLUDE_NONCATALOG_FLAG --
286: from PO_DOCUMENT_TYPES_ALL_B
287: where DOCUMENT_TYPE_CODE = X_DOCUMENT_TYPE_CODE
288: and DOCUMENT_SUBTYPE = X_DOCUMENT_SUBTYPE
289: and org_id = X_ORG_ID --
290: for update of DOCUMENT_TYPE_CODE nowait;

Line 472: update PO_DOCUMENT_TYPES_ALL_B set

468: begin
469: -- Bug 5081289: Passed org id instead of using session context
470: X_ORG_ID := p_org_id;
471:
472: update PO_DOCUMENT_TYPES_ALL_B set
473: WF_CREATEDOC_ITEMTYPE = X_WF_CREATEDOC_ITEMTYPE,
474: ARCHIVE_EXTERNAL_REVISION_CODE = X_ARCHIVE_EXTERNAL_REVISION_CO,
475: CAN_PREPARER_APPROVE_FLAG = X_CAN_PREPARER_APPROVE_FLAG,
476: FORWARDING_MODE_CODE = X_FORWARDING_MODE_CODE,

Line 557: delete from PO_DOCUMENT_TYPES_ALL_B

553: if (sql%notfound) then
554: raise no_data_found;
555: end if;
556:
557: delete from PO_DOCUMENT_TYPES_ALL_B
558: where DOCUMENT_TYPE_CODE = X_DOCUMENT_TYPE_CODE
559: and DOCUMENT_SUBTYPE = X_DOCUMENT_SUBTYPE
560: and ORG_ID = X_ORG_ID ; --
561:

Line 575: from PO_DOCUMENT_TYPES_ALL_B B

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
577: and B.DOCUMENT_SUBTYPE = T.DOCUMENT_SUBTYPE
578: and B.ORG_ID = T.ORG_ID -- Bug# 4899490: Retaining 11.5.10 behavior
579: );

Line 751: /* Changed table in query from PO_DOCUMENT_TYPES_ALL_B to PO_DOCUMENT_TYPES_ALL_VL

747: db_luby number; -- entity owner in db
748: db_ludate date; -- entity update date in db
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. */

Line 752: because table PO_DOCUMENT_TYPES_ALL_B doesnot contain TYPE_NAME Column.

748: db_ludate date; -- entity update date in db
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:

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 757: --rec PO_DOCUMENT_TYPES_ALL_B%Rowtype; -- Bug6086648 FP:Bug 5985709

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
760:
761: begin