APPS.EAM_WORKORDER_UTIL_PKG dependencies on WIP_DISCRETE_JOBS

Line 454: update wip_discrete_jobs set

450: from wip_operations
451: where wip_entity_id = i_wip_entity_id;
452:
453: if (l_wo_start_date is not null and l_wo_completion_date is not null) then
454: update wip_discrete_jobs set
455: scheduled_start_date = l_wo_start_date,
456: scheduled_completion_date = l_wo_completion_date
457: where wip_entity_id = i_wip_entity_id;
458: end if;

Line 507: update wip_discrete_jobs set

503: into l_wo_start_date, l_wo_completion_date
504: from wip_operations
505: where wip_entity_id = i_wip_entity_id;
506:
507: update wip_discrete_jobs set
508: scheduled_start_date = l_wo_start_date,
509: scheduled_completion_date = l_wo_completion_date
510: where wip_entity_id = i_wip_entity_id;
511: EXCEPTION

Line 1004: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB

1000:
1001: -- bug fix 2675869: removed 'distinct' from following query and added additonal ROWNUM<=1
1002: SELECT '1'
1003: into charges_exist_1
1004: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB
1005: WHERE DJ.WIP_ENTITY_ID = WPB.WIP_ENTITY_ID
1006: AND DJ.ORGANIZATION_ID = WPB.ORGANIZATION_ID
1007: AND DJ.WIP_ENTITY_ID = x_wip_id
1008: AND DJ.ORGANIZATION_ID = x_org_id

Line 1298: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB

1294: begin
1295: -- bug fix 2675869: removed 'distinct' from following query and added additonal ROWNUM<=1
1296: SELECT '1'
1297: into charges_exist_1
1298: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB
1299: WHERE DJ.WIP_ENTITY_ID = WPB.WIP_ENTITY_ID
1300: AND DJ.ORGANIZATION_ID = WPB.ORGANIZATION_ID
1301: AND DJ.WIP_ENTITY_ID = x_wip_id
1302: AND DJ.ORGANIZATION_ID = x_org_id

Line 1900: from eam_work_order_details ewod, wip_discrete_jobs wdj

1896: BEGIN
1897:
1898: select 1
1899: INTO l_temp
1900: from eam_work_order_details ewod, wip_discrete_jobs wdj
1901: where wdj.status_type not in (3,4,5,12)
1902: and ewod.pending_flag = 'Y'
1903: and ewod.wip_entity_id = wdj.wip_entity_id
1904: and ewod.wip_entity_id = (select wip_entity_id from EAM_WO_WORKFLOWS where wf_item_key=p_item_key);

Line 2009: UPDATE WIP_DISCRETE_JOBS

2005:
2006: -- Initialize API return status to success
2007: x_return_status := FND_API.G_RET_STS_SUCCESS;
2008:
2009: UPDATE WIP_DISCRETE_JOBS
2010: SET estimation_status = 2
2011: WHERE wip_entity_id = p_wip_entity_id
2012: AND organization_id = p_organization_id;
2013:

Line 2046: FROM WIP_DISCRETE_JOBS wdj

2042:
2043:
2044: SELECT wdj.maintenance_object_id
2045: bulk collect into l_maint_objid_tbl
2046: FROM WIP_DISCRETE_JOBS wdj
2047: WHERE wdj.parent_wip_entity_id = p_wip_entity_id
2048: AND wdj.organization_id = p_organization_id
2049: AND wdj.manual_rebuild_flag = 'N'
2050: AND wdj.maintenance_object_type = 3;