APPS.AP_WEB_OA_DISC_PKG dependencies on AP_WEB_DB_AP_INT_PKG

Line 773: p_base_curr_code IN AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode,

769: -- Bug: 6619166, Project and Task Not Validated in Disconnected Expense Entry Skip to Review.
770: PROCEDURE ValidateProjectTransaction(
771: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
772: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
773: p_base_curr_code IN AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode,
774: p_acct_raw_cost IN NUMBER,
775: p_def_exchng_rate_type IN VARCHAR2,
776: p_default_exchange_rate IN NUMBER,
777: p_vendor_id IN NUMBER,

Line 865: l_base_curr_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;

861: l_IsSessionProjectEnabled VARCHAR2(1);
862: l_return_error_message VARCHAR2(5000);
863: l_msg_count NUMBER;
864: l_msg_data VARCHAR2(5000);
865: l_base_curr_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
866: l_ret BOOLEAN;
867: l_def_exchng_rate_type VARCHAR2(100);
868: ln_default_exchange_rate NUMBER;
869: ln_acct_raw_cost NUMBER;

Line 991: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorID(p_report_header_info.employee_id, ln_vendor_id)) THEN

987: -- Bug 7497991: commenting return to continue validations.
988: -- return;
989: END IF;
990: END IF;
991: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorID(p_report_header_info.employee_id, ln_vendor_id)) THEN
992: ln_vendor_id := NULL;
993: END IF; /* GetVendorID */
994:
995: l_ret := AP_WEB_DB_AP_INT_PKG.GetBaseCurrInfo(l_base_curr_code);

Line 995: l_ret := AP_WEB_DB_AP_INT_PKG.GetBaseCurrInfo(l_base_curr_code);

991: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorID(p_report_header_info.employee_id, ln_vendor_id)) THEN
992: ln_vendor_id := NULL;
993: END IF; /* GetVendorID */
994:
995: l_ret := AP_WEB_DB_AP_INT_PKG.GetBaseCurrInfo(l_base_curr_code);
996: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange(l_def_exchng_rate_type);
997: ln_default_exchange_rate := AP_UTILITIES_PKG.get_exchange_rate(l_base_curr_code,
998: p_report_header_info.reimbursement_currency_code,
999: l_def_exchng_rate_type,

Line 996: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange(l_def_exchng_rate_type);

992: ln_vendor_id := NULL;
993: END IF; /* GetVendorID */
994:
995: l_ret := AP_WEB_DB_AP_INT_PKG.GetBaseCurrInfo(l_base_curr_code);
996: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange(l_def_exchng_rate_type);
997: ln_default_exchange_rate := AP_UTILITIES_PKG.get_exchange_rate(l_base_curr_code,
998: p_report_header_info.reimbursement_currency_code,
999: l_def_exchng_rate_type,
1000: p_report_lines_info(rec_count).end_date,

Line 1557: l_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;

1553: l_MPD_present BOOLEAN := false; -- Keeps track whether the report contains Mileage / Per Diem header exceptions
1554: l_foreign_currency_present BOOLEAN := false; -- Keeps track whether foreign currencies exist.
1555: l_reimbursement_currency_code AP_WEB_DFLEX_PKG.expLines_currCode;
1556: l_receipt_required_amount AP_EXPENSE_REPORT_PARAMS.require_receipt_amount%TYPE;
1557: l_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1558:
1559: BEGIN
1560: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_OA_DISC_PKG', 'start CheckForPerDiemMileagePolicy');
1561: -- Get reimbursement currency