APPS.AP_PAY_IN_FULL_PKG dependencies on AP_INVOICES

Line 30: P_payment_function OUT NOCOPY AP_INVOICES.PAYMENT_FUNCTION%TYPE, --VARCHAR2, -- 4965233

26: P_vendor_site_id OUT NOCOPY AP_SUPPLIER_SITES.VENDOR_SITE_ID%TYPE, --NUMBER,
27: P_party_id OUT NOCOPY AP_SUPPLIERS.PARTY_ID%TYPE, --NUMBER,
28: P_party_site_id OUT NOCOPY AP_SUPPLIER_SITES.PARTY_SITE_ID%TYPE, --NUMBER,
29: P_org_id OUT NOCOPY NUMBER,
30: P_payment_function OUT NOCOPY AP_INVOICES.PAYMENT_FUNCTION%TYPE, --VARCHAR2, -- 4965233
31: P_proc_trxn_type OUT NOCOPY AP_INVOICES.PAY_PROC_TRXN_TYPE_CODE%TYPE, --VARCHAR2, -- 4965233
32: P_num_payments OUT NOCOPY NUMBER,
33: P_le_id OUT NOCOPY NUMBER, -- 5617689
34: --Added below variables for the bug 7662240

Line 31: P_proc_trxn_type OUT NOCOPY AP_INVOICES.PAY_PROC_TRXN_TYPE_CODE%TYPE, --VARCHAR2, -- 4965233

27: P_party_id OUT NOCOPY AP_SUPPLIERS.PARTY_ID%TYPE, --NUMBER,
28: P_party_site_id OUT NOCOPY AP_SUPPLIER_SITES.PARTY_SITE_ID%TYPE, --NUMBER,
29: P_org_id OUT NOCOPY NUMBER,
30: P_payment_function OUT NOCOPY AP_INVOICES.PAYMENT_FUNCTION%TYPE, --VARCHAR2, -- 4965233
31: P_proc_trxn_type OUT NOCOPY AP_INVOICES.PAY_PROC_TRXN_TYPE_CODE%TYPE, --VARCHAR2, -- 4965233
32: P_num_payments OUT NOCOPY NUMBER,
33: P_le_id OUT NOCOPY NUMBER, -- 5617689
34: --Added below variables for the bug 7662240
35: P_remit_vendor_id OUT NOCOPY AP_SUPPLIERS.VENDOR_ID%TYPE, --NUMBER,

Line 73: AP_INVOICES_PKG.LOCK_ROW(l_invoice_id,

69: l_inv_pos,
70: l_inv_next - l_inv_pos));
71:
72: l_log_msg := 'Locking invoice_id:' || to_char(l_invoice_id);
73: AP_INVOICES_PKG.LOCK_ROW(l_invoice_id,
74: l_curr_calling_sequence);
75:
76: -- Determine the number of payments for this invoice
77: --

Line 85: FROM ap_invoices_ready_to_pay_v

81: to_char(l_invoice_id);
82:
83: SELECT count(*) + l_num_payments
84: INTO l_num_payments
85: FROM ap_invoices_ready_to_pay_v
86: WHERE invoice_id = l_invoice_id;
87:
88: ELSE
89: -- Parse and count P_payment_num_list

Line 119: -- Go to base table AP_INVOICES_ALL to reduce shared memory usage

115:
116:
117:
118: -- Perf bugfix 5052493
119: -- Go to base table AP_INVOICES_ALL to reduce shared memory usage
120: SELECT a.payment_currency_code,
121: b.payment_method_code, --4552701
122: a.vendor_id,
123: a.vendor_site_id,

Line 156: FROM ap_invoices_all a, ap_payment_schedules_all b --Bug 7662240

152: P_remit_vendor_site_id,
153: p_remit_vendor_name,
154: p_remit_vendor_site_name,
155: p_relationship_id
156: FROM ap_invoices_all a, ap_payment_schedules_all b --Bug 7662240
157: WHERE a.invoice_id = l_invoice_id
158: and a.invoice_id = b.invoice_id
159: and rownum<2;
160:

Line 222: FROM ap_invoices_all

