eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_EXPENSE_WF dependencies on AP_WEB_DB_AP_INT_PKG

Line 1808: p_chart_of_accounts_id IN AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID) IS

1804: p_default_emp_segments IN AP_OIE_KFF_SEGMENTS_T,
1805: p_dist_new_segments IN AP_OIE_KFF_SEGMENTS_T,
1806: p_ReportLineId IN AP_WEB_DB_EXPLINE_PKG.expLines_report_line_id,
1807: p_exp_dist_ccid IN AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID,
1808: p_chart_of_accounts_id IN AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID) IS
1809: ----------------------------------------------------------------------
1810: l_debug_info VARCHAR2(1000);
1811:
1812: l_new_segments AP_OIE_KFF_SEGMENTS_T;

Line 1870: l_sys_apply_advances_default AP_WEB_DB_AP_INT_PKG.apSetUp_applyAdvDefault;

1866: PROCEDURE DoAPValidation(p_item_type IN VARCHAR2,
1867: p_item_key IN VARCHAR2,
1868: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE) IS
1869: ----------------------------------------------------------------------
1870: l_sys_apply_advances_default AP_WEB_DB_AP_INT_PKG.apSetUp_applyAdvDefault;
1871: l_sys_allow_awt_flag AP_WEB_DB_AP_INT_PKG.apSetUp_allowAwtFlag;
1872: l_sys_default_xrate_type AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType;
1873: l_sys_make_rate_mandatory AP_WEB_DB_AP_INT_PKG.apSetUp_makeMandatoryFlag;
1874: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;

Line 1871: l_sys_allow_awt_flag AP_WEB_DB_AP_INT_PKG.apSetUp_allowAwtFlag;

1867: p_item_key IN VARCHAR2,
1868: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE) IS
1869: ----------------------------------------------------------------------
1870: l_sys_apply_advances_default AP_WEB_DB_AP_INT_PKG.apSetUp_applyAdvDefault;
1871: l_sys_allow_awt_flag AP_WEB_DB_AP_INT_PKG.apSetUp_allowAwtFlag;
1872: l_sys_default_xrate_type AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType;
1873: l_sys_make_rate_mandatory AP_WEB_DB_AP_INT_PKG.apSetUp_makeMandatoryFlag;
1874: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
1875: l_default_currency_code AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;

Line 1872: l_sys_default_xrate_type AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType;

1868: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE) IS
1869: ----------------------------------------------------------------------
1870: l_sys_apply_advances_default AP_WEB_DB_AP_INT_PKG.apSetUp_applyAdvDefault;
1871: l_sys_allow_awt_flag AP_WEB_DB_AP_INT_PKG.apSetUp_allowAwtFlag;
1872: l_sys_default_xrate_type AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType;
1873: l_sys_make_rate_mandatory AP_WEB_DB_AP_INT_PKG.apSetUp_makeMandatoryFlag;
1874: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
1875: l_default_currency_code AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1876: l_week_end_date AP_WEB_DB_EXPRPT_PKG.expHdr_weekEndDate;

Line 1873: l_sys_make_rate_mandatory AP_WEB_DB_AP_INT_PKG.apSetUp_makeMandatoryFlag;

1869: ----------------------------------------------------------------------
1870: l_sys_apply_advances_default AP_WEB_DB_AP_INT_PKG.apSetUp_applyAdvDefault;
1871: l_sys_allow_awt_flag AP_WEB_DB_AP_INT_PKG.apSetUp_allowAwtFlag;
1872: l_sys_default_xrate_type AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType;
1873: l_sys_make_rate_mandatory AP_WEB_DB_AP_INT_PKG.apSetUp_makeMandatoryFlag;
1874: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
1875: l_default_currency_code AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1876: l_week_end_date AP_WEB_DB_EXPRPT_PKG.expHdr_weekEndDate;
1877: l_exp_check_address_flag AP_WEB_DB_HR_INT_PKG.empCurrent_checkAddrFlag;

