eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_CVP_PVT dependencies on OKS_COV_TYPES_TL

Line 98: DELETE FROM OKS_COV_TYPES_TL T

94: -- PROCEDURE add_language
95: ---------------------------------------------------------------------------
96: PROCEDURE add_language IS
97: BEGIN
98: DELETE FROM OKS_COV_TYPES_TL T
99: WHERE NOT EXISTS (
100: SELECT NULL
101: FROM OKS_COV_TYPES_B B
102: WHERE B.CODE =T.CODE

Line 105: UPDATE OKS_COV_TYPES_TL T SET(

101: FROM OKS_COV_TYPES_B B
102: WHERE B.CODE =T.CODE
103: );
104:
105: UPDATE OKS_COV_TYPES_TL T SET(
106: MEANING,
107: DESCRIPTION) = (SELECT
108: B.MEANING,
109: B.DESCRIPTION

Line 110: FROM OKS_COV_TYPES_TL B

106: MEANING,
107: DESCRIPTION) = (SELECT
108: B.MEANING,
109: B.DESCRIPTION
110: FROM OKS_COV_TYPES_TL B
111: WHERE B.CODE = T.CODE
112: AND B.LANGUAGE = T.SOURCE_LANG)
113: WHERE ( T.CODE,
114: T.LANGUAGE)

Line 118: FROM OKS_COV_TYPES_TL SUBB, OKS_COV_TYPES_TL SUBT

114: T.LANGUAGE)
115: IN (SELECT
116: SUBT.CODE,
117: SUBT.LANGUAGE
118: FROM OKS_COV_TYPES_TL SUBB, OKS_COV_TYPES_TL SUBT
119: WHERE SUBB.CODE = SUBT.CODE
120: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
121: AND (SUBB.MEANING <> SUBT.MEANING
122: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 127: INSERT INTO OKS_COV_TYPES_TL (

123: OR (SUBB.MEANING IS NOT NULL AND SUBT.MEANING IS NULL)
124: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
125: ));
126:
127: INSERT INTO OKS_COV_TYPES_TL (
128: CODE,
129: LANGUAGE,
130: SOURCE_LANG,
131: SFWT_FLAG,

Line 151: FROM OKS_COV_TYPES_TL B, FND_LANGUAGES L

147: B.CREATION_DATE,
148: B.LAST_UPDATED_BY,
149: B.LAST_UPDATE_LOGIN,
150: B.LAST_UPDATE_DATE
151: FROM OKS_COV_TYPES_TL B, FND_LANGUAGES L
152: WHERE L.INSTALLED_FLAG IN ('I', 'B')
153: AND B.LANGUAGE = USERENV('LANG')
154: AND NOT EXISTS (
155: SELECT NULL

Line 156: FROM OKS_COV_TYPES_TL T

152: WHERE L.INSTALLED_FLAG IN ('I', 'B')
153: AND B.LANGUAGE = USERENV('LANG')
154: AND NOT EXISTS (
155: SELECT NULL
156: FROM OKS_COV_TYPES_TL T
157: WHERE T.CODE = B.CODE
158: AND T.LANGUAGE = L.LANGUAGE_CODE
159: );
160: END add_language;

Line 272: -- FUNCTION get_rec for: OKS_COV_TYPES_TL

268: BEGIN
269: RETURN(get_rec(p_cvpv_rec, l_row_not_found));
270: END get_rec;
271: ---------------------------------------------------------------------------
272: -- FUNCTION get_rec for: OKS_COV_TYPES_TL
273: ---------------------------------------------------------------------------
274: FUNCTION get_rec (
275: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
276: x_no_data_found OUT NOCOPY BOOLEAN

Line 275: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,

271: ---------------------------------------------------------------------------
272: -- FUNCTION get_rec for: OKS_COV_TYPES_TL
273: ---------------------------------------------------------------------------
274: FUNCTION get_rec (
275: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
276: x_no_data_found OUT NOCOPY BOOLEAN
277: ) RETURN oks_cov_types_tl_rec_type IS
278: CURSOR oks_cov_types_tl_pk_csr (p_code IN VARCHAR2,
279: p_language IN VARCHAR2) IS

Line 277: ) RETURN oks_cov_types_tl_rec_type IS

273: ---------------------------------------------------------------------------
274: FUNCTION get_rec (
275: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
276: x_no_data_found OUT NOCOPY BOOLEAN
277: ) RETURN oks_cov_types_tl_rec_type IS
278: CURSOR oks_cov_types_tl_pk_csr (p_code IN VARCHAR2,
279: p_language IN VARCHAR2) IS
280: SELECT
281: CODE,

Line 278: CURSOR oks_cov_types_tl_pk_csr (p_code IN VARCHAR2,

274: FUNCTION get_rec (
275: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
276: x_no_data_found OUT NOCOPY BOOLEAN
277: ) RETURN oks_cov_types_tl_rec_type IS
278: CURSOR oks_cov_types_tl_pk_csr (p_code IN VARCHAR2,
279: p_language IN VARCHAR2) IS
280: SELECT
281: CODE,
282: LANGUAGE,

Line 292: FROM Oks_Cov_Types_Tl

288: CREATION_DATE,
289: LAST_UPDATED_BY,
290: LAST_UPDATE_LOGIN,
291: LAST_UPDATE_DATE
292: FROM Oks_Cov_Types_Tl
293: WHERE oks_cov_types_tl.code = p_code
294: AND oks_cov_types_tl.language = p_language;
295: l_oks_cov_types_tl_pk oks_cov_types_tl_pk_csr%ROWTYPE;
296: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;

Line 293: WHERE oks_cov_types_tl.code = p_code

289: LAST_UPDATED_BY,
290: LAST_UPDATE_LOGIN,
291: LAST_UPDATE_DATE
292: FROM Oks_Cov_Types_Tl
293: WHERE oks_cov_types_tl.code = p_code
294: AND oks_cov_types_tl.language = p_language;
295: l_oks_cov_types_tl_pk oks_cov_types_tl_pk_csr%ROWTYPE;
296: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
297: BEGIN

Line 294: AND oks_cov_types_tl.language = p_language;

290: LAST_UPDATE_LOGIN,
291: LAST_UPDATE_DATE
292: FROM Oks_Cov_Types_Tl
293: WHERE oks_cov_types_tl.code = p_code
294: AND oks_cov_types_tl.language = p_language;
295: l_oks_cov_types_tl_pk oks_cov_types_tl_pk_csr%ROWTYPE;
296: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
297: BEGIN
298: x_no_data_found := TRUE;

Line 295: l_oks_cov_types_tl_pk oks_cov_types_tl_pk_csr%ROWTYPE;

291: LAST_UPDATE_DATE
292: FROM Oks_Cov_Types_Tl
293: WHERE oks_cov_types_tl.code = p_code
294: AND oks_cov_types_tl.language = p_language;
295: l_oks_cov_types_tl_pk oks_cov_types_tl_pk_csr%ROWTYPE;
296: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
297: BEGIN
298: x_no_data_found := TRUE;
299: -- Get current database values

Line 296: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;

292: FROM Oks_Cov_Types_Tl
293: WHERE oks_cov_types_tl.code = p_code
294: AND oks_cov_types_tl.language = p_language;
295: l_oks_cov_types_tl_pk oks_cov_types_tl_pk_csr%ROWTYPE;
296: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
297: BEGIN
298: x_no_data_found := TRUE;
299: -- Get current database values
300: OPEN oks_cov_types_tl_pk_csr (p_oks_cov_types_tl_rec.code,

Line 300: OPEN oks_cov_types_tl_pk_csr (p_oks_cov_types_tl_rec.code,

296: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
297: BEGIN
298: x_no_data_found := TRUE;
299: -- Get current database values
300: OPEN oks_cov_types_tl_pk_csr (p_oks_cov_types_tl_rec.code,
301: p_oks_cov_types_tl_rec.language);
302: FETCH oks_cov_types_tl_pk_csr INTO
303: l_oks_cov_types_tl_rec.code,
304: l_oks_cov_types_tl_rec.language,

Line 301: p_oks_cov_types_tl_rec.language);

297: BEGIN
298: x_no_data_found := TRUE;
299: -- Get current database values
300: OPEN oks_cov_types_tl_pk_csr (p_oks_cov_types_tl_rec.code,
301: p_oks_cov_types_tl_rec.language);
302: FETCH oks_cov_types_tl_pk_csr INTO
303: l_oks_cov_types_tl_rec.code,
304: l_oks_cov_types_tl_rec.language,
305: l_oks_cov_types_tl_rec.source_lang,

Line 302: FETCH oks_cov_types_tl_pk_csr INTO

298: x_no_data_found := TRUE;
299: -- Get current database values
300: OPEN oks_cov_types_tl_pk_csr (p_oks_cov_types_tl_rec.code,
301: p_oks_cov_types_tl_rec.language);
302: FETCH oks_cov_types_tl_pk_csr INTO
303: l_oks_cov_types_tl_rec.code,
304: l_oks_cov_types_tl_rec.language,
305: l_oks_cov_types_tl_rec.source_lang,
306: l_oks_cov_types_tl_rec.sfwt_flag,

Line 303: l_oks_cov_types_tl_rec.code,

299: -- Get current database values
300: OPEN oks_cov_types_tl_pk_csr (p_oks_cov_types_tl_rec.code,
301: p_oks_cov_types_tl_rec.language);
302: FETCH oks_cov_types_tl_pk_csr INTO
303: l_oks_cov_types_tl_rec.code,
304: l_oks_cov_types_tl_rec.language,
305: l_oks_cov_types_tl_rec.source_lang,
306: l_oks_cov_types_tl_rec.sfwt_flag,
307: l_oks_cov_types_tl_rec.meaning,

Line 304: l_oks_cov_types_tl_rec.language,

300: OPEN oks_cov_types_tl_pk_csr (p_oks_cov_types_tl_rec.code,
301: p_oks_cov_types_tl_rec.language);
302: FETCH oks_cov_types_tl_pk_csr INTO
303: l_oks_cov_types_tl_rec.code,
304: l_oks_cov_types_tl_rec.language,
305: l_oks_cov_types_tl_rec.source_lang,
306: l_oks_cov_types_tl_rec.sfwt_flag,
307: l_oks_cov_types_tl_rec.meaning,
308: l_oks_cov_types_tl_rec.description,

Line 305: l_oks_cov_types_tl_rec.source_lang,

301: p_oks_cov_types_tl_rec.language);
302: FETCH oks_cov_types_tl_pk_csr INTO
303: l_oks_cov_types_tl_rec.code,
304: l_oks_cov_types_tl_rec.language,
305: l_oks_cov_types_tl_rec.source_lang,
306: l_oks_cov_types_tl_rec.sfwt_flag,
307: l_oks_cov_types_tl_rec.meaning,
308: l_oks_cov_types_tl_rec.description,
309: l_oks_cov_types_tl_rec.created_by,

Line 306: l_oks_cov_types_tl_rec.sfwt_flag,

302: FETCH oks_cov_types_tl_pk_csr INTO
303: l_oks_cov_types_tl_rec.code,
304: l_oks_cov_types_tl_rec.language,
305: l_oks_cov_types_tl_rec.source_lang,
306: l_oks_cov_types_tl_rec.sfwt_flag,
307: l_oks_cov_types_tl_rec.meaning,
308: l_oks_cov_types_tl_rec.description,
309: l_oks_cov_types_tl_rec.created_by,
310: l_oks_cov_types_tl_rec.creation_date,

Line 307: l_oks_cov_types_tl_rec.meaning,

303: l_oks_cov_types_tl_rec.code,
304: l_oks_cov_types_tl_rec.language,
305: l_oks_cov_types_tl_rec.source_lang,
306: l_oks_cov_types_tl_rec.sfwt_flag,
307: l_oks_cov_types_tl_rec.meaning,
308: l_oks_cov_types_tl_rec.description,
309: l_oks_cov_types_tl_rec.created_by,
310: l_oks_cov_types_tl_rec.creation_date,
311: l_oks_cov_types_tl_rec.last_updated_by,

Line 308: l_oks_cov_types_tl_rec.description,

304: l_oks_cov_types_tl_rec.language,
305: l_oks_cov_types_tl_rec.source_lang,
306: l_oks_cov_types_tl_rec.sfwt_flag,
307: l_oks_cov_types_tl_rec.meaning,
308: l_oks_cov_types_tl_rec.description,
309: l_oks_cov_types_tl_rec.created_by,
310: l_oks_cov_types_tl_rec.creation_date,
311: l_oks_cov_types_tl_rec.last_updated_by,
312: l_oks_cov_types_tl_rec.last_update_login,

Line 309: l_oks_cov_types_tl_rec.created_by,

305: l_oks_cov_types_tl_rec.source_lang,
306: l_oks_cov_types_tl_rec.sfwt_flag,
307: l_oks_cov_types_tl_rec.meaning,
308: l_oks_cov_types_tl_rec.description,
309: l_oks_cov_types_tl_rec.created_by,
310: l_oks_cov_types_tl_rec.creation_date,
311: l_oks_cov_types_tl_rec.last_updated_by,
312: l_oks_cov_types_tl_rec.last_update_login,
313: l_oks_cov_types_tl_rec.last_update_date;

Line 310: l_oks_cov_types_tl_rec.creation_date,

306: l_oks_cov_types_tl_rec.sfwt_flag,
307: l_oks_cov_types_tl_rec.meaning,
308: l_oks_cov_types_tl_rec.description,
309: l_oks_cov_types_tl_rec.created_by,
310: l_oks_cov_types_tl_rec.creation_date,
311: l_oks_cov_types_tl_rec.last_updated_by,
312: l_oks_cov_types_tl_rec.last_update_login,
313: l_oks_cov_types_tl_rec.last_update_date;
314: x_no_data_found := oks_cov_types_tl_pk_csr%NOTFOUND;

Line 311: l_oks_cov_types_tl_rec.last_updated_by,

307: l_oks_cov_types_tl_rec.meaning,
308: l_oks_cov_types_tl_rec.description,
309: l_oks_cov_types_tl_rec.created_by,
310: l_oks_cov_types_tl_rec.creation_date,
311: l_oks_cov_types_tl_rec.last_updated_by,
312: l_oks_cov_types_tl_rec.last_update_login,
313: l_oks_cov_types_tl_rec.last_update_date;
314: x_no_data_found := oks_cov_types_tl_pk_csr%NOTFOUND;
315: CLOSE oks_cov_types_tl_pk_csr;

Line 312: l_oks_cov_types_tl_rec.last_update_login,

308: l_oks_cov_types_tl_rec.description,
309: l_oks_cov_types_tl_rec.created_by,
310: l_oks_cov_types_tl_rec.creation_date,
311: l_oks_cov_types_tl_rec.last_updated_by,
312: l_oks_cov_types_tl_rec.last_update_login,
313: l_oks_cov_types_tl_rec.last_update_date;
314: x_no_data_found := oks_cov_types_tl_pk_csr%NOTFOUND;
315: CLOSE oks_cov_types_tl_pk_csr;
316: RETURN(l_oks_cov_types_tl_rec);

Line 313: l_oks_cov_types_tl_rec.last_update_date;

309: l_oks_cov_types_tl_rec.created_by,
310: l_oks_cov_types_tl_rec.creation_date,
311: l_oks_cov_types_tl_rec.last_updated_by,
312: l_oks_cov_types_tl_rec.last_update_login,
313: l_oks_cov_types_tl_rec.last_update_date;
314: x_no_data_found := oks_cov_types_tl_pk_csr%NOTFOUND;
315: CLOSE oks_cov_types_tl_pk_csr;
316: RETURN(l_oks_cov_types_tl_rec);
317: END get_rec;

Line 314: x_no_data_found := oks_cov_types_tl_pk_csr%NOTFOUND;

310: l_oks_cov_types_tl_rec.creation_date,
311: l_oks_cov_types_tl_rec.last_updated_by,
312: l_oks_cov_types_tl_rec.last_update_login,
313: l_oks_cov_types_tl_rec.last_update_date;
314: x_no_data_found := oks_cov_types_tl_pk_csr%NOTFOUND;
315: CLOSE oks_cov_types_tl_pk_csr;
316: RETURN(l_oks_cov_types_tl_rec);
317: END get_rec;
318:

Line 315: CLOSE oks_cov_types_tl_pk_csr;

311: l_oks_cov_types_tl_rec.last_updated_by,
312: l_oks_cov_types_tl_rec.last_update_login,
313: l_oks_cov_types_tl_rec.last_update_date;
314: x_no_data_found := oks_cov_types_tl_pk_csr%NOTFOUND;
315: CLOSE oks_cov_types_tl_pk_csr;
316: RETURN(l_oks_cov_types_tl_rec);
317: END get_rec;
318:
319: ------------------------------------------------------------------

Line 316: RETURN(l_oks_cov_types_tl_rec);

312: l_oks_cov_types_tl_rec.last_update_login,
313: l_oks_cov_types_tl_rec.last_update_date;
314: x_no_data_found := oks_cov_types_tl_pk_csr%NOTFOUND;
315: CLOSE oks_cov_types_tl_pk_csr;
316: RETURN(l_oks_cov_types_tl_rec);
317: END get_rec;
318:
319: ------------------------------------------------------------------
320: -- This version of get_rec sets error messages if no data found --

Line 323: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,

319: ------------------------------------------------------------------
320: -- This version of get_rec sets error messages if no data found --
321: ------------------------------------------------------------------
322: FUNCTION get_rec (
323: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
324: x_return_status OUT NOCOPY VARCHAR2
325: ) RETURN oks_cov_types_tl_rec_type IS
326: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
327: l_row_notfound BOOLEAN := TRUE;

Line 325: ) RETURN oks_cov_types_tl_rec_type IS

321: ------------------------------------------------------------------
322: FUNCTION get_rec (
323: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
324: x_return_status OUT NOCOPY VARCHAR2
325: ) RETURN oks_cov_types_tl_rec_type IS
326: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
327: l_row_notfound BOOLEAN := TRUE;
328: BEGIN
329: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 326: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;

322: FUNCTION get_rec (
323: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
324: x_return_status OUT NOCOPY VARCHAR2
325: ) RETURN oks_cov_types_tl_rec_type IS
326: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
327: l_row_notfound BOOLEAN := TRUE;
328: BEGIN
329: x_return_status := OKC_API.G_RET_STS_SUCCESS;
330: l_oks_cov_types_tl_rec := get_rec(p_oks_cov_types_tl_rec, l_row_notfound);

Line 330: l_oks_cov_types_tl_rec := get_rec(p_oks_cov_types_tl_rec, l_row_notfound);

326: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
327: l_row_notfound BOOLEAN := TRUE;
328: BEGIN
329: x_return_status := OKC_API.G_RET_STS_SUCCESS;
330: l_oks_cov_types_tl_rec := get_rec(p_oks_cov_types_tl_rec, l_row_notfound);
331: IF (l_row_notfound) THEN
332: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CODE');
333: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'LANGUAGE');
334: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 336: RETURN(l_oks_cov_types_tl_rec);

332: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CODE');
333: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'LANGUAGE');
334: x_return_status := OKC_API.G_RET_STS_ERROR;
335: END IF;
336: RETURN(l_oks_cov_types_tl_rec);
337: END get_rec;
338: -----------------------------------------------------------
339: -- So we don't have to pass an "l_row_notfound" variable --
340: -----------------------------------------------------------

Line 342: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type

338: -----------------------------------------------------------
339: -- So we don't have to pass an "l_row_notfound" variable --
340: -----------------------------------------------------------
341: FUNCTION get_rec (
342: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type
343: ) RETURN oks_cov_types_tl_rec_type IS
344: l_row_not_found BOOLEAN := TRUE;
345: BEGIN
346: RETURN(get_rec(p_oks_cov_types_tl_rec, l_row_not_found));

Line 343: ) RETURN oks_cov_types_tl_rec_type IS

339: -- So we don't have to pass an "l_row_notfound" variable --
340: -----------------------------------------------------------
341: FUNCTION get_rec (
342: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type
343: ) RETURN oks_cov_types_tl_rec_type IS
344: l_row_not_found BOOLEAN := TRUE;
345: BEGIN
346: RETURN(get_rec(p_oks_cov_types_tl_rec, l_row_not_found));
347: END get_rec;

Line 346: RETURN(get_rec(p_oks_cov_types_tl_rec, l_row_not_found));

342: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type
343: ) RETURN oks_cov_types_tl_rec_type IS
344: l_row_not_found BOOLEAN := TRUE;
345: BEGIN
346: RETURN(get_rec(p_oks_cov_types_tl_rec, l_row_not_found));
347: END get_rec;
348: ---------------------------------------------------------------------------
349: -- FUNCTION get_rec for: OKS_COV_TYPES_B
350: ---------------------------------------------------------------------------

Line 715: p_to IN OUT NOCOPY oks_cov_types_tl_rec_type

711: -- PROCEDURE Migrate
712: ---------------------------------------------------------------------------
713: PROCEDURE migrate (
714: p_from IN cvpv_rec_type,
715: p_to IN OUT NOCOPY oks_cov_types_tl_rec_type
716: ) IS
717: BEGIN
718: p_to.code := p_from.code;
719: p_to.sfwt_flag := p_from.sfwt_flag;

Line 729: p_from IN oks_cov_types_tl_rec_type,

725: p_to.last_update_login := p_from.last_update_login;
726: p_to.last_update_date := p_from.last_update_date;
727: END migrate;
728: PROCEDURE migrate (
729: p_from IN oks_cov_types_tl_rec_type,
730: p_to IN OUT NOCOPY cvpv_rec_type
731: ) IS
732: BEGIN
733: p_to.code := p_from.code;

Line 826: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;

822: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
823: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
824: l_cvpv_rec cvpv_rec_type := p_cvpv_rec;
825: l_cvp_rec cvp_rec_type;
826: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
827: BEGIN
828: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
829: G_PKG_NAME,
830: p_init_msg_list,

Line 1187: -- insert_row for:OKS_COV_TYPES_TL --

1183: '_PVT'
1184: );
1185: END insert_row;
1186: -------------------------------------
1187: -- insert_row for:OKS_COV_TYPES_TL --
1188: -------------------------------------
1189: PROCEDURE insert_row(
1190: p_init_msg_list IN VARCHAR2,
1191: x_return_status OUT NOCOPY VARCHAR2,

Line 1194: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,

1190: p_init_msg_list IN VARCHAR2,
1191: x_return_status OUT NOCOPY VARCHAR2,
1192: x_msg_count OUT NOCOPY NUMBER,
1193: x_msg_data OUT NOCOPY VARCHAR2,
1194: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
1195: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type) IS
1196:
1197: l_api_version CONSTANT NUMBER := 1;
1198: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1195: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type) IS

1191: x_return_status OUT NOCOPY VARCHAR2,
1192: x_msg_count OUT NOCOPY NUMBER,
1193: x_msg_data OUT NOCOPY VARCHAR2,
1194: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
1195: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type) IS
1196:
1197: l_api_version CONSTANT NUMBER := 1;
1198: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1199: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1200: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type := p_oks_cov_types_tl_rec;

1196:
1197: l_api_version CONSTANT NUMBER := 1;
1198: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1199: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1200: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type := p_oks_cov_types_tl_rec;
1201: l_def_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
1202: CURSOR get_languages IS
1203: SELECT *
1204: FROM FND_LANGUAGES

Line 1201: l_def_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;

1197: l_api_version CONSTANT NUMBER := 1;
1198: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1199: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1200: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type := p_oks_cov_types_tl_rec;
1201: l_def_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
1202: CURSOR get_languages IS
1203: SELECT *
1204: FROM FND_LANGUAGES
1205: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1207: -- Set_Attributes for:OKS_COV_TYPES_TL --

1203: SELECT *
1204: FROM FND_LANGUAGES
1205: WHERE INSTALLED_FLAG IN ('I', 'B');
1206: -----------------------------------------
1207: -- Set_Attributes for:OKS_COV_TYPES_TL --
1208: -----------------------------------------
1209: FUNCTION Set_Attributes (
1210: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
1211: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type

Line 1210: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,

1206: -----------------------------------------
1207: -- Set_Attributes for:OKS_COV_TYPES_TL --
1208: -----------------------------------------
1209: FUNCTION Set_Attributes (
1210: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
1211: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type
1212: ) RETURN VARCHAR2 IS
1213: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1214: BEGIN

Line 1211: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type

1207: -- Set_Attributes for:OKS_COV_TYPES_TL --
1208: -----------------------------------------
1209: FUNCTION Set_Attributes (
1210: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
1211: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type
1212: ) RETURN VARCHAR2 IS
1213: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1214: BEGIN
1215: x_oks_cov_types_tl_rec := p_oks_cov_types_tl_rec;

Line 1215: x_oks_cov_types_tl_rec := p_oks_cov_types_tl_rec;

1211: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type
1212: ) RETURN VARCHAR2 IS
1213: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1214: BEGIN
1215: x_oks_cov_types_tl_rec := p_oks_cov_types_tl_rec;
1216: x_oks_cov_types_tl_rec.LANGUAGE := USERENV('LANG');
1217: x_oks_cov_types_tl_rec.SOURCE_LANG := USERENV('LANG');
1218: RETURN(l_return_status);
1219: END Set_Attributes;

Line 1216: x_oks_cov_types_tl_rec.LANGUAGE := USERENV('LANG');

1212: ) RETURN VARCHAR2 IS
1213: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1214: BEGIN
1215: x_oks_cov_types_tl_rec := p_oks_cov_types_tl_rec;
1216: x_oks_cov_types_tl_rec.LANGUAGE := USERENV('LANG');
1217: x_oks_cov_types_tl_rec.SOURCE_LANG := USERENV('LANG');
1218: RETURN(l_return_status);
1219: END Set_Attributes;
1220: BEGIN

Line 1217: x_oks_cov_types_tl_rec.SOURCE_LANG := USERENV('LANG');

1213: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1214: BEGIN
1215: x_oks_cov_types_tl_rec := p_oks_cov_types_tl_rec;
1216: x_oks_cov_types_tl_rec.LANGUAGE := USERENV('LANG');
1217: x_oks_cov_types_tl_rec.SOURCE_LANG := USERENV('LANG');
1218: RETURN(l_return_status);
1219: END Set_Attributes;
1220: BEGIN
1221: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1232: p_oks_cov_types_tl_rec, -- IN

1228: RAISE OKC_API.G_EXCEPTION_ERROR;
1229: END IF;
1230: --- Setting item attributes
1231: l_return_status := Set_Attributes(
1232: p_oks_cov_types_tl_rec, -- IN
1233: l_oks_cov_types_tl_rec); -- OUT
1234: --- If any errors happen abort API
1235: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1236: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1233: l_oks_cov_types_tl_rec); -- OUT

1229: END IF;
1230: --- Setting item attributes
1231: l_return_status := Set_Attributes(
1232: p_oks_cov_types_tl_rec, -- IN
1233: l_oks_cov_types_tl_rec); -- OUT
1234: --- If any errors happen abort API
1235: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1236: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1237: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1241: l_oks_cov_types_tl_rec.language := l_lang_rec.language_code;

