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.OKC_OCE_PVT dependencies on OKC_OUTCOMES_TL

Line 47: DELETE FROM OKC_OUTCOMES_TL T

43: -- PROCEDURE add_language
44: ---------------------------------------------------------------------------
45: PROCEDURE add_language IS
46: BEGIN
47: DELETE FROM OKC_OUTCOMES_TL T
48: WHERE NOT EXISTS (
49: SELECT NULL
50: FROM OKC_OUTCOMES_B B
51: WHERE B.ID = T.ID

Line 54: UPDATE OKC_OUTCOMES_TL T SET (

50: FROM OKC_OUTCOMES_B B
51: WHERE B.ID = T.ID
52: );
53:
54: UPDATE OKC_OUTCOMES_TL T SET (
55: COMMENTS) = (SELECT
56: B.COMMENTS
57: FROM OKC_OUTCOMES_TL B
58: WHERE B.ID = T.ID

Line 57: FROM OKC_OUTCOMES_TL B

53:
54: UPDATE OKC_OUTCOMES_TL T SET (
55: COMMENTS) = (SELECT
56: B.COMMENTS
57: FROM OKC_OUTCOMES_TL B
58: WHERE B.ID = T.ID
59: AND B.LANGUAGE = T.SOURCE_LANG)
60: WHERE (
61: T.ID,

Line 66: FROM OKC_OUTCOMES_TL SUBB, OKC_OUTCOMES_TL SUBT

62: T.LANGUAGE)
63: IN (SELECT
64: SUBT.ID,
65: SUBT.LANGUAGE
66: FROM OKC_OUTCOMES_TL SUBB, OKC_OUTCOMES_TL SUBT
67: WHERE SUBB.ID = SUBT.ID
68: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
69: AND (SUBB.COMMENTS <> SUBT.COMMENTS
70: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)

Line 74: INSERT INTO OKC_OUTCOMES_TL (

70: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
71: OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
72: ));
73:
74: INSERT INTO OKC_OUTCOMES_TL (
75: ID,
76: LANGUAGE,
77: SOURCE_LANG,
78: SFWT_FLAG,

Line 96: FROM OKC_OUTCOMES_TL B, FND_LANGUAGES L

92: B.CREATION_DATE,
93: B.LAST_UPDATED_BY,
94: B.LAST_UPDATE_DATE,
95: B.LAST_UPDATE_LOGIN
96: FROM OKC_OUTCOMES_TL B, FND_LANGUAGES L
97: WHERE L.INSTALLED_FLAG IN ('I', 'B')
98: AND B.LANGUAGE = USERENV('LANG')
99: AND NOT EXISTS(
100: SELECT NULL

Line 101: FROM OKC_OUTCOMES_TL T

97: WHERE L.INSTALLED_FLAG IN ('I', 'B')
98: AND B.LANGUAGE = USERENV('LANG')
99: AND NOT EXISTS(
100: SELECT NULL
101: FROM OKC_OUTCOMES_TL T
102: WHERE T.ID = B.ID
103: AND T.LANGUAGE = L.LANGUAGE_CODE
104: );
105: DELETE FROM OKC_OUTCOMES_TLH T

Line 105: DELETE FROM OKC_OUTCOMES_TLH T

101: FROM OKC_OUTCOMES_TL T
102: WHERE T.ID = B.ID
103: AND T.LANGUAGE = L.LANGUAGE_CODE
104: );
105: DELETE FROM OKC_OUTCOMES_TLH T
106: WHERE NOT EXISTS (
107: SELECT NULL
108: FROM OKC_OUTCOMES_BH B
109: WHERE B.ID = T.ID

Line 113: UPDATE OKC_OUTCOMES_TLH T SET (

109: WHERE B.ID = T.ID
110: AND B.MAJOR_VERSION = T.MAJOR_VERSION
111: );
112:
113: UPDATE OKC_OUTCOMES_TLH T SET (
114: COMMENTS) = (SELECT
115: B.COMMENTS
116: FROM OKC_OUTCOMES_TLH B
117: WHERE B.ID = T.ID

Line 116: FROM OKC_OUTCOMES_TLH B

112:
113: UPDATE OKC_OUTCOMES_TLH T SET (
114: COMMENTS) = (SELECT
115: B.COMMENTS
116: FROM OKC_OUTCOMES_TLH B
117: WHERE B.ID = T.ID
118: AND B.MAJOR_VERSION = T.MAJOR_VERSION
119: AND B.LANGUAGE = T.SOURCE_LANG)
120: WHERE (

Line 128: FROM OKC_OUTCOMES_TLH SUBB, OKC_OUTCOMES_TLH SUBT

124: IN (SELECT
125: SUBT.ID,
126: SUBT.MAJOR_VERSION,
127: SUBT.LANGUAGE
128: FROM OKC_OUTCOMES_TLH SUBB, OKC_OUTCOMES_TLH SUBT
129: WHERE SUBB.ID = SUBT.ID
130: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
131: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
132: AND (SUBB.COMMENTS <> SUBT.COMMENTS

Line 137: INSERT INTO OKC_OUTCOMES_TLH (

133: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
134: OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
135: ));
136:
137: INSERT INTO OKC_OUTCOMES_TLH (
138: ID,
139: LANGUAGE,
140: MAJOR_VERSION,
141: SOURCE_LANG,

Line 161: FROM OKC_OUTCOMES_TLH B, FND_LANGUAGES L

157: B.CREATION_DATE,
158: B.LAST_UPDATED_BY,
159: B.LAST_UPDATE_DATE,
160: B.LAST_UPDATE_LOGIN
161: FROM OKC_OUTCOMES_TLH B, FND_LANGUAGES L
162: WHERE L.INSTALLED_FLAG IN ('I', 'B')
163: AND B.LANGUAGE = USERENV('LANG')
164: AND NOT EXISTS(
165: SELECT NULL

Line 166: FROM OKC_OUTCOMES_TLH T

162: WHERE L.INSTALLED_FLAG IN ('I', 'B')
163: AND B.LANGUAGE = USERENV('LANG')
164: AND NOT EXISTS(
165: SELECT NULL
166: FROM OKC_OUTCOMES_TLH T
167: WHERE T.ID = B.ID
168: AND T.MAJOR_VERSION = B.MAJOR_VERSION
169: AND T.LANGUAGE = L.LANGUAGE_CODE
170: );

Line 268: -- FUNCTION get_rec for: OKC_OUTCOMES_TL

264: BEGIN
265: RETURN(get_rec(p_oce_rec, l_row_notfound));
266: END get_rec;
267: ---------------------------------------------------------------------------
268: -- FUNCTION get_rec for: OKC_OUTCOMES_TL
269: ---------------------------------------------------------------------------
270: FUNCTION get_rec (
271: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
272: x_no_data_found OUT NOCOPY BOOLEAN

Line 271: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,

267: ---------------------------------------------------------------------------
268: -- FUNCTION get_rec for: OKC_OUTCOMES_TL
269: ---------------------------------------------------------------------------
270: FUNCTION get_rec (
271: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
272: x_no_data_found OUT NOCOPY BOOLEAN
273: ) RETURN okc_outcomes_tl_rec_type IS
274: CURSOR okc_outcomes_tl_pk_csr (p_id IN NUMBER,
275: p_language IN VARCHAR2) IS

Line 273: ) RETURN okc_outcomes_tl_rec_type IS

269: ---------------------------------------------------------------------------
270: FUNCTION get_rec (
271: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
272: x_no_data_found OUT NOCOPY BOOLEAN
273: ) RETURN okc_outcomes_tl_rec_type IS
274: CURSOR okc_outcomes_tl_pk_csr (p_id IN NUMBER,
275: p_language IN VARCHAR2) IS
276: SELECT
277: ID,

Line 274: CURSOR okc_outcomes_tl_pk_csr (p_id IN NUMBER,

270: FUNCTION get_rec (
271: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
272: x_no_data_found OUT NOCOPY BOOLEAN
273: ) RETURN okc_outcomes_tl_rec_type IS
274: CURSOR okc_outcomes_tl_pk_csr (p_id IN NUMBER,
275: p_language IN VARCHAR2) IS
276: SELECT
277: ID,
278: LANGUAGE,

Line 287: FROM Okc_Outcomes_Tl

283: CREATION_DATE,
284: LAST_UPDATED_BY,
285: LAST_UPDATE_DATE,
286: LAST_UPDATE_LOGIN
287: FROM Okc_Outcomes_Tl
288: WHERE okc_outcomes_tl.id = p_id
289: AND okc_outcomes_tl.language = p_language;
290: l_okc_outcomes_tl_pk okc_outcomes_tl_pk_csr%ROWTYPE;
291: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;

Line 288: WHERE okc_outcomes_tl.id = p_id

284: LAST_UPDATED_BY,
285: LAST_UPDATE_DATE,
286: LAST_UPDATE_LOGIN
287: FROM Okc_Outcomes_Tl
288: WHERE okc_outcomes_tl.id = p_id
289: AND okc_outcomes_tl.language = p_language;
290: l_okc_outcomes_tl_pk okc_outcomes_tl_pk_csr%ROWTYPE;
291: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
292: BEGIN

Line 289: AND okc_outcomes_tl.language = p_language;

285: LAST_UPDATE_DATE,
286: LAST_UPDATE_LOGIN
287: FROM Okc_Outcomes_Tl
288: WHERE okc_outcomes_tl.id = p_id
289: AND okc_outcomes_tl.language = p_language;
290: l_okc_outcomes_tl_pk okc_outcomes_tl_pk_csr%ROWTYPE;
291: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
292: BEGIN
293: x_no_data_found := TRUE;

Line 290: l_okc_outcomes_tl_pk okc_outcomes_tl_pk_csr%ROWTYPE;

286: LAST_UPDATE_LOGIN
287: FROM Okc_Outcomes_Tl
288: WHERE okc_outcomes_tl.id = p_id
289: AND okc_outcomes_tl.language = p_language;
290: l_okc_outcomes_tl_pk okc_outcomes_tl_pk_csr%ROWTYPE;
291: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
292: BEGIN
293: x_no_data_found := TRUE;
294: -- Get current database values

Line 291: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;

287: FROM Okc_Outcomes_Tl
288: WHERE okc_outcomes_tl.id = p_id
289: AND okc_outcomes_tl.language = p_language;
290: l_okc_outcomes_tl_pk okc_outcomes_tl_pk_csr%ROWTYPE;
291: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
292: BEGIN
293: x_no_data_found := TRUE;
294: -- Get current database values
295: OPEN okc_outcomes_tl_pk_csr (p_okc_outcomes_tl_rec.id,

Line 295: OPEN okc_outcomes_tl_pk_csr (p_okc_outcomes_tl_rec.id,

291: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
292: BEGIN
293: x_no_data_found := TRUE;
294: -- Get current database values
295: OPEN okc_outcomes_tl_pk_csr (p_okc_outcomes_tl_rec.id,
296: p_okc_outcomes_tl_rec.language);
297: FETCH okc_outcomes_tl_pk_csr INTO
298: l_okc_outcomes_tl_rec.ID,
299: l_okc_outcomes_tl_rec.LANGUAGE,

Line 296: p_okc_outcomes_tl_rec.language);

292: BEGIN
293: x_no_data_found := TRUE;
294: -- Get current database values
295: OPEN okc_outcomes_tl_pk_csr (p_okc_outcomes_tl_rec.id,
296: p_okc_outcomes_tl_rec.language);
297: FETCH okc_outcomes_tl_pk_csr INTO
298: l_okc_outcomes_tl_rec.ID,
299: l_okc_outcomes_tl_rec.LANGUAGE,
300: l_okc_outcomes_tl_rec.SOURCE_LANG,

Line 297: FETCH okc_outcomes_tl_pk_csr INTO

293: x_no_data_found := TRUE;
294: -- Get current database values
295: OPEN okc_outcomes_tl_pk_csr (p_okc_outcomes_tl_rec.id,
296: p_okc_outcomes_tl_rec.language);
297: FETCH okc_outcomes_tl_pk_csr INTO
298: l_okc_outcomes_tl_rec.ID,
299: l_okc_outcomes_tl_rec.LANGUAGE,
300: l_okc_outcomes_tl_rec.SOURCE_LANG,
301: l_okc_outcomes_tl_rec.SFWT_FLAG,

Line 298: l_okc_outcomes_tl_rec.ID,

294: -- Get current database values
295: OPEN okc_outcomes_tl_pk_csr (p_okc_outcomes_tl_rec.id,
296: p_okc_outcomes_tl_rec.language);
297: FETCH okc_outcomes_tl_pk_csr INTO
298: l_okc_outcomes_tl_rec.ID,
299: l_okc_outcomes_tl_rec.LANGUAGE,
300: l_okc_outcomes_tl_rec.SOURCE_LANG,
301: l_okc_outcomes_tl_rec.SFWT_FLAG,
302: l_okc_outcomes_tl_rec.COMMENTS,

Line 299: l_okc_outcomes_tl_rec.LANGUAGE,

295: OPEN okc_outcomes_tl_pk_csr (p_okc_outcomes_tl_rec.id,
296: p_okc_outcomes_tl_rec.language);
297: FETCH okc_outcomes_tl_pk_csr INTO
298: l_okc_outcomes_tl_rec.ID,
299: l_okc_outcomes_tl_rec.LANGUAGE,
300: l_okc_outcomes_tl_rec.SOURCE_LANG,
301: l_okc_outcomes_tl_rec.SFWT_FLAG,
302: l_okc_outcomes_tl_rec.COMMENTS,
303: l_okc_outcomes_tl_rec.CREATED_BY,

Line 300: l_okc_outcomes_tl_rec.SOURCE_LANG,

296: p_okc_outcomes_tl_rec.language);
297: FETCH okc_outcomes_tl_pk_csr INTO
298: l_okc_outcomes_tl_rec.ID,
299: l_okc_outcomes_tl_rec.LANGUAGE,
300: l_okc_outcomes_tl_rec.SOURCE_LANG,
301: l_okc_outcomes_tl_rec.SFWT_FLAG,
302: l_okc_outcomes_tl_rec.COMMENTS,
303: l_okc_outcomes_tl_rec.CREATED_BY,
304: l_okc_outcomes_tl_rec.CREATION_DATE,

Line 301: l_okc_outcomes_tl_rec.SFWT_FLAG,

297: FETCH okc_outcomes_tl_pk_csr INTO
298: l_okc_outcomes_tl_rec.ID,
299: l_okc_outcomes_tl_rec.LANGUAGE,
300: l_okc_outcomes_tl_rec.SOURCE_LANG,
301: l_okc_outcomes_tl_rec.SFWT_FLAG,
302: l_okc_outcomes_tl_rec.COMMENTS,
303: l_okc_outcomes_tl_rec.CREATED_BY,
304: l_okc_outcomes_tl_rec.CREATION_DATE,
305: l_okc_outcomes_tl_rec.LAST_UPDATED_BY,

Line 302: l_okc_outcomes_tl_rec.COMMENTS,

298: l_okc_outcomes_tl_rec.ID,
299: l_okc_outcomes_tl_rec.LANGUAGE,
300: l_okc_outcomes_tl_rec.SOURCE_LANG,
301: l_okc_outcomes_tl_rec.SFWT_FLAG,
302: l_okc_outcomes_tl_rec.COMMENTS,
303: l_okc_outcomes_tl_rec.CREATED_BY,
304: l_okc_outcomes_tl_rec.CREATION_DATE,
305: l_okc_outcomes_tl_rec.LAST_UPDATED_BY,
306: l_okc_outcomes_tl_rec.LAST_UPDATE_DATE,

Line 303: l_okc_outcomes_tl_rec.CREATED_BY,

299: l_okc_outcomes_tl_rec.LANGUAGE,
300: l_okc_outcomes_tl_rec.SOURCE_LANG,
301: l_okc_outcomes_tl_rec.SFWT_FLAG,
302: l_okc_outcomes_tl_rec.COMMENTS,
303: l_okc_outcomes_tl_rec.CREATED_BY,
304: l_okc_outcomes_tl_rec.CREATION_DATE,
305: l_okc_outcomes_tl_rec.LAST_UPDATED_BY,
306: l_okc_outcomes_tl_rec.LAST_UPDATE_DATE,
307: l_okc_outcomes_tl_rec.LAST_UPDATE_LOGIN;

Line 304: l_okc_outcomes_tl_rec.CREATION_DATE,

300: l_okc_outcomes_tl_rec.SOURCE_LANG,
301: l_okc_outcomes_tl_rec.SFWT_FLAG,
302: l_okc_outcomes_tl_rec.COMMENTS,
303: l_okc_outcomes_tl_rec.CREATED_BY,
304: l_okc_outcomes_tl_rec.CREATION_DATE,
305: l_okc_outcomes_tl_rec.LAST_UPDATED_BY,
306: l_okc_outcomes_tl_rec.LAST_UPDATE_DATE,
307: l_okc_outcomes_tl_rec.LAST_UPDATE_LOGIN;
308: x_no_data_found := okc_outcomes_tl_pk_csr%NOTFOUND;

Line 305: l_okc_outcomes_tl_rec.LAST_UPDATED_BY,

301: l_okc_outcomes_tl_rec.SFWT_FLAG,
302: l_okc_outcomes_tl_rec.COMMENTS,
303: l_okc_outcomes_tl_rec.CREATED_BY,
304: l_okc_outcomes_tl_rec.CREATION_DATE,
305: l_okc_outcomes_tl_rec.LAST_UPDATED_BY,
306: l_okc_outcomes_tl_rec.LAST_UPDATE_DATE,
307: l_okc_outcomes_tl_rec.LAST_UPDATE_LOGIN;
308: x_no_data_found := okc_outcomes_tl_pk_csr%NOTFOUND;
309: CLOSE okc_outcomes_tl_pk_csr;

Line 306: l_okc_outcomes_tl_rec.LAST_UPDATE_DATE,

302: l_okc_outcomes_tl_rec.COMMENTS,
303: l_okc_outcomes_tl_rec.CREATED_BY,
304: l_okc_outcomes_tl_rec.CREATION_DATE,
305: l_okc_outcomes_tl_rec.LAST_UPDATED_BY,
306: l_okc_outcomes_tl_rec.LAST_UPDATE_DATE,
307: l_okc_outcomes_tl_rec.LAST_UPDATE_LOGIN;
308: x_no_data_found := okc_outcomes_tl_pk_csr%NOTFOUND;
309: CLOSE okc_outcomes_tl_pk_csr;
310: RETURN(l_okc_outcomes_tl_rec);

Line 307: l_okc_outcomes_tl_rec.LAST_UPDATE_LOGIN;

303: l_okc_outcomes_tl_rec.CREATED_BY,
304: l_okc_outcomes_tl_rec.CREATION_DATE,
305: l_okc_outcomes_tl_rec.LAST_UPDATED_BY,
306: l_okc_outcomes_tl_rec.LAST_UPDATE_DATE,
307: l_okc_outcomes_tl_rec.LAST_UPDATE_LOGIN;
308: x_no_data_found := okc_outcomes_tl_pk_csr%NOTFOUND;
309: CLOSE okc_outcomes_tl_pk_csr;
310: RETURN(l_okc_outcomes_tl_rec);
311: END get_rec;

Line 308: x_no_data_found := okc_outcomes_tl_pk_csr%NOTFOUND;

304: l_okc_outcomes_tl_rec.CREATION_DATE,
305: l_okc_outcomes_tl_rec.LAST_UPDATED_BY,
306: l_okc_outcomes_tl_rec.LAST_UPDATE_DATE,
307: l_okc_outcomes_tl_rec.LAST_UPDATE_LOGIN;
308: x_no_data_found := okc_outcomes_tl_pk_csr%NOTFOUND;
309: CLOSE okc_outcomes_tl_pk_csr;
310: RETURN(l_okc_outcomes_tl_rec);
311: END get_rec;
312:

Line 309: CLOSE okc_outcomes_tl_pk_csr;

305: l_okc_outcomes_tl_rec.LAST_UPDATED_BY,
306: l_okc_outcomes_tl_rec.LAST_UPDATE_DATE,
307: l_okc_outcomes_tl_rec.LAST_UPDATE_LOGIN;
308: x_no_data_found := okc_outcomes_tl_pk_csr%NOTFOUND;
309: CLOSE okc_outcomes_tl_pk_csr;
310: RETURN(l_okc_outcomes_tl_rec);
311: END get_rec;
312:
313: FUNCTION get_rec (

Line 310: RETURN(l_okc_outcomes_tl_rec);

306: l_okc_outcomes_tl_rec.LAST_UPDATE_DATE,
307: l_okc_outcomes_tl_rec.LAST_UPDATE_LOGIN;
308: x_no_data_found := okc_outcomes_tl_pk_csr%NOTFOUND;
309: CLOSE okc_outcomes_tl_pk_csr;
310: RETURN(l_okc_outcomes_tl_rec);
311: END get_rec;
312:
313: FUNCTION get_rec (
314: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type

Line 314: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type

310: RETURN(l_okc_outcomes_tl_rec);
311: END get_rec;
312:
313: FUNCTION get_rec (
314: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type
315: ) RETURN okc_outcomes_tl_rec_type IS
316: l_row_notfound BOOLEAN := TRUE;
317: BEGIN
318: RETURN(get_rec(p_okc_outcomes_tl_rec, l_row_notfound));

Line 315: ) RETURN okc_outcomes_tl_rec_type IS

311: END get_rec;
312:
313: FUNCTION get_rec (
314: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type
315: ) RETURN okc_outcomes_tl_rec_type IS
316: l_row_notfound BOOLEAN := TRUE;
317: BEGIN
318: RETURN(get_rec(p_okc_outcomes_tl_rec, l_row_notfound));
319: END get_rec;

Line 318: RETURN(get_rec(p_okc_outcomes_tl_rec, l_row_notfound));

314: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type
315: ) RETURN okc_outcomes_tl_rec_type IS
316: l_row_notfound BOOLEAN := TRUE;
317: BEGIN
318: RETURN(get_rec(p_okc_outcomes_tl_rec, l_row_notfound));
319: END get_rec;
320: ---------------------------------------------------------------------------
321: -- FUNCTION get_rec for: OKC_OUTCOMES_V
322: ---------------------------------------------------------------------------

Line 1582: p_to OUT NOCOPY okc_outcomes_tl_rec_type

1578: p_to.seeded_flag := p_from.seeded_flag;
1579: END migrate;
1580: PROCEDURE migrate (
1581: p_from IN ocev_rec_type,
1582: p_to OUT NOCOPY okc_outcomes_tl_rec_type
1583: ) IS
1584: BEGIN
1585: p_to.id := p_from.id;
1586: p_to.sfwt_flag := p_from.sfwt_flag;

Line 1595: p_from IN okc_outcomes_tl_rec_type,

1591: p_to.last_update_date := p_from.last_update_date;
1592: p_to.last_update_login := p_from.last_update_login;
1593: END migrate;
1594: PROCEDURE migrate (
1595: p_from IN okc_outcomes_tl_rec_type,
1596: p_to IN OUT NOCOPY ocev_rec_type
1597: ) IS
1598: BEGIN
1599: p_to.id := p_from.id;

Line 1628: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;

1624: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1625: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1626: l_ocev_rec ocev_rec_type := p_ocev_rec;
1627: l_oce_rec oce_rec_type;
1628: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
1629: BEGIN
1630: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1631: G_PKG_NAME,
1632: p_init_msg_list,

Line 1905: -- insert_row for:OKC_OUTCOMES_TL --

1901: '_PVT'
1902: );
1903: END insert_row;
1904: ------------------------------------
1905: -- insert_row for:OKC_OUTCOMES_TL --
1906: ------------------------------------
1907: PROCEDURE insert_row(
1908: p_init_msg_list IN VARCHAR2 ,
1909: x_return_status OUT NOCOPY VARCHAR2,

Line 1912: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,

1908: p_init_msg_list IN VARCHAR2 ,
1909: x_return_status OUT NOCOPY VARCHAR2,
1910: x_msg_count OUT NOCOPY NUMBER,
1911: x_msg_data OUT NOCOPY VARCHAR2,
1912: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
1913: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type) IS
1914:
1915: l_api_version CONSTANT NUMBER := 1;
1916: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1913: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type) IS

1909: x_return_status OUT NOCOPY VARCHAR2,
1910: x_msg_count OUT NOCOPY NUMBER,
1911: x_msg_data OUT NOCOPY VARCHAR2,
1912: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
1913: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type) IS
1914:
1915: l_api_version CONSTANT NUMBER := 1;
1916: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1917: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1918: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type := p_okc_outcomes_tl_rec;

1914:
1915: l_api_version CONSTANT NUMBER := 1;
1916: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1917: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1918: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type := p_okc_outcomes_tl_rec;
1919: l_def_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
1920: CURSOR get_languages IS
1921: SELECT *
1922: FROM FND_LANGUAGES

Line 1919: l_def_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;

1915: l_api_version CONSTANT NUMBER := 1;
1916: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1917: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1918: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type := p_okc_outcomes_tl_rec;
1919: l_def_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
1920: CURSOR get_languages IS
1921: SELECT *
1922: FROM FND_LANGUAGES
1923: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1925: -- Set_Attributes for:OKC_OUTCOMES_TL --

1921: SELECT *
1922: FROM FND_LANGUAGES
1923: WHERE INSTALLED_FLAG IN ('I', 'B');
1924: ----------------------------------------
1925: -- Set_Attributes for:OKC_OUTCOMES_TL --
1926: ----------------------------------------
1927: FUNCTION Set_Attributes (
1928: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
1929: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type

Line 1928: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,

1924: ----------------------------------------
1925: -- Set_Attributes for:OKC_OUTCOMES_TL --
1926: ----------------------------------------
1927: FUNCTION Set_Attributes (
1928: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
1929: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type
1930: ) RETURN VARCHAR2 IS
1931: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1932: BEGIN

Line 1929: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type

1925: -- Set_Attributes for:OKC_OUTCOMES_TL --
1926: ----------------------------------------
1927: FUNCTION Set_Attributes (
1928: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
1929: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type
1930: ) RETURN VARCHAR2 IS
1931: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1932: BEGIN
1933: x_okc_outcomes_tl_rec := p_okc_outcomes_tl_rec;

Line 1933: x_okc_outcomes_tl_rec := p_okc_outcomes_tl_rec;

1929: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type
1930: ) RETURN VARCHAR2 IS
1931: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1932: BEGIN
1933: x_okc_outcomes_tl_rec := p_okc_outcomes_tl_rec;
1934: x_okc_outcomes_tl_rec.LANGUAGE :=l_lang;
1935: x_okc_outcomes_tl_rec.SOURCE_LANG := l_lang;
1936: RETURN(l_return_status);
1937: END Set_Attributes;

Line 1934: x_okc_outcomes_tl_rec.LANGUAGE :=l_lang;

1930: ) RETURN VARCHAR2 IS
1931: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1932: BEGIN
1933: x_okc_outcomes_tl_rec := p_okc_outcomes_tl_rec;
1934: x_okc_outcomes_tl_rec.LANGUAGE :=l_lang;
1935: x_okc_outcomes_tl_rec.SOURCE_LANG := l_lang;
1936: RETURN(l_return_status);
1937: END Set_Attributes;
1938: BEGIN

Line 1935: x_okc_outcomes_tl_rec.SOURCE_LANG := l_lang;

1931: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1932: BEGIN
1933: x_okc_outcomes_tl_rec := p_okc_outcomes_tl_rec;
1934: x_okc_outcomes_tl_rec.LANGUAGE :=l_lang;
1935: x_okc_outcomes_tl_rec.SOURCE_LANG := l_lang;
1936: RETURN(l_return_status);
1937: END Set_Attributes;
1938: BEGIN
1939: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1950: p_okc_outcomes_tl_rec, -- IN

1946: RAISE OKC_API.G_EXCEPTION_ERROR;
1947: END IF;
1948: --- Setting item attributes
1949: l_return_status := Set_Attributes(
1950: p_okc_outcomes_tl_rec, -- IN
1951: l_okc_outcomes_tl_rec); -- OUT
1952: --- If any errors happen abort API
1953: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1954: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1951: l_okc_outcomes_tl_rec); -- OUT

1947: END IF;
1948: --- Setting item attributes
1949: l_return_status := Set_Attributes(
1950: p_okc_outcomes_tl_rec, -- IN
1951: l_okc_outcomes_tl_rec); -- OUT
1952: --- If any errors happen abort API
1953: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1954: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1955: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1959: l_okc_outcomes_tl_rec.language := l_lang_rec.language_code;

1955: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1956: RAISE OKC_API.G_EXCEPTION_ERROR;
1957: END IF;
1958: FOR l_lang_rec IN get_languages LOOP
1959: l_okc_outcomes_tl_rec.language := l_lang_rec.language_code;
1960: INSERT INTO OKC_OUTCOMES_TL(
1961: id,
1962: language,
1963: source_lang,

Line 1960: INSERT INTO OKC_OUTCOMES_TL(

1956: RAISE OKC_API.G_EXCEPTION_ERROR;
1957: END IF;
1958: FOR l_lang_rec IN get_languages LOOP
1959: l_okc_outcomes_tl_rec.language := l_lang_rec.language_code;
1960: INSERT INTO OKC_OUTCOMES_TL(
1961: id,
1962: language,
1963: source_lang,
1964: sfwt_flag,

Line 1972: l_okc_outcomes_tl_rec.id,

1968: last_updated_by,
1969: last_update_date,
1970: last_update_login)
1971: VALUES (
1972: l_okc_outcomes_tl_rec.id,
1973: l_okc_outcomes_tl_rec.language,
1974: l_okc_outcomes_tl_rec.source_lang,
1975: l_okc_outcomes_tl_rec.sfwt_flag,
1976: l_okc_outcomes_tl_rec.comments,

Line 1973: l_okc_outcomes_tl_rec.language,

1969: last_update_date,
1970: last_update_login)
1971: VALUES (
1972: l_okc_outcomes_tl_rec.id,
1973: l_okc_outcomes_tl_rec.language,
1974: l_okc_outcomes_tl_rec.source_lang,
1975: l_okc_outcomes_tl_rec.sfwt_flag,
1976: l_okc_outcomes_tl_rec.comments,
1977: l_okc_outcomes_tl_rec.created_by,

Line 1974: l_okc_outcomes_tl_rec.source_lang,

1970: last_update_login)
1971: VALUES (
1972: l_okc_outcomes_tl_rec.id,
1973: l_okc_outcomes_tl_rec.language,
1974: l_okc_outcomes_tl_rec.source_lang,
1975: l_okc_outcomes_tl_rec.sfwt_flag,
1976: l_okc_outcomes_tl_rec.comments,
1977: l_okc_outcomes_tl_rec.created_by,
1978: l_okc_outcomes_tl_rec.creation_date,

Line 1975: l_okc_outcomes_tl_rec.sfwt_flag,

1971: VALUES (
1972: l_okc_outcomes_tl_rec.id,
1973: l_okc_outcomes_tl_rec.language,
1974: l_okc_outcomes_tl_rec.source_lang,
1975: l_okc_outcomes_tl_rec.sfwt_flag,
1976: l_okc_outcomes_tl_rec.comments,
1977: l_okc_outcomes_tl_rec.created_by,
1978: l_okc_outcomes_tl_rec.creation_date,
1979: l_okc_outcomes_tl_rec.last_updated_by,

Line 1976: l_okc_outcomes_tl_rec.comments,

1972: l_okc_outcomes_tl_rec.id,
1973: l_okc_outcomes_tl_rec.language,
1974: l_okc_outcomes_tl_rec.source_lang,
1975: l_okc_outcomes_tl_rec.sfwt_flag,
1976: l_okc_outcomes_tl_rec.comments,
1977: l_okc_outcomes_tl_rec.created_by,
1978: l_okc_outcomes_tl_rec.creation_date,
1979: l_okc_outcomes_tl_rec.last_updated_by,
1980: l_okc_outcomes_tl_rec.last_update_date,

Line 1977: l_okc_outcomes_tl_rec.created_by,

1973: l_okc_outcomes_tl_rec.language,
1974: l_okc_outcomes_tl_rec.source_lang,
1975: l_okc_outcomes_tl_rec.sfwt_flag,
1976: l_okc_outcomes_tl_rec.comments,
1977: l_okc_outcomes_tl_rec.created_by,
1978: l_okc_outcomes_tl_rec.creation_date,
1979: l_okc_outcomes_tl_rec.last_updated_by,
1980: l_okc_outcomes_tl_rec.last_update_date,
1981: l_okc_outcomes_tl_rec.last_update_login);

Line 1978: l_okc_outcomes_tl_rec.creation_date,

1974: l_okc_outcomes_tl_rec.source_lang,
1975: l_okc_outcomes_tl_rec.sfwt_flag,
1976: l_okc_outcomes_tl_rec.comments,
1977: l_okc_outcomes_tl_rec.created_by,
1978: l_okc_outcomes_tl_rec.creation_date,
1979: l_okc_outcomes_tl_rec.last_updated_by,
1980: l_okc_outcomes_tl_rec.last_update_date,
1981: l_okc_outcomes_tl_rec.last_update_login);
1982: END LOOP;

Line 1979: l_okc_outcomes_tl_rec.last_updated_by,

1975: l_okc_outcomes_tl_rec.sfwt_flag,
1976: l_okc_outcomes_tl_rec.comments,
1977: l_okc_outcomes_tl_rec.created_by,
1978: l_okc_outcomes_tl_rec.creation_date,
1979: l_okc_outcomes_tl_rec.last_updated_by,
1980: l_okc_outcomes_tl_rec.last_update_date,
1981: l_okc_outcomes_tl_rec.last_update_login);
1982: END LOOP;
1983: -- Set OUT values

Line 1980: l_okc_outcomes_tl_rec.last_update_date,

1976: l_okc_outcomes_tl_rec.comments,
1977: l_okc_outcomes_tl_rec.created_by,
1978: l_okc_outcomes_tl_rec.creation_date,
1979: l_okc_outcomes_tl_rec.last_updated_by,
1980: l_okc_outcomes_tl_rec.last_update_date,
1981: l_okc_outcomes_tl_rec.last_update_login);
1982: END LOOP;
1983: -- Set OUT values
1984: x_okc_outcomes_tl_rec := l_okc_outcomes_tl_rec;

Line 1981: l_okc_outcomes_tl_rec.last_update_login);

1977: l_okc_outcomes_tl_rec.created_by,
1978: l_okc_outcomes_tl_rec.creation_date,
1979: l_okc_outcomes_tl_rec.last_updated_by,
1980: l_okc_outcomes_tl_rec.last_update_date,
1981: l_okc_outcomes_tl_rec.last_update_login);
1982: END LOOP;
1983: -- Set OUT values
1984: x_okc_outcomes_tl_rec := l_okc_outcomes_tl_rec;
1985: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1984: x_okc_outcomes_tl_rec := l_okc_outcomes_tl_rec;

1980: l_okc_outcomes_tl_rec.last_update_date,
1981: l_okc_outcomes_tl_rec.last_update_login);
1982: END LOOP;
1983: -- Set OUT values
1984: x_okc_outcomes_tl_rec := l_okc_outcomes_tl_rec;
1985: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1986: EXCEPTION
1987: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1988: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2038: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;

2034: l_ocev_rec ocev_rec_type;
2035: l_def_ocev_rec ocev_rec_type;
2036: l_oce_rec oce_rec_type;
2037: lx_oce_rec oce_rec_type;
2038: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
2039: lx_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
2040: -------------------------------
2041: -- FUNCTION fill_who_columns --
2042: -------------------------------

Line 2039: lx_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;

2035: l_def_ocev_rec ocev_rec_type;
2036: l_oce_rec oce_rec_type;
2037: lx_oce_rec oce_rec_type;
2038: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
2039: lx_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
2040: -------------------------------
2041: -- FUNCTION fill_who_columns --
2042: -------------------------------
2043: FUNCTION fill_who_columns (

Line 2124: migrate(l_def_ocev_rec, l_okc_outcomes_tl_rec);

2120: --------------------------------------
2121: -- Move VIEW record to "Child" records
2122: --------------------------------------
2123: migrate(l_def_ocev_rec, l_oce_rec);
2124: migrate(l_def_ocev_rec, l_okc_outcomes_tl_rec);
2125: --------------------------------------------
2126: -- Call the INSERT_ROW for each child record
2127: --------------------------------------------
2128: insert_row(

Line 2147: l_okc_outcomes_tl_rec,

2143: p_init_msg_list,
2144: x_return_status,
2145: x_msg_count,
2146: x_msg_data,
2147: l_okc_outcomes_tl_rec,
2148: lx_okc_outcomes_tl_rec
2149: );
2150: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2151: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2148: lx_okc_outcomes_tl_rec

2144: x_return_status,
2145: x_msg_count,
2146: x_msg_data,
2147: l_okc_outcomes_tl_rec,
2148: lx_okc_outcomes_tl_rec
2149: );
2150: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2151: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2152: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2155: migrate(lx_okc_outcomes_tl_rec, l_def_ocev_rec);

2151: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2152: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2153: RAISE OKC_API.G_EXCEPTION_ERROR;
2154: END IF;
2155: migrate(lx_okc_outcomes_tl_rec, l_def_ocev_rec);
2156: -- Set OUT values
2157: x_ocev_rec := l_def_ocev_rec;
2158: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2159: EXCEPTION

Line 2368: -- lock_row for:OKC_OUTCOMES_TL --

2364: '_PVT'
2365: );
2366: END lock_row;
2367: ----------------------------------
2368: -- lock_row for:OKC_OUTCOMES_TL --
2369: ----------------------------------
2370: PROCEDURE lock_row(
2371: p_init_msg_list IN VARCHAR2 ,
2372: x_return_status OUT NOCOPY VARCHAR2,

Line 2375: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type) IS

2371: p_init_msg_list IN VARCHAR2 ,
2372: x_return_status OUT NOCOPY VARCHAR2,
2373: x_msg_count OUT NOCOPY NUMBER,
2374: x_msg_data OUT NOCOPY VARCHAR2,
2375: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type) IS
2376:
2377: E_Resource_Busy EXCEPTION;
2378: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2379: CURSOR lock_csr (p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type) IS

Line 2379: CURSOR lock_csr (p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type) IS

2375: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type) IS
2376:
2377: E_Resource_Busy EXCEPTION;
2378: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2379: CURSOR lock_csr (p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type) IS
2380: SELECT *
2381: FROM OKC_OUTCOMES_TL
2382: WHERE ID = p_okc_outcomes_tl_rec.id
2383: FOR UPDATE NOWAIT;

Line 2381: FROM OKC_OUTCOMES_TL

2377: E_Resource_Busy EXCEPTION;
2378: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2379: CURSOR lock_csr (p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type) IS
2380: SELECT *
2381: FROM OKC_OUTCOMES_TL
2382: WHERE ID = p_okc_outcomes_tl_rec.id
2383: FOR UPDATE NOWAIT;
2384:
2385: l_api_version CONSTANT NUMBER := 1;

Line 2382: WHERE ID = p_okc_outcomes_tl_rec.id

2378: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2379: CURSOR lock_csr (p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type) IS
2380: SELECT *
2381: FROM OKC_OUTCOMES_TL
2382: WHERE ID = p_okc_outcomes_tl_rec.id
2383: FOR UPDATE NOWAIT;
2384:
2385: l_api_version CONSTANT NUMBER := 1;
2386: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2402: OPEN lock_csr(p_okc_outcomes_tl_rec);

