661: ---------------------------------------------------------------------------
662: -- PROCEDURE create_stream_type for: OKL_STRM_TYPE_V
663: ---------------------------------------------------------------------------
664: PROCEDURE create_stream_type( p_api_version IN NUMBER,
665: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
666: x_return_status OUT NOCOPY VARCHAR2,
667: x_msg_count OUT NOCOPY NUMBER,
668: x_msg_data OUT NOCOPY VARCHAR2,
669: p_styv_rec IN styv_rec_type,
741: ---------------------------------------------------------------------------
742: -- PROCEDURE update_stream_type for: OKL_STRM_TYPE_V
743: ---------------------------------------------------------------------------
744: PROCEDURE update_stream_type(p_api_version IN NUMBER,
745: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
746: x_return_status OUT NOCOPY VARCHAR2,
747: x_msg_count OUT NOCOPY NUMBER,
748: x_msg_data OUT NOCOPY VARCHAR2,
749: p_styv_rec IN styv_rec_type,
796: THEN
797: /*
798: ** 25-Oct-2004 vthiruva -- Fix for Bug#3731453 end
799: */
800: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,
801: p_msg_name => G_INVALID_VALUE,
802: p_token1 => G_COL_NAME_TOKEN,
803: p_token1_value => 'END_DATE' );
804: RAISE G_EXCEPTION_ERROR;
825: ( to_date(to_char(l_db_styv_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <= l_sysdate
826: OR to_date(to_char(l_styv_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate
827: )
828: THEN
829: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,
830: p_msg_name => G_INVALID_VALUE,
831: p_token1 => G_COL_NAME_TOKEN,
832: p_token1_value => 'START_DATE' );
833: RAISE G_EXCEPTION_ERROR;
844: THEN
845: /*
846: ** 25-Oct-2004 vthiruva -- Fix for Bug#3731453 end
847: */
848: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,
849: p_msg_name => G_INVALID_VALUE,
850: p_token1 => G_COL_NAME_TOKEN,
851: p_token1_value => 'START_DATE' );
852: RAISE G_EXCEPTION_ERROR;
876: IF l_styv_rec.end_date IS NOT NULL
877: AND to_date(to_char(l_styv_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(G_MISS_DATE,'DD/MM/YYYY'), 'DD/MM/YYYY')
878: AND to_date(to_char(l_styv_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') < to_date(to_char(l_styv_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY')
879: THEN
880: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,
881: p_msg_name => G_INVALID_VALUE,
882: p_token1 => G_COL_NAME_TOKEN,
883: p_token1_value => 'END_DATE' );
884: END IF;
1143: END update_stream_type;
1144:
1145: PROCEDURE create_stream_type(
1146: p_api_version IN NUMBER,
1147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1148: x_return_status OUT NOCOPY VARCHAR2,
1149: x_msg_count OUT NOCOPY NUMBER,
1150: x_msg_data OUT NOCOPY VARCHAR2,
1151: p_styv_tbl IN styv_tbl_type,
1194:
1195:
1196: PROCEDURE update_stream_type(
1197: p_api_version IN NUMBER,
1198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1199: x_return_status OUT NOCOPY VARCHAR2,
1200: x_msg_count OUT NOCOPY NUMBER,
1201: x_msg_data OUT NOCOPY VARCHAR2,
1202: p_styv_tbl IN styv_tbl_type,