APPS.AP_CREATE_PAY_SCHEDS_PKG dependencies on FND_CURRENCIES

Line 178: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;

174: current_calling_sequence VARCHAR2(2000);
175: debug_info VARCHAR2(100);
176: l_amount_for_discount ap_invoices.amount_applicable_to_discount%TYPE;
177: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
178: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;
179: l_precision_pay_curr fnd_currencies.precision%TYPE;
180: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
181: l_precision_inv_curr fnd_currencies.precision%TYPE;
182: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;

Line 179: l_precision_pay_curr fnd_currencies.precision%TYPE;

175: debug_info VARCHAR2(100);
176: l_amount_for_discount ap_invoices.amount_applicable_to_discount%TYPE;
177: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
178: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;
179: l_precision_pay_curr fnd_currencies.precision%TYPE;
180: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
181: l_precision_inv_curr fnd_currencies.precision%TYPE;
182: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
183:

Line 180: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;

176: l_amount_for_discount ap_invoices.amount_applicable_to_discount%TYPE;
177: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
178: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;
179: l_precision_pay_curr fnd_currencies.precision%TYPE;
180: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
181: l_precision_inv_curr fnd_currencies.precision%TYPE;
182: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
183:
184: l_payment_priority NUMBER; -- Added for Payment Request

Line 181: l_precision_inv_curr fnd_currencies.precision%TYPE;

177: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
178: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;
179: l_precision_pay_curr fnd_currencies.precision%TYPE;
180: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
181: l_precision_inv_curr fnd_currencies.precision%TYPE;
182: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
183:
184: l_payment_priority NUMBER; -- Added for Payment Request
185: l_vendor_site_id NUMBER;

Line 284: FROM fnd_currencies fc

280: SELECT fc.minimum_accountable_unit,
281: fc.precision
282: INTO l_min_acc_unit_pay_curr,
283: l_precision_pay_curr
284: FROM fnd_currencies fc
285: WHERE fc.currency_code = P_Payment_Currency;
286: EXCEPTION
287: WHEN OTHERS THEN
288: NULL;

Line 299: FROM fnd_currencies fc

295: SELECT fc.minimum_accountable_unit,
296: fc.precision
297: INTO l_min_acc_unit_inv_curr,
298: l_precision_inv_curr
299: FROM fnd_currencies fc
300: WHERE fc.currency_code = P_Invoice_Currency;
301: EXCEPTION
302: WHEN OTHERS THEN
303: NULL;

Line 1239: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;

1235: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
1236: l_Payment_Priority NUMBER(15):=NULL; /*Bug fix:1635550*/
1237:
1238: -- Bug Fix: 1952122
1239: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;
1240: l_precision_pay_curr fnd_currencies.precision%TYPE;
1241: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
1242: l_precision_inv_curr fnd_currencies.precision%TYPE;
1243: l_hold_flag varchar2(1);

Line 1240: l_precision_pay_curr fnd_currencies.precision%TYPE;

1236: l_Payment_Priority NUMBER(15):=NULL; /*Bug fix:1635550*/
1237:
1238: -- Bug Fix: 1952122
1239: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;
1240: l_precision_pay_curr fnd_currencies.precision%TYPE;
1241: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
1242: l_precision_inv_curr fnd_currencies.precision%TYPE;
1243: l_hold_flag varchar2(1);
1244: --Bug 4539462 DBI logging

Line 1241: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;

1237:
1238: -- Bug Fix: 1952122
1239: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;
1240: l_precision_pay_curr fnd_currencies.precision%TYPE;
1241: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
1242: l_precision_inv_curr fnd_currencies.precision%TYPE;
1243: l_hold_flag varchar2(1);
1244: --Bug 4539462 DBI logging
1245: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;

Line 1242: l_precision_inv_curr fnd_currencies.precision%TYPE;

1238: -- Bug Fix: 1952122
1239: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;
1240: l_precision_pay_curr fnd_currencies.precision%TYPE;
1241: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
1242: l_precision_inv_curr fnd_currencies.precision%TYPE;
1243: l_hold_flag varchar2(1);
1244: --Bug 4539462 DBI logging
1245: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
1246: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;

Line 1347: FROM fnd_currencies fc

1343:
1344: BEGIN
1345: SELECT fc.minimum_accountable_unit, fc.precision
1346: INTO l_min_acc_unit_pay_curr, l_precision_pay_curr
1347: FROM fnd_currencies fc
1348: WHERE fc.currency_code = P_Payment_Currency;
1349: END;
1350:
1351: -- Select precision and minimum_accountable_unit before loops

Line 1357: FROM fnd_currencies fc

1353:
1354: BEGIN
1355: SELECT fc.minimum_accountable_unit, fc.precision
1356: INTO l_min_acc_unit_inv_curr, l_precision_inv_curr
1357: FROM fnd_currencies fc
1358: WHERE fc.currency_code = P_Invoice_Currency;
1359: END;
1360:
1361: -- Bug Fix:1635550

Line 2229: FROM fnd_currencies F

2225: , F.precision),
2226: ROUND( gross_amount / P_Payment_Cross_Rate
2227: /F.minimum_accountable_unit)
2228: * F.minimum_accountable_unit)
2229: FROM fnd_currencies F
2230: WHERE F.currency_code = P_Invoice_Currency)
2231: WHERE invoice_id = P_Invoice_Id;
2232: */
2233: --