APPS.PO_INVOICES_SV2 dependencies on AP_INVOICES_INTERFACE

Line 63: ap_invoices_interface.invoice_amount%TYPE INDEX BY BINARY_INTEGER;

59: TYPE tax_code_id_tbl_type IS TABLE OF
60: po_line_locations.tax_code_id%TYPE INDEX BY BINARY_INTEGER;
61:
62: TYPE invoice_amount_tbl_type IS TABLE OF
63: ap_invoices_interface.invoice_amount%TYPE INDEX BY BINARY_INTEGER;
64:
65: TYPE org_id_tbl_type IS TABLE OF
66: po_headers.org_id%TYPE INDEX BY BINARY_INTEGER;
67:

Line 72: ap_invoices_interface.invoice_id%TYPE INDEX BY BINARY_INTEGER;

68: TYPE invoice_line_num_tbl_type IS TABLE OF
69: ap_invoice_lines_interface.line_number%TYPE INDEX BY BINARY_INTEGER;
70:
71: TYPE invoice_id_tbl_type IS TABLE OF
72: ap_invoices_interface.invoice_id%TYPE INDEX BY BINARY_INTEGER;
73:
74: TYPE invoice_num_tbl_type IS TABLE OF
75: ap_invoices_interface.invoice_num%TYPE INDEX BY BINARY_INTEGER;
76:

Line 75: ap_invoices_interface.invoice_num%TYPE INDEX BY BINARY_INTEGER;

71: TYPE invoice_id_tbl_type IS TABLE OF
72: ap_invoices_interface.invoice_id%TYPE INDEX BY BINARY_INTEGER;
73:
74: TYPE invoice_num_tbl_type IS TABLE OF
75: ap_invoices_interface.invoice_num%TYPE INDEX BY BINARY_INTEGER;
76:
77: TYPE source_tbl_type IS TABLE OF
78: ap_invoices_interface.source%TYPE INDEX BY BINARY_INTEGER;
79:

Line 78: ap_invoices_interface.source%TYPE INDEX BY BINARY_INTEGER;

74: TYPE invoice_num_tbl_type IS TABLE OF
75: ap_invoices_interface.invoice_num%TYPE INDEX BY BINARY_INTEGER;
76:
77: TYPE source_tbl_type IS TABLE OF
78: ap_invoices_interface.source%TYPE INDEX BY BINARY_INTEGER;
79:
80: TYPE description_tbl_type IS TABLE OF
81: ap_invoices_interface.description%TYPE INDEX BY BINARY_INTEGER;
82:

Line 81: ap_invoices_interface.description%TYPE INDEX BY BINARY_INTEGER;

77: TYPE source_tbl_type IS TABLE OF
78: ap_invoices_interface.source%TYPE INDEX BY BINARY_INTEGER;
79:
80: TYPE description_tbl_type IS TABLE OF
81: ap_invoices_interface.description%TYPE INDEX BY BINARY_INTEGER;
82:
83: TYPE pay_curr_code_tbl_type IS TABLE OF
84: po_vendor_sites.payment_currency_code%TYPE INDEX BY BINARY_INTEGER;
85:

Line 87: ap_invoices_interface.terms_id%TYPE INDEX BY BINARY_INTEGER;

83: TYPE pay_curr_code_tbl_type IS TABLE OF
84: po_vendor_sites.payment_currency_code%TYPE INDEX BY BINARY_INTEGER;
85:
86: TYPE terms_id_tbl_type IS TABLE OF
87: ap_invoices_interface.terms_id%TYPE INDEX BY BINARY_INTEGER;
88:
89: TYPE group_id_tbl_type IS TABLE OF
90: ap_invoices_interface.group_id%TYPE INDEX BY BINARY_INTEGER;
91:

Line 90: ap_invoices_interface.group_id%TYPE INDEX BY BINARY_INTEGER;

86: TYPE terms_id_tbl_type IS TABLE OF
87: ap_invoices_interface.terms_id%TYPE INDEX BY BINARY_INTEGER;
88:
89: TYPE group_id_tbl_type IS TABLE OF
90: ap_invoices_interface.group_id%TYPE INDEX BY BINARY_INTEGER;
91:
92: /* Bug 5100177. */
93: TYPE unit_of_meas_tbl_type IS TABLE OF
94: PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE INDEX BY BINARY_INTEGER;

