APPS.EAM_CREATEUPDATE_WO_PVT dependencies on WIP_DISCRETE_JOBS

Line 343: FROM WIP_DISCRETE_JOBS

339: ,maintenance_object_id
340: INTO
341: l_maintenance_object_type
342: ,l_maintenance_object_id
343: FROM WIP_DISCRETE_JOBS
344: WHERE wip_entity_id = l_eam_wo_comp_rec.wip_entity_id;
345:
346: --only if asset number/rebuild serial number exists for work order
347: IF(l_maintenance_object_type =3) THEN

Line 536: FROM WIP_DISCRETE_JOBS

532: /* Code Added for bug#6053425 Start */
533: ,l_prev_project_id
534: ,l_prev_task_id
535: /* Code Added for bug#6053425 End */
536: FROM WIP_DISCRETE_JOBS
537: where wip_entity_id = l_wip_entity_id;
538:
539: IF(l_asset_number is NOT NULL and l_eam_wo_rec.asset_number IS NULL) THEN
540: l_eam_wo_rec.asset_number := FND_API.G_MISS_CHAR;

Line 672: p_desc_flex_name => 'WIP_DISCRETE_JOBS',

668:
669: --Validate descriptive flexfield for workorder
670: l_validate := EAM_COMMON_UTILITIES_PVT.validate_desc_flex_field(
671: p_app_short_name => 'WIP',
672: p_desc_flex_name => 'WIP_DISCRETE_JOBS',
673: p_attribute_category => l_eam_wo_rec.attribute_category,
674: p_attribute1 => l_eam_wo_rec.attribute1,
675: p_attribute2 => l_eam_wo_rec.attribute2,
676: p_attribute3 => l_eam_wo_rec.attribute3,

Line 1973: FROM WIP_DISCRETE_JOBS

1969: ,maintenance_object_id
1970: INTO
1971: l_maintenance_object_type
1972: ,l_maintenance_object_id
1973: FROM WIP_DISCRETE_JOBS
1974: WHERE wip_entity_id = l_eam_wo_comp_rec.wip_entity_id;
1975:
1976: --only if asset number/rebuild serial number exists for work order
1977: IF(l_maintenance_object_type =3) THEN

Line 2166: FROM WIP_DISCRETE_JOBS

2162: /* Code Added for bug#6053425 Start */
2163: ,l_prev_project_id
2164: ,l_prev_task_id
2165: /* Code Added for bug#6053425 End */
2166: FROM WIP_DISCRETE_JOBS
2167: where wip_entity_id = l_wip_entity_id;
2168:
2169: IF(l_asset_number is NOT NULL and l_eam_wo_rec.asset_number IS NULL) THEN
2170: l_eam_wo_rec.asset_number := FND_API.G_MISS_CHAR;

Line 2302: p_desc_flex_name => 'WIP_DISCRETE_JOBS',

2298:
2299: --Validate descriptive flexfield for workorder
2300: l_validate := EAM_COMMON_UTILITIES_PVT.validate_desc_flex_field(
2301: p_app_short_name => 'WIP',
2302: p_desc_flex_name => 'WIP_DISCRETE_JOBS',
2303: p_attribute_category => l_eam_wo_rec.attribute_category,
2304: p_attribute1 => l_eam_wo_rec.attribute1,
2305: p_attribute2 => l_eam_wo_rec.attribute2,
2306: p_attribute3 => l_eam_wo_rec.attribute3,