[Home] [Help]
1826: ORDER BY interface_line_id;
1827:
1828: /* Bug 9883780 - End */
1829:
1830: /* Selects the data from Sourcing that will populate PO_HEADERS_INTERFACE */
1831:
1832: /* Bug 9891996 - Added External IDV field to headerLevelInfo cursor */
1833:
1834: CURSOR headerLevelInfo IS
2071: l_is_fed := 'N';
2072: END;
2073:
2074:
2075: SELECT po_headers_interface_s.nextval
2076: INTO x_interface_header_id
2077: FROM dual;
2078:
2079: OPEN headerLevelInfo;
2111: CLOSE sumOfReqAllocQuantities;
2112: END IF;
2113:
2114: /*
2115: Insert into PO_HEADERS_INTERFACE the purchase order header information based on the negotiation and the award bid.
2116: */
2117:
2118: /* Bug 9891996 - Populate External IDV also in PO_HEADERS_INTERFACE table */
2119:
2114: /*
2115: Insert into PO_HEADERS_INTERFACE the purchase order header information based on the negotiation and the award bid.
2116: */
2117:
2118: /* Bug 9891996 - Populate External IDV also in PO_HEADERS_INTERFACE table */
2119:
2120: INSERT into PO_HEADERS_INTERFACE (
2121: interface_header_id,
2122: interface_source_code,
2116: */
2117:
2118: /* Bug 9891996 - Populate External IDV also in PO_HEADERS_INTERFACE table */
2119:
2120: INSERT into PO_HEADERS_INTERFACE (
2121: interface_header_id,
2122: interface_source_code,
2123: batch_id,
2124: action,
2199: decode(x_pdoi_header.contract_type, 'STANDARD',NULL,x_pdoi_header.umbrella_program_id),
2200: decode(Nvl(x_pdoi_header.fair_opp_notice_flag,'N'), 'Y',x_pdoi_header.auction_header_id,NULL)); -- last_update_date
2201:
2202:
2203: x_progress := '15: CREATE_PO_STRUCTURE: INSERTING the following data into po_headers_interface: ' ||
2204: 'interface_header_id: ' || to_char(x_interface_header_id) || ', ' ||
2205: 'interface_source_code: ' || 'SOURCING' || ', ' ||
2206: 'batch_id: ' || to_char(x_interface_header_id) || ', ' ||
2207: 'action: ' || 'NEW' || ', ' ||