[Home] [Help]
246: end if;
247:
248: select resource_over_util_cost
249: into v_resource_over_util_cost
250: from msc_department_resources
251: where department_id = arg_department_id
252: and resource_id = arg_resource_id
253: and organization_id = arg_org_id
254: and sr_instance_id = arg_instance_id
786: elsif arg_org_id is null then
787:
788: select distinct department_code
789: into v_department_code
790: from msc_department_resources
791: where department_id = arg_dept_id
792: and plan_id = arg_plan_id
793: and sr_instance_id = arg_instance_id
794: and line_flag = arg_line_flag;
796: else
797:
798: select distinct department_code
799: into v_department_code
800: from msc_department_resources
801: where department_id = arg_dept_id
802: and plan_id = arg_plan_id
803: and organization_id = arg_org_id
804: and sr_instance_id = arg_instance_id
821:
822: if arg_dept_id = -1 then -- from undo, arg_org_id will pass transaction_id
823: select distinct mdr.resource_code
824: into v_resource_code
825: from msc_department_resources mdr,
826: msc_resource_requirements mrr
827: where mdr.department_id = mrr.department_id
828: and mdr.resource_id = arg_resource_id
829: and mdr.plan_id = mrr.plan_id
845: else
846:
847: select distinct resource_code
848: into v_resource_code
849: from msc_department_resources
850: where department_id = arg_dept_id
851: and resource_id = arg_resource_id
852: and plan_id = arg_plan_id
853: and organization_id = arg_org_id
874: return util_pct;
875: else
876: select utilization
877: into util_pct
878: from msc_department_resources
879: where department_id = arg_dept_id
880: and resource_id = arg_resource_id
881: and plan_id = arg_plan_id
882: and organization_id = arg_org_id
909: end if;
910:
911: select resource_type
912: into v_resource_type
913: from msc_department_resources
914: where department_id = arg_dept_id
915: and resource_id = arg_resource_id
916: and plan_id = arg_plan_id
917: and organization_id = arg_org_id
942: v_org_code := msc_get_name.org_code(arg_org_id, arg_instance_id);
943:
944: select department_code || '/' || resource_code
945: into v_dept_resource_code
946: from msc_department_resources
947: where department_id = arg_dept_id
948: and resource_id = arg_resource_id
949: and plan_id = arg_plan_id
950: and organization_id = arg_org_id
963: v_org_code varchar2(15);
964:
965: CURSOR flag_c IS
966: select nvl(Batchable_flag,2)
967: from msc_department_resources
968: where department_id = arg_dept_id
969: and resource_id = arg_resource_id
970: and plan_id = arg_plan_id
971: and organization_id = arg_org_id
1007: end if;
1008:
1009: select decode(min_capacity,0,null, min_capacity)
1010: into v_res_min_capacity
1011: from msc_department_resources
1012: where department_id = arg_dept_id
1013: and resource_id = arg_resource_id
1014: and plan_id = arg_plan_id
1015: and organization_id = arg_org_id
1056: and rownum = 1;
1057:
1058: select decode(max_capacity,0 , null,max_capacity)
1059: into v_res_max_capacity
1060: from msc_department_resources
1061: where department_id = arg_dept_id
1062: and resource_id = arg_resource_id
1063: and plan_id = arg_plan_id
1064: and organization_id = arg_org_id
2379: p_resource_id number) return varchar2 IS
2380:
2381: CURSOR batchable_uom_cur IS
2382: SELECT unit_of_measure
2383: FROM msc_department_resources
2384: WHERE plan_id > -1
2385: and organization_id = p_organization_id
2386: and department_id = p_department_id
2387: and resource_id = p_resource_id;
3743: end if;
3744:
3745: select resource_group_name
3746: into l_group
3747: from msc_department_resources
3748: where department_id = arg_dept_id
3749: and resource_id = arg_resource_id
3750: and plan_id = arg_plan_id
3751: and organization_id = arg_org_id
4085: Mrr.Resource_Id,
4086: Mdr.Resource_Code,
4087: Mrr.Department_Id,
4088: Mdr.Department_Code
4089: From Msc_Department_Resources Mdr,
4090: Msc_Resource_Requirements Mrr
4091: Where Mrr.Transaction_Id = P_Res_Transaction_Id
4092: And Mrr.Plan_Id = P_Plan_Id
4093: And Mrr.Sr_Instance_Id = P_Sr_Instance_Id
4666:
4667: cursor cur(l_plan_id number ,l_sr_instance_id number ,l_organization_id number
4668: ,l_department_id number ,l_resource_id number) is
4669: select utilization_change_percent
4670: from msc_department_resources
4671: where plan_id = l_plan_id
4672: and sr_instance_id = l_sr_instance_id
4673: and organization_id = l_organization_id
4674: and department_id = l_department_id