2398: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2399: RAISE OKC_API.G_EXCEPTION_ERROR;
2400: END IF;
2401: BEGIN
2402: OPEN lock_csr(p_okc_outcomes_tl_rec);
2403: FETCH lock_csr INTO l_lock_var;
2404: l_row_notfound := lock_csr%NOTFOUND;
2405: CLOSE lock_csr;
2406: EXCEPTION

Line 2467: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;

2463: l_api_version CONSTANT NUMBER := 1;
2464: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2465: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2466: l_oce_rec oce_rec_type;
2467: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
2468: BEGIN
2469: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2470: G_PKG_NAME,
2471: p_init_msg_list,

Line 2485: migrate(p_ocev_rec, l_okc_outcomes_tl_rec);

2481: --------------------------------------
2482: -- Move VIEW record to "Child" records
2483: --------------------------------------
2484: migrate(p_ocev_rec, l_oce_rec);
2485: migrate(p_ocev_rec, l_okc_outcomes_tl_rec);
2486: --------------------------------------------
2487: -- Call the LOCK_ROW for each child record
2488: --------------------------------------------
2489: lock_row(

Line 2506: l_okc_outcomes_tl_rec

2502: p_init_msg_list,
2503: x_return_status,
2504: x_msg_count,
2505: x_msg_data,
2506: l_okc_outcomes_tl_rec
2507: );
2508: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2509: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2510: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2880: -- update_row for:OKC_OUTCOMES_TL --

