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_ACN_PVT dependencies on OKC_ACTIONS_TL

Line 50: DELETE FROM OKC_ACTIONS_TL T

46: /* as a quick workaround to fix the time-consuming table handler issue */
47: /* Eventually we'll need to turn them into a separate fix_language procedure */
48: /*
49:
50: DELETE FROM OKC_ACTIONS_TL T
51: WHERE NOT EXISTS (
52: SELECT NULL
53: FROM OKC_ACTIONS_B B
54: WHERE B.ID = T.ID

Line 57: UPDATE OKC_ACTIONS_TL T SET (

53: FROM OKC_ACTIONS_B B
54: WHERE B.ID = T.ID
55: );
56:
57: UPDATE OKC_ACTIONS_TL T SET (
58: NAME,
59: DESCRIPTION,
60: SHORT_DESCRIPTION,
61: COMMENTS) = (SELECT

Line 66: FROM OKC_ACTIONS_TL B

62: B.NAME,
63: B.DESCRIPTION,
64: B.SHORT_DESCRIPTION,
65: B.COMMENTS
66: FROM OKC_ACTIONS_TL B
67: WHERE B.ID = T.ID
68: AND B.LANGUAGE = T.SOURCE_LANG)
69: WHERE (
70: T.ID,

Line 75: FROM OKC_ACTIONS_TL SUBB, OKC_ACTIONS_TL SUBT

71: T.LANGUAGE)
72: IN (SELECT
73: SUBT.ID,
74: SUBT.LANGUAGE
75: FROM OKC_ACTIONS_TL SUBB, OKC_ACTIONS_TL SUBT
76: WHERE SUBB.ID = SUBT.ID
77: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
78: AND (SUBB.NAME <> SUBT.NAME
79: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 91: INSERT INTO OKC_ACTIONS_TL (

87: OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
88: ));
89: */
90:
91: INSERT INTO OKC_ACTIONS_TL (
92: ID,
93: LANGUAGE,
94: SOURCE_LANG,
95: SFWT_FLAG,

Line 119: FROM OKC_ACTIONS_TL B, FND_LANGUAGES L

115: B.CREATION_DATE,
116: B.LAST_UPDATED_BY,
117: B.LAST_UPDATE_DATE,
118: B.LAST_UPDATE_LOGIN
119: FROM OKC_ACTIONS_TL B, FND_LANGUAGES L
120: WHERE L.INSTALLED_FLAG IN ('I', 'B')
121: AND B.LANGUAGE = USERENV('LANG')
122: AND NOT EXISTS(
123: SELECT NULL

Line 124: FROM OKC_ACTIONS_TL T

120: WHERE L.INSTALLED_FLAG IN ('I', 'B')
121: AND B.LANGUAGE = USERENV('LANG')
122: AND NOT EXISTS(
123: SELECT NULL
124: FROM OKC_ACTIONS_TL T
125: WHERE T.ID = B.ID
126: AND T.LANGUAGE = L.LANGUAGE_CODE
127: );
128:

Line 224: -- FUNCTION get_rec for: OKC_ACTIONS_TL

220: BEGIN
221: RETURN(get_rec(p_acn_rec, l_row_notfound));
222: END get_rec;
223: ---------------------------------------------------------------------------
224: -- FUNCTION get_rec for: OKC_ACTIONS_TL
225: ---------------------------------------------------------------------------
226: FUNCTION get_rec (
227: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
228: x_no_data_found OUT NOCOPY BOOLEAN

Line 227: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,

223: ---------------------------------------------------------------------------
224: -- FUNCTION get_rec for: OKC_ACTIONS_TL
225: ---------------------------------------------------------------------------
226: FUNCTION get_rec (
227: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
228: x_no_data_found OUT NOCOPY BOOLEAN
229: ) RETURN okc_actions_tl_rec_type IS
230: CURSOR okc_actions_tl_pk_csr (p_id IN NUMBER,
231: p_language IN VARCHAR2) IS

Line 229: ) RETURN okc_actions_tl_rec_type IS

225: ---------------------------------------------------------------------------
226: FUNCTION get_rec (
227: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
228: x_no_data_found OUT NOCOPY BOOLEAN
229: ) RETURN okc_actions_tl_rec_type IS
230: CURSOR okc_actions_tl_pk_csr (p_id IN NUMBER,
231: p_language IN VARCHAR2) IS
232: SELECT
233: ID,

Line 230: CURSOR okc_actions_tl_pk_csr (p_id IN NUMBER,

226: FUNCTION get_rec (
227: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
228: x_no_data_found OUT NOCOPY BOOLEAN
229: ) RETURN okc_actions_tl_rec_type IS
230: CURSOR okc_actions_tl_pk_csr (p_id IN NUMBER,
231: p_language IN VARCHAR2) IS
232: SELECT
233: ID,
234: LANGUAGE,

Line 246: FROM Okc_Actions_Tl

242: CREATION_DATE,
243: LAST_UPDATED_BY,
244: LAST_UPDATE_DATE,
245: LAST_UPDATE_LOGIN
246: FROM Okc_Actions_Tl
247: WHERE okc_actions_tl.id = p_id
248: AND okc_actions_tl.language = p_language;
249: l_okc_actions_tl_pk okc_actions_tl_pk_csr%ROWTYPE;
250: l_okc_actions_tl_rec okc_actions_tl_rec_type;

Line 247: WHERE okc_actions_tl.id = p_id

243: LAST_UPDATED_BY,
244: LAST_UPDATE_DATE,
245: LAST_UPDATE_LOGIN
246: FROM Okc_Actions_Tl
247: WHERE okc_actions_tl.id = p_id
248: AND okc_actions_tl.language = p_language;
249: l_okc_actions_tl_pk okc_actions_tl_pk_csr%ROWTYPE;
250: l_okc_actions_tl_rec okc_actions_tl_rec_type;
251: BEGIN

Line 248: AND okc_actions_tl.language = p_language;

244: LAST_UPDATE_DATE,
245: LAST_UPDATE_LOGIN
246: FROM Okc_Actions_Tl
247: WHERE okc_actions_tl.id = p_id
248: AND okc_actions_tl.language = p_language;
249: l_okc_actions_tl_pk okc_actions_tl_pk_csr%ROWTYPE;
250: l_okc_actions_tl_rec okc_actions_tl_rec_type;
251: BEGIN
252: x_no_data_found := TRUE;

Line 249: l_okc_actions_tl_pk okc_actions_tl_pk_csr%ROWTYPE;

245: LAST_UPDATE_LOGIN
246: FROM Okc_Actions_Tl
247: WHERE okc_actions_tl.id = p_id
248: AND okc_actions_tl.language = p_language;
249: l_okc_actions_tl_pk okc_actions_tl_pk_csr%ROWTYPE;
250: l_okc_actions_tl_rec okc_actions_tl_rec_type;
251: BEGIN
252: x_no_data_found := TRUE;
253: -- Get current database values

Line 250: l_okc_actions_tl_rec okc_actions_tl_rec_type;

246: FROM Okc_Actions_Tl
247: WHERE okc_actions_tl.id = p_id
248: AND okc_actions_tl.language = p_language;
249: l_okc_actions_tl_pk okc_actions_tl_pk_csr%ROWTYPE;
250: l_okc_actions_tl_rec okc_actions_tl_rec_type;
251: BEGIN
252: x_no_data_found := TRUE;
253: -- Get current database values
254: OPEN okc_actions_tl_pk_csr (p_okc_actions_tl_rec.id,

Line 254: OPEN okc_actions_tl_pk_csr (p_okc_actions_tl_rec.id,

250: l_okc_actions_tl_rec okc_actions_tl_rec_type;
251: BEGIN
252: x_no_data_found := TRUE;
253: -- Get current database values
254: OPEN okc_actions_tl_pk_csr (p_okc_actions_tl_rec.id,
255: p_okc_actions_tl_rec.language);
256: FETCH okc_actions_tl_pk_csr INTO
257: l_okc_actions_tl_rec.ID,
258: l_okc_actions_tl_rec.LANGUAGE,

Line 255: p_okc_actions_tl_rec.language);

251: BEGIN
252: x_no_data_found := TRUE;
253: -- Get current database values
254: OPEN okc_actions_tl_pk_csr (p_okc_actions_tl_rec.id,
255: p_okc_actions_tl_rec.language);
256: FETCH okc_actions_tl_pk_csr INTO
257: l_okc_actions_tl_rec.ID,
258: l_okc_actions_tl_rec.LANGUAGE,
259: l_okc_actions_tl_rec.SOURCE_LANG,

Line 256: FETCH okc_actions_tl_pk_csr INTO

252: x_no_data_found := TRUE;
253: -- Get current database values
254: OPEN okc_actions_tl_pk_csr (p_okc_actions_tl_rec.id,
255: p_okc_actions_tl_rec.language);
256: FETCH okc_actions_tl_pk_csr INTO
257: l_okc_actions_tl_rec.ID,
258: l_okc_actions_tl_rec.LANGUAGE,
259: l_okc_actions_tl_rec.SOURCE_LANG,
260: l_okc_actions_tl_rec.SFWT_FLAG,

Line 257: l_okc_actions_tl_rec.ID,

253: -- Get current database values
254: OPEN okc_actions_tl_pk_csr (p_okc_actions_tl_rec.id,
255: p_okc_actions_tl_rec.language);
256: FETCH okc_actions_tl_pk_csr INTO
257: l_okc_actions_tl_rec.ID,
258: l_okc_actions_tl_rec.LANGUAGE,
259: l_okc_actions_tl_rec.SOURCE_LANG,
260: l_okc_actions_tl_rec.SFWT_FLAG,
261: l_okc_actions_tl_rec.NAME,

Line 258: l_okc_actions_tl_rec.LANGUAGE,

254: OPEN okc_actions_tl_pk_csr (p_okc_actions_tl_rec.id,
255: p_okc_actions_tl_rec.language);
256: FETCH okc_actions_tl_pk_csr INTO
257: l_okc_actions_tl_rec.ID,
258: l_okc_actions_tl_rec.LANGUAGE,
259: l_okc_actions_tl_rec.SOURCE_LANG,
260: l_okc_actions_tl_rec.SFWT_FLAG,
261: l_okc_actions_tl_rec.NAME,
262: l_okc_actions_tl_rec.DESCRIPTION,

Line 259: l_okc_actions_tl_rec.SOURCE_LANG,

255: p_okc_actions_tl_rec.language);
256: FETCH okc_actions_tl_pk_csr INTO
257: l_okc_actions_tl_rec.ID,
258: l_okc_actions_tl_rec.LANGUAGE,
259: l_okc_actions_tl_rec.SOURCE_LANG,
260: l_okc_actions_tl_rec.SFWT_FLAG,
261: l_okc_actions_tl_rec.NAME,
262: l_okc_actions_tl_rec.DESCRIPTION,
263: l_okc_actions_tl_rec.SHORT_DESCRIPTION,

Line 260: l_okc_actions_tl_rec.SFWT_FLAG,

256: FETCH okc_actions_tl_pk_csr INTO
257: l_okc_actions_tl_rec.ID,
258: l_okc_actions_tl_rec.LANGUAGE,
259: l_okc_actions_tl_rec.SOURCE_LANG,
260: l_okc_actions_tl_rec.SFWT_FLAG,
261: l_okc_actions_tl_rec.NAME,
262: l_okc_actions_tl_rec.DESCRIPTION,
263: l_okc_actions_tl_rec.SHORT_DESCRIPTION,
264: l_okc_actions_tl_rec.COMMENTS,

Line 261: l_okc_actions_tl_rec.NAME,

257: l_okc_actions_tl_rec.ID,
258: l_okc_actions_tl_rec.LANGUAGE,
259: l_okc_actions_tl_rec.SOURCE_LANG,
260: l_okc_actions_tl_rec.SFWT_FLAG,
261: l_okc_actions_tl_rec.NAME,
262: l_okc_actions_tl_rec.DESCRIPTION,
263: l_okc_actions_tl_rec.SHORT_DESCRIPTION,
264: l_okc_actions_tl_rec.COMMENTS,
265: l_okc_actions_tl_rec.CREATED_BY,

Line 262: l_okc_actions_tl_rec.DESCRIPTION,

258: l_okc_actions_tl_rec.LANGUAGE,
259: l_okc_actions_tl_rec.SOURCE_LANG,
260: l_okc_actions_tl_rec.SFWT_FLAG,
261: l_okc_actions_tl_rec.NAME,
262: l_okc_actions_tl_rec.DESCRIPTION,
263: l_okc_actions_tl_rec.SHORT_DESCRIPTION,
264: l_okc_actions_tl_rec.COMMENTS,
265: l_okc_actions_tl_rec.CREATED_BY,
266: l_okc_actions_tl_rec.CREATION_DATE,

Line 263: l_okc_actions_tl_rec.SHORT_DESCRIPTION,

259: l_okc_actions_tl_rec.SOURCE_LANG,
260: l_okc_actions_tl_rec.SFWT_FLAG,
261: l_okc_actions_tl_rec.NAME,
262: l_okc_actions_tl_rec.DESCRIPTION,
263: l_okc_actions_tl_rec.SHORT_DESCRIPTION,
264: l_okc_actions_tl_rec.COMMENTS,
265: l_okc_actions_tl_rec.CREATED_BY,
266: l_okc_actions_tl_rec.CREATION_DATE,
267: l_okc_actions_tl_rec.LAST_UPDATED_BY,

Line 264: l_okc_actions_tl_rec.COMMENTS,

260: l_okc_actions_tl_rec.SFWT_FLAG,
261: l_okc_actions_tl_rec.NAME,
262: l_okc_actions_tl_rec.DESCRIPTION,
263: l_okc_actions_tl_rec.SHORT_DESCRIPTION,
264: l_okc_actions_tl_rec.COMMENTS,
265: l_okc_actions_tl_rec.CREATED_BY,
266: l_okc_actions_tl_rec.CREATION_DATE,
267: l_okc_actions_tl_rec.LAST_UPDATED_BY,
268: l_okc_actions_tl_rec.LAST_UPDATE_DATE,

Line 265: l_okc_actions_tl_rec.CREATED_BY,

261: l_okc_actions_tl_rec.NAME,
262: l_okc_actions_tl_rec.DESCRIPTION,
263: l_okc_actions_tl_rec.SHORT_DESCRIPTION,
264: l_okc_actions_tl_rec.COMMENTS,
265: l_okc_actions_tl_rec.CREATED_BY,
266: l_okc_actions_tl_rec.CREATION_DATE,
267: l_okc_actions_tl_rec.LAST_UPDATED_BY,
268: l_okc_actions_tl_rec.LAST_UPDATE_DATE,
269: l_okc_actions_tl_rec.LAST_UPDATE_LOGIN;

Line 266: l_okc_actions_tl_rec.CREATION_DATE,

262: l_okc_actions_tl_rec.DESCRIPTION,
263: l_okc_actions_tl_rec.SHORT_DESCRIPTION,
264: l_okc_actions_tl_rec.COMMENTS,
265: l_okc_actions_tl_rec.CREATED_BY,
266: l_okc_actions_tl_rec.CREATION_DATE,
267: l_okc_actions_tl_rec.LAST_UPDATED_BY,
268: l_okc_actions_tl_rec.LAST_UPDATE_DATE,
269: l_okc_actions_tl_rec.LAST_UPDATE_LOGIN;
270: x_no_data_found := okc_actions_tl_pk_csr%NOTFOUND;

Line 267: l_okc_actions_tl_rec.LAST_UPDATED_BY,

263: l_okc_actions_tl_rec.SHORT_DESCRIPTION,
264: l_okc_actions_tl_rec.COMMENTS,
265: l_okc_actions_tl_rec.CREATED_BY,
266: l_okc_actions_tl_rec.CREATION_DATE,
267: l_okc_actions_tl_rec.LAST_UPDATED_BY,
268: l_okc_actions_tl_rec.LAST_UPDATE_DATE,
269: l_okc_actions_tl_rec.LAST_UPDATE_LOGIN;
270: x_no_data_found := okc_actions_tl_pk_csr%NOTFOUND;
271: CLOSE okc_actions_tl_pk_csr;

Line 268: l_okc_actions_tl_rec.LAST_UPDATE_DATE,

264: l_okc_actions_tl_rec.COMMENTS,
265: l_okc_actions_tl_rec.CREATED_BY,
266: l_okc_actions_tl_rec.CREATION_DATE,
267: l_okc_actions_tl_rec.LAST_UPDATED_BY,
268: l_okc_actions_tl_rec.LAST_UPDATE_DATE,
269: l_okc_actions_tl_rec.LAST_UPDATE_LOGIN;
270: x_no_data_found := okc_actions_tl_pk_csr%NOTFOUND;
271: CLOSE okc_actions_tl_pk_csr;
272: RETURN(l_okc_actions_tl_rec);

Line 269: l_okc_actions_tl_rec.LAST_UPDATE_LOGIN;

265: l_okc_actions_tl_rec.CREATED_BY,
266: l_okc_actions_tl_rec.CREATION_DATE,
267: l_okc_actions_tl_rec.LAST_UPDATED_BY,
268: l_okc_actions_tl_rec.LAST_UPDATE_DATE,
269: l_okc_actions_tl_rec.LAST_UPDATE_LOGIN;
270: x_no_data_found := okc_actions_tl_pk_csr%NOTFOUND;
271: CLOSE okc_actions_tl_pk_csr;
272: RETURN(l_okc_actions_tl_rec);
273: END get_rec;

Line 270: x_no_data_found := okc_actions_tl_pk_csr%NOTFOUND;

266: l_okc_actions_tl_rec.CREATION_DATE,
267: l_okc_actions_tl_rec.LAST_UPDATED_BY,
268: l_okc_actions_tl_rec.LAST_UPDATE_DATE,
269: l_okc_actions_tl_rec.LAST_UPDATE_LOGIN;
270: x_no_data_found := okc_actions_tl_pk_csr%NOTFOUND;
271: CLOSE okc_actions_tl_pk_csr;
272: RETURN(l_okc_actions_tl_rec);
273: END get_rec;
274:

Line 271: CLOSE okc_actions_tl_pk_csr;

267: l_okc_actions_tl_rec.LAST_UPDATED_BY,
268: l_okc_actions_tl_rec.LAST_UPDATE_DATE,
269: l_okc_actions_tl_rec.LAST_UPDATE_LOGIN;
270: x_no_data_found := okc_actions_tl_pk_csr%NOTFOUND;
271: CLOSE okc_actions_tl_pk_csr;
272: RETURN(l_okc_actions_tl_rec);
273: END get_rec;
274:
275: FUNCTION get_rec (

Line 272: RETURN(l_okc_actions_tl_rec);

268: l_okc_actions_tl_rec.LAST_UPDATE_DATE,
269: l_okc_actions_tl_rec.LAST_UPDATE_LOGIN;
270: x_no_data_found := okc_actions_tl_pk_csr%NOTFOUND;
271: CLOSE okc_actions_tl_pk_csr;
272: RETURN(l_okc_actions_tl_rec);
273: END get_rec;
274:
275: FUNCTION get_rec (
276: p_okc_actions_tl_rec IN okc_actions_tl_rec_type

Line 276: p_okc_actions_tl_rec IN okc_actions_tl_rec_type

272: RETURN(l_okc_actions_tl_rec);
273: END get_rec;
274:
275: FUNCTION get_rec (
276: p_okc_actions_tl_rec IN okc_actions_tl_rec_type
277: ) RETURN okc_actions_tl_rec_type IS
278: l_row_notfound BOOLEAN := TRUE;
279: BEGIN
280: RETURN(get_rec(p_okc_actions_tl_rec, l_row_notfound));

Line 277: ) RETURN okc_actions_tl_rec_type IS

273: END get_rec;
274:
275: FUNCTION get_rec (
276: p_okc_actions_tl_rec IN okc_actions_tl_rec_type
277: ) RETURN okc_actions_tl_rec_type IS
278: l_row_notfound BOOLEAN := TRUE;
279: BEGIN
280: RETURN(get_rec(p_okc_actions_tl_rec, l_row_notfound));
281: END get_rec;

Line 280: RETURN(get_rec(p_okc_actions_tl_rec, l_row_notfound));

276: p_okc_actions_tl_rec IN okc_actions_tl_rec_type
277: ) RETURN okc_actions_tl_rec_type IS
278: l_row_notfound BOOLEAN := TRUE;
279: BEGIN
280: RETURN(get_rec(p_okc_actions_tl_rec, l_row_notfound));
281: END get_rec;
282: ---------------------------------------------------------------------------
283: -- FUNCTION get_rec for: OKC_ACTIONS_V
284: ---------------------------------------------------------------------------

Line 1885: p_to OUT NOCOPY okc_actions_tl_rec_type

1881: p_to.seeded_flag := p_from.seeded_flag;
1882: END migrate;
1883: PROCEDURE migrate (
1884: p_from IN acnv_rec_type,
1885: p_to OUT NOCOPY okc_actions_tl_rec_type
1886: ) IS
1887: BEGIN
1888: p_to.id := p_from.id;
1889: p_to.sfwt_flag := p_from.sfwt_flag;

Line 1901: p_from IN okc_actions_tl_rec_type,

1897: p_to.last_update_date := p_from.last_update_date;
1898: p_to.last_update_login := p_from.last_update_login;
1899: END migrate;
1900: PROCEDURE migrate (
1901: p_from IN okc_actions_tl_rec_type,
1902: p_to IN OUT NOCOPY acnv_rec_type
1903: ) IS
1904: BEGIN
1905: p_to.id := p_from.id;

Line 1937: l_okc_actions_tl_rec okc_actions_tl_rec_type;

1933: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1934: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1935: l_acnv_rec acnv_rec_type := p_acnv_rec;
1936: l_acn_rec acn_rec_type;
1937: l_okc_actions_tl_rec okc_actions_tl_rec_type;
1938: BEGIN
1939: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1940: G_PKG_NAME,
1941: p_init_msg_list,

Line 2214: -- insert_row for:OKC_ACTIONS_TL --

2210: '_PVT'
2211: );
2212: END insert_row;
2213: -----------------------------------
2214: -- insert_row for:OKC_ACTIONS_TL --
2215: -----------------------------------
2216: PROCEDURE insert_row(
2217: p_init_msg_list IN VARCHAR2 ,
2218: x_return_status OUT NOCOPY VARCHAR2,

Line 2221: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,

2217: p_init_msg_list IN VARCHAR2 ,
2218: x_return_status OUT NOCOPY VARCHAR2,
2219: x_msg_count OUT NOCOPY NUMBER,
2220: x_msg_data OUT NOCOPY VARCHAR2,
2221: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
2222: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type) IS
2223:
2224: l_api_version CONSTANT NUMBER := 1;
2225: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 2222: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type) IS

2218: x_return_status OUT NOCOPY VARCHAR2,
2219: x_msg_count OUT NOCOPY NUMBER,
2220: x_msg_data OUT NOCOPY VARCHAR2,
2221: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
2222: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type) IS
2223:
2224: l_api_version CONSTANT NUMBER := 1;
2225: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2226: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2227: l_okc_actions_tl_rec okc_actions_tl_rec_type := p_okc_actions_tl_rec;

