APPS.AR_ARXINVAD_XMLP_PKG dependencies on GL_SETS_OF_BOOKS

Line 84: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;

80: RAISE_application_error(-20101,null);/*SRW.PROGRAM_ABORT;*/null;
81: END; return (TRUE);
82: end;
83: FUNCTION get_company_name RETURN BOOLEAN IS
84: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
85: l_name gl_sets_of_books.name%TYPE;
86: l_sob_id NUMBER;
87: l_report_start_date DATE;
88: BEGIN

Line 85: l_name gl_sets_of_books.name%TYPE;

81: END; return (TRUE);
82: end;
83: FUNCTION get_company_name RETURN BOOLEAN IS
84: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
85: l_name gl_sets_of_books.name%TYPE;
86: l_sob_id NUMBER;
87: l_report_start_date DATE;
88: BEGIN
89: l_report_start_date := sysdate; l_sob_id := p_set_of_books_id;

Line 94: FROM gl_sets_of_books

90: SELECT name,
91: chart_of_accounts_id
92: INTO l_name,
93: l_chart_of_accounts_id
94: FROM gl_sets_of_books
95: WHERE set_of_books_id = l_sob_id;
96: c_company_name_header := l_name;
97: c_chart_of_accounts_id := l_chart_of_accounts_id;
98: c_report_start_date := l_report_start_date;

Line 161: base_curr gl_sets_of_books.currency_code%TYPE; prec fnd_currencies.precision%TYPE; min_au fnd_currencies.minimum_accountable_unit%TYPE; descr fnd_currencies_vl.description%TYPE;

157: return(status);
158: END;
159: RETURN NULL; end;
160: FUNCTION get_base_curr_data RETURN BOOLEAN IS
161: base_curr gl_sets_of_books.currency_code%TYPE; prec fnd_currencies.precision%TYPE; min_au fnd_currencies.minimum_accountable_unit%TYPE; descr fnd_currencies_vl.description%TYPE;
162: BEGIN
163: base_curr := '';
164: prec := 0;
165: min_au := 0;

Line 176: gl_sets_of_books g,

172: prec,
173: min_au,
174: descr
175: FROM ar_system_parameters p,
176: gl_sets_of_books g,
177: fnd_currencies_vl c
178: WHERE p.set_of_books_id = g.set_of_books_id
179: AND g.currency_code = c.currency_code;
180: c_base_currency_code := base_curr;