DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on PO_DRAFTS

Line 1322: l_draft_type PO_DRAFTS.DRAFT_TYPE%TYPE; -- PAR Approval

1318: /* Bug 2788683 end */
1319: l_supplier po_vendors.vendor_name%TYPE; --
1320: l_draft_id NUMBER;
1321: l_doc_sub_type_code po_action_history.object_sub_type_code%TYPE; -- CLM Apprvl
1322: l_draft_type PO_DRAFTS.DRAFT_TYPE%TYPE; -- PAR Approval
1323:
1324: BEGIN
1325:
1326: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);

Line 1721: l_draft_type PO_DRAFTS.DRAFT_TYPE%TYPE; -- PAR Approval

1717: --15859236 start
1718: l_new_recipient_name wf_users.name%type;
1719: l_new_recipient_display_name wf_users.display_name%type;
1720: --15859236 end
1721: l_draft_type PO_DRAFTS.DRAFT_TYPE%TYPE; -- PAR Approval
1722: begin
1723:
1724: --Start of code changes for inserting the delegate action in Action History. Bug 13951919 fix
1725: l_progress := '001';

Line 2614: l_draft_type PO_DRAFTS.DRAFT_TYPE%TYPE; -- PAR Approval

2610: and document_subtype = p_doc_subtype;
2611:
2612: l_document_id PO_HEADERS_ALL.po_header_id%TYPE; --
2613: l_draft_id NUMBER; -- CLM Apprvl
2614: l_draft_type PO_DRAFTS.DRAFT_TYPE%TYPE; -- PAR Approval
2615:
2616: BEGIN
2617: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 001, user name: '
2618: || username;