DBA Data[Home] [Help]

APPS.AP_WEB_UTILITIES_PKG dependencies on AP_WEB_DB_COUNTRY_PKG

Line 171: l_curr_code AP_WEB_DB_COUNTRY_PKG.curr_currCode;

167:
168: -----------------------------------
169: PROCEDURE PopulateCurrencyArray IS
170: -----------------------------------
171: l_curr_code AP_WEB_DB_COUNTRY_PKG.curr_currCode;
172: l_curr_name AP_WEB_DB_COUNTRY_PKG.curr_name;
173: l_precision AP_WEB_DB_COUNTRY_PKG.curr_precision;
174: l_minimum_acct_unit AP_WEB_DB_COUNTRY_PKG.curr_minAcctUnit;
175: l_derive_factor AP_WEB_DB_COUNTRY_PKG.curr_deriveFactor;

Line 172: l_curr_name AP_WEB_DB_COUNTRY_PKG.curr_name;

168: -----------------------------------
169: PROCEDURE PopulateCurrencyArray IS
170: -----------------------------------
171: l_curr_code AP_WEB_DB_COUNTRY_PKG.curr_currCode;
172: l_curr_name AP_WEB_DB_COUNTRY_PKG.curr_name;
173: l_precision AP_WEB_DB_COUNTRY_PKG.curr_precision;
174: l_minimum_acct_unit AP_WEB_DB_COUNTRY_PKG.curr_minAcctUnit;
175: l_derive_factor AP_WEB_DB_COUNTRY_PKG.curr_deriveFactor;
176: l_derive_effective AP_WEB_DB_COUNTRY_PKG.curr_deriveEffective;

Line 173: l_precision AP_WEB_DB_COUNTRY_PKG.curr_precision;

169: PROCEDURE PopulateCurrencyArray IS
170: -----------------------------------
171: l_curr_code AP_WEB_DB_COUNTRY_PKG.curr_currCode;
172: l_curr_name AP_WEB_DB_COUNTRY_PKG.curr_name;
173: l_precision AP_WEB_DB_COUNTRY_PKG.curr_precision;
174: l_minimum_acct_unit AP_WEB_DB_COUNTRY_PKG.curr_minAcctUnit;
175: l_derive_factor AP_WEB_DB_COUNTRY_PKG.curr_deriveFactor;
176: l_derive_effective AP_WEB_DB_COUNTRY_PKG.curr_deriveEffective;
177: l_curr_count NUMBER := 0;

Line 174: l_minimum_acct_unit AP_WEB_DB_COUNTRY_PKG.curr_minAcctUnit;

170: -----------------------------------
171: l_curr_code AP_WEB_DB_COUNTRY_PKG.curr_currCode;
172: l_curr_name AP_WEB_DB_COUNTRY_PKG.curr_name;
173: l_precision AP_WEB_DB_COUNTRY_PKG.curr_precision;
174: l_minimum_acct_unit AP_WEB_DB_COUNTRY_PKG.curr_minAcctUnit;
175: l_derive_factor AP_WEB_DB_COUNTRY_PKG.curr_deriveFactor;
176: l_derive_effective AP_WEB_DB_COUNTRY_PKG.curr_deriveEffective;
177: l_curr_count NUMBER := 0;
178: l_date_format VARCHAR2(20);

Line 175: l_derive_factor AP_WEB_DB_COUNTRY_PKG.curr_deriveFactor;

171: l_curr_code AP_WEB_DB_COUNTRY_PKG.curr_currCode;
172: l_curr_name AP_WEB_DB_COUNTRY_PKG.curr_name;
173: l_precision AP_WEB_DB_COUNTRY_PKG.curr_precision;
174: l_minimum_acct_unit AP_WEB_DB_COUNTRY_PKG.curr_minAcctUnit;
175: l_derive_factor AP_WEB_DB_COUNTRY_PKG.curr_deriveFactor;
176: l_derive_effective AP_WEB_DB_COUNTRY_PKG.curr_deriveEffective;
177: l_curr_count NUMBER := 0;
178: l_date_format VARCHAR2(20);
179:

Line 176: l_derive_effective AP_WEB_DB_COUNTRY_PKG.curr_deriveEffective;

172: l_curr_name AP_WEB_DB_COUNTRY_PKG.curr_name;
173: l_precision AP_WEB_DB_COUNTRY_PKG.curr_precision;
174: l_minimum_acct_unit AP_WEB_DB_COUNTRY_PKG.curr_minAcctUnit;
175: l_derive_factor AP_WEB_DB_COUNTRY_PKG.curr_deriveFactor;
176: l_derive_effective AP_WEB_DB_COUNTRY_PKG.curr_deriveEffective;
177: l_curr_count NUMBER := 0;
178: l_date_format VARCHAR2(20);
179:
180: l_curr_cursor AP_WEB_DB_COUNTRY_PKG.CurrencyInfoCursor;

Line 180: l_curr_cursor AP_WEB_DB_COUNTRY_PKG.CurrencyInfoCursor;

176: l_derive_effective AP_WEB_DB_COUNTRY_PKG.curr_deriveEffective;
177: l_curr_count NUMBER := 0;
178: l_date_format VARCHAR2(20);
179:
180: l_curr_cursor AP_WEB_DB_COUNTRY_PKG.CurrencyInfoCursor;
181:
182: BEGIN
183:
184: l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);

Line 186: IF (AP_WEB_DB_COUNTRY_PKG.GetCurrencyInfoCursor(l_curr_cursor)) THEN

182: BEGIN
183:
184: l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
185: htp.p('var gC=g_arrCurrency;');
186: IF (AP_WEB_DB_COUNTRY_PKG.GetCurrencyInfoCursor(l_curr_cursor)) THEN
187: LOOP
188: FETCH l_curr_cursor INTO l_curr_code,
189: l_curr_name,
190: l_precision,

Line 2484: l_euro_code AP_WEB_DB_COUNTRY_PKG.curr_currCode;

2480:
2481:
2482: PROCEDURE DetermineConversion IS
2483:
2484: l_euro_code AP_WEB_DB_COUNTRY_PKG.curr_currCode;
2485:
2486: BEGIN
2487: l_euro_code := getEuroCode;
2488:

Line 2570: l_euro_code AP_WEB_DB_COUNTRY_PKG.curr_currCode;

2566:
2567: -----------------------------
2568: FUNCTION getEuroCode RETURN VARCHAR2 IS
2569: -----------------------------
2570: l_euro_code AP_WEB_DB_COUNTRY_PKG.curr_currCode;
2571: BEGIN
2572: l_euro_code := GL_CURRENCY_API.get_euro_code();
2573: htp.p('top.g_bEuroCodeDefined = true');
2574: return l_euro_code;