eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 78: AP_INVOICES_PKG.LOCK_ROW(l_invoice_id,

74: l_inv_pos,
75: l_inv_next - l_inv_pos));
76:
77: l_log_msg := 'Locking invoice_id:' || to_char(l_invoice_id);
78: AP_INVOICES_PKG.LOCK_ROW(l_invoice_id,
79: l_curr_calling_sequence);
80:
81: -- Determine the number of payments for this invoice
82: --

Line 90: FROM ap_invoices_ready_to_pay_v

86: to_char(l_invoice_id);
87:
88: SELECT count(*) + l_num_payments
89: INTO l_num_payments
90: FROM ap_invoices_ready_to_pay_v
91: WHERE invoice_id = l_invoice_id;
92:
93: ELSE
94: -- Parse and count P_payment_num_list

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

120:
121:
122:
123: -- Perf bugfix 5052493
124: -- Go to base table AP_INVOICES_ALL to reduce shared memory usage
125: SELECT a.payment_currency_code,
126: b.payment_method_code, --4552701
127: a.vendor_id,
128: a.vendor_site_id,

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

157: P_remit_vendor_site_id,
158: p_remit_vendor_name,
159: p_remit_vendor_site_name,
160: p_relationship_id
161: FROM ap_invoices_all a, ap_payment_schedules_all b --Bug 7662240
162: WHERE a.invoice_id = l_invoice_id
163: and a.invoice_id = b.invoice_id
164: and rownum<2;
165:

Line 270: FROM ap_invoices_all

266: (p_remit_vendor_site_id = p_vendor_site_id) ) THEN
267:
268: SELECT party_id, party_site_id
269: INTO p_remit_party_id, p_remit_party_site_id
270: FROM ap_invoices_all
271: WHERE invoice_id = l_invoice_id;
272:
273: end if; --7860631
274:

Line 338: FROM ap_invoices_ready_to_pay_v

334: payment_num,
335: P_check_date,
336: P_currency_code)
337: INTO l_discount_available
338: FROM ap_invoices_ready_to_pay_v
339: WHERE invoice_id = l_invoice_id
340: AND payment_num = l_payment_num;
341:
342: EXIT WHEN (l_discount_available > 0 OR

Line 371: FROM ap_invoices_ready_to_pay_v

367: payment_num,
368: P_check_date,
369: P_currency_code))
370: INTO l_discount_available
371: FROM ap_invoices_ready_to_pay_v
372: WHERE invoice_id = l_invoice_id;
373:
374: EXIT WHEN (l_discount_available > 0 OR
375: l_next > LENGTH(P_invoice_id_list));

Line 446: FROM ap_invoices_ready_to_pay_v

442: invoice_id,
443: payment_num,
444: P_check_date,
445: P_currency_code)
446: FROM ap_invoices_ready_to_pay_v
447: WHERE invoice_id = P_invoice_id
448: AND payment_num = nvl(P_payment_num, payment_num);
449:
450: BEGIN

Line 773: FROM ap_invoices_ready_to_pay_v AIRP,

769: APS.attribute13,
770: APS.attribute14,
771: APS.attribute15,
772: APS.attribute_category
773: FROM ap_invoices_ready_to_pay_v AIRP,
774: ap_payment_schedules APS
775: WHERE AIRP.invoice_id = P_invoice_id
776: AND AIRP.payment_num = nvl(P_payment_num, AIRP.payment_num)
777: AND APS.invoice_id = AIRP.invoice_id

Line 901: FROM ap_invoices AI