Line 1874: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;

1870: l_sys_apply_advances_default AP_WEB_DB_AP_INT_PKG.apSetUp_applyAdvDefault;
1871: l_sys_allow_awt_flag AP_WEB_DB_AP_INT_PKG.apSetUp_allowAwtFlag;
1872: l_sys_default_xrate_type AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType;
1873: l_sys_make_rate_mandatory AP_WEB_DB_AP_INT_PKG.apSetUp_makeMandatoryFlag;
1874: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
1875: l_default_currency_code AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1876: l_week_end_date AP_WEB_DB_EXPRPT_PKG.expHdr_weekEndDate;
1877: l_exp_check_address_flag AP_WEB_DB_HR_INT_PKG.empCurrent_checkAddrFlag;
1878: l_ven_allow_awt_flag AP_WEB_DB_AP_INT_PKG.vendors_allowAWTFlag;

Line 1878: l_ven_allow_awt_flag AP_WEB_DB_AP_INT_PKG.vendors_allowAWTFlag;

1874: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
1875: l_default_currency_code AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1876: l_week_end_date AP_WEB_DB_EXPRPT_PKG.expHdr_weekEndDate;
1877: l_exp_check_address_flag AP_WEB_DB_HR_INT_PKG.empCurrent_checkAddrFlag;
1878: l_ven_allow_awt_flag AP_WEB_DB_AP_INT_PKG.vendors_allowAWTFlag;
1879: l_ven_awt_group_id AP_WEB_DB_AP_INT_PKG.vendors_awtGroupID;
1880: l_default_emp_ccid AP_WEB_DB_HR_INT_PKG.empCurrent_defaultCodeCombID;
1881: l_default_emp_segments AP_OIE_KFF_SEGMENTS_T;
1882: l_exp_dist_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;

Line 1879: l_ven_awt_group_id AP_WEB_DB_AP_INT_PKG.vendors_awtGroupID;

1875: l_default_currency_code AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1876: l_week_end_date AP_WEB_DB_EXPRPT_PKG.expHdr_weekEndDate;
1877: l_exp_check_address_flag AP_WEB_DB_HR_INT_PKG.empCurrent_checkAddrFlag;
1878: l_ven_allow_awt_flag AP_WEB_DB_AP_INT_PKG.vendors_allowAWTFlag;
1879: l_ven_awt_group_id AP_WEB_DB_AP_INT_PKG.vendors_awtGroupID;
1880: l_default_emp_ccid AP_WEB_DB_HR_INT_PKG.empCurrent_defaultCodeCombID;
1881: l_default_emp_segments AP_OIE_KFF_SEGMENTS_T;
1882: l_exp_dist_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;
1883: l_id_flex_structure_name fnd_id_flex_structures_vl.id_flex_structure_name%TYPE;

Line 1890: l_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;

1886: l_employee_id AP_WEB_DB_EXPRPT_PKG.expHdr_employeeID;
1887: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1888: l_category AP_WEB_DB_CCARD_PKG.ccTrxn_category;
1889: l_default_exchange_rate AP_WEB_DB_EXPRPT_PKG.expHdr_defaultExchRate;
1890: l_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1891: l_sys_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1892: exchange_rate_exception EXCEPTION;
1893: l_available_prepays NUMBER;
1894: l_payment_due VARCHAR2(10) := C_IndividualPay;

Line 1891: l_sys_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;

1887: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1888: l_category AP_WEB_DB_CCARD_PKG.ccTrxn_category;
1889: l_default_exchange_rate AP_WEB_DB_EXPRPT_PKG.expHdr_defaultExchRate;
1890: l_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1891: l_sys_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1892: exchange_rate_exception EXCEPTION;
1893: l_available_prepays NUMBER;
1894: l_payment_due VARCHAR2(10) := C_IndividualPay;
1895:

Line 1907: V_DefaultExchangeRateType AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType; -- For PATC: Exchange rate type in AP

