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.OKL_RCA_PVT dependencies on OKL_TXL_RCPT_APPS_TL

Line 40: DELETE FROM OKL_TXL_RCPT_APPS_TL T

36: -- PROCEDURE add_language
37: ---------------------------------------------------------------------------
38: PROCEDURE add_language IS
39: BEGIN
40: DELETE FROM OKL_TXL_RCPT_APPS_TL T
41: WHERE NOT EXISTS (
42: SELECT NULL
43: FROM OKL_TXL_RCPT_APPS_ALL_B B
44: WHERE B.ID = T.ID

Line 47: UPDATE OKL_TXL_RCPT_APPS_TL T SET (

43: FROM OKL_TXL_RCPT_APPS_ALL_B B
44: WHERE B.ID = T.ID
45: );
46:
47: UPDATE OKL_TXL_RCPT_APPS_TL T SET (
48: DESCRIPTION) = (SELECT
49: B.DESCRIPTION
50: FROM OKL_TXL_RCPT_APPS_TL B
51: WHERE B.ID = T.ID

Line 50: FROM OKL_TXL_RCPT_APPS_TL B

46:
47: UPDATE OKL_TXL_RCPT_APPS_TL T SET (
48: DESCRIPTION) = (SELECT
49: B.DESCRIPTION
50: FROM OKL_TXL_RCPT_APPS_TL B
51: WHERE B.ID = T.ID
52: AND B.LANGUAGE = T.SOURCE_LANG)
53: WHERE (
54: T.ID,

Line 59: FROM OKL_TXL_RCPT_APPS_TL SUBB, OKL_TXL_RCPT_APPS_TL SUBT

55: T.LANGUAGE)
56: IN (SELECT
57: SUBT.ID,
58: SUBT.LANGUAGE
59: FROM OKL_TXL_RCPT_APPS_TL SUBB, OKL_TXL_RCPT_APPS_TL SUBT
60: WHERE SUBB.ID = SUBT.ID
61: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
62: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
63: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)

Line 67: INSERT INTO OKL_TXL_RCPT_APPS_TL (

63: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
64: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
65: ));
66:
67: INSERT INTO OKL_TXL_RCPT_APPS_TL (
68: ID,
69: LANGUAGE,
70: SOURCE_LANG,
71: SFWT_FLAG,

Line 89: FROM OKL_TXL_RCPT_APPS_TL B, FND_LANGUAGES L

85: B.CREATION_DATE,
86: B.LAST_UPDATED_BY,
87: B.LAST_UPDATE_DATE,
88: B.LAST_UPDATE_LOGIN
89: FROM OKL_TXL_RCPT_APPS_TL B, FND_LANGUAGES L
90: WHERE L.INSTALLED_FLAG IN ('I', 'B')
91: AND B.LANGUAGE = USERENV('LANG')
92: AND NOT EXISTS(
93: SELECT NULL

Line 94: FROM OKL_TXL_RCPT_APPS_TL T

90: WHERE L.INSTALLED_FLAG IN ('I', 'B')
91: AND B.LANGUAGE = USERENV('LANG')
92: AND NOT EXISTS(
93: SELECT NULL
94: FROM OKL_TXL_RCPT_APPS_TL T
95: WHERE T.ID = B.ID
96: AND T.LANGUAGE = L.LANGUAGE_CODE
97: );
98:

Line 224: -- FUNCTION get_rec for: OKL_TXL_RCPT_APPS_TL

220: BEGIN
221: RETURN(get_rec(p_rca_rec, l_row_notfound));
222: END get_rec;
223: ---------------------------------------------------------------------------
224: -- FUNCTION get_rec for: OKL_TXL_RCPT_APPS_TL
225: ---------------------------------------------------------------------------
226: FUNCTION get_rec (
227: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,
228: x_no_data_found OUT NOCOPY BOOLEAN

Line 227: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,

223: ---------------------------------------------------------------------------
224: -- FUNCTION get_rec for: OKL_TXL_RCPT_APPS_TL
225: ---------------------------------------------------------------------------
226: FUNCTION get_rec (
227: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,
228: x_no_data_found OUT NOCOPY BOOLEAN
229: ) RETURN okl_txl_rcpt_apps_tl_rec_type IS
230: CURSOR okl_txl_rcpt_apps_tl_pk_csr (p_id IN NUMBER,
231: p_language IN VARCHAR2) IS

Line 229: ) RETURN okl_txl_rcpt_apps_tl_rec_type IS

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

Line 230: CURSOR okl_txl_rcpt_apps_tl_pk_csr (p_id IN NUMBER,

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

Line 243: FROM Okl_Txl_Rcpt_Apps_Tl

239: CREATION_DATE,
240: LAST_UPDATED_BY,
241: LAST_UPDATE_DATE,
242: LAST_UPDATE_LOGIN
243: FROM Okl_Txl_Rcpt_Apps_Tl
244: WHERE okl_txl_rcpt_apps_tl.id = p_id
245: AND okl_txl_rcpt_apps_tl.LANGUAGE = p_language;
246: l_okl_txl_rcpt_apps_tl_pk okl_txl_rcpt_apps_tl_pk_csr%ROWTYPE;
247: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;

Line 244: WHERE okl_txl_rcpt_apps_tl.id = p_id

240: LAST_UPDATED_BY,
241: LAST_UPDATE_DATE,
242: LAST_UPDATE_LOGIN
243: FROM Okl_Txl_Rcpt_Apps_Tl
244: WHERE okl_txl_rcpt_apps_tl.id = p_id
245: AND okl_txl_rcpt_apps_tl.LANGUAGE = p_language;
246: l_okl_txl_rcpt_apps_tl_pk okl_txl_rcpt_apps_tl_pk_csr%ROWTYPE;
247: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
248: BEGIN

Line 245: AND okl_txl_rcpt_apps_tl.LANGUAGE = p_language;

241: LAST_UPDATE_DATE,
242: LAST_UPDATE_LOGIN
243: FROM Okl_Txl_Rcpt_Apps_Tl
244: WHERE okl_txl_rcpt_apps_tl.id = p_id
245: AND okl_txl_rcpt_apps_tl.LANGUAGE = p_language;
246: l_okl_txl_rcpt_apps_tl_pk okl_txl_rcpt_apps_tl_pk_csr%ROWTYPE;
247: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
248: BEGIN
249: x_no_data_found := TRUE;

Line 246: l_okl_txl_rcpt_apps_tl_pk okl_txl_rcpt_apps_tl_pk_csr%ROWTYPE;

242: LAST_UPDATE_LOGIN
243: FROM Okl_Txl_Rcpt_Apps_Tl
244: WHERE okl_txl_rcpt_apps_tl.id = p_id
245: AND okl_txl_rcpt_apps_tl.LANGUAGE = p_language;
246: l_okl_txl_rcpt_apps_tl_pk okl_txl_rcpt_apps_tl_pk_csr%ROWTYPE;
247: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
248: BEGIN
249: x_no_data_found := TRUE;
250: -- Get current database values

Line 247: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;

243: FROM Okl_Txl_Rcpt_Apps_Tl
244: WHERE okl_txl_rcpt_apps_tl.id = p_id
245: AND okl_txl_rcpt_apps_tl.LANGUAGE = p_language;
246: l_okl_txl_rcpt_apps_tl_pk okl_txl_rcpt_apps_tl_pk_csr%ROWTYPE;
247: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
248: BEGIN
249: x_no_data_found := TRUE;
250: -- Get current database values
251: OPEN okl_txl_rcpt_apps_tl_pk_csr (p_okl_txl_rcpt_apps_tl_rec.id,

Line 251: OPEN okl_txl_rcpt_apps_tl_pk_csr (p_okl_txl_rcpt_apps_tl_rec.id,

247: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
248: BEGIN
249: x_no_data_found := TRUE;
250: -- Get current database values
251: OPEN okl_txl_rcpt_apps_tl_pk_csr (p_okl_txl_rcpt_apps_tl_rec.id,
252: p_okl_txl_rcpt_apps_tl_rec.LANGUAGE);
253: FETCH okl_txl_rcpt_apps_tl_pk_csr INTO
254: l_okl_txl_rcpt_apps_tl_rec.ID,
255: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE,

Line 252: p_okl_txl_rcpt_apps_tl_rec.LANGUAGE);

248: BEGIN
249: x_no_data_found := TRUE;
250: -- Get current database values
251: OPEN okl_txl_rcpt_apps_tl_pk_csr (p_okl_txl_rcpt_apps_tl_rec.id,
252: p_okl_txl_rcpt_apps_tl_rec.LANGUAGE);
253: FETCH okl_txl_rcpt_apps_tl_pk_csr INTO
254: l_okl_txl_rcpt_apps_tl_rec.ID,
255: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE,
256: l_okl_txl_rcpt_apps_tl_rec.SOURCE_LANG,

Line 253: FETCH okl_txl_rcpt_apps_tl_pk_csr INTO

249: x_no_data_found := TRUE;
250: -- Get current database values
251: OPEN okl_txl_rcpt_apps_tl_pk_csr (p_okl_txl_rcpt_apps_tl_rec.id,
252: p_okl_txl_rcpt_apps_tl_rec.LANGUAGE);
253: FETCH okl_txl_rcpt_apps_tl_pk_csr INTO
254: l_okl_txl_rcpt_apps_tl_rec.ID,
255: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE,
256: l_okl_txl_rcpt_apps_tl_rec.SOURCE_LANG,
257: l_okl_txl_rcpt_apps_tl_rec.SFWT_FLAG,

Line 254: l_okl_txl_rcpt_apps_tl_rec.ID,

250: -- Get current database values
251: OPEN okl_txl_rcpt_apps_tl_pk_csr (p_okl_txl_rcpt_apps_tl_rec.id,
252: p_okl_txl_rcpt_apps_tl_rec.LANGUAGE);
253: FETCH okl_txl_rcpt_apps_tl_pk_csr INTO
254: l_okl_txl_rcpt_apps_tl_rec.ID,
255: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE,
256: l_okl_txl_rcpt_apps_tl_rec.SOURCE_LANG,
257: l_okl_txl_rcpt_apps_tl_rec.SFWT_FLAG,
258: l_okl_txl_rcpt_apps_tl_rec.DESCRIPTION,

Line 255: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE,

251: OPEN okl_txl_rcpt_apps_tl_pk_csr (p_okl_txl_rcpt_apps_tl_rec.id,
252: p_okl_txl_rcpt_apps_tl_rec.LANGUAGE);
253: FETCH okl_txl_rcpt_apps_tl_pk_csr INTO
254: l_okl_txl_rcpt_apps_tl_rec.ID,
255: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE,
256: l_okl_txl_rcpt_apps_tl_rec.SOURCE_LANG,
257: l_okl_txl_rcpt_apps_tl_rec.SFWT_FLAG,
258: l_okl_txl_rcpt_apps_tl_rec.DESCRIPTION,
259: l_okl_txl_rcpt_apps_tl_rec.CREATED_BY,

Line 256: l_okl_txl_rcpt_apps_tl_rec.SOURCE_LANG,

252: p_okl_txl_rcpt_apps_tl_rec.LANGUAGE);
253: FETCH okl_txl_rcpt_apps_tl_pk_csr INTO
254: l_okl_txl_rcpt_apps_tl_rec.ID,
255: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE,
256: l_okl_txl_rcpt_apps_tl_rec.SOURCE_LANG,
257: l_okl_txl_rcpt_apps_tl_rec.SFWT_FLAG,
258: l_okl_txl_rcpt_apps_tl_rec.DESCRIPTION,
259: l_okl_txl_rcpt_apps_tl_rec.CREATED_BY,
260: l_okl_txl_rcpt_apps_tl_rec.CREATION_DATE,

Line 257: l_okl_txl_rcpt_apps_tl_rec.SFWT_FLAG,

253: FETCH okl_txl_rcpt_apps_tl_pk_csr INTO
254: l_okl_txl_rcpt_apps_tl_rec.ID,
255: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE,
256: l_okl_txl_rcpt_apps_tl_rec.SOURCE_LANG,
257: l_okl_txl_rcpt_apps_tl_rec.SFWT_FLAG,
258: l_okl_txl_rcpt_apps_tl_rec.DESCRIPTION,
259: l_okl_txl_rcpt_apps_tl_rec.CREATED_BY,
260: l_okl_txl_rcpt_apps_tl_rec.CREATION_DATE,
261: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATED_BY,

Line 258: l_okl_txl_rcpt_apps_tl_rec.DESCRIPTION,

254: l_okl_txl_rcpt_apps_tl_rec.ID,
255: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE,
256: l_okl_txl_rcpt_apps_tl_rec.SOURCE_LANG,
257: l_okl_txl_rcpt_apps_tl_rec.SFWT_FLAG,
258: l_okl_txl_rcpt_apps_tl_rec.DESCRIPTION,
259: l_okl_txl_rcpt_apps_tl_rec.CREATED_BY,
260: l_okl_txl_rcpt_apps_tl_rec.CREATION_DATE,
261: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATED_BY,
262: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_DATE,

Line 259: l_okl_txl_rcpt_apps_tl_rec.CREATED_BY,

255: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE,
256: l_okl_txl_rcpt_apps_tl_rec.SOURCE_LANG,
257: l_okl_txl_rcpt_apps_tl_rec.SFWT_FLAG,
258: l_okl_txl_rcpt_apps_tl_rec.DESCRIPTION,
259: l_okl_txl_rcpt_apps_tl_rec.CREATED_BY,
260: l_okl_txl_rcpt_apps_tl_rec.CREATION_DATE,
261: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATED_BY,
262: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_DATE,
263: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_LOGIN;

Line 260: l_okl_txl_rcpt_apps_tl_rec.CREATION_DATE,

256: l_okl_txl_rcpt_apps_tl_rec.SOURCE_LANG,
257: l_okl_txl_rcpt_apps_tl_rec.SFWT_FLAG,
258: l_okl_txl_rcpt_apps_tl_rec.DESCRIPTION,
259: l_okl_txl_rcpt_apps_tl_rec.CREATED_BY,
260: l_okl_txl_rcpt_apps_tl_rec.CREATION_DATE,
261: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATED_BY,
262: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_DATE,
263: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_LOGIN;
264: x_no_data_found := okl_txl_rcpt_apps_tl_pk_csr%NOTFOUND;

Line 261: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATED_BY,

257: l_okl_txl_rcpt_apps_tl_rec.SFWT_FLAG,
258: l_okl_txl_rcpt_apps_tl_rec.DESCRIPTION,
259: l_okl_txl_rcpt_apps_tl_rec.CREATED_BY,
260: l_okl_txl_rcpt_apps_tl_rec.CREATION_DATE,
261: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATED_BY,
262: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_DATE,
263: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_LOGIN;
264: x_no_data_found := okl_txl_rcpt_apps_tl_pk_csr%NOTFOUND;
265: CLOSE okl_txl_rcpt_apps_tl_pk_csr;

Line 262: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_DATE,

258: l_okl_txl_rcpt_apps_tl_rec.DESCRIPTION,
259: l_okl_txl_rcpt_apps_tl_rec.CREATED_BY,
260: l_okl_txl_rcpt_apps_tl_rec.CREATION_DATE,
261: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATED_BY,
262: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_DATE,
263: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_LOGIN;
264: x_no_data_found := okl_txl_rcpt_apps_tl_pk_csr%NOTFOUND;
265: CLOSE okl_txl_rcpt_apps_tl_pk_csr;
266: RETURN(l_okl_txl_rcpt_apps_tl_rec);

Line 263: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_LOGIN;

259: l_okl_txl_rcpt_apps_tl_rec.CREATED_BY,
260: l_okl_txl_rcpt_apps_tl_rec.CREATION_DATE,
261: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATED_BY,
262: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_DATE,
263: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_LOGIN;
264: x_no_data_found := okl_txl_rcpt_apps_tl_pk_csr%NOTFOUND;
265: CLOSE okl_txl_rcpt_apps_tl_pk_csr;
266: RETURN(l_okl_txl_rcpt_apps_tl_rec);
267: END get_rec;

Line 264: x_no_data_found := okl_txl_rcpt_apps_tl_pk_csr%NOTFOUND;

260: l_okl_txl_rcpt_apps_tl_rec.CREATION_DATE,
261: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATED_BY,
262: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_DATE,
263: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_LOGIN;
264: x_no_data_found := okl_txl_rcpt_apps_tl_pk_csr%NOTFOUND;
265: CLOSE okl_txl_rcpt_apps_tl_pk_csr;
266: RETURN(l_okl_txl_rcpt_apps_tl_rec);
267: END get_rec;
268:

Line 265: CLOSE okl_txl_rcpt_apps_tl_pk_csr;

261: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATED_BY,
262: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_DATE,
263: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_LOGIN;
264: x_no_data_found := okl_txl_rcpt_apps_tl_pk_csr%NOTFOUND;
265: CLOSE okl_txl_rcpt_apps_tl_pk_csr;
266: RETURN(l_okl_txl_rcpt_apps_tl_rec);
267: END get_rec;
268:
269: FUNCTION get_rec (

Line 266: RETURN(l_okl_txl_rcpt_apps_tl_rec);

262: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_DATE,
263: l_okl_txl_rcpt_apps_tl_rec.LAST_UPDATE_LOGIN;
264: x_no_data_found := okl_txl_rcpt_apps_tl_pk_csr%NOTFOUND;
265: CLOSE okl_txl_rcpt_apps_tl_pk_csr;
266: RETURN(l_okl_txl_rcpt_apps_tl_rec);
267: END get_rec;
268:
269: FUNCTION get_rec (
270: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type

Line 270: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type

266: RETURN(l_okl_txl_rcpt_apps_tl_rec);
267: END get_rec;
268:
269: FUNCTION get_rec (
270: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type
271: ) RETURN okl_txl_rcpt_apps_tl_rec_type IS
272: l_row_notfound BOOLEAN := TRUE;
273: BEGIN
274: RETURN(get_rec(p_okl_txl_rcpt_apps_tl_rec, l_row_notfound));

Line 271: ) RETURN okl_txl_rcpt_apps_tl_rec_type IS

267: END get_rec;
268:
269: FUNCTION get_rec (
270: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type
271: ) RETURN okl_txl_rcpt_apps_tl_rec_type IS
272: l_row_notfound BOOLEAN := TRUE;
273: BEGIN
274: RETURN(get_rec(p_okl_txl_rcpt_apps_tl_rec, l_row_notfound));
275: END get_rec;

Line 274: RETURN(get_rec(p_okl_txl_rcpt_apps_tl_rec, l_row_notfound));

270: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type
271: ) RETURN okl_txl_rcpt_apps_tl_rec_type IS
272: l_row_notfound BOOLEAN := TRUE;
273: BEGIN
274: RETURN(get_rec(p_okl_txl_rcpt_apps_tl_rec, l_row_notfound));
275: END get_rec;
276: ---------------------------------------------------------------------------
277: -- FUNCTION get_rec for: OKL_TXL_RCPT_APPS_V
278: ---------------------------------------------------------------------------

Line 1407: p_to IN OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type

1403: p_to.ar_invoice_id := p_from.ar_invoice_id;
1404: END migrate;
1405: PROCEDURE migrate (
1406: p_from IN rcav_rec_type,
1407: p_to IN OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type
1408: ) IS
1409: BEGIN
1410: p_to.id := p_from.id;
1411: p_to.sfwt_flag := p_from.sfwt_flag;

Line 1420: p_from IN okl_txl_rcpt_apps_tl_rec_type,

1416: p_to.last_update_date := p_from.last_update_date;
1417: p_to.last_update_login := p_from.last_update_login;
1418: END migrate;
1419: PROCEDURE migrate (
1420: p_from IN okl_txl_rcpt_apps_tl_rec_type,
1421: p_to IN OUT NOCOPY rcav_rec_type
1422: ) IS
1423: BEGIN
1424: p_to.id := p_from.id;

Line 1453: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;

1449: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1450: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1451: l_rcav_rec rcav_rec_type := p_rcav_rec;
1452: l_rca_rec rca_rec_type;
1453: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
1454: BEGIN
1455: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1456: G_PKG_NAME,
1457: p_init_msg_list,

Line 1784: -- insert_row for:OKL_TXL_RCPT_APPS_TL --

1780: '_PVT'
1781: );
1782: END insert_row;
1783: -----------------------------------------
1784: -- insert_row for:OKL_TXL_RCPT_APPS_TL --
1785: -----------------------------------------
1786: PROCEDURE insert_row(
1787: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1788: x_return_status OUT NOCOPY VARCHAR2,

Line 1791: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,

1787: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1788: x_return_status OUT NOCOPY VARCHAR2,
1789: x_msg_count OUT NOCOPY NUMBER,
1790: x_msg_data OUT NOCOPY VARCHAR2,
1791: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,
1792: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type) IS
1793:
1794: l_api_version CONSTANT NUMBER := 1;
1795: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1792: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type) IS

1788: x_return_status OUT NOCOPY VARCHAR2,
1789: x_msg_count OUT NOCOPY NUMBER,
1790: x_msg_data OUT NOCOPY VARCHAR2,
1791: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,
1792: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type) IS
1793:
1794: l_api_version CONSTANT NUMBER := 1;
1795: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1796: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 1797: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type := p_okl_txl_rcpt_apps_tl_rec;

1793:
1794: l_api_version CONSTANT NUMBER := 1;
1795: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1796: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1797: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type := p_okl_txl_rcpt_apps_tl_rec;
1798: ldefokltxlrcptappstlrec okl_txl_rcpt_apps_tl_rec_type;
1799: CURSOR get_languages IS
1800: SELECT *
1801: FROM FND_LANGUAGES

Line 1798: ldefokltxlrcptappstlrec okl_txl_rcpt_apps_tl_rec_type;

1794: l_api_version CONSTANT NUMBER := 1;
1795: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1796: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1797: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type := p_okl_txl_rcpt_apps_tl_rec;
1798: ldefokltxlrcptappstlrec okl_txl_rcpt_apps_tl_rec_type;
1799: CURSOR get_languages IS
1800: SELECT *
1801: FROM FND_LANGUAGES
1802: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1804: -- Set_Attributes for:OKL_TXL_RCPT_APPS_TL --

1800: SELECT *
1801: FROM FND_LANGUAGES
1802: WHERE INSTALLED_FLAG IN ('I', 'B');
1803: ---------------------------------------------
1804: -- Set_Attributes for:OKL_TXL_RCPT_APPS_TL --
1805: ---------------------------------------------
1806: FUNCTION Set_Attributes (
1807: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,
1808: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type

Line 1807: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,

1803: ---------------------------------------------
1804: -- Set_Attributes for:OKL_TXL_RCPT_APPS_TL --
1805: ---------------------------------------------
1806: FUNCTION Set_Attributes (
1807: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,
1808: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type
1809: ) RETURN VARCHAR2 IS
1810: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1811: BEGIN

Line 1808: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type

1804: -- Set_Attributes for:OKL_TXL_RCPT_APPS_TL --
1805: ---------------------------------------------
1806: FUNCTION Set_Attributes (
1807: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,
1808: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type
1809: ) RETURN VARCHAR2 IS
1810: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1811: BEGIN
1812: x_okl_txl_rcpt_apps_tl_rec := p_okl_txl_rcpt_apps_tl_rec;

Line 1812: x_okl_txl_rcpt_apps_tl_rec := p_okl_txl_rcpt_apps_tl_rec;

1808: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type
1809: ) RETURN VARCHAR2 IS
1810: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1811: BEGIN
1812: x_okl_txl_rcpt_apps_tl_rec := p_okl_txl_rcpt_apps_tl_rec;
1813: x_okl_txl_rcpt_apps_tl_rec.LANGUAGE := USERENV('LANG');
1814: x_okl_txl_rcpt_apps_tl_rec.SOURCE_LANG := USERENV('LANG');
1815: RETURN(l_return_status);
1816: END Set_Attributes;

Line 1813: x_okl_txl_rcpt_apps_tl_rec.LANGUAGE := USERENV('LANG');

1809: ) RETURN VARCHAR2 IS
1810: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1811: BEGIN
1812: x_okl_txl_rcpt_apps_tl_rec := p_okl_txl_rcpt_apps_tl_rec;
1813: x_okl_txl_rcpt_apps_tl_rec.LANGUAGE := USERENV('LANG');
1814: x_okl_txl_rcpt_apps_tl_rec.SOURCE_LANG := USERENV('LANG');
1815: RETURN(l_return_status);
1816: END Set_Attributes;
1817: BEGIN

Line 1814: x_okl_txl_rcpt_apps_tl_rec.SOURCE_LANG := USERENV('LANG');

1810: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1811: BEGIN
1812: x_okl_txl_rcpt_apps_tl_rec := p_okl_txl_rcpt_apps_tl_rec;
1813: x_okl_txl_rcpt_apps_tl_rec.LANGUAGE := USERENV('LANG');
1814: x_okl_txl_rcpt_apps_tl_rec.SOURCE_LANG := USERENV('LANG');
1815: RETURN(l_return_status);
1816: END Set_Attributes;
1817: BEGIN
1818: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 1829: p_okl_txl_rcpt_apps_tl_rec, -- IN

1825: RAISE Okl_Api.G_EXCEPTION_ERROR;
1826: END IF;
1827: --- Setting item attributes
1828: l_return_status := Set_Attributes(
1829: p_okl_txl_rcpt_apps_tl_rec, -- IN
1830: l_okl_txl_rcpt_apps_tl_rec); -- OUT
1831: --- If any errors happen abort API
1832: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1833: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1830: l_okl_txl_rcpt_apps_tl_rec); -- OUT

1826: END IF;
1827: --- Setting item attributes
1828: l_return_status := Set_Attributes(
1829: p_okl_txl_rcpt_apps_tl_rec, -- IN
1830: l_okl_txl_rcpt_apps_tl_rec); -- OUT
1831: --- If any errors happen abort API
1832: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1833: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1834: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 1838: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE := l_lang_rec.language_code;

