APPS.GME_API_GRP dependencies on MTL_RESERVATIONS

Line 983: l_rsv_rec mtl_reservations%ROWTYPE;

979: IS
980: l_api_name CONSTANT VARCHAR2 (30) := 'Is_reservation_fully_specified';
981: l_reservation_type NUMBER := 0;
982: l_item_rec mtl_system_items_b%ROWTYPE;
983: l_rsv_rec mtl_reservations%ROWTYPE;
984: l_rsv_type NUMBER;
985: l_msg_count NUMBER;
986: l_msg_list VARCHAR2(32767);
987: l_return_status VARCHAR2 (10);

Line 994: FROM mtl_reservations

990:
991: CURSOR cur_rsv_rec (v_reservation_id NUMBER)
992: IS
993: SELECT *
994: FROM mtl_reservations
995: WHERE reservation_id = v_reservation_id;
996:
997: CURSOR cur_fetch_item (v_org_id NUMBER, v_inventory_item_id NUMBER)
998: IS

Line 1018: ,'MTL_RESERVATIONS');

1014: CLOSE cur_rsv_rec;
1015:
1016: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1017: ,'TABLE_NAME'
1018: ,'MTL_RESERVATIONS');
1019:
1020: IF g_debug <= gme_debug.g_log_statement THEN
1021: gme_debug.put_line
1022: ( g_pkg_name

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

1021: gme_debug.put_line
1022: ( g_pkg_name
1023: || '.'
1024: || l_api_name
1025: || ' Retrieval failure against mtl_reservations using id of '
1026: || p_reservation_id);
1027: END IF;
1028:
1029: RAISE fetch_error;

Line 2444: FROM mtl_reservations mr

2440: END IF;
2441: x_return_status := FND_API.G_RET_STS_SUCCESS;
2442: OPEN x_resvns_cur FOR
2443: SELECT mr.*
2444: FROM mtl_reservations mr
2445: WHERE mr.organization_id = p_organization_id
2446: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
2447: AND mr.demand_source_header_id = p_batch_id
2448: AND mr.demand_source_line_id = p_mat_det_id