DBA Data[Home] [Help]

APPS.GME_API_PUB dependencies on DUAL

Line 205: FROM DUAL

201:
202: CURSOR cur_validate_uom (v_uom_code VARCHAR2)
203: IS
204: SELECT 1
205: FROM DUAL
206: WHERE EXISTS (SELECT 1
207: FROM mtl_units_of_measure
208: WHERE uom_code = v_uom_code);
209: BEGIN

Line 3079: FROM DUAL

3075: ,l_oprn_vers NUMBER
3076: ,l_org_id NUMBER)
3077: IS
3078: SELECT 1
3079: FROM DUAL
3080: WHERE EXISTS (
3081: SELECT 1
3082: FROM gmd_operations_b
3083: WHERE oprn_no = l_oprn_no

Line 3425: --validate individual fields

3421: ELSE
3422: gme_common_pvt.g_flex_validate_prof := 0;
3423: END IF;
3424:
3425: --validate individual fields
3426: gme_material_detail_pvt.validate_material_for_ins (
3427: p_batch_header_rec => l_batch_header_rec
3428: ,p_material_detail_rec => l_material_detail_rec
3429: ,p_batch_step_rec => l_batch_step_rec