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_UTILITIES_PKG dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 2996: FROM AP_EXPENSE_REPORT_HEADERS_ALL

2992:
2993: SELECT OVERRIDE_APPROVER_ID into p_ApproverId
2994: FROM
2995: ( SELECT OVERRIDE_APPROVER_ID
2996: FROM AP_EXPENSE_REPORT_HEADERS_ALL
2997: WHERE EMPLOYEE_ID = p_EmpId AND BOTHPAY_PARENT_ID IS NULL
2998: ORDER BY report_header_id DESC
2999: ) WHERE ROWNUM=1;
3000:

Line 3182: FROM ap_expense_report_headers_all parent_aerh,

3178: parent_aerh.report_header_id report_header_id,
3179: DECODE(parent_APS.GROSS_AMOUNT ,0,'PAID',
3180: DECODE(parent_AI.Payment_status_flag,
3181: 'Y','PAID','N','INVOICED','P','PARPAID',NULL) ) invoice_status
3182: FROM ap_expense_report_headers_all parent_aerh,
3183: ap_expense_report_headers_all main_aerh,
3184: ap_invoices_all parent_ai,
3185: ap_payment_schedules_all parent_aps
3186: WHERE

Line 3183: ap_expense_report_headers_all main_aerh,

3179: DECODE(parent_APS.GROSS_AMOUNT ,0,'PAID',
3180: DECODE(parent_AI.Payment_status_flag,
3181: 'Y','PAID','N','INVOICED','P','PARPAID',NULL) ) invoice_status
3182: FROM ap_expense_report_headers_all parent_aerh,
3183: ap_expense_report_headers_all main_aerh,
3184: ap_invoices_all parent_ai,
3185: ap_payment_schedules_all parent_aps
3186: WHERE
3187: main_aerh.bothpay_parent_id = parent_aerh.report_header_id (+) and

Line 3199: ap_expense_report_headers_all main_aerh,

3195: DECODE(main_APS.GROSS_AMOUNT ,0,'PAID',
3196: DECODE(main_AI.Payment_status_flag,
3197: 'Y','PAID','N','INVOICED','P','PARPAID',NULL) ) invoice_status
3198: FROM
3199: ap_expense_report_headers_all main_aerh,
3200: ap_invoices_all main_ai,
3201: ap_payment_schedules_all main_aps
3202: WHERE
3203: main_aerh.vouchno = main_ai.invoice_id and

Line 3214: ap_expense_report_headers_all child_aerh,

3210: DECODE(child_APS.GROSS_AMOUNT ,0,'PAID',
3211: DECODE(child_AI.Payment_status_flag,
3212: 'Y','PAID','N','INVOICED','P','PARPAID',NULL) ) invoice_status
3213: FROM
3214: ap_expense_report_headers_all child_aerh,
3215: ap_expense_report_headers_all main_aerh,
3216: ap_invoices_all child_ai,
3217: ap_payment_schedules_all child_aps
3218: WHERE child_aerh.bothpay_parent_id (+) = main_aerh.report_header_id and

Line 3215: ap_expense_report_headers_all main_aerh,

3211: DECODE(child_AI.Payment_status_flag,
3212: 'Y','PAID','N','INVOICED','P','PARPAID',NULL) ) invoice_status
3213: FROM
3214: ap_expense_report_headers_all child_aerh,
3215: ap_expense_report_headers_all main_aerh,
3216: ap_invoices_all child_ai,
3217: ap_payment_schedules_all child_aps
3218: WHERE child_aerh.bothpay_parent_id (+) = main_aerh.report_header_id and
3219: child_aerh.vouchno = child_ai.invoice_id and

Line 3225: l_parent_report_header_id AP_EXPENSE_REPORT_HEADERS_ALL.report_header_id%TYPE;

3221: main_aerh.vouchno = l_invoice_id;
3222:
3223: l_report_status_rec c_report_status%ROWTYPE;
3224:
3225: l_parent_report_header_id AP_EXPENSE_REPORT_HEADERS_ALL.report_header_id%TYPE;
3226: l_parent_invoice_status varchar2(100);
3227: l_main_report_header_id AP_EXPENSE_REPORT_HEADERS_ALL.report_header_id%TYPE;
3228: l_main_invoice_status varchar2(100);
3229: l_child_report_header_id AP_EXPENSE_REPORT_HEADERS_ALL.report_header_id%TYPE;

Line 3227: l_main_report_header_id AP_EXPENSE_REPORT_HEADERS_ALL.report_header_id%TYPE;

3223: l_report_status_rec c_report_status%ROWTYPE;
3224:
3225: l_parent_report_header_id AP_EXPENSE_REPORT_HEADERS_ALL.report_header_id%TYPE;
3226: l_parent_invoice_status varchar2(100);
3227: l_main_report_header_id AP_EXPENSE_REPORT_HEADERS_ALL.report_header_id%TYPE;
3228: l_main_invoice_status varchar2(100);
3229: l_child_report_header_id AP_EXPENSE_REPORT_HEADERS_ALL.report_header_id%TYPE;
3230: l_child_invoice_status varchar2(100);
3231:

Line 3229: l_child_report_header_id AP_EXPENSE_REPORT_HEADERS_ALL.report_header_id%TYPE;

3225: l_parent_report_header_id AP_EXPENSE_REPORT_HEADERS_ALL.report_header_id%TYPE;
3226: l_parent_invoice_status varchar2(100);
3227: l_main_report_header_id AP_EXPENSE_REPORT_HEADERS_ALL.report_header_id%TYPE;
3228: l_main_invoice_status varchar2(100);
3229: l_child_report_header_id AP_EXPENSE_REPORT_HEADERS_ALL.report_header_id%TYPE;
3230: l_child_invoice_status varchar2(100);
3231:
3232: l_parent_report_status VARCHAR2(100);
3233: l_main_report_status VARCHAR2(100);

Line 3335: UPDATE ap_expense_report_headers_all

3331:
3332: IF ( l_parent_report_status IS NOT NULL )
3333: THEN
3334:
3335: UPDATE ap_expense_report_headers_all
3336: SET expense_status_code = l_parent_report_status
3337: WHERE report_header_id = l_parent_report_header_id;
3338: END IF;
3339:

Line 3343: UPDATE ap_expense_report_headers_all

3339:
3340: IF ( l_main_report_status IS NOT NULL )
3341: THEN
3342:
3343: UPDATE ap_expense_report_headers_all
3344: SET expense_status_code = l_main_report_status
3345: WHERE report_header_id = l_main_report_header_id;
3346:
3347: END IF;