APPS.EAM_WO_SCHEDULE_PVT dependencies on WIP_OPERATION_RESOURCE_USAGE

Line 1664: DELETE FROM wip_operation_resource_usage

1660: l_stmt_num := 80;
1661:
1662: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling CALC_SCHEDULE from SCHEDULE_WO') ; END IF ;
1663:
1664: DELETE FROM wip_operation_resource_usage
1665: WHERE wip_entity_id = p_wip_entity_id
1666: AND organization_id = p_organization_id;
1667:
1668:

Line 1719: INSERT INTO WIP_OPERATION_RESOURCE_USAGE

1715: AND organization_id = p_organization_id;
1716:
1717: FOR cnt IN p_res_usage_tbl.FIRST..p_res_usage_tbl.LAST LOOP
1718:
1719: INSERT INTO WIP_OPERATION_RESOURCE_USAGE
1720: ( wip_entity_id
1721: , operation_seq_num
1722: , resource_seq_num
1723: , organization_id

Line 1775: INSERT INTO WIP_OPERATION_RESOURCE_USAGE

1771:
1772: IF l_WipOperResInst_tbl.COUNT > 0 THEN
1773: FOR mm in l_WipOperResInst_tbl.FIRST..l_WipOperResInst_tbl.LAST LOOP
1774:
1775: INSERT INTO WIP_OPERATION_RESOURCE_USAGE
1776: ( wip_entity_id
1777: , operation_seq_num
1778: , resource_seq_num
1779: , organization_id

Line 1811: FROM WIP_OPERATION_RESOURCE_USAGE

1807: , request_id
1808: , program_application_id
1809: , program_id
1810: , program_update_date
1811: FROM WIP_OPERATION_RESOURCE_USAGE
1812: WHERE wip_entity_id = p_wip_entity_id
1813: AND organization_id = p_organization_id
1814: AND operation_seq_num = l_WipOperation_tbl(mm)
1815: AND resource_seq_num = l_WipOperResource_tbl(mm)