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.OZF_AP_INTERFACE_PVT dependencies on AP_INVOICES

Line 197: select ap_invoices_interface_s.nextval

193: WHERE claim_id = cv_claim_id;
194: */
195:
196: CURSOR invoice_int_seq_csr IS
197: select ap_invoices_interface_s.nextval
198: from dual;
199:
200: CURSOR invoice_line_int_seq_csr IS
201: select ap_invoice_lines_interface_s.nextval

Line 223: from AP_INVOICES

219: -- kishore
220:
221: CURSOR Get_Invoicenum_csr(cv_invoice_num IN VARCHAR2, cv_vendor_id IN NUMBER) IS
222: select invoice_num
223: from AP_INVOICES
224: where INVOICE_NUM = cv_invoice_num
225: and VENDOR_ID = cv_vendor_id;
226:
227: CURSOR csr_get_claim_lines(cv_claim_id IN NUMBER) IS

Line 665: INSERT INTO AP_INVOICES_INTERFACE (

661: END IF;
662: END IF;
663:
664: -- Inserting an Invoice header record into AP_INVOICE_INTERFACE table.
665: INSERT INTO AP_INVOICES_INTERFACE (
666: INVOICE_ID
667: , INVOICE_NUM
668: , INVOICE_DATE
669: , VENDOR_ID