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

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 201: -- FUNCTION get_rec for: OKL_INSURER_RANKINGS

197: BEGIN
198: RETURN(get_rec(p_irkv_rec, l_row_not_found));
199: END get_rec;
200: ---------------------------------------------------------------------------
201: -- FUNCTION get_rec for: OKL_INSURER_RANKINGS
202: ---------------------------------------------------------------------------
203: FUNCTION get_rec (
204: p_irk_rec IN irk_rec_type,
205: x_no_data_found OUT NOCOPY BOOLEAN

Line 237: FROM Okl_Insurer_Rankings

233: CREATION_DATE,
234: LAST_UPDATED_BY,
235: LAST_UPDATE_DATE,
236: LAST_UPDATE_LOGIN
237: FROM Okl_Insurer_Rankings
238: WHERE okl_insurer_rankings.id = p_id;
239: l_okl_irk_pk okl_irk_pk_csr%ROWTYPE;
240: l_irk_rec irk_rec_type;
241: BEGIN

Line 238: WHERE okl_insurer_rankings.id = p_id;

234: LAST_UPDATED_BY,
235: LAST_UPDATE_DATE,
236: LAST_UPDATE_LOGIN
237: FROM Okl_Insurer_Rankings
238: WHERE okl_insurer_rankings.id = p_id;
239: l_okl_irk_pk okl_irk_pk_csr%ROWTYPE;
240: l_irk_rec irk_rec_type;
241: BEGIN
242: 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 761: FROM okl_insurer_rankings

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
764: AND okl_insurer_rankings.RANKING_SEQ = p_irkv_rec.RANKING_SEQ
765: And okl_insurer_rankings.date_from <= p_irkv_rec.date_from

Line 762: WHERE okl_insurer_rankings.id <> p_irkv_rec.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
764: AND okl_insurer_rankings.RANKING_SEQ = p_irkv_rec.RANKING_SEQ
765: And okl_insurer_rankings.date_from <= p_irkv_rec.date_from
766: AND ( p_irkv_rec.date_from <= nvl(okl_insurer_rankings.date_to,p_irkv_rec.date_from)) ;

Line 763: and okl_insurer_rankings.ic_code = p_irkv_rec.ic_code

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
764: AND okl_insurer_rankings.RANKING_SEQ = p_irkv_rec.RANKING_SEQ
765: And okl_insurer_rankings.date_from <= p_irkv_rec.date_from
766: AND ( p_irkv_rec.date_from <= nvl(okl_insurer_rankings.date_to,p_irkv_rec.date_from)) ;
767:

Line 764: AND okl_insurer_rankings.RANKING_SEQ = p_irkv_rec.RANKING_SEQ

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
764: AND okl_insurer_rankings.RANKING_SEQ = p_irkv_rec.RANKING_SEQ
765: And okl_insurer_rankings.date_from <= p_irkv_rec.date_from
766: AND ( p_irkv_rec.date_from <= nvl(okl_insurer_rankings.date_to,p_irkv_rec.date_from)) ;
767:
768: --AND p_irkv_rec.date_from between okl_insurer_rankings.date_from and nvl(okl_insurer_rankings.date_to,SYSDATE) ;

Line 765: And okl_insurer_rankings.date_from <= p_irkv_rec.date_from

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
764: AND okl_insurer_rankings.RANKING_SEQ = p_irkv_rec.RANKING_SEQ
765: And okl_insurer_rankings.date_from <= p_irkv_rec.date_from
766: AND ( p_irkv_rec.date_from <= nvl(okl_insurer_rankings.date_to,p_irkv_rec.date_from)) ;
767:
768: --AND p_irkv_rec.date_from between okl_insurer_rankings.date_from and nvl(okl_insurer_rankings.date_to,SYSDATE) ;
769:

Line 766: AND ( p_irkv_rec.date_from <= nvl(okl_insurer_rankings.date_to,p_irkv_rec.date_from)) ;

762: WHERE okl_insurer_rankings.id <> p_irkv_rec.id
763: and okl_insurer_rankings.ic_code = p_irkv_rec.ic_code
764: AND okl_insurer_rankings.RANKING_SEQ = p_irkv_rec.RANKING_SEQ
765: And okl_insurer_rankings.date_from <= p_irkv_rec.date_from
766: AND ( p_irkv_rec.date_from <= nvl(okl_insurer_rankings.date_to,p_irkv_rec.date_from)) ;
767:
768: --AND p_irkv_rec.date_from between okl_insurer_rankings.date_from and nvl(okl_insurer_rankings.date_to,SYSDATE) ;
769:
770: CURSOR okl_insurer_rank_v_pk_csr IS

Line 768: --AND p_irkv_rec.date_from between okl_insurer_rankings.date_from and nvl(okl_insurer_rankings.date_to,SYSDATE) ;

764: AND okl_insurer_rankings.RANKING_SEQ = p_irkv_rec.RANKING_SEQ
765: And okl_insurer_rankings.date_from <= p_irkv_rec.date_from
766: AND ( p_irkv_rec.date_from <= nvl(okl_insurer_rankings.date_to,p_irkv_rec.date_from)) ;
767:
768: --AND p_irkv_rec.date_from between okl_insurer_rankings.date_from and nvl(okl_insurer_rankings.date_to,SYSDATE) ;
769:
770: CURSOR okl_insurer_rank_v_pk_csr IS
771: SELECT 'x'
772: FROM okl_insurer_rankings

Line 772: FROM okl_insurer_rankings

768: --AND p_irkv_rec.date_from between okl_insurer_rankings.date_from and nvl(okl_insurer_rankings.date_to,SYSDATE) ;
769:
770: CURSOR okl_insurer_rank_v_pk_csr IS
771: SELECT 'x'
772: FROM okl_insurer_rankings
773: WHERE okl_insurer_rankings.id <> p_irkv_rec.id
774: AND okl_insurer_rankings.ic_code = p_irkv_rec.ic_code
775: AND okl_insurer_rankings.ISU_ID = p_irkv_rec.ISU_ID
776: And okl_insurer_rankings.date_from <= p_irkv_rec.date_from

Line 773: WHERE okl_insurer_rankings.id <> p_irkv_rec.id

769:
770: CURSOR okl_insurer_rank_v_pk_csr IS
771: SELECT 'x'
772: FROM okl_insurer_rankings
773: WHERE okl_insurer_rankings.id <> p_irkv_rec.id
774: AND okl_insurer_rankings.ic_code = p_irkv_rec.ic_code
775: AND okl_insurer_rankings.ISU_ID = p_irkv_rec.ISU_ID
776: And okl_insurer_rankings.date_from <= p_irkv_rec.date_from
777: AND ( p_irkv_rec.date_from <= nvl(okl_insurer_rankings.date_to,p_irkv_rec.date_from)) ;

Line 774: AND okl_insurer_rankings.ic_code = p_irkv_rec.ic_code

770: CURSOR okl_insurer_rank_v_pk_csr IS
771: SELECT 'x'
772: FROM okl_insurer_rankings
773: WHERE okl_insurer_rankings.id <> p_irkv_rec.id
774: AND okl_insurer_rankings.ic_code = p_irkv_rec.ic_code
775: AND okl_insurer_rankings.ISU_ID = p_irkv_rec.ISU_ID
776: And okl_insurer_rankings.date_from <= p_irkv_rec.date_from
777: AND ( p_irkv_rec.date_from <= nvl(okl_insurer_rankings.date_to,p_irkv_rec.date_from)) ;
778:

Line 775: AND okl_insurer_rankings.ISU_ID = p_irkv_rec.ISU_ID

771: SELECT 'x'
772: FROM okl_insurer_rankings
773: WHERE okl_insurer_rankings.id <> p_irkv_rec.id
774: AND okl_insurer_rankings.ic_code = p_irkv_rec.ic_code
775: AND okl_insurer_rankings.ISU_ID = p_irkv_rec.ISU_ID
776: And okl_insurer_rankings.date_from <= p_irkv_rec.date_from
777: AND ( p_irkv_rec.date_from <= nvl(okl_insurer_rankings.date_to,p_irkv_rec.date_from)) ;
778:
779: -- AND p_irkv_rec.date_from between okl_insurer_rankings.date_from and nvl(okl_insurer_rankings.date_to,SYSDATE) ;

Line 776: And okl_insurer_rankings.date_from <= p_irkv_rec.date_from

772: FROM okl_insurer_rankings
773: WHERE okl_insurer_rankings.id <> p_irkv_rec.id
774: AND okl_insurer_rankings.ic_code = p_irkv_rec.ic_code
775: AND okl_insurer_rankings.ISU_ID = p_irkv_rec.ISU_ID
776: And okl_insurer_rankings.date_from <= p_irkv_rec.date_from
777: AND ( p_irkv_rec.date_from <= nvl(okl_insurer_rankings.date_to,p_irkv_rec.date_from)) ;
778:
779: -- AND p_irkv_rec.date_from between okl_insurer_rankings.date_from and nvl(okl_insurer_rankings.date_to,SYSDATE) ;
780:

Line 777: AND ( p_irkv_rec.date_from <= nvl(okl_insurer_rankings.date_to,p_irkv_rec.date_from)) ;

773: WHERE okl_insurer_rankings.id <> p_irkv_rec.id
774: AND okl_insurer_rankings.ic_code = p_irkv_rec.ic_code
775: AND okl_insurer_rankings.ISU_ID = p_irkv_rec.ISU_ID
776: And okl_insurer_rankings.date_from <= p_irkv_rec.date_from
777: AND ( p_irkv_rec.date_from <= nvl(okl_insurer_rankings.date_to,p_irkv_rec.date_from)) ;
778:
779: -- AND p_irkv_rec.date_from between okl_insurer_rankings.date_from and nvl(okl_insurer_rankings.date_to,SYSDATE) ;
780:
781: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 779: -- AND p_irkv_rec.date_from between okl_insurer_rankings.date_from and nvl(okl_insurer_rankings.date_to,SYSDATE) ;

775: AND okl_insurer_rankings.ISU_ID = p_irkv_rec.ISU_ID
776: And okl_insurer_rankings.date_from <= p_irkv_rec.date_from
777: AND ( p_irkv_rec.date_from <= nvl(okl_insurer_rankings.date_to,p_irkv_rec.date_from)) ;
778:
779: -- AND p_irkv_rec.date_from between okl_insurer_rankings.date_from and nvl(okl_insurer_rankings.date_to,SYSDATE) ;
780:
781: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
782: l_row_notfound BOOLEAN := TRUE;
783: l_dummy_var VARCHAR2(1) := '?';

Line 801: p_token3_value => 'OKL_INSURER_RANKINGS');

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;
804: return (l_return_status);
805: END IF;

