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_ALL

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 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 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 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 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,