2876: '_PVT'
2877: );
2878: END update_row;
2879: ------------------------------------
2880: -- update_row for:OKC_OUTCOMES_TL --
2881: ------------------------------------
2882: PROCEDURE update_row(
2883: p_init_msg_list IN VARCHAR2 ,
2884: x_return_status OUT NOCOPY VARCHAR2,

Line 2887: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,

2883: p_init_msg_list IN VARCHAR2 ,
2884: x_return_status OUT NOCOPY VARCHAR2,
2885: x_msg_count OUT NOCOPY NUMBER,
2886: x_msg_data OUT NOCOPY VARCHAR2,
2887: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
2888: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type) IS
2889:
2890: l_api_version CONSTANT NUMBER := 1;
2891: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2888: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type) IS

2884: x_return_status OUT NOCOPY VARCHAR2,
2885: x_msg_count OUT NOCOPY NUMBER,
2886: x_msg_data OUT NOCOPY VARCHAR2,
2887: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
2888: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type) IS
2889:
2890: l_api_version CONSTANT NUMBER := 1;
2891: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2892: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2893: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type := p_okc_outcomes_tl_rec;

2889:
2890: l_api_version CONSTANT NUMBER := 1;
2891: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2892: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2893: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type := p_okc_outcomes_tl_rec;
2894: l_def_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
2895: l_row_notfound BOOLEAN := TRUE;
2896: ----------------------------------
2897: -- FUNCTION populate_new_record --

