604: l_okc_phlbv_okcklv_fk okc_phlbv_okcklv_fk_csr%ROWTYPE;
605:
606: CURSOR okc_phlbv_hrlav_fk_csr (p_ship_to_location_id IN NUMBER) IS
607: SELECT 'x'
608: FROM Hr_Locations_All_V
609: WHERE hr_locations_all_v.ship_to_location_id = p_ship_to_location_id;
610: l_okc_phlbv_hrlav_fk okc_phlbv_hrlav_fk_csr%ROWTYPE;
611:
612: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
605:
606: CURSOR okc_phlbv_hrlav_fk_csr (p_ship_to_location_id IN NUMBER) IS
607: SELECT 'x'
608: FROM Hr_Locations_All_V
609: WHERE hr_locations_all_v.ship_to_location_id = p_ship_to_location_id;
610: l_okc_phlbv_hrlav_fk okc_phlbv_hrlav_fk_csr%ROWTYPE;
611:
612: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
613: l_row_notfound BOOLEAN := TRUE;