DBA Data[Home] [Help]

APPS.PO_CHANGEORDERWF_PVT dependencies on PO_DOCUMENT_TYPES_V

Line 1166: l_workflow_process PO_DOCUMENT_TYPES_V.WF_APPROVAL_PROCESS%TYPE;

1162: l_document_subtype po_document_types_all.DOCUMENT_SUBTYPE%TYPE;
1163: l_seq number;
1164: l_item_key po_headers_all.wf_item_key%TYPE;
1165: l_item_type po_headers_all.wf_item_type%TYPE;
1166: l_workflow_process PO_DOCUMENT_TYPES_V.WF_APPROVAL_PROCESS%TYPE;
1167:
1168: /* Bug 2810156 BEGIN*/
1169: l_orig_itemtype po_headers.wf_item_type%TYPE;
1170: l_orig_itemkey po_headers.wf_item_key%TYPE;

Line 1292: from PO_DOCUMENT_TYPES_V

1288: wf_approval_process
1289: into
1290: l_Item_Type,
1291: l_Workflow_Process
1292: from PO_DOCUMENT_TYPES_V
1293: where DOCUMENT_TYPE_CODE = l_Document_Type_Code
1294: and DOCUMENT_SUBTYPE = l_Document_Subtype;
1295:
1296: select to_char(PO_WF_ITEMKEY_S.NEXTVAL) into l_seq from sys.dual;