APPS.EAM_WO_SCHEDULE_PVT dependencies on WIP_OPERATION_RESOURCE_USAGE

Line 1645: DELETE FROM wip_operation_resource_usage

1641: l_stmt_num := 80;
1642:
1643: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling CALC_SCHEDULE from SCHEDULE_WO') ; END IF ;
1644:
1645: DELETE FROM wip_operation_resource_usage
1646: WHERE wip_entity_id = p_wip_entity_id
1647: AND organization_id = p_organization_id;
1648:
1649:

Line 1700: INSERT INTO WIP_OPERATION_RESOURCE_USAGE

1696: AND organization_id = p_organization_id;
1697:
1698: FOR cnt IN p_res_usage_tbl.FIRST..p_res_usage_tbl.LAST LOOP
1699:
1700: INSERT INTO WIP_OPERATION_RESOURCE_USAGE
1701: ( wip_entity_id
1702: , operation_seq_num
1703: , resource_seq_num
1704: , organization_id

Line 1756: INSERT INTO WIP_OPERATION_RESOURCE_USAGE

1752:
1753: IF l_WipOperResInst_tbl.COUNT > 0 THEN
1754: FOR mm in l_WipOperResInst_tbl.FIRST..l_WipOperResInst_tbl.LAST LOOP
1755:
1756: INSERT INTO WIP_OPERATION_RESOURCE_USAGE
1757: ( wip_entity_id
1758: , operation_seq_num
1759: , resource_seq_num
1760: , organization_id

Line 1792: FROM WIP_OPERATION_RESOURCE_USAGE

1788: , request_id
1789: , program_application_id
1790: , program_id
1791: , program_update_date
1792: FROM WIP_OPERATION_RESOURCE_USAGE
1793: WHERE wip_entity_id = p_wip_entity_id
1794: AND organization_id = p_organization_id
1795: AND operation_seq_num = l_WipOperation_tbl(mm)
1796: AND resource_seq_num = l_WipOperResource_tbl(mm)