DBA Data[Home] [Help]

APPS.EAM_OP_VALIDATE_PVT dependencies on BOM_DEPARTMENTS

Line 313: from bom_departments

309: if (p_eam_op_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
310:
311: select 1
312: into g_dummy
313: from bom_departments
314: where department_id = p_eam_op_rec.department_id
315: and organization_id = p_eam_op_rec.organization_id;
316:
317: if (p_eam_op_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE and

Line 359: FROM bom_departments bd

355: WHEN OP_DEPT_NOT_UPDATEABLE THEN
356: l_token_tbl(1).token_name := 'DEPT_NAME';
357:
358: SELECT bd.department_code into l_token_tbl(1).token_value
359: FROM bom_departments bd
360: WHERE bd.DEPARTMENT_ID = p_eam_op_rec.department_id
361: AND bd.organization_id = p_eam_op_rec.organization_id;
362:
363:

Line 382: FROM bom_departments bd

378:
379: l_token_tbl(1).token_name := 'DEPARTMENT_NAME';
380:
381: SELECT bd.department_code into l_token_tbl(1).token_value
382: FROM bom_departments bd
383: WHERE bd.DEPARTMENT_ID = p_eam_op_rec.department_id
384: AND bd.organization_id = p_eam_op_rec.organization_id;
385:
386: