APPS.EAM_WO_VALIDATE_PVT dependencies on MFG_LOOKUPS

Line 269: mfg_lookups where lookup_type = g_obj_source

265: raise fnd_api.g_exc_error;
266: end if;
267:
268: select 1 into g_dummy from
269: mfg_lookups where lookup_type = g_obj_source
270: and lookup_code = p_eam_wo_rec.maintenance_object_source;
271:
272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273:

Line 327: mfg_lookups where lookup_type = g_obj_type

323: raise fnd_api.g_exc_error;
324: end if;
325:
326: select 1 into g_dummy from
327: mfg_lookups where lookup_type = g_obj_type
328: and lookup_code = p_eam_wo_rec.maintenance_object_type;
329:
330: x_return_status := FND_API.G_RET_STS_SUCCESS;
331:

Line 749: from mfg_lookups

745: if (p_eam_wo_rec.maintenance_object_type is not null) then
746:
747: select 1
748: into g_dummy
749: from mfg_lookups
750: where lookup_type = g_obj_type
751: and lookup_code = p_eam_wo_rec.maintenance_object_type;
752:
753: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2705: from mfg_lookups

2701: begin
2702: if p_eam_wo_rec.shutdown_type is not null then
2703: select 1
2704: into g_dummy
2705: from mfg_lookups
2706: where lookup_type = g_shutdown_type
2707: and lookup_code = p_eam_wo_rec.shutdown_type
2708: and enabled_flag = 'Y';
2709: end if;

Line 2805: from mfg_lookups

2801: begin
2802: if p_eam_wo_rec.work_order_type is not null then
2803: select 1
2804: into g_dummy
2805: from mfg_lookups
2806: where lookup_type = g_wo_type
2807: and lookup_code = p_eam_wo_rec.work_order_type
2808: and enabled_flag = 'Y';
2809: end if;

Line 2841: from mfg_lookups

2837: begin
2838: if p_eam_wo_rec.activity_type is not null then
2839: select 1
2840: into g_dummy
2841: from mfg_lookups
2842: where lookup_type = g_act_type
2843: and lookup_code = p_eam_wo_rec.activity_type
2844: and enabled_flag = 'Y';
2845: end if;

Line 2877: from mfg_lookups

2873: begin
2874: if p_eam_wo_rec.activity_cause is not null then
2875: select 1
2876: into g_dummy
2877: from mfg_lookups
2878: where lookup_type = g_act_cause
2879: and lookup_code = p_eam_wo_rec.activity_cause
2880: and enabled_flag = 'Y';
2881: end if;

Line 2915: from mfg_lookups

2911: begin
2912: if p_eam_wo_rec.activity_source is not null then
2913: select 1
2914: into g_dummy
2915: from mfg_lookups
2916: where lookup_type = g_act_source
2917: and lookup_code = p_eam_wo_rec.activity_source
2918: and enabled_flag = 'Y';
2919: end if;

Line 3024: from mfg_lookups

3020: if (p_eam_wo_rec.maintenance_object_source is not null) then
3021:
3022: select 1
3023: into g_dummy
3024: from mfg_lookups
3025: where lookup_type = g_obj_source
3026: and lookup_code = p_eam_wo_rec.maintenance_object_source;
3027:
3028: x_return_status := FND_API.G_RET_STS_SUCCESS;