[Home] [Help]
421: x_list_line_tbl(i).item_type_code := l_item_type_code;
422: x_list_line_tbl(i).quantity := l_quantity;
423:
424: /*
425: * find same item IN aso_quote_lines view where item_type_code is 'STD',
426: * and inventory_item_id, organization_id, and uom_code matches with this line
427: */
428: BEGIN
429: SELECT shp_list_item_id,
2068: AQL.attribute13 ,
2069: AQL.attribute14 ,
2070: AQL.attribute15 ,
2071: AQL.pricing_line_type_indicator
2072: FROM aso_quote_lines AQL,
2073: aso_quote_line_details AQLD
2074: WHERE AQL.quote_header_id = p_quote_header_id
2075: AND AQL.quote_line_id = AQLD.quote_line_id(+)
2076: ORDER BY AQL.quote_line_id;
2182: OPEN l_csr_rel FOR SELECT ALR.quote_line_id,
2183: ALR.related_quote_line_id,
2184: ALR.relationship_type_code
2185: FROM aso_line_relationships ALR,
2186: aso_quote_lines AQL
2187: WHERE ALR.quote_line_id = AQL.quote_line_id
2188: AND AQL.quote_header_id = p_quote_header_id;
2189:
2190: LOOP
2483: x_qte_line_tbl(i).quantity := l_quantity;
2484: x_qte_line_tbl(i).minisite_id := p_minisite_id;
2485:
2486: /*
2487: * find same item IN aso_quote_lines view where item_type_code is 'STD',
2488: * and inventory_item_id, organization_id, and uom_code matches with this line
2489: */
2490: BEGIN
2491: SELECT quote_line_id,
2491: SELECT quote_line_id,
2492: quantity
2493: INTO l_quote_line_id,
2494: l_quantity
2495: FROM aso_quote_lines
2496: WHERE quote_header_id = p_quote_header_id
2497: AND organization_id = l_organization_id
2498: AND item_type_code = 'STD'
2499: AND inventory_item_id = l_inventory_item_id
2505: x_qte_line_tbl(i).quantity := x_qte_line_tbl(i).quantity + l_quantity;
2506: EXCEPTION
2507: /*
2508: * We get to NO_DATA_FOUND block when there is no line in
2509: * x_qte_line_tbl nor in aso_quote_lines table for the same item.
2510: */
2511: WHEN NO_DATA_FOUND THEN
2512: x_qte_line_tbl(i).operation_code := 'CREATE';
2513: --commented by makulkar