[Home] [Help]
653:
654: -- Bug 3133704 . removed count for department_code within an org. For a given org id , dept code is unique.
655: select department_id
656: into l_department_id
657: from bom_departments
658: where organization_id = l_org_id
659: and department_code like p_assigned_department;
660: if(l_department_id = l_old_dept_id) then
661: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_HANDOVER_DEPT_SAME');
1382: and operation_seq_num = p_old_op_seq_num
1383: and resource_seq_num = p_resource_seq_num;
1384:
1385: select bd.department_id into l_dept
1386: from bom_department_resources bdr,bom_departments bd
1387: where bd.department_id = bdr.department_id
1388: and resource_id = l_resource_id
1389: and bd.department_id in (select department_id
1390: from bom_departments
1386: from bom_department_resources bdr,bom_departments bd
1387: where bd.department_id = bdr.department_id
1388: and resource_id = l_resource_id
1389: and bd.department_id in (select department_id
1390: from bom_departments
1391: where department_code=p_department);
1392: if(l_dept=null) then
1393: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_HANDOVER_DEPT_INVALID'
1394: ,p_token1 => 'RESOURCE_SEQ_NUM', p_value1 => p_resource_seq_num ,p_token2 => 'DEPARTMENT',p_value2 =>p_department);
1428: if( curRow.Wip_Entity_Id is not null) then
1429: BEGIN
1430: select department_id
1431: into l_department_id
1432: from bom_departments bd
1433: where bd.department_code like p_department
1434: and bd.organization_id = curRow.Organization_Id
1435: and nvl(bd.disable_date, sysdate) >= sysdate;
1436:
1793:
1794:
1795: CURSOR c_oper_cur IS --rhshriva
1796: select wo.operation_seq_num, bd.department_code
1797: from wip_operations wo, bom_departments bd
1798: where bd.department_id = wo.department_id
1799: and bd.organization_id = wo.organization_id
1800: and wo.organization_id = p_organization_id
1801: and wo.wip_entity_id = p_wip_entity_id;
3219: BEGIN
3220:
3221: SELECT department_id
3222: INTO l_department_id
3223: FROM BOM_DEPARTMENTS bd
3224: WHERE bd.organization_id = p_organization_id
3225: AND department_code = p_department_code
3226: AND NVL (bd.disable_date, sysdate+2) > sysdate
3227: AND NOT EXISTS
3309: SELECT bdp.department_id, bso.standard_operation_id,
3310: bso.shutdown_type
3311: INTO l_department_id, l_standard_operation_id,
3312: l_shutdown_type
3313: FROM BOM_DEPARTMENTS bdp,
3314: BOM_STANDARD_OPERATIONS bso
3315: WHERE bso.organization_id = p_organization_id
3316: AND bso.operation_code = p_operation_code
3317: AND bso.line_id IS NULL
4302:
4303: if (l_op_count = 1 ) then
4304: SELECT wo.operation_seq_num, bd.department_code
4305: INTO op_seq_num, op_dept_code
4306: FROM wip_operations wo, bom_departments bd
4307: WHERE wo.wip_entity_id = p_wip_entity_id and
4308: wo.organization_id = p_organization_id and
4309: wo.organization_id = bd.organization_id and
4310: wo.department_id = bd.department_id;
4342:
4343: if (l_op_count = 1 ) then
4344: SELECT wo.operation_seq_num, wo.first_unit_start_date, wo.last_unit_completion_date, bd.department_code
4345: INTO x_op_seq_num, x_op_start_date, x_op_end_date, x_op_dept_code
4346: FROM wip_operations wo, bom_departments bd
4347: WHERE wo.wip_entity_id = p_wip_entity_id and
4348: wo.organization_id = p_organization_id and
4349: wo.organization_id = bd.organization_id and
4350: wo.department_id = bd.department_id;
4375: l_resource_id := 0;
4376:
4377: SELECT department_id
4378: INTO l_department_id
4379: FROM bom_departments
4380: WHERE department_code like p_department
4381: AND organization_id = p_organization_id;
4382:
4383: -- get resources available in the assigned department