[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;
3729: BEGIN
3730:
3731: SELECT department_id
3732: INTO l_department_id
3733: FROM BOM_DEPARTMENTS bd
3734: WHERE bd.organization_id = p_organization_id
3735: AND department_code = p_department_code
3736: AND NVL (bd.disable_date, sysdate+2) > sysdate
3737: AND NOT EXISTS
3819: SELECT bdp.department_id, bso.standard_operation_id,
3820: bso.shutdown_type
3821: INTO l_department_id, l_standard_operation_id,
3822: l_shutdown_type
3823: FROM BOM_DEPARTMENTS bdp,
3824: BOM_STANDARD_OPERATIONS bso
3825: WHERE bso.organization_id = p_organization_id
3826: AND bso.operation_code = p_operation_code
3827: AND bso.line_id IS NULL
4812:
4813: if (l_op_count = 1 ) then
4814: SELECT wo.operation_seq_num, bd.department_code
4815: INTO op_seq_num, op_dept_code
4816: FROM wip_operations wo, bom_departments bd
4817: WHERE wo.wip_entity_id = p_wip_entity_id and
4818: wo.organization_id = p_organization_id and
4819: wo.organization_id = bd.organization_id and
4820: wo.department_id = bd.department_id;
4852:
4853: if (l_op_count = 1 ) then
4854: SELECT wo.operation_seq_num, wo.first_unit_start_date, wo.last_unit_completion_date, bd.department_code
4855: INTO x_op_seq_num, x_op_start_date, x_op_end_date, x_op_dept_code
4856: FROM wip_operations wo, bom_departments bd
4857: WHERE wo.wip_entity_id = p_wip_entity_id and
4858: wo.organization_id = p_organization_id and
4859: wo.organization_id = bd.organization_id and
4860: wo.department_id = bd.department_id;
4885: l_resource_id := 0;
4886:
4887: SELECT department_id
4888: INTO l_department_id
4889: FROM bom_departments
4890: WHERE department_code like p_department
4891: AND organization_id = p_organization_id;
4892:
4893: -- get resources available in the assigned department