Line 2894: l_def_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;

2890: l_api_version CONSTANT NUMBER := 1;
2891: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2892: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2893: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type := p_okc_outcomes_tl_rec;
2894: l_def_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
2895: l_row_notfound BOOLEAN := TRUE;
2896: ----------------------------------
2897: -- FUNCTION populate_new_record --
2898: ----------------------------------

Line 2900: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,

2896: ----------------------------------
2897: -- FUNCTION populate_new_record --
2898: ----------------------------------
2899: FUNCTION populate_new_record (
2900: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
2901: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type
2902: ) RETURN VARCHAR2 IS
2903: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
2904: l_row_notfound BOOLEAN := TRUE;

Line 2901: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type

2897: -- FUNCTION populate_new_record --
2898: ----------------------------------
2899: FUNCTION populate_new_record (
2900: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
2901: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type
2902: ) RETURN VARCHAR2 IS
2903: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
2904: l_row_notfound BOOLEAN := TRUE;
2905: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2903: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;

2899: FUNCTION populate_new_record (
2900: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
2901: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type
2902: ) RETURN VARCHAR2 IS
2903: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
2904: l_row_notfound BOOLEAN := TRUE;
2905: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2906: BEGIN
2907: x_okc_outcomes_tl_rec := p_okc_outcomes_tl_rec;

Line 2907: x_okc_outcomes_tl_rec := p_okc_outcomes_tl_rec;

2903: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
2904: l_row_notfound BOOLEAN := TRUE;
2905: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2906: BEGIN
2907: x_okc_outcomes_tl_rec := p_okc_outcomes_tl_rec;
2908: -- Get current database values
2909: l_okc_outcomes_tl_rec := get_rec(p_okc_outcomes_tl_rec, l_row_notfound);
2910: IF (l_row_notfound) THEN
2911: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2909: l_okc_outcomes_tl_rec := get_rec(p_okc_outcomes_tl_rec, l_row_notfound);

2905: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2906: BEGIN
2907: x_okc_outcomes_tl_rec := p_okc_outcomes_tl_rec;
2908: -- Get current database values
2909: l_okc_outcomes_tl_rec := get_rec(p_okc_outcomes_tl_rec, l_row_notfound);
2910: IF (l_row_notfound) THEN
2911: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2912: END IF;
2913: IF (x_okc_outcomes_tl_rec.id = OKC_API.G_MISS_NUM)

Line 2913: IF (x_okc_outcomes_tl_rec.id = OKC_API.G_MISS_NUM)

