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 1141: -- Following function validates department id in bom_departments table.

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

Line 1150: from bom_departments

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

Line 1852: bom_departments bd

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

Line 1929: bom_departments bd

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

Line 2005: bom_departments bd

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

Line 2352: from bom_departments

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

Line 2359: from bom_departments bd, mtl_parameters mp

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