DBA Data[Home] [Help]

APPS.BOM_RESOURCE_SHIFTS_PKG dependencies on BOM_RESOURCE_CHANGES

Line 12: (select 1 from bom_resource_changes

8: Dummy NUMBER;
9: BEGIN
10: message_name := 'BOM_CANNOT_DELETE_SHIFT';
11: select 1 into dummy from dual where not exists
12: (select 1 from bom_resource_changes
13: where department_id = X_Department_Id
14: and resource_id = X_Resource_Id
15: and shift_num = X_Shift_Num);
16: