APPS.AP_WEB_EXPENSE_WF dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 288: from ap_expense_report_headers_all

284:
285: -- Fix 2178792 : Added the below select
286: select nvl(AMT_DUE_CCARD_COMPANY,0)+nvl(AMT_DUE_EMPLOYEE,0)+nvl(MAXIMUM_AMOUNT_TO_APPLY,0)
287: into l_total
288: from ap_expense_report_headers_all
289: where report_header_id = p_report_header_id;
290:
291: l_total_dsp := to_char(l_total,
292: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));

Line 352: FROM ap_expense_report_headers_all

348: -- FND_PROFILE.GET('ORG_ID' , l_n_org_id );
349:
350: SELECT org_id
351: INTO l_n_org_id
352: FROM ap_expense_report_headers_all
353: WHERE report_header_id = l_item_key;
354:
355:
356: -- ORG_ID was added later; therefore, it needs to be tested for upgrade purpose, and

Line 3361: UPDATE ap_expense_report_headers_all

3357: IF (C_WF_Version < AP_WEB_EXPENSE_WF.C_OIEH_Version) THEN
3358: -------------------------------------------------------------------
3359: l_debug_info := 'Set Expense Status Code';
3360: -------------------------------------------------------------------
3361: UPDATE ap_expense_report_headers_all
3362: SET expense_status_code = 'MGRAPPR'
3363: WHERE report_header_id = l_report_header_id;
3364: END IF;
3365:

Line 3448: l_reimb_currency ap_expense_report_headers_all.payment_currency_code%type;

3444: l_policy_shortpay_total NUMBER := 0;
3445: /* jrautiai ADJ Fix End */
3446:
3447: l_ExpRec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;
3448: l_reimb_currency ap_expense_report_headers_all.payment_currency_code%type;
3449: BEGIN
3450:
3451: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start AnyAPAdjustments');
3452:

Line 3913: UPDATE ap_expense_report_headers_all

3909: IF (C_WF_Version < AP_WEB_EXPENSE_WF.C_OIEH_Version) THEN
3910: -------------------------------------------------------------------
3911: l_debug_info := 'Set Expense Status Code';
3912: -------------------------------------------------------------------
3913: UPDATE ap_expense_report_headers_all
3914: SET expense_status_code = 'INVOICED'
3915: WHERE report_header_id = l_report_header_id;
3916: END IF;
3917:

Line 7705: UPDATE ap_expense_report_headers_all

7701: /* Bug 3566496: Need to update expense_current_approver_id since that
7702: * is used to display the approver in the Track expenses page.
7703: */
7704:
7705: UPDATE ap_expense_report_headers_all
7706: SET expense_current_approver_id = p_manager_id
7707: WHERE report_header_id = l_report_header_id;
7708:
7709: END IF;

Line 10799: UPDATE ap_expense_report_headers_all

10795: -- replaced p_item_key with the l_report_header_id
10796: -------------------------------------------------------------------
10797: l_debug_info := 'Set Expense Status Code and Current Approver ID';
10798: -------------------------------------------------------------------
10799: UPDATE ap_expense_report_headers_all
10800: SET expense_status_code = l_expense_status_code,
10801: expense_current_approver_id = l_current_approver_id,
10802: expense_last_status_date=sysdate,
10803: source = nvl(l_source, source)

Line 16093: UPDATE ap_expense_report_headers_all

16089: approvalprocesscompleteynout => l_approvalProcessCompleteYNOut,
16090: approversout => l_approversOut);
16091:
16092: if (l_approversOut.count > 1) then
16093: UPDATE ap_expense_report_headers_all
16094: SET expense_current_approver_id = C_AME_MULTIPLE_CURR_APPROVER
16095: WHERE report_header_id = l_report_header_id;
16096: elsif (l_approversOut.count = 1) then
16097: UPDATE ap_expense_report_headers_all

Line 16097: UPDATE ap_expense_report_headers_all

16093: UPDATE ap_expense_report_headers_all
16094: SET expense_current_approver_id = C_AME_MULTIPLE_CURR_APPROVER
16095: WHERE report_header_id = l_report_header_id;
16096: elsif (l_approversOut.count = 1) then
16097: UPDATE ap_expense_report_headers_all
16098: SET expense_current_approver_id = l_approversOut(1).orig_system_id
16099: WHERE report_header_id = l_report_header_id;
16100: end if;
16101: