APPS.GME_POST_MIGRATION dependencies on IC_LOCT_MST

Line 1828: CURSOR Cur_ic_loct_mst IS

1824: p_whse_code IN VARCHAR2,
1825: x_organization_id OUT NOCOPY NUMBER,
1826: x_locator_id OUT NOCOPY NUMBER,
1827: x_subinventory OUT NOCOPY VARCHAR2) IS
1828: CURSOR Cur_ic_loct_mst IS
1829: SELECT i.locator_id, m.organization_id, m.subinventory_code
1830: FROM ic_loct_mst i, mtl_item_locations m
1831: WHERE i.location = p_location
1832: AND i.whse_code = p_whse_code

Line 1830: FROM ic_loct_mst i, mtl_item_locations m

1826: x_locator_id OUT NOCOPY NUMBER,
1827: x_subinventory OUT NOCOPY VARCHAR2) IS
1828: CURSOR Cur_ic_loct_mst IS
1829: SELECT i.locator_id, m.organization_id, m.subinventory_code
1830: FROM ic_loct_mst i, mtl_item_locations m
1831: WHERE i.location = p_location
1832: AND i.whse_code = p_whse_code
1833: AND m.inventory_location_id = i.locator_id;
1834: CURSOR Cur_mtl_locs IS

Line 1850: OPEN Cur_ic_loct_mst;

1846: EXCEPTION
1847: WHEN NO_DATA_FOUND THEN
1848: NULL;
1849: END;
1850: OPEN Cur_ic_loct_mst;
1851: FETCH Cur_ic_loct_mst INTO x_locator_id, x_organization_id, x_subinventory;
1852: IF (Cur_ic_loct_mst%NOTFOUND) THEN
1853: get_subinventory(p_whse_code => p_whse_code,
1854: x_subinventory => x_subinventory,

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

1847: WHEN NO_DATA_FOUND THEN
1848: NULL;
1849: END;
1850: OPEN Cur_ic_loct_mst;
1851: FETCH Cur_ic_loct_mst INTO x_locator_id, x_organization_id, x_subinventory;
1852: IF (Cur_ic_loct_mst%NOTFOUND) THEN
1853: get_subinventory(p_whse_code => p_whse_code,
1854: x_subinventory => x_subinventory,
1855: x_organization_id => x_organization_id);

Line 1852: IF (Cur_ic_loct_mst%NOTFOUND) THEN

1848: NULL;
1849: END;
1850: OPEN Cur_ic_loct_mst;
1851: FETCH Cur_ic_loct_mst INTO x_locator_id, x_organization_id, x_subinventory;
1852: IF (Cur_ic_loct_mst%NOTFOUND) THEN
1853: get_subinventory(p_whse_code => p_whse_code,
1854: x_subinventory => x_subinventory,
1855: x_organization_id => x_organization_id);
1856: OPEN Cur_mtl_locs;

Line 1860: CLOSE Cur_ic_loct_mst;

1856: OPEN Cur_mtl_locs;
1857: FETCH Cur_mtl_locs INTO x_locator_id, x_organization_id, x_subinventory;
1858: CLOSE Cur_mtl_locs;
1859: END IF;
1860: CLOSE Cur_ic_loct_mst;
1861: p_locator_tbl(p_whse_code||'**'||p_location).locator_id := x_locator_id;
1862: p_locator_tbl(p_whse_code||'**'||p_location).organization_id := x_organization_id;
1863: p_locator_tbl(p_whse_code||'**'||p_location).subinventory := x_subinventory;
1864: END get_locator;

Line 1903: FROM ic_loct_mst

1899: x_location_id OUT NOCOPY NUMBER,
1900: x_failure_count OUT NOCOPY NUMBER) IS
1901: CURSOR Cur_loc_details IS
1902: SELECT *
1903: FROM ic_loct_mst
1904: WHERE location = p_location;
1905: l_loc_rec ic_loct_mst%ROWTYPE;
1906: l_api_name VARCHAR2(30) := 'create_locator';
1907: BEGIN

Line 1905: l_loc_rec ic_loct_mst%ROWTYPE;

1901: CURSOR Cur_loc_details IS
1902: SELECT *
1903: FROM ic_loct_mst
1904: WHERE location = p_location;
1905: l_loc_rec ic_loct_mst%ROWTYPE;
1906: l_api_name VARCHAR2(30) := 'create_locator';
1907: BEGIN
1908: IF (g_debug <= gme_debug.g_log_procedure) THEN
1909: gme_debug.put_line('Start procedure '||l_api_name);