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 26: ap_expense_report_headers_all aeh,

22: aeh.org_id OU_ID,
23: hou.name,
24: aeh.default_currency_code
25: FROM
26: ap_expense_report_headers_all aeh,
27: ap_suppliers aps,
28: ap_suppliers apsbp,
29: per_employees_x per,
30: ap_lookup_codes alc,

Line 55: ap_expense_report_headers_all aeh,

51: aeh.org_id OU_ID,
52: hou.name,
53: aeh.default_currency_code
54: FROM
55: ap_expense_report_headers_all aeh,
56: ap_suppliers aps,
57: per_cont_workers_x per,
58: ap_lookup_codes alc,
59: hr_organization_units hou

Line 85: ap_expense_report_headers_all aeh, hr_organization_units hou

81: aeh.org_id OU_ID,
82: hou.name,
83: aeh.default_currency_code
84: FROM ap_invoices_all I, ap_invoices_all P, ap_suppliers V,
85: ap_expense_report_headers_all aeh, hr_organization_units hou
86: WHERE aeh.request_id = l_req_id
87: AND aeh.vouchno is not null
88: AND hou.organization_id(+) = aeh.org_id
89: AND I.invoice_id = aeh.vouchno

Line 117: ap_expense_report_headers_all aeh,

113: aeh.org_id OU_ID,
114: hou.name,
115: aeh.default_currency_code
116: FROM
117: ap_expense_report_headers_all aeh,
118: ap_invoices_all ai,
119: ap_suppliers aps,
120: ap_suppliers apsbp,
121: per_employees_x per,

Line 151: ap_expense_report_headers_all aeh,

147: aeh.org_id OU_ID,
148: hou.name,
149: aeh.default_currency_code
150: FROM
151: ap_expense_report_headers_all aeh,
152: ap_invoices_all ai,
153: ap_suppliers aps,
154: per_cont_workers_x per,
155: ap_lookup_codes alc,

Line 176: l_inv_num ap_expense_report_headers_all.invoice_num%TYPE;

172: l_full_name per_employees_x.full_name%TYPE;
173: l_emp_num per_employees_x.employee_num%TYPE;
174: l_vendor_name ap_suppliers.vendor_name%TYPE;
175: l_vendor_num ap_suppliers.segment1%TYPE;
176: l_inv_num ap_expense_report_headers_all.invoice_num%TYPE;
177: l_inv_date ap_expense_report_headers_all.week_end_date%TYPE;
178: l_inv_curr ap_expense_report_headers_all.payment_currency_code%TYPE;
179: l_inv_amount ap_expense_report_headers_all.total%TYPE;
180: l_reject_reason ap_lookup_codes.description%TYPE;

Line 177: l_inv_date ap_expense_report_headers_all.week_end_date%TYPE;

173: l_emp_num per_employees_x.employee_num%TYPE;
174: l_vendor_name ap_suppliers.vendor_name%TYPE;
175: l_vendor_num ap_suppliers.segment1%TYPE;
176: l_inv_num ap_expense_report_headers_all.invoice_num%TYPE;
177: l_inv_date ap_expense_report_headers_all.week_end_date%TYPE;
178: l_inv_curr ap_expense_report_headers_all.payment_currency_code%TYPE;
179: l_inv_amount ap_expense_report_headers_all.total%TYPE;
180: l_reject_reason ap_lookup_codes.description%TYPE;
181: l_invoice_num ap_invoices_all.invoice_num%TYPE;

Line 178: l_inv_curr ap_expense_report_headers_all.payment_currency_code%TYPE;

174: l_vendor_name ap_suppliers.vendor_name%TYPE;
175: l_vendor_num ap_suppliers.segment1%TYPE;
176: l_inv_num ap_expense_report_headers_all.invoice_num%TYPE;
177: l_inv_date ap_expense_report_headers_all.week_end_date%TYPE;
178: l_inv_curr ap_expense_report_headers_all.payment_currency_code%TYPE;
179: l_inv_amount ap_expense_report_headers_all.total%TYPE;
180: l_reject_reason ap_lookup_codes.description%TYPE;
181: l_invoice_num ap_invoices_all.invoice_num%TYPE;
182: l_prepay_num ap_invoices_all.invoice_num%TYPE;

Line 179: l_inv_amount ap_expense_report_headers_all.total%TYPE;

175: l_vendor_num ap_suppliers.segment1%TYPE;
176: l_inv_num ap_expense_report_headers_all.invoice_num%TYPE;
177: l_inv_date ap_expense_report_headers_all.week_end_date%TYPE;
178: l_inv_curr ap_expense_report_headers_all.payment_currency_code%TYPE;
179: l_inv_amount ap_expense_report_headers_all.total%TYPE;
180: l_reject_reason ap_lookup_codes.description%TYPE;
181: l_invoice_num ap_invoices_all.invoice_num%TYPE;
182: l_prepay_num ap_invoices_all.invoice_num%TYPE;
183: l_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;

Line 190: l_exp_desc ap_expense_report_headers_all.description%TYPE;

186: l_prepay_remaining NUMBER;
187: l_per_prepay NUMBER;
188: l_prepay_applied NUMBER;
189: l_vouchno NUMBER;
190: l_exp_desc ap_expense_report_headers_all.description%TYPE;
191: l_hold ap_lookup_codes.description%TYPE;
192: l_org_id NUMBER;
193: l_prev_org_id NUMBER;
194: l_org_name hr_organization_units.name%TYPE;

Line 199: l_def_currency_code ap_expense_report_headers_all.default_currency_code%TYPE;

195: l_print_header BOOLEAN := TRUE;
196: l_page_count NUMBER;
197: l_base_currency ap_system_parameters_all.base_currency_code%TYPE;
198: l_default_rate_type ap_system_parameters_all.default_exchange_rate_type%TYPE;
199: l_def_currency_code ap_expense_report_headers_all.default_currency_code%TYPE;
200: l_conv_amount NUMBER := 0;
201: l_total_func_amount NUMBER := 0;
202: l_rate NUMBER := 0;
203: l_header NUMBER := 0;

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

789: -- Bug: 11071821, Validate Line and Dist amounts for nulls
790: ---------------------------------------------------------------------------------------------------------
791:
792: PROCEDURE ValidateAmounts(p_report_header_id IN NUMBER,
793: p_reject_code OUT NOCOPY ap_expense_report_headers.reject_code%TYPE) IS
794: l_line_count NUMBER := 0;
795: l_dist_count NUMBER := 0;
796: l_header_total NUMBER;
797: l_line_total NUMBER;

Line 834: select total into l_header_total from ap_expense_report_headers_all where report_header_id = p_report_header_id;

830: p_reject_code := 'LINE AMOUNT IS NULL';
831: END IF;
832:
833: l_debug_info := 'Fetching Header Total';
834: select total into l_header_total from ap_expense_report_headers_all where report_header_id = p_report_header_id;
835:
836: -- Bug 14627375: Personal expenses to be excluded
837: select parameter_id into l_parameter_id from ap_expense_report_params_all where expense_type_code = 'PERSONAL';
838:

Line 1071: p_reject_code OUT NOCOPY ap_expense_report_headers.reject_code%TYPE)

1067: -- Bug#2823530 : Validate the attachments before transferring to AP.
1068: -----------------
1069: -----------------------------------------------------------------------------------------------
1070: PROCEDURE ValidateAttachCategory(p_report_header_id IN NUMBER,
1071: p_reject_code OUT NOCOPY ap_expense_report_headers.reject_code%TYPE)
1072: IS
1073:
1074: l_count_invalid_cat NUMBER;
1075:

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

1124: p_valid_inv_gl_date IN DATE,
1125: p_source_item IN VARCHAR2,
1126: p_set_of_books_id IN ap_system_parameters.set_of_books_id%TYPE,
1127: p_open_gl_date OUT NOCOPY DATE,
1128: p_reject_code OUT NOCOPY ap_expense_report_headers.reject_code%TYPE) IS
1129: l_gl_period_status varchar2(2);
1130: l_new_gl_date ap_expense_report_headers_all.week_end_date%TYPE;
1131: l_debug_info VARCHAR2(2000);
1132: BEGIN

Line 1130: l_new_gl_date ap_expense_report_headers_all.week_end_date%TYPE;

