[Home] [Help]
990: l_change_comments VARCHAR2(2000);
991:
992: CURSOR get_service IS
993: SELECT LINE_ID, ORDERED_QUANTITY
994: FROM oe_order_lines
995: WHERE service_reference_line_id = p_line_rec.line_id
996: AND service_reference_type_code = 'ORDER' -- these two conditions added for bug 2946327
997: AND nvl(cancelled_flag, 'N') <> 'Y';
998:
1091: select nvl(ordered_quantity, 0)
1092: , nvl(cancelled_quantity, 0)
1093: into l_old_ord_quantity
1094: , l_old_can_quantity
1095: from oe_order_lines
1096: where line_id = p_line_rec.line_id;
1097:
1098: IF l_debug_level > 0 THEN
1099: oe_debug_pub.add( 'NEW ORDERED QUANTITY IS: '||P_LINE_REC.ORDERED_QUANTITY ) ;
1339:
1340: begin
1341: select 'Y'
1342: into l_service_parent_exists
1343: from oe_order_lines
1344: where header_id = l_line_old_tbl(j).header_id
1345: and line_id = l_line_old_tbl(j).service_reference_line_id;
1346: exception
1347: when no_data_found then
1743:
1744: -- Find all the non-closed fulfillment sets
1745: Cursor C_FulfillmentSets IS
1746: SELECT DISTINCT OS.SET_ID
1747: FROM oe_order_lines ol, oe_sets OS, oe_line_sets ols
1748: WHERE ol.header_id = p_header_id
1749: and OS.HEADER_ID = ol.header_id
1750: and ol.line_id = ols.line_id
1751: and ols.set_id = OS.set_id
1765: LOOP
1766:
1767: -- Count the lines in this set
1768: SELECT count(1) INTO l_lines_in_set
1769: FROM oe_order_lines ol, oe_line_sets ols
1770: WHERE ol.header_id = p_header_id
1771: AND ols.set_id = C_Set.set_id
1772: AND ol.line_id = ols.line_id
1773: AND ol.cancelled_flag <> 'Y'
1779:
1780: -- Count the lines that are awaiting fulfillment for this set
1781: IF l_lines_in_set > 0 THEN
1782: SELECT count(1) INTO l_lines_awaiting
1783: FROM oe_order_lines ol, oe_line_sets ols,
1784: wf_item_activity_statuses WIAS,
1785: wf_process_activities WPA
1786: WHERE ol.header_id = p_header_id
1787: AND ols.set_id = C_Set.set_id
1799: IF l_lines_awaiting = l_lines_in_set THEN
1800: -- This is to pick up 1 line in the set in Fulfill:Notified
1801: SELECT WIAS.Process_Activity, ol.line_id
1802: INTO l_activity_id, l_line_id
1803: FROM oe_order_lines ol, oe_line_sets ols,
1804: wf_item_activity_statuses WIAS,
1805: wf_process_activities WPA
1806: WHERE ol.header_id = p_header_id
1807: AND ols.set_id = C_Set.set_id
1971:
1972: begin
1973: select 'Y'
1974: into l_service_parent_exists
1975: from oe_order_lines
1976: where header_id = l_line_old_tbl(i).header_id
1977: and line_id = l_line_old_tbl(i).service_reference_line_id;
1978: exception
1979: when no_data_found then
1996: into l_prg_line_count
1997: from oe_price_adjustments opa1,
1998: oe_price_adjustments opa2,
1999: oe_price_adj_assocs opaa,
2000: oe_order_lines_all ol --bug 4156493
2001: where opa1.list_line_type_code = 'PRG'
2002: and opa1.price_adjustment_id = opaa.price_adjustment_id
2003: and opa2.price_adjustment_id = opaa.rltd_price_adj_id
2004: and opa2.line_id = l_line_old_tbl(i).line_id
2141: IS
2142: l_Ordered_Quantity number ;
2143: Cursor C1 IS
2144: select ordered_quantity from
2145: oe_order_lines_all
2146: where line_id = x_request_rec.entity_id;
2147:
2148: Cursor C2 IS
2149: select ordered_quantity from
2146: where line_id = x_request_rec.entity_id;
2147:
2148: Cursor C2 IS
2149: select ordered_quantity from
2150: oe_order_lines_all
2151: where header_id = x_request_rec.entity_id
2152: and ordered_quantity <> 0;
2153: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2154:
2196: IF l_ordered_quantity = 0 THEN
2197: if l_debug_level > 0 then
2198: OE_DEBUG_PUB.ADD('Before cancelling line flow ');
2199: end if;
2200: Update oe_order_lines_all
2201: set cancelled_flag = 'Y' where
2202: line_id = x_request_rec.entity_id;
2203:
2204: wf_engine.handleerror(OE_Globals.G_WFI_LIN
2268: select nvl(ordered_quantity2, 0)
2269: , nvl(cancelled_quantity2, 0)
2270: into l_old_ord_quantity2
2271: , l_old_can_quantity2
2272: from oe_order_lines
2273: where line_id = p_line_rec.line_id;
2274:
2275: IF l_debug_level > 0 THEN
2276: oe_debug_pub.add( 'NEW ORDERED QUANTITY2 IS: '||P_LINE_REC.ORDERED_QUANTITY2 ) ;