DBA Data[Home] [Help]

APPS.PO_CHANGEORDERWF_PVT dependencies on PO_DOCUMENT_TYPES_V

Line 1261: l_workflow_process PO_DOCUMENT_TYPES_V.WF_APPROVAL_PROCESS%TYPE;

1257: l_document_subtype po_document_types_all.DOCUMENT_SUBTYPE%TYPE;
1258: l_seq number;
1259: l_item_key po_headers_all.wf_item_key%TYPE;
1260: l_item_type po_headers_all.wf_item_type%TYPE;
1261: l_workflow_process PO_DOCUMENT_TYPES_V.WF_APPROVAL_PROCESS%TYPE;
1262:
1263: /* Bug 2810156 BEGIN*/
1264: l_orig_itemtype po_headers.wf_item_type%TYPE;
1265: l_orig_itemkey po_headers.wf_item_key%TYPE;

Line 1399: from PO_DOCUMENT_TYPES_V

1395: wf_approval_process
1396: into
1397: l_Item_Type,
1398: l_Workflow_Process
1399: from PO_DOCUMENT_TYPES_V
1400: where DOCUMENT_TYPE_CODE = l_Document_Type_Code
1401: and DOCUMENT_SUBTYPE = l_Document_Subtype;
1402:
1403: select to_char(PO_WF_ITEMKEY_S.NEXTVAL) into l_seq from sys.dual;