APPS.OKL_IPY_PVT dependencies on FND_TERRITORIES_VL

Line 1012: FROM FND_TERRITORIES_VL

1008: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1009: -- select the ID of the parent record from the parent table
1010: CURSOR l_terr_csr IS
1011: SELECT 'x'
1012: FROM FND_TERRITORIES_VL
1013: WHERE territory_code = p_ipyv_rec.territory_code;
1014: BEGIN
1015: --data is required
1016: IF (p_ipyv_rec.territory_code = OKC_API.G_MISS_CHAR) THEN

Line 1028: OKC_API.set_message(G_APP_NAME,G_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'Territory Code',g_child_table_token,'OKL_INS_POLICIES_V',g_parent_table_token,'FND_TERRITORIES_VL');

1024: FETCH l_terr_csr INTO l_dummy_var ;
1025: CLOSE l_terr_csr ;
1026: -- if l_dummy_var is still set to default ,data was not found
1027: IF (l_dummy_var ='?') THEN
1028: OKC_API.set_message(G_APP_NAME,G_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'Territory Code',g_child_table_token,'OKL_INS_POLICIES_V',g_parent_table_token,'FND_TERRITORIES_VL');
1029: --notify caller of an error
1030: x_return_status := OKC_API.G_RET_STS_ERROR;
1031: END IF;
1032: EXCEPTION