2223:
2224: l_api_version CONSTANT NUMBER := 1;
2225: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2226: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2227: l_okc_actions_tl_rec okc_actions_tl_rec_type := p_okc_actions_tl_rec;
2228: l_def_okc_actions_tl_rec okc_actions_tl_rec_type;
2229: CURSOR get_languages IS
2230: SELECT *
2231: FROM FND_LANGUAGES

Line 2228: l_def_okc_actions_tl_rec okc_actions_tl_rec_type;

2224: l_api_version CONSTANT NUMBER := 1;
2225: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2226: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2227: l_okc_actions_tl_rec okc_actions_tl_rec_type := p_okc_actions_tl_rec;
2228: l_def_okc_actions_tl_rec okc_actions_tl_rec_type;
2229: CURSOR get_languages IS
2230: SELECT *
2231: FROM FND_LANGUAGES
2232: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 2234: -- Set_Attributes for:OKC_ACTIONS_TL --

2230: SELECT *
2231: FROM FND_LANGUAGES
2232: WHERE INSTALLED_FLAG IN ('I', 'B');
2233: ---------------------------------------
2234: -- Set_Attributes for:OKC_ACTIONS_TL --
2235: ---------------------------------------
2236: FUNCTION Set_Attributes (
2237: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
2238: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type

Line 2237: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,

2233: ---------------------------------------
2234: -- Set_Attributes for:OKC_ACTIONS_TL --
2235: ---------------------------------------
2236: FUNCTION Set_Attributes (
2237: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
2238: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type
2239: ) RETURN VARCHAR2 IS
2240: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2241: BEGIN

Line 2238: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type

2234: -- Set_Attributes for:OKC_ACTIONS_TL --
2235: ---------------------------------------
2236: FUNCTION Set_Attributes (
2237: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
2238: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type
2239: ) RETURN VARCHAR2 IS
2240: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2241: BEGIN
2242: x_okc_actions_tl_rec := p_okc_actions_tl_rec;

Line 2242: x_okc_actions_tl_rec := p_okc_actions_tl_rec;

2238: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type
2239: ) RETURN VARCHAR2 IS
2240: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2241: BEGIN
2242: x_okc_actions_tl_rec := p_okc_actions_tl_rec;
2243: x_okc_actions_tl_rec.LANGUAGE := l_lang;
2244: x_okc_actions_tl_rec.SOURCE_LANG := l_lang;
2245: RETURN(l_return_status);
2246: END Set_Attributes;