Line 146: invoice_amount ap_invoices_interface.invoice_amount%TYPE,

142: org_id org_id_tbl_type);
143:
144: TYPE curr_condition_rec_type IS RECORD (
145: pay_curr_code po_vendor_sites.payment_currency_code%TYPE,
146: invoice_amount ap_invoices_interface.invoice_amount%TYPE,
147: invoice_id ap_invoices_interface.invoice_id%TYPE,
148: invoice_num ap_invoices_interface.invoice_num%TYPE,
149: vendor_id po_vendors.vendor_id%TYPE,
150: pay_site_id po_vendor_sites.vendor_site_id%TYPE,

Line 147: invoice_id ap_invoices_interface.invoice_id%TYPE,

143:
144: TYPE curr_condition_rec_type IS RECORD (
145: pay_curr_code po_vendor_sites.payment_currency_code%TYPE,
146: invoice_amount ap_invoices_interface.invoice_amount%TYPE,
147: invoice_id ap_invoices_interface.invoice_id%TYPE,
148: invoice_num ap_invoices_interface.invoice_num%TYPE,
149: vendor_id po_vendors.vendor_id%TYPE,
150: pay_site_id po_vendor_sites.vendor_site_id%TYPE,
151: inv_summary_code po_vendor_sites.pay_on_receipt_summary_code%TYPE,

Line 148: invoice_num ap_invoices_interface.invoice_num%TYPE,

144: TYPE curr_condition_rec_type IS RECORD (
145: pay_curr_code po_vendor_sites.payment_currency_code%TYPE,
146: invoice_amount ap_invoices_interface.invoice_amount%TYPE,
147: invoice_id ap_invoices_interface.invoice_id%TYPE,
148: invoice_num ap_invoices_interface.invoice_num%TYPE,
149: vendor_id po_vendors.vendor_id%TYPE,
150: pay_site_id po_vendor_sites.vendor_site_id%TYPE,
151: inv_summary_code po_vendor_sites.pay_on_receipt_summary_code%TYPE,
152: po_header_id po_headers.po_header_id%TYPE,

Line 160: invoice_date ap_invoices_interface.invoice_date%TYPE

156: conversion_type po_headers.rate_type%TYPE,
157: conversion_date po_headers.rate_date%TYPE,
158: payment_terms_id po_headers.terms_id%TYPE,
159: creation_date po_headers.creation_date%TYPE,
160: invoice_date ap_invoices_interface.invoice_date%TYPE
161: );
162:
163: /* Cursor for fetching consumption advice */
164:

Line 229: FROM ap_invoices_interface aii,

225: AND pvs.pay_on_code IN ('RECEIPT_AND_USE', 'USE')
226: AND pod.quantity_ordered > NVL(pod.quantity_billed,0)
227: AND poll.closed_code <> 'FINALLY CLOSED'
228: AND NOT EXISTS ( SELECT 'use invoice is interfaced'
229: FROM ap_invoices_interface aii,
230: ap_invoice_lines_interface aili
231: WHERE aii.invoice_id = aili.invoice_id
232: AND nvl(aii.status,'PENDING') <> 'PROCESSED'
233: AND aili.po_distribution_id = pod.po_distribution_id )

Line 296: FROM ap_invoices_interface aii,

292: AND pvs.pay_on_code IN ('RECEIPT_AND_USE', 'USE')
293: AND pod.quantity_ordered > NVL(pod.quantity_billed,0)
294: AND poll.closed_code <> 'FINALLY CLOSED'
295: AND NOT EXISTS ( SELECT 'use invoice is interfaced'
296: FROM ap_invoices_interface aii,
297: ap_invoice_lines_interface aili
298: WHERE aii.invoice_id = aili.invoice_id
299: AND nvl(aii.status,'PENDING') <> 'PROCESSED'
300: AND aili.po_distribution_id = pod.po_distribution_id )

Line 753: into AP_INVOICES_INTERFACE

749: /*==================================================================
750: PROCEDURE NAME: create_invoice_hdr
751:
752: DESCRIPTION: bulk insert records from p_ap_inv_header structure
753: into AP_INVOICES_INTERFACE
754:
755:
756: PARAMETERS:
757: x_return_status : return status of the procedure