APPS.GME_COMMON_PVT dependencies on GME_EXCEPTIONS_GTMP

Line 2445: l_exception_rec gme_exceptions_gtmp%ROWTYPE;

2441: l_mtl_dtl_rec gme_material_details%ROWTYPE;
2442: --FPbug#4912179
2443: --l_item_rec mtl_system_items_kfv%ROWTYPE;
2444: l_item_rec cur_get_item%ROWTYPE;
2445: l_exception_rec gme_exceptions_gtmp%ROWTYPE;
2446: setup_failure EXCEPTION;
2447: get_open_qty_err EXCEPTION;
2448: uom_conv_error EXCEPTION;
2449: exception_ins_err EXCEPTION;

Line 2482: DELETE FROM gme_exceptions_gtmp;

2478: END IF;
2479: END IF;
2480:
2481: /* Bug 5256543 If get shortages is called multiple times then records have to be cleared */
2482: DELETE FROM gme_exceptions_gtmp;
2483:
2484: OPEN cur_get_materials;
2485: LOOP
2486: /* Bug 5512352 l_exception_rec needs to reset for each material */

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

3058: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3059: x_return_status := fnd_api.g_ret_sts_unexp_error;
3060: END get_open_qty;
3061:
3062: FUNCTION insert_exceptions (p_exception_rec IN gme_exceptions_gtmp%ROWTYPE)
3063: RETURN BOOLEAN
3064: IS
3065: l_api_name CONSTANT VARCHAR2 (30) := 'insert_exceptions';
3066: BEGIN

Line 3072: INSERT INTO gme_exceptions_gtmp

3068: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3069: || l_api_name);
3070: END IF;
3071:
3072: INSERT INTO gme_exceptions_gtmp
3073: (organization_id
3074: ,pending_move_order_ind
3075: ,pending_reservations_ind
3076: ,onhand_qty, att