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_DB_EXPLINE_PKG dependencies on AP_EXPENSE_REPORT_HEADERS

Line 304: ap_expense_report_headers XH,

300: nvl(XL.flex_concatenated, XH.flex_concatenated),
301: XL.mileage_rate_adjusted_flag
302: FROM ap_expense_report_params XP,
303: ap_expense_report_lines XL,
304: ap_expense_report_headers XH,
305: ap_credit_card_trxns CC,
306: ap_lookup_codes LC,
307: PA_PROJECTS_ALL PAP, -- AP_WEB_PA_PROJECTS_V PAP, -- bug 1652647
308: PA_TASKS_EXPEND_V PAT, -- AP_WEB_PA_PROJECTS_TASKS_V PAT -- bug 1652647

Line 351: ap_expense_report_headers XH,

347: nvl(XL.flex_concatenated, XH.flex_concatenated),
348: XL.mileage_rate_adjusted_flag
349: FROM ap_expense_report_params XP,
350: ap_expense_report_lines XL,
351: ap_expense_report_headers XH,
352: ap_credit_card_trxns CC,
353: ap_lookup_codes LC,
354: AP_POL_VIOLATIONS_V AV
355: WHERE XL.report_header_id = p_report_header_id

Line 396: ap_expense_report_headers XH,

392: nvl(XL.flex_concatenated, XH.flex_concatenated),
393: XL.mileage_rate_adjusted_flag
394: FROM ap_expense_report_params XP,
395: ap_expense_report_lines XL,
396: ap_expense_report_headers XH,
397: ap_lookup_codes LC,
398: PA_PROJECTS_ALL PAP, -- AP_WEB_PA_PROJECTS_V PAP, -- bug 1652647
399: PA_TASKS_EXPEND_V PAT, -- AP_WEB_PA_PROJECTS_TASKS_V PAT -- bug 1652647
400: GMS_AWARDS GMS,

Line 439: ap_expense_report_headers XH,

435: nvl(XL.flex_concatenated, XH.flex_concatenated),
436: XL.mileage_rate_adjusted_flag
437: FROM ap_expense_report_params XP,
438: ap_expense_report_lines XL,
439: ap_expense_report_headers XH,
440: ap_lookup_codes LC,
441: AP_POL_VIOLATIONS_V av
442: WHERE XL.report_header_id = p_report_header_id
443: AND XL.report_header_id = XH.report_header_id

Line 645: from ap_expense_report_headers_all aerh1

641: FROM ap_expense_report_lines aerl
642: WHERE aerl.report_header_id in (select p_report_header_id from dual
643: union
644: select aerh1.report_header_id
645: from ap_expense_report_headers_all aerh1
646: where aerh1.SHORTPAY_PARENT_ID = p_report_header_id)
647: AND (itemization_parent_id is null OR itemization_parent_id = -1)
648: AND aerl.web_parameter_id <> l_roundingParameterId
649: AND aerl.amount <> NVL(aerl.submitted_amount,aerl.amount)

Line 797: ap_expense_report_headers aerh

793: SELECT sum(DECODE(aerl.credit_card_trx_id,null,0,aerl.amount)),
794: sum(DECODE(aerl.credit_card_trx_id, null, aerl.amount,0))
795: INTO p_no_receipts_ccard_amt, p_no_receipts_emp_amt
796: FROM ap_expense_report_lines aerl,
797: ap_expense_report_headers aerh
798: WHERE aerl.report_header_id = p_report_header_id
799: AND aerh.report_header_id = aerl.report_header_id
800: AND nvl(aerh.receipts_status,'NONE') <> AP_WEB_RECEIPT_MANAGEMENT_UTIL.C_STATUS_WAIVED
801: AND nvl(aerl.receipt_required_flag, 'N') = 'Y'

Line 827: ap_expense_report_headers aerh,

823: BEGIN
824: SELECT nvl(sum(erl.amount),0)
825: INTO p_personal_total
826: FROM ap_expense_report_lines erl,
827: ap_expense_report_headers aerh,
828: ap_credit_card_trxns cct
829: WHERE erl.report_header_id = p_report_header_id
830: AND aerh.report_header_id = erl.report_header_id
831: AND nvl(aerh.receipts_status,'NONE') <> AP_WEB_RECEIPT_MANAGEMENT_UTIL.C_STATUS_WAIVED

