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_INS_QUOTE_PVT dependencies on OKL_STREAMS_PUB

Line 613: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;

609: x_msg_data OUT NOCOPY VARCHAR2,
610: p_ipyv_rec IN ipyv_rec_type,
611: p_payment_tbl_type IN payment_tbl_type ) IS
612:
613: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
614: l_api_version CONSTANT NUMBER := 1;
615: l_api_name CONSTANT VARCHAR2(30) := 'payment_stream';
616: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
617: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;

Line 617: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;

613: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
614: l_api_version CONSTANT NUMBER := 1;
615: l_api_name CONSTANT VARCHAR2(30) := 'payment_stream';
616: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
617: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
618: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
619: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;
620: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
621:

Line 618: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;

614: l_api_version CONSTANT NUMBER := 1;
615: l_api_name CONSTANT VARCHAR2(30) := 'payment_stream';
616: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
617: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
618: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
619: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;
620: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
621:
622: l_date DATE;

Line 619: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;

615: l_api_name CONSTANT VARCHAR2(30) := 'payment_stream';
616: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
617: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
618: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
619: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;
620: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
621:
622: l_date DATE;
623:

Line 620: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;

616: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
617: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
618: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
619: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;
620: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
621:
622: l_date DATE;
623:
624: BEGIN

Line 687: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams

683: p_selv_tbl(i).se_line_number := i;
684: p_selv_tbl(i).accrued_yn := 'N';
685: END LOOP;
686: -- Create Stream and Stream Elements
687: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
688: IF(L_DEBUG_ENABLED='Y') THEN
689: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
690: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
691: END IF;

Line 732: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');

728:
729:
730: IF(IS_DEBUG_PROCEDURE_ON) THEN
731: BEGIN
732: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
733: END;
734: END IF;
735: OKL_STREAMS_PUB.create_streams(
736: p_api_version

Line 735: OKL_STREAMS_PUB.create_streams(

731: BEGIN
732: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
733: END;
734: END IF;
735: OKL_STREAMS_PUB.create_streams(
736: p_api_version
737: ,p_init_msg_list
738: ,x_return_status
739: ,x_msg_count

Line 747: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');

743: ,x_stmv_rec
744: ,x_selv_tbl);
745: IF(IS_DEBUG_PROCEDURE_ON) THEN
746: BEGIN
747: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
748: END;
749: END IF;
750: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
751:

Line 750: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams

746: BEGIN
747: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
748: END;
749: END IF;
750: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
751:
752: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
753: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
754: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 795: FUNCTION genrt_monthly_inc(p_ipyv_rec IN ipyv_rec_type,x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type)

791: END payment_stream ;
792:
793:
794:
795: FUNCTION genrt_monthly_inc(p_ipyv_rec IN ipyv_rec_type,x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type)
796: RETURN VARCHAR2 IS
797: l_date_from DATE;
798: l_date_to DATE;
799: l_ins_term NUMBER;

Line 895: x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type)

891:
892:
893: FUNCTION genrt_monthly(p_insexp_tbl IN insexp_tbl_type,
894: p_date_from IN DATE,
895: x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type)
896: RETURN VARCHAR2 IS
897: l_ins_term NUMBER;
898: l_premium NUMBER;
899: l_bill_periods NUMBER;

Line 1001: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;

997: x_msg_count OUT NOCOPY NUMBER,
998: x_msg_data OUT NOCOPY VARCHAR2,
999: p_ipyv_rec IN ipyv_rec_type
1000: )IS
1001: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
1002: l_row_notfound BOOLEAN := TRUE;
1003: l_msg_count NUMBER ;
1004: l_msg_data VARCHAR2(2000);
1005: l_api_version CONSTANT NUMBER := 1;

Line 1008: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;

1004: l_msg_data VARCHAR2(2000);
1005: l_api_version CONSTANT NUMBER := 1;
1006: l_api_name CONSTANT VARCHAR2(30) := 'create_insinc_streams';
1007: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1008: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
1009: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
1010: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;
1011: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
1012: x_khr_status VARCHAR2 (30) ;

Line 1009: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;

