eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_RM_ROUTE_UTIL dependencies on BOM_DEPARTMENTS

Line 2627: p_bom_org_id IN BOM_DEPARTMENTS.organization_id%TYPE,

2623: (
2624: x_return_status OUT NOCOPY VARCHAR2,
2625: x_msg_data OUT NOCOPY VARCHAR2,
2626: p_bom_resource_id IN NUMBER,
2627: p_bom_org_id IN BOM_DEPARTMENTS.organization_id%TYPE,
2628: p_bom_department_name IN BOM_DEPARTMENTS.DESCRIPTION%TYPE,
2629: p_x_bom_department_id IN OUT NOCOPY BOM_DEPARTMENTS.department_id%TYPE
2630: )
2631: IS

Line 2628: p_bom_department_name IN BOM_DEPARTMENTS.DESCRIPTION%TYPE,

2624: x_return_status OUT NOCOPY VARCHAR2,
2625: x_msg_data OUT NOCOPY VARCHAR2,
2626: p_bom_resource_id IN NUMBER,
2627: p_bom_org_id IN BOM_DEPARTMENTS.organization_id%TYPE,
2628: p_bom_department_name IN BOM_DEPARTMENTS.DESCRIPTION%TYPE,
2629: p_x_bom_department_id IN OUT NOCOPY BOM_DEPARTMENTS.department_id%TYPE
2630: )
2631: IS
2632:

Line 2629: p_x_bom_department_id IN OUT NOCOPY BOM_DEPARTMENTS.department_id%TYPE

2625: x_msg_data OUT NOCOPY VARCHAR2,
2626: p_bom_resource_id IN NUMBER,
2627: p_bom_org_id IN BOM_DEPARTMENTS.organization_id%TYPE,
2628: p_bom_department_name IN BOM_DEPARTMENTS.DESCRIPTION%TYPE,
2629: p_x_bom_department_id IN OUT NOCOPY BOM_DEPARTMENTS.department_id%TYPE
2630: )
2631: IS
2632:
2633: l_bom_department_id number;

Line 2635: CURSOR get_rec_from_value ( c_bom_department_name BOM_DEPARTMENTS.DESCRIPTION%TYPE , c_bom_resource_id NUMBER, c_bom_org_id NUMBER)

2631: IS
2632:
2633: l_bom_department_id number;
2634:
2635: CURSOR get_rec_from_value ( c_bom_department_name BOM_DEPARTMENTS.DESCRIPTION%TYPE , c_bom_resource_id NUMBER, c_bom_org_id NUMBER)
2636: IS
2637: select distinct DEPT.department_id
2638: from bom_departments DEPT, BOM_DEPARTMENT_RESOURCES DEPT_RES, BOM_RESOURCES RES
2639: where DEPT_RES.department_id = DEPT.department_id

Line 2638: from bom_departments DEPT, BOM_DEPARTMENT_RESOURCES DEPT_RES, BOM_RESOURCES RES

2634:
2635: CURSOR get_rec_from_value ( c_bom_department_name BOM_DEPARTMENTS.DESCRIPTION%TYPE , c_bom_resource_id NUMBER, c_bom_org_id NUMBER)
2636: IS
2637: select distinct DEPT.department_id
2638: from bom_departments DEPT, BOM_DEPARTMENT_RESOURCES DEPT_RES, BOM_RESOURCES RES
2639: where DEPT_RES.department_id = DEPT.department_id
2640: and DEPT.description = c_bom_department_name
2641: and DEPT_RES.resource_id = c_bom_resource_id
2642: and DEPT.organization_id = c_bom_org_id;