1834: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1835: RAISE Okl_Api.G_EXCEPTION_ERROR;
1836: END IF;
1837: FOR l_lang_rec IN get_languages LOOP
1838: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE := l_lang_rec.language_code;
1839: INSERT INTO OKL_TXL_RCPT_APPS_TL(
1840: id,
1841: LANGUAGE,
1842: source_lang,

Line 1839: INSERT INTO OKL_TXL_RCPT_APPS_TL(

1835: RAISE Okl_Api.G_EXCEPTION_ERROR;
1836: END IF;
1837: FOR l_lang_rec IN get_languages LOOP
1838: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE := l_lang_rec.language_code;
1839: INSERT INTO OKL_TXL_RCPT_APPS_TL(
1840: id,
1841: LANGUAGE,
1842: source_lang,
1843: sfwt_flag,

Line 1851: l_okl_txl_rcpt_apps_tl_rec.id,

1847: last_updated_by,
1848: last_update_date,
1849: last_update_login)
1850: VALUES (
1851: l_okl_txl_rcpt_apps_tl_rec.id,
1852: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE,
1853: l_okl_txl_rcpt_apps_tl_rec.source_lang,
1854: l_okl_txl_rcpt_apps_tl_rec.sfwt_flag,
1855: l_okl_txl_rcpt_apps_tl_rec.description,

Line 1852: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE,

1848: last_update_date,
1849: last_update_login)
1850: VALUES (
1851: l_okl_txl_rcpt_apps_tl_rec.id,
1852: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE,
1853: l_okl_txl_rcpt_apps_tl_rec.source_lang,
1854: l_okl_txl_rcpt_apps_tl_rec.sfwt_flag,
1855: l_okl_txl_rcpt_apps_tl_rec.description,
1856: l_okl_txl_rcpt_apps_tl_rec.created_by,

Line 1853: l_okl_txl_rcpt_apps_tl_rec.source_lang,

1849: last_update_login)
1850: VALUES (
1851: l_okl_txl_rcpt_apps_tl_rec.id,
1852: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE,
1853: l_okl_txl_rcpt_apps_tl_rec.source_lang,
1854: l_okl_txl_rcpt_apps_tl_rec.sfwt_flag,
1855: l_okl_txl_rcpt_apps_tl_rec.description,
1856: l_okl_txl_rcpt_apps_tl_rec.created_by,
1857: l_okl_txl_rcpt_apps_tl_rec.creation_date,

Line 1854: l_okl_txl_rcpt_apps_tl_rec.sfwt_flag,

1850: VALUES (
1851: l_okl_txl_rcpt_apps_tl_rec.id,
1852: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE,
1853: l_okl_txl_rcpt_apps_tl_rec.source_lang,
1854: l_okl_txl_rcpt_apps_tl_rec.sfwt_flag,
1855: l_okl_txl_rcpt_apps_tl_rec.description,
1856: l_okl_txl_rcpt_apps_tl_rec.created_by,
1857: l_okl_txl_rcpt_apps_tl_rec.creation_date,
1858: l_okl_txl_rcpt_apps_tl_rec.last_updated_by,

Line 1855: l_okl_txl_rcpt_apps_tl_rec.description,

1851: l_okl_txl_rcpt_apps_tl_rec.id,
1852: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE,
1853: l_okl_txl_rcpt_apps_tl_rec.source_lang,
1854: l_okl_txl_rcpt_apps_tl_rec.sfwt_flag,
1855: l_okl_txl_rcpt_apps_tl_rec.description,
1856: l_okl_txl_rcpt_apps_tl_rec.created_by,
1857: l_okl_txl_rcpt_apps_tl_rec.creation_date,
1858: l_okl_txl_rcpt_apps_tl_rec.last_updated_by,
1859: l_okl_txl_rcpt_apps_tl_rec.last_update_date,

Line 1856: l_okl_txl_rcpt_apps_tl_rec.created_by,

1852: l_okl_txl_rcpt_apps_tl_rec.LANGUAGE,
1853: l_okl_txl_rcpt_apps_tl_rec.source_lang,
1854: l_okl_txl_rcpt_apps_tl_rec.sfwt_flag,
1855: l_okl_txl_rcpt_apps_tl_rec.description,
1856: l_okl_txl_rcpt_apps_tl_rec.created_by,
1857: l_okl_txl_rcpt_apps_tl_rec.creation_date,
1858: l_okl_txl_rcpt_apps_tl_rec.last_updated_by,
1859: l_okl_txl_rcpt_apps_tl_rec.last_update_date,
1860: l_okl_txl_rcpt_apps_tl_rec.last_update_login);

Line 1857: l_okl_txl_rcpt_apps_tl_rec.creation_date,

1853: l_okl_txl_rcpt_apps_tl_rec.source_lang,
1854: l_okl_txl_rcpt_apps_tl_rec.sfwt_flag,
1855: l_okl_txl_rcpt_apps_tl_rec.description,
1856: l_okl_txl_rcpt_apps_tl_rec.created_by,
1857: l_okl_txl_rcpt_apps_tl_rec.creation_date,
1858: l_okl_txl_rcpt_apps_tl_rec.last_updated_by,
1859: l_okl_txl_rcpt_apps_tl_rec.last_update_date,
1860: l_okl_txl_rcpt_apps_tl_rec.last_update_login);
1861: END LOOP;

Line 1858: l_okl_txl_rcpt_apps_tl_rec.last_updated_by,

1854: l_okl_txl_rcpt_apps_tl_rec.sfwt_flag,
1855: l_okl_txl_rcpt_apps_tl_rec.description,
1856: l_okl_txl_rcpt_apps_tl_rec.created_by,
1857: l_okl_txl_rcpt_apps_tl_rec.creation_date,
1858: l_okl_txl_rcpt_apps_tl_rec.last_updated_by,
1859: l_okl_txl_rcpt_apps_tl_rec.last_update_date,
1860: l_okl_txl_rcpt_apps_tl_rec.last_update_login);
1861: END LOOP;
1862: -- Set OUT values

Line 1859: l_okl_txl_rcpt_apps_tl_rec.last_update_date,

1855: l_okl_txl_rcpt_apps_tl_rec.description,
1856: l_okl_txl_rcpt_apps_tl_rec.created_by,
1857: l_okl_txl_rcpt_apps_tl_rec.creation_date,
1858: l_okl_txl_rcpt_apps_tl_rec.last_updated_by,
1859: l_okl_txl_rcpt_apps_tl_rec.last_update_date,
1860: l_okl_txl_rcpt_apps_tl_rec.last_update_login);
1861: END LOOP;
1862: -- Set OUT values
1863: x_okl_txl_rcpt_apps_tl_rec := l_okl_txl_rcpt_apps_tl_rec;

