791: x_return_status => x_return_status,
792: x_msg_count => x_msg_count,
793: x_msg_data => x_msg_data,
794: p_tqdv_rec => p_tqdv_tbl(i));
795: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
796: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
797: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
798: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
799: END IF;
792: x_msg_count => x_msg_count,
793: x_msg_data => x_msg_data,
794: p_tqdv_rec => p_tqdv_tbl(i));
795: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
796: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
797: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
798: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
799: END IF;
800: EXIT WHEN (i = p_tqdv_tbl.LAST);
793: x_msg_data => x_msg_data,
794: p_tqdv_rec => p_tqdv_tbl(i));
795: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
796: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
797: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
798: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
799: END IF;
800: EXIT WHEN (i = p_tqdv_tbl.LAST);
801: i := p_tqdv_tbl.NEXT(i);
794: p_tqdv_rec => p_tqdv_tbl(i));
795: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
796: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
797: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
798: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
799: END IF;
800: EXIT WHEN (i = p_tqdv_tbl.LAST);
801: i := p_tqdv_tbl.NEXT(i);
802: END LOOP;
1020: x_tqdv_rec.OBJECT_VERSION_NUMBER := 1;
1021: RETURN(l_return_status);
1022: END Set_Attributes;
1023: BEGIN
1024: x_return_status := OKL_API.START_ACTIVITY(l_api_name,
1025: G_PKG_NAME,
1026: p_init_msg_list,
1027: l_api_version,
1028: p_api_version,
1138: x_msg_count => x_msg_count,
1139: x_msg_data => x_msg_data,
1140: p_tqdv_rec => p_tqdv_tbl(i),
1141: x_tqdv_rec => x_tqdv_tbl(i));
1142: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1143: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1144: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1145: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1146: END IF;
1139: x_msg_data => x_msg_data,
1140: p_tqdv_rec => p_tqdv_tbl(i),
1141: x_tqdv_rec => x_tqdv_tbl(i));
1142: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1143: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1144: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1145: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1146: END IF;
1147: EXIT WHEN (i = p_tqdv_tbl.LAST);
1140: p_tqdv_rec => p_tqdv_tbl(i),
1141: x_tqdv_rec => x_tqdv_tbl(i));
1142: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1143: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1144: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1145: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1146: END IF;
1147: EXIT WHEN (i = p_tqdv_tbl.LAST);
1148: i := p_tqdv_tbl.NEXT(i);
1141: x_tqdv_rec => x_tqdv_tbl(i));
1142: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1143: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1144: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1145: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1146: END IF;
1147: EXIT WHEN (i = p_tqdv_tbl.LAST);
1148: i := p_tqdv_tbl.NEXT(i);
1149: END LOOP;
1380: x_return_status => x_return_status,
1381: x_msg_count => x_msg_count,
1382: x_msg_data => x_msg_data,
1383: p_tqdv_rec => p_tqdv_tbl(i));
1384: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1385: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1387: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1388: END IF;
1381: x_msg_count => x_msg_count,
1382: x_msg_data => x_msg_data,
1383: p_tqdv_rec => p_tqdv_tbl(i));
1384: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1385: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1387: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1388: END IF;
1389: EXIT WHEN (i = p_tqdv_tbl.LAST);
1382: x_msg_data => x_msg_data,
1383: p_tqdv_rec => p_tqdv_tbl(i));
1384: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1385: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1387: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1388: END IF;
1389: EXIT WHEN (i = p_tqdv_tbl.LAST);
1390: i := p_tqdv_tbl.NEXT(i);
1383: p_tqdv_rec => p_tqdv_tbl(i));
1384: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1385: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1387: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1388: END IF;
1389: EXIT WHEN (i = p_tqdv_tbl.LAST);
1390: i := p_tqdv_tbl.NEXT(i);
1391: END LOOP;
1737: IF (x_tqdv_rec.id = OKC_API.G_MISS_NUM)
1738: THEN
1739: x_tqdv_rec.id := l_db_tqdv_rec.id;
1740: END IF;
1741: IF (x_tqdv_rec.object_version_number = OKL_API.G_MISS_NUM)
1742: THEN
1743: x_tqdv_rec.object_version_number := l_db_tqdv_rec.object_version_number;
1744: END IF;
1745: IF (x_tqdv_rec.number_of_units = OKC_API.G_MISS_NUM)
2008: x_msg_count => x_msg_count,
2009: x_msg_data => x_msg_data,
2010: p_tqdv_rec => p_tqdv_tbl(i),
2011: x_tqdv_rec => x_tqdv_tbl(i));
2012: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2013: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2014: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2015: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2016: END IF;
2009: x_msg_data => x_msg_data,
2010: p_tqdv_rec => p_tqdv_tbl(i),
2011: x_tqdv_rec => x_tqdv_tbl(i));
2012: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2013: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2014: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2015: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2016: END IF;
2017: EXIT WHEN (i = p_tqdv_tbl.LAST);
2010: p_tqdv_rec => p_tqdv_tbl(i),
2011: x_tqdv_rec => x_tqdv_tbl(i));
2012: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2013: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2014: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2015: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2016: END IF;
2017: EXIT WHEN (i = p_tqdv_tbl.LAST);
2018: i := p_tqdv_tbl.NEXT(i);
2011: x_tqdv_rec => x_tqdv_tbl(i));
2012: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2013: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2014: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2015: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2016: END IF;
2017: EXIT WHEN (i = p_tqdv_tbl.LAST);
2018: i := p_tqdv_tbl.NEXT(i);
2019: END LOOP;
2207: x_return_status => x_return_status,
2208: x_msg_count => x_msg_count,
2209: x_msg_data => x_msg_data,
2210: p_tqdv_rec => p_tqdv_tbl(i));
2211: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2212: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2214: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2215: END IF;
2208: x_msg_count => x_msg_count,
2209: x_msg_data => x_msg_data,
2210: p_tqdv_rec => p_tqdv_tbl(i));
2211: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2212: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2214: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2215: END IF;
2216: EXIT WHEN (i = p_tqdv_tbl.LAST);
2209: x_msg_data => x_msg_data,
2210: p_tqdv_rec => p_tqdv_tbl(i));
2211: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2212: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2214: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2215: END IF;
2216: EXIT WHEN (i = p_tqdv_tbl.LAST);
2217: i := p_tqdv_tbl.NEXT(i);
2210: p_tqdv_rec => p_tqdv_tbl(i));
2211: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2212: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2214: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2215: END IF;
2216: EXIT WHEN (i = p_tqdv_tbl.LAST);
2217: i := p_tqdv_tbl.NEXT(i);
2218: END LOOP;