[Home] [Help]
938: l_change_comments VARCHAR2(2000);
939:
940: CURSOR get_service IS
941: SELECT LINE_ID, ORDERED_QUANTITY
942: FROM oe_order_lines
943: WHERE service_reference_line_id = p_line_rec.line_id
944: AND service_reference_type_code = 'ORDER' -- these two conditions added for bug 2946327
945: AND nvl(cancelled_flag, 'N') <> 'Y';
946:
1039: select nvl(ordered_quantity, 0)
1040: , nvl(cancelled_quantity, 0)
1041: into l_old_ord_quantity
1042: , l_old_can_quantity
1043: from oe_order_lines
1044: where line_id = p_line_rec.line_id;
1045:
1046: IF l_debug_level > 0 THEN
1047: oe_debug_pub.add( 'NEW ORDERED QUANTITY IS: '||P_LINE_REC.ORDERED_QUANTITY ) ;
1276:
1277: begin
1278: select 'Y'
1279: into l_service_parent_exists
1280: from oe_order_lines
1281: where header_id = l_line_old_tbl(j).header_id
1282: and line_id = l_line_old_tbl(j).service_reference_line_id;
1283: exception
1284: when no_data_found then
1680:
1681: -- Find all the non-closed fulfillment sets
1682: Cursor C_FulfillmentSets IS
1683: SELECT DISTINCT OS.SET_ID
1684: FROM oe_order_lines ol, oe_sets OS, oe_line_sets ols
1685: WHERE ol.header_id = p_header_id
1686: and OS.HEADER_ID = ol.header_id
1687: and ol.line_id = ols.line_id
1688: and ols.set_id = OS.set_id
1702: LOOP
1703:
1704: -- Count the lines in this set
1705: SELECT count(1) INTO l_lines_in_set
1706: FROM oe_order_lines ol, oe_line_sets ols
1707: WHERE ol.header_id = p_header_id
1708: AND ols.set_id = C_Set.set_id
1709: AND ol.line_id = ols.line_id
1710: AND ol.cancelled_flag <> 'Y'
1716:
1717: -- Count the lines that are awaiting fulfillment for this set
1718: IF l_lines_in_set > 0 THEN
1719: SELECT count(1) INTO l_lines_awaiting
1720: FROM oe_order_lines ol, oe_line_sets ols,
1721: wf_item_activity_statuses WIAS,
1722: wf_process_activities WPA
1723: WHERE ol.header_id = p_header_id
1724: AND ols.set_id = C_Set.set_id
1736: IF l_lines_awaiting = l_lines_in_set THEN
1737: -- This is to pick up 1 line in the set in Fulfill:Notified
1738: SELECT WIAS.Process_Activity, ol.line_id
1739: INTO l_activity_id, l_line_id
1740: FROM oe_order_lines ol, oe_line_sets ols,
1741: wf_item_activity_statuses WIAS,
1742: wf_process_activities WPA
1743: WHERE ol.header_id = p_header_id
1744: AND ols.set_id = C_Set.set_id
1908:
1909: begin
1910: select 'Y'
1911: into l_service_parent_exists
1912: from oe_order_lines
1913: where header_id = l_line_old_tbl(i).header_id
1914: and line_id = l_line_old_tbl(i).service_reference_line_id;
1915: exception
1916: when no_data_found then
1933: into l_prg_line_count
1934: from oe_price_adjustments opa1,
1935: oe_price_adjustments opa2,
1936: oe_price_adj_assocs opaa,
1937: oe_order_lines_all ol --bug 4156493
1938: where opa1.list_line_type_code = 'PRG'
1939: and opa1.price_adjustment_id = opaa.price_adjustment_id
1940: and opa2.price_adjustment_id = opaa.rltd_price_adj_id
1941: and opa2.line_id = l_line_old_tbl(i).line_id
2077: IS
2078: l_Ordered_Quantity number ;
2079: Cursor C1 IS
2080: select ordered_quantity from
2081: oe_order_lines_all
2082: where line_id = x_request_rec.entity_id;
2083:
2084: Cursor C2 IS
2085: select ordered_quantity from
2082: where line_id = x_request_rec.entity_id;
2083:
2084: Cursor C2 IS
2085: select ordered_quantity from
2086: oe_order_lines_all
2087: where header_id = x_request_rec.entity_id
2088: and ordered_quantity <> 0;
2089: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2090:
2132: IF l_ordered_quantity = 0 THEN
2133: if l_debug_level > 0 then
2134: OE_DEBUG_PUB.ADD('Before cancelling line flow ');
2135: end if;
2136: Update oe_order_lines_all
2137: set cancelled_flag = 'Y' where
2138: line_id = x_request_rec.entity_id;
2139:
2140: wf_engine.handleerror(OE_Globals.G_WFI_LIN
2204: select nvl(ordered_quantity2, 0)
2205: , nvl(cancelled_quantity2, 0)
2206: into l_old_ord_quantity2
2207: , l_old_can_quantity2
2208: from oe_order_lines
2209: where line_id = p_line_rec.line_id;
2210:
2211: IF l_debug_level > 0 THEN
2212: oe_debug_pub.add( 'NEW ORDERED QUANTITY2 IS: '||P_LINE_REC.ORDERED_QUANTITY2 ) ;