1903: V_ProcedureReturnCode VARCHAR2(2000);
1904: V_ProcedureBillableFlag VARCHAR2(200);
1905: V_PATCMsgType VARCHAR2(10); -- Value not used in 11.0, but used in 11.5+
1906:
1907: V_DefaultExchangeRateType AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType; -- For PATC: Exchange rate type in AP
1908: V_BaseCurrencyCode AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode; -- For PATC: Functional currency
1909: V_ReimbCurrencyCode VARCHAR2(15);
1910: V_DefaultExchangeRate NUMBER; -- For PATC: Exchange rate for func->reimb
1911: V_AcctRawCost NUMBER; -- For PATC: Receipt amount in functional currency

Line 1908: V_BaseCurrencyCode AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode; -- For PATC: Functional currency

1904: V_ProcedureBillableFlag VARCHAR2(200);
1905: V_PATCMsgType VARCHAR2(10); -- Value not used in 11.0, but used in 11.5+
1906:
1907: V_DefaultExchangeRateType AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType; -- For PATC: Exchange rate type in AP
1908: V_BaseCurrencyCode AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode; -- For PATC: Functional currency
1909: V_ReimbCurrencyCode VARCHAR2(15);
1910: V_DefaultExchangeRate NUMBER; -- For PATC: Exchange rate for func->reimb
1911: V_AcctRawCost NUMBER; -- For PATC: Receipt amount in functional currency
1912: V_WeekEndDate DATE;

Line 1914: l_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec;

1910: V_DefaultExchangeRate NUMBER; -- For PATC: Exchange rate for func->reimb
1911: V_AcctRawCost NUMBER; -- For PATC: Receipt amount in functional currency
1912: V_WeekEndDate DATE;
1913: C_WF_Version NUMBER := 0;
1914: l_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec;
1915:
1916: l_error_message VARCHAR2(2000);
1917:
1918: V_UserID NUMBER;

Line 1920: V_VendorID AP_WEB_DB_AP_INT_PKG.vendors_vendorID;

1916: l_error_message VARCHAR2(2000);
1917:
1918: V_UserID NUMBER;
1919: V_UserName VARCHAR2(30);
1920: V_VendorID AP_WEB_DB_AP_INT_PKG.vendors_vendorID;
1921: V_IsSessionProjectEnabled VARCHAR2(1);
1922:
1923: V_EmployeeID AP_WEB_DB_EXPRPT_PKG.expHdr_employeeID;
1924: l_cost_center AP_WEB_DB_EXPRPT_PKG.expHdr_flexConcat;

Line 2144: l_debug_info := 'Calling AP_WEB_DB_AP_INT_PKG.GetRoundingErrorCCID';

2140:
2141: END IF; /* C_CompanyPay */
2142:
2143: ------------------------------------------------------------------------
2144: l_debug_info := 'Calling AP_WEB_DB_AP_INT_PKG.GetRoundingErrorCCID';
2145: ------------------------------------------------------------------------
2146: IF (NOT AP_WEB_DB_AP_INT_PKG.GetRoundingErrorCCID(l_rounding_error_ccid)) THEN
2147: l_rounding_error_ccid := NULL;
2148: END IF; /* GetRoundingErrorCCID */

Line 2146: IF (NOT AP_WEB_DB_AP_INT_PKG.GetRoundingErrorCCID(l_rounding_error_ccid)) THEN

2142:
2143: ------------------------------------------------------------------------
2144: l_debug_info := 'Calling AP_WEB_DB_AP_INT_PKG.GetRoundingErrorCCID';
2145: ------------------------------------------------------------------------
2146: IF (NOT AP_WEB_DB_AP_INT_PKG.GetRoundingErrorCCID(l_rounding_error_ccid)) THEN
2147: l_rounding_error_ccid := NULL;
2148: END IF; /* GetRoundingErrorCCID */
2149:
2150: LOOP

