[Home] [Help]
257: l_failure BOOLEAN := FALSE;
258: l_index NUMBER;
259: l_line_count NUMBER :=0; -- 12639770
260: l_prg_start_date DATE := sysdate; -- 12639770
261: -- Moac. Changed the below cursor logic to also join to oe_order_lines for OU.
262: CURSOR wf_item IS
263: SELECT item_key, l.org_id,wias.process_activity --added process_activity for bug 13542899
264: FROM wf_item_activity_statuses wias,
265: wf_process_activities wpa,
262: CURSOR wf_item IS
263: SELECT item_key, l.org_id,wias.process_activity --added process_activity for bug 13542899
264: FROM wf_item_activity_statuses wias,
265: wf_process_activities wpa,
266: oe_order_lines l
267: WHERE wias.item_type = 'OEOL'
268: AND wias.process_activity = wpa.instance_id
269: AND wpa.activity_item_type = 'OEOL'
270: AND wpa.activity_name = 'SCHEDULING_ELIGIBLE'
274: Order by l.org_id;
275:
276: CURSOR progress_pto IS
277: SELECT line_id
278: FROM oe_order_lines_all
279: WHERE header_id = l_header_id
280: AND top_model_line_id = l_line_id
281: AND item_type_code in ('MODEL','KIT','CLASS','OPTION')
282: AND ((ato_line_id is not null AND
504: --Lock the line first
505: BEGIN
506: SELECT line_id
507: INTO l_locked_line_id
508: FROM oe_order_lines_all
509: WHERE line_id = to_number(l_wf_item_rec(K).ITEM_KEY)
510: FOR UPDATE NOWAIT;
511:
512: wf_engine.CompleteActivityInternalName
581: l_stmt := l_stmt || ' H.header_id, L.Line_id, L.org_id ' ;
582: --BUG 13901213 End
583:
584: IF NVL(p_sch_mode, 'LINE_ELIGIBLE') = 'LINE_ELIGIBLE' THEN
585: l_stmt := l_stmt || 'FROM oe_order_headers_all H, oe_order_lines L, '
586: || ' wf_item_activity_statuses wias, wf_process_activities wpa ';
587: ELSE
588: l_stmt := l_stmt || 'FROM oe_order_headers_all H, oe_order_lines L ';
589: END IF;
584: IF NVL(p_sch_mode, 'LINE_ELIGIBLE') = 'LINE_ELIGIBLE' THEN
585: l_stmt := l_stmt || 'FROM oe_order_headers_all H, oe_order_lines L, '
586: || ' wf_item_activity_statuses wias, wf_process_activities wpa ';
587: ELSE
588: l_stmt := l_stmt || 'FROM oe_order_headers_all H, oe_order_lines L ';
589: END IF;
590: l_stmt := l_stmt || 'WHERE H.header_id = L.header_id '
591: || 'AND H.org_id = L.org_id '
592: || 'AND nvl(H.transaction_phase_code,''F'')=''F''' -- Bug 8517633
922: l_link_to_line_id,
923: l_smc_flag,
924: l_item_type_code,
925: l_schedule_status_code
926: FROM oe_order_lines_all L
927: WHERE L.open_flag = 'Y'
928: AND L.line_id = l_line_id;
929:
930:
956: -- Lock the record before processing
957: BEGIN
958: SELECT line_id
959: INTO l_locked_line_id
960: FROM oe_order_lines_all
961: WHERE line_id = l_line_id
962: FOR UPDATE NOWAIT;
963: wf_engine.CompleteActivityInternalName ('OEOL',
964: to_char(l_line_id),