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 302: ap_expense_report_headers XH,

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

Line 349: ap_expense_report_headers XH,

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

Line 394: ap_expense_report_headers XH,

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

Line 437: ap_expense_report_headers XH,

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

Line 643: from ap_expense_report_headers_all aerh1

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

Line 795: ap_expense_report_headers aerh

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

Line 825: ap_expense_report_headers aerh,

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

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

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

Line 1028: ap_expense_report_headers aerh

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

Line 1056: ap_expense_report_headers aerh

1052: BEGIN
1053: SELECT count(*)
1054: INTO p_count
1055: FROM ap_expense_report_lines aerl,
1056: ap_expense_report_headers aerh
1057: WHERE aerl.report_header_id = p_report_header_id
1058: AND aerh.report_header_id = aerl.report_header_id
1059: AND (nvl(aerl.policy_shortpay_flag,'N') = 'Y'
1060: OR ( nvl(aerl.receipt_required_flag, 'N') = 'Y'

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

1099: END GetNumJustReqdLines;
1100:
1101:
1102: -------------------------------------------------------------------
1103: FUNCTION GetNumberOfExpLines(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
1104: p_count OUT NOCOPY NUMBER)
1105: RETURN BOOLEAN IS
1106: -------------------------------------------------------------------
1107: BEGIN

Line 2504: ap_expense_report_headers erh

2500: nvl(cc.transaction_date,sysdate),
2501: erh.employee_id
2502: FROM ap_expense_report_lines erl,
2503: ap_credit_card_trxns cc,
2504: ap_expense_report_headers erh
2505: WHERE erl.report_header_id = erh.report_header_id
2506: AND nvl(erl.itemization_parent_id,0) <> -1 /* Itemization Project */
2507: AND cc.trx_id = erl.credit_card_trx_id -- is a credit card transaction
2508: AND cc.payment_due_from_code in ('BOTH','COMPANY') -- Both Pay split project

Line 4225: UPDATE ap_expense_report_headers

4221: policy_shortpay_flag = null,
4222: adjustment_reason = null
4223: WHERE report_header_id = p_report_header_id;
4224:
4225: UPDATE ap_expense_report_headers
4226: SET audit_code = null, -- Bug 4019412
4227: report_submitted_date = null
4228: WHERE report_header_id = p_report_header_id;
4229:

Line 4722: from ap_expense_report_headers

4718: RETURN BOOLEAN IS
4719: BEGIN
4720: select decode(shortpay_parent_id, null, 'N','Y')
4721: into p_shortpaid_flag
4722: from ap_expense_report_headers
4723: where report_header_id = p_report_header_id;
4724:
4725: RETURN TRUE;
4726:

Line 4923: FROM ap_expense_report_headers XH,

4919: SELECT to_char(nvl(CC.TRANSACTION_DATE,SYSDATE)),
4920: LPAD(to_char(CC.expensed_amount),9),
4921: CC.billed_currency_code,
4922: nvl(CC.Merchant_name1 , Merchant_name2)
4923: FROM ap_expense_report_headers XH,
4924: ap_credit_card_trxns CC,
4925: ap_lookup_codes alc
4926: WHERE XH.report_header_id = p_report_header_id
4927: AND XH.report_header_id = CC.report_header_id

Line 4958: FROM ap_expense_report_headers XH,

4954: BEGIN
4955:
4956: SELECT count(*)
4957: INTO p_personal_count
4958: FROM ap_expense_report_headers XH,
4959: ap_credit_card_trxns CC,
4960: ap_lookup_codes alc
4961: WHERE XH.report_header_id = p_report_header_id
4962: AND XH.report_header_id = CC.report_header_id

Line 5069: UPDATE ap_expense_report_headers_all

5065:
5066: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start resetApplyAdvances');
5067:
5068: -- bug : 4001778/3654956
5069: UPDATE ap_expense_report_headers_all
5070: SET maximum_amount_to_apply = null,
5071: advance_invoice_to_apply = null,
5072: apply_advances_default = null,
5073: prepay_apply_flag = null,