APPS.AP_RETAINAGE_RELEASE_PKG dependencies on AP_INVOICE_LINES_ALL

Line 10: line_number ap_invoice_lines_all.line_number%TYPE,

6: po_line_id po_line_locations_all.po_line_id%TYPE,
7: po_release_id po_line_locations_all.po_release_id%TYPE,
8: line_location_id po_line_locations_all.line_location_id%TYPE,
9: invoice_id ap_invoices_all.invoice_id%TYPE,
10: line_number ap_invoice_lines_all.line_number%TYPE,
11: release_amount number,
12: release_amount_remaining number);
13:
14: TYPE release_shipments_tab IS TABLE OF release_shipments_record INDEX BY BINARY_INTEGER;

Line 20: (c_line_location_id IN ap_invoice_lines_all.po_line_location_id%TYPE) Is

16: Procedure create_release (x_invoice_id IN ap_invoices_all.invoice_id%TYPE,
17: x_release_shipments_tab IN release_shipments_tab);
18: /*
19: CURSOR c_retained_lines
20: (c_line_location_id IN ap_invoice_lines_all.po_line_location_id%TYPE) Is
21: SELECT ai.invoice_currency_code,
22: ai.exchange_rate,
23: ail.invoice_id,
24: ail.line_number,

Line 119: ap_invoice_lines_all ail

115: ail.user_defined_fisc_class,
116: ail.purchasing_category_id,
117: ail.wfapproval_status
118: FROM ap_invoices_all ai,
119: ap_invoice_lines_all ail
120: WHERE ai.invoice_id = ail.invoice_id
121: AND ail.po_line_location_id = c_line_location_id
122: AND ail.retained_amount_remaining > 0
123: AND ail.line_type_lookup_code = 'ITEM'

Line 135: (c_line_location_id IN ap_invoice_lines_all.po_line_location_id%TYPE) Is

131: -- The select columns in c_retained_lines_po and c_retained_lines_inv should always match.
132: --
133:
134: CURSOR c_retained_lines_po
135: (c_line_location_id IN ap_invoice_lines_all.po_line_location_id%TYPE) Is
136: SELECT ai.invoice_currency_code,
137: ai.exchange_rate,
138: ail.*
139: FROM ap_invoices_all ai,

Line 140: ap_invoice_lines_all ail

136: SELECT ai.invoice_currency_code,
137: ai.exchange_rate,
138: ail.*
139: FROM ap_invoices_all ai,
140: ap_invoice_lines_all ail
141: WHERE ai.invoice_id = ail.invoice_id
142: AND ail.po_line_location_id = c_line_location_id
143: AND ail.retained_amount_remaining > 0
144: AND ail.line_type_lookup_code = 'ITEM'

Line 150: (c_invoice_id IN ap_invoice_lines_all.invoice_id%TYPE,

146: AND NVL(ail.line_selected_for_release_flag,'N') <> 'Y'
147: ORDER BY ai.creation_date;
148:
149: CURSOR c_retained_lines_inv
150: (c_invoice_id IN ap_invoice_lines_all.invoice_id%TYPE,
151: c_line_number IN ap_invoice_lines_all.line_number%TYPE) Is
152: SELECT ai.invoice_currency_code,
153: ai.exchange_rate,
154: ail.*

Line 151: c_line_number IN ap_invoice_lines_all.line_number%TYPE) Is

147: ORDER BY ai.creation_date;
148:
149: CURSOR c_retained_lines_inv
150: (c_invoice_id IN ap_invoice_lines_all.invoice_id%TYPE,
151: c_line_number IN ap_invoice_lines_all.line_number%TYPE) Is
152: SELECT ai.invoice_currency_code,
153: ai.exchange_rate,
154: ail.*
155: FROM ap_invoices_all ai,

Line 156: ap_invoice_lines_all ail

152: SELECT ai.invoice_currency_code,
153: ai.exchange_rate,
154: ail.*
155: FROM ap_invoices_all ai,
156: ap_invoice_lines_all ail
157: WHERE ai.invoice_id = ail.invoice_id
158: AND ai.invoice_id = c_invoice_id
159: AND ail.line_number = c_line_number
160: ORDER BY ai.creation_date;