APPS.AP_WFAPPROVAL_PKG dependencies on AP_INVOICES_ALL

Line 149: FROM ap_invoices_all

145: --in the invoice workbench
146:
147: SELECT org_id
148: INTO l_org_id
149: FROM ap_invoices_all
150: WHERE invoice_id = substr(itemkey, 1, instr(itemkey,'_')-1);
151:
152: -- lets go ahead and set the wf attribute
153: WF_ENGINE.SETITEMATTRNumber(itemtype,

Line 365: l_amount ap_invoices_all.invoice_amount%TYPE;

361: l_invoice_id NUMBER(15);
362: l_result VARCHAR2(50);
363: l_hist_id NUMBER(15);
364: l_comments VARCHAR2(240);
365: l_amount ap_invoices_all.invoice_amount%TYPE;
366: l_status VARCHAR2(50);
367: l_org_id NUMBER(15);
368: l_user_id NUMBER(15);
369: l_login_id NUMBER(15);

Line 490: l_amount ap_invoices_all.invoice_amount%TYPE;

486: l_org_id NUMBER(15);
487: l_comments VARCHAR2(240);
488: l_iteration NUMBER(9);
489: l_hist_id NUMBER(15);
490: l_amount ap_invoices_all.invoice_amount%TYPE;
491:
492: BEGIN
493: --Get attribute values to create record in the history table
494:

Line 575: l_amount ap_invoices_all.invoice_amount%TYPE;

571: p_iteration IN NUMBER,
572: p_org_id IN NUMBER,
573: p_status IN VARCHAR2) IS
574: l_hist_id NUMBER;
575: l_amount ap_invoices_all.invoice_amount%TYPE;
576: BEGIN
577: --insert into the history table
578: SELECT AP_INV_APRVL_HIST_S.nextval
579: INTO l_hist_id

Line 584: FROM AP_INVOICES_ALL

580: FROM dual;
581:
582: SELECT invoice_amount
583: INTO l_amount
584: FROM AP_INVOICES_ALL
585: WHERE invoice_id = p_invoice_id;
586:
587: INSERT INTO AP_INV_APRVL_HIST
588: (APPROVAL_HISTORY_ID

Line 743: l_amount ap_invoices_all.invoice_amount%TYPE;

739: l_description VARCHAR2(240);
740: l_currency VARCHAR2(15);
741: l_vendor_id NUMBER(15);
742: l_vendor_site_id NUMBER(15);
743: l_amount ap_invoices_all.invoice_amount%TYPE;
744: l_invoice_num VARCHAR(50);
745: l_invoice_date DATE;
746: l_prev_com VARCHAR2(240);
747: l_dsp_format VARCHAR2(50);

Line 763: FROM ap_invoices_all

759: --in the invoice workbench
760:
761: SELECT org_id
762: INTO l_org_id
763: FROM ap_invoices_all
764: WHERE invoice_id = substr(itemkey, 1, instr(itemkey,'_')-1);
765:
766: -- lets go ahead and set the wf attribute again
767: WF_ENGINE.SETITEMATTRNumber(itemtype,

Line 1041: FROM ap_invoices_all

1037: SELECT organization
1038: INTO l_return_val
1039: FROM PA_EXP_ORGS_IT
1040: WHERE organization_id=(SELECT expenditure_organization_id
1041: FROM ap_invoices_all
1042: WHERE invoice_id = p_invoice_id);
1043:
1044: ELSIF p_attribute_name = 'SUPPLIER_INVOICE_PROJECT_RELATED' THEN
1045:

Line 1108: p_invoice_id IN ap_invoices_all.invoice_id%TYPE) IS

1104: END get_attribute_value;
1105: --Bug 5968183
1106: -- Added procedure to update in
1107: PROCEDURE Update_Invoice_Status(
1108: p_invoice_id IN ap_invoices_all.invoice_id%TYPE) IS
1109:
1110: PRAGMA autonomous_transaction;
1111: BEGIN
1112: UPDATE ap_inv_aprvl_hist_all