Line 2243: x_okc_actions_tl_rec.LANGUAGE := l_lang;

2239: ) RETURN VARCHAR2 IS
2240: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2241: BEGIN
2242: x_okc_actions_tl_rec := p_okc_actions_tl_rec;
2243: x_okc_actions_tl_rec.LANGUAGE := l_lang;
2244: x_okc_actions_tl_rec.SOURCE_LANG := l_lang;
2245: RETURN(l_return_status);
2246: END Set_Attributes;
2247: BEGIN

Line 2244: x_okc_actions_tl_rec.SOURCE_LANG := l_lang;

2240: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2241: BEGIN
2242: x_okc_actions_tl_rec := p_okc_actions_tl_rec;
2243: x_okc_actions_tl_rec.LANGUAGE := l_lang;
2244: x_okc_actions_tl_rec.SOURCE_LANG := l_lang;
2245: RETURN(l_return_status);
2246: END Set_Attributes;
2247: BEGIN
2248: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2259: p_okc_actions_tl_rec, -- IN

2255: RAISE OKC_API.G_EXCEPTION_ERROR;
2256: END IF;
2257: --- Setting item attributes
2258: l_return_status := Set_Attributes(
2259: p_okc_actions_tl_rec, -- IN
2260: l_okc_actions_tl_rec); -- OUT
2261: --- If any errors happen abort API
2262: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2260: l_okc_actions_tl_rec); -- OUT

2256: END IF;
2257: --- Setting item attributes
2258: l_return_status := Set_Attributes(
2259: p_okc_actions_tl_rec, -- IN
2260: l_okc_actions_tl_rec); -- OUT
2261: --- If any errors happen abort API
2262: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2264: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2268: l_okc_actions_tl_rec.language := l_lang_rec.language_code;

2264: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2265: RAISE OKC_API.G_EXCEPTION_ERROR;
2266: END IF;
2267: FOR l_lang_rec IN get_languages LOOP
2268: l_okc_actions_tl_rec.language := l_lang_rec.language_code;
2269: INSERT INTO OKC_ACTIONS_TL(
2270: id,
2271: language,
2272: source_lang,

Line 2269: INSERT INTO OKC_ACTIONS_TL(

2265: RAISE OKC_API.G_EXCEPTION_ERROR;
2266: END IF;
2267: FOR l_lang_rec IN get_languages LOOP
2268: l_okc_actions_tl_rec.language := l_lang_rec.language_code;
2269: INSERT INTO OKC_ACTIONS_TL(
2270: id,
2271: language,
2272: source_lang,
2273: sfwt_flag,

Line 2284: l_okc_actions_tl_rec.id,

2280: last_updated_by,
2281: last_update_date,
2282: last_update_login)
2283: VALUES (
2284: l_okc_actions_tl_rec.id,
2285: l_okc_actions_tl_rec.language,
2286: l_okc_actions_tl_rec.source_lang,
2287: l_okc_actions_tl_rec.sfwt_flag,
2288: l_okc_actions_tl_rec.name,

Line 2285: l_okc_actions_tl_rec.language,

2281: last_update_date,
2282: last_update_login)
2283: VALUES (
2284: l_okc_actions_tl_rec.id,
2285: l_okc_actions_tl_rec.language,
2286: l_okc_actions_tl_rec.source_lang,
2287: l_okc_actions_tl_rec.sfwt_flag,
2288: l_okc_actions_tl_rec.name,
2289: l_okc_actions_tl_rec.description,

Line 2286: l_okc_actions_tl_rec.source_lang,

2282: last_update_login)
2283: VALUES (
2284: l_okc_actions_tl_rec.id,
2285: l_okc_actions_tl_rec.language,
2286: l_okc_actions_tl_rec.source_lang,
2287: l_okc_actions_tl_rec.sfwt_flag,
2288: l_okc_actions_tl_rec.name,
2289: l_okc_actions_tl_rec.description,
2290: l_okc_actions_tl_rec.short_description,

Line 2287: l_okc_actions_tl_rec.sfwt_flag,

2283: VALUES (
2284: l_okc_actions_tl_rec.id,
2285: l_okc_actions_tl_rec.language,
2286: l_okc_actions_tl_rec.source_lang,
2287: l_okc_actions_tl_rec.sfwt_flag,
2288: l_okc_actions_tl_rec.name,
2289: l_okc_actions_tl_rec.description,
2290: l_okc_actions_tl_rec.short_description,
2291: l_okc_actions_tl_rec.comments,

Line 2288: l_okc_actions_tl_rec.name,

2284: l_okc_actions_tl_rec.id,
2285: l_okc_actions_tl_rec.language,
2286: l_okc_actions_tl_rec.source_lang,
2287: l_okc_actions_tl_rec.sfwt_flag,
2288: l_okc_actions_tl_rec.name,
2289: l_okc_actions_tl_rec.description,
2290: l_okc_actions_tl_rec.short_description,
2291: l_okc_actions_tl_rec.comments,
2292: l_okc_actions_tl_rec.created_by,

Line 2289: l_okc_actions_tl_rec.description,

2285: l_okc_actions_tl_rec.language,
2286: l_okc_actions_tl_rec.source_lang,
2287: l_okc_actions_tl_rec.sfwt_flag,
2288: l_okc_actions_tl_rec.name,
2289: l_okc_actions_tl_rec.description,
2290: l_okc_actions_tl_rec.short_description,
2291: l_okc_actions_tl_rec.comments,
2292: l_okc_actions_tl_rec.created_by,
2293: l_okc_actions_tl_rec.creation_date,

Line 2290: l_okc_actions_tl_rec.short_description,

2286: l_okc_actions_tl_rec.source_lang,
2287: l_okc_actions_tl_rec.sfwt_flag,
2288: l_okc_actions_tl_rec.name,
2289: l_okc_actions_tl_rec.description,
2290: l_okc_actions_tl_rec.short_description,
2291: l_okc_actions_tl_rec.comments,
2292: l_okc_actions_tl_rec.created_by,
2293: l_okc_actions_tl_rec.creation_date,
2294: l_okc_actions_tl_rec.last_updated_by,

Line 2291: l_okc_actions_tl_rec.comments,

2287: l_okc_actions_tl_rec.sfwt_flag,
2288: l_okc_actions_tl_rec.name,
2289: l_okc_actions_tl_rec.description,
2290: l_okc_actions_tl_rec.short_description,
2291: l_okc_actions_tl_rec.comments,
2292: l_okc_actions_tl_rec.created_by,
2293: l_okc_actions_tl_rec.creation_date,
2294: l_okc_actions_tl_rec.last_updated_by,
2295: l_okc_actions_tl_rec.last_update_date,

Line 2292: l_okc_actions_tl_rec.created_by,

2288: l_okc_actions_tl_rec.name,
2289: l_okc_actions_tl_rec.description,
2290: l_okc_actions_tl_rec.short_description,
2291: l_okc_actions_tl_rec.comments,
2292: l_okc_actions_tl_rec.created_by,
2293: l_okc_actions_tl_rec.creation_date,
2294: l_okc_actions_tl_rec.last_updated_by,
2295: l_okc_actions_tl_rec.last_update_date,
2296: l_okc_actions_tl_rec.last_update_login);

Line 2293: l_okc_actions_tl_rec.creation_date,

2289: l_okc_actions_tl_rec.description,
2290: l_okc_actions_tl_rec.short_description,
2291: l_okc_actions_tl_rec.comments,
2292: l_okc_actions_tl_rec.created_by,
2293: l_okc_actions_tl_rec.creation_date,
2294: l_okc_actions_tl_rec.last_updated_by,
2295: l_okc_actions_tl_rec.last_update_date,
2296: l_okc_actions_tl_rec.last_update_login);
2297: END LOOP;

Line 2294: l_okc_actions_tl_rec.last_updated_by,

2290: l_okc_actions_tl_rec.short_description,
2291: l_okc_actions_tl_rec.comments,
2292: l_okc_actions_tl_rec.created_by,
2293: l_okc_actions_tl_rec.creation_date,
2294: l_okc_actions_tl_rec.last_updated_by,
2295: l_okc_actions_tl_rec.last_update_date,
2296: l_okc_actions_tl_rec.last_update_login);
2297: END LOOP;
2298: -- Set OUT values

Line 2295: l_okc_actions_tl_rec.last_update_date,

2291: l_okc_actions_tl_rec.comments,
2292: l_okc_actions_tl_rec.created_by,
2293: l_okc_actions_tl_rec.creation_date,
2294: l_okc_actions_tl_rec.last_updated_by,
2295: l_okc_actions_tl_rec.last_update_date,
2296: l_okc_actions_tl_rec.last_update_login);
2297: END LOOP;
2298: -- Set OUT values
2299: x_okc_actions_tl_rec := l_okc_actions_tl_rec;

Line 2296: l_okc_actions_tl_rec.last_update_login);

2292: l_okc_actions_tl_rec.created_by,
2293: l_okc_actions_tl_rec.creation_date,
2294: l_okc_actions_tl_rec.last_updated_by,
2295: l_okc_actions_tl_rec.last_update_date,
2296: l_okc_actions_tl_rec.last_update_login);
2297: END LOOP;
2298: -- Set OUT values
2299: x_okc_actions_tl_rec := l_okc_actions_tl_rec;
2300: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2299: x_okc_actions_tl_rec := l_okc_actions_tl_rec;

2295: l_okc_actions_tl_rec.last_update_date,
2296: l_okc_actions_tl_rec.last_update_login);
2297: END LOOP;
2298: -- Set OUT values
2299: x_okc_actions_tl_rec := l_okc_actions_tl_rec;
2300: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2301: EXCEPTION
2302: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2303: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2353: l_okc_actions_tl_rec okc_actions_tl_rec_type;

2349: l_acnv_rec acnv_rec_type;
2350: l_def_acnv_rec acnv_rec_type;
2351: l_acn_rec acn_rec_type;
2352: lx_acn_rec acn_rec_type;
2353: l_okc_actions_tl_rec okc_actions_tl_rec_type;
2354: lx_okc_actions_tl_rec okc_actions_tl_rec_type;
2355: -------------------------------
2356: -- FUNCTION fill_who_columns --
2357: -------------------------------

Line 2354: lx_okc_actions_tl_rec okc_actions_tl_rec_type;

2350: l_def_acnv_rec acnv_rec_type;
2351: l_acn_rec acn_rec_type;
2352: lx_acn_rec acn_rec_type;
2353: l_okc_actions_tl_rec okc_actions_tl_rec_type;
2354: lx_okc_actions_tl_rec okc_actions_tl_rec_type;
2355: -------------------------------
2356: -- FUNCTION fill_who_columns --
2357: -------------------------------
2358: FUNCTION fill_who_columns (

Line 2439: migrate(l_def_acnv_rec, l_okc_actions_tl_rec);

2435: --------------------------------------
2436: -- Move VIEW record to "Child" records
2437: --------------------------------------
2438: migrate(l_def_acnv_rec, l_acn_rec);
2439: migrate(l_def_acnv_rec, l_okc_actions_tl_rec);
2440: --------------------------------------------
2441: -- Call the INSERT_ROW for each child record
2442: --------------------------------------------
2443: insert_row(

Line 2462: l_okc_actions_tl_rec,

2458: p_init_msg_list,
2459: x_return_status,
2460: x_msg_count,
2461: x_msg_data,
2462: l_okc_actions_tl_rec,
2463: lx_okc_actions_tl_rec
2464: );
2465: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2466: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2463: lx_okc_actions_tl_rec

2459: x_return_status,
2460: x_msg_count,
2461: x_msg_data,
2462: l_okc_actions_tl_rec,
2463: lx_okc_actions_tl_rec
2464: );
2465: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2466: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2467: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2470: migrate(lx_okc_actions_tl_rec, l_def_acnv_rec);

2466: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2467: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2468: RAISE OKC_API.G_EXCEPTION_ERROR;
2469: END IF;
2470: migrate(lx_okc_actions_tl_rec, l_def_acnv_rec);
2471: -- Set OUT values
2472: x_acnv_rec := l_def_acnv_rec;
2473: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2474: EXCEPTION

Line 2683: -- lock_row for:OKC_ACTIONS_TL --

2679: '_PVT'
2680: );
2681: END lock_row;
2682: ---------------------------------
2683: -- lock_row for:OKC_ACTIONS_TL --
2684: ---------------------------------
2685: PROCEDURE lock_row(
2686: p_init_msg_list IN VARCHAR2 ,
2687: x_return_status OUT NOCOPY VARCHAR2,

Line 2690: p_okc_actions_tl_rec IN okc_actions_tl_rec_type) IS

2686: p_init_msg_list IN VARCHAR2 ,
2687: x_return_status OUT NOCOPY VARCHAR2,
2688: x_msg_count OUT NOCOPY NUMBER,
2689: x_msg_data OUT NOCOPY VARCHAR2,
2690: p_okc_actions_tl_rec IN okc_actions_tl_rec_type) IS
2691:
2692: E_Resource_Busy EXCEPTION;
2693: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2694: CURSOR lock_csr (p_okc_actions_tl_rec IN okc_actions_tl_rec_type) IS

Line 2694: CURSOR lock_csr (p_okc_actions_tl_rec IN okc_actions_tl_rec_type) IS

2690: p_okc_actions_tl_rec IN okc_actions_tl_rec_type) IS
2691:
2692: E_Resource_Busy EXCEPTION;
2693: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2694: CURSOR lock_csr (p_okc_actions_tl_rec IN okc_actions_tl_rec_type) IS
2695: SELECT *
2696: FROM OKC_ACTIONS_TL
2697: WHERE ID = p_okc_actions_tl_rec.id
2698: FOR UPDATE NOWAIT;

Line 2696: FROM OKC_ACTIONS_TL

2692: E_Resource_Busy EXCEPTION;
2693: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2694: CURSOR lock_csr (p_okc_actions_tl_rec IN okc_actions_tl_rec_type) IS
2695: SELECT *
2696: FROM OKC_ACTIONS_TL
2697: WHERE ID = p_okc_actions_tl_rec.id
2698: FOR UPDATE NOWAIT;
2699:
2700: l_api_version CONSTANT NUMBER := 1;

Line 2697: WHERE ID = p_okc_actions_tl_rec.id

2693: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2694: CURSOR lock_csr (p_okc_actions_tl_rec IN okc_actions_tl_rec_type) IS
2695: SELECT *
2696: FROM OKC_ACTIONS_TL
2697: WHERE ID = p_okc_actions_tl_rec.id
2698: FOR UPDATE NOWAIT;
2699:
2700: l_api_version CONSTANT NUMBER := 1;
2701: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2717: OPEN lock_csr(p_okc_actions_tl_rec);

2713: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2714: RAISE OKC_API.G_EXCEPTION_ERROR;
2715: END IF;
2716: BEGIN
2717: OPEN lock_csr(p_okc_actions_tl_rec);
2718: FETCH lock_csr INTO l_lock_var;
2719: l_row_notfound := lock_csr%NOTFOUND;
2720: CLOSE lock_csr;
2721: EXCEPTION

Line 2782: l_okc_actions_tl_rec okc_actions_tl_rec_type;

2778: l_api_version CONSTANT NUMBER := 1;
2779: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2780: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2781: l_acn_rec acn_rec_type;
2782: l_okc_actions_tl_rec okc_actions_tl_rec_type;
2783: BEGIN
2784: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2785: G_PKG_NAME,
2786: p_init_msg_list,

Line 2800: migrate(p_acnv_rec, l_okc_actions_tl_rec);

2796: --------------------------------------
2797: -- Move VIEW record to "Child" records
2798: --------------------------------------
2799: migrate(p_acnv_rec, l_acn_rec);
2800: migrate(p_acnv_rec, l_okc_actions_tl_rec);
2801: --------------------------------------------
2802: -- Call the LOCK_ROW for each child record
2803: --------------------------------------------
2804: lock_row(

Line 2821: l_okc_actions_tl_rec

2817: p_init_msg_list,
2818: x_return_status,
2819: x_msg_count,
2820: x_msg_data,
2821: l_okc_actions_tl_rec
2822: );
2823: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2824: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2825: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3195: -- update_row for:OKC_ACTIONS_TL --

3191: '_PVT'
3192: );
3193: END update_row;
3194: -----------------------------------
3195: -- update_row for:OKC_ACTIONS_TL --
3196: -----------------------------------
3197: PROCEDURE update_row(
3198: p_init_msg_list IN VARCHAR2 ,
3199: x_return_status OUT NOCOPY VARCHAR2,

Line 3202: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,

3198: p_init_msg_list IN VARCHAR2 ,
3199: x_return_status OUT NOCOPY VARCHAR2,
3200: x_msg_count OUT NOCOPY NUMBER,
3201: x_msg_data OUT NOCOPY VARCHAR2,
3202: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
3203: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type) IS
3204:
3205: l_api_version CONSTANT NUMBER := 1;
3206: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 3203: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type) IS

3199: x_return_status OUT NOCOPY VARCHAR2,
3200: x_msg_count OUT NOCOPY NUMBER,
3201: x_msg_data OUT NOCOPY VARCHAR2,
3202: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
3203: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type) IS
3204:
3205: l_api_version CONSTANT NUMBER := 1;
3206: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3207: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3208: l_okc_actions_tl_rec okc_actions_tl_rec_type := p_okc_actions_tl_rec;

3204:
3205: l_api_version CONSTANT NUMBER := 1;
3206: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3207: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3208: l_okc_actions_tl_rec okc_actions_tl_rec_type := p_okc_actions_tl_rec;
3209: l_def_okc_actions_tl_rec okc_actions_tl_rec_type;
3210: l_row_notfound BOOLEAN := TRUE;
3211: ----------------------------------
3212: -- FUNCTION populate_new_record --

Line 3209: l_def_okc_actions_tl_rec okc_actions_tl_rec_type;

3205: l_api_version CONSTANT NUMBER := 1;
3206: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3207: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3208: l_okc_actions_tl_rec okc_actions_tl_rec_type := p_okc_actions_tl_rec;
3209: l_def_okc_actions_tl_rec okc_actions_tl_rec_type;
3210: l_row_notfound BOOLEAN := TRUE;
3211: ----------------------------------
3212: -- FUNCTION populate_new_record --
3213: ----------------------------------

Line 3215: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,

3211: ----------------------------------
3212: -- FUNCTION populate_new_record --
3213: ----------------------------------
3214: FUNCTION populate_new_record (
3215: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
3216: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type
3217: ) RETURN VARCHAR2 IS
3218: l_okc_actions_tl_rec okc_actions_tl_rec_type;
3219: l_row_notfound BOOLEAN := TRUE;

Line 3216: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type

3212: -- FUNCTION populate_new_record --
3213: ----------------------------------
3214: FUNCTION populate_new_record (
3215: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
3216: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type
3217: ) RETURN VARCHAR2 IS
3218: l_okc_actions_tl_rec okc_actions_tl_rec_type;
3219: l_row_notfound BOOLEAN := TRUE;
3220: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3218: l_okc_actions_tl_rec okc_actions_tl_rec_type;

3214: FUNCTION populate_new_record (
3215: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
3216: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type
3217: ) RETURN VARCHAR2 IS
3218: l_okc_actions_tl_rec okc_actions_tl_rec_type;
3219: l_row_notfound BOOLEAN := TRUE;
3220: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3221: BEGIN
3222: x_okc_actions_tl_rec := p_okc_actions_tl_rec;

Line 3222: x_okc_actions_tl_rec := p_okc_actions_tl_rec;

3218: l_okc_actions_tl_rec okc_actions_tl_rec_type;
3219: l_row_notfound BOOLEAN := TRUE;
3220: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3221: BEGIN
3222: x_okc_actions_tl_rec := p_okc_actions_tl_rec;
3223: -- Get current database values
3224: l_okc_actions_tl_rec := get_rec(p_okc_actions_tl_rec, l_row_notfound);
3225: IF (l_row_notfound) THEN
3226: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 3224: l_okc_actions_tl_rec := get_rec(p_okc_actions_tl_rec, l_row_notfound);

3220: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3221: BEGIN
3222: x_okc_actions_tl_rec := p_okc_actions_tl_rec;
3223: -- Get current database values
3224: l_okc_actions_tl_rec := get_rec(p_okc_actions_tl_rec, l_row_notfound);
3225: IF (l_row_notfound) THEN
3226: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3227: END IF;
3228: IF (x_okc_actions_tl_rec.id = OKC_API.G_MISS_NUM)

Line 3228: IF (x_okc_actions_tl_rec.id = OKC_API.G_MISS_NUM)

3224: l_okc_actions_tl_rec := get_rec(p_okc_actions_tl_rec, l_row_notfound);
3225: IF (l_row_notfound) THEN
3226: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3227: END IF;
3228: IF (x_okc_actions_tl_rec.id = OKC_API.G_MISS_NUM)
3229: THEN
3230: x_okc_actions_tl_rec.id := l_okc_actions_tl_rec.id;
3231: END IF;
3232: IF (x_okc_actions_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 3230: x_okc_actions_tl_rec.id := l_okc_actions_tl_rec.id;

3226: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3227: END IF;
3228: IF (x_okc_actions_tl_rec.id = OKC_API.G_MISS_NUM)
3229: THEN
3230: x_okc_actions_tl_rec.id := l_okc_actions_tl_rec.id;
3231: END IF;
3232: IF (x_okc_actions_tl_rec.language = OKC_API.G_MISS_CHAR)
3233: THEN
3234: x_okc_actions_tl_rec.language := l_okc_actions_tl_rec.language;

Line 3232: IF (x_okc_actions_tl_rec.language = OKC_API.G_MISS_CHAR)

3228: IF (x_okc_actions_tl_rec.id = OKC_API.G_MISS_NUM)
3229: THEN
3230: x_okc_actions_tl_rec.id := l_okc_actions_tl_rec.id;
3231: END IF;
3232: IF (x_okc_actions_tl_rec.language = OKC_API.G_MISS_CHAR)
3233: THEN
3234: x_okc_actions_tl_rec.language := l_okc_actions_tl_rec.language;
3235: END IF;
3236: IF (x_okc_actions_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 3234: x_okc_actions_tl_rec.language := l_okc_actions_tl_rec.language;

3230: x_okc_actions_tl_rec.id := l_okc_actions_tl_rec.id;
3231: END IF;
3232: IF (x_okc_actions_tl_rec.language = OKC_API.G_MISS_CHAR)
3233: THEN
3234: x_okc_actions_tl_rec.language := l_okc_actions_tl_rec.language;
3235: END IF;
3236: IF (x_okc_actions_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3237: THEN
3238: x_okc_actions_tl_rec.source_lang := l_okc_actions_tl_rec.source_lang;

Line 3236: IF (x_okc_actions_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

3232: IF (x_okc_actions_tl_rec.language = OKC_API.G_MISS_CHAR)
3233: THEN
3234: x_okc_actions_tl_rec.language := l_okc_actions_tl_rec.language;
3235: END IF;
3236: IF (x_okc_actions_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3237: THEN
3238: x_okc_actions_tl_rec.source_lang := l_okc_actions_tl_rec.source_lang;
3239: END IF;
3240: IF (x_okc_actions_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 3238: x_okc_actions_tl_rec.source_lang := l_okc_actions_tl_rec.source_lang;

3234: x_okc_actions_tl_rec.language := l_okc_actions_tl_rec.language;
3235: END IF;
3236: IF (x_okc_actions_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3237: THEN
3238: x_okc_actions_tl_rec.source_lang := l_okc_actions_tl_rec.source_lang;
3239: END IF;
3240: IF (x_okc_actions_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3241: THEN
3242: x_okc_actions_tl_rec.sfwt_flag := l_okc_actions_tl_rec.sfwt_flag;

Line 3240: IF (x_okc_actions_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

3236: IF (x_okc_actions_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3237: THEN
3238: x_okc_actions_tl_rec.source_lang := l_okc_actions_tl_rec.source_lang;
3239: END IF;
3240: IF (x_okc_actions_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3241: THEN
3242: x_okc_actions_tl_rec.sfwt_flag := l_okc_actions_tl_rec.sfwt_flag;
3243: END IF;
3244: IF (x_okc_actions_tl_rec.name = OKC_API.G_MISS_CHAR)

Line 3242: x_okc_actions_tl_rec.sfwt_flag := l_okc_actions_tl_rec.sfwt_flag;

3238: x_okc_actions_tl_rec.source_lang := l_okc_actions_tl_rec.source_lang;
3239: END IF;
3240: IF (x_okc_actions_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3241: THEN
3242: x_okc_actions_tl_rec.sfwt_flag := l_okc_actions_tl_rec.sfwt_flag;
3243: END IF;
3244: IF (x_okc_actions_tl_rec.name = OKC_API.G_MISS_CHAR)
3245: THEN
3246: x_okc_actions_tl_rec.name := l_okc_actions_tl_rec.name;

Line 3244: IF (x_okc_actions_tl_rec.name = OKC_API.G_MISS_CHAR)

3240: IF (x_okc_actions_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3241: THEN
3242: x_okc_actions_tl_rec.sfwt_flag := l_okc_actions_tl_rec.sfwt_flag;
3243: END IF;
3244: IF (x_okc_actions_tl_rec.name = OKC_API.G_MISS_CHAR)
3245: THEN
3246: x_okc_actions_tl_rec.name := l_okc_actions_tl_rec.name;
3247: END IF;
3248: IF (x_okc_actions_tl_rec.description = OKC_API.G_MISS_CHAR)

Line 3246: x_okc_actions_tl_rec.name := l_okc_actions_tl_rec.name;

3242: x_okc_actions_tl_rec.sfwt_flag := l_okc_actions_tl_rec.sfwt_flag;
3243: END IF;
3244: IF (x_okc_actions_tl_rec.name = OKC_API.G_MISS_CHAR)
3245: THEN
3246: x_okc_actions_tl_rec.name := l_okc_actions_tl_rec.name;
3247: END IF;
3248: IF (x_okc_actions_tl_rec.description = OKC_API.G_MISS_CHAR)
3249: THEN
3250: x_okc_actions_tl_rec.description := l_okc_actions_tl_rec.description;

Line 3248: IF (x_okc_actions_tl_rec.description = OKC_API.G_MISS_CHAR)

3244: IF (x_okc_actions_tl_rec.name = OKC_API.G_MISS_CHAR)
3245: THEN
3246: x_okc_actions_tl_rec.name := l_okc_actions_tl_rec.name;
3247: END IF;
3248: IF (x_okc_actions_tl_rec.description = OKC_API.G_MISS_CHAR)
3249: THEN
3250: x_okc_actions_tl_rec.description := l_okc_actions_tl_rec.description;
3251: END IF;
3252: IF (x_okc_actions_tl_rec.short_description = OKC_API.G_MISS_CHAR)

Line 3250: x_okc_actions_tl_rec.description := l_okc_actions_tl_rec.description;

3246: x_okc_actions_tl_rec.name := l_okc_actions_tl_rec.name;
3247: END IF;
3248: IF (x_okc_actions_tl_rec.description = OKC_API.G_MISS_CHAR)
3249: THEN
3250: x_okc_actions_tl_rec.description := l_okc_actions_tl_rec.description;
3251: END IF;
3252: IF (x_okc_actions_tl_rec.short_description = OKC_API.G_MISS_CHAR)
3253: THEN
3254: x_okc_actions_tl_rec.short_description := l_okc_actions_tl_rec.short_description;

Line 3252: IF (x_okc_actions_tl_rec.short_description = OKC_API.G_MISS_CHAR)

3248: IF (x_okc_actions_tl_rec.description = OKC_API.G_MISS_CHAR)
3249: THEN
3250: x_okc_actions_tl_rec.description := l_okc_actions_tl_rec.description;
3251: END IF;
3252: IF (x_okc_actions_tl_rec.short_description = OKC_API.G_MISS_CHAR)
3253: THEN
3254: x_okc_actions_tl_rec.short_description := l_okc_actions_tl_rec.short_description;
3255: END IF;
3256: IF (x_okc_actions_tl_rec.comments = OKC_API.G_MISS_CHAR)

Line 3254: x_okc_actions_tl_rec.short_description := l_okc_actions_tl_rec.short_description;

3250: x_okc_actions_tl_rec.description := l_okc_actions_tl_rec.description;
3251: END IF;
3252: IF (x_okc_actions_tl_rec.short_description = OKC_API.G_MISS_CHAR)
3253: THEN
3254: x_okc_actions_tl_rec.short_description := l_okc_actions_tl_rec.short_description;
3255: END IF;
3256: IF (x_okc_actions_tl_rec.comments = OKC_API.G_MISS_CHAR)
3257: THEN
3258: x_okc_actions_tl_rec.comments := l_okc_actions_tl_rec.comments;

Line 3256: IF (x_okc_actions_tl_rec.comments = OKC_API.G_MISS_CHAR)

3252: IF (x_okc_actions_tl_rec.short_description = OKC_API.G_MISS_CHAR)
3253: THEN
3254: x_okc_actions_tl_rec.short_description := l_okc_actions_tl_rec.short_description;
3255: END IF;
3256: IF (x_okc_actions_tl_rec.comments = OKC_API.G_MISS_CHAR)
3257: THEN
3258: x_okc_actions_tl_rec.comments := l_okc_actions_tl_rec.comments;
3259: END IF;
3260: IF (x_okc_actions_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 3258: x_okc_actions_tl_rec.comments := l_okc_actions_tl_rec.comments;

3254: x_okc_actions_tl_rec.short_description := l_okc_actions_tl_rec.short_description;
3255: END IF;
3256: IF (x_okc_actions_tl_rec.comments = OKC_API.G_MISS_CHAR)
3257: THEN
3258: x_okc_actions_tl_rec.comments := l_okc_actions_tl_rec.comments;
3259: END IF;
3260: IF (x_okc_actions_tl_rec.created_by = OKC_API.G_MISS_NUM)
3261: THEN
3262: x_okc_actions_tl_rec.created_by := l_okc_actions_tl_rec.created_by;

Line 3260: IF (x_okc_actions_tl_rec.created_by = OKC_API.G_MISS_NUM)

3256: IF (x_okc_actions_tl_rec.comments = OKC_API.G_MISS_CHAR)
3257: THEN
3258: x_okc_actions_tl_rec.comments := l_okc_actions_tl_rec.comments;
3259: END IF;
3260: IF (x_okc_actions_tl_rec.created_by = OKC_API.G_MISS_NUM)
3261: THEN
3262: x_okc_actions_tl_rec.created_by := l_okc_actions_tl_rec.created_by;
3263: END IF;
3264: IF (x_okc_actions_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 3262: x_okc_actions_tl_rec.created_by := l_okc_actions_tl_rec.created_by;

3258: x_okc_actions_tl_rec.comments := l_okc_actions_tl_rec.comments;
3259: END IF;
3260: IF (x_okc_actions_tl_rec.created_by = OKC_API.G_MISS_NUM)
3261: THEN
3262: x_okc_actions_tl_rec.created_by := l_okc_actions_tl_rec.created_by;
3263: END IF;
3264: IF (x_okc_actions_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3265: THEN
3266: x_okc_actions_tl_rec.creation_date := l_okc_actions_tl_rec.creation_date;

Line 3264: IF (x_okc_actions_tl_rec.creation_date = OKC_API.G_MISS_DATE)

3260: IF (x_okc_actions_tl_rec.created_by = OKC_API.G_MISS_NUM)
3261: THEN
3262: x_okc_actions_tl_rec.created_by := l_okc_actions_tl_rec.created_by;
3263: END IF;
3264: IF (x_okc_actions_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3265: THEN
3266: x_okc_actions_tl_rec.creation_date := l_okc_actions_tl_rec.creation_date;
3267: END IF;
3268: IF (x_okc_actions_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 3266: x_okc_actions_tl_rec.creation_date := l_okc_actions_tl_rec.creation_date;

3262: x_okc_actions_tl_rec.created_by := l_okc_actions_tl_rec.created_by;
3263: END IF;
3264: IF (x_okc_actions_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3265: THEN
3266: x_okc_actions_tl_rec.creation_date := l_okc_actions_tl_rec.creation_date;
3267: END IF;
3268: IF (x_okc_actions_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3269: THEN
3270: x_okc_actions_tl_rec.last_updated_by := l_okc_actions_tl_rec.last_updated_by;

Line 3268: IF (x_okc_actions_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

3264: IF (x_okc_actions_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3265: THEN
3266: x_okc_actions_tl_rec.creation_date := l_okc_actions_tl_rec.creation_date;
3267: END IF;
3268: IF (x_okc_actions_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3269: THEN
3270: x_okc_actions_tl_rec.last_updated_by := l_okc_actions_tl_rec.last_updated_by;
3271: END IF;
3272: IF (x_okc_actions_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 3270: x_okc_actions_tl_rec.last_updated_by := l_okc_actions_tl_rec.last_updated_by;

3266: x_okc_actions_tl_rec.creation_date := l_okc_actions_tl_rec.creation_date;
3267: END IF;
3268: IF (x_okc_actions_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3269: THEN
3270: x_okc_actions_tl_rec.last_updated_by := l_okc_actions_tl_rec.last_updated_by;
3271: END IF;
3272: IF (x_okc_actions_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3273: THEN
3274: x_okc_actions_tl_rec.last_update_date := l_okc_actions_tl_rec.last_update_date;

Line 3272: IF (x_okc_actions_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

3268: IF (x_okc_actions_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3269: THEN
3270: x_okc_actions_tl_rec.last_updated_by := l_okc_actions_tl_rec.last_updated_by;
3271: END IF;
3272: IF (x_okc_actions_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3273: THEN
3274: x_okc_actions_tl_rec.last_update_date := l_okc_actions_tl_rec.last_update_date;
3275: END IF;
3276: IF (x_okc_actions_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 3274: x_okc_actions_tl_rec.last_update_date := l_okc_actions_tl_rec.last_update_date;

3270: x_okc_actions_tl_rec.last_updated_by := l_okc_actions_tl_rec.last_updated_by;
3271: END IF;
3272: IF (x_okc_actions_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3273: THEN
3274: x_okc_actions_tl_rec.last_update_date := l_okc_actions_tl_rec.last_update_date;
3275: END IF;
3276: IF (x_okc_actions_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3277: THEN
3278: x_okc_actions_tl_rec.last_update_login := l_okc_actions_tl_rec.last_update_login;

Line 3276: IF (x_okc_actions_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

3272: IF (x_okc_actions_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3273: THEN
3274: x_okc_actions_tl_rec.last_update_date := l_okc_actions_tl_rec.last_update_date;
3275: END IF;
3276: IF (x_okc_actions_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3277: THEN
3278: x_okc_actions_tl_rec.last_update_login := l_okc_actions_tl_rec.last_update_login;
3279: END IF;
3280: RETURN(l_return_status);

Line 3278: x_okc_actions_tl_rec.last_update_login := l_okc_actions_tl_rec.last_update_login;

3274: x_okc_actions_tl_rec.last_update_date := l_okc_actions_tl_rec.last_update_date;
3275: END IF;
3276: IF (x_okc_actions_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3277: THEN
3278: x_okc_actions_tl_rec.last_update_login := l_okc_actions_tl_rec.last_update_login;
3279: END IF;
3280: RETURN(l_return_status);
3281: END populate_new_record;
3282: ---------------------------------------

Line 3283: -- Set_Attributes for:OKC_ACTIONS_TL --

3279: END IF;
3280: RETURN(l_return_status);
3281: END populate_new_record;
3282: ---------------------------------------
3283: -- Set_Attributes for:OKC_ACTIONS_TL --
3284: ---------------------------------------
3285: FUNCTION Set_Attributes (
3286: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
3287: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type

Line 3286: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,

3282: ---------------------------------------
3283: -- Set_Attributes for:OKC_ACTIONS_TL --
3284: ---------------------------------------
3285: FUNCTION Set_Attributes (
3286: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
3287: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type
3288: ) RETURN VARCHAR2 IS
3289: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3290: BEGIN

Line 3287: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type

3283: -- Set_Attributes for:OKC_ACTIONS_TL --
3284: ---------------------------------------
3285: FUNCTION Set_Attributes (
3286: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
3287: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type
3288: ) RETURN VARCHAR2 IS
3289: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3290: BEGIN
3291: x_okc_actions_tl_rec := p_okc_actions_tl_rec;

Line 3291: x_okc_actions_tl_rec := p_okc_actions_tl_rec;

3287: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type
3288: ) RETURN VARCHAR2 IS
3289: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3290: BEGIN
3291: x_okc_actions_tl_rec := p_okc_actions_tl_rec;
3292: x_okc_actions_tl_rec.LANGUAGE := l_lang;
3293: x_okc_actions_tl_rec.SOURCE_LANG := l_lang;
3294: RETURN(l_return_status);
3295: END Set_Attributes;

Line 3292: x_okc_actions_tl_rec.LANGUAGE := l_lang;

3288: ) RETURN VARCHAR2 IS
3289: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3290: BEGIN
3291: x_okc_actions_tl_rec := p_okc_actions_tl_rec;
3292: x_okc_actions_tl_rec.LANGUAGE := l_lang;
3293: x_okc_actions_tl_rec.SOURCE_LANG := l_lang;
3294: RETURN(l_return_status);
3295: END Set_Attributes;
3296: BEGIN

Line 3293: x_okc_actions_tl_rec.SOURCE_LANG := l_lang;

3289: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3290: BEGIN
3291: x_okc_actions_tl_rec := p_okc_actions_tl_rec;
3292: x_okc_actions_tl_rec.LANGUAGE := l_lang;
3293: x_okc_actions_tl_rec.SOURCE_LANG := l_lang;
3294: RETURN(l_return_status);
3295: END Set_Attributes;
3296: BEGIN
3297: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3308: p_okc_actions_tl_rec, -- IN

3304: RAISE OKC_API.G_EXCEPTION_ERROR;
3305: END IF;
3306: --- Setting item attributes
3307: l_return_status := Set_Attributes(
3308: p_okc_actions_tl_rec, -- IN
3309: l_okc_actions_tl_rec); -- OUT
3310: --- If any errors happen abort API
3311: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3312: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3309: l_okc_actions_tl_rec); -- OUT

3305: END IF;
3306: --- Setting item attributes
3307: l_return_status := Set_Attributes(
3308: p_okc_actions_tl_rec, -- IN
3309: l_okc_actions_tl_rec); -- OUT
3310: --- If any errors happen abort API
3311: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3312: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3313: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3316: l_return_status := populate_new_record(l_okc_actions_tl_rec, l_def_okc_actions_tl_rec);

3312: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3313: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3314: RAISE OKC_API.G_EXCEPTION_ERROR;
3315: END IF;
3316: l_return_status := populate_new_record(l_okc_actions_tl_rec, l_def_okc_actions_tl_rec);
3317: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3318: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3319: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3320: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3322: UPDATE OKC_ACTIONS_TL

3318: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3319: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3320: RAISE OKC_API.G_EXCEPTION_ERROR;
3321: END IF;
3322: UPDATE OKC_ACTIONS_TL
3323: SET NAME = l_def_okc_actions_tl_rec.name,
3324: DESCRIPTION = l_def_okc_actions_tl_rec.description,
3325: SOURCE_LANG = l_def_okc_actions_tl_rec.source_lang,
3326: SHORT_DESCRIPTION = l_def_okc_actions_tl_rec.short_description,

Line 3323: SET NAME = l_def_okc_actions_tl_rec.name,

3319: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3320: RAISE OKC_API.G_EXCEPTION_ERROR;
3321: END IF;
3322: UPDATE OKC_ACTIONS_TL
3323: SET NAME = l_def_okc_actions_tl_rec.name,
3324: DESCRIPTION = l_def_okc_actions_tl_rec.description,
3325: SOURCE_LANG = l_def_okc_actions_tl_rec.source_lang,
3326: SHORT_DESCRIPTION = l_def_okc_actions_tl_rec.short_description,
3327: COMMENTS = l_def_okc_actions_tl_rec.comments,

Line 3324: DESCRIPTION = l_def_okc_actions_tl_rec.description,

3320: RAISE OKC_API.G_EXCEPTION_ERROR;
3321: END IF;
3322: UPDATE OKC_ACTIONS_TL
3323: SET NAME = l_def_okc_actions_tl_rec.name,
3324: DESCRIPTION = l_def_okc_actions_tl_rec.description,
3325: SOURCE_LANG = l_def_okc_actions_tl_rec.source_lang,
3326: SHORT_DESCRIPTION = l_def_okc_actions_tl_rec.short_description,
3327: COMMENTS = l_def_okc_actions_tl_rec.comments,
3328: CREATED_BY = l_def_okc_actions_tl_rec.created_by,

Line 3325: SOURCE_LANG = l_def_okc_actions_tl_rec.source_lang,

3321: END IF;
3322: UPDATE OKC_ACTIONS_TL
3323: SET NAME = l_def_okc_actions_tl_rec.name,
3324: DESCRIPTION = l_def_okc_actions_tl_rec.description,
3325: SOURCE_LANG = l_def_okc_actions_tl_rec.source_lang,
3326: SHORT_DESCRIPTION = l_def_okc_actions_tl_rec.short_description,
3327: COMMENTS = l_def_okc_actions_tl_rec.comments,
3328: CREATED_BY = l_def_okc_actions_tl_rec.created_by,
3329: CREATION_DATE = l_def_okc_actions_tl_rec.creation_date,

Line 3326: SHORT_DESCRIPTION = l_def_okc_actions_tl_rec.short_description,

3322: UPDATE OKC_ACTIONS_TL
3323: SET NAME = l_def_okc_actions_tl_rec.name,
3324: DESCRIPTION = l_def_okc_actions_tl_rec.description,
3325: SOURCE_LANG = l_def_okc_actions_tl_rec.source_lang,
3326: SHORT_DESCRIPTION = l_def_okc_actions_tl_rec.short_description,
3327: COMMENTS = l_def_okc_actions_tl_rec.comments,
3328: CREATED_BY = l_def_okc_actions_tl_rec.created_by,
3329: CREATION_DATE = l_def_okc_actions_tl_rec.creation_date,
3330: LAST_UPDATED_BY = l_def_okc_actions_tl_rec.last_updated_by,

Line 3327: COMMENTS = l_def_okc_actions_tl_rec.comments,

3323: SET NAME = l_def_okc_actions_tl_rec.name,
3324: DESCRIPTION = l_def_okc_actions_tl_rec.description,
3325: SOURCE_LANG = l_def_okc_actions_tl_rec.source_lang,
3326: SHORT_DESCRIPTION = l_def_okc_actions_tl_rec.short_description,
3327: COMMENTS = l_def_okc_actions_tl_rec.comments,
3328: CREATED_BY = l_def_okc_actions_tl_rec.created_by,
3329: CREATION_DATE = l_def_okc_actions_tl_rec.creation_date,
3330: LAST_UPDATED_BY = l_def_okc_actions_tl_rec.last_updated_by,
3331: LAST_UPDATE_DATE = l_def_okc_actions_tl_rec.last_update_date,

Line 3328: CREATED_BY = l_def_okc_actions_tl_rec.created_by,

3324: DESCRIPTION = l_def_okc_actions_tl_rec.description,
3325: SOURCE_LANG = l_def_okc_actions_tl_rec.source_lang,
3326: SHORT_DESCRIPTION = l_def_okc_actions_tl_rec.short_description,
3327: COMMENTS = l_def_okc_actions_tl_rec.comments,
3328: CREATED_BY = l_def_okc_actions_tl_rec.created_by,
3329: CREATION_DATE = l_def_okc_actions_tl_rec.creation_date,
3330: LAST_UPDATED_BY = l_def_okc_actions_tl_rec.last_updated_by,
3331: LAST_UPDATE_DATE = l_def_okc_actions_tl_rec.last_update_date,
3332: LAST_UPDATE_LOGIN = l_def_okc_actions_tl_rec.last_update_login

Line 3329: CREATION_DATE = l_def_okc_actions_tl_rec.creation_date,

3325: SOURCE_LANG = l_def_okc_actions_tl_rec.source_lang,
3326: SHORT_DESCRIPTION = l_def_okc_actions_tl_rec.short_description,
3327: COMMENTS = l_def_okc_actions_tl_rec.comments,
3328: CREATED_BY = l_def_okc_actions_tl_rec.created_by,
3329: CREATION_DATE = l_def_okc_actions_tl_rec.creation_date,
3330: LAST_UPDATED_BY = l_def_okc_actions_tl_rec.last_updated_by,
3331: LAST_UPDATE_DATE = l_def_okc_actions_tl_rec.last_update_date,
3332: LAST_UPDATE_LOGIN = l_def_okc_actions_tl_rec.last_update_login
3333: WHERE ID = l_def_okc_actions_tl_rec.id

Line 3330: LAST_UPDATED_BY = l_def_okc_actions_tl_rec.last_updated_by,

3326: SHORT_DESCRIPTION = l_def_okc_actions_tl_rec.short_description,
3327: COMMENTS = l_def_okc_actions_tl_rec.comments,
3328: CREATED_BY = l_def_okc_actions_tl_rec.created_by,
3329: CREATION_DATE = l_def_okc_actions_tl_rec.creation_date,
3330: LAST_UPDATED_BY = l_def_okc_actions_tl_rec.last_updated_by,
3331: LAST_UPDATE_DATE = l_def_okc_actions_tl_rec.last_update_date,
3332: LAST_UPDATE_LOGIN = l_def_okc_actions_tl_rec.last_update_login
3333: WHERE ID = l_def_okc_actions_tl_rec.id
3334: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);

Line 3331: LAST_UPDATE_DATE = l_def_okc_actions_tl_rec.last_update_date,

3327: COMMENTS = l_def_okc_actions_tl_rec.comments,
3328: CREATED_BY = l_def_okc_actions_tl_rec.created_by,
3329: CREATION_DATE = l_def_okc_actions_tl_rec.creation_date,
3330: LAST_UPDATED_BY = l_def_okc_actions_tl_rec.last_updated_by,
3331: LAST_UPDATE_DATE = l_def_okc_actions_tl_rec.last_update_date,
3332: LAST_UPDATE_LOGIN = l_def_okc_actions_tl_rec.last_update_login
3333: WHERE ID = l_def_okc_actions_tl_rec.id
3334: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
3335: --AND SOURCE_LANG = USERENV('LANG');

Line 3332: LAST_UPDATE_LOGIN = l_def_okc_actions_tl_rec.last_update_login

3328: CREATED_BY = l_def_okc_actions_tl_rec.created_by,
3329: CREATION_DATE = l_def_okc_actions_tl_rec.creation_date,
3330: LAST_UPDATED_BY = l_def_okc_actions_tl_rec.last_updated_by,
3331: LAST_UPDATE_DATE = l_def_okc_actions_tl_rec.last_update_date,
3332: LAST_UPDATE_LOGIN = l_def_okc_actions_tl_rec.last_update_login
3333: WHERE ID = l_def_okc_actions_tl_rec.id
3334: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
3335: --AND SOURCE_LANG = USERENV('LANG');
3336:

Line 3333: WHERE ID = l_def_okc_actions_tl_rec.id

3329: CREATION_DATE = l_def_okc_actions_tl_rec.creation_date,
3330: LAST_UPDATED_BY = l_def_okc_actions_tl_rec.last_updated_by,
3331: LAST_UPDATE_DATE = l_def_okc_actions_tl_rec.last_update_date,
3332: LAST_UPDATE_LOGIN = l_def_okc_actions_tl_rec.last_update_login
3333: WHERE ID = l_def_okc_actions_tl_rec.id
3334: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
3335: --AND SOURCE_LANG = USERENV('LANG');
3336:
3337: UPDATE OKC_ACTIONS_TL

Line 3337: UPDATE OKC_ACTIONS_TL

3333: WHERE ID = l_def_okc_actions_tl_rec.id
3334: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
3335: --AND SOURCE_LANG = USERENV('LANG');
3336:
3337: UPDATE OKC_ACTIONS_TL
3338: SET SFWT_FLAG = 'Y'
3339: WHERE ID = l_def_okc_actions_tl_rec.id
3340: AND SOURCE_LANG <> USERENV('LANG');
3341:

Line 3339: WHERE ID = l_def_okc_actions_tl_rec.id

3335: --AND SOURCE_LANG = USERENV('LANG');
3336:
3337: UPDATE OKC_ACTIONS_TL
3338: SET SFWT_FLAG = 'Y'
3339: WHERE ID = l_def_okc_actions_tl_rec.id
3340: AND SOURCE_LANG <> USERENV('LANG');
3341:
3342: x_okc_actions_tl_rec := l_def_okc_actions_tl_rec;
3343: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3342: x_okc_actions_tl_rec := l_def_okc_actions_tl_rec;

3338: SET SFWT_FLAG = 'Y'
3339: WHERE ID = l_def_okc_actions_tl_rec.id
3340: AND SOURCE_LANG <> USERENV('LANG');
3341:
3342: x_okc_actions_tl_rec := l_def_okc_actions_tl_rec;
3343: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3344: EXCEPTION
3345: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3346: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3393: l_okc_actions_tl_rec okc_actions_tl_rec_type;

3389: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
3390: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3391: l_acnv_rec acnv_rec_type := p_acnv_rec;
3392: l_def_acnv_rec acnv_rec_type;
3393: l_okc_actions_tl_rec okc_actions_tl_rec_type;
3394: lx_okc_actions_tl_rec okc_actions_tl_rec_type;
3395: l_acn_rec acn_rec_type;
3396: lx_acn_rec acn_rec_type;
3397: -------------------------------

Line 3394: lx_okc_actions_tl_rec okc_actions_tl_rec_type;

3390: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3391: l_acnv_rec acnv_rec_type := p_acnv_rec;
3392: l_def_acnv_rec acnv_rec_type;
3393: l_okc_actions_tl_rec okc_actions_tl_rec_type;
3394: lx_okc_actions_tl_rec okc_actions_tl_rec_type;
3395: l_acn_rec acn_rec_type;
3396: lx_acn_rec acn_rec_type;
3397: -------------------------------
3398: -- FUNCTION fill_who_columns --

Line 3649: migrate(l_def_acnv_rec, l_okc_actions_tl_rec);

3645:
3646: --------------------------------------
3647: -- Move VIEW record to "Child" records
3648: --------------------------------------
3649: migrate(l_def_acnv_rec, l_okc_actions_tl_rec);
3650: migrate(l_def_acnv_rec, l_acn_rec);
3651: --------------------------------------------
3652: -- Call the UPDATE_ROW for each child record
3653: --------------------------------------------

Line 3659: l_okc_actions_tl_rec,

3655: p_init_msg_list,
3656: x_return_status,
3657: x_msg_count,
3658: x_msg_data,
3659: l_okc_actions_tl_rec,
3660: lx_okc_actions_tl_rec
3661: );
3662: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3663: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3660: lx_okc_actions_tl_rec

3656: x_return_status,
3657: x_msg_count,
3658: x_msg_data,
3659: l_okc_actions_tl_rec,
3660: lx_okc_actions_tl_rec
3661: );
3662: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3663: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3664: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3667: migrate(lx_okc_actions_tl_rec, l_def_acnv_rec);

3663: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3664: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3665: RAISE OKC_API.G_EXCEPTION_ERROR;
3666: END IF;
3667: migrate(lx_okc_actions_tl_rec, l_def_acnv_rec);
3668: update_row(
3669: p_init_msg_list,
3670: x_return_status,
3671: x_msg_count,

Line 3848: -- delete_row for:OKC_ACTIONS_TL --

3844: '_PVT'
3845: );
3846: END delete_row;
3847: -----------------------------------
3848: -- delete_row for:OKC_ACTIONS_TL --
3849: -----------------------------------
3850: PROCEDURE delete_row(
3851: p_init_msg_list IN VARCHAR2 ,
3852: x_return_status OUT NOCOPY VARCHAR2,

Line 3855: p_okc_actions_tl_rec IN okc_actions_tl_rec_type) IS

3851: p_init_msg_list IN VARCHAR2 ,
3852: x_return_status OUT NOCOPY VARCHAR2,
3853: x_msg_count OUT NOCOPY NUMBER,
3854: x_msg_data OUT NOCOPY VARCHAR2,
3855: p_okc_actions_tl_rec IN okc_actions_tl_rec_type) IS
3856:
3857: l_api_version CONSTANT NUMBER := 1;
3858: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3859: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3860: l_okc_actions_tl_rec okc_actions_tl_rec_type:= p_okc_actions_tl_rec;

3856:
3857: l_api_version CONSTANT NUMBER := 1;
3858: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3859: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3860: l_okc_actions_tl_rec okc_actions_tl_rec_type:= p_okc_actions_tl_rec;
3861: l_row_notfound BOOLEAN := TRUE;
3862: ---------------------------------------
3863: -- Set_Attributes for:OKC_ACTIONS_TL --
3864: ---------------------------------------

Line 3863: -- Set_Attributes for:OKC_ACTIONS_TL --

3859: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3860: l_okc_actions_tl_rec okc_actions_tl_rec_type:= p_okc_actions_tl_rec;
3861: l_row_notfound BOOLEAN := TRUE;
3862: ---------------------------------------
3863: -- Set_Attributes for:OKC_ACTIONS_TL --
3864: ---------------------------------------
3865: FUNCTION Set_Attributes (
3866: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
3867: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type

Line 3866: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,

3862: ---------------------------------------
3863: -- Set_Attributes for:OKC_ACTIONS_TL --
3864: ---------------------------------------
3865: FUNCTION Set_Attributes (
3866: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
3867: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type
3868: ) RETURN VARCHAR2 IS
3869: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3870: BEGIN

Line 3867: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type

3863: -- Set_Attributes for:OKC_ACTIONS_TL --
3864: ---------------------------------------
3865: FUNCTION Set_Attributes (
3866: p_okc_actions_tl_rec IN okc_actions_tl_rec_type,
3867: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type
3868: ) RETURN VARCHAR2 IS
3869: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3870: BEGIN
3871: x_okc_actions_tl_rec := p_okc_actions_tl_rec;

Line 3871: x_okc_actions_tl_rec := p_okc_actions_tl_rec;

3867: x_okc_actions_tl_rec OUT NOCOPY okc_actions_tl_rec_type
3868: ) RETURN VARCHAR2 IS
3869: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3870: BEGIN
3871: x_okc_actions_tl_rec := p_okc_actions_tl_rec;
3872: x_okc_actions_tl_rec.LANGUAGE := l_lang;
3873: RETURN(l_return_status);
3874: END Set_Attributes;
3875: BEGIN

Line 3872: x_okc_actions_tl_rec.LANGUAGE := l_lang;

3868: ) RETURN VARCHAR2 IS
3869: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3870: BEGIN
3871: x_okc_actions_tl_rec := p_okc_actions_tl_rec;
3872: x_okc_actions_tl_rec.LANGUAGE := l_lang;
3873: RETURN(l_return_status);
3874: END Set_Attributes;
3875: BEGIN
3876: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3887: p_okc_actions_tl_rec, -- IN

3883: RAISE OKC_API.G_EXCEPTION_ERROR;
3884: END IF;
3885: --- Setting item attributes
3886: l_return_status := Set_Attributes(
3887: p_okc_actions_tl_rec, -- IN
3888: l_okc_actions_tl_rec); -- OUT
3889: --- If any errors happen abort API
3890: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3891: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3888: l_okc_actions_tl_rec); -- OUT

3884: END IF;
3885: --- Setting item attributes
3886: l_return_status := Set_Attributes(
3887: p_okc_actions_tl_rec, -- IN
3888: l_okc_actions_tl_rec); -- OUT
3889: --- If any errors happen abort API
3890: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3891: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3892: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3895: DELETE FROM OKC_ACTIONS_TL

3891: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3892: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3893: RAISE OKC_API.G_EXCEPTION_ERROR;
3894: END IF;
3895: DELETE FROM OKC_ACTIONS_TL
3896: WHERE ID = l_okc_actions_tl_rec.id;
3897:
3898: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3899: EXCEPTION

Line 3896: WHERE ID = l_okc_actions_tl_rec.id;

3892: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3893: RAISE OKC_API.G_EXCEPTION_ERROR;
3894: END IF;
3895: DELETE FROM OKC_ACTIONS_TL
3896: WHERE ID = l_okc_actions_tl_rec.id;
3897:
3898: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3899: EXCEPTION
3900: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3946: l_okc_actions_tl_rec okc_actions_tl_rec_type;

3942: l_api_version CONSTANT NUMBER := 1;
3943: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3944: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3945: l_acnv_rec acnv_rec_type := p_acnv_rec;
3946: l_okc_actions_tl_rec okc_actions_tl_rec_type;
3947: l_acn_rec acn_rec_type;
3948: BEGIN
3949: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3950: G_PKG_NAME,

Line 3977: migrate(l_acnv_rec, l_okc_actions_tl_rec);

3973: END IF;*/
3974: --------------------------------------
3975: -- Move VIEW record to "Child" records
3976: --------------------------------------
3977: migrate(l_acnv_rec, l_okc_actions_tl_rec);
3978: migrate(l_acnv_rec, l_acn_rec);
3979: --------------------------------------------
3980: -- Call the DELETE_ROW for each child record
3981: --------------------------------------------

Line 3987: l_okc_actions_tl_rec

3983: p_init_msg_list,
3984: x_return_status,
3985: x_msg_count,
3986: x_msg_data,
3987: l_okc_actions_tl_rec
3988: );
3989: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3990: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3991: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN