APPS.AP_WEB_DISC_PKG dependencies on AP_WEB_DB_AP_INT_PKG

Line 83: function isValidCurrency (p_currency_code IN AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode)

79:
80: function ReportTotal2(ExpLine_Array in AP_WEB_DFLEX_PKG.ExpReportLines_A)
81: return number;
82:
83: function isValidCurrency (p_currency_code IN AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode)
84: return boolean;
85:
86:
87: procedure getFlexFieldGlobalSegments(p_user_id in NUMBER, -- Bug 2242176

Line 1181: l_base_curr AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;

1177: -- store justif flag fetched from just_required
1178: l_justreq_array AP_WEB_PARENT_PKG.Number_Array;
1179:
1180: -- store currency code fetched from Currencies
1181: l_base_curr AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1182: curr_found BOOLEAN := false;
1183:
1184: l_xtype_text VARCHAR2(80) := '';
1185: l_xtype_code VARCHAR2(25) := '';

Line 1233: IF ( AP_WEB_DB_AP_INT_PKG.GetBaseCurrInfo( l_base_curr ) <> TRUE ) THEN

1229: l_date_str := to_date(l_date_str_var,AP_WEB_INFRASTRUCTURE_PKG.getDateFormat);
1230: END IF;
1231:
1232: -- Get base currency code
1233: IF ( AP_WEB_DB_AP_INT_PKG.GetBaseCurrInfo( l_base_curr ) <> TRUE ) THEN
1234: l_base_curr := NULL;
1235: END IF;
1236:
1237: -- Set up the l_segmentPromptTable array

Line 1938: V_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec; -- For PATC: Exchange rate type in AP and Functional currency

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
1941: -- on latest receipt date
1942: V_DateTemp DATE; -- For PATC: Scratch variable

Line 2061: IF (NOT AP_WEB_DB_AP_INT_PKG.GetAPSysCurrencySetupInfo(V_SysInfoRec)) THEN

2057: -- rate for the last receipt date. The last receipt date will be
2058: -- equal to sysdate.
2059: l_debug_info := 'Getting functional currency and exchange rate info';
2060:
2061: IF (NOT AP_WEB_DB_AP_INT_PKG.GetAPSysCurrencySetupInfo(V_SysInfoRec)) THEN
2062: NULL;
2063: END IF;
2064:
2065: -- For PATC: Get the default exchange rate for the V_EndExpenseDate

Line 2532: function isValidCurrency (p_currency_code IN AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode)

2528: ------------------------------------------
2529: -- Checks whether the given currency code
2530: -- is valid or not.
2531: ------------------------------------------
2532: function isValidCurrency (p_currency_code IN AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode)
2533: return boolean IS
2534: ---
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,

Line 2609: l_currencyCode AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;

2605: l_temp_errors Setup_error_stack;
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);

Line 2620: l_apsys_info_rec AP_WEB_DB_AP_INT_PKG.APSysInfoRec;

2616: V_NumMaxPseudoFlexField NUMBER;
2617:
2618: debug_info VARCHAR2(2000);
2619:
2620: l_apsys_info_rec AP_WEB_DB_AP_INT_PKG.APSysInfoRec;
2621: l_curr_format VARCHAR2(80); /* reimbCurr format */
2622: l_terror_exists BOOLEAN;
2623: EndDate date;
2624:

Line 2697: IF ( AP_WEB_DB_AP_INT_PKG.GetAPSysCurrencySetupInfo(l_apsys_info_rec) = TRUE ) THEN

2693: begin
2694: if (l_currencyCode is null) then
2695: debug_info := 'Get base currency';
2696:
2697: IF ( AP_WEB_DB_AP_INT_PKG.GetAPSysCurrencySetupInfo(l_apsys_info_rec) = TRUE ) THEN
2698: l_currencyCode := l_apsys_info_rec.base_currency;
2699: l_currencyName := l_apsys_info_rec.base_curr_name;
2700: END IF;
2701:

Line 2703: IF ( AP_WEB_DB_AP_INT_PKG.GetCurrNameForCurrCode(l_currencyCode,

2699: l_currencyName := l_apsys_info_rec.base_curr_name;
2700: END IF;
2701:
2702: else
2703: IF ( AP_WEB_DB_AP_INT_PKG.GetCurrNameForCurrCode(l_currencyCode,
2704: l_currencyName) <> TRUE ) THEN
2705: l_currencyName := NULL;
2706: END IF;
2707: end if;