Line 1860: l_okl_txl_rcpt_apps_tl_rec.last_update_login);

1856: l_okl_txl_rcpt_apps_tl_rec.created_by,
1857: l_okl_txl_rcpt_apps_tl_rec.creation_date,
1858: l_okl_txl_rcpt_apps_tl_rec.last_updated_by,
1859: l_okl_txl_rcpt_apps_tl_rec.last_update_date,
1860: l_okl_txl_rcpt_apps_tl_rec.last_update_login);
1861: END LOOP;
1862: -- Set OUT values
1863: x_okl_txl_rcpt_apps_tl_rec := l_okl_txl_rcpt_apps_tl_rec;
1864: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1863: x_okl_txl_rcpt_apps_tl_rec := l_okl_txl_rcpt_apps_tl_rec;

1859: l_okl_txl_rcpt_apps_tl_rec.last_update_date,
1860: l_okl_txl_rcpt_apps_tl_rec.last_update_login);
1861: END LOOP;
1862: -- Set OUT values
1863: x_okl_txl_rcpt_apps_tl_rec := l_okl_txl_rcpt_apps_tl_rec;
1864: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1865: EXCEPTION
1866: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1867: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 1916: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;

1912: l_rcav_rec rcav_rec_type;
1913: l_def_rcav_rec rcav_rec_type;
1914: l_rca_rec rca_rec_type;
1915: lx_rca_rec rca_rec_type;
1916: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
1917: lx_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
1918: -------------------------------
1919: -- FUNCTION fill_who_columns --
1920: -------------------------------

Line 1917: lx_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;

1913: l_def_rcav_rec rcav_rec_type;
1914: l_rca_rec rca_rec_type;
1915: lx_rca_rec rca_rec_type;
1916: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
1917: lx_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
1918: -------------------------------
1919: -- FUNCTION fill_who_columns --
1920: -------------------------------
1921: FUNCTION fill_who_columns (

Line 1996: migrate(l_def_rcav_rec, l_okl_txl_rcpt_apps_tl_rec);

1992: --------------------------------------
1993: -- Move VIEW record to "Child" records
1994: --------------------------------------
1995: migrate(l_def_rcav_rec, l_rca_rec);
1996: migrate(l_def_rcav_rec, l_okl_txl_rcpt_apps_tl_rec);
1997: --------------------------------------------
1998: -- Call the INSERT_ROW for each child record
1999: --------------------------------------------
2000: insert_row(

Line 2019: l_okl_txl_rcpt_apps_tl_rec,

2015: p_init_msg_list,
2016: x_return_status,
2017: x_msg_count,
2018: x_msg_data,
2019: l_okl_txl_rcpt_apps_tl_rec,
2020: lx_okl_txl_rcpt_apps_tl_rec
2021: );
2022: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2023: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2020: lx_okl_txl_rcpt_apps_tl_rec

2016: x_return_status,
2017: x_msg_count,
2018: x_msg_data,
2019: l_okl_txl_rcpt_apps_tl_rec,
2020: lx_okl_txl_rcpt_apps_tl_rec
2021: );
2022: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2023: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2024: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2027: migrate(lx_okl_txl_rcpt_apps_tl_rec, l_def_rcav_rec);

2023: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2024: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2025: RAISE Okl_Api.G_EXCEPTION_ERROR;
2026: END IF;
2027: migrate(lx_okl_txl_rcpt_apps_tl_rec, l_def_rcav_rec);
2028: -- Set OUT values
2029: x_rcav_rec := l_def_rcav_rec;
2030: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2031: EXCEPTION

Line 2260: -- lock_row for:OKL_TXL_RCPT_APPS_TL --

2256: '_PVT'
2257: );
2258: END lock_row;
2259: ---------------------------------------
2260: -- lock_row for:OKL_TXL_RCPT_APPS_TL --
2261: ---------------------------------------
2262: PROCEDURE lock_row(
2263: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2264: x_return_status OUT NOCOPY VARCHAR2,

Line 2267: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type) IS

