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

Line 14: p_reject_code OUT NOCOPY ap_expense_report_headers.reject_code%TYPE) IS

10: p_valid_inv_gl_date IN DATE,
11: p_source_item IN VARCHAR2,
12: p_set_of_books_id IN ap_system_parameters.set_of_books_id%TYPE,
13: p_open_gl_date OUT NOCOPY DATE,
14: p_reject_code OUT NOCOPY ap_expense_report_headers.reject_code%TYPE) IS
15: l_gl_period_status varchar2(2);
16: l_new_gl_date ap_expense_report_headers_all.week_end_date%TYPE;
17: l_debug_info VARCHAR2(2000);
18: BEGIN

Line 16: l_new_gl_date ap_expense_report_headers_all.week_end_date%TYPE;

12: p_set_of_books_id IN ap_system_parameters.set_of_books_id%TYPE,
13: p_open_gl_date OUT NOCOPY DATE,
14: p_reject_code OUT NOCOPY ap_expense_report_headers.reject_code%TYPE) IS
15: l_gl_period_status varchar2(2);
16: l_new_gl_date ap_expense_report_headers_all.week_end_date%TYPE;
17: l_debug_info VARCHAR2(2000);
18: BEGIN
19:
20: IF (p_source_date IS NULL) THEN

Line 274: FROM ap_expense_report_headers_all aerh, ap_invoices_all ai

270:
271: CURSOR c_successful_invoices(l_request_id IN NUMBER) IS
272: SELECT ai.invoice_id, aerh.report_header_id,
273: aerh.advance_invoice_to_apply, aerh.maximum_amount_to_apply
274: FROM ap_expense_report_headers_all aerh, ap_invoices_all ai
275: WHERE ai.APPLICATION_ID = 200
276: AND ai.PRODUCT_TABLE = 'AP_EXPENSE_REPORT_HEADERS_ALL'
277: AND ai.REFERENCE_KEY1 = aerh.report_header_id
278: AND aerh.invoice_num = ai.invoice_num

Line 276: AND ai.PRODUCT_TABLE = 'AP_EXPENSE_REPORT_HEADERS_ALL'

272: SELECT ai.invoice_id, aerh.report_header_id,
273: aerh.advance_invoice_to_apply, aerh.maximum_amount_to_apply
274: FROM ap_expense_report_headers_all aerh, ap_invoices_all ai
275: WHERE ai.APPLICATION_ID = 200
276: AND ai.PRODUCT_TABLE = 'AP_EXPENSE_REPORT_HEADERS_ALL'
277: AND ai.REFERENCE_KEY1 = aerh.report_header_id
278: AND aerh.invoice_num = ai.invoice_num
279: AND aerh.request_id = l_request_id
280: AND aerh.vouchno = 0;

Line 463: FROM ap_expense_report_headers XH,