Line 823: p_token3_value => 'OKL_INSURER_RANKINGS');

819: p_token1_value => 'Provider',
820: p_token2 => g_parent_table_token,
821: p_token2_value => 'OKX_INS_PROVIDER_V',
822: p_token3 => g_child_table_token,
823: p_token3_value => 'OKL_INSURER_RANKINGS');
824: -- notify caller of an error
825: l_return_status := OKC_API.G_RET_STS_ERROR;
826: return (l_return_status);
827: END IF;

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 1247: -- insert_row for:OKL_INSURER_RANKINGS --

1243: ---------------------------------------------------------------------------
1244: -- PROCEDURE insert_row
1245: ---------------------------------------------------------------------------
1246: -----------------------------------------
1247: -- insert_row for:OKL_INSURER_RANKINGS --
1248: -----------------------------------------
1249: PROCEDURE insert_row(
1250: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1251: x_return_status OUT NOCOPY VARCHAR2,

Line 1263: -- Set_Attributes for:OKL_INSURER_RANKINGS --

1259: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1260: l_irk_rec irk_rec_type := p_irk_rec;
1261: l_def_irk_rec irk_rec_type;
1262: ---------------------------------------------
1263: -- Set_Attributes for:OKL_INSURER_RANKINGS --
1264: ---------------------------------------------
1265: FUNCTION Set_Attributes (
1266: p_irk_rec IN irk_rec_type,
1267: x_irk_rec OUT NOCOPY irk_rec_type

Line 1294: INSERT INTO OKL_INSURER_RANKINGS(

1290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1291: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1292: RAISE OKC_API.G_EXCEPTION_ERROR;
1293: END IF;
1294: INSERT INTO OKL_INSURER_RANKINGS(
1295: id,
1296: object_version_number,
1297: ranking_seq,
1298: date_from,

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 1699: -- lock_row for:OKL_INSURER_RANKINGS --

1695: ---------------------------------------------------------------------------
1696: -- PROCEDURE lock_row
1697: ---------------------------------------------------------------------------
1698: ---------------------------------------
1699: -- lock_row for:OKL_INSURER_RANKINGS --
1700: ---------------------------------------
1701: PROCEDURE lock_row(
1702: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1703: x_return_status OUT NOCOPY VARCHAR2,

Line 1712: FROM OKL_INSURER_RANKINGS

1708: E_Resource_Busy EXCEPTION;
1709: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1710: CURSOR lock_csr (p_irk_rec IN irk_rec_type) IS
1711: SELECT OBJECT_VERSION_NUMBER
1712: FROM OKL_INSURER_RANKINGS
1713: WHERE ID = p_irk_rec.id
1714: AND OBJECT_VERSION_NUMBER = p_irk_rec.object_version_number
1715: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1716:

Line 1719: FROM OKL_INSURER_RANKINGS

1715: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1716:
1717: CURSOR lchk_csr (p_irk_rec IN irk_rec_type) IS
1718: SELECT OBJECT_VERSION_NUMBER
1719: FROM OKL_INSURER_RANKINGS
1720: WHERE ID = p_irk_rec.id;
1721: l_api_version CONSTANT NUMBER := 1;
1722: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1723: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1724: l_object_version_number OKL_INSURER_RANKINGS.OBJECT_VERSION_NUMBER%TYPE;

1720: WHERE ID = p_irk_rec.id;
1721: l_api_version CONSTANT NUMBER := 1;
1722: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1723: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1724: l_object_version_number OKL_INSURER_RANKINGS.OBJECT_VERSION_NUMBER%TYPE;
1725: lc_object_version_number OKL_INSURER_RANKINGS.OBJECT_VERSION_NUMBER%TYPE;
1726: l_row_notfound BOOLEAN := FALSE;
1727: lc_row_notfound BOOLEAN := FALSE;
1728: BEGIN

Line 1725: lc_object_version_number OKL_INSURER_RANKINGS.OBJECT_VERSION_NUMBER%TYPE;

1721: l_api_version CONSTANT NUMBER := 1;
1722: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1723: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1724: l_object_version_number OKL_INSURER_RANKINGS.OBJECT_VERSION_NUMBER%TYPE;
1725: lc_object_version_number OKL_INSURER_RANKINGS.OBJECT_VERSION_NUMBER%TYPE;
1726: l_row_notfound BOOLEAN := FALSE;
1727: lc_row_notfound BOOLEAN := FALSE;
1728: BEGIN
1729: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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 2046: -- update_row for:OKL_INSURER_RANKINGS --

2042: ---------------------------------------------------------------------------
2043: -- PROCEDURE update_row
2044: ---------------------------------------------------------------------------
2045: -----------------------------------------
2046: -- update_row for:OKL_INSURER_RANKINGS --
2047: -----------------------------------------
2048: PROCEDURE update_row(
2049: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2050: x_return_status OUT NOCOPY VARCHAR2,

Line 2193: -- Set_Attributes for:OKL_INSURER_RANKINGS --

2189: END IF;
2190: RETURN(l_return_status);
2191: END populate_new_record;
2192: ---------------------------------------------
2193: -- Set_Attributes for:OKL_INSURER_RANKINGS --
2194: ---------------------------------------------
2195: FUNCTION Set_Attributes (
2196: p_irk_rec IN irk_rec_type,
2197: x_irk_rec OUT NOCOPY irk_rec_type

Line 2231: UPDATE OKL_INSURER_RANKINGS

2227: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2228: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2229: RAISE OKC_API.G_EXCEPTION_ERROR;
2230: END IF;
2231: UPDATE OKL_INSURER_RANKINGS
2232: SET OBJECT_VERSION_NUMBER = l_def_irk_rec.object_version_number,
2233: RANKING_SEQ = l_def_irk_rec.ranking_seq,
2234: DATE_FROM = l_def_irk_rec.date_from,
2235: DATE_TO = l_def_irk_rec.date_to,

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 2755: -- delete_row for:OKL_INSURER_RANKINGS --

2751: ---------------------------------------------------------------------------
2752: -- PROCEDURE delete_row
2753: ---------------------------------------------------------------------------
2754: -----------------------------------------
2755: -- delete_row for:OKL_INSURER_RANKINGS --
2756: -----------------------------------------
2757: PROCEDURE delete_row(
2758: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2759: x_return_status OUT NOCOPY VARCHAR2,

Line 2780: DELETE FROM OKL_INSURER_RANKINGS

2776: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2777: RAISE OKC_API.G_EXCEPTION_ERROR;
2778: END IF;
2779:
2780: DELETE FROM OKL_INSURER_RANKINGS
2781: WHERE ID = p_irk_rec.id;
2782:
2783: x_return_status := l_return_status;
2784: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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,