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_EXPENSE_REPORT_HEADERS_ALL

Line 292: from ap_expense_report_headers_all

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

Line 369: FROM ap_expense_report_headers_all

365: -- FND_PROFILE.GET('ORG_ID' , l_n_org_id );
366:
367: SELECT org_id
368: INTO l_n_org_id
369: FROM ap_expense_report_headers_all
370: WHERE report_header_id = l_item_key;
371:
372:
373: -- ORG_ID was added later; therefore, it needs to be tested for upgrade purpose, and

Line 3410: UPDATE ap_expense_report_headers_all

3406: IF (C_WF_Version < AP_WEB_EXPENSE_WF.C_OIEH_Version) THEN
3407: -------------------------------------------------------------------
3408: l_debug_info := 'Set Expense Status Code';
3409: -------------------------------------------------------------------
3410: UPDATE ap_expense_report_headers_all
3411: SET expense_status_code = 'MGRAPPR'
3412: WHERE report_header_id = l_report_header_id;
3413: END IF;
3414:

Line 3497: l_reimb_currency ap_expense_report_headers_all.payment_currency_code%type;

3493: l_policy_shortpay_total NUMBER := 0;
3494: /* jrautiai ADJ Fix End */
3495:
3496: l_ExpRec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;
3497: l_reimb_currency ap_expense_report_headers_all.payment_currency_code%type;
3498: BEGIN
3499:
3500: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start AnyAPAdjustments');
3501:

Line 3962: UPDATE ap_expense_report_headers_all

3958: IF (C_WF_Version < AP_WEB_EXPENSE_WF.C_OIEH_Version) THEN
3959: -------------------------------------------------------------------
3960: l_debug_info := 'Set Expense Status Code';
3961: -------------------------------------------------------------------
3962: UPDATE ap_expense_report_headers_all
3963: SET expense_status_code = 'INVOICED',
3964: last_update_date = SYSDATE
3965: --last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)
3966: WHERE report_header_id = l_report_header_id;

Line 8150: UPDATE ap_expense_report_headers_all

8146: /* Bug 3566496: Need to update expense_current_approver_id since that
8147: * is used to display the approver in the Track expenses page.
8148: */
8149:
8150: UPDATE ap_expense_report_headers_all
8151: SET expense_current_approver_id = p_manager_id,
8152: approval_type = 'PER'
8153: WHERE report_header_id = l_report_header_id;
8154:

Line 11519: FROM ap_expense_report_headers_all

11515: where report_header_id = l_report_header_id;
11516:
11517: SELECT employee_id
11518: INTO l_employee_id
11519: FROM ap_expense_report_headers_all
11520: WHERE report_header_id = l_report_header_id;
11521:
11522: IF (l_expense_status_code = 'INVOICED') THEN
11523:

Line 11544: UPDATE ap_expense_report_headers_all

11540: -- replaced p_item_key with the l_report_header_id
11541: -------------------------------------------------------------------
11542: l_debug_info := 'Set Expense Status Code and Current Approver ID';
11543: -------------------------------------------------------------------
11544: UPDATE ap_expense_report_headers_all
11545: SET expense_status_code = l_expense_status_code,
11546: expense_current_approver_id = l_current_approver_id,
11547: expense_last_status_date=sysdate,
11548: source = nvl(l_source, source),

Line 14501: ap_expense_report_headers_all where report_header_id = l_report_header_id;

14497:
14498:
14499: select nvl(image_receipts_status,'NOT_REQUIRED') ,
14500: nvl(receipts_status, 'NOT_REQUIRED') into l_image_receipts_status, l_receipts_status from
14501: ap_expense_report_headers_all where report_header_id = l_report_header_id;
14502:
14503: IF ((NVL(recpt_rec.AUD_IMG_RECEIPT_REQUIRED, 'N') = 'Y' AND l_image_receipts_status = 'RECEIVED')
14504: OR (NVL(recpt_rec.AUD_PAPER_RECEIPT_REQUIRED, 'N') = 'Y' AND l_receipts_status = 'RECEIVED')) THEN
14505: IF (l_auditor_id IS NULL) THEN

Line 14526: ap_expense_report_headers_all where report_header_id = l_report_header_id;

14522: IF recpt_rec.recpt_assign_stage_code = 'MGR_APPR_IMG' THEN
14523:
14524: select nvl(image_receipts_status,'NOT_REQUIRED') ,
14525: nvl(receipts_status, 'NOT_REQUIRED') into l_image_receipts_status, l_receipts_status from
14526: ap_expense_report_headers_all where report_header_id = l_report_header_id;
14527:
14528: IF ((NVL(recpt_rec.AUD_IMG_RECEIPT_REQUIRED, 'N') = 'Y' AND l_image_receipts_status = 'RECEIVED')
14529: OR (NVL(recpt_rec.AUD_PAPER_RECEIPT_REQUIRED, 'N') = 'Y' AND l_receipts_status = 'RECEIVED')) THEN
14530: IF (l_auditor_id IS NULL) THEN

