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