1126: p_set_of_books_id IN ap_system_parameters.set_of_books_id%TYPE,
1127: p_open_gl_date OUT NOCOPY DATE,
1128: p_reject_code OUT NOCOPY ap_expense_report_headers.reject_code%TYPE) IS
1129: l_gl_period_status varchar2(2);
1130: l_new_gl_date ap_expense_report_headers_all.week_end_date%TYPE;
1131: l_debug_info VARCHAR2(2000);
1132: BEGIN
1133:
1134: IF (p_source_date IS NULL) THEN

Line 1387: FROM ap_expense_report_headers_all aerh, ap_invoices_all ai

1383:
1384: CURSOR c_successful_invoices(l_request_id IN NUMBER) IS
1385: SELECT ai.invoice_id, aerh.report_header_id,
1386: aerh.advance_invoice_to_apply, aerh.maximum_amount_to_apply
1387: FROM ap_expense_report_headers_all aerh, ap_invoices_all ai
1388: WHERE ai.APPLICATION_ID = 200
1389: AND ai.PRODUCT_TABLE = 'AP_EXPENSE_REPORT_HEADERS_ALL'
1390: AND ai.REFERENCE_KEY1 = aerh.report_header_id
1391: AND aerh.invoice_num = ai.invoice_num

Line 1389: AND ai.PRODUCT_TABLE = 'AP_EXPENSE_REPORT_HEADERS_ALL'

1385: SELECT ai.invoice_id, aerh.report_header_id,
1386: aerh.advance_invoice_to_apply, aerh.maximum_amount_to_apply
1387: FROM ap_expense_report_headers_all aerh, ap_invoices_all ai
1388: WHERE ai.APPLICATION_ID = 200
1389: AND ai.PRODUCT_TABLE = 'AP_EXPENSE_REPORT_HEADERS_ALL'
1390: AND ai.REFERENCE_KEY1 = aerh.report_header_id
1391: AND aerh.invoice_num = ai.invoice_num
1392: AND aerh.request_id = l_request_id
1393: AND aerh.vouchno = 0;

Line 1577: FROM ap_expense_report_headers XH,

