[Home] [Help]
1337: SELECT TRUNC((fs_select_rec.planned_quantity -
1338: v_itemQty_tab(fs_select_rec.primary_item_id).remainQty)/
1339: v_order_quantity-0.000000001)+1
1340: INTO v_num_flow
1341: FROM DUAL;
1342:
1343: V_ERROR_LINE := 3;
1344:
1345: UPDATE wip_flow_schedules
1360:
1361: -- Create a new flow schedule to carry over the unscheduled quantity
1362: SELECT wip_entities_s.nextval
1363: INTO v_temp
1364: FROM dual;
1365:
1366: V_ERROR_LINE := 5;
1367:
1368: IF to_schedule_qty >= v_order_quantity THEN
1535: V_ERROR_LINE := 7;
1536:
1537: SELECT wip_entities_s.nextval
1538: INTO v_temp
1539: FROM dual;
1540:
1541: V_ERROR_LINE := 8;
1542:
1543: --Bug 6122344
2250:
2251: -- Create a new flow schedule to carry over the unscheduled quantity
2252: SELECT wip_entities_s.nextval
2253: INTO v_temp
2254: FROM dual;
2255:
2256: V_ERROR_LINE := 11;
2257:
2258: --Bug 6122344
2483: v_finish_date := to_number(to_char(p_last_date,'J'));
2484:
2485: SELECT mrp_form_query_s.nextval
2486: INTO v_query_id
2487: FROM DUAL;
2488:
2489: V_ERROR_LINE := 2;
2490:
2491: FOR i in v_begin_date..v_finish_date LOOP
3065:
3066: -- Create a new flow schedule to carry over the unscheduled quantity
3067: SELECT wip_entities_s.nextval
3068: INTO v_temp
3069: FROM dual;
3070:
3071: V_ERROR_LINE := 18;
3072:
3073: --Bug 6122344
3877: p_time_tab(v_current_date).start_completion_time + v_required_time;
3878:
3879: SELECT wip_entities_s.nextval
3880: INTO v_temp
3881: FROM dual;
3882:
3883: V_ERROR_LINE := 11;
3884:
3885: --Bug 6122344
4236: to_number(to_char(p_scheduling_end_date,'J')),
4237: to_char(p_scheduling_start_date,'SSSSS'),
4238: to_char(p_scheduling_end_date,'SSSSS')
4239: INTO v_start_date, v_end_date, v_start_time, v_end_time
4240: FROM dual;
4241:
4242: -- Get the minimum wip_entity_id that having request id
4243:
4244: SELECT MIN(wip_entity_id)