APPS.EAM_WO_SCHEDULE_PVT dependencies on WIP_DISCRETE_JOBS

Line 1513: update wip_discrete_jobs

1509: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Negative workorder duration') ; END IF ;
1510: return;
1511: end if;
1512:
1513: update wip_discrete_jobs
1514: set scheduled_start_date = p_start_date,
1515: scheduled_completion_date = p_completion_date
1516: where wip_entity_id = p_wip_entity_id
1517: and organization_id = p_organization_id;

Line 1713: FROM wip_discrete_jobs

1709: IF p_res_usage_tbl.count > 0 THEN
1710:
1711: SELECT request_id,program_application_id,program_id,program_update_date
1712: INTO l_request_id,l_program_application_id,l_program_id,l_program_update_date
1713: FROM wip_discrete_jobs
1714: WHERE wip_entity_id = p_wip_entity_id
1715: AND organization_id = p_organization_id;
1716:
1717: FOR cnt IN p_res_usage_tbl.FIRST..p_res_usage_tbl.LAST LOOP

Line 1841: from wip_discrete_jobs

1837: IF l_relationship_record.parent_object_id is not null then
1838:
1839: select scheduled_start_date,scheduled_completion_date,status_type,date_completed
1840: into l_start_date,l_compl_date,l_status_type,l_date_completed
1841: from wip_discrete_jobs
1842: where wip_entity_id = l_relationship_record.child_object_id
1843: and organization_id = p_organization_id;
1844:
1845: --do not consider child workorders which are cancelled or [closed and date_completed is null](closed from cancelled status)

Line 1872: from wip_discrete_jobs

1868:
1869:
1870: select scheduled_start_date, scheduled_completion_date
1871: into l_wo_start_date, l_wo_end_date
1872: from wip_discrete_jobs
1873: where wip_entity_id = p_wip_entity_id
1874: and organization_id = p_organization_id;
1875:
1876:

Line 1878: update wip_discrete_jobs set

1874: and organization_id = p_organization_id;
1875:
1876:
1877: if l_wo_start_date > nvl(l_min_date,l_wo_start_date+1) then
1878: update wip_discrete_jobs set
1879: scheduled_start_date = l_min_date
1880: where wip_entity_id = p_wip_entity_id
1881: and organization_id = p_organization_id;
1882: end if;

Line 1884: update wip_discrete_jobs set

1880: where wip_entity_id = p_wip_entity_id
1881: and organization_id = p_organization_id;
1882: end if;
1883: if l_wo_end_date < nvl(l_max_date,l_wo_end_date -1) then
1884: update wip_discrete_jobs set
1885: scheduled_completion_date = l_max_date
1886: where wip_entity_id = p_wip_entity_id
1887: and organization_id = p_organization_id;
1888:

Line 1894: from wip_discrete_jobs

1890:
1891: -- bug no 3444091
1892: select scheduled_start_date, scheduled_completion_date
1893: into l_wo_start_date, l_wo_end_date
1894: from wip_discrete_jobs
1895: where wip_entity_id = p_wip_entity_id
1896: and organization_id = p_organization_id;
1897:
1898: if l_wo_start_date > l_wo_end_date then