DBA Data[Home] [Help]

APPS.EAM_OTL_TIMECARD_PUB dependencies on WIP_OPERATIONS

Line 2055: select count(*) into l_count from wip_operations where

2051: end if;
2052:
2053: -- 5. operations do belong to the work order
2054: if l_wip_entity_id <> -9999 and l_org_id <> -9999 and l_operation_number <> -9999 then
2055: select count(*) into l_count from wip_operations where
2056: wip_entity_id = l_wip_entity_id and
2057: organization_id = l_org_id and
2058: operation_seq_num = l_operation_number;
2059: if l_count = 0 then

Line 2078: select count(*) into l_count from wip_operations where

2074:
2075: -- 6. Check whether department and operation association is correct.
2076: if l_wip_entity_id <> -9999 and l_org_id <> -9999 and l_operation_number <> -9999
2077: and l_dept_id <> -9999 then
2078: select count(*) into l_count from wip_operations where
2079: wip_entity_id = l_wip_entity_id and
2080: operation_seq_num = l_operation_number and
2081: organization_id = l_org_id and
2082: department_id = l_dept_id;