APPS.OKL_RECEIPTS_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 63: AND ledger_id = okl_accounting_util.get_set_of_books_id

59: CURSOR c_get_gl_date(cp_date IN DATE) IS SELECT * from (
60: SELECT end_date gl_date, 1 Counter
61: FROM gl_period_statuses
62: WHERE application_id = 222
63: AND ledger_id = okl_accounting_util.get_set_of_books_id
64: AND closing_status IN ('F','O')
65: AND trunc(cp_date) between start_date and end_date
66: AND adjustment_period_flag = 'N'
67: UNION

Line 71: AND ledger_id = okl_accounting_util.get_set_of_books_id

67: UNION
68: SELECT MAX(end_date) gl_date, 2 Counter
69: FROM gl_period_statuses
70: WHERE application_id = 222
71: AND ledger_id = okl_accounting_util.get_set_of_books_id
72: AND closing_status IN ('F','O')
73: AND end_date <= trunc(cp_date)
74: AND adjustment_period_flag = 'N'
75: UNION

Line 79: AND ledger_id = okl_accounting_util.get_set_of_books_id

75: UNION
76: SELECT MIN(start_date) gl_date, 3 Counter
77: FROM gl_period_statuses
78: WHERE application_id = 222
79: AND ledger_id = okl_accounting_util.get_set_of_books_id
80: AND closing_status IN ('F','O')
81: AND start_date >= trunc(cp_date)
82: AND adjustment_period_flag = 'N'
83: )

Line 235: l_functional_currency := okl_accounting_util.get_func_curr_code;

231:
232:
233: BEGIN
234: log_debug('validate_receipt_attributes start');
235: l_functional_currency := okl_accounting_util.get_func_curr_code;
236:
237: -- check for mandatory fields
238:
239: IF l_receipt_currency_code IS NULL OR

Line 329: l_functional_currency := okl_accounting_util.get_func_curr_code;

325: l_rcpt_date AR_CASH_RECEIPTS.RECEIPT_DATE%TYPE DEFAULT p_curr_conv_rec.receipt_date;
326:
327: BEGIN
328: log_debug('validate_currency_conv_params start');
329: l_functional_currency := okl_accounting_util.get_func_curr_code;
330:
331: x_rcpt_curr_conv_rec := p_curr_conv_rec;
332:
333: log_debug('l_functional_currency = '||l_functional_currency);

Line 372: l_functional_conversion_rate := okl_accounting_util.get_curr_con_rate( l_receipt_currency_code

368: ELSE
369: l_currency_conv_type := 'Spot';
370: END IF;*/
371:
372: l_functional_conversion_rate := okl_accounting_util.get_curr_con_rate( l_receipt_currency_code
373: ,l_functional_currency
374: ,l_currency_conv_date
375: ,l_currency_conv_type
376: );

Line 378: l_inverse_conversion_rate := okl_accounting_util.get_curr_con_rate( l_functional_currency

374: ,l_currency_conv_date
375: ,l_currency_conv_type
376: );
377:
378: l_inverse_conversion_rate := okl_accounting_util.get_curr_con_rate( l_functional_currency
379: ,l_receipt_currency_code
380: ,l_currency_conv_date
381: ,l_currency_conv_type
382: );

Line 670: l_conversion_rate := okl_accounting_util.get_curr_con_rate( l_receipt_currency_code

666: CLOSE c_fetch_inv_currency;
667:
668: IF l_invoice_currency_code <> l_receipt_currency_code THEN
669:
670: l_conversion_rate := okl_accounting_util.get_curr_con_rate( l_receipt_currency_code
671: ,l_invoice_currency_code
672: --,trunc(SYSDATE)
673: ,l_rcpt_date
674: ,'Corporate'

Line 2367: okl_accounting_util.get_curr_con_rate

2363: );
2364: RAISE g_exception_halt_validation;
2365: ELSE
2366: l_trans_to_receipt_rate :=
2367: okl_accounting_util.get_curr_con_rate
2368: (l_invoice_currency_code,
2369: l_rcpt_rec.currency_code,
2370: l_rcpt_rec.receipt_Date,
2371: l_exchange_rate_type