[Home] [Help]
757:
758: CURSOR get_department(c_dept VARCHAR2,c_org_id NUMBER)
759: IS
760: SELECT department_id
761: FROM BOM_DEPARTMENTS
762: WHERE UPPER(description) LIKE UPPER(c_dept)
763: AND ORganization_id=c_org_id
764: AND TRUNC(NVL(DISABLE_DATE,SYSDATE+1)) > TRUNC(SYSDATE);
765:
1089:
1090: CURSOR validate_dept(c_dept_id NUMBER,c_org_id NUMBER)
1091: IS
1092: SELECT a.department_id
1093: FROM BOM_DEPARTMENTS a
1094: WHERE a.department_id=c_dept_id
1095: AND a.organization_id=c_org_id
1096: AND TRUNC(NVL(DISABLE_DATE,SYSDATE+1)) > TRUNC(SYSDATE);
1097:
1666: p_org_id IN NUMBER)
1667: IS
1668: SELECT DISTINCT MAP.department_id, DEPT.description
1669: FROM BOM_DEPARTMENT_RESOURCES BD, AHL_RESOURCE_MAPPINGS MAP,
1670: BOM_RESOURCES BR, BOM_DEPARTMENTS DEPT
1671: WHERE BD.resource_id = MAP.bom_resource_id
1672: AND BR.resource_id = BD.resource_id
1673: AND BR.organization_id = p_org_id
1674: AND MAP.aso_resource_id = p_aso_resource_id
1686: l_one_bomres_org varchar2(1) := 'Y';
1687: --pekambar ER # 9014609 -- End
1688:
1689: l_department_id NUMBER;
1690: l_department_name bom_departments.description%TYPE;
1691:
1692:
1693: BEGIN
1694:
1770:
1771: l_rt_oper_resource_rec get_rt_oper_resources%ROWTYPE;
1772: l_return_status varchar2(1);
1773: l_final_department_id NUMBER;
1774: l_final_department_name bom_departments.description%TYPE;
1775: l_department_id NUMBER;
1776: l_department_name bom_departments.description%TYPE;
1777:
1778:
1772: l_return_status varchar2(1);
1773: l_final_department_id NUMBER;
1774: l_final_department_name bom_departments.description%TYPE;
1775: l_department_id NUMBER;
1776: l_department_name bom_departments.description%TYPE;
1777:
1778:
1779: BEGIN
1780:
3492: l_blank_operation_txt FND_NEW_MESSAGES.message_text%TYPE;
3493:
3494: -- Added for FP bug# 7238868
3495: l_department_id NUMBER;
3496: l_department_name bom_departments.description%TYPE;
3497: l_route_found VARCHAR2(1);
3498: l_oper_found VARCHAR2(1);
3499: l_return_status VARCHAR2(1);
3500:
4650: -- Bug # 6680137 -- end
4651:
4652: -- Added for FP bug# 7238868
4653: l_department_id NUMBER;
4654: l_department_name bom_departments.description%TYPE;
4655: l_oper_found VARCHAR2(1);
4656:
4657: CURSOR get_operation_details(p_operation_code VARCHAR2)
4658: IS
6875:
6876: FROM AHL_VISIT_TASKS_B AVTB,
6877: AHL_WORKORDERS AHLW,
6878: AHL_VISITS_B AVB,
6879: BOM_DEPARTMENTS BOMD
6880:
6881: WHERE ( AVTB.stage_id = c_stage_id OR
6882: (c_stage_id = 0 AND AVTB.visit_id = c_visit_id AND AVTB.stage_id IS NULL) )
6883: AND AVTB.task_type_code = 'STAGE'