APPS.PO_WF_PO_PRICAT_UPDATE dependencies on PO_LINES_INTERFACE

Line 49: FROM po_lines_interface

45: c_interface_line_id number;
46:
47: cursor C_temp_lines_interface IS
48: SELECT interface_header_id, interface_line_id, price_chg_accept_flag, price_break_flag
49: FROM po_lines_interface
50: WHERE interface_header_id = X_interface_header_id
51: AND NVL(process_code, 'PENDING') = X_process_code
52: ORDER By interface_line_id, unit_price desc;
53:

Line 130: update po_lines_interface

126: else
127:
128: -- process price break - update acceptance flag.
129:
130: update po_lines_interface
131: set price_chg_accept_flag = x_current_line_accept_flag
132: where interface_header_id = c_interface_header_id
133: and interface_line_id = c_interface_line_id;
134:

Line 184: from PO_LINES_INTERFACE

180:
181: begin
182: select 'COMPLETE:N' into result from sys.dual
183: where exists ( select 'un_processed_items_exist'
184: from PO_LINES_INTERFACE
185: where interface_header_id = x_interface_header_id
186: and NVL(process_code, 'PENDING') = 'NOTIFIED'
187: and NVL(price_chg_accept_flag,'NULL') = 'NULL' );
188: exception

Line 222: from PO_LINES_INTERFACE

218:
219: begin
220: select 'COMPLETE:Y' into result from sys.dual
221: where exists ( select 'items_were_rejected'
222: from PO_LINES_INTERFACE
223: where interface_header_id = x_interface_header_id
224: and NVL(process_code, 'PENDING') = 'NOTIFIED'
225: and NVL(price_chg_accept_flag,'NULL') = 'N');
226: exception