2909: l_okc_outcomes_tl_rec := get_rec(p_okc_outcomes_tl_rec, l_row_notfound);
2910: IF (l_row_notfound) THEN
2911: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2912: END IF;
2913: IF (x_okc_outcomes_tl_rec.id = OKC_API.G_MISS_NUM)
2914: THEN
2915: x_okc_outcomes_tl_rec.id := l_okc_outcomes_tl_rec.id;
2916: END IF;
2917: IF (x_okc_outcomes_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 2915: x_okc_outcomes_tl_rec.id := l_okc_outcomes_tl_rec.id;

2911: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2912: END IF;
2913: IF (x_okc_outcomes_tl_rec.id = OKC_API.G_MISS_NUM)
2914: THEN
2915: x_okc_outcomes_tl_rec.id := l_okc_outcomes_tl_rec.id;
2916: END IF;
2917: IF (x_okc_outcomes_tl_rec.language = OKC_API.G_MISS_CHAR)
2918: THEN
2919: x_okc_outcomes_tl_rec.language := l_okc_outcomes_tl_rec.language;

Line 2917: IF (x_okc_outcomes_tl_rec.language = OKC_API.G_MISS_CHAR)

2913: IF (x_okc_outcomes_tl_rec.id = OKC_API.G_MISS_NUM)
2914: THEN
2915: x_okc_outcomes_tl_rec.id := l_okc_outcomes_tl_rec.id;
2916: END IF;
2917: IF (x_okc_outcomes_tl_rec.language = OKC_API.G_MISS_CHAR)
2918: THEN
2919: x_okc_outcomes_tl_rec.language := l_okc_outcomes_tl_rec.language;
2920: END IF;
2921: IF (x_okc_outcomes_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 2919: x_okc_outcomes_tl_rec.language := l_okc_outcomes_tl_rec.language;

2915: x_okc_outcomes_tl_rec.id := l_okc_outcomes_tl_rec.id;
2916: END IF;
2917: IF (x_okc_outcomes_tl_rec.language = OKC_API.G_MISS_CHAR)
2918: THEN
2919: x_okc_outcomes_tl_rec.language := l_okc_outcomes_tl_rec.language;
2920: END IF;
2921: IF (x_okc_outcomes_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2922: THEN
2923: x_okc_outcomes_tl_rec.source_lang := l_okc_outcomes_tl_rec.source_lang;

Line 2921: IF (x_okc_outcomes_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

2917: IF (x_okc_outcomes_tl_rec.language = OKC_API.G_MISS_CHAR)
2918: THEN
2919: x_okc_outcomes_tl_rec.language := l_okc_outcomes_tl_rec.language;
2920: END IF;
2921: IF (x_okc_outcomes_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2922: THEN
2923: x_okc_outcomes_tl_rec.source_lang := l_okc_outcomes_tl_rec.source_lang;
2924: END IF;
2925: IF (x_okc_outcomes_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 2923: x_okc_outcomes_tl_rec.source_lang := l_okc_outcomes_tl_rec.source_lang;

2919: x_okc_outcomes_tl_rec.language := l_okc_outcomes_tl_rec.language;
2920: END IF;
2921: IF (x_okc_outcomes_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2922: THEN
2923: x_okc_outcomes_tl_rec.source_lang := l_okc_outcomes_tl_rec.source_lang;
2924: END IF;
2925: IF (x_okc_outcomes_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2926: THEN
2927: x_okc_outcomes_tl_rec.sfwt_flag := l_okc_outcomes_tl_rec.sfwt_flag;

Line 2925: IF (x_okc_outcomes_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

2921: IF (x_okc_outcomes_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2922: THEN
2923: x_okc_outcomes_tl_rec.source_lang := l_okc_outcomes_tl_rec.source_lang;
2924: END IF;
2925: IF (x_okc_outcomes_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2926: THEN
2927: x_okc_outcomes_tl_rec.sfwt_flag := l_okc_outcomes_tl_rec.sfwt_flag;
2928: END IF;
2929: IF (x_okc_outcomes_tl_rec.comments = OKC_API.G_MISS_CHAR)

Line 2927: x_okc_outcomes_tl_rec.sfwt_flag := l_okc_outcomes_tl_rec.sfwt_flag;

2923: x_okc_outcomes_tl_rec.source_lang := l_okc_outcomes_tl_rec.source_lang;
2924: END IF;
2925: IF (x_okc_outcomes_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2926: THEN
2927: x_okc_outcomes_tl_rec.sfwt_flag := l_okc_outcomes_tl_rec.sfwt_flag;
2928: END IF;
2929: IF (x_okc_outcomes_tl_rec.comments = OKC_API.G_MISS_CHAR)
2930: THEN
2931: x_okc_outcomes_tl_rec.comments := l_okc_outcomes_tl_rec.comments;

Line 2929: IF (x_okc_outcomes_tl_rec.comments = OKC_API.G_MISS_CHAR)

2925: IF (x_okc_outcomes_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2926: THEN
2927: x_okc_outcomes_tl_rec.sfwt_flag := l_okc_outcomes_tl_rec.sfwt_flag;
2928: END IF;
2929: IF (x_okc_outcomes_tl_rec.comments = OKC_API.G_MISS_CHAR)
2930: THEN
2931: x_okc_outcomes_tl_rec.comments := l_okc_outcomes_tl_rec.comments;
2932: END IF;
2933: IF (x_okc_outcomes_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 2931: x_okc_outcomes_tl_rec.comments := l_okc_outcomes_tl_rec.comments;

2927: x_okc_outcomes_tl_rec.sfwt_flag := l_okc_outcomes_tl_rec.sfwt_flag;
2928: END IF;
2929: IF (x_okc_outcomes_tl_rec.comments = OKC_API.G_MISS_CHAR)
2930: THEN
2931: x_okc_outcomes_tl_rec.comments := l_okc_outcomes_tl_rec.comments;
2932: END IF;
2933: IF (x_okc_outcomes_tl_rec.created_by = OKC_API.G_MISS_NUM)
2934: THEN
2935: x_okc_outcomes_tl_rec.created_by := l_okc_outcomes_tl_rec.created_by;

Line 2933: IF (x_okc_outcomes_tl_rec.created_by = OKC_API.G_MISS_NUM)

2929: IF (x_okc_outcomes_tl_rec.comments = OKC_API.G_MISS_CHAR)
2930: THEN
2931: x_okc_outcomes_tl_rec.comments := l_okc_outcomes_tl_rec.comments;
2932: END IF;
2933: IF (x_okc_outcomes_tl_rec.created_by = OKC_API.G_MISS_NUM)
2934: THEN
2935: x_okc_outcomes_tl_rec.created_by := l_okc_outcomes_tl_rec.created_by;
2936: END IF;
2937: IF (x_okc_outcomes_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2935: x_okc_outcomes_tl_rec.created_by := l_okc_outcomes_tl_rec.created_by;

2931: x_okc_outcomes_tl_rec.comments := l_okc_outcomes_tl_rec.comments;
2932: END IF;
2933: IF (x_okc_outcomes_tl_rec.created_by = OKC_API.G_MISS_NUM)
2934: THEN
2935: x_okc_outcomes_tl_rec.created_by := l_okc_outcomes_tl_rec.created_by;
2936: END IF;
2937: IF (x_okc_outcomes_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2938: THEN
2939: x_okc_outcomes_tl_rec.creation_date := l_okc_outcomes_tl_rec.creation_date;

Line 2937: IF (x_okc_outcomes_tl_rec.creation_date = OKC_API.G_MISS_DATE)

2933: IF (x_okc_outcomes_tl_rec.created_by = OKC_API.G_MISS_NUM)
2934: THEN
2935: x_okc_outcomes_tl_rec.created_by := l_okc_outcomes_tl_rec.created_by;
2936: END IF;
2937: IF (x_okc_outcomes_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2938: THEN
2939: x_okc_outcomes_tl_rec.creation_date := l_okc_outcomes_tl_rec.creation_date;
2940: END IF;
2941: IF (x_okc_outcomes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2939: x_okc_outcomes_tl_rec.creation_date := l_okc_outcomes_tl_rec.creation_date;

2935: x_okc_outcomes_tl_rec.created_by := l_okc_outcomes_tl_rec.created_by;
2936: END IF;
2937: IF (x_okc_outcomes_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2938: THEN
2939: x_okc_outcomes_tl_rec.creation_date := l_okc_outcomes_tl_rec.creation_date;
2940: END IF;
2941: IF (x_okc_outcomes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2942: THEN
2943: x_okc_outcomes_tl_rec.last_updated_by := l_okc_outcomes_tl_rec.last_updated_by;

Line 2941: IF (x_okc_outcomes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

2937: IF (x_okc_outcomes_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2938: THEN
2939: x_okc_outcomes_tl_rec.creation_date := l_okc_outcomes_tl_rec.creation_date;
2940: END IF;
2941: IF (x_okc_outcomes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2942: THEN
2943: x_okc_outcomes_tl_rec.last_updated_by := l_okc_outcomes_tl_rec.last_updated_by;
2944: END IF;
2945: IF (x_okc_outcomes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2943: x_okc_outcomes_tl_rec.last_updated_by := l_okc_outcomes_tl_rec.last_updated_by;

2939: x_okc_outcomes_tl_rec.creation_date := l_okc_outcomes_tl_rec.creation_date;
2940: END IF;
2941: IF (x_okc_outcomes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2942: THEN
2943: x_okc_outcomes_tl_rec.last_updated_by := l_okc_outcomes_tl_rec.last_updated_by;
2944: END IF;
2945: IF (x_okc_outcomes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2946: THEN
2947: x_okc_outcomes_tl_rec.last_update_date := l_okc_outcomes_tl_rec.last_update_date;

Line 2945: IF (x_okc_outcomes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

2941: IF (x_okc_outcomes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2942: THEN
2943: x_okc_outcomes_tl_rec.last_updated_by := l_okc_outcomes_tl_rec.last_updated_by;
2944: END IF;
2945: IF (x_okc_outcomes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2946: THEN
2947: x_okc_outcomes_tl_rec.last_update_date := l_okc_outcomes_tl_rec.last_update_date;
2948: END IF;
2949: IF (x_okc_outcomes_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2947: x_okc_outcomes_tl_rec.last_update_date := l_okc_outcomes_tl_rec.last_update_date;

2943: x_okc_outcomes_tl_rec.last_updated_by := l_okc_outcomes_tl_rec.last_updated_by;
2944: END IF;
2945: IF (x_okc_outcomes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2946: THEN
2947: x_okc_outcomes_tl_rec.last_update_date := l_okc_outcomes_tl_rec.last_update_date;
2948: END IF;
2949: IF (x_okc_outcomes_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2950: THEN
2951: x_okc_outcomes_tl_rec.last_update_login := l_okc_outcomes_tl_rec.last_update_login;

Line 2949: IF (x_okc_outcomes_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

2945: IF (x_okc_outcomes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2946: THEN
2947: x_okc_outcomes_tl_rec.last_update_date := l_okc_outcomes_tl_rec.last_update_date;
2948: END IF;
2949: IF (x_okc_outcomes_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2950: THEN
2951: x_okc_outcomes_tl_rec.last_update_login := l_okc_outcomes_tl_rec.last_update_login;
2952: END IF;
2953: RETURN(l_return_status);

Line 2951: x_okc_outcomes_tl_rec.last_update_login := l_okc_outcomes_tl_rec.last_update_login;

2947: x_okc_outcomes_tl_rec.last_update_date := l_okc_outcomes_tl_rec.last_update_date;
2948: END IF;
2949: IF (x_okc_outcomes_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2950: THEN
2951: x_okc_outcomes_tl_rec.last_update_login := l_okc_outcomes_tl_rec.last_update_login;
2952: END IF;
2953: RETURN(l_return_status);
2954: END populate_new_record;
2955: ----------------------------------------

Line 2956: -- Set_Attributes for:OKC_OUTCOMES_TL --

2952: END IF;
2953: RETURN(l_return_status);
2954: END populate_new_record;
2955: ----------------------------------------
2956: -- Set_Attributes for:OKC_OUTCOMES_TL --
2957: ----------------------------------------
2958: FUNCTION Set_Attributes (
2959: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
2960: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type

Line 2959: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,

2955: ----------------------------------------
2956: -- Set_Attributes for:OKC_OUTCOMES_TL --
2957: ----------------------------------------
2958: FUNCTION Set_Attributes (
2959: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
2960: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type
2961: ) RETURN VARCHAR2 IS
2962: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2963: BEGIN

Line 2960: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type

2956: -- Set_Attributes for:OKC_OUTCOMES_TL --
2957: ----------------------------------------
2958: FUNCTION Set_Attributes (
2959: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
2960: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type
2961: ) RETURN VARCHAR2 IS
2962: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2963: BEGIN
2964: x_okc_outcomes_tl_rec := p_okc_outcomes_tl_rec;

Line 2964: x_okc_outcomes_tl_rec := p_okc_outcomes_tl_rec;

2960: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type
2961: ) RETURN VARCHAR2 IS
2962: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2963: BEGIN
2964: x_okc_outcomes_tl_rec := p_okc_outcomes_tl_rec;
2965: x_okc_outcomes_tl_rec.LANGUAGE := l_lang;
2966: x_okc_outcomes_tl_rec.SOURCE_LANG := l_lang;
2967: RETURN(l_return_status);
2968: END Set_Attributes;

Line 2965: x_okc_outcomes_tl_rec.LANGUAGE := l_lang;

2961: ) RETURN VARCHAR2 IS
2962: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2963: BEGIN
2964: x_okc_outcomes_tl_rec := p_okc_outcomes_tl_rec;
2965: x_okc_outcomes_tl_rec.LANGUAGE := l_lang;
2966: x_okc_outcomes_tl_rec.SOURCE_LANG := l_lang;
2967: RETURN(l_return_status);
2968: END Set_Attributes;
2969: BEGIN

Line 2966: x_okc_outcomes_tl_rec.SOURCE_LANG := l_lang;

2962: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2963: BEGIN
2964: x_okc_outcomes_tl_rec := p_okc_outcomes_tl_rec;
2965: x_okc_outcomes_tl_rec.LANGUAGE := l_lang;
2966: x_okc_outcomes_tl_rec.SOURCE_LANG := l_lang;
2967: RETURN(l_return_status);
2968: END Set_Attributes;
2969: BEGIN
2970: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2981: p_okc_outcomes_tl_rec, -- IN

2977: RAISE OKC_API.G_EXCEPTION_ERROR;
2978: END IF;
2979: --- Setting item attributes
2980: l_return_status := Set_Attributes(
2981: p_okc_outcomes_tl_rec, -- IN
2982: l_okc_outcomes_tl_rec); -- OUT
2983: --- If any errors happen abort API
2984: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2985: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2982: l_okc_outcomes_tl_rec); -- OUT

2978: END IF;
2979: --- Setting item attributes
2980: l_return_status := Set_Attributes(
2981: p_okc_outcomes_tl_rec, -- IN
2982: l_okc_outcomes_tl_rec); -- OUT
2983: --- If any errors happen abort API
2984: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2985: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2986: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2989: l_return_status := populate_new_record(l_okc_outcomes_tl_rec, l_def_okc_outcomes_tl_rec);

2985: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2986: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2987: RAISE OKC_API.G_EXCEPTION_ERROR;
2988: END IF;
2989: l_return_status := populate_new_record(l_okc_outcomes_tl_rec, l_def_okc_outcomes_tl_rec);
2990: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2991: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2992: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2993: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2995: UPDATE OKC_OUTCOMES_TL

2991: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2992: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2993: RAISE OKC_API.G_EXCEPTION_ERROR;
2994: END IF;
2995: UPDATE OKC_OUTCOMES_TL
2996: SET COMMENTS = l_def_okc_outcomes_tl_rec.comments,
2997: SOURCE_LANG = l_def_okc_outcomes_tl_rec.source_lang,
2998: CREATED_BY = l_def_okc_outcomes_tl_rec.created_by,
2999: CREATION_DATE = l_def_okc_outcomes_tl_rec.creation_date,

Line 2996: SET COMMENTS = l_def_okc_outcomes_tl_rec.comments,

2992: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2993: RAISE OKC_API.G_EXCEPTION_ERROR;
2994: END IF;
2995: UPDATE OKC_OUTCOMES_TL
2996: SET COMMENTS = l_def_okc_outcomes_tl_rec.comments,
2997: SOURCE_LANG = l_def_okc_outcomes_tl_rec.source_lang,
2998: CREATED_BY = l_def_okc_outcomes_tl_rec.created_by,
2999: CREATION_DATE = l_def_okc_outcomes_tl_rec.creation_date,
3000: LAST_UPDATED_BY = l_def_okc_outcomes_tl_rec.last_updated_by,

Line 2997: SOURCE_LANG = l_def_okc_outcomes_tl_rec.source_lang,

2993: RAISE OKC_API.G_EXCEPTION_ERROR;
2994: END IF;
2995: UPDATE OKC_OUTCOMES_TL
2996: SET COMMENTS = l_def_okc_outcomes_tl_rec.comments,
2997: SOURCE_LANG = l_def_okc_outcomes_tl_rec.source_lang,
2998: CREATED_BY = l_def_okc_outcomes_tl_rec.created_by,
2999: CREATION_DATE = l_def_okc_outcomes_tl_rec.creation_date,
3000: LAST_UPDATED_BY = l_def_okc_outcomes_tl_rec.last_updated_by,
3001: LAST_UPDATE_DATE = l_def_okc_outcomes_tl_rec.last_update_date,

Line 2998: CREATED_BY = l_def_okc_outcomes_tl_rec.created_by,

2994: END IF;
2995: UPDATE OKC_OUTCOMES_TL
2996: SET COMMENTS = l_def_okc_outcomes_tl_rec.comments,
2997: SOURCE_LANG = l_def_okc_outcomes_tl_rec.source_lang,
2998: CREATED_BY = l_def_okc_outcomes_tl_rec.created_by,
2999: CREATION_DATE = l_def_okc_outcomes_tl_rec.creation_date,
3000: LAST_UPDATED_BY = l_def_okc_outcomes_tl_rec.last_updated_by,
3001: LAST_UPDATE_DATE = l_def_okc_outcomes_tl_rec.last_update_date,
3002: LAST_UPDATE_LOGIN = l_def_okc_outcomes_tl_rec.last_update_login

Line 2999: CREATION_DATE = l_def_okc_outcomes_tl_rec.creation_date,

2995: UPDATE OKC_OUTCOMES_TL
2996: SET COMMENTS = l_def_okc_outcomes_tl_rec.comments,
2997: SOURCE_LANG = l_def_okc_outcomes_tl_rec.source_lang,
2998: CREATED_BY = l_def_okc_outcomes_tl_rec.created_by,
2999: CREATION_DATE = l_def_okc_outcomes_tl_rec.creation_date,
3000: LAST_UPDATED_BY = l_def_okc_outcomes_tl_rec.last_updated_by,
3001: LAST_UPDATE_DATE = l_def_okc_outcomes_tl_rec.last_update_date,
3002: LAST_UPDATE_LOGIN = l_def_okc_outcomes_tl_rec.last_update_login
3003: WHERE ID = l_def_okc_outcomes_tl_rec.id

Line 3000: LAST_UPDATED_BY = l_def_okc_outcomes_tl_rec.last_updated_by,

2996: SET COMMENTS = l_def_okc_outcomes_tl_rec.comments,
2997: SOURCE_LANG = l_def_okc_outcomes_tl_rec.source_lang,
2998: CREATED_BY = l_def_okc_outcomes_tl_rec.created_by,
2999: CREATION_DATE = l_def_okc_outcomes_tl_rec.creation_date,
3000: LAST_UPDATED_BY = l_def_okc_outcomes_tl_rec.last_updated_by,
3001: LAST_UPDATE_DATE = l_def_okc_outcomes_tl_rec.last_update_date,
3002: LAST_UPDATE_LOGIN = l_def_okc_outcomes_tl_rec.last_update_login
3003: WHERE ID = l_def_okc_outcomes_tl_rec.id
3004: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);

Line 3001: LAST_UPDATE_DATE = l_def_okc_outcomes_tl_rec.last_update_date,

2997: SOURCE_LANG = l_def_okc_outcomes_tl_rec.source_lang,
2998: CREATED_BY = l_def_okc_outcomes_tl_rec.created_by,
2999: CREATION_DATE = l_def_okc_outcomes_tl_rec.creation_date,
3000: LAST_UPDATED_BY = l_def_okc_outcomes_tl_rec.last_updated_by,
3001: LAST_UPDATE_DATE = l_def_okc_outcomes_tl_rec.last_update_date,
3002: LAST_UPDATE_LOGIN = l_def_okc_outcomes_tl_rec.last_update_login
3003: WHERE ID = l_def_okc_outcomes_tl_rec.id
3004: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
3005: --AND SOURCE_LANG = USERENV('LANG');

Line 3002: LAST_UPDATE_LOGIN = l_def_okc_outcomes_tl_rec.last_update_login

2998: CREATED_BY = l_def_okc_outcomes_tl_rec.created_by,
2999: CREATION_DATE = l_def_okc_outcomes_tl_rec.creation_date,
3000: LAST_UPDATED_BY = l_def_okc_outcomes_tl_rec.last_updated_by,
3001: LAST_UPDATE_DATE = l_def_okc_outcomes_tl_rec.last_update_date,
3002: LAST_UPDATE_LOGIN = l_def_okc_outcomes_tl_rec.last_update_login
3003: WHERE ID = l_def_okc_outcomes_tl_rec.id
3004: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
3005: --AND SOURCE_LANG = USERENV('LANG');
3006:

Line 3003: WHERE ID = l_def_okc_outcomes_tl_rec.id

2999: CREATION_DATE = l_def_okc_outcomes_tl_rec.creation_date,
3000: LAST_UPDATED_BY = l_def_okc_outcomes_tl_rec.last_updated_by,
3001: LAST_UPDATE_DATE = l_def_okc_outcomes_tl_rec.last_update_date,
3002: LAST_UPDATE_LOGIN = l_def_okc_outcomes_tl_rec.last_update_login
3003: WHERE ID = l_def_okc_outcomes_tl_rec.id
3004: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
3005: --AND SOURCE_LANG = USERENV('LANG');
3006:
3007: UPDATE OKC_OUTCOMES_TL

Line 3007: UPDATE OKC_OUTCOMES_TL

3003: WHERE ID = l_def_okc_outcomes_tl_rec.id
3004: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
3005: --AND SOURCE_LANG = USERENV('LANG');
3006:
3007: UPDATE OKC_OUTCOMES_TL
3008: SET SFWT_FLAG = 'Y'
3009: WHERE ID = l_def_okc_outcomes_tl_rec.id
3010: AND SOURCE_LANG <> USERENV('LANG');
3011:

Line 3009: WHERE ID = l_def_okc_outcomes_tl_rec.id

3005: --AND SOURCE_LANG = USERENV('LANG');
3006:
3007: UPDATE OKC_OUTCOMES_TL
3008: SET SFWT_FLAG = 'Y'
3009: WHERE ID = l_def_okc_outcomes_tl_rec.id
3010: AND SOURCE_LANG <> USERENV('LANG');
3011:
3012: x_okc_outcomes_tl_rec := l_def_okc_outcomes_tl_rec;
3013: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3012: x_okc_outcomes_tl_rec := l_def_okc_outcomes_tl_rec;

3008: SET SFWT_FLAG = 'Y'
3009: WHERE ID = l_def_okc_outcomes_tl_rec.id
3010: AND SOURCE_LANG <> USERENV('LANG');
3011:
3012: x_okc_outcomes_tl_rec := l_def_okc_outcomes_tl_rec;
3013: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3014: EXCEPTION
3015: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3016: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3063: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;

3059: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
3060: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3061: l_ocev_rec ocev_rec_type := p_ocev_rec;
3062: l_def_ocev_rec ocev_rec_type;
3063: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
3064: lx_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
3065: l_oce_rec oce_rec_type;
3066: lx_oce_rec oce_rec_type;
3067: -------------------------------

Line 3064: lx_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;

3060: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3061: l_ocev_rec ocev_rec_type := p_ocev_rec;
3062: l_def_ocev_rec ocev_rec_type;
3063: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
3064: lx_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
3065: l_oce_rec oce_rec_type;
3066: lx_oce_rec oce_rec_type;
3067: -------------------------------
3068: -- FUNCTION fill_who_columns --

Line 3300: migrate(l_def_ocev_rec, l_okc_outcomes_tl_rec);

3296:
3297: --------------------------------------
3298: -- Move VIEW record to "Child" records
3299: --------------------------------------
3300: migrate(l_def_ocev_rec, l_okc_outcomes_tl_rec);
3301: migrate(l_def_ocev_rec, l_oce_rec);
3302: --------------------------------------------
3303: -- Call the UPDATE_ROW for each child record
3304: --------------------------------------------

Line 3310: l_okc_outcomes_tl_rec,

3306: p_init_msg_list,
3307: x_return_status,
3308: x_msg_count,
3309: x_msg_data,
3310: l_okc_outcomes_tl_rec,
3311: lx_okc_outcomes_tl_rec
3312: );
3313: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3314: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3311: lx_okc_outcomes_tl_rec

3307: x_return_status,
3308: x_msg_count,
3309: x_msg_data,
3310: l_okc_outcomes_tl_rec,
3311: lx_okc_outcomes_tl_rec
3312: );
3313: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3314: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3315: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3318: migrate(lx_okc_outcomes_tl_rec, l_def_ocev_rec);

3314: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3315: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3316: RAISE OKC_API.G_EXCEPTION_ERROR;
3317: END IF;
3318: migrate(lx_okc_outcomes_tl_rec, l_def_ocev_rec);
3319: update_row(
3320: p_init_msg_list,
3321: x_return_status,
3322: x_msg_count,

Line 3499: -- delete_row for:OKC_OUTCOMES_TL --

3495: '_PVT'
3496: );
3497: END delete_row;
3498: ------------------------------------
3499: -- delete_row for:OKC_OUTCOMES_TL --
3500: ------------------------------------
3501: PROCEDURE delete_row(
3502: p_init_msg_list IN VARCHAR2 ,
3503: x_return_status OUT NOCOPY VARCHAR2,

Line 3506: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type) IS

3502: p_init_msg_list IN VARCHAR2 ,
3503: x_return_status OUT NOCOPY VARCHAR2,
3504: x_msg_count OUT NOCOPY NUMBER,
3505: x_msg_data OUT NOCOPY VARCHAR2,
3506: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type) IS
3507:
3508: l_api_version CONSTANT NUMBER := 1;
3509: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3510: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3511: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type:= p_okc_outcomes_tl_rec;

3507:
3508: l_api_version CONSTANT NUMBER := 1;
3509: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3510: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3511: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type:= p_okc_outcomes_tl_rec;
3512: l_row_notfound BOOLEAN := TRUE;
3513: ----------------------------------------
3514: -- Set_Attributes for:OKC_OUTCOMES_TL --
3515: ----------------------------------------

Line 3514: -- Set_Attributes for:OKC_OUTCOMES_TL --

3510: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3511: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type:= p_okc_outcomes_tl_rec;
3512: l_row_notfound BOOLEAN := TRUE;
3513: ----------------------------------------
3514: -- Set_Attributes for:OKC_OUTCOMES_TL --
3515: ----------------------------------------
3516: FUNCTION Set_Attributes (
3517: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
3518: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type

Line 3517: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,

3513: ----------------------------------------
3514: -- Set_Attributes for:OKC_OUTCOMES_TL --
3515: ----------------------------------------
3516: FUNCTION Set_Attributes (
3517: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
3518: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type
3519: ) RETURN VARCHAR2 IS
3520: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3521: BEGIN

Line 3518: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type

3514: -- Set_Attributes for:OKC_OUTCOMES_TL --
3515: ----------------------------------------
3516: FUNCTION Set_Attributes (
3517: p_okc_outcomes_tl_rec IN okc_outcomes_tl_rec_type,
3518: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type
3519: ) RETURN VARCHAR2 IS
3520: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3521: BEGIN
3522: x_okc_outcomes_tl_rec := p_okc_outcomes_tl_rec;

Line 3522: x_okc_outcomes_tl_rec := p_okc_outcomes_tl_rec;

3518: x_okc_outcomes_tl_rec OUT NOCOPY okc_outcomes_tl_rec_type
3519: ) RETURN VARCHAR2 IS
3520: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3521: BEGIN
3522: x_okc_outcomes_tl_rec := p_okc_outcomes_tl_rec;
3523: x_okc_outcomes_tl_rec.LANGUAGE := l_lang;
3524: RETURN(l_return_status);
3525: END Set_Attributes;
3526: BEGIN

Line 3523: x_okc_outcomes_tl_rec.LANGUAGE := l_lang;

3519: ) RETURN VARCHAR2 IS
3520: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3521: BEGIN
3522: x_okc_outcomes_tl_rec := p_okc_outcomes_tl_rec;
3523: x_okc_outcomes_tl_rec.LANGUAGE := l_lang;
3524: RETURN(l_return_status);
3525: END Set_Attributes;
3526: BEGIN
3527: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3538: p_okc_outcomes_tl_rec, -- IN

3534: RAISE OKC_API.G_EXCEPTION_ERROR;
3535: END IF;
3536: --- Setting item attributes
3537: l_return_status := Set_Attributes(
3538: p_okc_outcomes_tl_rec, -- IN
3539: l_okc_outcomes_tl_rec); -- OUT
3540: --- If any errors happen abort API
3541: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3542: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3539: l_okc_outcomes_tl_rec); -- OUT

3535: END IF;
3536: --- Setting item attributes
3537: l_return_status := Set_Attributes(
3538: p_okc_outcomes_tl_rec, -- IN
3539: l_okc_outcomes_tl_rec); -- OUT
3540: --- If any errors happen abort API
3541: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3542: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3543: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3546: DELETE FROM OKC_OUTCOMES_TL

3542: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3543: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3544: RAISE OKC_API.G_EXCEPTION_ERROR;
3545: END IF;
3546: DELETE FROM OKC_OUTCOMES_TL
3547: WHERE ID = l_okc_outcomes_tl_rec.id;
3548:
3549: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3550: EXCEPTION

Line 3547: WHERE ID = l_okc_outcomes_tl_rec.id;

3543: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3544: RAISE OKC_API.G_EXCEPTION_ERROR;
3545: END IF;
3546: DELETE FROM OKC_OUTCOMES_TL
3547: WHERE ID = l_okc_outcomes_tl_rec.id;
3548:
3549: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3550: EXCEPTION
3551: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3597: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;

3593: l_api_version CONSTANT NUMBER := 1;
3594: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3595: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3596: l_ocev_rec ocev_rec_type := p_ocev_rec;
3597: l_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
3598: l_oce_rec oce_rec_type;
3599: BEGIN
3600: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3601: G_PKG_NAME,

Line 3623: migrate(l_ocev_rec, l_okc_outcomes_tl_rec);

3619: END IF;
3620: --------------------------------------
3621: -- Move VIEW record to "Child" records
3622: --------------------------------------
3623: migrate(l_ocev_rec, l_okc_outcomes_tl_rec);
3624: migrate(l_ocev_rec, l_oce_rec);
3625: --------------------------------------------
3626: -- Call the DELETE_ROW for each child record
3627: --------------------------------------------

Line 3633: l_okc_outcomes_tl_rec

3629: p_init_msg_list,
3630: x_return_status,
3631: x_msg_count,
3632: x_msg_data,
3633: l_okc_outcomes_tl_rec
3634: );
3635: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3636: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3637: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3907: INSERT INTO OKC_OUTCOMES_TL(

3903: );
3904:
3905: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
3906: FORALL i in 1..l_tabsize
3907: INSERT INTO OKC_OUTCOMES_TL(
3908: id,
3909: language,
3910: source_lang,
3911: sfwt_flag,

Line 4036: INSERT INTO okc_outcomes_tlh

4032: ------------------------------
4033: -- Versioning TL Table
4034: ------------------------------
4035:
4036: INSERT INTO okc_outcomes_tlh
4037: (
4038: major_version,
4039: id,
4040: language,

Line 4062: FROM okc_outcomes_tl

4058: creation_date,
4059: last_updated_by,
4060: last_update_date,
4061: last_update_login
4062: FROM okc_outcomes_tl
4063: WHERE id in (select id from okc_outcomes_b
4064: where dnz_chr_id = p_chr_id);
4065:
4066: RETURN l_return_status;

Line 4095: INSERT INTO okc_outcomes_tl

4091:
4092: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
4093:
4094: BEGIN
4095: INSERT INTO okc_outcomes_tl
4096: (
4097: id,
4098: language,
4099: source_lang,

Line 4119: FROM okc_outcomes_tlh

4115: creation_date,
4116: last_updated_by,
4117: last_update_date,
4118: last_update_login
4119: FROM okc_outcomes_tlh
4120: WHERE id in (select id from okc_outcomes_b where dnz_chr_id = p_chr_id)
4121: AND major_version = p_major_version;
4122:
4123: --------------------------------------