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 1791: p_chart_of_accounts_id IN AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID) IS

1787: p_default_emp_segments IN AP_OIE_KFF_SEGMENTS_T,
1788: p_dist_new_segments IN AP_OIE_KFF_SEGMENTS_T,
1789: p_ReportLineId IN AP_WEB_DB_EXPLINE_PKG.expLines_report_line_id,
1790: p_exp_dist_ccid IN AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID,
1791: p_chart_of_accounts_id IN AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID) IS
1792: ----------------------------------------------------------------------
1793: l_debug_info VARCHAR2(1000);
1794:
1795: l_new_segments AP_OIE_KFF_SEGMENTS_T;

Line 1853: l_sys_apply_advances_default AP_WEB_DB_AP_INT_PKG.apSetUp_applyAdvDefault;

1849: PROCEDURE DoAPValidation(p_item_type IN VARCHAR2,
1850: p_item_key IN VARCHAR2,
1851: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE) IS
1852: ----------------------------------------------------------------------
1853: l_sys_apply_advances_default AP_WEB_DB_AP_INT_PKG.apSetUp_applyAdvDefault;
1854: l_sys_allow_awt_flag AP_WEB_DB_AP_INT_PKG.apSetUp_allowAwtFlag;
1855: l_sys_default_xrate_type AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType;
1856: l_sys_make_rate_mandatory AP_WEB_DB_AP_INT_PKG.apSetUp_makeMandatoryFlag;
1857: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;

Line 1854: l_sys_allow_awt_flag AP_WEB_DB_AP_INT_PKG.apSetUp_allowAwtFlag;

1850: p_item_key IN VARCHAR2,
1851: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE) IS
1852: ----------------------------------------------------------------------
1853: l_sys_apply_advances_default AP_WEB_DB_AP_INT_PKG.apSetUp_applyAdvDefault;
1854: l_sys_allow_awt_flag AP_WEB_DB_AP_INT_PKG.apSetUp_allowAwtFlag;
1855: l_sys_default_xrate_type AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType;
1856: l_sys_make_rate_mandatory AP_WEB_DB_AP_INT_PKG.apSetUp_makeMandatoryFlag;
1857: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
1858: l_default_currency_code AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;

Line 1855: l_sys_default_xrate_type AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType;

1851: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE) IS
1852: ----------------------------------------------------------------------
1853: l_sys_apply_advances_default AP_WEB_DB_AP_INT_PKG.apSetUp_applyAdvDefault;
1854: l_sys_allow_awt_flag AP_WEB_DB_AP_INT_PKG.apSetUp_allowAwtFlag;
1855: l_sys_default_xrate_type AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType;
1856: l_sys_make_rate_mandatory AP_WEB_DB_AP_INT_PKG.apSetUp_makeMandatoryFlag;
1857: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
1858: l_default_currency_code AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1859: l_week_end_date AP_WEB_DB_EXPRPT_PKG.expHdr_weekEndDate;

Line 1856: l_sys_make_rate_mandatory AP_WEB_DB_AP_INT_PKG.apSetUp_makeMandatoryFlag;

1852: ----------------------------------------------------------------------
1853: l_sys_apply_advances_default AP_WEB_DB_AP_INT_PKG.apSetUp_applyAdvDefault;
1854: l_sys_allow_awt_flag AP_WEB_DB_AP_INT_PKG.apSetUp_allowAwtFlag;
1855: l_sys_default_xrate_type AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType;
1856: l_sys_make_rate_mandatory AP_WEB_DB_AP_INT_PKG.apSetUp_makeMandatoryFlag;
1857: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
1858: l_default_currency_code AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1859: l_week_end_date AP_WEB_DB_EXPRPT_PKG.expHdr_weekEndDate;
1860: l_exp_check_address_flag AP_WEB_DB_HR_INT_PKG.empCurrent_checkAddrFlag;

Line 1857: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;

1853: l_sys_apply_advances_default AP_WEB_DB_AP_INT_PKG.apSetUp_applyAdvDefault;
1854: l_sys_allow_awt_flag AP_WEB_DB_AP_INT_PKG.apSetUp_allowAwtFlag;
1855: l_sys_default_xrate_type AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType;
1856: l_sys_make_rate_mandatory AP_WEB_DB_AP_INT_PKG.apSetUp_makeMandatoryFlag;
1857: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
1858: l_default_currency_code AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1859: l_week_end_date AP_WEB_DB_EXPRPT_PKG.expHdr_weekEndDate;
1860: l_exp_check_address_flag AP_WEB_DB_HR_INT_PKG.empCurrent_checkAddrFlag;
1861: l_ven_allow_awt_flag AP_WEB_DB_AP_INT_PKG.vendors_allowAWTFlag;

Line 1861: l_ven_allow_awt_flag AP_WEB_DB_AP_INT_PKG.vendors_allowAWTFlag;

1857: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
1858: l_default_currency_code AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1859: l_week_end_date AP_WEB_DB_EXPRPT_PKG.expHdr_weekEndDate;
1860: l_exp_check_address_flag AP_WEB_DB_HR_INT_PKG.empCurrent_checkAddrFlag;
1861: l_ven_allow_awt_flag AP_WEB_DB_AP_INT_PKG.vendors_allowAWTFlag;
1862: l_ven_awt_group_id AP_WEB_DB_AP_INT_PKG.vendors_awtGroupID;
1863: l_default_emp_ccid AP_WEB_DB_HR_INT_PKG.empCurrent_defaultCodeCombID;
1864: l_default_emp_segments AP_OIE_KFF_SEGMENTS_T;
1865: l_exp_dist_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;

Line 1862: l_ven_awt_group_id AP_WEB_DB_AP_INT_PKG.vendors_awtGroupID;

1858: l_default_currency_code AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1859: l_week_end_date AP_WEB_DB_EXPRPT_PKG.expHdr_weekEndDate;
1860: l_exp_check_address_flag AP_WEB_DB_HR_INT_PKG.empCurrent_checkAddrFlag;
1861: l_ven_allow_awt_flag AP_WEB_DB_AP_INT_PKG.vendors_allowAWTFlag;
1862: l_ven_awt_group_id AP_WEB_DB_AP_INT_PKG.vendors_awtGroupID;
1863: l_default_emp_ccid AP_WEB_DB_HR_INT_PKG.empCurrent_defaultCodeCombID;
1864: l_default_emp_segments AP_OIE_KFF_SEGMENTS_T;
1865: l_exp_dist_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;
1866: l_id_flex_structure_name fnd_id_flex_structures_vl.id_flex_structure_name%TYPE;

Line 1873: l_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;

1869: l_employee_id AP_WEB_DB_EXPRPT_PKG.expHdr_employeeID;
1870: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1871: l_category AP_WEB_DB_CCARD_PKG.ccTrxn_category;
1872: l_default_exchange_rate AP_WEB_DB_EXPRPT_PKG.expHdr_defaultExchRate;
1873: l_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1874: l_sys_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1875: exchange_rate_exception EXCEPTION;
1876: l_available_prepays NUMBER;
1877: l_payment_due VARCHAR2(10) := C_IndividualPay;

Line 1874: l_sys_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;

1870: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1871: l_category AP_WEB_DB_CCARD_PKG.ccTrxn_category;
1872: l_default_exchange_rate AP_WEB_DB_EXPRPT_PKG.expHdr_defaultExchRate;
1873: l_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1874: l_sys_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1875: exchange_rate_exception EXCEPTION;
1876: l_available_prepays NUMBER;
1877: l_payment_due VARCHAR2(10) := C_IndividualPay;
1878:

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

1886: V_ProcedureReturnCode VARCHAR2(2000);
1887: V_ProcedureBillableFlag VARCHAR2(200);
1888: V_PATCMsgType VARCHAR2(10); -- Value not used in 11.0, but used in 11.5+
1889:
1890: V_DefaultExchangeRateType AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType; -- For PATC: Exchange rate type in AP
1891: V_BaseCurrencyCode AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode; -- For PATC: Functional currency
1892: V_ReimbCurrencyCode VARCHAR2(15);
1893: V_DefaultExchangeRate NUMBER; -- For PATC: Exchange rate for func->reimb
1894: V_AcctRawCost NUMBER; -- For PATC: Receipt amount in functional currency

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

