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 1631: AP_INVOICE_LINES_INTERFACE_S.nextval,

1627: p_lines_rec.wfapproval_status,
1628: p_lines_rec.pa_quantity,
1629: p_lines_rec.instruction_id,
1630: p_lines_rec.adj_type,
1631: AP_INVOICE_LINES_INTERFACE_S.nextval,
1632: p_lines_rec.cost_factor_id);
1633:
1634:
1635: --

Line 1849: ap_invoice_lines_interface IL

1845: L.REFERENCE_KEY1,
1846: L.REFERENCE_KEY2,
1847: L.RCV_SHIPMENT_LINE_ID
1848: FROM ap_invoice_lines L,
1849: ap_invoice_lines_interface IL
1850: WHERE L.po_line_location_id = IL.po_line_location_id
1851: AND IL.invoice_id = p_instruction_id
1852: AND IL.invoice_line_id = p_instruction_line_id
1853: AND L.discarded_flag <> 'Y'