1573: '' alternate_name,
1574: '' amount_app_to_discount,
1575: V.payment_method_lookup_code,
1576: emps.is_contingent
1577: FROM ap_expense_report_headers XH,
1578: hr_locations locs,
1579: per_all_people_f people,
1580: (SELECT
1581: h.employee_id,

Line 1668: l_reject_code ap_expense_report_headers.reject_code%TYPE;

1664: l_payment_due_from VARCHAR2(15);
1665: l_invoice_rec InvoiceInfoRecType;
1666: l_invoice_lines_rec_tab InvoiceLinesRecTabType;
1667: l_request_id NUMBER;
1668: l_reject_code ap_expense_report_headers.reject_code%TYPE;
1669: l_total ap_expense_report_headers.total%TYPE;
1670: l_invoices_fetched NUMBER := 0;
1671: l_invoices_created NUMBER := 0;
1672: l_cc_invoices_fetched NUMBER := 0;

Line 1669: l_total ap_expense_report_headers.total%TYPE;

1665: l_invoice_rec InvoiceInfoRecType;
1666: l_invoice_lines_rec_tab InvoiceLinesRecTabType;
1667: l_request_id NUMBER;
1668: l_reject_code ap_expense_report_headers.reject_code%TYPE;
1669: l_total ap_expense_report_headers.total%TYPE;
1670: l_invoices_fetched NUMBER := 0;
1671: l_invoices_created NUMBER := 0;
1672: l_cc_invoices_fetched NUMBER := 0;
1673: l_cc_invoices_created NUMBER := 0;

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

1685: l_emp_pg_lookup_code ap_system_parameters.employee_pay_group_lookup_code%TYPE;
1686: l_emp_terms_id ap_system_parameters.employee_terms_id%TYPE;
1687: l_sys_apply_advances_flag ap_system_parameters.apply_advances_default%TYPE;
1688:
1689: TYPE ReportHeaderIdType IS TABLE OF ap_expense_report_headers.report_header_id%TYPE
1690: INDEX BY BINARY_INTEGER;
1691: TYPE RejectCodeType IS TABLE OF ap_interface_rejections.reject_lookup_code%TYPE
1692: INDEX BY BINARY_INTEGER;
1693: TYPE InvoiceIdType IS TABLE OF ap_invoices_interface.invoice_id%TYPE

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

1691: TYPE RejectCodeType IS TABLE OF ap_interface_rejections.reject_lookup_code%TYPE
1692: INDEX BY BINARY_INTEGER;
1693: TYPE InvoiceIdType IS TABLE OF ap_invoices_interface.invoice_id%TYPE
1694: INDEX BY BINARY_INTEGER;
1695: TYPE AdvAppliedType IS TABLE OF ap_expense_report_headers.maximum_amount_to_apply%TYPE
1696: INDEX BY BINARY_INTEGER;
1697:
1698: l_report_header_id_list ReportHeaderIdType;
1699: l_reject_code_list RejectCodeType;

Line 1705: l_expense_status_code ap_expense_report_headers_all.expense_status_code%TYPE;

1701: l_vendor_rec VendorInfoRecType;
1702: l_oie_applied_prepay_list InvoiceIdType;
1703: l_oie_applied_amt_list AdvAppliedType;
1704:
1705: l_expense_status_code ap_expense_report_headers_all.expense_status_code%TYPE;
1706: l_actual_adv_applied NUMBER;
1707: x_return_status VARCHAR2(4000);
1708: x_msg_count NUMBER;
1709: x_msg_data VARCHAR2(4000);

Line 1723: l_new_gl_date ap_expense_report_headers_all.week_end_date%TYPE;

1719: l_le_id number;
1720: l_available_prepays NUMBER;
1721: l_gl_period_status varchar2(2);
1722: l_period_year varchar2(5);
1723: l_new_gl_date ap_expense_report_headers_all.week_end_date%TYPE;
1724:
1725:
1726: BEGIN
1727:

Line 2583: UPDATE ap_expense_report_headers_all

2579: fnd_file.put_line(fnd_file.log, l_debug_info);
2580: END IF;
2581:
2582:
2583: UPDATE ap_expense_report_headers_all
2584: SET apply_advances_default = 'N'
2585: WHERE report_header_id = l_invoice_rec.report_header_id;
2586:
2587: l_invoice_rec.apply_advances_flag := 'N';

Line 2602: UPDATE ap_expense_report_headers_all

2598: fnd_file.put_line(fnd_file.log, l_debug_info);
2599: END IF;
2600:
2601:
2602: UPDATE ap_expense_report_headers_all
2603: SET apply_advances_default = 'Y'
2604: WHERE report_header_id = l_invoice_rec.report_header_id;
2605:
2606: l_invoice_rec.apply_advances_flag := 'Y';

Line 2689: UPDATE ap_expense_report_headers_all

2685: IF g_debug_switch = 'Y' THEN
2686: fnd_file.put_line(fnd_file.log, l_debug_info);
2687: END IF;
2688:
2689: UPDATE ap_expense_report_headers_all
2690: SET request_id = l_request_id,
2691: last_update_date = sysdate,
2692: last_updated_by = g_last_updated_by,
2693: last_update_login = g_last_update_login

Line 2706: UPDATE ap_expense_report_headers_all

2702: IF g_debug_switch = 'Y' THEN
2703: fnd_file.put_line(fnd_file.log, l_debug_info);
2704: END IF;
2705:
2706: UPDATE ap_expense_report_headers_all
2707: SET reject_code = l_reject_code,
2708: request_id = l_request_id,
2709: vouchno = 0,
2710: last_update_date = sysdate,

Line 2780: UPDATE ap_expense_report_headers_all

2776: FETCH c_successful_invoices BULK COLLECT INTO l_invoice_id_list, l_report_header_id_list,
2777: l_oie_applied_prepay_list, l_oie_applied_amt_list;
2778:
2779: FORALL i IN l_report_header_id_list.FIRST .. l_report_header_id_list.LAST
2780: UPDATE ap_expense_report_headers_all
2781: SET vouchno = l_invoice_id_list(i),
2782: reject_code = null
2783: WHERE report_header_id = l_report_header_id_list(i);
2784:

Line 2806: UPDATE ap_expense_report_headers_all

2802: l_actual_adv_applied := 0;
2803: END;
2804:
2805: IF ( l_oie_applied_amt_list(i) <> l_actual_adv_applied) THEN
2806: UPDATE ap_expense_report_headers_all
2807: SET maximum_amount_to_apply = l_actual_adv_applied,
2808: amt_due_employee = ( nvl(amt_due_employee,0) + (l_oie_applied_amt_list(i) - l_actual_adv_applied) )
2809: WHERE report_header_id = l_report_header_id_list(i);
2810:

Line 2812: 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);