1887: V_ProcedureBillableFlag VARCHAR2(200);
1888: V_PATCMsgType VARCHAR2(10); -- Value not used in 11.0, but used in 11.5+
1889:
1890: V_DefaultExchangeRateType AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType; -- For PATC: Exchange rate type in AP
1891: V_BaseCurrencyCode AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode; -- For PATC: Functional currency
1892: V_ReimbCurrencyCode VARCHAR2(15);
1893: V_DefaultExchangeRate NUMBER; -- For PATC: Exchange rate for func->reimb
1894: V_AcctRawCost NUMBER; -- For PATC: Receipt amount in functional currency
1895: V_WeekEndDate DATE;

Line 1897: l_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec;

1893: V_DefaultExchangeRate NUMBER; -- For PATC: Exchange rate for func->reimb
1894: V_AcctRawCost NUMBER; -- For PATC: Receipt amount in functional currency
1895: V_WeekEndDate DATE;
1896: C_WF_Version NUMBER := 0;
1897: l_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec;
1898:
1899: l_error_message VARCHAR2(2000);
1900:
1901: V_UserID NUMBER;

Line 1903: V_VendorID AP_WEB_DB_AP_INT_PKG.vendors_vendorID;

1899: l_error_message VARCHAR2(2000);
1900:
1901: V_UserID NUMBER;
1902: V_UserName VARCHAR2(30);
1903: V_VendorID AP_WEB_DB_AP_INT_PKG.vendors_vendorID;
1904: V_IsSessionProjectEnabled VARCHAR2(1);
1905:
1906: V_EmployeeID AP_WEB_DB_EXPRPT_PKG.expHdr_employeeID;
1907: l_cost_center AP_WEB_DB_EXPRPT_PKG.expHdr_flexConcat;

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

2123:
2124: END IF; /* C_CompanyPay */
2125:
2126: ------------------------------------------------------------------------
2127: l_debug_info := 'Calling AP_WEB_DB_AP_INT_PKG.GetRoundingErrorCCID';
2128: ------------------------------------------------------------------------
2129: IF (NOT AP_WEB_DB_AP_INT_PKG.GetRoundingErrorCCID(l_rounding_error_ccid)) THEN
2130: l_rounding_error_ccid := NULL;
2131: END IF; /* GetRoundingErrorCCID */

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

2125:
2126: ------------------------------------------------------------------------
2127: l_debug_info := 'Calling AP_WEB_DB_AP_INT_PKG.GetRoundingErrorCCID';
2128: ------------------------------------------------------------------------
2129: IF (NOT AP_WEB_DB_AP_INT_PKG.GetRoundingErrorCCID(l_rounding_error_ccid)) THEN
2130: l_rounding_error_ccid := NULL;
2131: END IF; /* GetRoundingErrorCCID */
2132:
2133: LOOP

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

2224: INTO l_card_program_id, l_transaction_date
2225: FROM ap_credit_card_trxns
2226: WHERE trx_id = V_CreditCardTrxID;
2227:
2228: IF (NOT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(p_ccid => l_exp_dist_ccid,
2229: p_card_program_id => l_card_program_id,
2230: p_employee_id => l_employee_id,
2231: p_as_of_date => l_transaction_date)) THEN
2232: l_exp_dist_ccid := NULL;

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

2315: INTO l_card_program_id, l_transaction_Date
2316: FROM ap_credit_card_trxns
2317: WHERE trx_id = V_CreditCardTrxID;
2318:
2319: IF (NOT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(p_ccid => l_exp_dist_ccid,
2320: p_card_program_id => l_card_program_id,
2321: p_employee_id => l_employee_id,
2322: p_as_of_date => l_transaction_date)) THEN
2323: l_exp_dist_ccid := NULL;

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

2525:
2526: ------------------------------------------------
2527: l_debug_info := 'Retrieve function currency';
2528: ------------------------------------------------
2529: IF (NOT AP_WEB_DB_AP_INT_PKG.GetBaseCurrInfo(l_sys_base_currency_code)) THEN
2530: l_sys_base_currency_code := NULL;
2531: END IF; /* GetBaseCurrInfo */
2532:
2533: ------------------------------------------------

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

2542: END IF; /* l_sys_base_currency_code <> l_default_currency_code */
2543:
2544: END IF; /* is_fixed_rate */
2545:
2546: IF (NOT AP_WEB_DB_AP_INT_PKG.GetBaseCurrInfo(l_base_currency_code)) THEN
2547: l_base_currency_code := null;
2548: END IF; /* GetBaseCurrInfo */
2549:
2550: ----------------------------------------------

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