2263: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2264: x_return_status OUT NOCOPY VARCHAR2,
2265: x_msg_count OUT NOCOPY NUMBER,
2266: x_msg_data OUT NOCOPY VARCHAR2,
2267: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type) IS
2268:
2269: E_Resource_Busy EXCEPTION;
2270: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2271: CURSOR lock_csr (p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type) IS

Line 2271: CURSOR lock_csr (p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type) IS

2267: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type) IS
2268:
2269: E_Resource_Busy EXCEPTION;
2270: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2271: CURSOR lock_csr (p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type) IS
2272: SELECT *
2273: FROM OKL_TXL_RCPT_APPS_TL
2274: WHERE ID = p_okl_txl_rcpt_apps_tl_rec.id
2275: FOR UPDATE NOWAIT;

Line 2273: FROM OKL_TXL_RCPT_APPS_TL

2269: E_Resource_Busy EXCEPTION;
2270: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2271: CURSOR lock_csr (p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type) IS
2272: SELECT *
2273: FROM OKL_TXL_RCPT_APPS_TL
2274: WHERE ID = p_okl_txl_rcpt_apps_tl_rec.id
2275: FOR UPDATE NOWAIT;
2276:
2277: l_api_version CONSTANT NUMBER := 1;

Line 2274: WHERE ID = p_okl_txl_rcpt_apps_tl_rec.id

2270: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2271: CURSOR lock_csr (p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type) IS
2272: SELECT *
2273: FROM OKL_TXL_RCPT_APPS_TL
2274: WHERE ID = p_okl_txl_rcpt_apps_tl_rec.id
2275: FOR UPDATE NOWAIT;
2276:
2277: l_api_version CONSTANT NUMBER := 1;
2278: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2294: OPEN lock_csr(p_okl_txl_rcpt_apps_tl_rec);

2290: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2291: RAISE Okl_Api.G_EXCEPTION_ERROR;
2292: END IF;
2293: BEGIN
2294: OPEN lock_csr(p_okl_txl_rcpt_apps_tl_rec);
2295: FETCH lock_csr INTO l_lock_var;
2296: l_row_notfound := lock_csr%NOTFOUND;
2297: CLOSE lock_csr;
2298: EXCEPTION

Line 2359: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;

2355: l_api_version CONSTANT NUMBER := 1;
2356: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2357: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2358: l_rca_rec rca_rec_type;
2359: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
2360: BEGIN
2361: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
2362: G_PKG_NAME,
2363: p_init_msg_list,

Line 2377: migrate(p_rcav_rec, l_okl_txl_rcpt_apps_tl_rec);

2373: --------------------------------------
2374: -- Move VIEW record to "Child" records
2375: --------------------------------------
2376: migrate(p_rcav_rec, l_rca_rec);
2377: migrate(p_rcav_rec, l_okl_txl_rcpt_apps_tl_rec);
2378: --------------------------------------------
2379: -- Call the LOCK_ROW for each child record
2380: --------------------------------------------
2381: lock_row(

Line 2398: l_okl_txl_rcpt_apps_tl_rec

2394: p_init_msg_list,
2395: x_return_status,
2396: x_msg_count,
2397: x_msg_data,
2398: l_okl_txl_rcpt_apps_tl_rec
2399: );
2400: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2401: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2402: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2846: -- update_row for:OKL_TXL_RCPT_APPS_TL --

2842: '_PVT'
2843: );
2844: END update_row;
2845: -----------------------------------------
2846: -- update_row for:OKL_TXL_RCPT_APPS_TL --
2847: -----------------------------------------
2848: PROCEDURE update_row(
2849: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2850: x_return_status OUT NOCOPY VARCHAR2,

Line 2853: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,

2849: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2850: x_return_status OUT NOCOPY VARCHAR2,
2851: x_msg_count OUT NOCOPY NUMBER,
2852: x_msg_data OUT NOCOPY VARCHAR2,
2853: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,
2854: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type) IS
2855:
2856: l_api_version CONSTANT NUMBER := 1;
2857: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2854: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type) IS

2850: x_return_status OUT NOCOPY VARCHAR2,
2851: x_msg_count OUT NOCOPY NUMBER,
2852: x_msg_data OUT NOCOPY VARCHAR2,
2853: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,
2854: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type) IS
2855:
2856: l_api_version CONSTANT NUMBER := 1;
2857: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2858: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2859: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type := p_okl_txl_rcpt_apps_tl_rec;

2855:
2856: l_api_version CONSTANT NUMBER := 1;
2857: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2858: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2859: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type := p_okl_txl_rcpt_apps_tl_rec;
2860: ldefokltxlrcptappstlrec okl_txl_rcpt_apps_tl_rec_type;
2861: l_row_notfound BOOLEAN := TRUE;
2862: ----------------------------------
2863: -- FUNCTION populate_new_record --

Line 2860: ldefokltxlrcptappstlrec okl_txl_rcpt_apps_tl_rec_type;

2856: l_api_version CONSTANT NUMBER := 1;
2857: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2858: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2859: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type := p_okl_txl_rcpt_apps_tl_rec;
2860: ldefokltxlrcptappstlrec okl_txl_rcpt_apps_tl_rec_type;
2861: l_row_notfound BOOLEAN := TRUE;
2862: ----------------------------------
2863: -- FUNCTION populate_new_record --
2864: ----------------------------------

Line 2867: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,

2863: -- FUNCTION populate_new_record --
2864: ----------------------------------
2865:
2866: FUNCTION populate_new_record (
2867: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,
2868: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type
2869: ) RETURN VARCHAR2 IS
2870: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
2871: l_row_notfound BOOLEAN := TRUE;

Line 2868: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type

2864: ----------------------------------
2865:
2866: FUNCTION populate_new_record (
2867: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,
2868: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type
2869: ) RETURN VARCHAR2 IS
2870: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
2871: l_row_notfound BOOLEAN := TRUE;
2872: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2870: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;

2866: FUNCTION populate_new_record (
2867: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,
2868: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type
2869: ) RETURN VARCHAR2 IS
2870: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
2871: l_row_notfound BOOLEAN := TRUE;
2872: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2873: BEGIN
2874: x_okl_txl_rcpt_apps_tl_rec := p_okl_txl_rcpt_apps_tl_rec;

Line 2874: x_okl_txl_rcpt_apps_tl_rec := p_okl_txl_rcpt_apps_tl_rec;

2870: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
2871: l_row_notfound BOOLEAN := TRUE;
2872: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2873: BEGIN
2874: x_okl_txl_rcpt_apps_tl_rec := p_okl_txl_rcpt_apps_tl_rec;
2875: -- Get current database values
2876: l_okl_txl_rcpt_apps_tl_rec := get_rec(p_okl_txl_rcpt_apps_tl_rec, l_row_notfound);
2877: IF (l_row_notfound) THEN
2878: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 2876: l_okl_txl_rcpt_apps_tl_rec := get_rec(p_okl_txl_rcpt_apps_tl_rec, l_row_notfound);

2872: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2873: BEGIN
2874: x_okl_txl_rcpt_apps_tl_rec := p_okl_txl_rcpt_apps_tl_rec;
2875: -- Get current database values
2876: l_okl_txl_rcpt_apps_tl_rec := get_rec(p_okl_txl_rcpt_apps_tl_rec, l_row_notfound);
2877: IF (l_row_notfound) THEN
2878: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2879: END IF;
2880: IF (x_okl_txl_rcpt_apps_tl_rec.id = Okl_Api.G_MISS_NUM)

Line 2880: IF (x_okl_txl_rcpt_apps_tl_rec.id = Okl_Api.G_MISS_NUM)

2876: l_okl_txl_rcpt_apps_tl_rec := get_rec(p_okl_txl_rcpt_apps_tl_rec, l_row_notfound);
2877: IF (l_row_notfound) THEN
2878: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2879: END IF;
2880: IF (x_okl_txl_rcpt_apps_tl_rec.id = Okl_Api.G_MISS_NUM)
2881: THEN
2882: x_okl_txl_rcpt_apps_tl_rec.id := l_okl_txl_rcpt_apps_tl_rec.id;
2883: END IF;
2884: IF (x_okl_txl_rcpt_apps_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)

Line 2882: x_okl_txl_rcpt_apps_tl_rec.id := l_okl_txl_rcpt_apps_tl_rec.id;

