APPS.GME_POST_MIGRATION dependencies on IC_LOCT_MST

Line 2044: CURSOR Cur_ic_loct_mst IS

2040: p_whse_code IN VARCHAR2,
2041: x_organization_id OUT NOCOPY NUMBER,
2042: x_locator_id OUT NOCOPY NUMBER,
2043: x_subinventory OUT NOCOPY VARCHAR2) IS
2044: CURSOR Cur_ic_loct_mst IS
2045: SELECT i.locator_id, m.organization_id, m.subinventory_code
2046: FROM ic_loct_mst i, mtl_item_locations m
2047: WHERE i.location = p_location
2048: AND i.whse_code = p_whse_code

Line 2046: FROM ic_loct_mst i, mtl_item_locations m

2042: x_locator_id OUT NOCOPY NUMBER,
2043: x_subinventory OUT NOCOPY VARCHAR2) IS
2044: CURSOR Cur_ic_loct_mst IS
2045: SELECT i.locator_id, m.organization_id, m.subinventory_code
2046: FROM ic_loct_mst i, mtl_item_locations m
2047: WHERE i.location = p_location
2048: AND i.whse_code = p_whse_code
2049: AND m.inventory_location_id = i.locator_id;
2050: CURSOR Cur_mtl_locs IS

Line 2066: OPEN Cur_ic_loct_mst;

2062: EXCEPTION
2063: WHEN NO_DATA_FOUND THEN
2064: NULL;
2065: END;
2066: OPEN Cur_ic_loct_mst;
2067: FETCH Cur_ic_loct_mst INTO x_locator_id, x_organization_id, x_subinventory;
2068: IF (Cur_ic_loct_mst%NOTFOUND) THEN
2069: get_subinventory(p_whse_code => p_whse_code,
2070: x_subinventory => x_subinventory,

Line 2067: FETCH Cur_ic_loct_mst INTO x_locator_id, x_organization_id, x_subinventory;

2063: WHEN NO_DATA_FOUND THEN
2064: NULL;
2065: END;
2066: OPEN Cur_ic_loct_mst;
2067: FETCH Cur_ic_loct_mst INTO x_locator_id, x_organization_id, x_subinventory;
2068: IF (Cur_ic_loct_mst%NOTFOUND) THEN
2069: get_subinventory(p_whse_code => p_whse_code,
2070: x_subinventory => x_subinventory,
2071: x_organization_id => x_organization_id);

Line 2068: IF (Cur_ic_loct_mst%NOTFOUND) THEN

2064: NULL;
2065: END;
2066: OPEN Cur_ic_loct_mst;
2067: FETCH Cur_ic_loct_mst INTO x_locator_id, x_organization_id, x_subinventory;
2068: IF (Cur_ic_loct_mst%NOTFOUND) THEN
2069: get_subinventory(p_whse_code => p_whse_code,
2070: x_subinventory => x_subinventory,
2071: x_organization_id => x_organization_id);
2072: OPEN Cur_mtl_locs;

Line 2076: CLOSE Cur_ic_loct_mst;

2072: OPEN Cur_mtl_locs;
2073: FETCH Cur_mtl_locs INTO x_locator_id, x_organization_id, x_subinventory;
2074: CLOSE Cur_mtl_locs;
2075: END IF;
2076: CLOSE Cur_ic_loct_mst;
2077: p_locator_tbl(p_whse_code||'**'||p_location).locator_id := x_locator_id;
2078: p_locator_tbl(p_whse_code||'**'||p_location).organization_id := x_organization_id;
2079: p_locator_tbl(p_whse_code||'**'||p_location).subinventory := x_subinventory;
2080: END get_locator;

Line 2119: FROM ic_loct_mst

2115: x_location_id OUT NOCOPY NUMBER,
2116: x_failure_count OUT NOCOPY NUMBER) IS
2117: CURSOR Cur_loc_details IS
2118: SELECT *
2119: FROM ic_loct_mst
2120: WHERE location = p_location;
2121: l_loc_rec ic_loct_mst%ROWTYPE;
2122: l_api_name VARCHAR2(30) := 'create_locator';
2123: BEGIN

Line 2121: l_loc_rec ic_loct_mst%ROWTYPE;

2117: CURSOR Cur_loc_details IS
2118: SELECT *
2119: FROM ic_loct_mst
2120: WHERE location = p_location;
2121: l_loc_rec ic_loct_mst%ROWTYPE;
2122: l_api_name VARCHAR2(30) := 'create_locator';
2123: BEGIN
2124: IF (g_debug <= gme_debug.g_log_procedure) THEN
2125: gme_debug.put_line('Start procedure '||l_api_name);