1237: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1238: RAISE OKC_API.G_EXCEPTION_ERROR;
1239: END IF;
1240: FOR l_lang_rec IN get_languages LOOP
1241: l_oks_cov_types_tl_rec.language := l_lang_rec.language_code;
1242: INSERT INTO OKS_COV_TYPES_TL(
1243: code,
1244: language,
1245: source_lang,

Line 1242: INSERT INTO OKS_COV_TYPES_TL(

1238: RAISE OKC_API.G_EXCEPTION_ERROR;
1239: END IF;
1240: FOR l_lang_rec IN get_languages LOOP
1241: l_oks_cov_types_tl_rec.language := l_lang_rec.language_code;
1242: INSERT INTO OKS_COV_TYPES_TL(
1243: code,
1244: language,
1245: source_lang,
1246: sfwt_flag,

Line 1255: l_oks_cov_types_tl_rec.code,

1251: last_updated_by,
1252: last_update_login,
1253: last_update_date)
1254: VALUES (
1255: l_oks_cov_types_tl_rec.code,
1256: l_oks_cov_types_tl_rec.language,
1257: l_oks_cov_types_tl_rec.source_lang,
1258: l_oks_cov_types_tl_rec.sfwt_flag,
1259: l_oks_cov_types_tl_rec.meaning,

Line 1256: l_oks_cov_types_tl_rec.language,

1252: last_update_login,
1253: last_update_date)
1254: VALUES (
1255: l_oks_cov_types_tl_rec.code,
1256: l_oks_cov_types_tl_rec.language,
1257: l_oks_cov_types_tl_rec.source_lang,
1258: l_oks_cov_types_tl_rec.sfwt_flag,
1259: l_oks_cov_types_tl_rec.meaning,
1260: l_oks_cov_types_tl_rec.description,

Line 1257: l_oks_cov_types_tl_rec.source_lang,

1253: last_update_date)
1254: VALUES (
1255: l_oks_cov_types_tl_rec.code,
1256: l_oks_cov_types_tl_rec.language,
1257: l_oks_cov_types_tl_rec.source_lang,
1258: l_oks_cov_types_tl_rec.sfwt_flag,
1259: l_oks_cov_types_tl_rec.meaning,
1260: l_oks_cov_types_tl_rec.description,
1261: l_oks_cov_types_tl_rec.created_by,

Line 1258: l_oks_cov_types_tl_rec.sfwt_flag,

1254: VALUES (
1255: l_oks_cov_types_tl_rec.code,
1256: l_oks_cov_types_tl_rec.language,
1257: l_oks_cov_types_tl_rec.source_lang,
1258: l_oks_cov_types_tl_rec.sfwt_flag,
1259: l_oks_cov_types_tl_rec.meaning,
1260: l_oks_cov_types_tl_rec.description,
1261: l_oks_cov_types_tl_rec.created_by,
1262: l_oks_cov_types_tl_rec.creation_date,

Line 1259: l_oks_cov_types_tl_rec.meaning,

1255: l_oks_cov_types_tl_rec.code,
1256: l_oks_cov_types_tl_rec.language,
1257: l_oks_cov_types_tl_rec.source_lang,
1258: l_oks_cov_types_tl_rec.sfwt_flag,
1259: l_oks_cov_types_tl_rec.meaning,
1260: l_oks_cov_types_tl_rec.description,
1261: l_oks_cov_types_tl_rec.created_by,
1262: l_oks_cov_types_tl_rec.creation_date,
1263: l_oks_cov_types_tl_rec.last_updated_by,

Line 1260: l_oks_cov_types_tl_rec.description,

1256: l_oks_cov_types_tl_rec.language,
1257: l_oks_cov_types_tl_rec.source_lang,
1258: l_oks_cov_types_tl_rec.sfwt_flag,
1259: l_oks_cov_types_tl_rec.meaning,
1260: l_oks_cov_types_tl_rec.description,
1261: l_oks_cov_types_tl_rec.created_by,
1262: l_oks_cov_types_tl_rec.creation_date,
1263: l_oks_cov_types_tl_rec.last_updated_by,
1264: l_oks_cov_types_tl_rec.last_update_login,

Line 1261: l_oks_cov_types_tl_rec.created_by,

1257: l_oks_cov_types_tl_rec.source_lang,
1258: l_oks_cov_types_tl_rec.sfwt_flag,
1259: l_oks_cov_types_tl_rec.meaning,
1260: l_oks_cov_types_tl_rec.description,
1261: l_oks_cov_types_tl_rec.created_by,
1262: l_oks_cov_types_tl_rec.creation_date,
1263: l_oks_cov_types_tl_rec.last_updated_by,
1264: l_oks_cov_types_tl_rec.last_update_login,
1265: l_oks_cov_types_tl_rec.last_update_date);

Line 1262: l_oks_cov_types_tl_rec.creation_date,

1258: l_oks_cov_types_tl_rec.sfwt_flag,
1259: l_oks_cov_types_tl_rec.meaning,
1260: l_oks_cov_types_tl_rec.description,
1261: l_oks_cov_types_tl_rec.created_by,
1262: l_oks_cov_types_tl_rec.creation_date,
1263: l_oks_cov_types_tl_rec.last_updated_by,
1264: l_oks_cov_types_tl_rec.last_update_login,
1265: l_oks_cov_types_tl_rec.last_update_date);
1266: END LOOP;

Line 1263: l_oks_cov_types_tl_rec.last_updated_by,

1259: l_oks_cov_types_tl_rec.meaning,
1260: l_oks_cov_types_tl_rec.description,
1261: l_oks_cov_types_tl_rec.created_by,
1262: l_oks_cov_types_tl_rec.creation_date,
1263: l_oks_cov_types_tl_rec.last_updated_by,
1264: l_oks_cov_types_tl_rec.last_update_login,
1265: l_oks_cov_types_tl_rec.last_update_date);
1266: END LOOP;
1267: -- Set OUT values

Line 1264: l_oks_cov_types_tl_rec.last_update_login,

1260: l_oks_cov_types_tl_rec.description,
1261: l_oks_cov_types_tl_rec.created_by,
1262: l_oks_cov_types_tl_rec.creation_date,
1263: l_oks_cov_types_tl_rec.last_updated_by,
1264: l_oks_cov_types_tl_rec.last_update_login,
1265: l_oks_cov_types_tl_rec.last_update_date);
1266: END LOOP;
1267: -- Set OUT values
1268: x_oks_cov_types_tl_rec := l_oks_cov_types_tl_rec;

Line 1265: l_oks_cov_types_tl_rec.last_update_date);

1261: l_oks_cov_types_tl_rec.created_by,
1262: l_oks_cov_types_tl_rec.creation_date,
1263: l_oks_cov_types_tl_rec.last_updated_by,
1264: l_oks_cov_types_tl_rec.last_update_login,
1265: l_oks_cov_types_tl_rec.last_update_date);
1266: END LOOP;
1267: -- Set OUT values
1268: x_oks_cov_types_tl_rec := l_oks_cov_types_tl_rec;
1269: x_return_status := l_return_status;

Line 1268: x_oks_cov_types_tl_rec := l_oks_cov_types_tl_rec;

1264: l_oks_cov_types_tl_rec.last_update_login,
1265: l_oks_cov_types_tl_rec.last_update_date);
1266: END LOOP;
1267: -- Set OUT values
1268: x_oks_cov_types_tl_rec := l_oks_cov_types_tl_rec;
1269: x_return_status := l_return_status;
1270: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1271: EXCEPTION
1272: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1322: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;

1318: l_cvpv_rec cvpv_rec_type := p_cvpv_rec;
1319: l_def_cvpv_rec cvpv_rec_type;
1320: l_cvp_rec cvp_rec_type;
1321: lx_cvp_rec cvp_rec_type;
1322: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
1323: lx_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
1324: -------------------------------
1325: -- FUNCTION fill_who_columns --
1326: -------------------------------

Line 1323: lx_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;

1319: l_def_cvpv_rec cvpv_rec_type;
1320: l_cvp_rec cvp_rec_type;
1321: lx_cvp_rec cvp_rec_type;
1322: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
1323: lx_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
1324: -------------------------------
1325: -- FUNCTION fill_who_columns --
1326: -------------------------------
1327: FUNCTION fill_who_columns (

Line 1398: migrate(l_def_cvpv_rec, l_oks_cov_types_tl_rec);

1394: -----------------------------------------
1395: -- Move VIEW record to "Child" records --
1396: -----------------------------------------
1397: migrate(l_def_cvpv_rec, l_cvp_rec);
1398: migrate(l_def_cvpv_rec, l_oks_cov_types_tl_rec);
1399: -----------------------------------------------
1400: -- Call the INSERT_ROW for each child record --
1401: -----------------------------------------------
1402: insert_row(

Line 1421: l_oks_cov_types_tl_rec,

1417: p_init_msg_list,
1418: l_return_status,
1419: x_msg_count,
1420: x_msg_data,
1421: l_oks_cov_types_tl_rec,
1422: lx_oks_cov_types_tl_rec
1423: );
1424: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1425: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1422: lx_oks_cov_types_tl_rec

1418: l_return_status,
1419: x_msg_count,
1420: x_msg_data,
1421: l_oks_cov_types_tl_rec,
1422: lx_oks_cov_types_tl_rec
1423: );
1424: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1425: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1426: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1429: migrate(lx_oks_cov_types_tl_rec, l_def_cvpv_rec);

1425: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1426: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1427: RAISE OKC_API.G_EXCEPTION_ERROR;
1428: END IF;
1429: migrate(lx_oks_cov_types_tl_rec, l_def_cvpv_rec);
1430: -- Set OUT values
1431: x_cvpv_rec := l_def_cvpv_rec;
1432: x_return_status := l_return_status;
1433: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1825: -- lock_row for:OKS_COV_TYPES_TL --

1821: '_PVT'
1822: );
1823: END lock_row;
1824: -----------------------------------
1825: -- lock_row for:OKS_COV_TYPES_TL --
1826: -----------------------------------
1827: PROCEDURE lock_row(
1828: p_init_msg_list IN VARCHAR2,
1829: x_return_status OUT NOCOPY VARCHAR2,

Line 1832: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type) IS

1828: p_init_msg_list IN VARCHAR2,
1829: x_return_status OUT NOCOPY VARCHAR2,
1830: x_msg_count OUT NOCOPY NUMBER,
1831: x_msg_data OUT NOCOPY VARCHAR2,
1832: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type) IS
1833:
1834: E_Resource_Busy EXCEPTION;
1835: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1836: CURSOR lock_csr (p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type) IS

Line 1836: CURSOR lock_csr (p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type) IS

1832: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type) IS
1833:
1834: E_Resource_Busy EXCEPTION;
1835: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1836: CURSOR lock_csr (p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type) IS
1837: SELECT *
1838: FROM OKS_COV_TYPES_TL
1839: WHERE CODE = p_oks_cov_types_tl_rec.code
1840: FOR UPDATE NOWAIT;

Line 1838: FROM OKS_COV_TYPES_TL

1834: E_Resource_Busy EXCEPTION;
1835: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1836: CURSOR lock_csr (p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type) IS
1837: SELECT *
1838: FROM OKS_COV_TYPES_TL
1839: WHERE CODE = p_oks_cov_types_tl_rec.code
1840: FOR UPDATE NOWAIT;
1841:
1842: l_api_version CONSTANT NUMBER := 1;

