APPS.EAM_WORKORDER_UTIL_PKG dependencies on WIP_OPERATION_RESOURCES

Line 426: from wip_operation_resources

422: BEGIN
423: -- Get the New Date Range
424: select min(start_date), max(completion_date)
425: into l_op_start_date, l_op_completion_date
426: from wip_operation_resources
427: where wip_entity_id = i_wip_entity_id
428: and operation_seq_num = l_op_seq_num;
429: -- Update the Operation
430:

Line 522: update wip_operation_resources set

518: return;
519: end if;
520: l_index := i_operation_table.FIRST;
521: LOOP
522: update wip_operation_resources set
523: start_date = start_date, -- + i_operation_table(l_index).time_shift,
524: completion_date = completion_date --+ i_operation_table(l_index).time_shift
525: where wip_entity_id = i_wip_entity_id
526: and operation_seq_num = i_operation_table(l_index).operation_seq_num;

Line 546: update wip_operation_resources set

542: last_unit_start_date = last_unit_start_date,
543: last_unit_completion_date = last_unit_completion_date
544: where wip_entity_id = i_wip_entity_id;
545: -- Resources
546: update wip_operation_resources set
547: start_date = start_date,
548: completion_date = completion_date
549: where wip_entity_id = i_wip_entity_id;
550: END adjust_workorder;

Line 1099: FROM WIP_OPERATION_RESOURCES

1095: SELECT DISTINCT '1'
1096: into charges_exist_3
1097: FROM dual
1098: where EXISTS (SELECT '1'
1099: FROM WIP_OPERATION_RESOURCES
1100: WHERE ORGANIZATION_ID = x_org_id
1101: AND WIP_ENTITY_ID = x_wip_id
1102: AND APPLIED_RESOURCE_UNITS <> 0);
1103:

Line 1364: FROM WIP_OPERATION_RESOURCES

1360: SELECT DISTINCT '1'
1361: into charges_exist_3
1362: FROM dual
1363: where EXISTS (SELECT '1'
1364: FROM WIP_OPERATION_RESOURCES
1365: WHERE ORGANIZATION_ID = x_org_id
1366: AND WIP_ENTITY_ID = x_wip_id
1367: AND APPLIED_RESOURCE_UNITS <> 0);
1368:

Line 1636: FROM WIP_OPERATION_RESOURCES

1632: SELECT DISTINCT '1'
1633: into charges_exist_2
1634: FROM dual
1635: where EXISTS (SELECT '1'
1636: FROM WIP_OPERATION_RESOURCES
1637: WHERE ORGANIZATION_ID = p_org_id
1638: AND WIP_ENTITY_ID = p_wip_id
1639: AND APPLIED_RESOURCE_UNITS <> 0);
1640: