APPS.POR_UTIL_PKG dependencies on PO_DOCUMENT_TYPES

Line 1599: FROM po_document_types

1595: wf_approval_process
1596: INTO
1597: p_item_type,
1598: p_workflow_process
1599: FROM po_document_types
1600: WHERE document_type_code = p_document_type
1601: AND document_subtype = p_document_subtype ;
1602:
1603: PO_REQAPPROVAL_INIT1.Start_WF_Process

Line 4176: FROM po_document_types

4172:
4173:
4174: SELECT Nvl(CAN_PREPARER_APPROVE_FLAG,'N')
4175: INTO p_owner_can_approve
4176: FROM po_document_types
4177: WHERE DOCUMENT_TYPE_CODE = 'REQUISITION'
4178: AND DOCUMENT_SUBTYPE = p_document_type ;
4179:
4180:

Line 5936: l_workflow_process po_document_types.wf_approval_process%type;

5932: p_error_code OUT NOCOPY varchar2) IS
5933: l_progress varchar2(100);
5934: l_seq_for_item_key varchar2(25);
5935: l_itemkey varchar2(60);
5936: l_workflow_process po_document_types.wf_approval_process%type;
5937: l_itemtype po_document_types.wf_approval_itemtype%type;
5938: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
5939: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
5940: l_po_email_performer WF_USERS.NAME%TYPE;

Line 5937: l_itemtype po_document_types.wf_approval_itemtype%type;

5933: l_progress varchar2(100);
5934: l_seq_for_item_key varchar2(25);
5935: l_itemkey varchar2(60);
5936: l_workflow_process po_document_types.wf_approval_process%type;
5937: l_itemtype po_document_types.wf_approval_itemtype%type;
5938: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
5939: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
5940: l_po_email_performer WF_USERS.NAME%TYPE;
5941: l_email_address WF_USERS.NAME%TYPE;

Line 6084: l_itemtype po_document_types.wf_approval_itemtype%type;

6080: l_document_id number;
6081: l_document blob;
6082: l_document_length number;
6083: l_itemkey varchar2(60);
6084: l_itemtype po_document_types.wf_approval_itemtype%type;
6085: l_message FND_NEW_MESSAGES.message_text%TYPE;
6086:
6087: x_progress varchar2(300);
6088: