eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_IRK_PVT dependencies on OKX_COUNTRIES_V

Line 750: CURSOR okx_countries_v_pk_csr IS

746: p_irkv_rec IN irkv_rec_type,
747: p_db_irkv_rec IN irkv_rec_type
748: ) RETURN VARCHAR2 IS
749: item_not_found_error EXCEPTION;
750: CURSOR okx_countries_v_pk_csr IS
751: SELECT 'x'
752: FROM OKX_COUNTRIES_V
753: WHERE id1 = p_irkv_rec.ic_code;
754: CURSOR okx_insurer_v_pk_csr (p_isu_id IN NUMBER) IS

Line 752: FROM OKX_COUNTRIES_V

748: ) RETURN VARCHAR2 IS
749: item_not_found_error EXCEPTION;
750: CURSOR okx_countries_v_pk_csr IS
751: SELECT 'x'
752: FROM OKX_COUNTRIES_V
753: WHERE id1 = p_irkv_rec.ic_code;
754: CURSOR okx_insurer_v_pk_csr (p_isu_id IN NUMBER) IS
755: SELECT 'x'
756: FROM OKX_INS_PROVIDER_V

Line 789: OPEN okx_countries_v_pk_csr;

785: -------------------------------------------------------------------------------------------------------------
786: -- Validation for IC_CODE
787: IF ((p_irkv_rec.IC_CODE IS NOT NULL) AND (p_irkv_rec.IC_CODE <> p_db_irkv_rec.IC_CODE)) THEN
788: -- enforce foreign key
789: OPEN okx_countries_v_pk_csr;
790: FETCH okx_countries_v_pk_csr INTO l_dummy_var;
791: CLOSE okx_countries_v_pk_csr;
792: -- if l_dummy_var is still set to default ,data was not found
793: IF (l_dummy_var ='?') THEN

Line 790: FETCH okx_countries_v_pk_csr INTO l_dummy_var;

786: -- Validation for IC_CODE
787: IF ((p_irkv_rec.IC_CODE IS NOT NULL) AND (p_irkv_rec.IC_CODE <> p_db_irkv_rec.IC_CODE)) THEN
788: -- enforce foreign key
789: OPEN okx_countries_v_pk_csr;
790: FETCH okx_countries_v_pk_csr INTO l_dummy_var;
791: CLOSE okx_countries_v_pk_csr;
792: -- if l_dummy_var is still set to default ,data was not found
793: IF (l_dummy_var ='?') THEN
794: OKC_API.set_message(p_app_name => G_APP_NAME,

Line 791: CLOSE okx_countries_v_pk_csr;

787: IF ((p_irkv_rec.IC_CODE IS NOT NULL) AND (p_irkv_rec.IC_CODE <> p_db_irkv_rec.IC_CODE)) THEN
788: -- enforce foreign key
789: OPEN okx_countries_v_pk_csr;
790: FETCH okx_countries_v_pk_csr INTO l_dummy_var;
791: CLOSE okx_countries_v_pk_csr;
792: -- if l_dummy_var is still set to default ,data was not found
793: IF (l_dummy_var ='?') THEN
794: OKC_API.set_message(p_app_name => G_APP_NAME,
795: p_msg_name => G_NO_PARENT_RECORD,

Line 799: p_token2_value => 'OKX_COUNTRIES_V',

795: p_msg_name => G_NO_PARENT_RECORD,
796: p_token1 => G_COL_NAME_TOKEN,
797: p_token1_value => 'Country',
798: p_token2 => g_parent_table_token,
799: p_token2_value => 'OKX_COUNTRIES_V',
800: p_token3 => g_child_table_token,
801: p_token3_value => 'OKL_INSURER_RANKINGS');
802: -- notify caller of an error
803: l_return_status := OKC_API.G_RET_STS_ERROR;