APPS.AP_OPEN_ITEMS_REVAL_PKG dependencies on GL_SETS_OF_BOOKS

Line 21: g_ledger_id gl_sets_of_books.set_of_books_id%type;

17: P_TRACE_SWITCH varchar2(1);
18:
19: /* Additional parameters */
20: g_coa_id gl_ledgers.chart_of_accounts_id%type;
21: g_ledger_id gl_sets_of_books.set_of_books_id%type;
22: g_base_precision fnd_currencies_vl.precision%type;
23: g_base_min_acct_unit fnd_currencies_vl.minimum_accountable_unit%type;
24: g_daily_rate_information varchar2(1) := 'N';
25: g_daily_rate_error varchar2(1) := 'N';

Line 29: g_gl_name_dsp gl_sets_of_books.name%type;

25: g_daily_rate_error varchar2(1) := 'N';
26:
27: /* Report displayed values*/
28: g_operating_unit_dsp hr_operating_units.name%type;
29: g_gl_name_dsp gl_sets_of_books.name%type;
30: g_rate_type_dsp ap_lookup_codes.displayed_field%type;
31: g_daily_rate_type_dsp gl_daily_conversion_types.user_conversion_type%type;
32: g_trans_to_gl_only_dsp fnd_lookups.meaning%type;
33: g_cleared_only_dsp fnd_lookups.meaning%type;

Line 34: g_base_currency_code gl_sets_of_books.currency_code%type;

30: g_rate_type_dsp ap_lookup_codes.displayed_field%type;
31: g_daily_rate_type_dsp gl_daily_conversion_types.user_conversion_type%type;
32: g_trans_to_gl_only_dsp fnd_lookups.meaning%type;
33: g_cleared_only_dsp fnd_lookups.meaning%type;
34: g_base_currency_code gl_sets_of_books.currency_code%type;
35: g_base_currency_desc fnd_currencies_vl.description%type;
36: g_revaluation_date gl_period_statuses.end_date%type;
37: /* Bug 14136626*/
38: g_eur_code gl_sets_of_books.currency_code%type;

Line 38: g_eur_code gl_sets_of_books.currency_code%type;

34: g_base_currency_code gl_sets_of_books.currency_code%type;
35: g_base_currency_desc fnd_currencies_vl.description%type;
36: g_revaluation_date gl_period_statuses.end_date%type;
37: /* Bug 14136626*/
38: g_eur_code gl_sets_of_books.currency_code%type;
39:
40: /* Constants */
41: c_application_id constant number := 200;
42:

Line 96: function get_revaluation_rate(l_currency_code IN gl_sets_of_books.currency_code%type,

92: txn_date';
93:
94: /* loacl procedure, can be usable only by the report */
95: /*Bug 14136626*/
96: function get_revaluation_rate(l_currency_code IN gl_sets_of_books.currency_code%type,
97: l_pay_cross_rate_type IN gl_sets_of_books.currency_code%type)
98: return number;
99:
100: /* loacl procedure, can be usable only by the report */

Line 97: l_pay_cross_rate_type IN gl_sets_of_books.currency_code%type)

93:
94: /* loacl procedure, can be usable only by the report */
95: /*Bug 14136626*/
96: function get_revaluation_rate(l_currency_code IN gl_sets_of_books.currency_code%type,
97: l_pay_cross_rate_type IN gl_sets_of_books.currency_code%type)
98: return number;
99:
100: /* loacl procedure, can be usable only by the report */
101: function get_due_date(p_invoice_id IN number, p_type in varchar2)