APPS.WSMPJUPD dependencies on WIP_DISCRETE_JOBS

Line 2340: UPDATE wip_discrete_jobs

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:

Line 3526: UPDATE wip_discrete_jobs wdj

3522: l_job_kanban_card_id := null;
3523: end if;
3524: end if;
3525:
3526: UPDATE wip_discrete_jobs wdj
3527: SET routing_reference_id = p_rj_job_rec.routing_reference_id,
3528: alternate_routing_designator = p_rj_job_rec.alternate_routing_designator,
3529: common_routing_sequence_id = p_rj_job_rec.common_routing_sequence_id,
3530: routing_revision = p_rj_job_rec.routing_revision,

Line 3597: UPDATE wip_discrete_jobs wdj

3593:
3594: end if; -- kanban_card_id not null
3595:
3596:
3597: UPDATE wip_discrete_jobs wdj
3598: SET primary_item_id = p_rj_job_rec.primary_item_id,
3599: kanban_card_id = l_job_kanban_card_id,
3600: routing_reference_id = p_rj_job_rec.routing_reference_id,
3601: alternate_routing_designator = p_rj_job_rec.alternate_routing_designator,

Line 4831: l_kanban_card_id wip_discrete_jobs.kanban_card_id%type;

4827:
4828: l_sj_gen_object_id wip_entities.gen_object_id%type;
4829: l_rj_gen_object_id wip_entities.gen_object_id%type;
4830:
4831: l_kanban_card_id wip_discrete_jobs.kanban_card_id%type;
4832:
4833: l_msg_count number;
4834: l_msg_data varchar2(2000);
4835:

Line 5297: update wip_discrete_jobs

5293:
5294: end if;
5295: end if;
5296:
5297: update wip_discrete_jobs
5298: set completion_subinventory = p_wltx_resulting_jobs_tbl(l_job_counter).completion_subinventory,
5299: completion_locator_id = p_wltx_resulting_jobs_tbl(l_job_counter).completion_locator_id,
5300: kanban_card_id = p_wltx_resulting_jobs_tbl(l_job_counter).kanban_card_id
5301: where wip_entity_id = p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id;

Line 5777: UPDATE wip_discrete_jobs

5773: );
5774: End if;
5775:
5776: -- update the completion subinv and the kanban card id ....
5777: UPDATE wip_discrete_jobs
5778: SET completion_subinventory = p_wltx_resulting_jobs_tbl(l_sj_also_rj_index).completion_subinventory,
5779: completion_locator_id = p_wltx_resulting_jobs_tbl(l_sj_also_rj_index).completion_locator_id ,
5780: kanban_card_id = p_wltx_resulting_jobs_tbl(l_sj_also_rj_index).kanban_card_id ,
5781: -- ST : Fix for bug 5122500

Line 5873: UPDATE wip_discrete_jobs

5869: l_stmt_num := 180;
5870:
5871: -- change the status of the job...
5872: -- Related bugs : 2974419
5873: UPDATE wip_discrete_jobs
5874: SET STATUS_TYPE = 4
5875: ,kanban_card_id = l_kanban_card_id
5876: ,date_completed = sysdate
5877: ,last_updated_by = g_user_id

Line 6747: update wip_discrete_jobs

6743:
6744: l_stmt_num := 155;
6745:
6746: -- update the completion subinv and the kanban card id ....
6747: update wip_discrete_jobs
6748: SET completion_subinventory = p_wltx_resulting_jobs_tbl(l_rj_index).completion_subinventory,
6749: completion_locator_id = p_wltx_resulting_jobs_tbl(l_rj_index).completion_locator_id,
6750: kanban_card_id = l_kanban_card_id
6751: where wip_entity_id = p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id;

Line 6933: update wip_discrete_jobs

6929: end if;
6930:
6931: l_stmt_num := 560;
6932:
6933: update wip_discrete_jobs
6934: set lot_number = p_wltx_resulting_jobs_tbl(l_rj_index).wip_entity_name,
6935: description = p_wltx_resulting_jobs_tbl(l_rj_index).description,
6936: /* Start Bugfix 5531371 csi/loc is updatable in upd lot name */
6937: completion_subinventory = p_wltx_resulting_jobs_tbl(l_rj_index).completion_subinventory,