DBA Data[Home] [Help]

APPS.AP_APXINDUP_XMLP_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 4: base_curr ap_system_parameters.base_currency_code%TYPE;

1: PACKAGE BODY AP_APXINDUP_XMLP_PKG AS
2: /* $Header: APXINDUPB.pls 120.0 2007/12/27 07:53:06 vjaganat noship $ */
3: FUNCTION get_base_curr_data RETURN BOOLEAN IS
4: base_curr ap_system_parameters.base_currency_code%TYPE;
5: prec fnd_currencies_vl.precision%TYPE;
6: min_au fnd_currencies_vl.minimum_accountable_unit%TYPE;
7: descr fnd_currencies_vl.description%TYPE;
8: l_org_id ap_system_parameters.org_id%TYPE;

Line 8: l_org_id ap_system_parameters.org_id%TYPE;

4: base_curr ap_system_parameters.base_currency_code%TYPE;
5: prec fnd_currencies_vl.precision%TYPE;
6: min_au fnd_currencies_vl.minimum_accountable_unit%TYPE;
7: descr fnd_currencies_vl.description%TYPE;
8: l_org_id ap_system_parameters.org_id%TYPE;
9: BEGIN
10: base_curr := '';
11: prec := 0;
12: min_au := 0;

Line 22: FROM ap_system_parameters p,

18: INTO base_curr,
19: prec,
20: min_au,
21: l_org_id, descr
22: FROM ap_system_parameters p,
23: fnd_currencies_vl c
24: WHERE p.base_currency_code = c.currency_code;
25: c_base_currency_code := base_curr;
26: c_base_precision := prec;