DBA Data[Home] [Help]

APPS.PO_INVOICES_SV2 dependencies on AP_INVOICES_INTERFACE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 142: invoice_amount ap_invoices_interface.invoice_amount%TYPE,

138: org_id org_id_tbl_type);
139:
140: TYPE curr_condition_rec_type IS RECORD (
141: pay_curr_code po_vendor_sites.payment_currency_code%TYPE,
142: invoice_amount ap_invoices_interface.invoice_amount%TYPE,
143: invoice_id ap_invoices_interface.invoice_id%TYPE,
144: invoice_num ap_invoices_interface.invoice_num%TYPE,
145: vendor_id po_vendors.vendor_id%TYPE,
146: pay_site_id po_vendor_sites.vendor_site_id%TYPE,

Line 143: invoice_id ap_invoices_interface.invoice_id%TYPE,

139:
140: TYPE curr_condition_rec_type IS RECORD (
141: pay_curr_code po_vendor_sites.payment_currency_code%TYPE,
142: invoice_amount ap_invoices_interface.invoice_amount%TYPE,
143: invoice_id ap_invoices_interface.invoice_id%TYPE,
144: invoice_num ap_invoices_interface.invoice_num%TYPE,
145: vendor_id po_vendors.vendor_id%TYPE,
146: pay_site_id po_vendor_sites.vendor_site_id%TYPE,
147: inv_summary_code po_vendor_sites.pay_on_receipt_summary_code%TYPE,

Line 144: invoice_num ap_invoices_interface.invoice_num%TYPE,

140: TYPE curr_condition_rec_type IS RECORD (
141: pay_curr_code po_vendor_sites.payment_currency_code%TYPE,
142: invoice_amount ap_invoices_interface.invoice_amount%TYPE,
143: invoice_id ap_invoices_interface.invoice_id%TYPE,
144: invoice_num ap_invoices_interface.invoice_num%TYPE,
145: vendor_id po_vendors.vendor_id%TYPE,
146: pay_site_id po_vendor_sites.vendor_site_id%TYPE,
147: inv_summary_code po_vendor_sites.pay_on_receipt_summary_code%TYPE,
148: po_header_id po_headers.po_header_id%TYPE,

Line 156: invoice_date ap_invoices_interface.invoice_date%TYPE

152: conversion_type po_headers.rate_type%TYPE,
153: conversion_date po_headers.rate_date%TYPE,
154: payment_terms_id po_headers.terms_id%TYPE,
155: creation_date po_headers.creation_date%TYPE,
156: invoice_date ap_invoices_interface.invoice_date%TYPE
157: );
158:
159: /* Cursor for fetching consumption advice */
160:

Line 224: FROM ap_invoices_interface aii,

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

Line 290: FROM ap_invoices_interface aii,

286: AND pvs.pay_on_code IN ('RECEIPT_AND_USE', 'USE')
287: AND pod.quantity_ordered > NVL(pod.quantity_billed,0)
288: AND poll.closed_code <> 'FINALLY CLOSED'
289: AND NOT EXISTS ( SELECT 'use invoice is interfaced'
290: FROM ap_invoices_interface aii,
291: ap_invoice_lines_interface aili
292: WHERE aii.invoice_id = aili.invoice_id
293: AND nvl(aii.status,'PENDING') <> 'PROCESSED'
294: AND aili.po_distribution_id = pod.po_distribution_id )

Line 746: into AP_INVOICES_INTERFACE

742: /*==================================================================
743: PROCEDURE NAME: create_invoice_hdr
744:
745: DESCRIPTION: bulk insert records from p_ap_inv_header structure
746: into AP_INVOICES_INTERFACE
747:
748:
749: PARAMETERS:
750: x_return_status : return status of the procedure