APPS.AP_APXINDTL_XMLP_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 4: base_curr ap_system_parameters.base_currency_code%TYPE; prec fnd_currencies_vl.precision%TYPE; min_au fnd_currencies_vl.minimum_accountable_unit%TYPE; descr fnd_currencies_vl.description%TYPE;

1: PACKAGE BODY AP_APXINDTL_XMLP_PKG AS
2: /* $Header: APXINDTLB.pls 120.0 2007/12/27 07:51:32 vjaganat noship $ */
3: FUNCTION get_base_curr_data RETURN BOOLEAN IS
4: base_curr ap_system_parameters.base_currency_code%TYPE; prec fnd_currencies_vl.precision%TYPE; min_au fnd_currencies_vl.minimum_accountable_unit%TYPE; descr fnd_currencies_vl.description%TYPE;
5: BEGIN
6: prec := 0;
7: min_au := 0;
8: descr := '';

Line 15: FROM ap_system_parameters p,

11: c.description
12: INTO prec,
13: min_au,
14: descr
15: FROM ap_system_parameters p,
16: fnd_currencies_vl c
17: WHERE p.base_currency_code = c.currency_code;
18: c_base_precision := prec;
19: c_base_min_acct_unit := min_au;

Line 129: l_base_curr_code ap_system_parameters.base_currency_code%TYPE;

125: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
126: l_name gl_sets_of_books.name%TYPE;
127: l_sob_id NUMBER;
128: l_report_start_date DATE;
129: l_base_curr_code ap_system_parameters.base_currency_code%TYPE;
130: BEGIN
131: l_report_start_date := sysdate; l_sob_id := p_set_of_books_id;
132: SELECT gl.name,
133: gl.chart_of_accounts_id,

Line 138: FROM gl_sets_of_books gl, ap_system_parameters p

134: p.base_currency_code
135: INTO l_name,
136: l_chart_of_accounts_id,
137: l_base_curr_code
138: FROM gl_sets_of_books gl, ap_system_parameters p
139: WHERE gl.set_of_books_id = l_sob_id;
140: c_company_name_header := l_name;
141: c_chart_of_accounts_id := l_chart_of_accounts_id;
142: c_report_start_date := l_report_start_date;