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 OKL_INSURER_RANKINGS_V

Line 94: -- FUNCTION get_rec for: OKL_INSURER_RANKINGS_V

90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_INSURER_RANKINGS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_irkv_rec IN irkv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 130: FROM Okl_Insurer_Rankings_V

126: CREATION_DATE,
127: LAST_UPDATED_BY,
128: LAST_UPDATE_DATE,
129: LAST_UPDATE_LOGIN
130: FROM Okl_Insurer_Rankings_V
131: WHERE okl_insurer_rankings_v.id = p_id;
132: l_okl_irkv_pk okl_irkv_pk_csr%ROWTYPE;
133: l_irkv_rec irkv_rec_type;
134: BEGIN

Line 131: WHERE okl_insurer_rankings_v.id = p_id;

127: LAST_UPDATED_BY,
128: LAST_UPDATE_DATE,
129: LAST_UPDATE_LOGIN
130: FROM Okl_Insurer_Rankings_V
131: WHERE okl_insurer_rankings_v.id = p_id;
132: l_okl_irkv_pk okl_irkv_pk_csr%ROWTYPE;
133: l_irkv_rec irkv_rec_type;
134: BEGIN
135: x_no_data_found := TRUE;

Line 308: -- FUNCTION null_out_defaults for: OKL_INSURER_RANKINGS_V

304: BEGIN
305: RETURN(get_rec(p_irk_rec, l_row_not_found));
306: END get_rec;
307: ---------------------------------------------------------------------------
308: -- FUNCTION null_out_defaults for: OKL_INSURER_RANKINGS_V
309: ---------------------------------------------------------------------------
310: FUNCTION null_out_defaults (
311: p_irkv_rec IN irkv_rec_type
312: ) RETURN irkv_rec_type IS

Line 418: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'

414: RAISE G_EXCEPTION_HALT_VALIDATION;
415: END IF;
416:
417: -- Verify the value fits the length of the column in the database
418: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'
419: ,p_col_name => 'id'
420: ,p_col_value => p_id
421: ,x_return_status => x_return_status);
422: -- verify that length is within allowed limits

Line 456: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'

452: RAISE G_EXCEPTION_HALT_VALIDATION;
453: END IF;
454:
455: -- Verify the value fits the length of the column in the database
456: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'
457: ,p_col_name => 'ranking_seq'
458: ,p_col_value => p_ranking_seq
459: ,x_return_status => x_return_status);
460: -- verify that length is within allowed limits

Line 494: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'

490: RAISE G_EXCEPTION_HALT_VALIDATION;
491: END IF;
492:
493: -- Verify the value fits the length of the column in the database
494: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'
495: ,p_col_name => 'object_version_number'
496: ,p_col_value => p_object_version_number
497: ,x_return_status => x_return_status);
498: -- verify that length is within allowed limits

Line 583: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'

579: RAISE G_EXCEPTION_HALT_VALIDATION;
580: END IF;
581:
582: -- Verify the value fits the length of the column in the database
583: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'
584: ,p_col_name => 'isu_id'
585: ,p_col_value => p_isu_id
586: ,x_return_status => x_return_status);
587: -- verify that length is within allowed limits

Line 623: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'

619:
620: /*
621:
622: -- Verify the value fits the length of the column in the database
623: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'
624: ,p_col_name => 'ic_code'
625: ,p_col_value => p_ic_code
626: ,x_return_status => x_return_status);
627: -- verify that length is within allowed limits

Line 650: -- Validate_Attributes for:OKL_INSURER_RANKINGS_V --

646: ---------------------------------------------------------------------------
647: -- FUNCTION Validate_Attributes
648: ---------------------------------------------------------------------------
649: ----------------------------------------------------
650: -- Validate_Attributes for:OKL_INSURER_RANKINGS_V --
651: ----------------------------------------------------
652: FUNCTION Validate_Attributes (
653: p_irkv_rec IN irkv_rec_type
654: ) RETURN VARCHAR2 IS

Line 659: OKC_UTIL.ADD_VIEW('OKL_INSURER_RANKINGS_V', x_return_status);

655: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
656: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
657: BEGIN
658: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
659: OKC_UTIL.ADD_VIEW('OKL_INSURER_RANKINGS_V', x_return_status);
660: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
661: l_return_status := x_return_status;
662: RAISE G_EXCEPTION_HALT_VALIDATION;
663: END IF;

Line 739: -- Validate Record for:OKL_INSURER_RANKINGS_V --

735: ---------------------------------------------------------------------------
736: -- PROCEDURE Validate_Record
737: ---------------------------------------------------------------------------
738: ------------------------------------------------
739: -- Validate Record for:OKL_INSURER_RANKINGS_V --
740: ------------------------------------------------
741:
742: ------------------------------------
743: -- FUNCTION validate_foreign_keys --

Line 759: CURSOR okl_insurer_rankings_v_pk_csr IS

755: SELECT 'x'
756: FROM OKX_INS_PROVIDER_V
757: WHERE OKX_INS_PROVIDER_V.PARTY_ID = p_isu_id;
758:
759: CURSOR okl_insurer_rankings_v_pk_csr IS
760: SELECT 'x'
761: FROM okl_insurer_rankings
762: WHERE okl_insurer_rankings.id <> p_irkv_rec.id
763: and okl_insurer_rankings.ic_code = p_irkv_rec.ic_code

Line 832: OPEN okl_insurer_rankings_v_pk_csr;

828: END IF;
829: ---------------------------------------------------------------------------------
830: --
831: l_dummy_var := '?' ;
832: OPEN okl_insurer_rankings_v_pk_csr;
833: FETCH okl_insurer_rankings_v_pk_csr INTO l_dummy_var;
834: CLOSE okl_insurer_rankings_v_pk_csr;
835: -- if l_dummy_var is still set to default ,data was not found
836: IF (l_dummy_var ='x') THEN

Line 833: FETCH okl_insurer_rankings_v_pk_csr INTO l_dummy_var;

829: ---------------------------------------------------------------------------------
830: --
831: l_dummy_var := '?' ;
832: OPEN okl_insurer_rankings_v_pk_csr;
833: FETCH okl_insurer_rankings_v_pk_csr INTO l_dummy_var;
834: CLOSE okl_insurer_rankings_v_pk_csr;
835: -- if l_dummy_var is still set to default ,data was not found
836: IF (l_dummy_var ='x') THEN
837: OKC_API.set_message(p_app_name => G_APP_NAME,

Line 834: CLOSE okl_insurer_rankings_v_pk_csr;

830: --
831: l_dummy_var := '?' ;
832: OPEN okl_insurer_rankings_v_pk_csr;
833: FETCH okl_insurer_rankings_v_pk_csr INTO l_dummy_var;
834: CLOSE okl_insurer_rankings_v_pk_csr;
835: -- if l_dummy_var is still set to default ,data was not found
836: IF (l_dummy_var ='x') THEN
837: OKC_API.set_message(p_app_name => G_APP_NAME,
838: p_msg_name => 'OKL_INS_RANK_UNIQUE'

Line 864: -- Validate Record for:OKL_INSURER_RANKINGS_V --

860: END validate_foreign_keys;
861:
862:
863: ------------------------------------------------
864: -- Validate Record for:OKL_INSURER_RANKINGS_V --
865: ------------------------------------------------
866: FUNCTION Validate_Record (
867: p_irkv_rec IN irkv_rec_type,
868: p_db_irkv_rec IN irkv_rec_type

Line 1009: -- validate_row for:OKL_INSURER_RANKINGS_V --

1005: ---------------------------------------------------------------------------
1006: -- PROCEDURE validate_row
1007: ---------------------------------------------------------------------------
1008: ---------------------------------------------
1009: -- validate_row for:OKL_INSURER_RANKINGS_V --
1010: ---------------------------------------------
1011: PROCEDURE validate_row(
1012: p_api_version IN NUMBER,
1013: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1086: -- PL/SQL TBL validate_row for:OKL_INSURER_RANKINGS_V --

1082: '_PVT'
1083: );
1084: END validate_row;
1085: --------------------------------------------------------
1086: -- PL/SQL TBL validate_row for:OKL_INSURER_RANKINGS_V --
1087: --------------------------------------------------------
1088: PROCEDURE validate_row(
1089: p_api_version IN NUMBER,
1090: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1182: -- PL/SQL TBL validate_row for:OKL_INSURER_RANKINGS_V --

1178: );
1179: END validate_row;
1180:
1181: --------------------------------------------------------
1182: -- PL/SQL TBL validate_row for:OKL_INSURER_RANKINGS_V --
1183: --------------------------------------------------------
1184: PROCEDURE validate_row(
1185: p_api_version IN NUMBER,
1186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1389: -- insert_row for :OKL_INSURER_RANKINGS_V --

1385: '_PVT'
1386: );
1387: END insert_row;
1388: --------------------------------------------
1389: -- insert_row for :OKL_INSURER_RANKINGS_V --
1390: --------------------------------------------
1391: PROCEDURE insert_row(
1392: p_api_version IN NUMBER,
1393: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1423: -- Set_Attributes for:OKL_INSURER_RANKINGS_V --

1419: l_irkv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1420: RETURN(l_irkv_rec);
1421: END fill_who_columns;
1422: -----------------------------------------------
1423: -- Set_Attributes for:OKL_INSURER_RANKINGS_V --
1424: -----------------------------------------------
1425: FUNCTION Set_Attributes (
1426: p_irkv_rec IN irkv_rec_type,
1427: x_irkv_rec OUT NOCOPY irkv_rec_type

Line 1806: -- lock_row for: OKL_INSURER_RANKINGS_V --

1802: '_PVT'
1803: );
1804: END lock_row;
1805: ------------------------------------------
1806: -- lock_row for: OKL_INSURER_RANKINGS_V --
1807: ------------------------------------------
1808: PROCEDURE lock_row(
1809: p_api_version IN NUMBER,
1810: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2297: -- update_row for:OKL_INSURER_RANKINGS_V --

2293: '_PVT'
2294: );
2295: END update_row;
2296: -------------------------------------------
2297: -- update_row for:OKL_INSURER_RANKINGS_V --
2298: -------------------------------------------
2299: PROCEDURE update_row(
2300: p_api_version IN NUMBER,
2301: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2458: -- Set_Attributes for:OKL_INSURER_RANKINGS_V --

2454: END IF;
2455: RETURN(l_return_status);
2456: END populate_new_record;
2457: -----------------------------------------------
2458: -- Set_Attributes for:OKL_INSURER_RANKINGS_V --
2459: -----------------------------------------------
2460: FUNCTION Set_Attributes (
2461: p_irkv_rec IN irkv_rec_type,
2462: x_irkv_rec OUT NOCOPY irkv_rec_type

Line 2818: -- delete_row for:OKL_INSURER_RANKINGS_V --

2814: '_PVT'
2815: );
2816: END delete_row;
2817: -------------------------------------------
2818: -- delete_row for:OKL_INSURER_RANKINGS_V --
2819: -------------------------------------------
2820: PROCEDURE delete_row(
2821: p_api_version IN NUMBER,
2822: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2900: -- PL/SQL TBL delete_row for:OKL_INSURER_RANKINGS_V --

2896: '_PVT'
2897: );
2898: END delete_row;
2899: ------------------------------------------------------
2900: -- PL/SQL TBL delete_row for:OKL_INSURER_RANKINGS_V --
2901: ------------------------------------------------------
2902: PROCEDURE delete_row(
2903: p_api_version IN NUMBER,
2904: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2996: -- PL/SQL TBL delete_row for:OKL_INSURER_RANKINGS_V --

2992: );
2993: END delete_row;
2994:
2995: ------------------------------------------------------
2996: -- PL/SQL TBL delete_row for:OKL_INSURER_RANKINGS_V --
2997: ------------------------------------------------------
2998: PROCEDURE delete_row(
2999: p_api_version IN NUMBER,
3000: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,