APPS.AP_RETAINAGE_RELEASE_PKG dependencies on AP_INVOICES_ALL

Line 9: invoice_id ap_invoices_all.invoice_id%TYPE,

5: (po_header_id po_line_locations_all.po_header_id%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:

Line 16: Procedure create_release (x_invoice_id IN ap_invoices_all.invoice_id%TYPE,

12: release_amount_remaining number);
13:
14: TYPE release_shipments_tab IS TABLE OF release_shipments_record INDEX BY BINARY_INTEGER;
15:
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

Line 118: FROM ap_invoices_all ai,

114: ail.product_category,
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

Line 139: FROM ap_invoices_all ai,

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,
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

Line 155: FROM ap_invoices_all ai,

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,
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