1005: l_api_version CONSTANT NUMBER := 1;
1006: l_api_name CONSTANT VARCHAR2(30) := 'create_insinc_streams';
1007: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1008: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
1009: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
1010: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;
1011: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
1012: x_khr_status VARCHAR2 (30) ;
1013: l_khr_date_from DATE ;

Line 1010: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;

1006: l_api_name CONSTANT VARCHAR2(30) := 'create_insinc_streams';
1007: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1008: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
1009: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
1010: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;
1011: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
1012: x_khr_status VARCHAR2 (30) ;
1013: l_khr_date_from DATE ;
1014: l_khr_date_to DATE ;

Line 1011: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;

1007: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1008: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
1009: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
1010: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;
1011: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
1012: x_khr_status VARCHAR2 (30) ;
1013: l_khr_date_from DATE ;
1014: l_khr_date_to DATE ;
1015: l_ipyv_rec Okl_Ipy_Pvt.ipyv_rec_type;

Line 1132: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams

1128: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
1129:
1130:
1131: -- Create Stream and Stream Elements
1132: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1133: IF(L_DEBUG_ENABLED='Y') THEN
1134: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
1135: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1136: END IF;

Line 1177: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');

1173:
1174:
1175: IF(IS_DEBUG_PROCEDURE_ON) THEN
1176: BEGIN
1177: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1178: END;
1179: END IF;
1180: OKL_STREAMS_PUB.create_streams(
1181: p_api_version

Line 1180: OKL_STREAMS_PUB.create_streams(

1176: BEGIN
1177: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1178: END;
1179: END IF;
1180: OKL_STREAMS_PUB.create_streams(
1181: p_api_version
1182: ,p_init_msg_list
1183: ,x_return_status
1184: ,x_msg_count

Line 1192: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');

1188: ,x_stmv_rec
1189: ,x_selv_tbl );
1190: IF(IS_DEBUG_PROCEDURE_ON) THEN
1191: BEGIN
1192: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1193: END;
1194: END IF;
1195: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1196:

Line 1195: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams

1191: BEGIN
1192: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1193: END;
1194: END IF;
1195: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1196:
1197:
1198: l_return_status := x_return_status ;
1199: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1374: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams

1370: p_selv_tbl:= x_selv_tbl;
1371: -- Bug 5408689 : End
1372:
1373:
1374: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1375: IF(IS_DEBUG_PROCEDURE_ON) THEN
1376: BEGIN
1377: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1378: END;

Line 1377: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');

1373:
1374: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1375: IF(IS_DEBUG_PROCEDURE_ON) THEN
1376: BEGIN
1377: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1378: END;
1379: END IF;
1380: OKL_STREAMS_PUB.create_streams(
1381: p_api_version

Line 1380: OKL_STREAMS_PUB.create_streams(

1376: BEGIN
1377: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1378: END;
1379: END IF;
1380: OKL_STREAMS_PUB.create_streams(
1381: p_api_version
1382: ,p_init_msg_list
1383: ,x_return_status
1384: ,x_msg_count

Line 1393: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');

1389: ,x_selv_tbl
1390: );
1391: IF(IS_DEBUG_PROCEDURE_ON) THEN
1392: BEGIN
1393: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1394: END;
1395: END IF;
1396: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1397:

Line 1396: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams

1392: BEGIN
1393: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1394: END;
1395: END IF;
1396: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1397:
1398:
1399:
1400: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1465: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;

1461: p_khr_id IN NUMBER,
1462: p_kle_id IN NUMBER,
1463: p_date_from IN DATE
1464: )IS
1465: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
1466: l_row_notfound BOOLEAN := TRUE;
1467: l_msg_count NUMBER ;
1468: l_msg_data VARCHAR2(2000);
1469: l_api_version CONSTANT NUMBER := 1;

Line 1472: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;

1468: l_msg_data VARCHAR2(2000);
1469: l_api_version CONSTANT NUMBER := 1;
1470: l_api_name CONSTANT VARCHAR2(30) := 'create_insexp_streams';
1471: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1472: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
1473: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
1474: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;
1475: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
1476: x_khr_status VARCHAR2 (30) ;

Line 1473: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;

1469: l_api_version CONSTANT NUMBER := 1;
1470: l_api_name CONSTANT VARCHAR2(30) := 'create_insexp_streams';
1471: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1472: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
1473: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
1474: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;
1475: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
1476: x_khr_status VARCHAR2 (30) ;
1477: l_khr_date_from DATE ;

Line 1474: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;

1470: l_api_name CONSTANT VARCHAR2(30) := 'create_insexp_streams';
1471: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1472: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
1473: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
1474: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;
1475: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
1476: x_khr_status VARCHAR2 (30) ;
1477: l_khr_date_from DATE ;
1478: l_khr_date_to DATE ;

Line 1475: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;

1471: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1472: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
1473: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
1474: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;
1475: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
1476: x_khr_status VARCHAR2 (30) ;
1477: l_khr_date_from DATE ;
1478: l_khr_date_to DATE ;
1479: l_insexp_tbl insexp_tbl_type;

Line 1567: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams

1563:
1564:
1565: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
1566: -- Create Stream and Stream Elements
1567: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1568: IF(L_DEBUG_ENABLED='Y') THEN
1569: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
1570: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1571: END IF;

Line 1612: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');

1608:
1609:
1610: IF(IS_DEBUG_PROCEDURE_ON) THEN
1611: BEGIN
1612: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1613: END;
1614: END IF;
1615: OKL_STREAMS_PUB.create_streams(
1616: p_api_version

Line 1615: OKL_STREAMS_PUB.create_streams(

1611: BEGIN
1612: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1613: END;
1614: END IF;
1615: OKL_STREAMS_PUB.create_streams(
1616: p_api_version
1617: ,p_init_msg_list
1618: ,x_return_status
1619: ,x_msg_count

Line 1628: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');

1624: ,x_selv_tbl
1625: );
1626: IF(IS_DEBUG_PROCEDURE_ON) THEN
1627: BEGIN
1628: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1629: END;
1630: END IF;
1631: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1632: l_return_status := x_return_status ;

Line 1631: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams

1627: BEGIN
1628: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1629: END;
1630: END IF;
1631: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1632: l_return_status := x_return_status ;
1633:
1634: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1635: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1810: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams

1806: p_selv_tbl:= x_selv_tbl;
1807: -- Bug 5408689 : End
1808:
1809:
1810: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1811: IF(IS_DEBUG_PROCEDURE_ON) THEN
1812: BEGIN
1813: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1814: END;

Line 1813: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');

1809:
1810: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1811: IF(IS_DEBUG_PROCEDURE_ON) THEN
1812: BEGIN
1813: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1814: END;
1815: END IF;
1816: OKL_STREAMS_PUB.create_streams(
1817: p_api_version

Line 1816: OKL_STREAMS_PUB.create_streams(

1812: BEGIN
1813: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1814: END;
1815: END IF;
1816: OKL_STREAMS_PUB.create_streams(
1817: p_api_version
1818: ,p_init_msg_list
1819: ,x_return_status
1820: ,x_msg_count

Line 1829: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');

1825: ,x_selv_tbl
1826: );
1827: IF(IS_DEBUG_PROCEDURE_ON) THEN
1828: BEGIN
1829: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1830: END;
1831: END IF;
1832: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1833:

Line 1832: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams

1828: BEGIN
1829: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1830: END;
1831: END IF;
1832: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1833:
1834:
1835: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1836: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1965: x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type) RETURN VARCHAR2 IS

1961: -------------------------------------------------------------------------------
1962: -- Procedure Generate Lump_Sum
1963: -------------------------------------------------------------------------------
1964: FUNCTION genrt_lump_sum(p_ipyv_rec IN ipyv_rec_type,
1965: x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type) RETURN VARCHAR2 IS
1966: l_date_from DATE;
1967: l_date_to DATE;
1968: l_due_date DATE;
1969: l_ins_term NUMBER;

Line 1989: FUNCTION genrt_monthly(p_ipyv_rec IN ipyv_rec_type,x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type)

1985: END genrt_lump_sum;
1986: -------------------------------------------------------------------------------
1987: -- Procedure Generate Monthly
1988: -------------------------------------------------------------------------------
1989: FUNCTION genrt_monthly(p_ipyv_rec IN ipyv_rec_type,x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type)
1990: RETURN VARCHAR2 IS
1991: l_date_from DATE;
1992: l_date_to DATE;
1993: l_ins_term NUMBER;

Line 2049: FUNCTION genrt_bi_monthly(p_ipyv_rec IN ipyv_rec_type,x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type)RETURN VARCHAR2 IS

2045: END genrt_monthly;
2046: -------------------------------------------------------------------------------
2047: -- Procedure Generate Bi-Monthly
2048: -------------------------------------------------------------------------------
2049: FUNCTION genrt_bi_monthly(p_ipyv_rec IN ipyv_rec_type,x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type)RETURN VARCHAR2 IS
2050: l_date_from DATE;
2051: l_date_to DATE;
2052: l_due_date DATE;
2053: l_ins_term NUMBER;

Line 2105: x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type) RETURN VARCHAR2 IS

2101: -------------------------------------------------------------------------------
2102: -- Procedure Generate Half-Yearly
2103: -------------------------------------------------------------------------------
2104: FUNCTION genrt_half_yearly(p_ipyv_rec IN ipyv_rec_type,
2105: x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type) RETURN VARCHAR2 IS
2106: l_date_from DATE;
2107: l_date_to DATE;
2108: l_due_date DATE;
2109: l_amount_due NUMBER;

Line 2167: FUNCTION genrt_quarterly(p_ipyv_rec IN ipyv_rec_type,x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type) RETURN VARCHAR2 IS

2163: END genrt_half_yearly;
2164: -------------------------------------------------------------------------------
2165: -- Procedure Generate Quarterly
2166: -------------------------------------------------------------------------------
2167: FUNCTION genrt_quarterly(p_ipyv_rec IN ipyv_rec_type,x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type) RETURN VARCHAR2 IS
2168: l_date_from DATE;
2169: l_date_to DATE;
2170: l_due_date DATE;
2171: l_amount_due NUMBER;

Line 2234: FUNCTION genrt_yearly(p_ipyv_rec IN ipyv_rec_type,x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type)RETURN VARCHAR2 IS

2230: END genrt_quarterly;
2231: -------------------------------------------------------------------------------
2232: -- Procedure Generate Yearly
2233: -------------------------------------------------------------------------------
2234: FUNCTION genrt_yearly(p_ipyv_rec IN ipyv_rec_type,x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type)RETURN VARCHAR2 IS
2235: l_date_from DATE;
2236: l_date_to DATE;
2237: l_due_date DATE;
2238: l_amount_due NUMBER;

Line 2587: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;

2583: x_msg_count OUT NOCOPY NUMBER,
2584: x_msg_data OUT NOCOPY VARCHAR2,
2585: p_ipyv_rec IN ipyv_rec_type
2586: )IS
2587: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2588: l_row_notfound BOOLEAN := TRUE;
2589: l_msg_count NUMBER ;
2590: l_msg_data VARCHAR2(2000);
2591: l_api_version CONSTANT NUMBER := 1;

Line 2594: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;

2590: l_msg_data VARCHAR2(2000);
2591: l_api_version CONSTANT NUMBER := 1;
2592: l_api_name CONSTANT VARCHAR2(30) := 'create_ins_streams';
2593: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2594: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2595: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2596: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;
2597: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
2598: x_khr_status VARCHAR2 (30) ;

Line 2595: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;

2591: l_api_version CONSTANT NUMBER := 1;
2592: l_api_name CONSTANT VARCHAR2(30) := 'create_ins_streams';
2593: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2594: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2595: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2596: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;
2597: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
2598: x_khr_status VARCHAR2 (30) ;
2599: l_khr_date_from DATE ;

Line 2596: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;

2592: l_api_name CONSTANT VARCHAR2(30) := 'create_ins_streams';
2593: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2594: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2595: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2596: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;
2597: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
2598: x_khr_status VARCHAR2 (30) ;
2599: l_khr_date_from DATE ;
2600: l_khr_date_to DATE ;

Line 2597: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;

2593: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2594: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2595: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2596: p_selv_tbl Okl_Streams_Pub.selv_tbl_type;
2597: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
2598: x_khr_status VARCHAR2 (30) ;
2599: l_khr_date_from DATE ;
2600: l_khr_date_to DATE ;
2601: l_ipyv_rec Okl_Ipy_Pvt.ipyv_rec_type;

Line 2790: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams

2786: END IF;
2787: p_selv_tbl:=x_selv_tbl;
2788: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
2789: -- Create Stream and Stream Elements
2790: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
2791: IF(L_DEBUG_ENABLED='Y') THEN
2792: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2793: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2794: END IF;

Line 2835: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');

2831:
2832:
2833: IF(IS_DEBUG_PROCEDURE_ON) THEN
2834: BEGIN
2835: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
2836: END;
2837: END IF;
2838: OKL_STREAMS_PUB.create_streams(
2839: p_api_version

Line 2838: OKL_STREAMS_PUB.create_streams(

2834: BEGIN
2835: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
2836: END;
2837: END IF;
2838: OKL_STREAMS_PUB.create_streams(
2839: p_api_version
2840: ,p_init_msg_list
2841: ,x_return_status
2842: ,x_msg_count

Line 2851: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');

2847: ,x_selv_tbl
2848: );
2849: IF(IS_DEBUG_PROCEDURE_ON) THEN
2850: BEGIN
2851: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
2852: END;
2853: END IF;
2854: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
2855: l_return_status := x_return_status ;

Line 2854: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams

2850: BEGIN
2851: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
2852: END;
2853: END IF;
2854: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
2855: l_return_status := x_return_status ;
2856:
2857: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2858: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 6337: -- Start of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.update_streams

6333: END IF;
6334: l_stmv_rec.active_yn := 'Y' ;
6335: l_stmv_rec.date_current := SYSDATE ;
6336: l_stmv_rec.SAY_CODE := 'CURR' ;
6337: -- Start of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.update_streams
6338: IF(L_DEBUG_ENABLED='Y') THEN
6339: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
6340: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
6341: END IF;

Line 6344: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Streams_Pub.update_streams ');

6340: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
6341: END IF;
6342: IF(IS_DEBUG_PROCEDURE_ON) THEN
6343: BEGIN
6344: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Streams_Pub.update_streams ');
6345: END;
6346: END IF;
6347: Okl_Streams_Pub.update_streams (
6348: p_api_version => l_api_version,

Line 6347: Okl_Streams_Pub.update_streams (

6343: BEGIN
6344: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Streams_Pub.update_streams ');
6345: END;
6346: END IF;
6347: Okl_Streams_Pub.update_streams (
6348: p_api_version => l_api_version,
6349: p_init_msg_list => Okc_Api.G_FALSE ,
6350: x_return_status => l_return_status ,
6351: x_msg_count => x_msg_count,

Line 6357: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Streams_Pub.update_streams ');

6353: p_stmv_rec => l_stmv_rec,
6354: x_stmv_rec => x_stmv_rec);
6355: IF(IS_DEBUG_PROCEDURE_ON) THEN
6356: BEGIN
6357: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Streams_Pub.update_streams ');
6358: END;
6359: END IF;
6360: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.update_streams
6361:

Line 6360: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.update_streams

6356: BEGIN
6357: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Streams_Pub.update_streams ');
6358: END;
6359: END IF;
6360: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.update_streams
6361:
6362: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6363:
6364: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 7160: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

7156: l_stmv_rec.date_current := SYSDATE ;
7157: l_stmv_rec.SAY_CODE := 'CURR' ;
7158:
7159:
7160: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7161: IF(IS_DEBUG_PROCEDURE_ON) THEN
7162: BEGIN
7163: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7164: END;

Line 7163: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');

7159:
7160: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7161: IF(IS_DEBUG_PROCEDURE_ON) THEN
7162: BEGIN
7163: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7164: END;
7165: END IF;
7166: OKL_STREAMS_PUB.update_streams(
7167: p_api_version

Line 7166: OKL_STREAMS_PUB.update_streams(

7162: BEGIN
7163: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7164: END;
7165: END IF;
7166: OKL_STREAMS_PUB.update_streams(
7167: p_api_version
7168: ,p_init_msg_list
7169: ,x_return_status
7170: ,x_msg_count

Line 7177: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');

7173: ,x_stmv_rec
7174: );
7175: IF(IS_DEBUG_PROCEDURE_ON) THEN
7176: BEGIN
7177: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7178: END;
7179: END IF;
7180: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7181:

Line 7180: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

7176: BEGIN
7177: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7178: END;
7179: END IF;
7180: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7181:
7182: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7183: CLOSE c_okl_strem_rec_acc ;
7184: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 7216: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

7212: l_stmv_rec2.date_current := SYSDATE ;
7213: l_stmv_rec2.SAY_CODE := 'CURR' ;
7214:
7215:
7216: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7217: IF(IS_DEBUG_PROCEDURE_ON) THEN
7218: BEGIN
7219: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7220: END;

Line 7219: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');

7215:
7216: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7217: IF(IS_DEBUG_PROCEDURE_ON) THEN
7218: BEGIN
7219: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7220: END;
7221: END IF;
7222: OKL_STREAMS_PUB.update_streams(
7223: p_api_version

Line 7222: OKL_STREAMS_PUB.update_streams(

7218: BEGIN
7219: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7220: END;
7221: END IF;
7222: OKL_STREAMS_PUB.update_streams(
7223: p_api_version
7224: ,p_init_msg_list
7225: ,x_return_status
7226: ,x_msg_count

Line 7233: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');

7229: ,x_stmv_rec
7230: );
7231: IF(IS_DEBUG_PROCEDURE_ON) THEN
7232: BEGIN
7233: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7234: END;
7235: END IF;
7236: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7237:

Line 7236: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

7232: BEGIN
7233: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7234: END;
7235: END IF;
7236: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7237:
7238: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7239: CLOSE c_okl_strem_rec_repacc ;
7240: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 7288: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

7284: l_stmv_rec3.date_current := SYSDATE ;
7285: l_stmv_rec3.SAY_CODE := 'CURR' ;
7286:
7287:
7288: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7289: IF(IS_DEBUG_PROCEDURE_ON) THEN
7290: BEGIN
7291: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7292: END;

Line 7291: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');

7287:
7288: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7289: IF(IS_DEBUG_PROCEDURE_ON) THEN
7290: BEGIN
7291: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7292: END;
7293: END IF;
7294: OKL_STREAMS_PUB.update_streams(
7295: p_api_version

Line 7294: OKL_STREAMS_PUB.update_streams(

7290: BEGIN
7291: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7292: END;
7293: END IF;
7294: OKL_STREAMS_PUB.update_streams(
7295: p_api_version
7296: ,p_init_msg_list
7297: ,x_return_status
7298: ,x_msg_count

Line 7305: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');

7301: ,x_stmv_rec
7302: );
7303: IF(IS_DEBUG_PROCEDURE_ON) THEN
7304: BEGIN
7305: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7306: END;
7307: END IF;
7308: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7309:

Line 7308: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

7304: BEGIN
7305: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7306: END;
7307: END IF;
7308: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7309:
7310: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7311: CLOSE c_okl_strem_rec_acc ;
7312: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 7344: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

7340: l_stmv_rec4.date_current := SYSDATE ;
7341: l_stmv_rec4.SAY_CODE := 'CURR' ;
7342:
7343:
7344: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7345: IF(IS_DEBUG_PROCEDURE_ON) THEN
7346: BEGIN
7347: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7348: END;

Line 7347: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');

7343:
7344: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7345: IF(IS_DEBUG_PROCEDURE_ON) THEN
7346: BEGIN
7347: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7348: END;
7349: END IF;
7350: OKL_STREAMS_PUB.update_streams(
7351: p_api_version

Line 7350: OKL_STREAMS_PUB.update_streams(

7346: BEGIN
7347: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7348: END;
7349: END IF;
7350: OKL_STREAMS_PUB.update_streams(
7351: p_api_version
7352: ,p_init_msg_list
7353: ,x_return_status
7354: ,x_msg_count

Line 7361: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');

7357: ,x_stmv_rec
7358: );
7359: IF(IS_DEBUG_PROCEDURE_ON) THEN
7360: BEGIN
7361: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7362: END;
7363: END IF;
7364: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7365:

Line 7364: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

7360: BEGIN
7361: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7362: END;
7363: END IF;
7364: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7365:
7366: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7367: CLOSE c_okl_strem_rec_repacc ;
7368: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;