APPS.GME_COMMON_PVT dependencies on GME_EXCEPTIONS_GTMP

Line 2570: l_exception_rec gme_exceptions_gtmp%ROWTYPE;

2566: l_mtl_dtl_rec gme_material_details%ROWTYPE;
2567: --FPbug#4912179
2568: --l_item_rec mtl_system_items_kfv%ROWTYPE;
2569: l_item_rec cur_get_item%ROWTYPE;
2570: l_exception_rec gme_exceptions_gtmp%ROWTYPE;
2571: setup_failure EXCEPTION;
2572: get_open_qty_err EXCEPTION;
2573: uom_conv_error EXCEPTION;
2574: exception_ins_err EXCEPTION;

Line 2608: DELETE FROM gme_exceptions_gtmp;

2604: END IF;
2605: END IF;
2606:
2607: /* Bug 5256543 If get shortages is called multiple times then records have to be cleared */
2608: DELETE FROM gme_exceptions_gtmp;
2609:
2610: OPEN cur_get_materials;
2611: LOOP
2612: /* Bug 5512352 l_exception_rec needs to reset for each material */

Line 3320: FUNCTION insert_exceptions (p_exception_rec IN gme_exceptions_gtmp%ROWTYPE)

3316: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3317: x_return_status := fnd_api.g_ret_sts_unexp_error;
3318: END get_open_qty;
3319:
3320: FUNCTION insert_exceptions (p_exception_rec IN gme_exceptions_gtmp%ROWTYPE)
3321: RETURN BOOLEAN
3322: IS
3323: l_api_name CONSTANT VARCHAR2 (30) := 'insert_exceptions';
3324: BEGIN

Line 3331: INSERT INTO gme_exceptions_gtmp

3327: || l_api_name);
3328: END IF;
3329:
3330: -- Bug 9666304 - NVL on att variable.
3331: INSERT INTO gme_exceptions_gtmp
3332: (organization_id
3333: ,pending_move_order_ind
3334: ,pending_reservations_ind
3335: ,onhand_qty, att