2579:
2580: --------------------------------------------------------------------
2581: l_debug_info := 'Calculate available prepayments for this employee';
2582: --------------------------------------------------------------------
2583: IF (NOT AP_WEB_DB_AP_INT_PKG.GetAvailablePrepayments(l_employee_id,
2584: l_default_currency_code,
2585: l_available_prepays)) THEN
2586: l_available_prepays := NULL;
2587: END IF; /* GetAvailablePrepayments */

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

2588:
2589: ------------------------------------------------
2590: l_debug_info := 'Retrieve values from vendors';
2591: ------------------------------------------------
2592: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorAWTSetupForExpRpt(p_report_header_id,
2593: l_ven_allow_awt_flag,
2594: l_ven_awt_group_id)) THEN
2595:
2596: l_ven_allow_awt_flag := NULL;

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

5835: IF (l_ccard_exists = TRUE) THEN
5836: ----------------------------------------------------------------------
5837: l_debug_info := 'Get the accts pay code combination id from vendors';
5838: ----------------------------------------------------------------------
5839: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorSitesCodeCombID(l_vendor_site_id,
5840: l_accts_pay_comb_id) OR
5841: l_accts_pay_comb_id = NULL) THEN
5842: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorCodeCombID(l_vendor_id,
5843: l_accts_pay_comb_id)) THEN

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

5838: ----------------------------------------------------------------------
5839: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorSitesCodeCombID(l_vendor_site_id,
5840: l_accts_pay_comb_id) OR
5841: l_accts_pay_comb_id = NULL) THEN
5842: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorCodeCombID(l_vendor_id,
5843: l_accts_pay_comb_id)) THEN
5844: l_accts_pay_comb_id := NULL;
5845: END IF;
5846: END IF;

Line 12547: l_base_curr_code AP_WEB_DB_AP_INT_PKG.apSetup_baseCurrencyCode;

12543: l_numerator NUMBER := 1;
12544: l_rate NUMBER;
12545:
12546: l_get_ap_system_params boolean;
12547: l_base_curr_code AP_WEB_DB_AP_INT_PKG.apSetup_baseCurrencyCode;
12548: l_set_of_books_id AP_WEB_DB_AP_INT_PKG.apSetup_setOfBooksID;
12549: l_expense_report_id AP_WEB_DB_AP_INT_PKG.apSetup_expenseReportID;
12550:
12551: BEGIN

Line 12548: l_set_of_books_id AP_WEB_DB_AP_INT_PKG.apSetup_setOfBooksID;

12544: l_rate NUMBER;
12545:
12546: l_get_ap_system_params boolean;
12547: l_base_curr_code AP_WEB_DB_AP_INT_PKG.apSetup_baseCurrencyCode;
12548: l_set_of_books_id AP_WEB_DB_AP_INT_PKG.apSetup_setOfBooksID;
12549: l_expense_report_id AP_WEB_DB_AP_INT_PKG.apSetup_expenseReportID;
12550:
12551: BEGIN
12552:

Line 12549: l_expense_report_id AP_WEB_DB_AP_INT_PKG.apSetup_expenseReportID;

12545:
12546: l_get_ap_system_params boolean;
12547: l_base_curr_code AP_WEB_DB_AP_INT_PKG.apSetup_baseCurrencyCode;
12548: l_set_of_books_id AP_WEB_DB_AP_INT_PKG.apSetup_setOfBooksID;
12549: l_expense_report_id AP_WEB_DB_AP_INT_PKG.apSetup_expenseReportID;
12550:
12551: BEGIN
12552:
12553: -- Need to convert to reimbursement currency if different

Line 12559: l_get_ap_system_params := AP_WEB_DB_AP_INT_PKG.get_ap_system_params(

12555:
12556: ------------------------------------------------------
12557: l_debug_info := 'Get the rate type';
12558: ------------------------------------------------------
12559: l_get_ap_system_params := AP_WEB_DB_AP_INT_PKG.get_ap_system_params(
12560: p_base_curr_code => l_base_curr_code,
12561: p_set_of_books_id => l_set_of_books_id,
12562: p_expense_report_id => l_expense_report_id,
12563: p_default_exch_rate_type => l_conversion_type);