218: (p_remit_vendor_site_id = p_vendor_site_id) ) THEN
219:
220: SELECT party_id, party_site_id
221: INTO p_remit_party_id, p_remit_party_site_id
222: FROM ap_invoices_all
223: WHERE invoice_id = l_invoice_id;
224:
225: end if; --7860631
226:

Line 290: FROM ap_invoices_ready_to_pay_v

286: payment_num,
287: P_check_date,
288: P_currency_code)
289: INTO l_discount_available
290: FROM ap_invoices_ready_to_pay_v
291: WHERE invoice_id = l_invoice_id
292: AND payment_num = l_payment_num;
293:
294: EXIT WHEN (l_discount_available > 0 OR

Line 323: FROM ap_invoices_ready_to_pay_v

319: payment_num,
320: P_check_date,
321: P_currency_code))
322: INTO l_discount_available
323: FROM ap_invoices_ready_to_pay_v
324: WHERE invoice_id = l_invoice_id;
325:
326: EXIT WHEN (l_discount_available > 0 OR
327: l_next > LENGTH(P_invoice_id_list));

Line 398: FROM ap_invoices_ready_to_pay_v

394: invoice_id,
395: payment_num,
396: P_check_date,
397: P_currency_code)
398: FROM ap_invoices_ready_to_pay_v
399: WHERE invoice_id = P_invoice_id
400: AND payment_num = nvl(P_payment_num, payment_num);
401:
402: BEGIN

Line 722: FROM ap_invoices_ready_to_pay_v AIRP,

718: APS.attribute13,
719: APS.attribute14,
720: APS.attribute15,
721: APS.attribute_category
722: FROM ap_invoices_ready_to_pay_v AIRP,
723: ap_payment_schedules APS
724: WHERE AIRP.invoice_id = P_invoice_id
725: AND AIRP.payment_num = nvl(P_payment_num, AIRP.payment_num)
726: AND APS.invoice_id = AIRP.invoice_id

Line 845: FROM ap_invoices AI

841: l_log_msg);
842: END IF;
843: SELECT 'Y',awt_flag
844: INTO l_awt_invoices_exists,l_awt_applied --5745239
845: FROM ap_invoices AI
846: WHERE AI.invoice_id = p_invoice_id
847: AND EXISTS (SELECT 'At least 1 dist has an AWT Group'
848: FROM ap_invoice_distributions AID1
849: WHERE AID1.invoice_id = AI.invoice_id

Line 878: FROM ap_invoice_distributions aid,ap_invoices ai

874: AND line_type_lookup_code not in('PREPAYMENT','AWT');
875:
876: SELECT sum(nvl(aid.base_amount,aid.amount))
877: INTO l_total_awt_amount
878: FROM ap_invoice_distributions aid,ap_invoices ai
879: WHERE aid.invoice_id =p_invoice_id
880: AND aid.invoice_id = ai.invoice_id
881: AND aid.line_type_lookup_code in ('AWT')
882: AND aid.awt_origin_group_id = ai.awt_group_id;

Line 899: FROM ap_invoices

895: -- witholding procedure expects the amount in base currency.
896:
897: SELECT invoice_amount,exchange_rate,nvl(payment_cross_rate,1)
898: INTO l_before_invoice_amount,l_inv_exchange_rate,l_pay_cross_rate
899: FROM ap_invoices
900: WHERE invoice_id = p_invoice_id;
901:
902: if (l_include_discount = 'Y') then
903: l_subject_amount := (((l_amount + l_discount_taken))

Line 961: ap_invoices AI

957: AID.amount * AI.payment_cross_rate,
958: AI.payment_currency_code)),0)
959: INTO l_withholding_amount
960: FROM ap_invoice_distributions AID,
961: ap_invoices AI
962: WHERE AID.awt_invoice_payment_id = l_invoice_payment_id
963: AND AID.invoice_id = AI.invoice_id;
964:
965: l_amount := l_amount + l_withholding_amount;

Line 1116: SELECT ap_invoices_s.nextval

1112: --
1113: -- Get next interest invoice_id
1114: --
1115: l_log_msg := 'Get next interest invoice_id';
1116: SELECT ap_invoices_s.nextval
1117: INTO l_interest_invoice_id
1118: FROM sys.dual;
1119:
1120: --