459: '' gl_date,
460: '' alternate_name,
461: '' amount_app_to_discount,
462: V.payment_method_lookup_code
463: FROM ap_expense_report_headers XH,
464: hr_locations locs,
465: per_all_people_f people,
466: (SELECT
467: h.employee_id,

Line 554: l_reject_code ap_expense_report_headers.reject_code%TYPE;

550: l_payment_due_from VARCHAR2(15);
551: l_invoice_rec InvoiceInfoRecType;
552: l_invoice_lines_rec_tab InvoiceLinesRecTabType;
553: l_request_id NUMBER;
554: l_reject_code ap_expense_report_headers.reject_code%TYPE;
555: l_total ap_expense_report_headers.total%TYPE;
556: l_invoices_fetched NUMBER := 0;
557: l_invoices_created NUMBER := 0;
558: l_cc_invoices_fetched NUMBER := 0;

Line 555: l_total ap_expense_report_headers.total%TYPE;

551: l_invoice_rec InvoiceInfoRecType;
552: l_invoice_lines_rec_tab InvoiceLinesRecTabType;
553: l_request_id NUMBER;
554: l_reject_code ap_expense_report_headers.reject_code%TYPE;
555: l_total ap_expense_report_headers.total%TYPE;
556: l_invoices_fetched NUMBER := 0;
557: l_invoices_created NUMBER := 0;
558: l_cc_invoices_fetched NUMBER := 0;
559: l_cc_invoices_created NUMBER := 0;

Line 575: TYPE ReportHeaderIdType IS TABLE OF ap_expense_report_headers.report_header_id%TYPE

571: l_emp_pg_lookup_code ap_system_parameters.employee_pay_group_lookup_code%TYPE;
572: l_emp_terms_id ap_system_parameters.employee_terms_id%TYPE;
573: l_sys_apply_advances_flag ap_system_parameters.apply_advances_default%TYPE;
574:
575: TYPE ReportHeaderIdType IS TABLE OF ap_expense_report_headers.report_header_id%TYPE
576: INDEX BY BINARY_INTEGER;
577: TYPE RejectCodeType IS TABLE OF ap_interface_rejections.reject_lookup_code%TYPE
578: INDEX BY BINARY_INTEGER;
579: TYPE InvoiceIdType IS TABLE OF ap_invoices_interface.invoice_id%TYPE

Line 581: TYPE AdvAppliedType IS TABLE OF ap_expense_report_headers.maximum_amount_to_apply%TYPE

577: TYPE RejectCodeType IS TABLE OF ap_interface_rejections.reject_lookup_code%TYPE
578: INDEX BY BINARY_INTEGER;
579: TYPE InvoiceIdType IS TABLE OF ap_invoices_interface.invoice_id%TYPE
580: INDEX BY BINARY_INTEGER;
581: TYPE AdvAppliedType IS TABLE OF ap_expense_report_headers.maximum_amount_to_apply%TYPE
582: INDEX BY BINARY_INTEGER;
583:
584: l_report_header_id_list ReportHeaderIdType;
585: l_reject_code_list RejectCodeType;

Line 591: l_expense_status_code ap_expense_report_headers_all.expense_status_code%TYPE;

587: l_vendor_rec VendorInfoRecType;
588: l_oie_applied_prepay_list InvoiceIdType;
589: l_oie_applied_amt_list AdvAppliedType;
590:
591: l_expense_status_code ap_expense_report_headers_all.expense_status_code%TYPE;
592: l_actual_adv_applied NUMBER;
593: x_return_status VARCHAR2(4000);
594: x_msg_count NUMBER;
595: x_msg_data VARCHAR2(4000);

Line 610: l_new_gl_date ap_expense_report_headers_all.week_end_date%TYPE;

606: l_le_id number;
607: l_available_prepays NUMBER;
608: l_gl_period_status varchar2(2);
609: l_period_year varchar2(5);
610: l_new_gl_date ap_expense_report_headers_all.week_end_date%TYPE;
611:
612:
613: BEGIN
614:

Line 1527: UPDATE ap_expense_report_headers_all

1523: fnd_file.put_line(fnd_file.log, l_debug_info);
1524: END IF;
1525:
1526:
1527: UPDATE ap_expense_report_headers_all
1528: SET apply_advances_default = 'N'
1529: WHERE report_header_id = l_invoice_rec.report_header_id;
1530:
1531: l_invoice_rec.apply_advances_flag := 'N';

Line 1546: UPDATE ap_expense_report_headers_all

1542: fnd_file.put_line(fnd_file.log, l_debug_info);
1543: END IF;
1544:
1545:
1546: UPDATE ap_expense_report_headers_all
1547: SET apply_advances_default = 'Y'
1548: WHERE report_header_id = l_invoice_rec.report_header_id;
1549:
1550: l_invoice_rec.apply_advances_flag := 'Y';

Line 1631: UPDATE ap_expense_report_headers_all

1627: IF g_debug_switch = 'Y' THEN
1628: fnd_file.put_line(fnd_file.log, l_debug_info);
1629: END IF;
1630:
1631: UPDATE ap_expense_report_headers_all
1632: SET request_id = l_request_id
1633: WHERE report_header_id = l_invoice_rec.report_header_id;
1634:
1635:

Line 1645: UPDATE ap_expense_report_headers_all

1641: IF g_debug_switch = 'Y' THEN
1642: fnd_file.put_line(fnd_file.log, l_debug_info);
1643: END IF;
1644:
1645: UPDATE ap_expense_report_headers_all
1646: SET reject_code = l_reject_code,
1647: request_id = l_request_id,
1648: vouchno = 0
1649: WHERE report_header_id = l_invoice_rec.report_header_id;

Line 1716: UPDATE ap_expense_report_headers_all

1712: FETCH c_successful_invoices BULK COLLECT INTO l_invoice_id_list, l_report_header_id_list,
1713: l_oie_applied_prepay_list, l_oie_applied_amt_list;
1714:
1715: FORALL i IN l_report_header_id_list.FIRST .. l_report_header_id_list.LAST
1716: UPDATE ap_expense_report_headers_all
1717: SET vouchno = l_invoice_id_list(i),
1718: reject_code = null
1719: WHERE report_header_id = l_report_header_id_list(i);
1720:

Line 1742: UPDATE ap_expense_report_headers_all

1738: l_actual_adv_applied := 0;
1739: END;
1740:
1741: IF ( l_oie_applied_amt_list(i) <> l_actual_adv_applied) THEN
1742: UPDATE ap_expense_report_headers_all
1743: SET maximum_amount_to_apply = l_actual_adv_applied,
1744: amt_due_employee = ( nvl(amt_due_employee,0) + (l_oie_applied_amt_list(i) - l_actual_adv_applied) )
1745: WHERE report_header_id = l_report_header_id_list(i);
1746:

Line 1748: l_debug_info := 'Updated ap_expense_report_headers_all for report_header_id = '||to_char(l_report_header_id_list(i))||' with maximum_amount_to_apply = '||to_char(l_actual_adv_applied);

1744: amt_due_employee = ( nvl(amt_due_employee,0) + (l_oie_applied_amt_list(i) - l_actual_adv_applied) )
1745: WHERE report_header_id = l_report_header_id_list(i);
1746:
1747: -----------------------------------------------------------------------
1748: l_debug_info := 'Updated ap_expense_report_headers_all for report_header_id = '||to_char(l_report_header_id_list(i))||' with maximum_amount_to_apply = '||to_char(l_actual_adv_applied);
1749: -----------------------------------------------------------------------
1750: fnd_file.put_line(fnd_file.log, l_debug_info);
1751:
1752: END IF;

Line 1782: UPDATE ap_expense_report_headers_all ah

1778: IF (l_payment_due_frm ='BOTH') THEN
1779: l_expense_status_code := 'PARPAID';
1780: END IF;
1781:
1782: UPDATE ap_expense_report_headers_all ah
1783: SET expense_status_code = l_expense_status_code
1784: WHERE report_header_id = l_report_header_id_list(i) ;
1785:
1786: END IF;

Line 1822: UPDATE ap_expense_report_headers_all

1818: fnd_file.put_line(fnd_file.log, l_debug_info);
1819: END IF;
1820:
1821: FORALL i IN l_report_header_id_list.FIRST .. l_report_header_id_list.LAST
1822: UPDATE ap_expense_report_headers_all
1823: SET reject_code = l_reject_code_list(i), vouchno = 0
1824: WHERE report_header_id = l_report_header_id_list(i)
1825: and nvl(vouchno,0) = 0;
1826:

Line 2050: ap_expense_report_headers XH

2046: FROM ap_expense_report_lines XL,
2047: gl_code_combinations gcc,
2048: ap_lookup_codes lc,
2049: fnd_currencies F,
2050: ap_expense_report_headers XH
2051: WHERE XL.report_header_id = XH.report_header_id
2052: AND XH.report_header_id = p_report_header_id
2053: AND XL.code_combination_id = gcc.code_combination_id(+)
2054: AND nvl(XL.itemization_parent_id,0) <> -1 /* Itemization Project */

Line 2246: 'AP_EXPENSE_REPORT_HEADERS_ALL',

2242: PARTY_SITE_ID)
2243: VALUES
2244: (p_invoice_rec.invoice_id,
2245: 200,
2246: 'AP_EXPENSE_REPORT_HEADERS_ALL',
2247: p_invoice_rec.report_header_id,
2248: p_invoice_rec.invoice_num,
2249: p_invoice_rec.invoice_type_lookup_code,
2250: p_invoice_rec.week_end_date,

Line 2576: ap_expense_report_headers XH

2572: FROM ap_expense_report_lines XL,
2573: gl_code_combinations gcc,
2574: ap_lookup_codes lc,
2575: fnd_currencies F,
2576: ap_expense_report_headers XH
2577: WHERE XL.report_header_id = XH.report_header_id
2578: AND XH.report_header_id = p_report_header_id
2579: AND XL.code_combination_id = gcc.code_combination_id(+)
2580: AND nvl(XL.itemization_parent_id,0) <> -1 /* Itemization Project */

Line 3323: p_org_id IN ap_expense_report_headers.org_id%TYPE,

3319: END GetVendorInfo;
3320:
3321: ------------------------------------------------------------------------
3322: FUNCTION CreatePayee(p_party_id IN ap_suppliers.party_id%TYPE,
3323: p_org_id IN ap_expense_report_headers.org_id%TYPE,
3324: p_reject_code OUT NOCOPY VARCHAR2)
3325: RETURN BOOLEAN IS
3326: ------------------------------------------------------------------------
3327: l_debug_info VARCHAR2(2000);