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 285: FROM fnd_currencies fc

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

Line 300: FROM fnd_currencies fc

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

Line 1283: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;

1279: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
1280: l_Payment_Priority NUMBER(15):=NULL; /*Bug fix:1635550*/
1281:
1282: -- Bug Fix: 1952122
1283: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;
1284: l_precision_pay_curr fnd_currencies.precision%TYPE;
1285: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
1286: l_precision_inv_curr fnd_currencies.precision%TYPE;
1287: l_hold_flag varchar2(1);

Line 1284: l_precision_pay_curr fnd_currencies.precision%TYPE;

1280: l_Payment_Priority NUMBER(15):=NULL; /*Bug fix:1635550*/
1281:
1282: -- Bug Fix: 1952122
1283: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;
1284: l_precision_pay_curr fnd_currencies.precision%TYPE;
1285: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
1286: l_precision_inv_curr fnd_currencies.precision%TYPE;
1287: l_hold_flag varchar2(1);
1288: --Bug 4539462 DBI logging

Line 1285: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;

1281:
1282: -- Bug Fix: 1952122
1283: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;
1284: l_precision_pay_curr fnd_currencies.precision%TYPE;
1285: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
1286: l_precision_inv_curr fnd_currencies.precision%TYPE;
1287: l_hold_flag varchar2(1);
1288: --Bug 4539462 DBI logging
1289: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;

Line 1286: l_precision_inv_curr fnd_currencies.precision%TYPE;

1282: -- Bug Fix: 1952122
1283: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;
1284: l_precision_pay_curr fnd_currencies.precision%TYPE;
1285: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
1286: l_precision_inv_curr fnd_currencies.precision%TYPE;
1287: l_hold_flag varchar2(1);
1288: --Bug 4539462 DBI logging
1289: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
1290: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;

Line 1405: FROM fnd_currencies fc

1401:
1402: BEGIN
1403: SELECT fc.minimum_accountable_unit, fc.precision
1404: INTO l_min_acc_unit_pay_curr, l_precision_pay_curr
1405: FROM fnd_currencies fc
1406: WHERE fc.currency_code = P_Payment_Currency;
1407: END;
1408:
1409: -- Select precision and minimum_accountable_unit before loops

Line 1415: FROM fnd_currencies fc

1411:
1412: BEGIN
1413: SELECT fc.minimum_accountable_unit, fc.precision
1414: INTO l_min_acc_unit_inv_curr, l_precision_inv_curr
1415: FROM fnd_currencies fc
1416: WHERE fc.currency_code = P_Invoice_Currency;
1417: END;
1418:
1419: -- Bug Fix:1635550

Line 2327: FROM fnd_currencies F

2323: , F.precision),
2324: ROUND( gross_amount / P_Payment_Cross_Rate
2325: /F.minimum_accountable_unit)
2326: * F.minimum_accountable_unit)
2327: FROM fnd_currencies F
2328: WHERE F.currency_code = P_Invoice_Currency)
2329: WHERE invoice_id = P_Invoice_Id;
2330: */
2331: --