APPS.AP_WEB_DISC_PKG dependencies on AP_WEB_DB_COUNTRY_PKG

Line 1204: l_curr_code_cursor AP_WEB_DB_COUNTRY_PKG.CurrencyCodeCursor;

1200: --- Used to determine if the receipt currency user provided is a recognized
1201: --- one. Took away the where clause since receipt can be in any currency,
1202: --- whereas reimbursement currency should be restricted.
1203: ---
1204: l_curr_code_cursor AP_WEB_DB_COUNTRY_PKG.CurrencyCodeCursor;
1205:
1206: l_prompt varchar2(40); --Bug 2758267
1207:
1208: l_label_code VARCHAR2(100) := '';/*Bug No: 3075093 - prompt code*/

Line 1934: l_curr_precision_cursor AP_WEB_DB_COUNTRY_PKG.CurrencyPrecisionCursor;

1930: l_allow_credit_lines BOOLEAN;
1931:
1932: l_just_required_cursor AP_WEB_DB_EXPTEMPLATE_PKG.JustificationExpTypeCursor;
1933:
1934: l_curr_precision_cursor AP_WEB_DB_COUNTRY_PKG.CurrencyPrecisionCursor;
1935: l_justreq_array AP_WEB_PARENT_PKG.Number_Array;
1936: l_reimbcurr_precision AP_WEB_DB_COUNTRY_PKG.curr_precision;
1937:
1938: V_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec; -- For PATC: Exchange rate type in AP and Functional currency

Line 1936: l_reimbcurr_precision AP_WEB_DB_COUNTRY_PKG.curr_precision;

1932: l_just_required_cursor AP_WEB_DB_EXPTEMPLATE_PKG.JustificationExpTypeCursor;
1933:
1934: l_curr_precision_cursor AP_WEB_DB_COUNTRY_PKG.CurrencyPrecisionCursor;
1935: l_justreq_array AP_WEB_PARENT_PKG.Number_Array;
1936: l_reimbcurr_precision AP_WEB_DB_COUNTRY_PKG.curr_precision;
1937:
1938: V_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec; -- For PATC: Exchange rate type in AP and Functional currency
1939: V_EndExpenseDate DATE; -- For PATC: Latest receipt date
1940: V_DefaultExchangeRate NUMBER; -- For PATC: Exchange rate for func->reimb

Line 1999: l_reimbcurr_precision := AP_WEB_DB_COUNTRY_PKG.GetCurrencyPrecision(

1995: END IF;
1996:
1997: CLOSE l_just_required_cursor;
1998:
1999: l_reimbcurr_precision := AP_WEB_DB_COUNTRY_PKG.GetCurrencyPrecision(
2000: p_report_header_info.reimbursement_currency_code);
2001:
2002: For l_recCount IN 1..l_receipt_count LOOP
2003: l_report_line_rec := p_report_lines_info(l_recCount);

Line 2539: l_curr_code_cursor AP_WEB_DB_COUNTRY_PKG.CurrencyCodeCursor;

2535: --- Used to determine if the receipt currency user provided is a recognized
2536: --- one. Took away the where clause since receipt can be in any currency,
2537: --- whereas reimbursement currency should be restricted.
2538: ---
2539: l_curr_code_cursor AP_WEB_DB_COUNTRY_PKG.CurrencyCodeCursor;
2540:
2541: l_currency_array AP_WEB_PARENT_PKG.MiniString_Array;
2542: l_count NUMBER;
2543: l_curr_found BOOLEAN := false;

Line 2547: IF ( AP_WEB_DB_COUNTRY_PKG.GetCurrCodeCursor(l_curr_code_cursor) ) THEN

2543: l_curr_found BOOLEAN := false;
2544: j BINARY_INTEGER;
2545:
2546: BEGIN
2547: IF ( AP_WEB_DB_COUNTRY_PKG.GetCurrCodeCursor(l_curr_code_cursor) ) THEN
2548:
2549: l_count := 1;
2550: LOOP
2551: FETCH l_curr_code_cursor INTO l_currency_array(l_count);

Line 2610: l_currencyName AP_WEB_DB_COUNTRY_PKG.curr_name;

2606:
2607: l_receipt_count INTEGER;
2608:
2609: l_currencyCode AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
2610: l_currencyName AP_WEB_DB_COUNTRY_PKG.curr_name;
2611:
2612: l_dflex_enabled BOOLEAN;
2613: l_tax_enabled VARCHAR2(1);
2614: l_tempChar VARCHAR2(1);