172: ,p_stmv_rec IN stmv_rec_type
173: ,x_stmv_rec OUT NOCOPY stmv_rec_type) IS
174: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
175: BEGIN
176: Okl_Stm_Pvt.insert_row(
177: p_api_version => p_api_version
178: ,p_init_msg_list => p_init_msg_list
179: ,x_return_status => x_return_status
180: ,x_msg_count => x_msg_count
218: ,x_stmv_tbl OUT NOCOPY stmv_tbl_type) IS
219: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
220:
221: BEGIN
222: Okl_Stm_Pvt.insert_row(
223: p_api_version => p_api_version
224: ,p_init_msg_list => p_init_msg_list
225: ,x_return_status => x_return_status
226: ,x_msg_count => x_msg_count
275: j BINARY_INTEGER;
276: l_new_rec BOOLEAN := true;
277: BEGIN
278: -- calling the bulk update method of the TAPI
279: okl_stm_pvt.insert_row_perf(
280: p_api_version,
281: p_init_msg_list,
282: x_return_status,
283: x_msg_count,
471: ,p_stmv_rec IN stmv_rec_type) IS
472: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
473:
474: BEGIN
475: Okl_Stm_Pvt.lock_row(
476: p_api_version => p_api_version
477: ,p_init_msg_list => p_init_msg_list
478: ,x_return_status => x_return_status
479: ,x_msg_count => x_msg_count
510: ,p_stmv_tbl IN stmv_tbl_type) IS
511: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
512:
513: BEGIN
514: Okl_Stm_Pvt.lock_row(
515: p_api_version => p_api_version
516: ,p_init_msg_list => p_init_msg_list
517: ,x_return_status => x_return_status
518: ,x_msg_count => x_msg_count
550: ,x_stmv_rec OUT NOCOPY stmv_rec_type) IS
551: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
552:
553: BEGIN
554: Okl_Stm_Pvt.update_row(
555: p_api_version => p_api_version
556: ,p_init_msg_list => p_init_msg_list
557: ,x_return_status => x_return_status
558: ,x_msg_count => x_msg_count
589: ,p_stmv_tbl IN stmv_tbl_type
590: ,x_stmv_tbl OUT NOCOPY stmv_tbl_type) IS
591: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
592: BEGIN
593: Okl_Stm_Pvt.update_row(
594: p_api_version => p_api_version
595: ,p_init_msg_list => p_init_msg_list
596: ,x_return_status => x_return_status
597: ,x_msg_count => x_msg_count
657: END IF;
658: -- rabhupat bug#4371472 end
659: END IF;
660: --Delete the Master
661: Okl_Stm_Pvt.delete_row(
662: p_api_version => p_api_version
663: ,p_init_msg_list => p_init_msg_list
664: ,x_return_status => x_return_status
665: ,x_msg_count => x_msg_count
744: ,x_msg_data OUT NOCOPY VARCHAR2
745: ,p_stmv_rec IN stmv_rec_type) IS
746: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
747: BEGIN
748: Okl_Stm_Pvt.validate_row(
749: p_api_version => p_api_version
750: ,p_init_msg_list => p_init_msg_list
751: ,x_return_status => x_return_status
752: ,x_msg_count => x_msg_count
782: p_stmv_tbl IN stmv_tbl_type) IS
783: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
784:
785: BEGIN
786: Okl_Stm_Pvt.validate_row(
787: p_api_version => p_api_version
788: ,p_init_msg_list => p_init_msg_list
789: ,x_return_status => x_return_status
790: ,x_msg_count => x_msg_count