[Home] [Help]
34: null;
35: END api_copy;
36:
37: ---------------------------------------------------------------------------
38: -- FUNCTION get_rec for: OKC_TIMEVALUES_B
39: ---------------------------------------------------------------------------
40: FUNCTION get_rec (
41: p_tve_rec IN tve_rec_type,
42: x_no_data_found OUT NOCOPY BOOLEAN
94: ATTRIBUTE12,
95: ATTRIBUTE13,
96: ATTRIBUTE14,
97: ATTRIBUTE15
98: FROM Okc_Timevalues
99: WHERE okc_timevalues.id = p_id;
100: l_tve_pk tve_pk_csr%ROWTYPE;
101: l_tve_rec tve_rec_type;
102: BEGIN
95: ATTRIBUTE13,
96: ATTRIBUTE14,
97: ATTRIBUTE15
98: FROM Okc_Timevalues
99: WHERE okc_timevalues.id = p_id;
100: l_tve_pk tve_pk_csr%ROWTYPE;
101: l_tve_rec tve_rec_type;
102: BEGIN
103: x_no_data_found := TRUE;
168: BEGIN
169: RETURN(get_rec(p_tve_rec, l_row_notfound));
170: END get_rec;
171: ---------------------------------------------------------------------------
172: -- FUNCTION get_rec for: OKC_TIMEVALUES_TL
173: ---------------------------------------------------------------------------
174: --Bug 3122962
175: /*
176: FUNCTION get_rec (
173: ---------------------------------------------------------------------------
174: --Bug 3122962
175: /*
176: FUNCTION get_rec (
177: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
178: x_no_data_found OUT NOCOPY BOOLEAN
179: ) RETURN okc_timevalues_tl_rec_type IS
180: CURSOR tve_pktl_csr (p_id IN NUMBER,
181: p_language IN VARCHAR2) IS
175: /*
176: FUNCTION get_rec (
177: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
178: x_no_data_found OUT NOCOPY BOOLEAN
179: ) RETURN okc_timevalues_tl_rec_type IS
180: CURSOR tve_pktl_csr (p_id IN NUMBER,
181: p_language IN VARCHAR2) IS
182: SELECT
183: ID,
192: CREATION_DATE,
193: LAST_UPDATED_BY,
194: LAST_UPDATE_DATE,
195: LAST_UPDATE_LOGIN
196: FROM Okc_Timevalues_Tl
197: WHERE okc_timevalues_tl.id = p_id
198: AND okc_timevalues_tl.language = p_language;
199: l_tve_pktl tve_pktl_csr%ROWTYPE;
200: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
193: LAST_UPDATED_BY,
194: LAST_UPDATE_DATE,
195: LAST_UPDATE_LOGIN
196: FROM Okc_Timevalues_Tl
197: WHERE okc_timevalues_tl.id = p_id
198: AND okc_timevalues_tl.language = p_language;
199: l_tve_pktl tve_pktl_csr%ROWTYPE;
200: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
201: BEGIN
194: LAST_UPDATE_DATE,
195: LAST_UPDATE_LOGIN
196: FROM Okc_Timevalues_Tl
197: WHERE okc_timevalues_tl.id = p_id
198: AND okc_timevalues_tl.language = p_language;
199: l_tve_pktl tve_pktl_csr%ROWTYPE;
200: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
201: BEGIN
202: x_no_data_found := TRUE;
196: FROM Okc_Timevalues_Tl
197: WHERE okc_timevalues_tl.id = p_id
198: AND okc_timevalues_tl.language = p_language;
199: l_tve_pktl tve_pktl_csr%ROWTYPE;
200: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
201: BEGIN
202: x_no_data_found := TRUE;
203: -- Get current database values
204: OPEN tve_pktl_csr (p_okc_timevalues_tl_rec.id,
200: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
201: BEGIN
202: x_no_data_found := TRUE;
203: -- Get current database values
204: OPEN tve_pktl_csr (p_okc_timevalues_tl_rec.id,
205: p_okc_timevalues_tl_rec.language);
206: FETCH tve_pktl_csr INTO
207: l_okc_timevalues_tl_rec.ID,
208: l_okc_timevalues_tl_rec.LANGUAGE,
201: BEGIN
202: x_no_data_found := TRUE;
203: -- Get current database values
204: OPEN tve_pktl_csr (p_okc_timevalues_tl_rec.id,
205: p_okc_timevalues_tl_rec.language);
206: FETCH tve_pktl_csr INTO
207: l_okc_timevalues_tl_rec.ID,
208: l_okc_timevalues_tl_rec.LANGUAGE,
209: l_okc_timevalues_tl_rec.SOURCE_LANG,
203: -- Get current database values
204: OPEN tve_pktl_csr (p_okc_timevalues_tl_rec.id,
205: p_okc_timevalues_tl_rec.language);
206: FETCH tve_pktl_csr INTO
207: l_okc_timevalues_tl_rec.ID,
208: l_okc_timevalues_tl_rec.LANGUAGE,
209: l_okc_timevalues_tl_rec.SOURCE_LANG,
210: l_okc_timevalues_tl_rec.SFWT_FLAG,
211: l_okc_timevalues_tl_rec.DESCRIPTION,
204: OPEN tve_pktl_csr (p_okc_timevalues_tl_rec.id,
205: p_okc_timevalues_tl_rec.language);
206: FETCH tve_pktl_csr INTO
207: l_okc_timevalues_tl_rec.ID,
208: l_okc_timevalues_tl_rec.LANGUAGE,
209: l_okc_timevalues_tl_rec.SOURCE_LANG,
210: l_okc_timevalues_tl_rec.SFWT_FLAG,
211: l_okc_timevalues_tl_rec.DESCRIPTION,
212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,
205: p_okc_timevalues_tl_rec.language);
206: FETCH tve_pktl_csr INTO
207: l_okc_timevalues_tl_rec.ID,
208: l_okc_timevalues_tl_rec.LANGUAGE,
209: l_okc_timevalues_tl_rec.SOURCE_LANG,
210: l_okc_timevalues_tl_rec.SFWT_FLAG,
211: l_okc_timevalues_tl_rec.DESCRIPTION,
212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,
213: l_okc_timevalues_tl_rec.COMMENTS,
206: FETCH tve_pktl_csr INTO
207: l_okc_timevalues_tl_rec.ID,
208: l_okc_timevalues_tl_rec.LANGUAGE,
209: l_okc_timevalues_tl_rec.SOURCE_LANG,
210: l_okc_timevalues_tl_rec.SFWT_FLAG,
211: l_okc_timevalues_tl_rec.DESCRIPTION,
212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,
213: l_okc_timevalues_tl_rec.COMMENTS,
214: l_okc_timevalues_tl_rec.NAME,
207: l_okc_timevalues_tl_rec.ID,
208: l_okc_timevalues_tl_rec.LANGUAGE,
209: l_okc_timevalues_tl_rec.SOURCE_LANG,
210: l_okc_timevalues_tl_rec.SFWT_FLAG,
211: l_okc_timevalues_tl_rec.DESCRIPTION,
212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,
213: l_okc_timevalues_tl_rec.COMMENTS,
214: l_okc_timevalues_tl_rec.NAME,
215: l_okc_timevalues_tl_rec.CREATED_BY,
208: l_okc_timevalues_tl_rec.LANGUAGE,
209: l_okc_timevalues_tl_rec.SOURCE_LANG,
210: l_okc_timevalues_tl_rec.SFWT_FLAG,
211: l_okc_timevalues_tl_rec.DESCRIPTION,
212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,
213: l_okc_timevalues_tl_rec.COMMENTS,
214: l_okc_timevalues_tl_rec.NAME,
215: l_okc_timevalues_tl_rec.CREATED_BY,
216: l_okc_timevalues_tl_rec.CREATION_DATE,
209: l_okc_timevalues_tl_rec.SOURCE_LANG,
210: l_okc_timevalues_tl_rec.SFWT_FLAG,
211: l_okc_timevalues_tl_rec.DESCRIPTION,
212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,
213: l_okc_timevalues_tl_rec.COMMENTS,
214: l_okc_timevalues_tl_rec.NAME,
215: l_okc_timevalues_tl_rec.CREATED_BY,
216: l_okc_timevalues_tl_rec.CREATION_DATE,
217: l_okc_timevalues_tl_rec.LAST_UPDATED_BY,
210: l_okc_timevalues_tl_rec.SFWT_FLAG,
211: l_okc_timevalues_tl_rec.DESCRIPTION,
212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,
213: l_okc_timevalues_tl_rec.COMMENTS,
214: l_okc_timevalues_tl_rec.NAME,
215: l_okc_timevalues_tl_rec.CREATED_BY,
216: l_okc_timevalues_tl_rec.CREATION_DATE,
217: l_okc_timevalues_tl_rec.LAST_UPDATED_BY,
218: l_okc_timevalues_tl_rec.LAST_UPDATE_DATE,
211: l_okc_timevalues_tl_rec.DESCRIPTION,
212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,
213: l_okc_timevalues_tl_rec.COMMENTS,
214: l_okc_timevalues_tl_rec.NAME,
215: l_okc_timevalues_tl_rec.CREATED_BY,
216: l_okc_timevalues_tl_rec.CREATION_DATE,
217: l_okc_timevalues_tl_rec.LAST_UPDATED_BY,
218: l_okc_timevalues_tl_rec.LAST_UPDATE_DATE,
219: l_okc_timevalues_tl_rec.LAST_UPDATE_LOGIN;
212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,
213: l_okc_timevalues_tl_rec.COMMENTS,
214: l_okc_timevalues_tl_rec.NAME,
215: l_okc_timevalues_tl_rec.CREATED_BY,
216: l_okc_timevalues_tl_rec.CREATION_DATE,
217: l_okc_timevalues_tl_rec.LAST_UPDATED_BY,
218: l_okc_timevalues_tl_rec.LAST_UPDATE_DATE,
219: l_okc_timevalues_tl_rec.LAST_UPDATE_LOGIN;
220: x_no_data_found := tve_pktl_csr%NOTFOUND;
213: l_okc_timevalues_tl_rec.COMMENTS,
214: l_okc_timevalues_tl_rec.NAME,
215: l_okc_timevalues_tl_rec.CREATED_BY,
216: l_okc_timevalues_tl_rec.CREATION_DATE,
217: l_okc_timevalues_tl_rec.LAST_UPDATED_BY,
218: l_okc_timevalues_tl_rec.LAST_UPDATE_DATE,
219: l_okc_timevalues_tl_rec.LAST_UPDATE_LOGIN;
220: x_no_data_found := tve_pktl_csr%NOTFOUND;
221: CLOSE tve_pktl_csr;
214: l_okc_timevalues_tl_rec.NAME,
215: l_okc_timevalues_tl_rec.CREATED_BY,
216: l_okc_timevalues_tl_rec.CREATION_DATE,
217: l_okc_timevalues_tl_rec.LAST_UPDATED_BY,
218: l_okc_timevalues_tl_rec.LAST_UPDATE_DATE,
219: l_okc_timevalues_tl_rec.LAST_UPDATE_LOGIN;
220: x_no_data_found := tve_pktl_csr%NOTFOUND;
221: CLOSE tve_pktl_csr;
222: RETURN(l_okc_timevalues_tl_rec);
215: l_okc_timevalues_tl_rec.CREATED_BY,
216: l_okc_timevalues_tl_rec.CREATION_DATE,
217: l_okc_timevalues_tl_rec.LAST_UPDATED_BY,
218: l_okc_timevalues_tl_rec.LAST_UPDATE_DATE,
219: l_okc_timevalues_tl_rec.LAST_UPDATE_LOGIN;
220: x_no_data_found := tve_pktl_csr%NOTFOUND;
221: CLOSE tve_pktl_csr;
222: RETURN(l_okc_timevalues_tl_rec);
223: END get_rec;
218: l_okc_timevalues_tl_rec.LAST_UPDATE_DATE,
219: l_okc_timevalues_tl_rec.LAST_UPDATE_LOGIN;
220: x_no_data_found := tve_pktl_csr%NOTFOUND;
221: CLOSE tve_pktl_csr;
222: RETURN(l_okc_timevalues_tl_rec);
223: END get_rec;
224:
225: FUNCTION get_rec (
226: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type
222: RETURN(l_okc_timevalues_tl_rec);
223: END get_rec;
224:
225: FUNCTION get_rec (
226: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type
227: ) RETURN okc_timevalues_tl_rec_type IS
228: l_row_notfound BOOLEAN := TRUE;
229: BEGIN
230: RETURN(get_rec(p_okc_timevalues_tl_rec, l_row_notfound));
223: END get_rec;
224:
225: FUNCTION get_rec (
226: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type
227: ) RETURN okc_timevalues_tl_rec_type IS
228: l_row_notfound BOOLEAN := TRUE;
229: BEGIN
230: RETURN(get_rec(p_okc_timevalues_tl_rec, l_row_notfound));
231: END get_rec;
226: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type
227: ) RETURN okc_timevalues_tl_rec_type IS
228: l_row_notfound BOOLEAN := TRUE;
229: BEGIN
230: RETURN(get_rec(p_okc_timevalues_tl_rec, l_row_notfound));
231: END get_rec;
232: */
233: ---------------------------------------------------------------------------
234: -- FUNCTION get_rec for: OKC_TIME_IG_STARTEND_V
431: END null_out_defaults;
432:
433: --**** Change from TAPI Code---follow till end of change---------------
434: ------------------------------------------------------
435: -- FUNCTION null_out_defaults for: OKC_TIMEVALUES_V --
436: ------------------------------------------------------
437: -- 1. Added null_out_defaults to overcome number initialization
438: -- problem while populating optional columns for supertypes from a subtype
439: -- 2. Moved all column validations (including FK) to Validate_column
513: RETURN(l_tve_rec);
514: END null_out_defaults;
515: /*
516: FUNCTION null_out_defaults (
517: p_tve_tl_rec IN okc_timevalues_tl_rec_type
518: ) RETURN okc_timevalues_tl_rec_type IS
519: l_tve_tl_rec okc_timevalues_tl_rec_type := p_tve_tl_rec;
520: BEGIN
521: RETURN(l_tve_tl_rec);
514: END null_out_defaults;
515: /*
516: FUNCTION null_out_defaults (
517: p_tve_tl_rec IN okc_timevalues_tl_rec_type
518: ) RETURN okc_timevalues_tl_rec_type IS
519: l_tve_tl_rec okc_timevalues_tl_rec_type := p_tve_tl_rec;
520: BEGIN
521: RETURN(l_tve_tl_rec);
522: END null_out_defaults;
515: /*
516: FUNCTION null_out_defaults (
517: p_tve_tl_rec IN okc_timevalues_tl_rec_type
518: ) RETURN okc_timevalues_tl_rec_type IS
519: l_tve_tl_rec okc_timevalues_tl_rec_type := p_tve_tl_rec;
520: BEGIN
521: RETURN(l_tve_tl_rec);
522: END null_out_defaults;
523: */
578: item_not_found_error EXCEPTION;
579: l_row_notfound BOOLEAN := TRUE;
580: CURSOR okc_tvev_pk_csr (p_id IN NUMBER) IS
581: SELECT '1'
582: FROM OKC_TIMEVALUES
583: WHERE id = p_id
584: AND TVE_TYPE IN ('TGD', 'TGN');
585: l_okc_tvev_pk okc_tvev_pk_csr%ROWTYPE;
586: BEGIN
623: item_not_found_error EXCEPTION;
624: l_row_notfound BOOLEAN := TRUE;
625: CURSOR okc_tvev_pk_csr (p_id IN NUMBER) IS
626: SELECT '1'
627: FROM OKC_TIMEVALUES
628: WHERE id = p_id
629: AND TVE_TYPE IN ('TGD', 'TGN');
630: l_okc_tvev_pk okc_tvev_pk_csr%ROWTYPE;
631: BEGIN
667: item_not_found_error EXCEPTION;
668: l_row_notfound BOOLEAN := TRUE;
669: CURSOR okc_tvev_pk_csr (p_id IN NUMBER) IS
670: SELECT '1'
671: FROM Okc_Timevalues
672: WHERE id = p_id
673: and tve_type in ('ISE','IGS');
674: l_okc_tvev_pk okc_tvev_pk_csr%ROWTYPE;
675: BEGIN
986: END migrate;
987: --Bug 3122962
988: /* PROCEDURE migrate (
989: p_from IN igsv_rec_type,
990: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type
991: ) IS
992: l_tve_tl_type okc_timevalues_tl_rec_type;
993: BEGIN
994: p_to.id := p_from.id;
988: /* PROCEDURE migrate (
989: p_from IN igsv_rec_type,
990: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type
991: ) IS
992: l_tve_tl_type okc_timevalues_tl_rec_type;
993: BEGIN
994: p_to.id := p_from.id;
995: p_to.sfwt_flag := p_from.sfwt_flag;
996: p_to.description := p_from.description;
1007: p_to := l_tve_tl_type;
1008: END migrate;
1009:
1010: PROCEDURE migrate (
1011: p_from IN okc_timevalues_tl_rec_type,
1012: p_to IN OUT NOCOPY igsv_rec_type
1013: ) IS
1014: BEGIN
1015: p_to.id := p_from.id;
1042: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1043: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1044: l_igsv_rec igsv_rec_type := p_igsv_rec;
1045: l_tve_rec tve_rec_type;
1046: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1047: BEGIN
1048: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1049: G_PKG_NAME,
1050: p_init_msg_list,
1171: ---------------------------------------------------------------------------
1172: -- PROCEDURE insert_row
1173: ---------------------------------------------------------------------------
1174: -------------------------------------
1175: -- insert_row for:OKC_TIMEVALUES_B --
1176: -------------------------------------
1177: PROCEDURE insert_row(
1178: p_init_msg_list IN VARCHAR2 ,
1179: x_return_status OUT NOCOPY VARCHAR2,
1187: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1188: l_tve_rec tve_rec_type := p_tve_rec;
1189: l_def_tve_rec tve_rec_type;
1190: -----------------------------------------
1191: -- Set_Attributes for:OKC_TIMEVALUES_B --
1192: -----------------------------------------
1193: FUNCTION Set_Attributes (
1194: p_tve_rec IN tve_rec_type,
1195: x_tve_rec OUT NOCOPY tve_rec_type
1218: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1219: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1220: RAISE OKC_API.G_EXCEPTION_ERROR;
1221: END IF;
1222: INSERT INTO OKC_TIMEVALUES(
1223: id,
1224: spn_id,
1225: tve_id_offset,
1226: uom_code,
1358: '_PVT'
1359: );
1360: END insert_row;
1361: --------------------------------------
1362: -- insert_row for:OKC_TIMEVALUES_TL --
1363: --------------------------------------
1364: --Bug 3122962
1365: /* PROCEDURE insert_row(
1366: p_init_msg_list IN VARCHAR2 ,
1366: p_init_msg_list IN VARCHAR2 ,
1367: x_return_status OUT NOCOPY VARCHAR2,
1368: x_msg_count OUT NOCOPY NUMBER,
1369: x_msg_data OUT NOCOPY VARCHAR2,
1370: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1371: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
1372:
1373: l_api_version CONSTANT NUMBER := 1;
1374: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1367: x_return_status OUT NOCOPY VARCHAR2,
1368: x_msg_count OUT NOCOPY NUMBER,
1369: x_msg_data OUT NOCOPY VARCHAR2,
1370: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1371: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
1372:
1373: l_api_version CONSTANT NUMBER := 1;
1374: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1375: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1372:
1373: l_api_version CONSTANT NUMBER := 1;
1374: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1375: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1376: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
1377: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1378: CURSOR get_languages IS
1379: SELECT *
1380: FROM FND_LANGUAGES
1373: l_api_version CONSTANT NUMBER := 1;
1374: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1375: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1376: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
1377: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1378: CURSOR get_languages IS
1379: SELECT *
1380: FROM FND_LANGUAGES
1381: WHERE INSTALLED_FLAG IN ('I', 'B');
1379: SELECT *
1380: FROM FND_LANGUAGES
1381: WHERE INSTALLED_FLAG IN ('I', 'B');
1382: ------------------------------------------
1383: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1384: ------------------------------------------
1385: FUNCTION Set_Attributes (
1386: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1387: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1382: ------------------------------------------
1383: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1384: ------------------------------------------
1385: FUNCTION Set_Attributes (
1386: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1387: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1388: ) RETURN VARCHAR2 IS
1389: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1390: BEGIN
1383: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1384: ------------------------------------------
1385: FUNCTION Set_Attributes (
1386: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1387: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1388: ) RETURN VARCHAR2 IS
1389: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1390: BEGIN
1391: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1387: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1388: ) RETURN VARCHAR2 IS
1389: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1390: BEGIN
1391: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1392: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1393: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1394: RETURN(l_return_status);
1395: END Set_Attributes;
1388: ) RETURN VARCHAR2 IS
1389: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1390: BEGIN
1391: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1392: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1393: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1394: RETURN(l_return_status);
1395: END Set_Attributes;
1396: BEGIN
1389: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1390: BEGIN
1391: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1392: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1393: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1394: RETURN(l_return_status);
1395: END Set_Attributes;
1396: BEGIN
1397: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1404: RAISE OKC_API.G_EXCEPTION_ERROR;
1405: END IF;
1406: --- Setting item attributes
1407: l_return_status := Set_Attributes(
1408: p_okc_timevalues_tl_rec, -- IN
1409: l_okc_timevalues_tl_rec); -- OUT
1410: --- If any errors happen abort API
1411: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1412: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1405: END IF;
1406: --- Setting item attributes
1407: l_return_status := Set_Attributes(
1408: p_okc_timevalues_tl_rec, -- IN
1409: l_okc_timevalues_tl_rec); -- OUT
1410: --- If any errors happen abort API
1411: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1412: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1413: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1413: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1414: RAISE OKC_API.G_EXCEPTION_ERROR;
1415: END IF;
1416: FOR l_lang_rec IN get_languages LOOP
1417: l_okc_timevalues_tl_rec.language := l_lang_rec.language_code;
1418: INSERT INTO OKC_TIMEVALUES_TL(
1419: id,
1420: language,
1421: source_lang,
1414: RAISE OKC_API.G_EXCEPTION_ERROR;
1415: END IF;
1416: FOR l_lang_rec IN get_languages LOOP
1417: l_okc_timevalues_tl_rec.language := l_lang_rec.language_code;
1418: INSERT INTO OKC_TIMEVALUES_TL(
1419: id,
1420: language,
1421: source_lang,
1422: sfwt_flag,
1429: last_updated_by,
1430: last_update_date,
1431: last_update_login)
1432: VALUES (
1433: l_okc_timevalues_tl_rec.id,
1434: l_okc_timevalues_tl_rec.language,
1435: l_okc_timevalues_tl_rec.source_lang,
1436: l_okc_timevalues_tl_rec.sfwt_flag,
1437: l_okc_timevalues_tl_rec.description,
1430: last_update_date,
1431: last_update_login)
1432: VALUES (
1433: l_okc_timevalues_tl_rec.id,
1434: l_okc_timevalues_tl_rec.language,
1435: l_okc_timevalues_tl_rec.source_lang,
1436: l_okc_timevalues_tl_rec.sfwt_flag,
1437: l_okc_timevalues_tl_rec.description,
1438: l_okc_timevalues_tl_rec.short_description,
1431: last_update_login)
1432: VALUES (
1433: l_okc_timevalues_tl_rec.id,
1434: l_okc_timevalues_tl_rec.language,
1435: l_okc_timevalues_tl_rec.source_lang,
1436: l_okc_timevalues_tl_rec.sfwt_flag,
1437: l_okc_timevalues_tl_rec.description,
1438: l_okc_timevalues_tl_rec.short_description,
1439: l_okc_timevalues_tl_rec.comments,
1432: VALUES (
1433: l_okc_timevalues_tl_rec.id,
1434: l_okc_timevalues_tl_rec.language,
1435: l_okc_timevalues_tl_rec.source_lang,
1436: l_okc_timevalues_tl_rec.sfwt_flag,
1437: l_okc_timevalues_tl_rec.description,
1438: l_okc_timevalues_tl_rec.short_description,
1439: l_okc_timevalues_tl_rec.comments,
1440: l_okc_timevalues_tl_rec.name,
1433: l_okc_timevalues_tl_rec.id,
1434: l_okc_timevalues_tl_rec.language,
1435: l_okc_timevalues_tl_rec.source_lang,
1436: l_okc_timevalues_tl_rec.sfwt_flag,
1437: l_okc_timevalues_tl_rec.description,
1438: l_okc_timevalues_tl_rec.short_description,
1439: l_okc_timevalues_tl_rec.comments,
1440: l_okc_timevalues_tl_rec.name,
1441: l_okc_timevalues_tl_rec.created_by,
1434: l_okc_timevalues_tl_rec.language,
1435: l_okc_timevalues_tl_rec.source_lang,
1436: l_okc_timevalues_tl_rec.sfwt_flag,
1437: l_okc_timevalues_tl_rec.description,
1438: l_okc_timevalues_tl_rec.short_description,
1439: l_okc_timevalues_tl_rec.comments,
1440: l_okc_timevalues_tl_rec.name,
1441: l_okc_timevalues_tl_rec.created_by,
1442: l_okc_timevalues_tl_rec.creation_date,
1435: l_okc_timevalues_tl_rec.source_lang,
1436: l_okc_timevalues_tl_rec.sfwt_flag,
1437: l_okc_timevalues_tl_rec.description,
1438: l_okc_timevalues_tl_rec.short_description,
1439: l_okc_timevalues_tl_rec.comments,
1440: l_okc_timevalues_tl_rec.name,
1441: l_okc_timevalues_tl_rec.created_by,
1442: l_okc_timevalues_tl_rec.creation_date,
1443: l_okc_timevalues_tl_rec.last_updated_by,
1436: l_okc_timevalues_tl_rec.sfwt_flag,
1437: l_okc_timevalues_tl_rec.description,
1438: l_okc_timevalues_tl_rec.short_description,
1439: l_okc_timevalues_tl_rec.comments,
1440: l_okc_timevalues_tl_rec.name,
1441: l_okc_timevalues_tl_rec.created_by,
1442: l_okc_timevalues_tl_rec.creation_date,
1443: l_okc_timevalues_tl_rec.last_updated_by,
1444: l_okc_timevalues_tl_rec.last_update_date,
1437: l_okc_timevalues_tl_rec.description,
1438: l_okc_timevalues_tl_rec.short_description,
1439: l_okc_timevalues_tl_rec.comments,
1440: l_okc_timevalues_tl_rec.name,
1441: l_okc_timevalues_tl_rec.created_by,
1442: l_okc_timevalues_tl_rec.creation_date,
1443: l_okc_timevalues_tl_rec.last_updated_by,
1444: l_okc_timevalues_tl_rec.last_update_date,
1445: l_okc_timevalues_tl_rec.last_update_login);
1438: l_okc_timevalues_tl_rec.short_description,
1439: l_okc_timevalues_tl_rec.comments,
1440: l_okc_timevalues_tl_rec.name,
1441: l_okc_timevalues_tl_rec.created_by,
1442: l_okc_timevalues_tl_rec.creation_date,
1443: l_okc_timevalues_tl_rec.last_updated_by,
1444: l_okc_timevalues_tl_rec.last_update_date,
1445: l_okc_timevalues_tl_rec.last_update_login);
1446: END LOOP;
1439: l_okc_timevalues_tl_rec.comments,
1440: l_okc_timevalues_tl_rec.name,
1441: l_okc_timevalues_tl_rec.created_by,
1442: l_okc_timevalues_tl_rec.creation_date,
1443: l_okc_timevalues_tl_rec.last_updated_by,
1444: l_okc_timevalues_tl_rec.last_update_date,
1445: l_okc_timevalues_tl_rec.last_update_login);
1446: END LOOP;
1447: -- Set OUT values
1440: l_okc_timevalues_tl_rec.name,
1441: l_okc_timevalues_tl_rec.created_by,
1442: l_okc_timevalues_tl_rec.creation_date,
1443: l_okc_timevalues_tl_rec.last_updated_by,
1444: l_okc_timevalues_tl_rec.last_update_date,
1445: l_okc_timevalues_tl_rec.last_update_login);
1446: END LOOP;
1447: -- Set OUT values
1448: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;
1441: l_okc_timevalues_tl_rec.created_by,
1442: l_okc_timevalues_tl_rec.creation_date,
1443: l_okc_timevalues_tl_rec.last_updated_by,
1444: l_okc_timevalues_tl_rec.last_update_date,
1445: l_okc_timevalues_tl_rec.last_update_login);
1446: END LOOP;
1447: -- Set OUT values
1448: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;
1449: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1444: l_okc_timevalues_tl_rec.last_update_date,
1445: l_okc_timevalues_tl_rec.last_update_login);
1446: END LOOP;
1447: -- Set OUT values
1448: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;
1449: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1450: EXCEPTION
1451: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1452: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1498: l_igsv_rec igsv_rec_type;
1499: l_def_igsv_rec igsv_rec_type;
1500: l_tve_rec tve_rec_type;
1501: lx_tve_rec tve_rec_type;
1502: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1503: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1504: -------------------------------
1505: -- FUNCTION fill_who_columns --
1506: -------------------------------
1499: l_def_igsv_rec igsv_rec_type;
1500: l_tve_rec tve_rec_type;
1501: lx_tve_rec tve_rec_type;
1502: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1503: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1504: -------------------------------
1505: -- FUNCTION fill_who_columns --
1506: -------------------------------
1507: FUNCTION fill_who_columns (
1574: --------------------------------------
1575: -- Move VIEW record to "Child" records
1576: --------------------------------------
1577: migrate(l_def_igsv_rec, l_tve_rec);
1578: --Bug 3122962 migrate(l_def_igsv_rec, l_okc_timevalues_tl_rec);
1579: --------------------------------------------
1580: -- Call the INSERT_ROW for each child record
1581: --------------------------------------------
1582: insert_row(
1597: p_init_msg_list,
1598: x_return_status,
1599: x_msg_count,
1600: x_msg_data,
1601: l_okc_timevalues_tl_rec,
1602: lx_okc_timevalues_tl_rec
1603: );
1604: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1598: x_return_status,
1599: x_msg_count,
1600: x_msg_data,
1601: l_okc_timevalues_tl_rec,
1602: lx_okc_timevalues_tl_rec
1603: );
1604: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1606: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1606: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1607: RAISE OKC_API.G_EXCEPTION_ERROR;
1608: END IF;
1609: migrate(lx_okc_timevalues_tl_rec, l_def_igsv_rec);
1610: */ -- Set OUT values
1611: x_igsv_rec := l_def_igsv_rec;
1612: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1613: EXCEPTION
1711: ---------------------------------------------------------------------------
1712: -- PROCEDURE lock_row
1713: ---------------------------------------------------------------------------
1714: -----------------------------------
1715: -- lock_row for:OKC_TIMEVALUES_B --
1716: -----------------------------------
1717: PROCEDURE lock_row(
1718: p_init_msg_list IN VARCHAR2 ,
1719: x_return_status OUT NOCOPY VARCHAR2,
1724: E_Resource_Busy EXCEPTION;
1725: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1726: CURSOR lock_csr (p_tve_rec IN tve_rec_type) IS
1727: SELECT OBJECT_VERSION_NUMBER
1728: FROM OKC_TIMEVALUES
1729: WHERE ID = p_tve_rec.id
1730: AND OBJECT_VERSION_NUMBER = p_tve_rec.object_version_number
1731: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1732:
1731: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1732:
1733: CURSOR lchk_csr (p_tve_rec IN tve_rec_type) IS
1734: SELECT OBJECT_VERSION_NUMBER
1735: FROM OKC_TIMEVALUES
1736: WHERE ID = p_tve_rec.id;
1737: l_api_version CONSTANT NUMBER := 1;
1738: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1739: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1736: WHERE ID = p_tve_rec.id;
1737: l_api_version CONSTANT NUMBER := 1;
1738: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1739: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1740: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1741: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1742: l_row_notfound BOOLEAN := FALSE;
1743: lc_row_notfound BOOLEAN := FALSE;
1744: BEGIN
1737: l_api_version CONSTANT NUMBER := 1;
1738: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1739: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1740: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1741: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1742: l_row_notfound BOOLEAN := FALSE;
1743: lc_row_notfound BOOLEAN := FALSE;
1744: BEGIN
1745: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1817: '_PVT'
1818: );
1819: END lock_row;
1820: ------------------------------------
1821: -- lock_row for:OKC_TIMEVALUES_TL --
1822: ------------------------------------
1823: /*
1824: PROCEDURE lock_row(
1825: p_init_msg_list IN VARCHAR2 ,
1825: p_init_msg_list IN VARCHAR2 ,
1826: x_return_status OUT NOCOPY VARCHAR2,
1827: x_msg_count OUT NOCOPY NUMBER,
1828: x_msg_data OUT NOCOPY VARCHAR2,
1829: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1830:
1831: E_Resource_Busy EXCEPTION;
1832: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1833: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1829: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1830:
1831: E_Resource_Busy EXCEPTION;
1832: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1833: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1834: SELECT id
1835: FROM OKC_TIMEVALUES_TL
1836: WHERE ID = p_okc_timevalues_tl_rec.id
1837: FOR UPDATE NOWAIT;
1831: E_Resource_Busy EXCEPTION;
1832: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1833: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1834: SELECT id
1835: FROM OKC_TIMEVALUES_TL
1836: WHERE ID = p_okc_timevalues_tl_rec.id
1837: FOR UPDATE NOWAIT;
1838:
1839: l_api_version CONSTANT NUMBER := 1;
1832: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1833: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1834: SELECT id
1835: FROM OKC_TIMEVALUES_TL
1836: WHERE ID = p_okc_timevalues_tl_rec.id
1837: FOR UPDATE NOWAIT;
1838:
1839: l_api_version CONSTANT NUMBER := 1;
1840: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';
1852: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1853: RAISE OKC_API.G_EXCEPTION_ERROR;
1854: END IF;
1855: BEGIN
1856: OPEN lock_csr(p_okc_timevalues_tl_rec);
1857: FETCH lock_csr INTO l_lock_var;
1858: l_row_notfound := lock_csr%NOTFOUND;
1859: CLOSE lock_csr;
1860: EXCEPTION
1918: l_api_version CONSTANT NUMBER := 1;
1919: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1920: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1921: l_tve_rec tve_rec_type;
1922: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1923: BEGIN
1924: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1925: G_PKG_NAME,
1926: p_init_msg_list,
1936: --------------------------------------
1937: -- Move VIEW record to "Child" records
1938: --------------------------------------
1939: migrate(p_igsv_rec, l_tve_rec);
1940: --Bug 3122962 migrate(p_igsv_rec, l_okc_timevalues_tl_rec);
1941: --------------------------------------------
1942: -- Call the LOCK_ROW for each child record
1943: --------------------------------------------
1944: lock_row(
1957: p_init_msg_list,
1958: x_return_status,
1959: x_msg_count,
1960: x_msg_data,
1961: l_okc_timevalues_tl_rec
1962: );
1963: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1964: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1965: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2066: ---------------------------------------------------------------------------
2067: -- PROCEDURE update_row
2068: ---------------------------------------------------------------------------
2069: -------------------------------------
2070: -- update_row for:OKC_TIMEVALUES_B --
2071: -------------------------------------
2072: PROCEDURE update_row(
2073: p_init_msg_list IN VARCHAR2 ,
2074: x_return_status OUT NOCOPY VARCHAR2,
2304:
2305: RETURN(l_return_status);
2306: END populate_new_record;
2307: -----------------------------------------
2308: -- Set_Attributes for:OKC_TIMEVALUES_B --
2309: -----------------------------------------
2310: FUNCTION Set_Attributes (
2311: p_tve_rec IN tve_rec_type,
2312: x_tve_rec OUT NOCOPY tve_rec_type
2341: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2342: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2343: RAISE OKC_API.G_EXCEPTION_ERROR;
2344: END IF;
2345: UPDATE OKC_TIMEVALUES
2346: SET SPN_ID = l_def_tve_rec.spn_id,
2347: TVE_ID_OFFSET = l_def_tve_rec.tve_id_offset,
2348: uom_code = l_def_tve_rec.uom_code,
2349: CNH_ID = l_def_tve_rec.cnh_id,
2428: '_PVT'
2429: );
2430: END update_row;
2431: --------------------------------------
2432: -- update_row for:OKC_TIMEVALUES_TL --
2433: --------------------------------------
2434: --Bug 3122962
2435: /* PROCEDURE update_row(
2436: p_init_msg_list IN VARCHAR2 ,
2436: p_init_msg_list IN VARCHAR2 ,
2437: x_return_status OUT NOCOPY VARCHAR2,
2438: x_msg_count OUT NOCOPY NUMBER,
2439: x_msg_data OUT NOCOPY VARCHAR2,
2440: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2441: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
2442:
2443: l_api_version CONSTANT NUMBER := 1;
2444: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2437: x_return_status OUT NOCOPY VARCHAR2,
2438: x_msg_count OUT NOCOPY NUMBER,
2439: x_msg_data OUT NOCOPY VARCHAR2,
2440: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2441: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
2442:
2443: l_api_version CONSTANT NUMBER := 1;
2444: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2445: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2442:
2443: l_api_version CONSTANT NUMBER := 1;
2444: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2445: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2446: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
2447: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2448: l_row_notfound BOOLEAN := TRUE;
2449: ----------------------------------
2450: -- FUNCTION populate_new_record --
2443: l_api_version CONSTANT NUMBER := 1;
2444: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2445: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2446: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
2447: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2448: l_row_notfound BOOLEAN := TRUE;
2449: ----------------------------------
2450: -- FUNCTION populate_new_record --
2451: ----------------------------------
2449: ----------------------------------
2450: -- FUNCTION populate_new_record --
2451: ----------------------------------
2452: FUNCTION populate_new_record (
2453: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2454: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2455: ) RETURN VARCHAR2 IS
2456: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2457: l_row_notfound BOOLEAN := TRUE;
2450: -- FUNCTION populate_new_record --
2451: ----------------------------------
2452: FUNCTION populate_new_record (
2453: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2454: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2455: ) RETURN VARCHAR2 IS
2456: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2457: l_row_notfound BOOLEAN := TRUE;
2458: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2452: FUNCTION populate_new_record (
2453: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2454: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2455: ) RETURN VARCHAR2 IS
2456: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2457: l_row_notfound BOOLEAN := TRUE;
2458: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2459: BEGIN
2460: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2456: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2457: l_row_notfound BOOLEAN := TRUE;
2458: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2459: BEGIN
2460: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2461: -- Get current database values
2462: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2463: IF (l_row_notfound) THEN
2464: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2458: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2459: BEGIN
2460: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2461: -- Get current database values
2462: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2463: IF (l_row_notfound) THEN
2464: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2465: END IF;
2466: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2462: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2463: IF (l_row_notfound) THEN
2464: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2465: END IF;
2466: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2467: THEN
2468: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2469: END IF;
2470: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2464: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2465: END IF;
2466: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2467: THEN
2468: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2469: END IF;
2470: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2471: THEN
2472: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2466: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2467: THEN
2468: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2469: END IF;
2470: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2471: THEN
2472: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2473: END IF;
2474: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2468: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2469: END IF;
2470: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2471: THEN
2472: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2473: END IF;
2474: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2475: THEN
2476: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2470: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2471: THEN
2472: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2473: END IF;
2474: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2475: THEN
2476: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2477: END IF;
2478: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2472: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2473: END IF;
2474: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2475: THEN
2476: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2477: END IF;
2478: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2479: THEN
2480: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2474: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2475: THEN
2476: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2477: END IF;
2478: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2479: THEN
2480: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2481: END IF;
2482: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2476: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2477: END IF;
2478: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2479: THEN
2480: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2481: END IF;
2482: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2483: THEN
2484: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2478: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2479: THEN
2480: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2481: END IF;
2482: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2483: THEN
2484: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2485: END IF;
2486: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2480: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2481: END IF;
2482: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2483: THEN
2484: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2485: END IF;
2486: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2487: THEN
2488: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2482: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2483: THEN
2484: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2485: END IF;
2486: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2487: THEN
2488: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2489: END IF;
2490: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2484: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2485: END IF;
2486: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2487: THEN
2488: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2489: END IF;
2490: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2491: THEN
2492: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2486: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2487: THEN
2488: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2489: END IF;
2490: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2491: THEN
2492: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2493: END IF;
2494: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2488: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2489: END IF;
2490: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2491: THEN
2492: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2493: END IF;
2494: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2495: THEN
2496: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2490: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2491: THEN
2492: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2493: END IF;
2494: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2495: THEN
2496: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2497: END IF;
2498: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2492: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2493: END IF;
2494: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2495: THEN
2496: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2497: END IF;
2498: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2499: THEN
2500: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2494: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2495: THEN
2496: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2497: END IF;
2498: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2499: THEN
2500: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2501: END IF;
2502: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2496: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2497: END IF;
2498: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2499: THEN
2500: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2501: END IF;
2502: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2503: THEN
2504: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2498: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2499: THEN
2500: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2501: END IF;
2502: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2503: THEN
2504: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2505: END IF;
2506: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2500: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2501: END IF;
2502: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2503: THEN
2504: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2505: END IF;
2506: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2507: THEN
2508: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2502: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2503: THEN
2504: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2505: END IF;
2506: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2507: THEN
2508: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2509: END IF;
2510: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2504: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2505: END IF;
2506: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2507: THEN
2508: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2509: END IF;
2510: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2511: THEN
2512: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2506: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2507: THEN
2508: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2509: END IF;
2510: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2511: THEN
2512: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2513: END IF;
2514: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2508: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2509: END IF;
2510: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2511: THEN
2512: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2513: END IF;
2514: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2515: THEN
2516: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;
2510: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2511: THEN
2512: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2513: END IF;
2514: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2515: THEN
2516: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;
2517: END IF;
2518: RETURN(l_return_status);
2512: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2513: END IF;
2514: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2515: THEN
2516: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;
2517: END IF;
2518: RETURN(l_return_status);
2519: END populate_new_record;
2520: ------------------------------------------
2517: END IF;
2518: RETURN(l_return_status);
2519: END populate_new_record;
2520: ------------------------------------------
2521: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2522: ------------------------------------------
2523: FUNCTION Set_Attributes (
2524: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2525: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2520: ------------------------------------------
2521: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2522: ------------------------------------------
2523: FUNCTION Set_Attributes (
2524: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2525: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2526: ) RETURN VARCHAR2 IS
2527: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2528: BEGIN
2521: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2522: ------------------------------------------
2523: FUNCTION Set_Attributes (
2524: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2525: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2526: ) RETURN VARCHAR2 IS
2527: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2528: BEGIN
2529: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2525: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2526: ) RETURN VARCHAR2 IS
2527: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2528: BEGIN
2529: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2530: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2531: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2532: RETURN(l_return_status);
2533: END Set_Attributes;
2526: ) RETURN VARCHAR2 IS
2527: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2528: BEGIN
2529: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2530: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2531: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2532: RETURN(l_return_status);
2533: END Set_Attributes;
2534: BEGIN
2527: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2528: BEGIN
2529: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2530: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2531: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2532: RETURN(l_return_status);
2533: END Set_Attributes;
2534: BEGIN
2535: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2542: RAISE OKC_API.G_EXCEPTION_ERROR;
2543: END IF;
2544: --- Setting item attributes
2545: l_return_status := Set_Attributes(
2546: p_okc_timevalues_tl_rec, -- IN
2547: l_okc_timevalues_tl_rec); -- OUT
2548: --- If any errors happen abort API
2549: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2550: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2543: END IF;
2544: --- Setting item attributes
2545: l_return_status := Set_Attributes(
2546: p_okc_timevalues_tl_rec, -- IN
2547: l_okc_timevalues_tl_rec); -- OUT
2548: --- If any errors happen abort API
2549: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2550: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2551: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2550: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2551: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2552: RAISE OKC_API.G_EXCEPTION_ERROR;
2553: END IF;
2554: l_return_status := populate_new_record(l_okc_timevalues_tl_rec, l_def_okc_timevalues_tl_rec);
2555: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2556: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2557: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2558: RAISE OKC_API.G_EXCEPTION_ERROR;
2556: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2557: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2558: RAISE OKC_API.G_EXCEPTION_ERROR;
2559: END IF;
2560: UPDATE OKC_TIMEVALUES_TL
2561: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2562: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2563: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2564: NAME = l_def_okc_timevalues_tl_rec.name,
2557: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2558: RAISE OKC_API.G_EXCEPTION_ERROR;
2559: END IF;
2560: UPDATE OKC_TIMEVALUES_TL
2561: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2562: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2563: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2564: NAME = l_def_okc_timevalues_tl_rec.name,
2565: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2558: RAISE OKC_API.G_EXCEPTION_ERROR;
2559: END IF;
2560: UPDATE OKC_TIMEVALUES_TL
2561: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2562: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2563: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2564: NAME = l_def_okc_timevalues_tl_rec.name,
2565: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2566: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2559: END IF;
2560: UPDATE OKC_TIMEVALUES_TL
2561: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2562: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2563: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2564: NAME = l_def_okc_timevalues_tl_rec.name,
2565: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2566: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2567: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2560: UPDATE OKC_TIMEVALUES_TL
2561: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2562: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2563: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2564: NAME = l_def_okc_timevalues_tl_rec.name,
2565: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2566: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2567: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2568: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2561: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2562: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2563: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2564: NAME = l_def_okc_timevalues_tl_rec.name,
2565: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2566: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2567: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2568: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2569: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2562: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2563: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2564: NAME = l_def_okc_timevalues_tl_rec.name,
2565: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2566: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2567: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2568: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2569: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2570: WHERE ID = l_def_okc_timevalues_tl_rec.id
2563: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2564: NAME = l_def_okc_timevalues_tl_rec.name,
2565: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2566: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2567: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2568: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2569: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2570: WHERE ID = l_def_okc_timevalues_tl_rec.id
2571: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2564: NAME = l_def_okc_timevalues_tl_rec.name,
2565: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2566: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2567: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2568: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2569: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2570: WHERE ID = l_def_okc_timevalues_tl_rec.id
2571: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2572:
2565: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2566: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2567: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2568: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2569: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2570: WHERE ID = l_def_okc_timevalues_tl_rec.id
2571: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2572:
2573: UPDATE OKC_TIMEVALUES_TL
2566: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2567: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2568: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2569: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2570: WHERE ID = l_def_okc_timevalues_tl_rec.id
2571: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2572:
2573: UPDATE OKC_TIMEVALUES_TL
2574: SET SFWT_FLAG = 'Y'
2569: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2570: WHERE ID = l_def_okc_timevalues_tl_rec.id
2571: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2572:
2573: UPDATE OKC_TIMEVALUES_TL
2574: SET SFWT_FLAG = 'Y'
2575: WHERE ID = l_def_okc_timevalues_tl_rec.id
2576: AND SOURCE_LANG <> USERENV('LANG');
2577: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;
2571: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2572:
2573: UPDATE OKC_TIMEVALUES_TL
2574: SET SFWT_FLAG = 'Y'
2575: WHERE ID = l_def_okc_timevalues_tl_rec.id
2576: AND SOURCE_LANG <> USERENV('LANG');
2577: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;
2578: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2579: EXCEPTION
2573: UPDATE OKC_TIMEVALUES_TL
2574: SET SFWT_FLAG = 'Y'
2575: WHERE ID = l_def_okc_timevalues_tl_rec.id
2576: AND SOURCE_LANG <> USERENV('LANG');
2577: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;
2578: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2579: EXCEPTION
2580: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2581: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2625: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2626: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2627: l_igsv_rec igsv_rec_type := p_igsv_rec;
2628: l_def_igsv_rec igsv_rec_type;
2629: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2630: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2631: l_tve_rec tve_rec_type;
2632: lx_tve_rec tve_rec_type;
2633: -------------------------------
2626: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2627: l_igsv_rec igsv_rec_type := p_igsv_rec;
2628: l_def_igsv_rec igsv_rec_type;
2629: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2630: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2631: l_tve_rec tve_rec_type;
2632: lx_tve_rec tve_rec_type;
2633: -------------------------------
2634: -- FUNCTION fill_who_columns --
2853:
2854: --------------------------------------
2855: -- Move VIEW record to "Child" records
2856: --------------------------------------
2857: --Bug 3122962 migrate(l_def_igsv_rec, l_okc_timevalues_tl_rec);
2858: migrate(l_def_igsv_rec, l_tve_rec);
2859: --------------------------------------------
2860: -- Call the UPDATE_ROW for each child record
2861: --------------------------------------------
2863: p_init_msg_list,
2864: x_return_status,
2865: x_msg_count,
2866: x_msg_data,
2867: l_okc_timevalues_tl_rec,
2868: lx_okc_timevalues_tl_rec
2869: );
2870: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2871: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2864: x_return_status,
2865: x_msg_count,
2866: x_msg_data,
2867: l_okc_timevalues_tl_rec,
2868: lx_okc_timevalues_tl_rec
2869: );
2870: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2871: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2872: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2871: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2872: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2873: RAISE OKC_API.G_EXCEPTION_ERROR;
2874: END IF;
2875: migrate(lx_okc_timevalues_tl_rec, l_def_igsv_rec);
2876: */
2877: update_row(
2878: p_init_msg_list,
2879: x_return_status,
2991: ---------------------------------------------------------------------------
2992: -- PROCEDURE delete_row
2993: ---------------------------------------------------------------------------
2994: -------------------------------------
2995: -- delete_row for:OKC_TIMEVALUES_B --
2996: -------------------------------------
2997: PROCEDURE delete_row(
2998: p_init_msg_list IN VARCHAR2 ,
2999: x_return_status OUT NOCOPY VARCHAR2,
3015: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3016: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3017: RAISE OKC_API.G_EXCEPTION_ERROR;
3018: END IF;
3019: DELETE FROM OKC_TIMEVALUES
3020: WHERE ID = l_tve_rec.id;
3021:
3022: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3023: EXCEPTION
3052: '_PVT'
3053: );
3054: END delete_row;
3055: --------------------------------------
3056: -- delete_row for:OKC_TIMEVALUES_TL --
3057: --------------------------------------
3058: --Bug 3122962
3059: /* PROCEDURE delete_row(
3060: p_init_msg_list IN VARCHAR2 ,
3060: p_init_msg_list IN VARCHAR2 ,
3061: x_return_status OUT NOCOPY VARCHAR2,
3062: x_msg_count OUT NOCOPY NUMBER,
3063: x_msg_data OUT NOCOPY VARCHAR2,
3064: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
3065:
3066: l_api_version CONSTANT NUMBER := 1;
3067: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3068: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3065:
3066: l_api_version CONSTANT NUMBER := 1;
3067: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3068: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3069: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;
3070: l_row_notfound BOOLEAN := TRUE;
3071: ------------------------------------------
3072: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3073: ------------------------------------------
3068: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3069: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;
3070: l_row_notfound BOOLEAN := TRUE;
3071: ------------------------------------------
3072: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3073: ------------------------------------------
3074: FUNCTION Set_Attributes (
3075: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3076: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3071: ------------------------------------------
3072: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3073: ------------------------------------------
3074: FUNCTION Set_Attributes (
3075: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3076: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3077: ) RETURN VARCHAR2 IS
3078: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3079: BEGIN
3072: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3073: ------------------------------------------
3074: FUNCTION Set_Attributes (
3075: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3076: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3077: ) RETURN VARCHAR2 IS
3078: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3079: BEGIN
3080: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
3076: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3077: ) RETURN VARCHAR2 IS
3078: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3079: BEGIN
3080: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
3081: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3082: RETURN(l_return_status);
3083: END Set_Attributes;
3084: BEGIN
3077: ) RETURN VARCHAR2 IS
3078: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3079: BEGIN
3080: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
3081: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3082: RETURN(l_return_status);
3083: END Set_Attributes;
3084: BEGIN
3085: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3092: RAISE OKC_API.G_EXCEPTION_ERROR;
3093: END IF;
3094: --- Setting item attributes
3095: l_return_status := Set_Attributes(
3096: p_okc_timevalues_tl_rec, -- IN
3097: l_okc_timevalues_tl_rec); -- OUT
3098: --- If any errors happen abort API
3099: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3093: END IF;
3094: --- Setting item attributes
3095: l_return_status := Set_Attributes(
3096: p_okc_timevalues_tl_rec, -- IN
3097: l_okc_timevalues_tl_rec); -- OUT
3098: --- If any errors happen abort API
3099: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3101: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3101: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3102: RAISE OKC_API.G_EXCEPTION_ERROR;
3103: END IF;
3104: DELETE FROM OKC_TIMEVALUES_TL
3105: WHERE ID = l_okc_timevalues_tl_rec.id;
3106:
3107: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3108: EXCEPTION
3101: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3102: RAISE OKC_API.G_EXCEPTION_ERROR;
3103: END IF;
3104: DELETE FROM OKC_TIMEVALUES_TL
3105: WHERE ID = l_okc_timevalues_tl_rec.id;
3106:
3107: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3108: EXCEPTION
3109: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3152: l_api_version CONSTANT NUMBER := 1;
3153: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3154: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3155: l_igsv_rec igsv_rec_type := p_igsv_rec;
3156: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
3157: l_tve_rec tve_rec_type;
3158: BEGIN
3159: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3160: G_PKG_NAME,
3170: END IF;
3171: --------------------------------------
3172: -- Move VIEW record to "Child" records
3173: --------------------------------------
3174: --Bug 3122962 migrate(l_igsv_rec, l_okc_timevalues_tl_rec);
3175: migrate(l_igsv_rec, l_tve_rec);
3176: --------------------------------------------
3177: -- Call the DELETE_ROW for each child record
3178: --------------------------------------------
3180: p_init_msg_list,
3181: x_return_status,
3182: x_msg_count,
3183: x_msg_data,
3184: l_okc_timevalues_tl_rec
3185: );
3186: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3188: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN