[Home] [Help]
2336: --Set the WDJ.start_quantity for all Split/Merge/Update Quantity Transactions----------------------------
2337:
2338:
2339: forall l_job_counter in indices of p_wip_entity_id_tbl
2340: UPDATE wip_discrete_jobs
2341: SET start_quantity = (p_sj_st_qty_tbl(l_job_counter) - p_sj_avail_qty_tbl(l_job_counter) + p_new_job_qty_tbl(l_job_counter)),
2342: net_quantity = nvl(p_new_net_qty_tbl(l_job_counter), 0)
2343: WHERE wip_entity_id = p_wip_entity_id_tbl(l_job_counter);
2344:
3528: l_job_kanban_card_id := null;
3529: end if;
3530: end if;
3531:
3532: UPDATE wip_discrete_jobs wdj
3533: SET routing_reference_id = p_rj_job_rec.routing_reference_id,
3534: alternate_routing_designator = p_rj_job_rec.alternate_routing_designator,
3535: common_routing_sequence_id = p_rj_job_rec.common_routing_sequence_id,
3536: routing_revision = p_rj_job_rec.routing_revision,
3599:
3600: end if; -- kanban_card_id not null
3601:
3602:
3603: UPDATE wip_discrete_jobs wdj
3604: SET primary_item_id = p_rj_job_rec.primary_item_id,
3605: kanban_card_id = l_job_kanban_card_id,
3606: routing_reference_id = p_rj_job_rec.routing_reference_id,
3607: alternate_routing_designator = p_rj_job_rec.alternate_routing_designator,
4835:
4836: l_sj_gen_object_id wip_entities.gen_object_id%type;
4837: l_rj_gen_object_id wip_entities.gen_object_id%type;
4838:
4839: l_kanban_card_id wip_discrete_jobs.kanban_card_id%type;
4840:
4841: l_msg_count number;
4842: l_msg_data varchar2(2000);
4843:
4989: l_attribute12,
4990: l_attribute13,
4991: l_attribute14,
4992: l_attribute15
4993: from wip_discrete_jobs
4994: where wip_entity_id = p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id;
4995: -- end of bug fix 6676148
4996:
4997: l_sj_also_rj_index := null;
5357:
5358: end if;
5359: end if;
5360:
5361: update wip_discrete_jobs
5362: set completion_subinventory = p_wltx_resulting_jobs_tbl(l_job_counter).completion_subinventory,
5363: completion_locator_id = p_wltx_resulting_jobs_tbl(l_job_counter).completion_locator_id,
5364: kanban_card_id = p_wltx_resulting_jobs_tbl(l_job_counter).kanban_card_id
5365: where wip_entity_id = p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id;
5837: );
5838: End if;
5839:
5840: -- update the completion subinv and the kanban card id ....
5841: UPDATE wip_discrete_jobs
5842: SET completion_subinventory = p_wltx_resulting_jobs_tbl(l_sj_also_rj_index).completion_subinventory,
5843: completion_locator_id = p_wltx_resulting_jobs_tbl(l_sj_also_rj_index).completion_locator_id ,
5844: kanban_card_id = p_wltx_resulting_jobs_tbl(l_sj_also_rj_index).kanban_card_id ,
5845: -- ST : Fix for bug 5122500
5933: l_stmt_num := 180;
5934:
5935: -- change the status of the job...
5936: -- Related bugs : 2974419
5937: UPDATE wip_discrete_jobs
5938: SET STATUS_TYPE = 4
5939: ,kanban_card_id = l_kanban_card_id
5940: ,date_completed = sysdate
5941: ,last_updated_by = g_user_id
6807:
6808: l_stmt_num := 155;
6809:
6810: -- update the completion subinv and the kanban card id ....
6811: update wip_discrete_jobs
6812: SET completion_subinventory = p_wltx_resulting_jobs_tbl(l_rj_index).completion_subinventory,
6813: completion_locator_id = p_wltx_resulting_jobs_tbl(l_rj_index).completion_locator_id,
6814: kanban_card_id = l_kanban_card_id
6815: where wip_entity_id = p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id;
6993: end if;
6994:
6995: l_stmt_num := 560;
6996:
6997: update wip_discrete_jobs
6998: set lot_number = p_wltx_resulting_jobs_tbl(l_rj_index).wip_entity_name,
6999: description = p_wltx_resulting_jobs_tbl(l_rj_index).description,
7000: /* Start Bugfix 5531371 csi/loc is updatable in upd lot name */
7001: completion_subinventory = p_wltx_resulting_jobs_tbl(l_rj_index).completion_subinventory,