Line 1839: WHERE CODE = p_oks_cov_types_tl_rec.code

1835: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1836: CURSOR lock_csr (p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type) IS
1837: SELECT *
1838: FROM OKS_COV_TYPES_TL
1839: WHERE CODE = p_oks_cov_types_tl_rec.code
1840: FOR UPDATE NOWAIT;
1841:
1842: l_api_version CONSTANT NUMBER := 1;
1843: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1859: OPEN lock_csr(p_oks_cov_types_tl_rec);

1855: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1856: RAISE OKC_API.G_EXCEPTION_ERROR;
1857: END IF;
1858: BEGIN
1859: OPEN lock_csr(p_oks_cov_types_tl_rec);
1860: FETCH lock_csr INTO l_lock_var;
1861: l_row_notfound := lock_csr%NOTFOUND;
1862: CLOSE lock_csr;
1863: EXCEPTION

Line 1924: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;

1920:
1921: l_api_version CONSTANT NUMBER := 1;
1922: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1923: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1924: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
1925: l_cvp_rec cvp_rec_type;
1926: BEGIN
1927: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1928: G_PKG_NAME,

Line 1942: migrate(p_cvpv_rec, l_oks_cov_types_tl_rec);

1938: END IF;
1939: -----------------------------------------
1940: -- Move VIEW record to "Child" records --
1941: -----------------------------------------
1942: migrate(p_cvpv_rec, l_oks_cov_types_tl_rec);
1943: migrate(p_cvpv_rec, l_cvp_rec);
1944: ---------------------------------------------
1945: -- Call the LOCK_ROW for each child record --
1946: ---------------------------------------------

Line 1952: l_oks_cov_types_tl_rec

1948: p_init_msg_list,
1949: l_return_status,
1950: x_msg_count,
1951: x_msg_data,
1952: l_oks_cov_types_tl_rec
1953: );
1954: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1955: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1956: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2405: -- update_row for:OKS_COV_TYPES_TL --

2401: '_PVT'
2402: );
2403: END update_row;
2404: -------------------------------------
2405: -- update_row for:OKS_COV_TYPES_TL --
2406: -------------------------------------
2407: PROCEDURE update_row(
2408: p_init_msg_list IN VARCHAR2,
2409: x_return_status OUT NOCOPY VARCHAR2,

Line 2412: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,

2408: p_init_msg_list IN VARCHAR2,
2409: x_return_status OUT NOCOPY VARCHAR2,
2410: x_msg_count OUT NOCOPY NUMBER,
2411: x_msg_data OUT NOCOPY VARCHAR2,
2412: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
2413: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type) IS
2414:
2415: l_api_version CONSTANT NUMBER := 1;
2416: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2413: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type) IS

2409: x_return_status OUT NOCOPY VARCHAR2,
2410: x_msg_count OUT NOCOPY NUMBER,
2411: x_msg_data OUT NOCOPY VARCHAR2,
2412: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
2413: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type) IS
2414:
2415: l_api_version CONSTANT NUMBER := 1;
2416: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2417: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2418: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type := p_oks_cov_types_tl_rec;

2414:
2415: l_api_version CONSTANT NUMBER := 1;
2416: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2417: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2418: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type := p_oks_cov_types_tl_rec;
2419: l_def_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
2420: l_row_notfound BOOLEAN := TRUE;
2421: ----------------------------------
2422: -- FUNCTION populate_new_record --

Line 2419: l_def_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;

2415: l_api_version CONSTANT NUMBER := 1;
2416: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2417: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2418: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type := p_oks_cov_types_tl_rec;
2419: l_def_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
2420: l_row_notfound BOOLEAN := TRUE;
2421: ----------------------------------
2422: -- FUNCTION populate_new_record --
2423: ----------------------------------

Line 2425: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,

2421: ----------------------------------
2422: -- FUNCTION populate_new_record --
2423: ----------------------------------
2424: FUNCTION populate_new_record (
2425: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
2426: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type
2427: ) RETURN VARCHAR2 IS
2428: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
2429: l_row_notfound BOOLEAN := TRUE;

Line 2426: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type

2422: -- FUNCTION populate_new_record --
2423: ----------------------------------
2424: FUNCTION populate_new_record (
2425: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
2426: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type
2427: ) RETURN VARCHAR2 IS
2428: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
2429: l_row_notfound BOOLEAN := TRUE;
2430: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2428: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;

2424: FUNCTION populate_new_record (
2425: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
2426: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type
2427: ) RETURN VARCHAR2 IS
2428: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
2429: l_row_notfound BOOLEAN := TRUE;
2430: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2431: BEGIN
2432: x_oks_cov_types_tl_rec := p_oks_cov_types_tl_rec;

Line 2432: x_oks_cov_types_tl_rec := p_oks_cov_types_tl_rec;

2428: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
2429: l_row_notfound BOOLEAN := TRUE;
2430: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2431: BEGIN
2432: x_oks_cov_types_tl_rec := p_oks_cov_types_tl_rec;
2433: -- Get current database values
2434: l_oks_cov_types_tl_rec := get_rec(p_oks_cov_types_tl_rec, l_return_status);
2435: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2436: IF (x_oks_cov_types_tl_rec.code = OKC_API.G_MISS_CHAR)

Line 2434: l_oks_cov_types_tl_rec := get_rec(p_oks_cov_types_tl_rec, l_return_status);

2430: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2431: BEGIN
2432: x_oks_cov_types_tl_rec := p_oks_cov_types_tl_rec;
2433: -- Get current database values
2434: l_oks_cov_types_tl_rec := get_rec(p_oks_cov_types_tl_rec, l_return_status);
2435: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2436: IF (x_oks_cov_types_tl_rec.code = OKC_API.G_MISS_CHAR)
2437: THEN
2438: x_oks_cov_types_tl_rec.code := l_oks_cov_types_tl_rec.code;

Line 2436: IF (x_oks_cov_types_tl_rec.code = OKC_API.G_MISS_CHAR)

2432: x_oks_cov_types_tl_rec := p_oks_cov_types_tl_rec;
2433: -- Get current database values
2434: l_oks_cov_types_tl_rec := get_rec(p_oks_cov_types_tl_rec, l_return_status);
2435: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2436: IF (x_oks_cov_types_tl_rec.code = OKC_API.G_MISS_CHAR)
2437: THEN
2438: x_oks_cov_types_tl_rec.code := l_oks_cov_types_tl_rec.code;
2439: END IF;
2440: IF (x_oks_cov_types_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 2438: x_oks_cov_types_tl_rec.code := l_oks_cov_types_tl_rec.code;

2434: l_oks_cov_types_tl_rec := get_rec(p_oks_cov_types_tl_rec, l_return_status);
2435: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2436: IF (x_oks_cov_types_tl_rec.code = OKC_API.G_MISS_CHAR)
2437: THEN
2438: x_oks_cov_types_tl_rec.code := l_oks_cov_types_tl_rec.code;
2439: END IF;
2440: IF (x_oks_cov_types_tl_rec.language = OKC_API.G_MISS_CHAR)
2441: THEN
2442: x_oks_cov_types_tl_rec.language := l_oks_cov_types_tl_rec.language;

Line 2440: IF (x_oks_cov_types_tl_rec.language = OKC_API.G_MISS_CHAR)

2436: IF (x_oks_cov_types_tl_rec.code = OKC_API.G_MISS_CHAR)
2437: THEN
2438: x_oks_cov_types_tl_rec.code := l_oks_cov_types_tl_rec.code;
2439: END IF;
2440: IF (x_oks_cov_types_tl_rec.language = OKC_API.G_MISS_CHAR)
2441: THEN
2442: x_oks_cov_types_tl_rec.language := l_oks_cov_types_tl_rec.language;
2443: END IF;
2444: IF (x_oks_cov_types_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 2442: x_oks_cov_types_tl_rec.language := l_oks_cov_types_tl_rec.language;

2438: x_oks_cov_types_tl_rec.code := l_oks_cov_types_tl_rec.code;
2439: END IF;
2440: IF (x_oks_cov_types_tl_rec.language = OKC_API.G_MISS_CHAR)
2441: THEN
2442: x_oks_cov_types_tl_rec.language := l_oks_cov_types_tl_rec.language;
2443: END IF;
2444: IF (x_oks_cov_types_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2445: THEN
2446: x_oks_cov_types_tl_rec.source_lang := l_oks_cov_types_tl_rec.source_lang;

Line 2444: IF (x_oks_cov_types_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

2440: IF (x_oks_cov_types_tl_rec.language = OKC_API.G_MISS_CHAR)
2441: THEN
2442: x_oks_cov_types_tl_rec.language := l_oks_cov_types_tl_rec.language;
2443: END IF;
2444: IF (x_oks_cov_types_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2445: THEN
2446: x_oks_cov_types_tl_rec.source_lang := l_oks_cov_types_tl_rec.source_lang;
2447: END IF;
2448: IF (x_oks_cov_types_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 2446: x_oks_cov_types_tl_rec.source_lang := l_oks_cov_types_tl_rec.source_lang;

2442: x_oks_cov_types_tl_rec.language := l_oks_cov_types_tl_rec.language;
2443: END IF;
2444: IF (x_oks_cov_types_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2445: THEN
2446: x_oks_cov_types_tl_rec.source_lang := l_oks_cov_types_tl_rec.source_lang;
2447: END IF;
2448: IF (x_oks_cov_types_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2449: THEN
2450: x_oks_cov_types_tl_rec.sfwt_flag := l_oks_cov_types_tl_rec.sfwt_flag;

Line 2448: IF (x_oks_cov_types_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

2444: IF (x_oks_cov_types_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2445: THEN
2446: x_oks_cov_types_tl_rec.source_lang := l_oks_cov_types_tl_rec.source_lang;
2447: END IF;
2448: IF (x_oks_cov_types_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2449: THEN
2450: x_oks_cov_types_tl_rec.sfwt_flag := l_oks_cov_types_tl_rec.sfwt_flag;
2451: END IF;
2452: IF (x_oks_cov_types_tl_rec.meaning = OKC_API.G_MISS_CHAR)

Line 2450: x_oks_cov_types_tl_rec.sfwt_flag := l_oks_cov_types_tl_rec.sfwt_flag;

2446: x_oks_cov_types_tl_rec.source_lang := l_oks_cov_types_tl_rec.source_lang;
2447: END IF;
2448: IF (x_oks_cov_types_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2449: THEN
2450: x_oks_cov_types_tl_rec.sfwt_flag := l_oks_cov_types_tl_rec.sfwt_flag;
2451: END IF;
2452: IF (x_oks_cov_types_tl_rec.meaning = OKC_API.G_MISS_CHAR)
2453: THEN
2454: x_oks_cov_types_tl_rec.meaning := l_oks_cov_types_tl_rec.meaning;

Line 2452: IF (x_oks_cov_types_tl_rec.meaning = OKC_API.G_MISS_CHAR)

2448: IF (x_oks_cov_types_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2449: THEN
2450: x_oks_cov_types_tl_rec.sfwt_flag := l_oks_cov_types_tl_rec.sfwt_flag;
2451: END IF;
2452: IF (x_oks_cov_types_tl_rec.meaning = OKC_API.G_MISS_CHAR)
2453: THEN
2454: x_oks_cov_types_tl_rec.meaning := l_oks_cov_types_tl_rec.meaning;
2455: END IF;
2456: IF (x_oks_cov_types_tl_rec.description = OKC_API.G_MISS_CHAR)

Line 2454: x_oks_cov_types_tl_rec.meaning := l_oks_cov_types_tl_rec.meaning;

2450: x_oks_cov_types_tl_rec.sfwt_flag := l_oks_cov_types_tl_rec.sfwt_flag;
2451: END IF;
2452: IF (x_oks_cov_types_tl_rec.meaning = OKC_API.G_MISS_CHAR)
2453: THEN
2454: x_oks_cov_types_tl_rec.meaning := l_oks_cov_types_tl_rec.meaning;
2455: END IF;
2456: IF (x_oks_cov_types_tl_rec.description = OKC_API.G_MISS_CHAR)
2457: THEN
2458: x_oks_cov_types_tl_rec.description := l_oks_cov_types_tl_rec.description;

Line 2456: IF (x_oks_cov_types_tl_rec.description = OKC_API.G_MISS_CHAR)

2452: IF (x_oks_cov_types_tl_rec.meaning = OKC_API.G_MISS_CHAR)
2453: THEN
2454: x_oks_cov_types_tl_rec.meaning := l_oks_cov_types_tl_rec.meaning;
2455: END IF;
2456: IF (x_oks_cov_types_tl_rec.description = OKC_API.G_MISS_CHAR)
2457: THEN
2458: x_oks_cov_types_tl_rec.description := l_oks_cov_types_tl_rec.description;
2459: END IF;
2460: IF (x_oks_cov_types_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 2458: x_oks_cov_types_tl_rec.description := l_oks_cov_types_tl_rec.description;

2454: x_oks_cov_types_tl_rec.meaning := l_oks_cov_types_tl_rec.meaning;
2455: END IF;
2456: IF (x_oks_cov_types_tl_rec.description = OKC_API.G_MISS_CHAR)
2457: THEN
2458: x_oks_cov_types_tl_rec.description := l_oks_cov_types_tl_rec.description;
2459: END IF;
2460: IF (x_oks_cov_types_tl_rec.created_by = OKC_API.G_MISS_NUM)
2461: THEN
2462: x_oks_cov_types_tl_rec.created_by := l_oks_cov_types_tl_rec.created_by;

Line 2460: IF (x_oks_cov_types_tl_rec.created_by = OKC_API.G_MISS_NUM)

2456: IF (x_oks_cov_types_tl_rec.description = OKC_API.G_MISS_CHAR)
2457: THEN
2458: x_oks_cov_types_tl_rec.description := l_oks_cov_types_tl_rec.description;
2459: END IF;
2460: IF (x_oks_cov_types_tl_rec.created_by = OKC_API.G_MISS_NUM)
2461: THEN
2462: x_oks_cov_types_tl_rec.created_by := l_oks_cov_types_tl_rec.created_by;
2463: END IF;
2464: IF (x_oks_cov_types_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2462: x_oks_cov_types_tl_rec.created_by := l_oks_cov_types_tl_rec.created_by;

2458: x_oks_cov_types_tl_rec.description := l_oks_cov_types_tl_rec.description;
2459: END IF;
2460: IF (x_oks_cov_types_tl_rec.created_by = OKC_API.G_MISS_NUM)
2461: THEN
2462: x_oks_cov_types_tl_rec.created_by := l_oks_cov_types_tl_rec.created_by;
2463: END IF;
2464: IF (x_oks_cov_types_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2465: THEN
2466: x_oks_cov_types_tl_rec.creation_date := l_oks_cov_types_tl_rec.creation_date;

Line 2464: IF (x_oks_cov_types_tl_rec.creation_date = OKC_API.G_MISS_DATE)

2460: IF (x_oks_cov_types_tl_rec.created_by = OKC_API.G_MISS_NUM)
2461: THEN
2462: x_oks_cov_types_tl_rec.created_by := l_oks_cov_types_tl_rec.created_by;
2463: END IF;
2464: IF (x_oks_cov_types_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2465: THEN
2466: x_oks_cov_types_tl_rec.creation_date := l_oks_cov_types_tl_rec.creation_date;
2467: END IF;
2468: IF (x_oks_cov_types_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2466: x_oks_cov_types_tl_rec.creation_date := l_oks_cov_types_tl_rec.creation_date;

2462: x_oks_cov_types_tl_rec.created_by := l_oks_cov_types_tl_rec.created_by;
2463: END IF;
2464: IF (x_oks_cov_types_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2465: THEN
2466: x_oks_cov_types_tl_rec.creation_date := l_oks_cov_types_tl_rec.creation_date;
2467: END IF;
2468: IF (x_oks_cov_types_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2469: THEN
2470: x_oks_cov_types_tl_rec.last_updated_by := l_oks_cov_types_tl_rec.last_updated_by;

Line 2468: IF (x_oks_cov_types_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

2464: IF (x_oks_cov_types_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2465: THEN
2466: x_oks_cov_types_tl_rec.creation_date := l_oks_cov_types_tl_rec.creation_date;
2467: END IF;
2468: IF (x_oks_cov_types_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2469: THEN
2470: x_oks_cov_types_tl_rec.last_updated_by := l_oks_cov_types_tl_rec.last_updated_by;
2471: END IF;
2472: IF (x_oks_cov_types_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2470: x_oks_cov_types_tl_rec.last_updated_by := l_oks_cov_types_tl_rec.last_updated_by;

2466: x_oks_cov_types_tl_rec.creation_date := l_oks_cov_types_tl_rec.creation_date;
2467: END IF;
2468: IF (x_oks_cov_types_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2469: THEN
2470: x_oks_cov_types_tl_rec.last_updated_by := l_oks_cov_types_tl_rec.last_updated_by;
2471: END IF;
2472: IF (x_oks_cov_types_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2473: THEN
2474: x_oks_cov_types_tl_rec.last_update_login := l_oks_cov_types_tl_rec.last_update_login;

Line 2472: IF (x_oks_cov_types_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

2468: IF (x_oks_cov_types_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2469: THEN
2470: x_oks_cov_types_tl_rec.last_updated_by := l_oks_cov_types_tl_rec.last_updated_by;
2471: END IF;
2472: IF (x_oks_cov_types_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2473: THEN
2474: x_oks_cov_types_tl_rec.last_update_login := l_oks_cov_types_tl_rec.last_update_login;
2475: END IF;
2476: IF (x_oks_cov_types_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2474: x_oks_cov_types_tl_rec.last_update_login := l_oks_cov_types_tl_rec.last_update_login;

2470: x_oks_cov_types_tl_rec.last_updated_by := l_oks_cov_types_tl_rec.last_updated_by;
2471: END IF;
2472: IF (x_oks_cov_types_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2473: THEN
2474: x_oks_cov_types_tl_rec.last_update_login := l_oks_cov_types_tl_rec.last_update_login;
2475: END IF;
2476: IF (x_oks_cov_types_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2477: THEN
2478: x_oks_cov_types_tl_rec.last_update_date := l_oks_cov_types_tl_rec.last_update_date;

Line 2476: IF (x_oks_cov_types_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

2472: IF (x_oks_cov_types_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2473: THEN
2474: x_oks_cov_types_tl_rec.last_update_login := l_oks_cov_types_tl_rec.last_update_login;
2475: END IF;
2476: IF (x_oks_cov_types_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2477: THEN
2478: x_oks_cov_types_tl_rec.last_update_date := l_oks_cov_types_tl_rec.last_update_date;
2479: END IF;
2480: END IF;

Line 2478: x_oks_cov_types_tl_rec.last_update_date := l_oks_cov_types_tl_rec.last_update_date;

2474: x_oks_cov_types_tl_rec.last_update_login := l_oks_cov_types_tl_rec.last_update_login;
2475: END IF;
2476: IF (x_oks_cov_types_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2477: THEN
2478: x_oks_cov_types_tl_rec.last_update_date := l_oks_cov_types_tl_rec.last_update_date;
2479: END IF;
2480: END IF;
2481: RETURN(l_return_status);
2482: END populate_new_record;

Line 2484: -- Set_Attributes for:OKS_COV_TYPES_TL --

2480: END IF;
2481: RETURN(l_return_status);
2482: END populate_new_record;
2483: -----------------------------------------
2484: -- Set_Attributes for:OKS_COV_TYPES_TL --
2485: -----------------------------------------
2486: FUNCTION Set_Attributes (
2487: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
2488: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type

Line 2487: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,

2483: -----------------------------------------
2484: -- Set_Attributes for:OKS_COV_TYPES_TL --
2485: -----------------------------------------
2486: FUNCTION Set_Attributes (
2487: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
2488: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type
2489: ) RETURN VARCHAR2 IS
2490: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2491: BEGIN

Line 2488: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type

2484: -- Set_Attributes for:OKS_COV_TYPES_TL --
2485: -----------------------------------------
2486: FUNCTION Set_Attributes (
2487: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type,
2488: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type
2489: ) RETURN VARCHAR2 IS
2490: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2491: BEGIN
2492: x_oks_cov_types_tl_rec := p_oks_cov_types_tl_rec;

Line 2492: x_oks_cov_types_tl_rec := p_oks_cov_types_tl_rec;

2488: x_oks_cov_types_tl_rec OUT NOCOPY oks_cov_types_tl_rec_type
2489: ) RETURN VARCHAR2 IS
2490: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2491: BEGIN
2492: x_oks_cov_types_tl_rec := p_oks_cov_types_tl_rec;
2493: x_oks_cov_types_tl_rec.LANGUAGE := USERENV('LANG');
2494: x_oks_cov_types_tl_rec.LANGUAGE := USERENV('LANG');
2495: RETURN(l_return_status);
2496: END Set_Attributes;

Line 2493: x_oks_cov_types_tl_rec.LANGUAGE := USERENV('LANG');

2489: ) RETURN VARCHAR2 IS
2490: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2491: BEGIN
2492: x_oks_cov_types_tl_rec := p_oks_cov_types_tl_rec;
2493: x_oks_cov_types_tl_rec.LANGUAGE := USERENV('LANG');
2494: x_oks_cov_types_tl_rec.LANGUAGE := USERENV('LANG');
2495: RETURN(l_return_status);
2496: END Set_Attributes;
2497: BEGIN

Line 2494: x_oks_cov_types_tl_rec.LANGUAGE := USERENV('LANG');

2490: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2491: BEGIN
2492: x_oks_cov_types_tl_rec := p_oks_cov_types_tl_rec;
2493: x_oks_cov_types_tl_rec.LANGUAGE := USERENV('LANG');
2494: x_oks_cov_types_tl_rec.LANGUAGE := USERENV('LANG');
2495: RETURN(l_return_status);
2496: END Set_Attributes;
2497: BEGIN
2498: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2509: p_oks_cov_types_tl_rec, -- IN

2505: RAISE OKC_API.G_EXCEPTION_ERROR;
2506: END IF;
2507: --- Setting item attributes
2508: l_return_status := Set_Attributes(
2509: p_oks_cov_types_tl_rec, -- IN
2510: l_oks_cov_types_tl_rec); -- OUT
2511: --- If any errors happen abort API
2512: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2513: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2510: l_oks_cov_types_tl_rec); -- OUT

2506: END IF;
2507: --- Setting item attributes
2508: l_return_status := Set_Attributes(
2509: p_oks_cov_types_tl_rec, -- IN
2510: l_oks_cov_types_tl_rec); -- OUT
2511: --- If any errors happen abort API
2512: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2513: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2514: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2517: l_return_status := populate_new_record(l_oks_cov_types_tl_rec, l_def_oks_cov_types_tl_rec);

2513: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2514: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2515: RAISE OKC_API.G_EXCEPTION_ERROR;
2516: END IF;
2517: l_return_status := populate_new_record(l_oks_cov_types_tl_rec, l_def_oks_cov_types_tl_rec);
2518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2521: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2523: UPDATE OKS_COV_TYPES_TL

2519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2521: RAISE OKC_API.G_EXCEPTION_ERROR;
2522: END IF;
2523: UPDATE OKS_COV_TYPES_TL
2524: SET MEANING = l_def_oks_cov_types_tl_rec.meaning,
2525: DESCRIPTION = l_def_oks_cov_types_tl_rec.description,
2526: CREATED_BY = l_def_oks_cov_types_tl_rec.created_by,
2527: CREATION_DATE = l_def_oks_cov_types_tl_rec.creation_date,

Line 2524: SET MEANING = l_def_oks_cov_types_tl_rec.meaning,

2520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2521: RAISE OKC_API.G_EXCEPTION_ERROR;
2522: END IF;
2523: UPDATE OKS_COV_TYPES_TL
2524: SET MEANING = l_def_oks_cov_types_tl_rec.meaning,
2525: DESCRIPTION = l_def_oks_cov_types_tl_rec.description,
2526: CREATED_BY = l_def_oks_cov_types_tl_rec.created_by,
2527: CREATION_DATE = l_def_oks_cov_types_tl_rec.creation_date,
2528: LAST_UPDATED_BY = l_def_oks_cov_types_tl_rec.last_updated_by,

Line 2525: DESCRIPTION = l_def_oks_cov_types_tl_rec.description,

2521: RAISE OKC_API.G_EXCEPTION_ERROR;
2522: END IF;
2523: UPDATE OKS_COV_TYPES_TL
2524: SET MEANING = l_def_oks_cov_types_tl_rec.meaning,
2525: DESCRIPTION = l_def_oks_cov_types_tl_rec.description,
2526: CREATED_BY = l_def_oks_cov_types_tl_rec.created_by,
2527: CREATION_DATE = l_def_oks_cov_types_tl_rec.creation_date,
2528: LAST_UPDATED_BY = l_def_oks_cov_types_tl_rec.last_updated_by,
2529: LAST_UPDATE_LOGIN = l_def_oks_cov_types_tl_rec.last_update_login,

Line 2526: CREATED_BY = l_def_oks_cov_types_tl_rec.created_by,

2522: END IF;
2523: UPDATE OKS_COV_TYPES_TL
2524: SET MEANING = l_def_oks_cov_types_tl_rec.meaning,
2525: DESCRIPTION = l_def_oks_cov_types_tl_rec.description,
2526: CREATED_BY = l_def_oks_cov_types_tl_rec.created_by,
2527: CREATION_DATE = l_def_oks_cov_types_tl_rec.creation_date,
2528: LAST_UPDATED_BY = l_def_oks_cov_types_tl_rec.last_updated_by,
2529: LAST_UPDATE_LOGIN = l_def_oks_cov_types_tl_rec.last_update_login,
2530: LAST_UPDATE_DATE = l_def_oks_cov_types_tl_rec.last_update_date

Line 2527: CREATION_DATE = l_def_oks_cov_types_tl_rec.creation_date,

2523: UPDATE OKS_COV_TYPES_TL
2524: SET MEANING = l_def_oks_cov_types_tl_rec.meaning,
2525: DESCRIPTION = l_def_oks_cov_types_tl_rec.description,
2526: CREATED_BY = l_def_oks_cov_types_tl_rec.created_by,
2527: CREATION_DATE = l_def_oks_cov_types_tl_rec.creation_date,
2528: LAST_UPDATED_BY = l_def_oks_cov_types_tl_rec.last_updated_by,
2529: LAST_UPDATE_LOGIN = l_def_oks_cov_types_tl_rec.last_update_login,
2530: LAST_UPDATE_DATE = l_def_oks_cov_types_tl_rec.last_update_date
2531: WHERE CODE = l_def_oks_cov_types_tl_rec.code

Line 2528: LAST_UPDATED_BY = l_def_oks_cov_types_tl_rec.last_updated_by,

2524: SET MEANING = l_def_oks_cov_types_tl_rec.meaning,
2525: DESCRIPTION = l_def_oks_cov_types_tl_rec.description,
2526: CREATED_BY = l_def_oks_cov_types_tl_rec.created_by,
2527: CREATION_DATE = l_def_oks_cov_types_tl_rec.creation_date,
2528: LAST_UPDATED_BY = l_def_oks_cov_types_tl_rec.last_updated_by,
2529: LAST_UPDATE_LOGIN = l_def_oks_cov_types_tl_rec.last_update_login,
2530: LAST_UPDATE_DATE = l_def_oks_cov_types_tl_rec.last_update_date
2531: WHERE CODE = l_def_oks_cov_types_tl_rec.code
2532: AND SOURCE_LANG = USERENV('LANG');

Line 2529: LAST_UPDATE_LOGIN = l_def_oks_cov_types_tl_rec.last_update_login,

2525: DESCRIPTION = l_def_oks_cov_types_tl_rec.description,
2526: CREATED_BY = l_def_oks_cov_types_tl_rec.created_by,
2527: CREATION_DATE = l_def_oks_cov_types_tl_rec.creation_date,
2528: LAST_UPDATED_BY = l_def_oks_cov_types_tl_rec.last_updated_by,
2529: LAST_UPDATE_LOGIN = l_def_oks_cov_types_tl_rec.last_update_login,
2530: LAST_UPDATE_DATE = l_def_oks_cov_types_tl_rec.last_update_date
2531: WHERE CODE = l_def_oks_cov_types_tl_rec.code
2532: AND SOURCE_LANG = USERENV('LANG');
2533:

Line 2530: LAST_UPDATE_DATE = l_def_oks_cov_types_tl_rec.last_update_date

2526: CREATED_BY = l_def_oks_cov_types_tl_rec.created_by,
2527: CREATION_DATE = l_def_oks_cov_types_tl_rec.creation_date,
2528: LAST_UPDATED_BY = l_def_oks_cov_types_tl_rec.last_updated_by,
2529: LAST_UPDATE_LOGIN = l_def_oks_cov_types_tl_rec.last_update_login,
2530: LAST_UPDATE_DATE = l_def_oks_cov_types_tl_rec.last_update_date
2531: WHERE CODE = l_def_oks_cov_types_tl_rec.code
2532: AND SOURCE_LANG = USERENV('LANG');
2533:
2534: UPDATE OKS_COV_TYPES_TL

Line 2531: WHERE CODE = l_def_oks_cov_types_tl_rec.code

2527: CREATION_DATE = l_def_oks_cov_types_tl_rec.creation_date,
2528: LAST_UPDATED_BY = l_def_oks_cov_types_tl_rec.last_updated_by,
2529: LAST_UPDATE_LOGIN = l_def_oks_cov_types_tl_rec.last_update_login,
2530: LAST_UPDATE_DATE = l_def_oks_cov_types_tl_rec.last_update_date
2531: WHERE CODE = l_def_oks_cov_types_tl_rec.code
2532: AND SOURCE_LANG = USERENV('LANG');
2533:
2534: UPDATE OKS_COV_TYPES_TL
2535: SET SFWT_FLAG = 'Y'

Line 2534: UPDATE OKS_COV_TYPES_TL

2530: LAST_UPDATE_DATE = l_def_oks_cov_types_tl_rec.last_update_date
2531: WHERE CODE = l_def_oks_cov_types_tl_rec.code
2532: AND SOURCE_LANG = USERENV('LANG');
2533:
2534: UPDATE OKS_COV_TYPES_TL
2535: SET SFWT_FLAG = 'Y'
2536: WHERE CODE = l_def_oks_cov_types_tl_rec.code
2537: AND SOURCE_LANG <> USERENV('LANG');
2538:

Line 2536: WHERE CODE = l_def_oks_cov_types_tl_rec.code

2532: AND SOURCE_LANG = USERENV('LANG');
2533:
2534: UPDATE OKS_COV_TYPES_TL
2535: SET SFWT_FLAG = 'Y'
2536: WHERE CODE = l_def_oks_cov_types_tl_rec.code
2537: AND SOURCE_LANG <> USERENV('LANG');
2538:
2539: x_oks_cov_types_tl_rec := l_oks_cov_types_tl_rec;
2540: x_return_status := l_return_status;

Line 2539: x_oks_cov_types_tl_rec := l_oks_cov_types_tl_rec;

2535: SET SFWT_FLAG = 'Y'
2536: WHERE CODE = l_def_oks_cov_types_tl_rec.code
2537: AND SOURCE_LANG <> USERENV('LANG');
2538:
2539: x_oks_cov_types_tl_rec := l_oks_cov_types_tl_rec;
2540: x_return_status := l_return_status;
2541: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2542: EXCEPTION
2543: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2594: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;

2590: l_def_cvpv_rec cvpv_rec_type;
2591: l_db_cvpv_rec cvpv_rec_type;
2592: l_cvp_rec cvp_rec_type;
2593: lx_cvp_rec cvp_rec_type;
2594: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
2595: lx_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
2596: -------------------------------
2597: -- FUNCTION fill_who_columns --
2598: -------------------------------

Line 2595: lx_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;

2591: l_db_cvpv_rec cvpv_rec_type;
2592: l_cvp_rec cvp_rec_type;
2593: lx_cvp_rec cvp_rec_type;
2594: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
2595: lx_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
2596: -------------------------------
2597: -- FUNCTION fill_who_columns --
2598: -------------------------------
2599: FUNCTION fill_who_columns (

Line 2819: migrate(l_def_cvpv_rec, l_oks_cov_types_tl_rec);

2815: -----------------------------------------
2816: -- Move VIEW record to "Child" records --
2817: -----------------------------------------
2818: migrate(l_def_cvpv_rec, l_cvp_rec);
2819: migrate(l_def_cvpv_rec, l_oks_cov_types_tl_rec);
2820: -----------------------------------------------
2821: -- Call the UPDATE_ROW for each child record --
2822: -----------------------------------------------
2823: update_row(

Line 2842: l_oks_cov_types_tl_rec,

2838: p_init_msg_list,
2839: l_return_status,
2840: x_msg_count,
2841: x_msg_data,
2842: l_oks_cov_types_tl_rec,
2843: lx_oks_cov_types_tl_rec
2844: );
2845: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2846: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2843: lx_oks_cov_types_tl_rec

2839: l_return_status,
2840: x_msg_count,
2841: x_msg_data,
2842: l_oks_cov_types_tl_rec,
2843: lx_oks_cov_types_tl_rec
2844: );
2845: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2846: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2847: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2850: migrate(lx_oks_cov_types_tl_rec, l_def_cvpv_rec);

2846: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2847: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2848: RAISE OKC_API.G_EXCEPTION_ERROR;
2849: END IF;
2850: migrate(lx_oks_cov_types_tl_rec, l_def_cvpv_rec);
2851: x_cvpv_rec := l_def_cvpv_rec;
2852: x_return_status := l_return_status;
2853: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2854: EXCEPTION

Line 3117: -- delete_row for:OKS_COV_TYPES_TL --

3113: '_PVT'
3114: );
3115: END delete_row;
3116: -------------------------------------
3117: -- delete_row for:OKS_COV_TYPES_TL --
3118: -------------------------------------
3119: PROCEDURE delete_row(
3120: p_init_msg_list IN VARCHAR2,
3121: x_return_status OUT NOCOPY VARCHAR2,

Line 3124: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type) IS

3120: p_init_msg_list IN VARCHAR2,
3121: x_return_status OUT NOCOPY VARCHAR2,
3122: x_msg_count OUT NOCOPY NUMBER,
3123: x_msg_data OUT NOCOPY VARCHAR2,
3124: p_oks_cov_types_tl_rec IN oks_cov_types_tl_rec_type) IS
3125:
3126: l_api_version CONSTANT NUMBER := 1;
3127: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3128: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3129: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type := p_oks_cov_types_tl_rec;

3125:
3126: l_api_version CONSTANT NUMBER := 1;
3127: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3128: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3129: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type := p_oks_cov_types_tl_rec;
3130: l_row_notfound BOOLEAN := TRUE;
3131: BEGIN
3132: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3133: p_init_msg_list,

Line 3142: DELETE FROM OKS_COV_TYPES_TL

3138: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3139: RAISE OKC_API.G_EXCEPTION_ERROR;
3140: END IF;
3141:
3142: DELETE FROM OKS_COV_TYPES_TL
3143: WHERE CODE = p_oks_cov_types_tl_rec.code;
3144:
3145: x_return_status := l_return_status;
3146: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3143: WHERE CODE = p_oks_cov_types_tl_rec.code;

3139: RAISE OKC_API.G_EXCEPTION_ERROR;
3140: END IF;
3141:
3142: DELETE FROM OKS_COV_TYPES_TL
3143: WHERE CODE = p_oks_cov_types_tl_rec.code;
3144:
3145: x_return_status := l_return_status;
3146: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3147: EXCEPTION

Line 3194: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;

3190: l_api_version CONSTANT NUMBER := 1;
3191: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3192: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3193: l_cvpv_rec cvpv_rec_type := p_cvpv_rec;
3194: l_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
3195: l_cvp_rec cvp_rec_type;
3196: BEGIN
3197: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3198: G_PKG_NAME,

Line 3212: migrate(l_cvpv_rec, l_oks_cov_types_tl_rec);

3208: END IF;
3209: -----------------------------------------
3210: -- Move VIEW record to "Child" records --
3211: -----------------------------------------
3212: migrate(l_cvpv_rec, l_oks_cov_types_tl_rec);
3213: migrate(l_cvpv_rec, l_cvp_rec);
3214: -----------------------------------------------
3215: -- Call the DELETE_ROW for each child record --
3216: -----------------------------------------------

Line 3222: l_oks_cov_types_tl_rec

3218: p_init_msg_list,
3219: l_return_status,
3220: x_msg_count,
3221: x_msg_data,
3222: l_oks_cov_types_tl_rec
3223: );
3224: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3225: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3226: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3469: SELECT 'X' FROM OKS_COV_TYPES_TL

3465: SELECT 'X' FROM OKS_COV_TYPES_B
3466: WHERE CODE = v_code ;
3467:
3468: CURSOR CUR_CHECK_EXISTS_TL(v_code VARCHAR2, v_lang VARCHAR2) IS
3469: SELECT 'X' FROM OKS_COV_TYPES_TL
3470: WHERE CODE = v_code
3471: AND LANGUAGE = v_lang ;
3472:
3473: CURSOR CUR_CHECK_SOURCELANG_NULL IS

Line 3474: SELECT 'X' FROM OKS_COV_TYPES_TL

3470: WHERE CODE = v_code
3471: AND LANGUAGE = v_lang ;
3472:
3473: CURSOR CUR_CHECK_SOURCELANG_NULL IS
3474: SELECT 'X' FROM OKS_COV_TYPES_TL
3475: WHERE SOURCE_LANG IS NULL;
3476:
3477:
3478: BEGIN

Line 3568: INSERT INTO OKS_COV_TYPES_TL(CODE,

3564: v_exist:= TRUE;
3565: END LOOP ;
3566:
3567: IF (v_exist = FALSE) THEN
3568: INSERT INTO OKS_COV_TYPES_TL(CODE,
3569: LANGUAGE,
3570: SOURCE_LANG,
3571: SFWT_FLAG,
3572: MEANING,

Line 3602: UPDATE OKS_COV_TYPES_TL

3598: v_sourcelang_null:= TRUE;
3599: END LOOP ;
3600:
3601: IF v_sourcelang_null= TRUE THEN
3602: UPDATE OKS_COV_TYPES_TL
3603: SET SOURCE_LANG=userenv('LANG'),SFWT_FLAG='N'
3604: WHERE SOURCE_LANG IS NULL;
3605: END IF;
3606: EXCEPTION