APPS.AP_RETRO_PRICING_UTIL_PKG dependencies on AP_INVOICE_LINES_INTERFACE

Line 12: | retropriced shipments(Records in AP_INVOICE_LINES_INTERFACE) are VALID

8: | DESCRIPTION
9: | This function checks for a particular instruction if all the base
10: | matched Invoices(along with Price Corrections,Qty Corrections and the
11: | previously existing(If Any) Retro Price Adjustments Documents ) for the
12: | retropriced shipments(Records in AP_INVOICE_LINES_INTERFACE) are VALID
13: |
14: | PARAMETERS
15: | p_instruction_id
16: | p_org_id

Line 38: FROM ap_invoice_lines_interface IL,

34:
35: debug_info := 'Are Original Invoices Valid';
36: SELECT count(*)
37: INTO l_count
38: FROM ap_invoice_lines_interface IL,
39: ap_invoice_lines_all L
40: WHERE IL.invoice_id = p_instruction_id
41: AND IL.po_line_location_id = L.po_line_location_id
42: AND L.org_id = p_org_id

Line 90: | retropriced shipments(Records in AP_INVOICE_LINES_INTERFACE) has any holds

86: | DESCRIPTION
87: | This function checks for a particular instruction if all the base
88: | matched Invoices(along with Price Corrections, Qty Corrections and the
89: | previously existing(If Any) Retro Price Adjustments Documents ) for the
90: | retropriced shipments(Records in AP_INVOICE_LINES_INTERFACE) has any holds
91: | (other than Price Hold)
92: |
93: | PARAMETERS
94: | p_instruction_id

Line 118: FROM ap_invoice_lines_interface IL,

114:
115: debug_info := 'Are Holds OK';
116: SELECT count(*)
117: INTO l_count
118: FROM ap_invoice_lines_interface IL,
119: ap_invoice_lines_all L
120: WHERE IL.invoice_id = p_instruction_id
121: AND L.org_id = p_org_id
122: AND L.po_line_location_id = IL.po_line_location_id

Line 1666: AP_INVOICE_LINES_INTERFACE_S.nextval,

1662: p_lines_rec.wfapproval_status,
1663: p_lines_rec.pa_quantity,
1664: p_lines_rec.instruction_id,
1665: p_lines_rec.adj_type,
1666: AP_INVOICE_LINES_INTERFACE_S.nextval,
1667: p_lines_rec.cost_factor_id);
1668:
1669:
1670: --

Line 1884: ap_invoice_lines_interface IL

1880: L.REFERENCE_KEY1,
1881: L.REFERENCE_KEY2,
1882: L.RCV_SHIPMENT_LINE_ID
1883: FROM ap_invoice_lines L,
1884: ap_invoice_lines_interface IL
1885: WHERE L.po_line_location_id = IL.po_line_location_id
1886: AND IL.invoice_id = p_instruction_id
1887: AND IL.invoice_line_id = p_instruction_line_id
1888: AND L.discarded_flag <> 'Y'