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.EAM_COMMON_UTILITIES_PVT dependencies on BOM_DEPARTMENTS

Line 1142: -- Following function validates department id in bom_departments table.

1138: end if;
1139: end;
1140:
1141:
1142: -- Following function validates department id in bom_departments table.
1143: FUNCTION validate_department_id
1144: (
1145: p_department_id in number,
1146: p_organization_id in number

Line 1151: from bom_departments

1147: ) return boolean is
1148: l_count number;
1149: begin
1150: select count(*) into l_count
1151: from bom_departments
1152: where department_id=p_department_id
1153: and organization_id=p_organization_id;
1154:
1155: if (l_count>0) then

Line 1853: bom_departments bd

1849: (
1850: SELECT 1
1851: FROM bom_resource_employees bre,
1852: bom_dept_res_instances bdri,
1853: bom_departments bd
1854: WHERE bre.person_id = p_employee_id
1855: AND bre.effective_start_date <= sysdate
1856: AND bre.effective_end_date >= sysdate
1857: AND bre.resource_id = bdri.resource_id

Line 1930: bom_departments bd

1926: (
1927: SELECT 1
1928: FROM bom_resource_employees bre,
1929: bom_dept_res_instances bdri,
1930: bom_departments bd
1931: WHERE bre.person_id = p_employee_id
1932: AND bre.effective_start_date <= sysdate
1933: AND bre.effective_end_date >= sysdate
1934: AND bre.resource_id = bdri.resource_id

Line 2006: bom_departments bd

2002: (
2003: SELECT 1
2004: FROM bom_resource_employees bre,
2005: bom_dept_res_instances bdri,
2006: bom_departments bd
2007: WHERE bre.person_id = p_employee_id
2008: AND bre.effective_start_date <= sysdate
2009: AND bre.effective_end_date >= sysdate
2010: AND bre.resource_id = bdri.resource_id

Line 2353: from bom_departments

2349: elsif p_dept_id is null and p_dept_code is null then
2350: return null;
2351: elsif p_dept_code is not null and p_org_id is not null then
2352: select department_id into l_dept_id
2353: from bom_departments
2354: where department_code = p_dept_code
2355: and organization_id = p_org_id;
2356:
2357: return l_dept_id;

Line 2360: from bom_departments bd, mtl_parameters mp

2356:
2357: return l_dept_id;
2358: else
2359: select bd.department_id into l_dept_id
2360: from bom_departments bd, mtl_parameters mp
2361: where bd.department_code = p_dept_code
2362: and mp.organization_code = p_org_code
2363: and bd.organization_id = mp.organization_id;
2364: