2101:
2102: values (
2103:
2104: x_interface_header_id, -- interface_header_id
2105: po_lines_interface_s.nextval, -- interface_line_id
2106: x_requisition_line_id, -- requisition_line_id
2107: x_pdoi_line.line_type_id,
2108: -- line_type_id
2109: x_pdoi_line.item_id,
2286:
2287: values (
2288:
2289: x_interface_header_id, -- interface_header_id
2290: po_lines_interface_s.nextval, -- interface_line_id
2291: NULL, -- requisition_line_id
2292: x_pdoi_line.line_type_id,
2293: -- line_type_id
2294: x_pdoi_line.item_id,
2457:
2458: )
2459: SELECT
2460: x_interface_header_id, -- interface_header_id
2461: po_lines_interface_s.nextval, -- interface_line_id
2462: NULL, -- requisition_line_id
2463: paip.line_type_id, -- line_type_id
2464: paip.item_id, -- item_id
2465: paip.item_revision, -- item_revision
2775: amount
2776: )
2777: SELECT
2778: x_interface_header_id, -- interface_header_id
2779: po_lines_interface_s.nextval, -- interface_line_id
2780: NULL, -- requisition_line_id
2781: paip.line_type_id, -- line_type_id
2782: l_rows_processed + rownum, -- line num
2783: paip.item_id,
2882: auction_header_id,
2883: auction_line_number)
2884: SELECT
2885: x_interface_header_id, -- interface_header_id
2886: po_lines_interface_s.NEXTVAL, -- interface_line_id
2887: pbs.shipment_type, -- shipment_type
2888: paip.line_type_id, -- line_type_id
2889: paip.item_id, -- item_id
2890: paip.item_revision, -- item_revision