[Home] [Help]
1728: pbh.auction_header_id = pah.auction_header_id and
1729: pbh.bid_number = p_bid_number and
1730: pbh.bid_currency_code = fc.currency_code;
1731:
1732: /* Selects the data from Sourcing that will populate PO_LINES_INTERFACE */
1733:
1734: /*
1735: rrkulkar-large-auction-support - this cursor will bring in all the lines in the middle-tier :
1736: hence, added the following condition in the where clause :-
2051:
2052: log_message(x_progress);
2053:
2054: /*
2055: Insert a row into PO_LINES_INTERFACE with the
2056: item information from the negotiation line, and
2057: the requisiton_line_id and quantity
2058: (price and quantity will be switched when
2059: negotiation line is amount-based-
2061: from the backing requisition.
2062: */
2063:
2064:
2065: INSERT into PO_LINES_INTERFACE (
2066: interface_header_id,
2067: interface_line_id,
2068: requisition_line_id,
2069: line_type_id,
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,
2147:
2148: ) return interface_line_id into x_interface_line_id;
2149:
2150: x_progress :=
2151: '35: CREATE_PO_STRUCTURE: INSERTING the following data into PO_LINES_INTERFACE: ' ||
2152: 'interface_header_id: ' || to_char(x_interface_header_id) || ', ' ||
2153: 'interface_line_id: ' || to_char(x_interface_line_id) || ', ' ||
2154: 'requisition_line_id: ' || to_char(x_requisition_line_id) || ', ' ||
2155: 'line_type_id: ' || to_char(x_pdoi_line.line_type_id) || ', ' ||
2200: award quantities
2201: case-3. There is an excess award OR
2202:
2203: In either of the aforementioned 3 cases, we need to
2204: insert an additional row into PO_LINES_INTERFACE with the
2205: item information from the negotiation line, a null
2206: requisition_line_id, a quantity for the excess award,
2207: and a value of 'N' in the orig_from_req_flag column.
2208:
2246: x_quantity := x_award_quantity - sum_of_alloc_quantities(x_line_number);
2247: ELSE
2248: x_quantity := x_award_quantity;
2249: END IF;
2250: INSERT into PO_LINES_INTERFACE (
2251: interface_header_id,
2252: interface_line_id,
2253: requisition_line_id,
2254: line_type_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,
2331: ) return interface_line_id into x_interface_line_id;
2332:
2333:
2334: x_progress :=
2335: '35: CREATE_PO_STRUCTURE: INSERTING the following data into PO_LINES_INTERFACE: ' ||
2336: 'interface_header_id: ' || to_char(x_interface_header_id) || ', ' ||
2337: 'interface_line_id: ' || to_char(x_interface_line_id) || ', ' ||
2338: 'requisition_line_id: ' || null || ', ' ||
2339: 'line_type_id: ' || to_char(x_pdoi_line.line_type_id) || ', ' ||
2419:
2420: need to find out about x_interface_line_id :- is it used for debugging purposes only?
2421: */
2422:
2423: INSERT into PO_LINES_INTERFACE (
2424: interface_header_id,
2425: interface_line_id,
2426: requisition_line_id,
2427: line_type_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
2644: FROM pon_auction_item_prices_all paip,
2645: pon_bid_item_prices pbip,
2646: pon_bid_payments_shipments bpys,
2647: pon_auc_payments_shipments apys,
2648: po_lines_interface pli,
2649: mtl_units_of_measure mtluom
2650: WHERE pbip.bid_number = p_bid_number and
2651: pbip.auction_header_id = p_auction_header_id and
2652: nvl(pbip.award_status, 'NO') = 'AWARDED' and
2740:
2741: log_message('blanket batching loop: l_batch_size=' || l_batch_size || ' l_batch_start=' || l_batch_start || ' l_batch_end=' || l_batch_end);
2742:
2743:
2744: INSERT into PO_LINES_INTERFACE (
2745: interface_header_id,
2746: interface_line_id,
2747: requisition_line_id,
2748: line_type_id,
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,
2857:
2858: log_message('inserting blanket price break information');
2859:
2860: -- Insert Price Break information
2861: INSERT INTO po_lines_interface (
2862: interface_header_id,
2863: interface_line_id,
2864: shipment_type,
2865: line_type_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
2907: pbs.auction_line_number -- auction_line_number
2908: FROM pon_auction_item_prices_all paip,
2909: pon_bid_item_prices pbip,
2910: pon_bid_shipments pbs,
2911: po_lines_interface pli
2912: WHERE pbip.bid_number = p_bid_number and
2913: pbip.auction_header_id = p_auction_header_id and
2914: nvl(pbip.award_status, 'NO') = 'AWARDED' and
2915: paip.auction_header_id = pbip.auction_header_id and
2958: FROM pon_price_differentials ppd,
2959: pon_bid_item_prices pbip,
2960: pon_bid_price_differentials pbpd,
2961: pon_auction_headers_all pah,
2962: po_lines_interface pli
2963: WHERE pbip.bid_number = p_bid_number
2964: AND nvl(pbip.award_status, 'NO') = 'AWARDED'
2965: AND pbip.auction_header_id = ppd.auction_header_id
2966: AND pbip.line_number = ppd.line_number
3019: and pbs.line_number = pbpd.line_number
3020: and pbs.shipment_number = pbpd.shipment_number) pbpd,
3021: pon_bid_shipments pbs,
3022: pon_auction_headers_all pah,
3023: po_lines_interface pli
3024: WHERE pbip.bid_number = p_bid_number
3025: AND nvl(pbip.award_status, 'NO') = 'AWARDED'
3026: AND pbip.bid_number = pbs.bid_number
3027: AND pbip.line_number = pbs.line_number
3043: /*
3044: -- DEBUG CODE
3045: -- ALWAYS COMMENTED OUT
3046:
3047: INSERT INTO po_lines_interface_debug
3048: (SELECT * FROM po_lines_interface WHERE interface_header_id = x_interface_header_id);
3049:
3050: INSERT INTO po_price_diff_interface_debug
3051: (SELECT * FROM po_price_diff_interface WHERE interface_header_id = x_interface_header_id);
3044: -- DEBUG CODE
3045: -- ALWAYS COMMENTED OUT
3046:
3047: INSERT INTO po_lines_interface_debug
3048: (SELECT * FROM po_lines_interface WHERE interface_header_id = x_interface_header_id);
3049:
3050: INSERT INTO po_price_diff_interface_debug
3051: (SELECT * FROM po_price_diff_interface WHERE interface_header_id = x_interface_header_id);
3052: */
3195: pbav.value,
3196: paa.attribute_name
3197: FROM pon_bid_item_prices pbip,
3198: pon_auction_item_prices_all paip,
3199: po_lines_interface pli,
3200: pon_bid_attribute_values pbav,
3201: pon_auction_attributes paa,
3202: icx_cat_agreement_attrs_v icx
3203: WHERE pbip.auction_header_id = p_auction_header_id and