[Home] [Help]
22: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;
23: g_ret_error varchar2(1) := FND_API.G_RET_STS_ERROR;
24: g_ret_unexpected varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25:
26: type t_wip_entity_name_tbl is table of NUMBER index by WIP_ENTITIES.wip_entity_name%TYPE;
27:
28: -- Derives the routing sequence information...
29: PROCEDURE routing_seq ( p_job_type IN NUMBER,
30: p_org_id IN NUMBER,
646: BEGIN
647: l_stmt_num := 30;
648: SELECT 1
649: INTO l_temp_num
650: FROM wip_entities
651: WHERE wip_entity_name = p_job_name
652: AND organization_id = p_org_id;
653:
654: IF l_temp_num = 1 then
1243: x_msg_count OUT NOCOPY NUMBER,
1244: x_msg_data OUT NOCOPY VARCHAR2
1245: ) IS
1246:
1247: l_wip_entity_id WIP_ENTITIES.wip_entity_id%TYPE ;
1248:
1249: -- Cursor to obtain the job specific information
1250: cursor c_wdj_details_name is
1251: -- Job specific details
1278: we.organization_id ,
1279: wdj.serialization_start_op ,
1280: wdj.wip_supply_type
1281: from wip_discrete_jobs wdj,
1282: wip_entities we
1283: where we.wip_entity_id = nvl(p_starting_job_rec.wip_entity_id,we.wip_entity_id)
1284: and we.wip_entity_name = p_starting_job_rec.wip_entity_name
1285: and wdj.wip_entity_id = we.wip_entity_id
1286: and we.organization_id = p_txn_org_id;
1317: we.organization_id ,
1318: wdj.serialization_start_op ,
1319: wdj.wip_supply_type
1320: from wip_discrete_jobs wdj,
1321: wip_entities we
1322: where wdj.wip_entity_id = p_starting_job_rec.wip_entity_id
1323: and we.wip_entity_name = nvl(p_starting_job_rec.wip_entity_name,we.wip_entity_name)
1324: and wdj.wip_entity_id = we.wip_entity_id
1325: and we.organization_id = p_txn_org_id;
1355: and wo.wip_entity_id = l_wip_entity_id
1356: and wo.operation_seq_num = operation_seq_num
1357: and (nvl(wo.quantity_in_queue,0) > 0 or nvl(wo.quantity_waiting_to_move,0) > 0);
1358:
1359: l_wip_entity_name WIP_ENTITIES.wip_entity_name%TYPE ;
1360: l_description WIP_DISCRETE_JOBS.description%TYPE ;
1361: l_status_type WIP_DISCRETE_JOBS.status_type%TYPE ;
1362: l_primary_item_id WIP_DISCRETE_JOBS.primary_item_id%TYPE ;
1363: l_job_type WIP_DISCRETE_JOBS.job_type%TYPE ;
1380: l_completion_subinventory WIP_DISCRETE_JOBS.completion_subinventory%TYPE ;
1381: l_completion_locator_id WIP_DISCRETE_JOBS.completion_locator_id%TYPE ;
1382: l_kanban_card_id WIP_DISCRETE_JOBS.kanban_card_id%TYPE ;
1383: l_coproducts_supply WIP_DISCRETE_JOBS.coproducts_supply%TYPE ;
1384: l_organization_id WIP_ENTITIES.organization_id%TYPE ;
1385: l_wip_supply_type NUMBER ;
1386: l_serial_track_flag NUMBER ;
1387:
1388: l_operation_seq_num NUMBER;
5109: l_stmt_num := 40;
5110: -- check if already existing job name
5111: select 1
5112: into l_dummy
5113: from wip_entities WE
5114: where WE.wip_entity_name = p_resulting_job_rec.wip_entity_name
5115: and WE.organization_id = p_txn_org_id;
5116:
5117: if l_dummy=1 then