APPS.WSMPJUPD dependencies on WIP_ENTITIES

Line 36: type t_job_name_tbl is table of number index by wip_entities.wip_entity_name%type;

32: g_ret_unexpected varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
33:
34:
35: type t_number is table of number index by binary_integer;
36: type t_job_name_tbl is table of number index by wip_entities.wip_entity_name%type;
37:
38: -- MES secondary qty changes
39: type t_wsm_job_sec_qty_tbl is table of wsm_job_secondary_quantities%rowtype index by binary_integer;
40: type t_wsm_sj_sec_qty_tbl is table of wsm_sj_secondary_quantities%rowtype index by binary_integer;

Line 44: type t_we_id_tbl is table of wip_entities.wip_entity_id%type index by binary_integer;

40: type t_wsm_sj_sec_qty_tbl is table of wsm_sj_secondary_quantities%rowtype index by binary_integer;
41: type t_wsm_rj_sec_qty_tbl is table of wsm_rj_secondary_quantities%rowtype index by binary_integer;
42: type t_wsm_op_sec_qty_tbl is table of wsm_op_secondary_quantities%rowtype index by binary_integer;
43:
44: type t_we_id_tbl is table of wip_entities.wip_entity_id%type index by binary_integer;
45: type t_cur_qty_tbl is table of wsm_job_secondary_quantities.current_quantity%type index by binary_integer;
46: type t_cur_uom_tbl is table of wsm_job_secondary_quantities.uom_code%type index by binary_integer;
47: -- End MES secondary qty changes
48:

Line 3618: -- Update the details in WIP_ENTITIES as well...

3614: last_updated_by = g_user_id
3615: WHERE wdj.wip_entity_id = l_wip_entity_id;
3616:
3617: -- ST : Fix for bug 5122653 --
3618: -- Update the details in WIP_ENTITIES as well...
3619: UPDATE wip_entities
3620: SET primary_item_id = p_rj_job_rec.primary_item_id
3621: WHERE wip_entity_id = l_wip_entity_id;
3622: -- ST : Fix for bug 5122653 end --

Line 3619: UPDATE wip_entities

3615: WHERE wdj.wip_entity_id = l_wip_entity_id;
3616:
3617: -- ST : Fix for bug 5122653 --
3618: -- Update the details in WIP_ENTITIES as well...
3619: UPDATE wip_entities
3620: SET primary_item_id = p_rj_job_rec.primary_item_id
3621: WHERE wip_entity_id = l_wip_entity_id;
3622: -- ST : Fix for bug 5122653 end --
3623:

Line 4823: l_new_name wip_entities.wip_entity_name%type;

4819:
4820: l_new_we_id number;
4821: l_sub_loc_change number;
4822: l_ret_status varchar2(1);
4823: l_new_name wip_entities.wip_entity_name%type;
4824: l_dup_job_name wip_entities.wip_entity_name%type;
4825:
4826: l_job_counter NUMBER;
4827:

Line 4824: l_dup_job_name wip_entities.wip_entity_name%type;

4820: l_new_we_id number;
4821: l_sub_loc_change number;
4822: l_ret_status varchar2(1);
4823: l_new_name wip_entities.wip_entity_name%type;
4824: l_dup_job_name wip_entities.wip_entity_name%type;
4825:
4826: l_job_counter NUMBER;
4827:
4828: l_sj_gen_object_id wip_entities.gen_object_id%type;

Line 4828: l_sj_gen_object_id wip_entities.gen_object_id%type;

4824: l_dup_job_name wip_entities.wip_entity_name%type;
4825:
4826: l_job_counter NUMBER;
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:

Line 4829: l_rj_gen_object_id wip_entities.gen_object_id%type;

4825:
4826: l_job_counter NUMBER;
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;

Line 6236: from wip_entities we

6232:
6233: -- for geneology purpose.... get the gen obj id
6234: select gen_object_id
6235: into l_sj_gen_object_id
6236: from wip_entities we
6237: where we.wip_entity_id = p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id;
6238:
6239: for l_job_counter in p_wltx_resulting_jobs_tbl.first..p_wltx_resulting_jobs_tbl.last loop
6240:

Line 6246: from wip_entities we

6242:
6243: -- get the gen object id of the resulting jobs ...
6244: select gen_object_id
6245: into l_rj_gen_object_id
6246: from wip_entities we
6247: where we.wip_entity_id = p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id;
6248: --Bug 5387828:Genealogy should be created only when the starting job is diff from
6249: --resulting job.
6250: if l_sj_gen_object_id <> l_rj_gen_object_id then

Line 6339: from wip_entities we

6335:
6336: -- for geneology purpose.... get the gen obj id
6337: select gen_object_id
6338: into l_rj_gen_object_id
6339: from wip_entities we
6340: where we.wip_entity_id = p_wltx_resulting_jobs_tbl(l_rj_index).wip_entity_id;
6341:
6342: for l_job_counter in p_wltx_starting_jobs_tbl.first..p_wltx_starting_jobs_tbl.last loop
6343:

Line 6349: from wip_entities we

6345:
6346: -- get the gen object id of the resulting jobs ...
6347: select gen_object_id
6348: into l_sj_gen_object_id
6349: from wip_entities we
6350: where we.wip_entity_id = p_wltx_starting_jobs_tbl(l_job_counter).wip_entity_id;
6351:
6352: --Bug 5367218:START. Genealogy should be created only when the resulting job is not
6353: -- among one of the starting jobs.

Line 6926: from wip_entities

6922: p_wltx_resulting_jobs_tbl(l_rj_index).wip_entity_id := p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id;
6923: else
6924: select wip_entity_id
6925: into p_wltx_resulting_jobs_tbl(l_rj_index).wip_entity_id
6926: from wip_entities
6927: where wip_entity_name like p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_name;
6928: end if;
6929: end if;
6930:

Line 6944: update wip_entities

6940: where wip_entity_id = p_wltx_resulting_jobs_tbl(l_rj_index).wip_entity_id;
6941:
6942: l_stmt_num := 570;
6943:
6944: update wip_entities
6945: set wip_entity_name = p_wltx_resulting_jobs_tbl(l_rj_index).wip_entity_name,
6946: description = p_wltx_resulting_jobs_tbl(l_rj_index).description
6947: where wip_entity_id = p_wltx_resulting_jobs_tbl(l_rj_index).wip_entity_id;
6948: