APPS.PO_AUTO_IMPLEMENT_PVT dependencies on PO_LINES_INTERFACE

Line 57: x_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE;

53: x_style_id PO_HEADERS_INTERFACE.style_id%TYPE := null;
54: x_pcard_id PO_HEADERS_INTERFACE.pcard_id%TYPE := null;
55:
56: -- Lines Interface
57: x_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE;
58: x_clm_option_exercised PO_REQUISITION_LINES_ALL.clm_option_exercised%TYPE; -- Bug 9838483
59:
60: BEGIN
61:

Line 292: SELECT po_lines_interface_s.nextval

288: l_progress:= '090';
289:
290: /* Get the next available interface_line_id */
291:
292: SELECT po_lines_interface_s.nextval
293: INTO x_interface_line_id
294: FROM dual;
295:
296:

Line 297: INSERT INTO po_lines_interface

293: INTO x_interface_line_id
294: FROM dual;
295:
296:
297: INSERT INTO po_lines_interface
298: (interface_header_id,
299: interface_line_id,
300: action,
301: line_num,

Line 328: SELECT po_lines_interface_s.nextval

324: -- Populate the info line details
325: l_progress:= '100';
326: /* Get the next available interface_line_id */
327:
328: SELECT po_lines_interface_s.nextval
329: INTO x_interface_line_id
330: FROM dual;
331:
332:

Line 333: INSERT INTO po_lines_interface

329: INTO x_interface_line_id
330: FROM dual;
331:
332:
333: INSERT INTO po_lines_interface
334: (interface_header_id,
335: interface_line_id,
336: action,
337: requisition_line_id,

Line 356: SELECT po_lines_interface_s.nextval

352: ELSE -- x_info_slin_falg = 'N'
353: l_progress:= '110';
354: /* Get the next available interface_line_id */
355:
356: SELECT po_lines_interface_s.nextval
357: INTO x_interface_line_id
358: FROM dual;
359:
360:

Line 361: INSERT INTO po_lines_interface

357: INTO x_interface_line_id
358: FROM dual;
359:
360:
361: INSERT INTO po_lines_interface
362: (interface_header_id,
363: interface_line_id,
364: action,
365: line_num,