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.PO_CREATE_ASBN_INVOICE dependencies on AP_INVOICES_INTERFACE

Line 159: select ap_invoices_interface_s.nextval

155:
156: if ((X_asbn_header.invoice_num is not null) and
157: (X_asbn_header.invoice_date is not null)) then
158:
159: select ap_invoices_interface_s.nextval
160: into l_invoice_id
161: from sys.dual;
162:
163: -- Bug 4723269 : Pass org_id to create_ap_batches

Line 276: to 'Y' in ap_invoices_interface table. */

272:
273: /* Bug 5107497: As per eTax project, no need to populate Tax lines in
274: ap_invoice_lines_table. We have to populate control_amount
275: with tax amount specified in ASBN and set calc_tax_during_import_flag
276: to 'Y' in ap_invoices_interface table. */
277: UPDATE ap_invoices_interface
278: SET calc_tax_during_import_flag = 'Y',
279: control_amount = X_asbn_header.tax_amount
280: WHERE invoice_id = l_invoice_id;

Line 277: UPDATE ap_invoices_interface

273: /* Bug 5107497: As per eTax project, no need to populate Tax lines in
274: ap_invoice_lines_table. We have to populate control_amount
275: with tax amount specified in ASBN and set calc_tax_during_import_flag
276: to 'Y' in ap_invoices_interface table. */
277: UPDATE ap_invoices_interface
278: SET calc_tax_during_import_flag = 'Y',
279: control_amount = X_asbn_header.tax_amount
280: WHERE invoice_id = l_invoice_id;
281:

Line 403: insert into AP_INVOICES_INTERFACE (

399: x_group_id := substr('ASBN-'||TO_CHAR(p_invoice_id),1,80);
400:
401: l_invoice_amount := ap_utilities_pkg.ap_round_currency(p_invoice_amount,p_invoice_currency_code); --Bug 7004065
402:
403: insert into AP_INVOICES_INTERFACE (
404: INVOICE_ID,
405: INVOICE_NUM,
406: INVOICE_DATE,
407: VENDOR_ID,