2808: amt_due_employee = ( nvl(amt_due_employee,0) + (l_oie_applied_amt_list(i) - l_actual_adv_applied) )
2809: WHERE report_header_id = l_report_header_id_list(i);
2810:
2811: -----------------------------------------------------------------------
2812: 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);
2813: -----------------------------------------------------------------------
2814: fnd_file.put_line(fnd_file.log, l_debug_info);
2815:
2816: END IF;

Line 2846: UPDATE ap_expense_report_headers_all ah

2842: IF (l_payment_due_frm ='BOTH') THEN
2843: l_expense_status_code := 'PARPAID';
2844: END IF;
2845:
2846: UPDATE ap_expense_report_headers_all ah
2847: SET expense_status_code = l_expense_status_code
2848: WHERE report_header_id = l_report_header_id_list(i) ;
2849:
2850: END IF;

Line 2898: UPDATE ap_expense_report_headers_all

2894: fnd_file.put_line(fnd_file.log, l_debug_info);
2895: END IF;
2896:
2897: FORALL i IN l_report_header_id_list.FIRST .. l_report_header_id_list.LAST
2898: UPDATE ap_expense_report_headers_all
2899: SET reject_code = l_reject_code_list(i), vouchno = 0
2900: WHERE report_header_id = l_report_header_id_list(i)
2901: and nvl(vouchno,0) = 0;
2902:

Line 3134: ap_expense_report_headers XH

3130: FROM ap_expense_report_lines XL,
3131: gl_code_combinations gcc,
3132: ap_lookup_codes lc,
3133: fnd_currencies F,
3134: ap_expense_report_headers XH
3135: WHERE XL.report_header_id = XH.report_header_id
3136: AND XH.report_header_id = p_report_header_id
3137: AND XL.code_combination_id = gcc.code_combination_id(+)
3138: AND nvl(XL.itemization_parent_id,0) <> -1 /* Itemization Project */

Line 3345: 'AP_EXPENSE_REPORT_HEADERS_ALL',

3341: PAYMENT_PRIORITY)
3342: VALUES
3343: (p_invoice_rec.invoice_id,
3344: 200,
3345: 'AP_EXPENSE_REPORT_HEADERS_ALL',
3346: p_invoice_rec.report_header_id,
3347: p_invoice_rec.invoice_num,
3348: p_invoice_rec.invoice_type_lookup_code,
3349: p_invoice_rec.week_end_date,

Line 3685: ap_expense_report_headers XH

3681: FROM ap_expense_report_lines XL,
3682: gl_code_combinations gcc,
3683: ap_lookup_codes lc,
3684: fnd_currencies F,
3685: ap_expense_report_headers XH
3686: WHERE XL.report_header_id = XH.report_header_id
3687: AND XH.report_header_id = p_report_header_id
3688: AND XL.code_combination_id = gcc.code_combination_id(+)
3689: AND nvl(XL.itemization_parent_id,0) <> -1 /* Itemization Project */

Line 4446: p_org_id IN ap_expense_report_headers.org_id%TYPE,

4442: END GetVendorInfo;
4443:
4444: ------------------------------------------------------------------------
4445: FUNCTION CreatePayee(p_party_id IN ap_suppliers.party_id%TYPE,
4446: p_org_id IN ap_expense_report_headers.org_id%TYPE,
4447: p_reject_code OUT NOCOPY VARCHAR2)
4448: RETURN BOOLEAN IS
4449: ------------------------------------------------------------------------
4450: l_debug_info VARCHAR2(2000);