[Home] [Help]
8: type t_wsm_wtxn_rj_tbl is table of wsm_resulting_jobs_interface%rowtype index by binary_integer;
9:
10: type t_wtxn_hdr_id_tbl is table of wsm_split_merge_txn_interface.header_id%type index by binary_integer;
11: type t_wtxn_job_id_tbl is table of number index by binary_integer;
12: type t_wtxn_job_name_tbl is table of number index by wip_entities.wip_entity_name%type;
13:
14: g_user_id number;
15: g_user_login_id number;
16: g_program_appl_id number;
58: ELSIF p_error_job_id is not NULL THEN -- Job Name is null
59: p_error_job_id_tbl(p_error_job_id) := 1;
60:
61: DECLARE
62: l_wip_entity_name WIP_ENTITIES.wip_entity_name%TYPE;
63: l_org_id NUMBER;
64: BEGIN
65: SELECT wip_entity_name,organization_id
66: into l_wip_entity_name,l_org_id
63: l_org_id NUMBER;
64: BEGIN
65: SELECT wip_entity_name,organization_id
66: into l_wip_entity_name,l_org_id
67: FROM WIP_ENTITIES
68: WHERE wip_entity_id = p_error_job_id;
69:
70: p_error_job_name_tbl(l_wip_entity_name) := l_org_id;
71:
82: l_wip_entity_id NUMBER;
83: BEGIN
84: SELECT wip_entity_id
85: into l_wip_entity_id
86: FROM WIP_ENTITIES
87: WHERE wip_entity_name = p_error_job_name
88: and organization_id = p_error_org_id;
89:
90: p_error_job_id_tbl(l_wip_entity_id) := 1;
1221: select we.wip_entity_name,
1222: wdj.primary_item_id
1223: into l_st_lot_number,
1224: l_st_inv_item_id
1225: from wip_entities we,
1226: wip_discrete_jobs wdj
1227: where we.wip_entity_name = l_starting_jobs_tbl(l_rep_job_index).wip_entity_name
1228: and we.wip_entity_id = wdj.wip_entity_id
1229: and we.organization_id = l_txn_header_rec.organization_id;
1242: select we.wip_entity_name,
1243: wdj.primary_item_id
1244: into l_st_lot_number,
1245: l_st_inv_item_id
1246: from wip_entities we,
1247: wip_discrete_jobs wdj
1248: where we.wip_entity_name = nvl(l_starting_jobs_tbl(l_rep_job_index).wip_entity_name,we.wip_entity_name)
1249: and we.wip_entity_id = wdj.wip_entity_id
1250: and we.wip_entity_id = l_starting_jobs_tbl(l_rep_job_index).wip_entity_id