2878: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2879: END IF;
2880: IF (x_okl_txl_rcpt_apps_tl_rec.id = Okl_Api.G_MISS_NUM)
2881: THEN
2882: x_okl_txl_rcpt_apps_tl_rec.id := l_okl_txl_rcpt_apps_tl_rec.id;
2883: END IF;
2884: IF (x_okl_txl_rcpt_apps_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2885: THEN
2886: x_okl_txl_rcpt_apps_tl_rec.LANGUAGE := l_okl_txl_rcpt_apps_tl_rec.LANGUAGE;

Line 2884: IF (x_okl_txl_rcpt_apps_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)

2880: IF (x_okl_txl_rcpt_apps_tl_rec.id = Okl_Api.G_MISS_NUM)
2881: THEN
2882: x_okl_txl_rcpt_apps_tl_rec.id := l_okl_txl_rcpt_apps_tl_rec.id;
2883: END IF;
2884: IF (x_okl_txl_rcpt_apps_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2885: THEN
2886: x_okl_txl_rcpt_apps_tl_rec.LANGUAGE := l_okl_txl_rcpt_apps_tl_rec.LANGUAGE;
2887: END IF;
2888: IF (x_okl_txl_rcpt_apps_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)

Line 2886: x_okl_txl_rcpt_apps_tl_rec.LANGUAGE := l_okl_txl_rcpt_apps_tl_rec.LANGUAGE;

2882: x_okl_txl_rcpt_apps_tl_rec.id := l_okl_txl_rcpt_apps_tl_rec.id;
2883: END IF;
2884: IF (x_okl_txl_rcpt_apps_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2885: THEN
2886: x_okl_txl_rcpt_apps_tl_rec.LANGUAGE := l_okl_txl_rcpt_apps_tl_rec.LANGUAGE;
2887: END IF;
2888: IF (x_okl_txl_rcpt_apps_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2889: THEN
2890: x_okl_txl_rcpt_apps_tl_rec.source_lang := l_okl_txl_rcpt_apps_tl_rec.source_lang;

Line 2888: IF (x_okl_txl_rcpt_apps_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)

2884: IF (x_okl_txl_rcpt_apps_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2885: THEN
2886: x_okl_txl_rcpt_apps_tl_rec.LANGUAGE := l_okl_txl_rcpt_apps_tl_rec.LANGUAGE;
2887: END IF;
2888: IF (x_okl_txl_rcpt_apps_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2889: THEN
2890: x_okl_txl_rcpt_apps_tl_rec.source_lang := l_okl_txl_rcpt_apps_tl_rec.source_lang;
2891: END IF;
2892: IF (x_okl_txl_rcpt_apps_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)

Line 2890: x_okl_txl_rcpt_apps_tl_rec.source_lang := l_okl_txl_rcpt_apps_tl_rec.source_lang;

2886: x_okl_txl_rcpt_apps_tl_rec.LANGUAGE := l_okl_txl_rcpt_apps_tl_rec.LANGUAGE;
2887: END IF;
2888: IF (x_okl_txl_rcpt_apps_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2889: THEN
2890: x_okl_txl_rcpt_apps_tl_rec.source_lang := l_okl_txl_rcpt_apps_tl_rec.source_lang;
2891: END IF;
2892: IF (x_okl_txl_rcpt_apps_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2893: THEN
2894: x_okl_txl_rcpt_apps_tl_rec.sfwt_flag := l_okl_txl_rcpt_apps_tl_rec.sfwt_flag;

Line 2892: IF (x_okl_txl_rcpt_apps_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)

2888: IF (x_okl_txl_rcpt_apps_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2889: THEN
2890: x_okl_txl_rcpt_apps_tl_rec.source_lang := l_okl_txl_rcpt_apps_tl_rec.source_lang;
2891: END IF;
2892: IF (x_okl_txl_rcpt_apps_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2893: THEN
2894: x_okl_txl_rcpt_apps_tl_rec.sfwt_flag := l_okl_txl_rcpt_apps_tl_rec.sfwt_flag;
2895: END IF;
2896: IF (x_okl_txl_rcpt_apps_tl_rec.description = Okl_Api.G_MISS_CHAR)

Line 2894: x_okl_txl_rcpt_apps_tl_rec.sfwt_flag := l_okl_txl_rcpt_apps_tl_rec.sfwt_flag;

2890: x_okl_txl_rcpt_apps_tl_rec.source_lang := l_okl_txl_rcpt_apps_tl_rec.source_lang;
2891: END IF;
2892: IF (x_okl_txl_rcpt_apps_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2893: THEN
2894: x_okl_txl_rcpt_apps_tl_rec.sfwt_flag := l_okl_txl_rcpt_apps_tl_rec.sfwt_flag;
2895: END IF;
2896: IF (x_okl_txl_rcpt_apps_tl_rec.description = Okl_Api.G_MISS_CHAR)
2897: THEN
2898: x_okl_txl_rcpt_apps_tl_rec.description := l_okl_txl_rcpt_apps_tl_rec.description;

Line 2896: IF (x_okl_txl_rcpt_apps_tl_rec.description = Okl_Api.G_MISS_CHAR)

2892: IF (x_okl_txl_rcpt_apps_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2893: THEN
2894: x_okl_txl_rcpt_apps_tl_rec.sfwt_flag := l_okl_txl_rcpt_apps_tl_rec.sfwt_flag;
2895: END IF;
2896: IF (x_okl_txl_rcpt_apps_tl_rec.description = Okl_Api.G_MISS_CHAR)
2897: THEN
2898: x_okl_txl_rcpt_apps_tl_rec.description := l_okl_txl_rcpt_apps_tl_rec.description;
2899: END IF;
2900: IF (x_okl_txl_rcpt_apps_tl_rec.created_by = Okl_Api.G_MISS_NUM)

Line 2898: x_okl_txl_rcpt_apps_tl_rec.description := l_okl_txl_rcpt_apps_tl_rec.description;

2894: x_okl_txl_rcpt_apps_tl_rec.sfwt_flag := l_okl_txl_rcpt_apps_tl_rec.sfwt_flag;
2895: END IF;
2896: IF (x_okl_txl_rcpt_apps_tl_rec.description = Okl_Api.G_MISS_CHAR)
2897: THEN
2898: x_okl_txl_rcpt_apps_tl_rec.description := l_okl_txl_rcpt_apps_tl_rec.description;
2899: END IF;
2900: IF (x_okl_txl_rcpt_apps_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2901: THEN
2902: x_okl_txl_rcpt_apps_tl_rec.created_by := l_okl_txl_rcpt_apps_tl_rec.created_by;

Line 2900: IF (x_okl_txl_rcpt_apps_tl_rec.created_by = Okl_Api.G_MISS_NUM)

2896: IF (x_okl_txl_rcpt_apps_tl_rec.description = Okl_Api.G_MISS_CHAR)
2897: THEN
2898: x_okl_txl_rcpt_apps_tl_rec.description := l_okl_txl_rcpt_apps_tl_rec.description;
2899: END IF;
2900: IF (x_okl_txl_rcpt_apps_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2901: THEN
2902: x_okl_txl_rcpt_apps_tl_rec.created_by := l_okl_txl_rcpt_apps_tl_rec.created_by;
2903: END IF;
2904: IF (x_okl_txl_rcpt_apps_tl_rec.creation_date = Okl_Api.G_MISS_DATE)

Line 2902: x_okl_txl_rcpt_apps_tl_rec.created_by := l_okl_txl_rcpt_apps_tl_rec.created_by;

2898: x_okl_txl_rcpt_apps_tl_rec.description := l_okl_txl_rcpt_apps_tl_rec.description;
2899: END IF;
2900: IF (x_okl_txl_rcpt_apps_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2901: THEN
2902: x_okl_txl_rcpt_apps_tl_rec.created_by := l_okl_txl_rcpt_apps_tl_rec.created_by;
2903: END IF;
2904: IF (x_okl_txl_rcpt_apps_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2905: THEN
2906: x_okl_txl_rcpt_apps_tl_rec.creation_date := l_okl_txl_rcpt_apps_tl_rec.creation_date;

Line 2904: IF (x_okl_txl_rcpt_apps_tl_rec.creation_date = Okl_Api.G_MISS_DATE)

2900: IF (x_okl_txl_rcpt_apps_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2901: THEN
2902: x_okl_txl_rcpt_apps_tl_rec.created_by := l_okl_txl_rcpt_apps_tl_rec.created_by;
2903: END IF;
2904: IF (x_okl_txl_rcpt_apps_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2905: THEN
2906: x_okl_txl_rcpt_apps_tl_rec.creation_date := l_okl_txl_rcpt_apps_tl_rec.creation_date;
2907: END IF;
2908: IF (x_okl_txl_rcpt_apps_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)

Line 2906: x_okl_txl_rcpt_apps_tl_rec.creation_date := l_okl_txl_rcpt_apps_tl_rec.creation_date;

2902: x_okl_txl_rcpt_apps_tl_rec.created_by := l_okl_txl_rcpt_apps_tl_rec.created_by;
2903: END IF;
2904: IF (x_okl_txl_rcpt_apps_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2905: THEN
2906: x_okl_txl_rcpt_apps_tl_rec.creation_date := l_okl_txl_rcpt_apps_tl_rec.creation_date;
2907: END IF;
2908: IF (x_okl_txl_rcpt_apps_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2909: THEN
2910: x_okl_txl_rcpt_apps_tl_rec.last_updated_by := l_okl_txl_rcpt_apps_tl_rec.last_updated_by;

Line 2908: IF (x_okl_txl_rcpt_apps_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)

2904: IF (x_okl_txl_rcpt_apps_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2905: THEN
2906: x_okl_txl_rcpt_apps_tl_rec.creation_date := l_okl_txl_rcpt_apps_tl_rec.creation_date;
2907: END IF;
2908: IF (x_okl_txl_rcpt_apps_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2909: THEN
2910: x_okl_txl_rcpt_apps_tl_rec.last_updated_by := l_okl_txl_rcpt_apps_tl_rec.last_updated_by;
2911: END IF;
2912: IF (x_okl_txl_rcpt_apps_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)

Line 2910: x_okl_txl_rcpt_apps_tl_rec.last_updated_by := l_okl_txl_rcpt_apps_tl_rec.last_updated_by;

2906: x_okl_txl_rcpt_apps_tl_rec.creation_date := l_okl_txl_rcpt_apps_tl_rec.creation_date;
2907: END IF;
2908: IF (x_okl_txl_rcpt_apps_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2909: THEN
2910: x_okl_txl_rcpt_apps_tl_rec.last_updated_by := l_okl_txl_rcpt_apps_tl_rec.last_updated_by;
2911: END IF;
2912: IF (x_okl_txl_rcpt_apps_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2913: THEN
2914: x_okl_txl_rcpt_apps_tl_rec.last_update_date := l_okl_txl_rcpt_apps_tl_rec.last_update_date;

Line 2912: IF (x_okl_txl_rcpt_apps_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)

2908: IF (x_okl_txl_rcpt_apps_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2909: THEN
2910: x_okl_txl_rcpt_apps_tl_rec.last_updated_by := l_okl_txl_rcpt_apps_tl_rec.last_updated_by;
2911: END IF;
2912: IF (x_okl_txl_rcpt_apps_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2913: THEN
2914: x_okl_txl_rcpt_apps_tl_rec.last_update_date := l_okl_txl_rcpt_apps_tl_rec.last_update_date;
2915: END IF;
2916: IF (x_okl_txl_rcpt_apps_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)

Line 2914: x_okl_txl_rcpt_apps_tl_rec.last_update_date := l_okl_txl_rcpt_apps_tl_rec.last_update_date;

2910: x_okl_txl_rcpt_apps_tl_rec.last_updated_by := l_okl_txl_rcpt_apps_tl_rec.last_updated_by;
2911: END IF;
2912: IF (x_okl_txl_rcpt_apps_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2913: THEN
2914: x_okl_txl_rcpt_apps_tl_rec.last_update_date := l_okl_txl_rcpt_apps_tl_rec.last_update_date;
2915: END IF;
2916: IF (x_okl_txl_rcpt_apps_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2917: THEN
2918: x_okl_txl_rcpt_apps_tl_rec.last_update_login := l_okl_txl_rcpt_apps_tl_rec.last_update_login;

Line 2916: IF (x_okl_txl_rcpt_apps_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)

2912: IF (x_okl_txl_rcpt_apps_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2913: THEN
2914: x_okl_txl_rcpt_apps_tl_rec.last_update_date := l_okl_txl_rcpt_apps_tl_rec.last_update_date;
2915: END IF;
2916: IF (x_okl_txl_rcpt_apps_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2917: THEN
2918: x_okl_txl_rcpt_apps_tl_rec.last_update_login := l_okl_txl_rcpt_apps_tl_rec.last_update_login;
2919: END IF;
2920: RETURN(l_return_status);

Line 2918: x_okl_txl_rcpt_apps_tl_rec.last_update_login := l_okl_txl_rcpt_apps_tl_rec.last_update_login;

2914: x_okl_txl_rcpt_apps_tl_rec.last_update_date := l_okl_txl_rcpt_apps_tl_rec.last_update_date;
2915: END IF;
2916: IF (x_okl_txl_rcpt_apps_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2917: THEN
2918: x_okl_txl_rcpt_apps_tl_rec.last_update_login := l_okl_txl_rcpt_apps_tl_rec.last_update_login;
2919: END IF;
2920: RETURN(l_return_status);
2921: END populate_new_record;
2922: ---------------------------------------------

Line 2923: -- Set_Attributes for:OKL_TXL_RCPT_APPS_TL --

2919: END IF;
2920: RETURN(l_return_status);
2921: END populate_new_record;
2922: ---------------------------------------------
2923: -- Set_Attributes for:OKL_TXL_RCPT_APPS_TL --
2924: ---------------------------------------------
2925: FUNCTION Set_Attributes (
2926: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,
2927: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type

Line 2926: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,

2922: ---------------------------------------------
2923: -- Set_Attributes for:OKL_TXL_RCPT_APPS_TL --
2924: ---------------------------------------------
2925: FUNCTION Set_Attributes (
2926: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,
2927: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type
2928: ) RETURN VARCHAR2 IS
2929: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2930: BEGIN

Line 2927: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type

2923: -- Set_Attributes for:OKL_TXL_RCPT_APPS_TL --
2924: ---------------------------------------------
2925: FUNCTION Set_Attributes (
2926: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,
2927: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type
2928: ) RETURN VARCHAR2 IS
2929: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2930: BEGIN
2931: x_okl_txl_rcpt_apps_tl_rec := p_okl_txl_rcpt_apps_tl_rec;

Line 2931: x_okl_txl_rcpt_apps_tl_rec := p_okl_txl_rcpt_apps_tl_rec;

2927: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type
2928: ) RETURN VARCHAR2 IS
2929: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2930: BEGIN
2931: x_okl_txl_rcpt_apps_tl_rec := p_okl_txl_rcpt_apps_tl_rec;
2932: x_okl_txl_rcpt_apps_tl_rec.LANGUAGE := USERENV('LANG');
2933: x_okl_txl_rcpt_apps_tl_rec.SOURCE_LANG := USERENV('LANG');
2934: RETURN(l_return_status);
2935: END Set_Attributes;

Line 2932: x_okl_txl_rcpt_apps_tl_rec.LANGUAGE := USERENV('LANG');

2928: ) RETURN VARCHAR2 IS
2929: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2930: BEGIN
2931: x_okl_txl_rcpt_apps_tl_rec := p_okl_txl_rcpt_apps_tl_rec;
2932: x_okl_txl_rcpt_apps_tl_rec.LANGUAGE := USERENV('LANG');
2933: x_okl_txl_rcpt_apps_tl_rec.SOURCE_LANG := USERENV('LANG');
2934: RETURN(l_return_status);
2935: END Set_Attributes;
2936: BEGIN

Line 2933: x_okl_txl_rcpt_apps_tl_rec.SOURCE_LANG := USERENV('LANG');

2929: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2930: BEGIN
2931: x_okl_txl_rcpt_apps_tl_rec := p_okl_txl_rcpt_apps_tl_rec;
2932: x_okl_txl_rcpt_apps_tl_rec.LANGUAGE := USERENV('LANG');
2933: x_okl_txl_rcpt_apps_tl_rec.SOURCE_LANG := USERENV('LANG');
2934: RETURN(l_return_status);
2935: END Set_Attributes;
2936: BEGIN
2937: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 2948: p_okl_txl_rcpt_apps_tl_rec, -- IN

2944: RAISE Okl_Api.G_EXCEPTION_ERROR;
2945: END IF;
2946: --- Setting item attributes
2947: l_return_status := Set_Attributes(
2948: p_okl_txl_rcpt_apps_tl_rec, -- IN
2949: l_okl_txl_rcpt_apps_tl_rec); -- OUT
2950: --- If any errors happen abort API
2951: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2952: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2949: l_okl_txl_rcpt_apps_tl_rec); -- OUT

2945: END IF;
2946: --- Setting item attributes
2947: l_return_status := Set_Attributes(
2948: p_okl_txl_rcpt_apps_tl_rec, -- IN
2949: l_okl_txl_rcpt_apps_tl_rec); -- OUT
2950: --- If any errors happen abort API
2951: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2952: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2953: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2956: l_return_status := populate_new_record(l_okl_txl_rcpt_apps_tl_rec, ldefokltxlrcptappstlrec);

2952: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2953: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2954: RAISE Okl_Api.G_EXCEPTION_ERROR;
2955: END IF;
2956: l_return_status := populate_new_record(l_okl_txl_rcpt_apps_tl_rec, ldefokltxlrcptappstlrec);
2957: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2958: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2959: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2960: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 2962: UPDATE OKL_TXL_RCPT_APPS_TL

2958: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2959: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2960: RAISE Okl_Api.G_EXCEPTION_ERROR;
2961: END IF;
2962: UPDATE OKL_TXL_RCPT_APPS_TL
2963: SET DESCRIPTION = ldefokltxlrcptappstlrec.description,
2964: CREATED_BY = ldefokltxlrcptappstlrec.created_by,
2965: CREATION_DATE = ldefokltxlrcptappstlrec.creation_date,
2966: LAST_UPDATED_BY = ldefokltxlrcptappstlrec.last_updated_by,

Line 2973: UPDATE OKL_TXL_RCPT_APPS_TL

2969: WHERE ID = ldefokltxlrcptappstlrec.id
2970: --AND SOURCE_LANG = USERENV('LANG');
2971: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2972:
2973: UPDATE OKL_TXL_RCPT_APPS_TL
2974: SET SFWT_FLAG = 'Y'
2975: WHERE ID = ldefokltxlrcptappstlrec.id
2976: AND SOURCE_LANG <> USERENV('LANG');
2977: x_okl_txl_rcpt_apps_tl_rec := ldefokltxlrcptappstlrec;

Line 2977: x_okl_txl_rcpt_apps_tl_rec := ldefokltxlrcptappstlrec;

2973: UPDATE OKL_TXL_RCPT_APPS_TL
2974: SET SFWT_FLAG = 'Y'
2975: WHERE ID = ldefokltxlrcptappstlrec.id
2976: AND SOURCE_LANG <> USERENV('LANG');
2977: x_okl_txl_rcpt_apps_tl_rec := ldefokltxlrcptappstlrec;
2978: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2979: EXCEPTION
2980: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2981: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 3041: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;

3037: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
3038: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3039: l_rcav_rec rcav_rec_type := p_rcav_rec;
3040: l_def_rcav_rec rcav_rec_type;
3041: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
3042: lx_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
3043: l_rca_rec rca_rec_type;
3044: lx_rca_rec rca_rec_type;
3045: -------------------------------

Line 3042: lx_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;

3038: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3039: l_rcav_rec rcav_rec_type := p_rcav_rec;
3040: l_def_rcav_rec rcav_rec_type;
3041: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
3042: lx_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
3043: l_rca_rec rca_rec_type;
3044: lx_rca_rec rca_rec_type;
3045: -------------------------------
3046: -- FUNCTION fill_who_columns --

Line 3311: migrate(l_def_rcav_rec, l_okl_txl_rcpt_apps_tl_rec);

3307:
3308: --------------------------------------
3309: -- Move VIEW record to "Child" records
3310: --------------------------------------
3311: migrate(l_def_rcav_rec, l_okl_txl_rcpt_apps_tl_rec);
3312: migrate(l_def_rcav_rec, l_rca_rec);
3313: --------------------------------------------
3314: -- Call the UPDATE_ROW for each child record
3315: --------------------------------------------

Line 3321: l_okl_txl_rcpt_apps_tl_rec,

3317: p_init_msg_list,
3318: x_return_status,
3319: x_msg_count,
3320: x_msg_data,
3321: l_okl_txl_rcpt_apps_tl_rec,
3322: lx_okl_txl_rcpt_apps_tl_rec
3323: );
3324:
3325: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 3322: lx_okl_txl_rcpt_apps_tl_rec

3318: x_return_status,
3319: x_msg_count,
3320: x_msg_data,
3321: l_okl_txl_rcpt_apps_tl_rec,
3322: lx_okl_txl_rcpt_apps_tl_rec
3323: );
3324:
3325: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3326: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3330: migrate(lx_okl_txl_rcpt_apps_tl_rec, l_def_rcav_rec);

3326: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3327: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3328: RAISE Okl_Api.G_EXCEPTION_ERROR;
3329: END IF;
3330: migrate(lx_okl_txl_rcpt_apps_tl_rec, l_def_rcav_rec);
3331: update_row(
3332: p_init_msg_list,
3333: x_return_status,
3334: x_msg_count,

Line 3534: -- delete_row for:OKL_TXL_RCPT_APPS_TL --

3530: '_PVT'
3531: );
3532: END delete_row;
3533: -----------------------------------------
3534: -- delete_row for:OKL_TXL_RCPT_APPS_TL --
3535: -----------------------------------------
3536: PROCEDURE delete_row(
3537: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
3538: x_return_status OUT NOCOPY VARCHAR2,

Line 3541: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type) IS

3537: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
3538: x_return_status OUT NOCOPY VARCHAR2,
3539: x_msg_count OUT NOCOPY NUMBER,
3540: x_msg_data OUT NOCOPY VARCHAR2,
3541: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type) IS
3542:
3543: l_api_version CONSTANT NUMBER := 1;
3544: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3545: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 3546: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type:= p_okl_txl_rcpt_apps_tl_rec;

3542:
3543: l_api_version CONSTANT NUMBER := 1;
3544: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3545: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3546: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type:= p_okl_txl_rcpt_apps_tl_rec;
3547: l_row_notfound BOOLEAN := TRUE;
3548: ---------------------------------------------
3549: -- Set_Attributes for:OKL_TXL_RCPT_APPS_TL --
3550: ---------------------------------------------

Line 3549: -- Set_Attributes for:OKL_TXL_RCPT_APPS_TL --

3545: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3546: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type:= p_okl_txl_rcpt_apps_tl_rec;
3547: l_row_notfound BOOLEAN := TRUE;
3548: ---------------------------------------------
3549: -- Set_Attributes for:OKL_TXL_RCPT_APPS_TL --
3550: ---------------------------------------------
3551: FUNCTION Set_Attributes (
3552: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,
3553: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type

Line 3552: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,

3548: ---------------------------------------------
3549: -- Set_Attributes for:OKL_TXL_RCPT_APPS_TL --
3550: ---------------------------------------------
3551: FUNCTION Set_Attributes (
3552: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,
3553: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type
3554: ) RETURN VARCHAR2 IS
3555: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3556: BEGIN

Line 3553: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type

3549: -- Set_Attributes for:OKL_TXL_RCPT_APPS_TL --
3550: ---------------------------------------------
3551: FUNCTION Set_Attributes (
3552: p_okl_txl_rcpt_apps_tl_rec IN okl_txl_rcpt_apps_tl_rec_type,
3553: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type
3554: ) RETURN VARCHAR2 IS
3555: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3556: BEGIN
3557: x_okl_txl_rcpt_apps_tl_rec := p_okl_txl_rcpt_apps_tl_rec;

Line 3557: x_okl_txl_rcpt_apps_tl_rec := p_okl_txl_rcpt_apps_tl_rec;

3553: x_okl_txl_rcpt_apps_tl_rec OUT NOCOPY okl_txl_rcpt_apps_tl_rec_type
3554: ) RETURN VARCHAR2 IS
3555: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3556: BEGIN
3557: x_okl_txl_rcpt_apps_tl_rec := p_okl_txl_rcpt_apps_tl_rec;
3558: x_okl_txl_rcpt_apps_tl_rec.LANGUAGE := USERENV('LANG');
3559: RETURN(l_return_status);
3560: END Set_Attributes;
3561: BEGIN

Line 3558: x_okl_txl_rcpt_apps_tl_rec.LANGUAGE := USERENV('LANG');

3554: ) RETURN VARCHAR2 IS
3555: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3556: BEGIN
3557: x_okl_txl_rcpt_apps_tl_rec := p_okl_txl_rcpt_apps_tl_rec;
3558: x_okl_txl_rcpt_apps_tl_rec.LANGUAGE := USERENV('LANG');
3559: RETURN(l_return_status);
3560: END Set_Attributes;
3561: BEGIN
3562: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 3573: p_okl_txl_rcpt_apps_tl_rec, -- IN

3569: RAISE Okl_Api.G_EXCEPTION_ERROR;
3570: END IF;
3571: --- Setting item attributes
3572: l_return_status := Set_Attributes(
3573: p_okl_txl_rcpt_apps_tl_rec, -- IN
3574: l_okl_txl_rcpt_apps_tl_rec); -- OUT
3575: --- If any errors happen abort API
3576: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3577: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3574: l_okl_txl_rcpt_apps_tl_rec); -- OUT

3570: END IF;
3571: --- Setting item attributes
3572: l_return_status := Set_Attributes(
3573: p_okl_txl_rcpt_apps_tl_rec, -- IN
3574: l_okl_txl_rcpt_apps_tl_rec); -- OUT
3575: --- If any errors happen abort API
3576: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3577: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3578: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 3581: DELETE FROM OKL_TXL_RCPT_APPS_TL

3577: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3578: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3579: RAISE Okl_Api.G_EXCEPTION_ERROR;
3580: END IF;
3581: DELETE FROM OKL_TXL_RCPT_APPS_TL
3582: WHERE ID = l_okl_txl_rcpt_apps_tl_rec.id;
3583:
3584: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3585: EXCEPTION

Line 3582: WHERE ID = l_okl_txl_rcpt_apps_tl_rec.id;

3578: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3579: RAISE Okl_Api.G_EXCEPTION_ERROR;
3580: END IF;
3581: DELETE FROM OKL_TXL_RCPT_APPS_TL
3582: WHERE ID = l_okl_txl_rcpt_apps_tl_rec.id;
3583:
3584: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3585: EXCEPTION
3586: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

Line 3632: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;

3628: l_api_version CONSTANT NUMBER := 1;
3629: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3630: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3631: l_rcav_rec rcav_rec_type := p_rcav_rec;
3632: l_okl_txl_rcpt_apps_tl_rec okl_txl_rcpt_apps_tl_rec_type;
3633: l_rca_rec rca_rec_type;
3634: BEGIN
3635: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
3636: G_PKG_NAME,

Line 3652: migrate(l_rcav_rec, l_okl_txl_rcpt_apps_tl_rec);

3648: */
3649: --------------------------------------
3650: -- Move VIEW record to "Child" records
3651: --------------------------------------
3652: migrate(l_rcav_rec, l_okl_txl_rcpt_apps_tl_rec);
3653: migrate(l_rcav_rec, l_rca_rec);
3654: --------------------------------------------
3655: -- Call the DELETE_ROW for each child record
3656: --------------------------------------------

Line 3662: l_okl_txl_rcpt_apps_tl_rec

3658: p_init_msg_list,
3659: x_return_status,
3660: x_msg_count,
3661: x_msg_data,
3662: l_okl_txl_rcpt_apps_tl_rec
3663: );
3664: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3665: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3666: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN