APPS.EAM_WO_VALIDATE_PVT dependencies on MFG_LOOKUPS

Line 303: mfg_lookups where lookup_type = g_obj_source

299: raise fnd_api.g_exc_error;
300: end if;
301:
302: select 1 into g_dummy from
303: mfg_lookups where lookup_type = g_obj_source
304: and lookup_code = p_eam_wo_rec.maintenance_object_source;
305:
306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307:

Line 361: mfg_lookups where lookup_type = g_obj_type

357: raise fnd_api.g_exc_error;
358: end if;
359:
360: select 1 into g_dummy from
361: mfg_lookups where lookup_type = g_obj_type
362: and lookup_code = p_eam_wo_rec.maintenance_object_type;
363:
364: x_return_status := FND_API.G_RET_STS_SUCCESS;
365:

Line 815: from mfg_lookups

811: if (p_eam_wo_rec.maintenance_object_type is not null) then
812:
813: select 1
814: into g_dummy
815: from mfg_lookups
816: where lookup_type = g_obj_type
817: and lookup_code = p_eam_wo_rec.maintenance_object_type;
818:
819: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2785: from mfg_lookups

2781: begin
2782: if p_eam_wo_rec.shutdown_type is not null then
2783: select 1
2784: into g_dummy
2785: from mfg_lookups
2786: where lookup_type = g_shutdown_type
2787: and lookup_code = p_eam_wo_rec.shutdown_type
2788: and enabled_flag = 'Y';
2789: end if;

Line 2885: from mfg_lookups

2881: begin
2882: if p_eam_wo_rec.work_order_type is not null then
2883: select 1
2884: into g_dummy
2885: from mfg_lookups
2886: where lookup_type = g_wo_type
2887: and lookup_code = p_eam_wo_rec.work_order_type
2888: and enabled_flag = 'Y';
2889: end if;

Line 2921: from mfg_lookups

2917: begin
2918: if p_eam_wo_rec.activity_type is not null then
2919: select 1
2920: into g_dummy
2921: from mfg_lookups
2922: where lookup_type = g_act_type
2923: and lookup_code = p_eam_wo_rec.activity_type
2924: and enabled_flag = 'Y';
2925: end if;

Line 2957: from mfg_lookups

2953: begin
2954: if p_eam_wo_rec.activity_cause is not null then
2955: select 1
2956: into g_dummy
2957: from mfg_lookups
2958: where lookup_type = g_act_cause
2959: and lookup_code = p_eam_wo_rec.activity_cause
2960: and enabled_flag = 'Y';
2961: end if;

Line 2995: from mfg_lookups

2991: begin
2992: if p_eam_wo_rec.activity_source is not null then
2993: select 1
2994: into g_dummy
2995: from mfg_lookups
2996: where lookup_type = g_act_source
2997: and lookup_code = p_eam_wo_rec.activity_source
2998: and enabled_flag = 'Y';
2999: end if;

Line 3104: from mfg_lookups

3100: if (p_eam_wo_rec.maintenance_object_source is not null) then
3101:
3102: select 1
3103: into g_dummy
3104: from mfg_lookups
3105: where lookup_type = g_obj_source
3106: and lookup_code = p_eam_wo_rec.maintenance_object_source;
3107:
3108: x_return_status := FND_API.G_RET_STS_SUCCESS;