Line 14548: ap_expense_report_headers_all where report_header_id = l_report_header_id;

14544: IF recpt_rec.recpt_assign_stage_code = 'MGR_APPR_IMG' THEN
14545:
14546: select nvl(image_receipts_status,'NOT_REQUIRED') ,
14547: nvl(receipts_status, 'NOT_REQUIRED') into l_image_receipts_status, l_receipts_status from
14548: ap_expense_report_headers_all where report_header_id = l_report_header_id;
14549:
14550: IF ((NVL(recpt_rec.AUD_IMG_RECEIPT_REQUIRED, 'N') = 'Y' AND l_image_receipts_status = 'RECEIVED')
14551: OR (NVL(recpt_rec.AUD_PAPER_RECEIPT_REQUIRED, 'N') = 'Y' AND l_receipts_status = 'RECEIVED')) THEN
14552: IF (l_auditor_id IS NULL) THEN

Line 14745: FROM ap_expense_report_headers_all

14741: begin
14742: SELECT user_name INTO l_auditor_name
14743: FROM fnd_user
14744: WHERE user_id=(SELECT last_audited_by
14745: FROM ap_expense_report_headers_all
14746: WHERE report_header_id=p_item_key);
14747: exception
14748: when no_data_found then
14749: l_auditor_name := WF_ENGINE.GetItemAttrText(p_item_type,

Line 15235: l_approval_type AP_EXPENSE_REPORT_HEADERS_ALL.APPROVAL_TYPE%TYPE;

15231: l_entered_by NUMBER := fnd_global.user_id;
15232: l_user_name fnd_user.user_name%TYPE := null;
15233: l_ame_enabled varchar2(1) := 'N';
15234:
15235: l_approval_type AP_EXPENSE_REPORT_HEADERS_ALL.APPROVAL_TYPE%TYPE;
15236: l_workflow_flag AP_EXPENSE_REPORT_HEADERS_ALL.WORKFLOW_APPROVED_FLAG%TYPE;
15237:
15238: BEGIN
15239:

Line 15236: l_workflow_flag AP_EXPENSE_REPORT_HEADERS_ALL.WORKFLOW_APPROVED_FLAG%TYPE;

15232: l_user_name fnd_user.user_name%TYPE := null;
15233: l_ame_enabled varchar2(1) := 'N';
15234:
15235: l_approval_type AP_EXPENSE_REPORT_HEADERS_ALL.APPROVAL_TYPE%TYPE;
15236: l_workflow_flag AP_EXPENSE_REPORT_HEADERS_ALL.WORKFLOW_APPROVED_FLAG%TYPE;
15237:
15238: BEGIN
15239:
15240: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start StoreNote');

Line 15305: FROM AP_EXPENSE_REPORT_HEADERS_ALL

15301: p_item_key,
15302: 'EXPENSE_REPORT_ID');
15303:
15304: SELECT approval_type, workflow_approved_flag INTO l_approval_type, l_workflow_flag
15305: FROM AP_EXPENSE_REPORT_HEADERS_ALL
15306: WHERE report_header_id = l_report_header_id;
15307: EXCEPTION
15308: WHEN OTHERS THEN
15309: l_approval_type := null;

Line 17191: UPDATE ap_expense_report_headers_all

17187: approvalprocesscompleteynout => l_approvalProcessCompleteYNOut,
17188: approversout => l_approversOut);
17189:
17190: if (l_approversOut.count > 1) then
17191: UPDATE ap_expense_report_headers_all
17192: SET expense_current_approver_id = C_AME_MULTIPLE_CURR_APPROVER
17193: WHERE report_header_id = l_report_header_id;
17194: elsif (l_approversOut.count = 1) then
17195: UPDATE ap_expense_report_headers_all

Line 17195: UPDATE ap_expense_report_headers_all

17191: UPDATE ap_expense_report_headers_all
17192: SET expense_current_approver_id = C_AME_MULTIPLE_CURR_APPROVER
17193: WHERE report_header_id = l_report_header_id;
17194: elsif (l_approversOut.count = 1) then
17195: UPDATE ap_expense_report_headers_all
17196: SET expense_current_approver_id = l_approversOut(1).orig_system_id,
17197: approval_type = l_approversOut(1).orig_system
17198: WHERE report_header_id = l_report_header_id;
17199: end if;

Line 17341: update ap_expense_report_headers_all

17337: AND TRUNC(NVL(rsa.END_DATE,SYSDATE));
17338:
17339: IF (l_req_mgr_appr = 'Y' AND l_img_recpt_status NOT IN ('RECEIVED','NOT_REQUIRED')) THEN
17340:
17341: update ap_expense_report_headers_all
17342: set expense_status_code = 'PENDING_IMAGE_SUBMISSION'
17343: where report_header_id = l_report_header_id;
17344:
17345: p_result := 'COMPLETE:Y';