APPS.EAM_WORKORDERTRANSACTIONS_PUB dependencies on WIP_DISCRETE_JOBS

Line 116: -- set out params by query wip_discrete_jobs table

112: p_x_return_status := FND_API.G_RET_STS_ERROR;
113: return;
114: END IF;
115:
116: -- set out params by query wip_discrete_jobs table
117: select parent_wip_entity_id,
118: asset_group_id,
119: asset_number,
120: organization_id,

Line 133: from wip_discrete_jobs

129: l_rebuild_item_id,
130: x_manual_rebuild_flag,
131: l_status_type,
132: x_shutdown_type
133: from wip_discrete_jobs
134: where wip_entity_id = p_wip_entity_id;
135: if l_rebuild_item_id is null then
136: x_rebuild_jobs := 'N';
137: else

Line 532: from wip_discrete_jobs

528:
529: -- Bug 3676937 . For CMRO work orders need not check completion subinventory
530: select maintenance_object_source, rebuild_item_id
531: into l_maintenance_source_id, l_rebuild_item_id
532: from wip_discrete_jobs
533: where wip_entity_id = p_wip_entity_id;
534:
535:
536: if l_maintenance_source_id = 2 then -- for CMRO no inventory item info is required.

Line 1046: select count(*) into l_count from wip_discrete_jobs where

1042:
1043: BEGIN
1044:
1045: -- Validate WIP Entity Id
1046: select count(*) into l_count from wip_discrete_jobs where
1047: wip_entity_id = p_wip_entity_id and
1048: organization_id = p_organization_id;
1049: if l_count <> 1 then
1050: x_return_status := 'E';

Line 1056: update wip_discrete_jobs set manual_rebuild_flag = p_manual_rebuild_flag

1052: end if;
1053:
1054: -- Set Manual Rebuild Flag
1055: IF p_manual_rebuild_flag is not null then
1056: update wip_discrete_jobs set manual_rebuild_flag = p_manual_rebuild_flag
1057: where wip_entity_id = p_wip_entity_id and
1058: organization_id = p_organization_id;
1059: END IF;
1060:

Line 1084: select count(*) into l_count from wip_discrete_jobs where

1080:
1081: BEGIN
1082:
1083: -- Validate WIP Entity Id
1084: select count(*) into l_count from wip_discrete_jobs where
1085: wip_entity_id = p_wip_entity_id and
1086: organization_id = p_organization_id;
1087: if l_count <> 1 then
1088: x_return_status := 'E';

Line 1103: update wip_discrete_jobs set owning_department = p_owning_department

1099: end if;
1100:
1101: -- Set Owning Department
1102: IF p_owning_department is not null then
1103: update wip_discrete_jobs set owning_department = p_owning_department
1104: where wip_entity_id = p_wip_entity_id and
1105: organization_id = p_organization_id;
1106: END IF;
1107:

Line 1149: FROM WIP_DJ_CLOSE_TEMP wdct, wip_discrete_jobs wdj

1145: , last_updated_by = FND_GLOBAL.user_id
1146: , last_update_login = FND_GLOBAL.login_id
1147: WHERE organization_id = p_organization_id
1148: AND WIP_ENTITY_ID IN (SELECT wdct.WIP_ENTITY_ID
1149: FROM WIP_DJ_CLOSE_TEMP wdct, wip_discrete_jobs wdj
1150: WHERE wdct.ORGANIZATION_ID = p_organization_id
1151: AND wdct.GROUP_ID = p_group_id
1152: and wdj.wip_entity_id = wdct.WIP_ENTITY_ID
1153: and wdj.status_type = WIP_CONSTANTS.PEND_CLOSE);

Line 1196: FROM wip_discrete_jobs wdj, wip_dj_close_temp wdct, eam_work_order_details ewod, wip_entities we

1192: CURSOR workorders
1193: IS
1194: SELECT wdj.wip_entity_id, we.wip_entity_name,
1195: wdj.status_type, wdj.organization_id, ewod.user_defined_status_id, ewod.workflow_type
1196: FROM wip_discrete_jobs wdj, wip_dj_close_temp wdct, eam_work_order_details ewod, wip_entities we
1197: WHERE wdct.group_id = p_group_id
1198: and wdct.wip_entity_id = wdj.wip_entity_id
1199: and wdct.organization_id = wdj.organization_id
1200: and wdj.wip_entity_id = ewod.wip_entity_id