APPS.AP_WFAPPROVAL_PKG dependencies on AP_INVOICES

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 174: UPDATE AP_INVOICES

170:
171: IF nvl(l_po_count,0) = 0 THEN
172: resultout := wf_engine.eng_completed||':'||'Y';
173: --update invoice status
174: UPDATE AP_INVOICES
175: SET wfapproval_status = 'NOT REQUIRED'
176: WHERE invoice_id = substr(itemkey, 1, instr(itemkey,'_')-1)
177: AND wfapproval_status <> 'MANUALLY APPROVED';
178: ELSE

Line 271: UPDATE AP_INVOICES

267: AND RESPONSE <> 'MANUALLY APPROVED';
268:
269: IF l_count >0 THEN
270: --update invoice header status
271: UPDATE AP_INVOICES
272: SET wfapproval_status = 'WFAPPROVED'
273: WHERE invoice_id = l_invoice_id
274: AND wfapproval_status <> 'MANUALLY APPROVED';
275: ELSE

Line 276: UPDATE AP_INVOICES

272: SET wfapproval_status = 'WFAPPROVED'
273: WHERE invoice_id = l_invoice_id
274: AND wfapproval_status <> 'MANUALLY APPROVED';
275: ELSE
276: UPDATE AP_INVOICES
277: SET wfapproval_status = 'NOT REQUIRED'
278: WHERE invoice_id = l_invoice_id
279: AND wfapproval_status <> 'MANUALLY APPROVED';
280: END IF;

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 457: UPDATE AP_INVOICES

453: WHERE APPROVAL_HISTORY_ID = l_hist_id;
454:
455: IF l_result = 'REJECTED' THEN
456: --update invoice status
457: UPDATE AP_INVOICES
458: SET wfapproval_status = l_result
459: WHERE invoice_id = substr(itemkey, 1, instr(itemkey,'_')-1)
460: AND wfapproval_status <> 'MANUALLY APPROVED';
461: END IF;

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 799: FROM AP_INVOICES

795: l_invoice_id,
796: l_invoice_num,
797: l_invoice_date,
798: l_requester_id
799: FROM AP_INVOICES
800: WHERE invoice_id = substr(itemkey, 1, instr(itemkey,'_')-1);
801:
802: SELECT vendor_name
803: INTO l_vendor_name

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