Line 939: FUNCTION GetPersonalTotalOfExpRpt(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,

935: return FALSE;
936: END GetReceiptViolationsTotal;
937:
938: -------------------------------------------------------------------
939: FUNCTION GetPersonalTotalOfExpRpt(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
940: p_personal_total OUT NOCOPY NUMBER)
941: RETURN BOOLEAN IS
942: -------------------------------------------------------------------
943: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

Line 1030: ap_expense_report_headers aerh

1026: BEGIN
1027: SELECT count(*)
1028: INTO p_num_req_receipt_not_verified
1029: FROM ap_expense_report_lines aerl,
1030: ap_expense_report_headers aerh
1031: WHERE aerl.report_header_id = p_report_header_id
1032: AND aerh.report_header_id = aerl.report_header_id
1033: AND nvl(aerh.receipts_status,'NONE') <> AP_WEB_RECEIPT_MANAGEMENT_UTIL.C_STATUS_WAIVED
1034: AND (nvl(aerl.receipt_required_flag, 'N') = 'Y' OR nvl(aerl.image_receipt_required_flag, 'N') = 'Y')

Line 1058: ap_expense_report_headers aerh

1054: BEGIN
1055: SELECT count(*)
1056: INTO p_count
1057: FROM ap_expense_report_lines aerl,
1058: ap_expense_report_headers aerh
1059: WHERE aerl.report_header_id = p_report_header_id
1060: AND (aerl.itemization_parent_id is null or aerl.itemization_parent_id = -1)
1061: AND aerh.report_header_id = aerl.report_header_id
1062: AND (nvl(aerl.policy_shortpay_flag,'N') = 'Y'

Line 1108: FUNCTION GetNumberOfExpLines(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,

1104: END GetNumJustReqdLines;
1105:
1106:
1107: -------------------------------------------------------------------
1108: FUNCTION GetNumberOfExpLines(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
1109: p_count OUT NOCOPY NUMBER)
1110: RETURN BOOLEAN IS
1111: -------------------------------------------------------------------
1112: BEGIN

Line 2761: ap_expense_report_headers erh

2757: nvl(cc.transaction_date,sysdate),
2758: erh.employee_id
2759: FROM ap_expense_report_lines erl,
2760: ap_credit_card_trxns cc,
2761: ap_expense_report_headers erh
2762: WHERE erl.report_header_id = erh.report_header_id
2763: AND nvl(erl.itemization_parent_id,0) <> -1 /* Itemization Project */
2764: AND cc.trx_id = erl.credit_card_trx_id -- is a credit card transaction
2765: AND cc.payment_due_from_code in ('BOTH','COMPANY') -- Both Pay split project

Line 4539: UPDATE ap_expense_report_headers

4535: policy_shortpay_flag = null,
4536: adjustment_reason = null
4537: WHERE report_header_id = p_report_header_id;
4538:
4539: UPDATE ap_expense_report_headers
4540: SET audit_code = null, -- Bug 4019412
4541: report_submitted_date = null
4542: WHERE report_header_id = p_report_header_id;
4543:

Line 5036: from ap_expense_report_headers

5032: RETURN BOOLEAN IS
5033: BEGIN
5034: select decode(shortpay_parent_id, null, 'N','Y')
5035: into p_shortpaid_flag
5036: from ap_expense_report_headers
5037: where report_header_id = p_report_header_id;
5038:
5039: RETURN TRUE;
5040:

Line 5238: FROM ap_expense_report_headers XH,

5234: SELECT to_char(nvl(CC.TRANSACTION_DATE,SYSDATE)),
5235: LPAD(to_char(CC.expensed_amount),9),
5236: CC.billed_currency_code,
5237: nvl(CC.Merchant_name1 , Merchant_name2)
5238: FROM ap_expense_report_headers XH,
5239: ap_credit_card_trxns CC,
5240: ap_lookup_codes alc
5241: WHERE XH.report_header_id = p_report_header_id
5242: AND XH.report_header_id = CC.report_header_id

Line 5273: FROM ap_expense_report_headers XH,

5269: BEGIN
5270:
5271: SELECT count(*)
5272: INTO p_personal_count
5273: FROM ap_expense_report_headers XH,
5274: ap_credit_card_trxns CC,
5275: ap_lookup_codes alc
5276: WHERE XH.report_header_id = p_report_header_id
5277: AND XH.report_header_id = CC.report_header_id

Line 5385: UPDATE ap_expense_report_headers_all

5381:
5382: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start resetApplyAdvances');
5383:
5384: -- bug : 4001778/3654956
5385: UPDATE ap_expense_report_headers_all
5386: SET maximum_amount_to_apply = null,
5387: advance_invoice_to_apply = null,
5388: apply_advances_default = null,
5389: prepay_apply_flag = null,