APPS.GME_API_PUB dependencies on DUAL

Line 241: FROM DUAL

237:
238: CURSOR cur_validate_uom (v_uom_code VARCHAR2)
239: IS
240: SELECT 1
241: FROM DUAL
242: WHERE EXISTS (SELECT 1
243: FROM mtl_units_of_measure
244: WHERE uom_code = v_uom_code);
245: BEGIN

Line 3156: FROM DUAL

3152: ,l_oprn_vers NUMBER
3153: ,l_org_id NUMBER)
3154: IS
3155: SELECT 1
3156: FROM DUAL
3157: WHERE EXISTS (
3158: SELECT 1
3159: FROM gmd_operations_b
3160: WHERE oprn_no = l_oprn_no

Line 3512: --validate individual fields

3508: ELSE
3509: gme_common_pvt.g_flex_validate_prof := 0;
3510: END IF;
3511:
3512: --validate individual fields
3513: gme_material_detail_pvt.validate_material_for_ins (
3514: p_batch_header_rec => l_batch_header_rec
3515: ,p_material_detail_rec => l_material_detail_rec
3516: ,p_batch_step_rec => l_batch_step_rec

Line 5275: IF (l_item_rec.dual_uom_control in (3, 4)) THEN

5271: */
5272:
5273: l_check_deviation := 0;
5274: -- Let's check deviations if necessary.
5275: IF (l_item_rec.dual_uom_control in (3, 4)) THEN
5276: l_check_deviation := 1;
5277: END IF;
5278:
5279: IF (g_debug = gme_debug.g_log_statement) THEN