APPS.GME_API_GRP dependencies on MTL_RESERVATIONS

Line 959: l_rsv_rec mtl_reservations%ROWTYPE;

955: IS
956: l_api_name CONSTANT VARCHAR2 (30) := 'Is_reservation_fully_specified';
957: l_reservation_type NUMBER := 0;
958: l_item_rec mtl_system_items_b%ROWTYPE;
959: l_rsv_rec mtl_reservations%ROWTYPE;
960: l_rsv_type NUMBER;
961: l_msg_count NUMBER;
962: l_msg_list VARCHAR2(32767);
963: l_return_status VARCHAR2 (10);

Line 970: FROM mtl_reservations

966:
967: CURSOR cur_rsv_rec (v_reservation_id NUMBER)
968: IS
969: SELECT *
970: FROM mtl_reservations
971: WHERE reservation_id = v_reservation_id;
972:
973: CURSOR cur_fetch_item (v_org_id NUMBER, v_inventory_item_id NUMBER)
974: IS

Line 994: ,'MTL_RESERVATIONS');

990: CLOSE cur_rsv_rec;
991:
992: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
993: ,'TABLE_NAME'
994: ,'MTL_RESERVATIONS');
995:
996: IF g_debug <= gme_debug.g_log_statement THEN
997: gme_debug.put_line
998: ( g_pkg_name

Line 1001: || ' Retrieval failure against mtl_reservations using id of '

997: gme_debug.put_line
998: ( g_pkg_name
999: || '.'
1000: || l_api_name
1001: || ' Retrieval failure against mtl_reservations using id of '
1002: || p_reservation_id);
1003: END IF;
1004:
1005: RAISE fetch_error;

Line 2359: FROM mtl_reservations mr

2355: END IF;
2356: x_return_status := FND_API.G_RET_STS_SUCCESS;
2357: OPEN x_resvns_cur FOR
2358: SELECT mr.*
2359: FROM mtl_reservations mr
2360: WHERE mr.organization_id = p_organization_id
2361: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
2362: AND mr.demand_source_header_id = p_batch_id
2363: AND mr.demand_source_line_id = p_mat_det_id