APPS.EAM_WO_SCHEDULE_PVT dependencies on WIP_DISCRETE_JOBS

Line 1494: update wip_discrete_jobs

1490: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Negative workorder duration') ; END IF ;
1491: return;
1492: end if;
1493:
1494: update wip_discrete_jobs
1495: set scheduled_start_date = p_start_date,
1496: scheduled_completion_date = p_completion_date
1497: where wip_entity_id = p_wip_entity_id
1498: and organization_id = p_organization_id;

Line 1694: FROM wip_discrete_jobs

1690: IF p_res_usage_tbl.count > 0 THEN
1691:
1692: SELECT request_id,program_application_id,program_id,program_update_date
1693: INTO l_request_id,l_program_application_id,l_program_id,l_program_update_date
1694: FROM wip_discrete_jobs
1695: WHERE wip_entity_id = p_wip_entity_id
1696: AND organization_id = p_organization_id;
1697:
1698: FOR cnt IN p_res_usage_tbl.FIRST..p_res_usage_tbl.LAST LOOP

Line 1822: from wip_discrete_jobs

1818: IF l_relationship_record.parent_object_id is not null then
1819:
1820: select scheduled_start_date,scheduled_completion_date,status_type,date_completed
1821: into l_start_date,l_compl_date,l_status_type,l_date_completed
1822: from wip_discrete_jobs
1823: where wip_entity_id = l_relationship_record.child_object_id
1824: and organization_id = p_organization_id;
1825:
1826: --do not consider child workorders which are cancelled or [closed and date_completed is null](closed from cancelled status)

Line 1853: from wip_discrete_jobs

1849:
1850:
1851: select scheduled_start_date, scheduled_completion_date
1852: into l_wo_start_date, l_wo_end_date
1853: from wip_discrete_jobs
1854: where wip_entity_id = p_wip_entity_id
1855: and organization_id = p_organization_id;
1856:
1857:

Line 1859: update wip_discrete_jobs set

1855: and organization_id = p_organization_id;
1856:
1857:
1858: if l_wo_start_date > nvl(l_min_date,l_wo_start_date+1) then
1859: update wip_discrete_jobs set
1860: scheduled_start_date = l_min_date
1861: where wip_entity_id = p_wip_entity_id
1862: and organization_id = p_organization_id;
1863: end if;

Line 1865: update wip_discrete_jobs set

1861: where wip_entity_id = p_wip_entity_id
1862: and organization_id = p_organization_id;
1863: end if;
1864: if l_wo_end_date < nvl(l_max_date,l_wo_end_date -1) then
1865: update wip_discrete_jobs set
1866: scheduled_completion_date = l_max_date
1867: where wip_entity_id = p_wip_entity_id
1868: and organization_id = p_organization_id;
1869:

Line 1875: from wip_discrete_jobs

1871:
1872: -- bug no 3444091
1873: select scheduled_start_date, scheduled_completion_date
1874: into l_wo_start_date, l_wo_end_date
1875: from wip_discrete_jobs
1876: where wip_entity_id = p_wip_entity_id
1877: and organization_id = p_organization_id;
1878:
1879: if l_wo_start_date > l_wo_end_date then