166: i := p_gtlv_tbl.NEXT(i);
167: END LOOP;
168:
169: -- Call the TAPI Procedcure to perform the actual inserts
170: okl_gtl_pvt.insert_row(
171: p_api_version => l_api_version
172: ,p_init_msg_list => p_init_msg_list
173: ,x_return_status => l_return_status
174: ,x_msg_count => l_msg_count
612: END LOOP;
613: IF (l_gtlv_tbl_ins_in.COUNT > 0 )
614: THEN
615: -- Call the TAPI Procedcure to perform the actual inserts
616: okl_gtl_pvt.insert_row(
617: p_api_version => l_api_version
618: ,p_init_msg_list => p_init_msg_list
619: ,x_return_status => l_return_status
620: ,x_msg_count => l_msg_count
630: END IF;
631: IF (l_gtlv_tbl_upd_in.count > 0 )
632: THEN
633: -- Call the TAPI Procedcure to perform the actual updates
634: okl_gtl_pvt.update_row(
635: p_api_version => l_api_version
636: ,p_init_msg_list => p_init_msg_list
637: ,x_return_status => l_return_status
638: ,x_msg_count => l_msg_count
1045: END LOOP;
1046: IF (l_gtlv_tbl_pri_in.COUNT > 0 )
1047: THEN
1048: -- Call the TAPI Procedcure to perform the actual inserts
1049: okl_gtl_pvt.insert_row(
1050: p_api_version => l_api_version
1051: ,p_init_msg_list => p_init_msg_list
1052: ,x_return_status => l_return_status
1053: ,x_msg_count => l_msg_count
1076: END LOOP;
1077: IF (l_gtlv_tbl_dep_in.COUNT > 0 )
1078: THEN
1079: -- Call the TAPI Procedcure to perform the actual inserts
1080: okl_gtl_pvt.insert_row(
1081: p_api_version => l_api_version
1082: ,p_init_msg_list => p_init_msg_list
1083: ,x_return_status => l_return_status
1084: ,x_msg_count => l_msg_count
1295: i := i + 1;
1296: END LOOP;
1297: IF l_gtlv_dep_tbl_del_in.COUNT > 0
1298: THEN
1299: Okl_Gtl_Pvt.delete_row(
1300: p_api_version => l_api_version,
1301: p_init_msg_list => l_init_msg_list,
1302: x_return_status => l_return_status,
1303: x_msg_count => l_msg_count,
1311: END IF;
1312: l_gtlv_dep_tbl_del_in.DELETE;
1313: END IF;
1314: END LOOP;
1315: Okl_Gtl_Pvt.delete_row(
1316: p_api_version => l_api_version,
1317: p_init_msg_list => l_init_msg_list,
1318: x_return_status => l_return_status,
1319: x_msg_count => l_msg_count,
1403: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1404: RAISE OKL_API.G_EXCEPTION_ERROR;
1405: END IF;
1406:
1407: Okl_Gtl_Pvt.delete_row(
1408: p_api_version => l_api_version,
1409: p_init_msg_list => l_init_msg_list,
1410: x_return_status => l_return_status,
1411: x_msg_count => l_msg_count,
4621: END LOOP;
4622: IF (l_gtlv_tbl_ins_in.COUNT > 0 )
4623: THEN
4624: -- Call the TAPI Procedcure to perform the actual inserts
4625: okl_gtl_pvt.insert_row(
4626: p_api_version => l_api_version
4627: ,p_init_msg_list => p_init_msg_list
4628: ,x_return_status => l_return_status
4629: ,x_msg_count => l_msg_count
4639: END IF;
4640: IF (l_gtlv_tbl_upd_in.count > 0 )
4641: THEN
4642: -- Call the TAPI Procedcure to perform the actual updates
4643: okl_gtl_pvt.update_row(
4644: p_api_version => l_api_version
4645: ,p_init_msg_list => p_init_msg_list
4646: ,x_return_status => l_return_status
4647: ,x_msg_count => l_msg_count