DBA Data[Home] [Help]

APPS.WSM_SERIAL_SUPPORT_PVT dependencies on WIP_ENTITIES

Line 3996: from wip_entities

3992: l_msg_tokens(1).TokenName := 'JOB';
3993:
3994: select wip_entity_name
3995: into l_msg_tokens(1).TokenValue
3996: from wip_entities
3997: where wip_entity_id = p_wip_entity_id
3998: and organization_id = p_organization_id;
3999:
4000: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 5203: from wip_entities we,

5199: BEGIN
5200: -- These two can cause error...
5201: select we.wip_entity_id,wdj.primary_item_id
5202: into l_wip_entity_id,l_inventory_item_id
5203: from wip_entities we,
5204: wip_discrete_jobs wdj
5205: where we.wip_entity_name = p_wip_entity_name
5206: and we.wip_entity_id = wdj.wip_entity_id
5207: and we.organization_id = p_organization_id;

Line 5244: from wip_entities we,

5240: BEGIN
5241: -- These two can cause error...
5242: select we.wip_entity_id,wdj.primary_item_id
5243: into l_wip_entity_id,l_inventory_item_id
5244: from wip_entities we,
5245: wip_discrete_jobs wdj
5246: where we.wip_entity_name = nvl(p_wip_entity_name,we.wip_entity_name)
5247: and we.wip_entity_id = wdj.wip_entity_id
5248: and we.wip_entity_id = p_wip_entity_id

Line 5668: type t_jser_info_tbl_type is table of t_jser_info_rec_type index by WIP_ENTITIES.wip_entity_name%type;

5664: l_count NUMBER
5665: );
5666:
5667:
5668: type t_jser_info_tbl_type is table of t_jser_info_rec_type index by WIP_ENTITIES.wip_entity_name%type;
5669: type t_job_name_tbl_type is table of NUMBER index by WIP_ENTITIES.wip_entity_name%type;
5670:
5671: l_job_ser_info_tbl t_jser_info_tbl_type;
5672: l_res_job_tbl t_job_name_tbl_type;

Line 5669: type t_job_name_tbl_type is table of NUMBER index by WIP_ENTITIES.wip_entity_name%type;

5665: );
5666:
5667:
5668: type t_jser_info_tbl_type is table of t_jser_info_rec_type index by WIP_ENTITIES.wip_entity_name%type;
5669: type t_job_name_tbl_type is table of NUMBER index by WIP_ENTITIES.wip_entity_name%type;
5670:
5671: l_job_ser_info_tbl t_jser_info_tbl_type;
5672: l_res_job_tbl t_job_name_tbl_type;
5673:

Line 5714: l_filling_job_name WIP_ENTITIES.wip_entity_name%type := null;

5710: l_temp_op_seq_num NUMBER;
5711: l_temp_op_step NUMBER;
5712:
5713: -- This is the job against which the left over serial numbers of the parent job will be assigned...
5714: l_filling_job_name WIP_ENTITIES.wip_entity_name%type := null;
5715: l_parent_as_resjob NUMBER := null;
5716: l_old_count NUMBER;
5717: l_new_count NUMBER;
5718: l_temp_job WIP_ENTITIES.wip_entity_name%TYPE; -- Used for debugging..

Line 5718: l_temp_job WIP_ENTITIES.wip_entity_name%TYPE; -- Used for debugging..

5714: l_filling_job_name WIP_ENTITIES.wip_entity_name%type := null;
5715: l_parent_as_resjob NUMBER := null;
5716: l_old_count NUMBER;
5717: l_new_count NUMBER;
5718: l_temp_job WIP_ENTITIES.wip_entity_name%TYPE; -- Used for debugging..
5719: l_index_job_name WIP_ENTITIES.wip_entity_name%TYPE;
5720: l_move_flag VARCHAR2(1) := 'N';
5721: l_curr_job_name WIP_ENTITIES.wip_entity_name%TYPE;
5722:

Line 5719: l_index_job_name WIP_ENTITIES.wip_entity_name%TYPE;

5715: l_parent_as_resjob NUMBER := null;
5716: l_old_count NUMBER;
5717: l_new_count NUMBER;
5718: l_temp_job WIP_ENTITIES.wip_entity_name%TYPE; -- Used for debugging..
5719: l_index_job_name WIP_ENTITIES.wip_entity_name%TYPE;
5720: l_move_flag VARCHAR2(1) := 'N';
5721: l_curr_job_name WIP_ENTITIES.wip_entity_name%TYPE;
5722:
5723: CURSOR c_job_serials(v_wip_entity_id IN NUMBER,v_item_id IN NUMBER)

Line 5721: l_curr_job_name WIP_ENTITIES.wip_entity_name%TYPE;

5717: l_new_count NUMBER;
5718: l_temp_job WIP_ENTITIES.wip_entity_name%TYPE; -- Used for debugging..
5719: l_index_job_name WIP_ENTITIES.wip_entity_name%TYPE;
5720: l_move_flag VARCHAR2(1) := 'N';
5721: l_curr_job_name WIP_ENTITIES.wip_entity_name%TYPE;
5722:
5723: CURSOR c_job_serials(v_wip_entity_id IN NUMBER,v_item_id IN NUMBER)
5724: IS SELECT msn.serial_number
5725: FROM MTL_SERIAL_NUMBERS MSN