897: l_log_msg);
898: END IF;
899: SELECT 'Y',awt_flag
900: INTO l_awt_invoices_exists,l_awt_applied --5745239
901: FROM ap_invoices AI
902: WHERE AI.invoice_id = p_invoice_id
903: AND EXISTS (SELECT 'At least 1 dist has an AWT Group'
904: FROM ap_invoice_distributions AID1
905: WHERE AID1.invoice_id = AI.invoice_id

Line 936: FROM ap_invoice_distributions aid,ap_invoices ai

932: --Bug7707630: Added NVL condition since the awt_group_id
933: --can be null at invoice header level
934: /* SELECT sum(nvl(aid.base_amount,aid.amount)) --query is commented for Bug:14696775
935: INTO l_total_awt_amount
936: FROM ap_invoice_distributions aid,ap_invoices ai
937: WHERE aid.invoice_id =p_invoice_id
938: AND aid.invoice_id = ai.invoice_id
939: AND aid.line_type_lookup_code in ('AWT')
940: AND aid.awt_origin_group_id = NVL(ai.awt_group_id, aid.awt_origin_group_id) --Bug7707630

Line 968: FROM ap_invoices

964: -- witholding procedure expects the amount in base currency.
965:
966: SELECT invoice_amount,exchange_rate,nvl(payment_cross_rate,1)
967: INTO l_before_invoice_amount,l_inv_exchange_rate,l_pay_cross_rate
968: FROM ap_invoices
969: WHERE invoice_id = p_invoice_id;
970: /*
971: if (l_include_discount = 'Y') then
972: l_subject_amount := (((l_amount + l_discount_taken))

Line 1067: ap_invoices AI

1063: AID.amount * AI.payment_cross_rate,
1064: AI.payment_currency_code)),0)
1065: INTO l_withholding_amount
1066: FROM ap_invoice_distributions AID,
1067: ap_invoices AI
1068: WHERE AID.awt_invoice_payment_id = l_invoice_payment_id
1069: AND AID.invoice_id = AI.invoice_id;
1070:
1071: l_amount := l_amount + l_withholding_amount;

Line 1097: FROM ap_invoice_distributions_all aid,ap_invoice_lines_all ail,ap_invoices_all ai

1093: WHERE aip.invoice_id = p_invoice_id;
1094:
1095: SELECT nvl(SUM(aid.amount),0)
1096: INTO l_prepay_amt
1097: FROM ap_invoice_distributions_all aid,ap_invoice_lines_all ail,ap_invoices_all ai
1098: WHERE ail.invoice_id=aid.invoice_id
1099: AND ail.invoice_id=ai.invoice_id
1100: AND ail.line_number=aid.invoice_line_number
1101: AND ai.invoice_id=p_invoice_id

Line 1111: FROM ap_invoices_all ai

1107: l_count:=0;
1108:
1109: SELECT count(ai.invoice_id)
1110: INTO l_count
1111: FROM ap_invoices_all ai
1112: WHERE ai.invoice_id=p_invoice_id
1113: GROUP BY ai.invoice_id,ai.invoice_amount
1114: ,ai.discount_amount_taken, decode(ai.net_of_retainage_flag,'Y',0,
1115: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(ai.invoice_id,ai.org_id),0))

Line 1115: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(ai.invoice_id,ai.org_id),0))

1111: FROM ap_invoices_all ai
1112: WHERE ai.invoice_id=p_invoice_id
1113: GROUP BY ai.invoice_id,ai.invoice_amount
1114: ,ai.discount_amount_taken, decode(ai.net_of_retainage_flag,'Y',0,
1115: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(ai.invoice_id,ai.org_id),0))
1116: HAVING (abs(nvl(ai.invoice_amount,0) -nvl(ai.discount_amount_taken,0)
1117: - nvl(AP_INVOICES_UTILITY_PKG.get_amount_withheld(ai.invoice_id),0)
1118: + decode(ai.net_of_retainage_flag, 'Y', 0,
1119: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(ai.invoice_id, ai.org_id),0))

Line 1117: - nvl(AP_INVOICES_UTILITY_PKG.get_amount_withheld(ai.invoice_id),0)

1113: GROUP BY ai.invoice_id,ai.invoice_amount
1114: ,ai.discount_amount_taken, decode(ai.net_of_retainage_flag,'Y',0,
1115: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(ai.invoice_id,ai.org_id),0))
1116: HAVING (abs(nvl(ai.invoice_amount,0) -nvl(ai.discount_amount_taken,0)
1117: - nvl(AP_INVOICES_UTILITY_PKG.get_amount_withheld(ai.invoice_id),0)
1118: + decode(ai.net_of_retainage_flag, 'Y', 0,
1119: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(ai.invoice_id, ai.org_id),0))
1120: )
1121: < abs((nvl(l_pay_amt,0)-nvl(l_prepay_amt,0))

Line 1119: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(ai.invoice_id, ai.org_id),0))

1115: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(ai.invoice_id,ai.org_id),0))
1116: HAVING (abs(nvl(ai.invoice_amount,0) -nvl(ai.discount_amount_taken,0)
1117: - nvl(AP_INVOICES_UTILITY_PKG.get_amount_withheld(ai.invoice_id),0)
1118: + decode(ai.net_of_retainage_flag, 'Y', 0,
1119: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(ai.invoice_id, ai.org_id),0))
1120: )
1121: < abs((nvl(l_pay_amt,0)-nvl(l_prepay_amt,0))
1122: +((l_amount) + (l_discount_taken))));
1123:

Line 1295: SELECT ap_invoices_s.nextval

1291: --
1292: -- Get next interest invoice_id
1293: --
1294: l_log_msg := 'Get next interest invoice_id';
1295: SELECT ap_invoices_s.nextval
1296: INTO l_interest_invoice_id
1297: FROM sys.dual;
1298:
1299: --