Line 2245: IF (NOT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(p_ccid => l_exp_dist_ccid,

2241: INTO l_card_program_id, l_transaction_date
2242: FROM ap_credit_card_trxns
2243: WHERE trx_id = V_CreditCardTrxID;
2244:
2245: IF (NOT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(p_ccid => l_exp_dist_ccid,
2246: p_card_program_id => l_card_program_id,
2247: p_employee_id => l_employee_id,
2248: p_as_of_date => l_transaction_date)) THEN
2249: l_exp_dist_ccid := NULL;

Line 2336: IF (NOT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(p_ccid => l_exp_dist_ccid,

2332: INTO l_card_program_id, l_transaction_Date
2333: FROM ap_credit_card_trxns
2334: WHERE trx_id = V_CreditCardTrxID;
2335:
2336: IF (NOT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(p_ccid => l_exp_dist_ccid,
2337: p_card_program_id => l_card_program_id,
2338: p_employee_id => l_employee_id,
2339: p_as_of_date => l_transaction_date)) THEN
2340: l_exp_dist_ccid := NULL;

Line 2546: IF (NOT AP_WEB_DB_AP_INT_PKG.GetBaseCurrInfo(l_sys_base_currency_code)) THEN

2542:
2543: ------------------------------------------------
2544: l_debug_info := 'Retrieve function currency';
2545: ------------------------------------------------
2546: IF (NOT AP_WEB_DB_AP_INT_PKG.GetBaseCurrInfo(l_sys_base_currency_code)) THEN
2547: l_sys_base_currency_code := NULL;
2548: END IF; /* GetBaseCurrInfo */
2549:
2550: ------------------------------------------------

Line 2563: IF (NOT AP_WEB_DB_AP_INT_PKG.GetBaseCurrInfo(l_base_currency_code)) THEN

2559: END IF; /* l_sys_base_currency_code <> l_default_currency_code */
2560:
2561: END IF; /* is_fixed_rate */
2562:
2563: IF (NOT AP_WEB_DB_AP_INT_PKG.GetBaseCurrInfo(l_base_currency_code)) THEN
2564: l_base_currency_code := null;
2565: END IF; /* GetBaseCurrInfo */
2566:
2567: ----------------------------------------------

Line 2600: IF (NOT AP_WEB_DB_AP_INT_PKG.GetAvailablePrepayments(l_employee_id,

2596:
2597: --------------------------------------------------------------------
2598: l_debug_info := 'Calculate available prepayments for this employee';
2599: --------------------------------------------------------------------
2600: IF (NOT AP_WEB_DB_AP_INT_PKG.GetAvailablePrepayments(l_employee_id,
2601: l_default_currency_code,
2602: l_available_prepays)) THEN
2603: l_available_prepays := NULL;
2604: END IF; /* GetAvailablePrepayments */

Line 2609: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorAWTSetupForExpRpt(p_report_header_id,

2605:
2606: ------------------------------------------------
2607: l_debug_info := 'Retrieve values from vendors';
2608: ------------------------------------------------
2609: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorAWTSetupForExpRpt(p_report_header_id,
2610: l_ven_allow_awt_flag,
2611: l_ven_awt_group_id)) THEN
2612:
2613: l_ven_allow_awt_flag := NULL;

Line 2962: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange(l_default_exch_rate_type);

2958: -- and compare
2959: if (nvl(l_currency,'USD') <> 'USD') then
2960: BEGIN
2961: -- Bug# 9818634: Get the exchange rate type and then convert the amount
2962: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange(l_default_exch_rate_type);
2963: gl_currency_api.convert_closest_amount( l_currency ,
2964: 'USD' ,
2965: SYSDATE ,
2966: l_default_exch_rate_type ,

Line 6210: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorSitesCodeCombID(l_vendor_site_id,

6206: IF (l_ccard_exists = TRUE) THEN
6207: ----------------------------------------------------------------------
6208: l_debug_info := 'Get the accts pay code combination id from vendors';
6209: ----------------------------------------------------------------------
6210: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorSitesCodeCombID(l_vendor_site_id,
6211: l_accts_pay_comb_id) OR
6212: l_accts_pay_comb_id = NULL) THEN
6213: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorCodeCombID(l_vendor_id,
6214: l_accts_pay_comb_id)) THEN

Line 6213: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorCodeCombID(l_vendor_id,

6209: ----------------------------------------------------------------------
6210: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorSitesCodeCombID(l_vendor_site_id,
6211: l_accts_pay_comb_id) OR
6212: l_accts_pay_comb_id = NULL) THEN
6213: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorCodeCombID(l_vendor_id,
6214: l_accts_pay_comb_id)) THEN
6215: l_accts_pay_comb_id := NULL;
6216: END IF;
6217: END IF;

Line 13330: l_base_curr_code AP_WEB_DB_AP_INT_PKG.apSetup_baseCurrencyCode;

13326: l_rate NUMBER;
13327: l_calc_rate NUMBER;
13328:
13329: l_get_ap_system_params boolean;
13330: l_base_curr_code AP_WEB_DB_AP_INT_PKG.apSetup_baseCurrencyCode;
13331: l_set_of_books_id AP_WEB_DB_AP_INT_PKG.apSetup_setOfBooksID;
13332: l_expense_report_id AP_WEB_DB_AP_INT_PKG.apSetup_expenseReportID;
13333:
13334: BEGIN

Line 13331: l_set_of_books_id AP_WEB_DB_AP_INT_PKG.apSetup_setOfBooksID;

13327: l_calc_rate NUMBER;
13328:
13329: l_get_ap_system_params boolean;
13330: l_base_curr_code AP_WEB_DB_AP_INT_PKG.apSetup_baseCurrencyCode;
13331: l_set_of_books_id AP_WEB_DB_AP_INT_PKG.apSetup_setOfBooksID;
13332: l_expense_report_id AP_WEB_DB_AP_INT_PKG.apSetup_expenseReportID;
13333:
13334: BEGIN
13335:

Line 13332: l_expense_report_id AP_WEB_DB_AP_INT_PKG.apSetup_expenseReportID;

13328:
13329: l_get_ap_system_params boolean;
13330: l_base_curr_code AP_WEB_DB_AP_INT_PKG.apSetup_baseCurrencyCode;
13331: l_set_of_books_id AP_WEB_DB_AP_INT_PKG.apSetup_setOfBooksID;
13332: l_expense_report_id AP_WEB_DB_AP_INT_PKG.apSetup_expenseReportID;
13333:
13334: BEGIN
13335:
13336: -- Bug 13581067 - Rate Per Passenger Calcluation and Addon Rates included.

Line 13346: /*l_get_ap_system_params := AP_WEB_DB_AP_INT_PKG.get_ap_system_params(

13342:
13343: ------------------------------------------------------
13344: l_debug_info := 'Get the rate type';
13345: ------------------------------------------------------
13346: /*l_get_ap_system_params := AP_WEB_DB_AP_INT_PKG.get_ap_system_params(
13347: p_base_curr_code => l_base_curr_code,
13348: p_set_of_books_id => l_set_of_books_id,
13349: p_expense_report_id => l_expense_report_id,
13350: p_default_exch_rate_type => l_conversion_type);*/

Line 13352: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange(p_default_exchange_rate_type => l_conversion_type);

13348: p_set_of_books_id => l_set_of_books_id,
13349: p_expense_report_id => l_expense_report_id,
13350: p_default_exch_rate_type => l_conversion_type);*/
13351:
13352: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange(p_default_exchange_rate_type => l_conversion_type);
13353:
13354: gl_currency_api.convert_closest_amount(
13355: x_from_currency => p_sh_currency_code,
13356: x_to_currency => p_mileage_line.reimbursement_currency_code,