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_XCR_PVT dependencies on OKL_EXT_CSH_RCPTS_TL

Line 40: DELETE FROM OKL_EXT_CSH_RCPTS_TL T

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

Line 48: UPDATE OKL_EXT_CSH_RCPTS_TL T SET (

44: WHERE B.ID = T.ID
45: AND T.LANGUAGE = USERENV('LANG')
46: );
47:
48: UPDATE OKL_EXT_CSH_RCPTS_TL T SET (
49: COMMENTS) = (SELECT
50: B.COMMENTS
51: FROM OKL_EXT_CSH_RCPTS_TL B
52: WHERE B.ID = T.ID

Line 51: FROM OKL_EXT_CSH_RCPTS_TL B

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

Line 60: FROM OKL_EXT_CSH_RCPTS_TL SUBB, OKL_EXT_CSH_RCPTS_TL SUBT

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

Line 68: INSERT INTO OKL_EXT_CSH_RCPTS_TL (

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

Line 90: FROM OKL_EXT_CSH_RCPTS_TL B, FND_LANGUAGES L

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

Line 95: FROM OKL_EXT_CSH_RCPTS_TL T

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

Line 252: -- FUNCTION get_rec for: OKL_EXT_CSH_RCPTS_TL

248: BEGIN
249: RETURN(get_rec(p_xcr_rec, l_row_notfound));
250: END get_rec;
251: ---------------------------------------------------------------------------
252: -- FUNCTION get_rec for: OKL_EXT_CSH_RCPTS_TL
253: ---------------------------------------------------------------------------
254: FUNCTION get_rec (
255: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
256: x_no_data_found OUT NOCOPY BOOLEAN

Line 255: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,

251: ---------------------------------------------------------------------------
252: -- FUNCTION get_rec for: OKL_EXT_CSH_RCPTS_TL
253: ---------------------------------------------------------------------------
254: FUNCTION get_rec (
255: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
256: x_no_data_found OUT NOCOPY BOOLEAN
257: ) RETURN okl_ext_csh_rcpts_tl_rec_type IS
258: CURSOR okl_ext_csh_rcpts_tl_pk_csr (p_id IN NUMBER,
259: p_language IN VARCHAR2) IS

Line 257: ) RETURN okl_ext_csh_rcpts_tl_rec_type IS

253: ---------------------------------------------------------------------------
254: FUNCTION get_rec (
255: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
256: x_no_data_found OUT NOCOPY BOOLEAN
257: ) RETURN okl_ext_csh_rcpts_tl_rec_type IS
258: CURSOR okl_ext_csh_rcpts_tl_pk_csr (p_id IN NUMBER,
259: p_language IN VARCHAR2) IS
260: SELECT
261: ID,

Line 258: CURSOR okl_ext_csh_rcpts_tl_pk_csr (p_id IN NUMBER,

254: FUNCTION get_rec (
255: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
256: x_no_data_found OUT NOCOPY BOOLEAN
257: ) RETURN okl_ext_csh_rcpts_tl_rec_type IS
258: CURSOR okl_ext_csh_rcpts_tl_pk_csr (p_id IN NUMBER,
259: p_language IN VARCHAR2) IS
260: SELECT
261: ID,
262: LANGUAGE,

Line 271: FROM Okl_Ext_Csh_Rcpts_Tl

267: CREATION_DATE,
268: LAST_UPDATED_BY,
269: LAST_UPDATE_DATE,
270: LAST_UPDATE_LOGIN
271: FROM Okl_Ext_Csh_Rcpts_Tl
272: WHERE okl_ext_csh_rcpts_tl.id = p_id
273: AND okl_ext_csh_rcpts_tl.LANGUAGE = p_language;
274: l_okl_ext_csh_rcpts_tl_pk okl_ext_csh_rcpts_tl_pk_csr%ROWTYPE;
275: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;

Line 272: WHERE okl_ext_csh_rcpts_tl.id = p_id

268: LAST_UPDATED_BY,
269: LAST_UPDATE_DATE,
270: LAST_UPDATE_LOGIN
271: FROM Okl_Ext_Csh_Rcpts_Tl
272: WHERE okl_ext_csh_rcpts_tl.id = p_id
273: AND okl_ext_csh_rcpts_tl.LANGUAGE = p_language;
274: l_okl_ext_csh_rcpts_tl_pk okl_ext_csh_rcpts_tl_pk_csr%ROWTYPE;
275: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
276: BEGIN

Line 273: AND okl_ext_csh_rcpts_tl.LANGUAGE = p_language;

269: LAST_UPDATE_DATE,
270: LAST_UPDATE_LOGIN
271: FROM Okl_Ext_Csh_Rcpts_Tl
272: WHERE okl_ext_csh_rcpts_tl.id = p_id
273: AND okl_ext_csh_rcpts_tl.LANGUAGE = p_language;
274: l_okl_ext_csh_rcpts_tl_pk okl_ext_csh_rcpts_tl_pk_csr%ROWTYPE;
275: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
276: BEGIN
277: x_no_data_found := TRUE;

Line 274: l_okl_ext_csh_rcpts_tl_pk okl_ext_csh_rcpts_tl_pk_csr%ROWTYPE;

270: LAST_UPDATE_LOGIN
271: FROM Okl_Ext_Csh_Rcpts_Tl
272: WHERE okl_ext_csh_rcpts_tl.id = p_id
273: AND okl_ext_csh_rcpts_tl.LANGUAGE = p_language;
274: l_okl_ext_csh_rcpts_tl_pk okl_ext_csh_rcpts_tl_pk_csr%ROWTYPE;
275: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
276: BEGIN
277: x_no_data_found := TRUE;
278: -- Get current database values

Line 275: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;

271: FROM Okl_Ext_Csh_Rcpts_Tl
272: WHERE okl_ext_csh_rcpts_tl.id = p_id
273: AND okl_ext_csh_rcpts_tl.LANGUAGE = p_language;
274: l_okl_ext_csh_rcpts_tl_pk okl_ext_csh_rcpts_tl_pk_csr%ROWTYPE;
275: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
276: BEGIN
277: x_no_data_found := TRUE;
278: -- Get current database values
279: OPEN okl_ext_csh_rcpts_tl_pk_csr (p_okl_ext_csh_rcpts_tl_rec.id,

Line 279: OPEN okl_ext_csh_rcpts_tl_pk_csr (p_okl_ext_csh_rcpts_tl_rec.id,

275: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
276: BEGIN
277: x_no_data_found := TRUE;
278: -- Get current database values
279: OPEN okl_ext_csh_rcpts_tl_pk_csr (p_okl_ext_csh_rcpts_tl_rec.id,
280: p_okl_ext_csh_rcpts_tl_rec.LANGUAGE);
281: FETCH okl_ext_csh_rcpts_tl_pk_csr INTO
282: l_okl_ext_csh_rcpts_tl_rec.ID,
283: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE,

Line 280: p_okl_ext_csh_rcpts_tl_rec.LANGUAGE);

276: BEGIN
277: x_no_data_found := TRUE;
278: -- Get current database values
279: OPEN okl_ext_csh_rcpts_tl_pk_csr (p_okl_ext_csh_rcpts_tl_rec.id,
280: p_okl_ext_csh_rcpts_tl_rec.LANGUAGE);
281: FETCH okl_ext_csh_rcpts_tl_pk_csr INTO
282: l_okl_ext_csh_rcpts_tl_rec.ID,
283: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE,
284: l_okl_ext_csh_rcpts_tl_rec.SOURCE_LANG,

Line 281: FETCH okl_ext_csh_rcpts_tl_pk_csr INTO

277: x_no_data_found := TRUE;
278: -- Get current database values
279: OPEN okl_ext_csh_rcpts_tl_pk_csr (p_okl_ext_csh_rcpts_tl_rec.id,
280: p_okl_ext_csh_rcpts_tl_rec.LANGUAGE);
281: FETCH okl_ext_csh_rcpts_tl_pk_csr INTO
282: l_okl_ext_csh_rcpts_tl_rec.ID,
283: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE,
284: l_okl_ext_csh_rcpts_tl_rec.SOURCE_LANG,
285: l_okl_ext_csh_rcpts_tl_rec.SFWT_FLAG,

Line 282: l_okl_ext_csh_rcpts_tl_rec.ID,

278: -- Get current database values
279: OPEN okl_ext_csh_rcpts_tl_pk_csr (p_okl_ext_csh_rcpts_tl_rec.id,
280: p_okl_ext_csh_rcpts_tl_rec.LANGUAGE);
281: FETCH okl_ext_csh_rcpts_tl_pk_csr INTO
282: l_okl_ext_csh_rcpts_tl_rec.ID,
283: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE,
284: l_okl_ext_csh_rcpts_tl_rec.SOURCE_LANG,
285: l_okl_ext_csh_rcpts_tl_rec.SFWT_FLAG,
286: l_okl_ext_csh_rcpts_tl_rec.COMMENTS,

Line 283: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE,

279: OPEN okl_ext_csh_rcpts_tl_pk_csr (p_okl_ext_csh_rcpts_tl_rec.id,
280: p_okl_ext_csh_rcpts_tl_rec.LANGUAGE);
281: FETCH okl_ext_csh_rcpts_tl_pk_csr INTO
282: l_okl_ext_csh_rcpts_tl_rec.ID,
283: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE,
284: l_okl_ext_csh_rcpts_tl_rec.SOURCE_LANG,
285: l_okl_ext_csh_rcpts_tl_rec.SFWT_FLAG,
286: l_okl_ext_csh_rcpts_tl_rec.COMMENTS,
287: l_okl_ext_csh_rcpts_tl_rec.CREATED_BY,

Line 284: l_okl_ext_csh_rcpts_tl_rec.SOURCE_LANG,

280: p_okl_ext_csh_rcpts_tl_rec.LANGUAGE);
281: FETCH okl_ext_csh_rcpts_tl_pk_csr INTO
282: l_okl_ext_csh_rcpts_tl_rec.ID,
283: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE,
284: l_okl_ext_csh_rcpts_tl_rec.SOURCE_LANG,
285: l_okl_ext_csh_rcpts_tl_rec.SFWT_FLAG,
286: l_okl_ext_csh_rcpts_tl_rec.COMMENTS,
287: l_okl_ext_csh_rcpts_tl_rec.CREATED_BY,
288: l_okl_ext_csh_rcpts_tl_rec.CREATION_DATE,

Line 285: l_okl_ext_csh_rcpts_tl_rec.SFWT_FLAG,

281: FETCH okl_ext_csh_rcpts_tl_pk_csr INTO
282: l_okl_ext_csh_rcpts_tl_rec.ID,
283: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE,
284: l_okl_ext_csh_rcpts_tl_rec.SOURCE_LANG,
285: l_okl_ext_csh_rcpts_tl_rec.SFWT_FLAG,
286: l_okl_ext_csh_rcpts_tl_rec.COMMENTS,
287: l_okl_ext_csh_rcpts_tl_rec.CREATED_BY,
288: l_okl_ext_csh_rcpts_tl_rec.CREATION_DATE,
289: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATED_BY,

Line 286: l_okl_ext_csh_rcpts_tl_rec.COMMENTS,

282: l_okl_ext_csh_rcpts_tl_rec.ID,
283: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE,
284: l_okl_ext_csh_rcpts_tl_rec.SOURCE_LANG,
285: l_okl_ext_csh_rcpts_tl_rec.SFWT_FLAG,
286: l_okl_ext_csh_rcpts_tl_rec.COMMENTS,
287: l_okl_ext_csh_rcpts_tl_rec.CREATED_BY,
288: l_okl_ext_csh_rcpts_tl_rec.CREATION_DATE,
289: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATED_BY,
290: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_DATE,

Line 287: l_okl_ext_csh_rcpts_tl_rec.CREATED_BY,

283: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE,
284: l_okl_ext_csh_rcpts_tl_rec.SOURCE_LANG,
285: l_okl_ext_csh_rcpts_tl_rec.SFWT_FLAG,
286: l_okl_ext_csh_rcpts_tl_rec.COMMENTS,
287: l_okl_ext_csh_rcpts_tl_rec.CREATED_BY,
288: l_okl_ext_csh_rcpts_tl_rec.CREATION_DATE,
289: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATED_BY,
290: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_DATE,
291: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_LOGIN;

Line 288: l_okl_ext_csh_rcpts_tl_rec.CREATION_DATE,

284: l_okl_ext_csh_rcpts_tl_rec.SOURCE_LANG,
285: l_okl_ext_csh_rcpts_tl_rec.SFWT_FLAG,
286: l_okl_ext_csh_rcpts_tl_rec.COMMENTS,
287: l_okl_ext_csh_rcpts_tl_rec.CREATED_BY,
288: l_okl_ext_csh_rcpts_tl_rec.CREATION_DATE,
289: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATED_BY,
290: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_DATE,
291: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_LOGIN;
292: x_no_data_found := okl_ext_csh_rcpts_tl_pk_csr%NOTFOUND;

Line 289: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATED_BY,

285: l_okl_ext_csh_rcpts_tl_rec.SFWT_FLAG,
286: l_okl_ext_csh_rcpts_tl_rec.COMMENTS,
287: l_okl_ext_csh_rcpts_tl_rec.CREATED_BY,
288: l_okl_ext_csh_rcpts_tl_rec.CREATION_DATE,
289: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATED_BY,
290: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_DATE,
291: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_LOGIN;
292: x_no_data_found := okl_ext_csh_rcpts_tl_pk_csr%NOTFOUND;
293: CLOSE okl_ext_csh_rcpts_tl_pk_csr;

Line 290: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_DATE,

286: l_okl_ext_csh_rcpts_tl_rec.COMMENTS,
287: l_okl_ext_csh_rcpts_tl_rec.CREATED_BY,
288: l_okl_ext_csh_rcpts_tl_rec.CREATION_DATE,
289: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATED_BY,
290: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_DATE,
291: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_LOGIN;
292: x_no_data_found := okl_ext_csh_rcpts_tl_pk_csr%NOTFOUND;
293: CLOSE okl_ext_csh_rcpts_tl_pk_csr;
294: RETURN(l_okl_ext_csh_rcpts_tl_rec);

Line 291: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_LOGIN;

287: l_okl_ext_csh_rcpts_tl_rec.CREATED_BY,
288: l_okl_ext_csh_rcpts_tl_rec.CREATION_DATE,
289: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATED_BY,
290: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_DATE,
291: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_LOGIN;
292: x_no_data_found := okl_ext_csh_rcpts_tl_pk_csr%NOTFOUND;
293: CLOSE okl_ext_csh_rcpts_tl_pk_csr;
294: RETURN(l_okl_ext_csh_rcpts_tl_rec);
295: END get_rec;

Line 292: x_no_data_found := okl_ext_csh_rcpts_tl_pk_csr%NOTFOUND;

288: l_okl_ext_csh_rcpts_tl_rec.CREATION_DATE,
289: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATED_BY,
290: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_DATE,
291: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_LOGIN;
292: x_no_data_found := okl_ext_csh_rcpts_tl_pk_csr%NOTFOUND;
293: CLOSE okl_ext_csh_rcpts_tl_pk_csr;
294: RETURN(l_okl_ext_csh_rcpts_tl_rec);
295: END get_rec;
296:

Line 293: CLOSE okl_ext_csh_rcpts_tl_pk_csr;

289: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATED_BY,
290: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_DATE,
291: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_LOGIN;
292: x_no_data_found := okl_ext_csh_rcpts_tl_pk_csr%NOTFOUND;
293: CLOSE okl_ext_csh_rcpts_tl_pk_csr;
294: RETURN(l_okl_ext_csh_rcpts_tl_rec);
295: END get_rec;
296:
297: FUNCTION get_rec (

Line 294: RETURN(l_okl_ext_csh_rcpts_tl_rec);

290: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_DATE,
291: l_okl_ext_csh_rcpts_tl_rec.LAST_UPDATE_LOGIN;
292: x_no_data_found := okl_ext_csh_rcpts_tl_pk_csr%NOTFOUND;
293: CLOSE okl_ext_csh_rcpts_tl_pk_csr;
294: RETURN(l_okl_ext_csh_rcpts_tl_rec);
295: END get_rec;
296:
297: FUNCTION get_rec (
298: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type

Line 298: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type

294: RETURN(l_okl_ext_csh_rcpts_tl_rec);
295: END get_rec;
296:
297: FUNCTION get_rec (
298: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type
299: ) RETURN okl_ext_csh_rcpts_tl_rec_type IS
300: l_row_notfound BOOLEAN := TRUE;
301: BEGIN
302: RETURN(get_rec(p_okl_ext_csh_rcpts_tl_rec, l_row_notfound));

Line 299: ) RETURN okl_ext_csh_rcpts_tl_rec_type IS

295: END get_rec;
296:
297: FUNCTION get_rec (
298: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type
299: ) RETURN okl_ext_csh_rcpts_tl_rec_type IS
300: l_row_notfound BOOLEAN := TRUE;
301: BEGIN
302: RETURN(get_rec(p_okl_ext_csh_rcpts_tl_rec, l_row_notfound));
303: END get_rec;

Line 302: RETURN(get_rec(p_okl_ext_csh_rcpts_tl_rec, l_row_notfound));

298: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type
299: ) RETURN okl_ext_csh_rcpts_tl_rec_type IS
300: l_row_notfound BOOLEAN := TRUE;
301: BEGIN
302: RETURN(get_rec(p_okl_ext_csh_rcpts_tl_rec, l_row_notfound));
303: END get_rec;
304: ---------------------------------------------------------------------------
305: -- FUNCTION get_rec for: OKL_EXT_CSH_RCPTS_V
306: ---------------------------------------------------------------------------

Line 1140: p_to IN OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type

1136: p_to.expired_flag := p_from.expired_flag;
1137: END migrate;
1138: PROCEDURE migrate (
1139: p_from IN xcrv_rec_type,
1140: p_to IN OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type
1141: ) IS
1142: BEGIN
1143: p_to.id := p_from.id;
1144: p_to.sfwt_flag := p_from.sfwt_flag;

Line 1153: p_from IN okl_ext_csh_rcpts_tl_rec_type,

1149: p_to.last_update_date := p_from.last_update_date;
1150: p_to.last_update_login := p_from.last_update_login;
1151: END migrate;
1152: PROCEDURE migrate (
1153: p_from IN okl_ext_csh_rcpts_tl_rec_type,
1154: p_to IN OUT NOCOPY xcrv_rec_type
1155: ) IS
1156: BEGIN
1157: p_to.id := p_from.id;

Line 1186: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;

1182: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1183: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1184: l_xcrv_rec xcrv_rec_type := p_xcrv_rec;
1185: l_xcr_rec xcr_rec_type;
1186: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
1187: BEGIN
1188: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1189: G_PKG_NAME,
1190: p_init_msg_list,

Line 1542: -- insert_row for:OKL_EXT_CSH_RCPTS_TL --

1538: '_PVT'
1539: );
1540: END insert_row;
1541: -----------------------------------------
1542: -- insert_row for:OKL_EXT_CSH_RCPTS_TL --
1543: -----------------------------------------
1544: PROCEDURE insert_row(
1545: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1546: x_return_status OUT NOCOPY VARCHAR2,

Line 1549: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,

1545: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1546: x_return_status OUT NOCOPY VARCHAR2,
1547: x_msg_count OUT NOCOPY NUMBER,
1548: x_msg_data OUT NOCOPY VARCHAR2,
1549: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
1550: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type) IS
1551:
1552: l_api_version CONSTANT NUMBER := 1;
1553: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1550: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type) IS

1546: x_return_status OUT NOCOPY VARCHAR2,
1547: x_msg_count OUT NOCOPY NUMBER,
1548: x_msg_data OUT NOCOPY VARCHAR2,
1549: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
1550: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type) IS
1551:
1552: l_api_version CONSTANT NUMBER := 1;
1553: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1554: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 1555: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type := p_okl_ext_csh_rcpts_tl_rec;

1551:
1552: l_api_version CONSTANT NUMBER := 1;
1553: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1554: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1555: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type := p_okl_ext_csh_rcpts_tl_rec;
1556: ldefoklextcshrcptstlrec okl_ext_csh_rcpts_tl_rec_type;
1557: CURSOR get_languages IS
1558: SELECT *
1559: FROM FND_LANGUAGES

Line 1556: ldefoklextcshrcptstlrec okl_ext_csh_rcpts_tl_rec_type;

1552: l_api_version CONSTANT NUMBER := 1;
1553: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1554: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1555: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type := p_okl_ext_csh_rcpts_tl_rec;
1556: ldefoklextcshrcptstlrec okl_ext_csh_rcpts_tl_rec_type;
1557: CURSOR get_languages IS
1558: SELECT *
1559: FROM FND_LANGUAGES
1560: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1562: -- Set_Attributes for:OKL_EXT_CSH_RCPTS_TL --

1558: SELECT *
1559: FROM FND_LANGUAGES
1560: WHERE INSTALLED_FLAG IN ('I', 'B');
1561: ---------------------------------------------
1562: -- Set_Attributes for:OKL_EXT_CSH_RCPTS_TL --
1563: ---------------------------------------------
1564: FUNCTION Set_Attributes (
1565: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
1566: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type

Line 1565: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,

1561: ---------------------------------------------
1562: -- Set_Attributes for:OKL_EXT_CSH_RCPTS_TL --
1563: ---------------------------------------------
1564: FUNCTION Set_Attributes (
1565: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
1566: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type
1567: ) RETURN VARCHAR2 IS
1568: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1569: BEGIN

Line 1566: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type

1562: -- Set_Attributes for:OKL_EXT_CSH_RCPTS_TL --
1563: ---------------------------------------------
1564: FUNCTION Set_Attributes (
1565: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
1566: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type
1567: ) RETURN VARCHAR2 IS
1568: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1569: BEGIN
1570: x_okl_ext_csh_rcpts_tl_rec := p_okl_ext_csh_rcpts_tl_rec;

Line 1570: x_okl_ext_csh_rcpts_tl_rec := p_okl_ext_csh_rcpts_tl_rec;

1566: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type
1567: ) RETURN VARCHAR2 IS
1568: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1569: BEGIN
1570: x_okl_ext_csh_rcpts_tl_rec := p_okl_ext_csh_rcpts_tl_rec;
1571: x_okl_ext_csh_rcpts_tl_rec.LANGUAGE := USERENV('LANG');
1572: x_okl_ext_csh_rcpts_tl_rec.SOURCE_LANG := USERENV('LANG');
1573: RETURN(l_return_status);
1574: END Set_Attributes;

Line 1571: x_okl_ext_csh_rcpts_tl_rec.LANGUAGE := USERENV('LANG');

1567: ) RETURN VARCHAR2 IS
1568: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1569: BEGIN
1570: x_okl_ext_csh_rcpts_tl_rec := p_okl_ext_csh_rcpts_tl_rec;
1571: x_okl_ext_csh_rcpts_tl_rec.LANGUAGE := USERENV('LANG');
1572: x_okl_ext_csh_rcpts_tl_rec.SOURCE_LANG := USERENV('LANG');
1573: RETURN(l_return_status);
1574: END Set_Attributes;
1575: BEGIN

Line 1572: x_okl_ext_csh_rcpts_tl_rec.SOURCE_LANG := USERENV('LANG');

1568: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1569: BEGIN
1570: x_okl_ext_csh_rcpts_tl_rec := p_okl_ext_csh_rcpts_tl_rec;
1571: x_okl_ext_csh_rcpts_tl_rec.LANGUAGE := USERENV('LANG');
1572: x_okl_ext_csh_rcpts_tl_rec.SOURCE_LANG := USERENV('LANG');
1573: RETURN(l_return_status);
1574: END Set_Attributes;
1575: BEGIN
1576: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 1587: p_okl_ext_csh_rcpts_tl_rec, -- IN

1583: RAISE Okl_Api.G_EXCEPTION_ERROR;
1584: END IF;
1585: --- Setting item attributes
1586: l_return_status := Set_Attributes(
1587: p_okl_ext_csh_rcpts_tl_rec, -- IN
1588: l_okl_ext_csh_rcpts_tl_rec); -- OUT
1589: --- If any errors happen abort API
1590: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1591: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1588: l_okl_ext_csh_rcpts_tl_rec); -- OUT

1584: END IF;
1585: --- Setting item attributes
1586: l_return_status := Set_Attributes(
1587: p_okl_ext_csh_rcpts_tl_rec, -- IN
1588: l_okl_ext_csh_rcpts_tl_rec); -- OUT
1589: --- If any errors happen abort API
1590: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1591: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1592: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 1596: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE := l_lang_rec.language_code;

1592: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1593: RAISE Okl_Api.G_EXCEPTION_ERROR;
1594: END IF;
1595: FOR l_lang_rec IN get_languages LOOP
1596: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE := l_lang_rec.language_code;
1597: INSERT INTO OKL_EXT_CSH_RCPTS_TL(
1598: id,
1599: LANGUAGE,
1600: source_lang,

Line 1597: INSERT INTO OKL_EXT_CSH_RCPTS_TL(

1593: RAISE Okl_Api.G_EXCEPTION_ERROR;
1594: END IF;
1595: FOR l_lang_rec IN get_languages LOOP
1596: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE := l_lang_rec.language_code;
1597: INSERT INTO OKL_EXT_CSH_RCPTS_TL(
1598: id,
1599: LANGUAGE,
1600: source_lang,
1601: sfwt_flag,

Line 1609: l_okl_ext_csh_rcpts_tl_rec.id,

1605: last_updated_by,
1606: last_update_date,
1607: last_update_login)
1608: VALUES (
1609: l_okl_ext_csh_rcpts_tl_rec.id,
1610: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE,
1611: l_okl_ext_csh_rcpts_tl_rec.source_lang,
1612: l_okl_ext_csh_rcpts_tl_rec.sfwt_flag,
1613: l_okl_ext_csh_rcpts_tl_rec.comments,

Line 1610: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE,

1606: last_update_date,
1607: last_update_login)
1608: VALUES (
1609: l_okl_ext_csh_rcpts_tl_rec.id,
1610: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE,
1611: l_okl_ext_csh_rcpts_tl_rec.source_lang,
1612: l_okl_ext_csh_rcpts_tl_rec.sfwt_flag,
1613: l_okl_ext_csh_rcpts_tl_rec.comments,
1614: l_okl_ext_csh_rcpts_tl_rec.created_by,

Line 1611: l_okl_ext_csh_rcpts_tl_rec.source_lang,

1607: last_update_login)
1608: VALUES (
1609: l_okl_ext_csh_rcpts_tl_rec.id,
1610: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE,
1611: l_okl_ext_csh_rcpts_tl_rec.source_lang,
1612: l_okl_ext_csh_rcpts_tl_rec.sfwt_flag,
1613: l_okl_ext_csh_rcpts_tl_rec.comments,
1614: l_okl_ext_csh_rcpts_tl_rec.created_by,
1615: l_okl_ext_csh_rcpts_tl_rec.creation_date,

Line 1612: l_okl_ext_csh_rcpts_tl_rec.sfwt_flag,

1608: VALUES (
1609: l_okl_ext_csh_rcpts_tl_rec.id,
1610: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE,
1611: l_okl_ext_csh_rcpts_tl_rec.source_lang,
1612: l_okl_ext_csh_rcpts_tl_rec.sfwt_flag,
1613: l_okl_ext_csh_rcpts_tl_rec.comments,
1614: l_okl_ext_csh_rcpts_tl_rec.created_by,
1615: l_okl_ext_csh_rcpts_tl_rec.creation_date,
1616: l_okl_ext_csh_rcpts_tl_rec.last_updated_by,

Line 1613: l_okl_ext_csh_rcpts_tl_rec.comments,

1609: l_okl_ext_csh_rcpts_tl_rec.id,
1610: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE,
1611: l_okl_ext_csh_rcpts_tl_rec.source_lang,
1612: l_okl_ext_csh_rcpts_tl_rec.sfwt_flag,
1613: l_okl_ext_csh_rcpts_tl_rec.comments,
1614: l_okl_ext_csh_rcpts_tl_rec.created_by,
1615: l_okl_ext_csh_rcpts_tl_rec.creation_date,
1616: l_okl_ext_csh_rcpts_tl_rec.last_updated_by,
1617: l_okl_ext_csh_rcpts_tl_rec.last_update_date,

Line 1614: l_okl_ext_csh_rcpts_tl_rec.created_by,

1610: l_okl_ext_csh_rcpts_tl_rec.LANGUAGE,
1611: l_okl_ext_csh_rcpts_tl_rec.source_lang,
1612: l_okl_ext_csh_rcpts_tl_rec.sfwt_flag,
1613: l_okl_ext_csh_rcpts_tl_rec.comments,
1614: l_okl_ext_csh_rcpts_tl_rec.created_by,
1615: l_okl_ext_csh_rcpts_tl_rec.creation_date,
1616: l_okl_ext_csh_rcpts_tl_rec.last_updated_by,
1617: l_okl_ext_csh_rcpts_tl_rec.last_update_date,
1618: l_okl_ext_csh_rcpts_tl_rec.last_update_login);

Line 1615: l_okl_ext_csh_rcpts_tl_rec.creation_date,

1611: l_okl_ext_csh_rcpts_tl_rec.source_lang,
1612: l_okl_ext_csh_rcpts_tl_rec.sfwt_flag,
1613: l_okl_ext_csh_rcpts_tl_rec.comments,
1614: l_okl_ext_csh_rcpts_tl_rec.created_by,
1615: l_okl_ext_csh_rcpts_tl_rec.creation_date,
1616: l_okl_ext_csh_rcpts_tl_rec.last_updated_by,
1617: l_okl_ext_csh_rcpts_tl_rec.last_update_date,
1618: l_okl_ext_csh_rcpts_tl_rec.last_update_login);
1619: END LOOP;

Line 1616: l_okl_ext_csh_rcpts_tl_rec.last_updated_by,

1612: l_okl_ext_csh_rcpts_tl_rec.sfwt_flag,
1613: l_okl_ext_csh_rcpts_tl_rec.comments,
1614: l_okl_ext_csh_rcpts_tl_rec.created_by,
1615: l_okl_ext_csh_rcpts_tl_rec.creation_date,
1616: l_okl_ext_csh_rcpts_tl_rec.last_updated_by,
1617: l_okl_ext_csh_rcpts_tl_rec.last_update_date,
1618: l_okl_ext_csh_rcpts_tl_rec.last_update_login);
1619: END LOOP;
1620: -- Set OUT values

Line 1617: l_okl_ext_csh_rcpts_tl_rec.last_update_date,

1613: l_okl_ext_csh_rcpts_tl_rec.comments,
1614: l_okl_ext_csh_rcpts_tl_rec.created_by,
1615: l_okl_ext_csh_rcpts_tl_rec.creation_date,
1616: l_okl_ext_csh_rcpts_tl_rec.last_updated_by,
1617: l_okl_ext_csh_rcpts_tl_rec.last_update_date,
1618: l_okl_ext_csh_rcpts_tl_rec.last_update_login);
1619: END LOOP;
1620: -- Set OUT values
1621: x_okl_ext_csh_rcpts_tl_rec := l_okl_ext_csh_rcpts_tl_rec;

Line 1618: l_okl_ext_csh_rcpts_tl_rec.last_update_login);

1614: l_okl_ext_csh_rcpts_tl_rec.created_by,
1615: l_okl_ext_csh_rcpts_tl_rec.creation_date,
1616: l_okl_ext_csh_rcpts_tl_rec.last_updated_by,
1617: l_okl_ext_csh_rcpts_tl_rec.last_update_date,
1618: l_okl_ext_csh_rcpts_tl_rec.last_update_login);
1619: END LOOP;
1620: -- Set OUT values
1621: x_okl_ext_csh_rcpts_tl_rec := l_okl_ext_csh_rcpts_tl_rec;
1622: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1621: x_okl_ext_csh_rcpts_tl_rec := l_okl_ext_csh_rcpts_tl_rec;

1617: l_okl_ext_csh_rcpts_tl_rec.last_update_date,
1618: l_okl_ext_csh_rcpts_tl_rec.last_update_login);
1619: END LOOP;
1620: -- Set OUT values
1621: x_okl_ext_csh_rcpts_tl_rec := l_okl_ext_csh_rcpts_tl_rec;
1622: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1623: EXCEPTION
1624: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1625: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 1674: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;

1670: l_xcrv_rec xcrv_rec_type;
1671: l_def_xcrv_rec xcrv_rec_type;
1672: l_xcr_rec xcr_rec_type;
1673: lx_xcr_rec xcr_rec_type;
1674: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
1675: lx_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
1676: -------------------------------
1677: -- FUNCTION fill_who_columns --
1678: -------------------------------

Line 1675: lx_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;

1671: l_def_xcrv_rec xcrv_rec_type;
1672: l_xcr_rec xcr_rec_type;
1673: lx_xcr_rec xcr_rec_type;
1674: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
1675: lx_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
1676: -------------------------------
1677: -- FUNCTION fill_who_columns --
1678: -------------------------------
1679: FUNCTION fill_who_columns (

Line 1773: migrate(l_def_xcrv_rec, l_okl_ext_csh_rcpts_tl_rec);

1769: --------------------------------------
1770: -- Move VIEW record to "Child" records
1771: --------------------------------------
1772: migrate(l_def_xcrv_rec, l_xcr_rec);
1773: migrate(l_def_xcrv_rec, l_okl_ext_csh_rcpts_tl_rec);
1774: --------------------------------------------
1775: -- Call the INSERT_ROW for each child record
1776: --------------------------------------------
1777: insert_row(

Line 1797: l_okl_ext_csh_rcpts_tl_rec,

1793: p_init_msg_list,
1794: x_return_status,
1795: x_msg_count,
1796: x_msg_data,
1797: l_okl_ext_csh_rcpts_tl_rec,
1798: lx_okl_ext_csh_rcpts_tl_rec
1799: );
1800: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1801: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1798: lx_okl_ext_csh_rcpts_tl_rec

1794: x_return_status,
1795: x_msg_count,
1796: x_msg_data,
1797: l_okl_ext_csh_rcpts_tl_rec,
1798: lx_okl_ext_csh_rcpts_tl_rec
1799: );
1800: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1801: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1802: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 1805: migrate(lx_okl_ext_csh_rcpts_tl_rec, l_def_xcrv_rec);

1801: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1802: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1803: RAISE Okl_Api.G_EXCEPTION_ERROR;
1804: END IF;
1805: migrate(lx_okl_ext_csh_rcpts_tl_rec, l_def_xcrv_rec);
1806: -- Set OUT values
1807: x_xcrv_rec := l_def_xcrv_rec;
1808: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1809: EXCEPTION

Line 2038: -- lock_row for:OKL_EXT_CSH_RCPTS_TL --

2034: '_PVT'
2035: );
2036: END lock_row;
2037: ---------------------------------------
2038: -- lock_row for:OKL_EXT_CSH_RCPTS_TL --
2039: ---------------------------------------
2040: PROCEDURE lock_row(
2041: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2042: x_return_status OUT NOCOPY VARCHAR2,

Line 2045: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type) IS

2041: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2042: x_return_status OUT NOCOPY VARCHAR2,
2043: x_msg_count OUT NOCOPY NUMBER,
2044: x_msg_data OUT NOCOPY VARCHAR2,
2045: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type) IS
2046:
2047: E_Resource_Busy EXCEPTION;
2048: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2049: CURSOR lock_csr (p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type) IS

Line 2049: CURSOR lock_csr (p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type) IS

2045: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type) IS
2046:
2047: E_Resource_Busy EXCEPTION;
2048: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2049: CURSOR lock_csr (p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type) IS
2050: SELECT *
2051: FROM OKL_EXT_CSH_RCPTS_TL
2052: WHERE ID = p_okl_ext_csh_rcpts_tl_rec.id
2053: FOR UPDATE NOWAIT;

Line 2051: FROM OKL_EXT_CSH_RCPTS_TL

2047: E_Resource_Busy EXCEPTION;
2048: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2049: CURSOR lock_csr (p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type) IS
2050: SELECT *
2051: FROM OKL_EXT_CSH_RCPTS_TL
2052: WHERE ID = p_okl_ext_csh_rcpts_tl_rec.id
2053: FOR UPDATE NOWAIT;
2054:
2055: l_api_version CONSTANT NUMBER := 1;

Line 2052: WHERE ID = p_okl_ext_csh_rcpts_tl_rec.id

2048: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2049: CURSOR lock_csr (p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type) IS
2050: SELECT *
2051: FROM OKL_EXT_CSH_RCPTS_TL
2052: WHERE ID = p_okl_ext_csh_rcpts_tl_rec.id
2053: FOR UPDATE NOWAIT;
2054:
2055: l_api_version CONSTANT NUMBER := 1;
2056: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2072: OPEN lock_csr(p_okl_ext_csh_rcpts_tl_rec);

2068: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2069: RAISE Okl_Api.G_EXCEPTION_ERROR;
2070: END IF;
2071: BEGIN
2072: OPEN lock_csr(p_okl_ext_csh_rcpts_tl_rec);
2073: FETCH lock_csr INTO l_lock_var;
2074: l_row_notfound := lock_csr%NOTFOUND;
2075: CLOSE lock_csr;
2076: EXCEPTION

Line 2137: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;

2133: l_api_version CONSTANT NUMBER := 1;
2134: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2135: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2136: l_xcr_rec xcr_rec_type;
2137: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
2138: BEGIN
2139: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
2140: G_PKG_NAME,
2141: p_init_msg_list,

Line 2155: migrate(p_xcrv_rec, l_okl_ext_csh_rcpts_tl_rec);

2151: --------------------------------------
2152: -- Move VIEW record to "Child" records
2153: --------------------------------------
2154: migrate(p_xcrv_rec, l_xcr_rec);
2155: migrate(p_xcrv_rec, l_okl_ext_csh_rcpts_tl_rec);
2156: --------------------------------------------
2157: -- Call the LOCK_ROW for each child record
2158: --------------------------------------------
2159: lock_row(

Line 2176: l_okl_ext_csh_rcpts_tl_rec

2172: p_init_msg_list,
2173: x_return_status,
2174: x_msg_count,
2175: x_msg_data,
2176: l_okl_ext_csh_rcpts_tl_rec
2177: );
2178: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2179: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2180: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2694: -- update_row for:OKL_EXT_CSH_RCPTS_TL --

2690: '_PVT'
2691: );
2692: END update_row;
2693: -----------------------------------------
2694: -- update_row for:OKL_EXT_CSH_RCPTS_TL --
2695: -----------------------------------------
2696: PROCEDURE update_row(
2697: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2698: x_return_status OUT NOCOPY VARCHAR2,

Line 2701: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,

2697: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2698: x_return_status OUT NOCOPY VARCHAR2,
2699: x_msg_count OUT NOCOPY NUMBER,
2700: x_msg_data OUT NOCOPY VARCHAR2,
2701: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
2702: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type) IS
2703:
2704: l_api_version CONSTANT NUMBER := 1;
2705: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2702: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type) IS

2698: x_return_status OUT NOCOPY VARCHAR2,
2699: x_msg_count OUT NOCOPY NUMBER,
2700: x_msg_data OUT NOCOPY VARCHAR2,
2701: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
2702: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type) IS
2703:
2704: l_api_version CONSTANT NUMBER := 1;
2705: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2706: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2707: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type := p_okl_ext_csh_rcpts_tl_rec;

2703:
2704: l_api_version CONSTANT NUMBER := 1;
2705: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2706: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2707: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type := p_okl_ext_csh_rcpts_tl_rec;
2708: ldefoklextcshrcptstlrec okl_ext_csh_rcpts_tl_rec_type;
2709: l_row_notfound BOOLEAN := TRUE;
2710: ----------------------------------
2711: -- FUNCTION populate_new_record --

Line 2708: ldefoklextcshrcptstlrec okl_ext_csh_rcpts_tl_rec_type;

2704: l_api_version CONSTANT NUMBER := 1;
2705: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2706: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2707: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type := p_okl_ext_csh_rcpts_tl_rec;
2708: ldefoklextcshrcptstlrec okl_ext_csh_rcpts_tl_rec_type;
2709: l_row_notfound BOOLEAN := TRUE;
2710: ----------------------------------
2711: -- FUNCTION populate_new_record --
2712: ----------------------------------

Line 2714: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,

2710: ----------------------------------
2711: -- FUNCTION populate_new_record --
2712: ----------------------------------
2713: FUNCTION populate_new_record (
2714: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
2715: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type
2716: ) RETURN VARCHAR2 IS
2717: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
2718: l_row_notfound BOOLEAN := TRUE;

Line 2715: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type

2711: -- FUNCTION populate_new_record --
2712: ----------------------------------
2713: FUNCTION populate_new_record (
2714: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
2715: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type
2716: ) RETURN VARCHAR2 IS
2717: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
2718: l_row_notfound BOOLEAN := TRUE;
2719: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2717: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;

2713: FUNCTION populate_new_record (
2714: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
2715: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type
2716: ) RETURN VARCHAR2 IS
2717: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
2718: l_row_notfound BOOLEAN := TRUE;
2719: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2720: BEGIN
2721: x_okl_ext_csh_rcpts_tl_rec := p_okl_ext_csh_rcpts_tl_rec;

Line 2721: x_okl_ext_csh_rcpts_tl_rec := p_okl_ext_csh_rcpts_tl_rec;

2717: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
2718: l_row_notfound BOOLEAN := TRUE;
2719: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2720: BEGIN
2721: x_okl_ext_csh_rcpts_tl_rec := p_okl_ext_csh_rcpts_tl_rec;
2722: -- Get current database values
2723: l_okl_ext_csh_rcpts_tl_rec := get_rec(p_okl_ext_csh_rcpts_tl_rec, l_row_notfound);
2724: IF (l_row_notfound) THEN
2725: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 2723: l_okl_ext_csh_rcpts_tl_rec := get_rec(p_okl_ext_csh_rcpts_tl_rec, l_row_notfound);

2719: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2720: BEGIN
2721: x_okl_ext_csh_rcpts_tl_rec := p_okl_ext_csh_rcpts_tl_rec;
2722: -- Get current database values
2723: l_okl_ext_csh_rcpts_tl_rec := get_rec(p_okl_ext_csh_rcpts_tl_rec, l_row_notfound);
2724: IF (l_row_notfound) THEN
2725: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2726: END IF;
2727: IF (x_okl_ext_csh_rcpts_tl_rec.id = Okl_Api.G_MISS_NUM)

Line 2727: IF (x_okl_ext_csh_rcpts_tl_rec.id = Okl_Api.G_MISS_NUM)

2723: l_okl_ext_csh_rcpts_tl_rec := get_rec(p_okl_ext_csh_rcpts_tl_rec, l_row_notfound);
2724: IF (l_row_notfound) THEN
2725: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2726: END IF;
2727: IF (x_okl_ext_csh_rcpts_tl_rec.id = Okl_Api.G_MISS_NUM)
2728: THEN
2729: x_okl_ext_csh_rcpts_tl_rec.id := l_okl_ext_csh_rcpts_tl_rec.id;
2730: END IF;
2731: IF (x_okl_ext_csh_rcpts_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)

Line 2729: x_okl_ext_csh_rcpts_tl_rec.id := l_okl_ext_csh_rcpts_tl_rec.id;

2725: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2726: END IF;
2727: IF (x_okl_ext_csh_rcpts_tl_rec.id = Okl_Api.G_MISS_NUM)
2728: THEN
2729: x_okl_ext_csh_rcpts_tl_rec.id := l_okl_ext_csh_rcpts_tl_rec.id;
2730: END IF;
2731: IF (x_okl_ext_csh_rcpts_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2732: THEN
2733: x_okl_ext_csh_rcpts_tl_rec.LANGUAGE := l_okl_ext_csh_rcpts_tl_rec.LANGUAGE;

Line 2731: IF (x_okl_ext_csh_rcpts_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)

2727: IF (x_okl_ext_csh_rcpts_tl_rec.id = Okl_Api.G_MISS_NUM)
2728: THEN
2729: x_okl_ext_csh_rcpts_tl_rec.id := l_okl_ext_csh_rcpts_tl_rec.id;
2730: END IF;
2731: IF (x_okl_ext_csh_rcpts_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2732: THEN
2733: x_okl_ext_csh_rcpts_tl_rec.LANGUAGE := l_okl_ext_csh_rcpts_tl_rec.LANGUAGE;
2734: END IF;
2735: IF (x_okl_ext_csh_rcpts_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)

Line 2733: x_okl_ext_csh_rcpts_tl_rec.LANGUAGE := l_okl_ext_csh_rcpts_tl_rec.LANGUAGE;

2729: x_okl_ext_csh_rcpts_tl_rec.id := l_okl_ext_csh_rcpts_tl_rec.id;
2730: END IF;
2731: IF (x_okl_ext_csh_rcpts_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2732: THEN
2733: x_okl_ext_csh_rcpts_tl_rec.LANGUAGE := l_okl_ext_csh_rcpts_tl_rec.LANGUAGE;
2734: END IF;
2735: IF (x_okl_ext_csh_rcpts_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2736: THEN
2737: x_okl_ext_csh_rcpts_tl_rec.source_lang := l_okl_ext_csh_rcpts_tl_rec.source_lang;

Line 2735: IF (x_okl_ext_csh_rcpts_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)

2731: IF (x_okl_ext_csh_rcpts_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2732: THEN
2733: x_okl_ext_csh_rcpts_tl_rec.LANGUAGE := l_okl_ext_csh_rcpts_tl_rec.LANGUAGE;
2734: END IF;
2735: IF (x_okl_ext_csh_rcpts_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2736: THEN
2737: x_okl_ext_csh_rcpts_tl_rec.source_lang := l_okl_ext_csh_rcpts_tl_rec.source_lang;
2738: END IF;
2739: IF (x_okl_ext_csh_rcpts_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)

Line 2737: x_okl_ext_csh_rcpts_tl_rec.source_lang := l_okl_ext_csh_rcpts_tl_rec.source_lang;

2733: x_okl_ext_csh_rcpts_tl_rec.LANGUAGE := l_okl_ext_csh_rcpts_tl_rec.LANGUAGE;
2734: END IF;
2735: IF (x_okl_ext_csh_rcpts_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2736: THEN
2737: x_okl_ext_csh_rcpts_tl_rec.source_lang := l_okl_ext_csh_rcpts_tl_rec.source_lang;
2738: END IF;
2739: IF (x_okl_ext_csh_rcpts_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2740: THEN
2741: x_okl_ext_csh_rcpts_tl_rec.sfwt_flag := l_okl_ext_csh_rcpts_tl_rec.sfwt_flag;

Line 2739: IF (x_okl_ext_csh_rcpts_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)

2735: IF (x_okl_ext_csh_rcpts_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2736: THEN
2737: x_okl_ext_csh_rcpts_tl_rec.source_lang := l_okl_ext_csh_rcpts_tl_rec.source_lang;
2738: END IF;
2739: IF (x_okl_ext_csh_rcpts_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2740: THEN
2741: x_okl_ext_csh_rcpts_tl_rec.sfwt_flag := l_okl_ext_csh_rcpts_tl_rec.sfwt_flag;
2742: END IF;
2743: IF (x_okl_ext_csh_rcpts_tl_rec.comments = Okl_Api.G_MISS_CHAR)

Line 2741: x_okl_ext_csh_rcpts_tl_rec.sfwt_flag := l_okl_ext_csh_rcpts_tl_rec.sfwt_flag;

2737: x_okl_ext_csh_rcpts_tl_rec.source_lang := l_okl_ext_csh_rcpts_tl_rec.source_lang;
2738: END IF;
2739: IF (x_okl_ext_csh_rcpts_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2740: THEN
2741: x_okl_ext_csh_rcpts_tl_rec.sfwt_flag := l_okl_ext_csh_rcpts_tl_rec.sfwt_flag;
2742: END IF;
2743: IF (x_okl_ext_csh_rcpts_tl_rec.comments = Okl_Api.G_MISS_CHAR)
2744: THEN
2745: x_okl_ext_csh_rcpts_tl_rec.comments := l_okl_ext_csh_rcpts_tl_rec.comments;

Line 2743: IF (x_okl_ext_csh_rcpts_tl_rec.comments = Okl_Api.G_MISS_CHAR)

2739: IF (x_okl_ext_csh_rcpts_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2740: THEN
2741: x_okl_ext_csh_rcpts_tl_rec.sfwt_flag := l_okl_ext_csh_rcpts_tl_rec.sfwt_flag;
2742: END IF;
2743: IF (x_okl_ext_csh_rcpts_tl_rec.comments = Okl_Api.G_MISS_CHAR)
2744: THEN
2745: x_okl_ext_csh_rcpts_tl_rec.comments := l_okl_ext_csh_rcpts_tl_rec.comments;
2746: END IF;
2747: IF (x_okl_ext_csh_rcpts_tl_rec.created_by = Okl_Api.G_MISS_NUM)

Line 2745: x_okl_ext_csh_rcpts_tl_rec.comments := l_okl_ext_csh_rcpts_tl_rec.comments;

2741: x_okl_ext_csh_rcpts_tl_rec.sfwt_flag := l_okl_ext_csh_rcpts_tl_rec.sfwt_flag;
2742: END IF;
2743: IF (x_okl_ext_csh_rcpts_tl_rec.comments = Okl_Api.G_MISS_CHAR)
2744: THEN
2745: x_okl_ext_csh_rcpts_tl_rec.comments := l_okl_ext_csh_rcpts_tl_rec.comments;
2746: END IF;
2747: IF (x_okl_ext_csh_rcpts_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2748: THEN
2749: x_okl_ext_csh_rcpts_tl_rec.created_by := l_okl_ext_csh_rcpts_tl_rec.created_by;

Line 2747: IF (x_okl_ext_csh_rcpts_tl_rec.created_by = Okl_Api.G_MISS_NUM)

2743: IF (x_okl_ext_csh_rcpts_tl_rec.comments = Okl_Api.G_MISS_CHAR)
2744: THEN
2745: x_okl_ext_csh_rcpts_tl_rec.comments := l_okl_ext_csh_rcpts_tl_rec.comments;
2746: END IF;
2747: IF (x_okl_ext_csh_rcpts_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2748: THEN
2749: x_okl_ext_csh_rcpts_tl_rec.created_by := l_okl_ext_csh_rcpts_tl_rec.created_by;
2750: END IF;
2751: IF (x_okl_ext_csh_rcpts_tl_rec.creation_date = Okl_Api.G_MISS_DATE)

Line 2749: x_okl_ext_csh_rcpts_tl_rec.created_by := l_okl_ext_csh_rcpts_tl_rec.created_by;

2745: x_okl_ext_csh_rcpts_tl_rec.comments := l_okl_ext_csh_rcpts_tl_rec.comments;
2746: END IF;
2747: IF (x_okl_ext_csh_rcpts_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2748: THEN
2749: x_okl_ext_csh_rcpts_tl_rec.created_by := l_okl_ext_csh_rcpts_tl_rec.created_by;
2750: END IF;
2751: IF (x_okl_ext_csh_rcpts_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2752: THEN
2753: x_okl_ext_csh_rcpts_tl_rec.creation_date := l_okl_ext_csh_rcpts_tl_rec.creation_date;

Line 2751: IF (x_okl_ext_csh_rcpts_tl_rec.creation_date = Okl_Api.G_MISS_DATE)

2747: IF (x_okl_ext_csh_rcpts_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2748: THEN
2749: x_okl_ext_csh_rcpts_tl_rec.created_by := l_okl_ext_csh_rcpts_tl_rec.created_by;
2750: END IF;
2751: IF (x_okl_ext_csh_rcpts_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2752: THEN
2753: x_okl_ext_csh_rcpts_tl_rec.creation_date := l_okl_ext_csh_rcpts_tl_rec.creation_date;
2754: END IF;
2755: IF (x_okl_ext_csh_rcpts_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)

Line 2753: x_okl_ext_csh_rcpts_tl_rec.creation_date := l_okl_ext_csh_rcpts_tl_rec.creation_date;

2749: x_okl_ext_csh_rcpts_tl_rec.created_by := l_okl_ext_csh_rcpts_tl_rec.created_by;
2750: END IF;
2751: IF (x_okl_ext_csh_rcpts_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2752: THEN
2753: x_okl_ext_csh_rcpts_tl_rec.creation_date := l_okl_ext_csh_rcpts_tl_rec.creation_date;
2754: END IF;
2755: IF (x_okl_ext_csh_rcpts_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2756: THEN
2757: x_okl_ext_csh_rcpts_tl_rec.last_updated_by := l_okl_ext_csh_rcpts_tl_rec.last_updated_by;

Line 2755: IF (x_okl_ext_csh_rcpts_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)

2751: IF (x_okl_ext_csh_rcpts_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2752: THEN
2753: x_okl_ext_csh_rcpts_tl_rec.creation_date := l_okl_ext_csh_rcpts_tl_rec.creation_date;
2754: END IF;
2755: IF (x_okl_ext_csh_rcpts_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2756: THEN
2757: x_okl_ext_csh_rcpts_tl_rec.last_updated_by := l_okl_ext_csh_rcpts_tl_rec.last_updated_by;
2758: END IF;
2759: IF (x_okl_ext_csh_rcpts_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)

Line 2757: x_okl_ext_csh_rcpts_tl_rec.last_updated_by := l_okl_ext_csh_rcpts_tl_rec.last_updated_by;

2753: x_okl_ext_csh_rcpts_tl_rec.creation_date := l_okl_ext_csh_rcpts_tl_rec.creation_date;
2754: END IF;
2755: IF (x_okl_ext_csh_rcpts_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2756: THEN
2757: x_okl_ext_csh_rcpts_tl_rec.last_updated_by := l_okl_ext_csh_rcpts_tl_rec.last_updated_by;
2758: END IF;
2759: IF (x_okl_ext_csh_rcpts_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2760: THEN
2761: x_okl_ext_csh_rcpts_tl_rec.last_update_date := l_okl_ext_csh_rcpts_tl_rec.last_update_date;

Line 2759: IF (x_okl_ext_csh_rcpts_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)

2755: IF (x_okl_ext_csh_rcpts_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2756: THEN
2757: x_okl_ext_csh_rcpts_tl_rec.last_updated_by := l_okl_ext_csh_rcpts_tl_rec.last_updated_by;
2758: END IF;
2759: IF (x_okl_ext_csh_rcpts_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2760: THEN
2761: x_okl_ext_csh_rcpts_tl_rec.last_update_date := l_okl_ext_csh_rcpts_tl_rec.last_update_date;
2762: END IF;
2763: IF (x_okl_ext_csh_rcpts_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)

Line 2761: x_okl_ext_csh_rcpts_tl_rec.last_update_date := l_okl_ext_csh_rcpts_tl_rec.last_update_date;

2757: x_okl_ext_csh_rcpts_tl_rec.last_updated_by := l_okl_ext_csh_rcpts_tl_rec.last_updated_by;
2758: END IF;
2759: IF (x_okl_ext_csh_rcpts_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2760: THEN
2761: x_okl_ext_csh_rcpts_tl_rec.last_update_date := l_okl_ext_csh_rcpts_tl_rec.last_update_date;
2762: END IF;
2763: IF (x_okl_ext_csh_rcpts_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2764: THEN
2765: x_okl_ext_csh_rcpts_tl_rec.last_update_login := l_okl_ext_csh_rcpts_tl_rec.last_update_login;

Line 2763: IF (x_okl_ext_csh_rcpts_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)

2759: IF (x_okl_ext_csh_rcpts_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2760: THEN
2761: x_okl_ext_csh_rcpts_tl_rec.last_update_date := l_okl_ext_csh_rcpts_tl_rec.last_update_date;
2762: END IF;
2763: IF (x_okl_ext_csh_rcpts_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2764: THEN
2765: x_okl_ext_csh_rcpts_tl_rec.last_update_login := l_okl_ext_csh_rcpts_tl_rec.last_update_login;
2766: END IF;
2767: RETURN(l_return_status);

Line 2765: x_okl_ext_csh_rcpts_tl_rec.last_update_login := l_okl_ext_csh_rcpts_tl_rec.last_update_login;

2761: x_okl_ext_csh_rcpts_tl_rec.last_update_date := l_okl_ext_csh_rcpts_tl_rec.last_update_date;
2762: END IF;
2763: IF (x_okl_ext_csh_rcpts_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2764: THEN
2765: x_okl_ext_csh_rcpts_tl_rec.last_update_login := l_okl_ext_csh_rcpts_tl_rec.last_update_login;
2766: END IF;
2767: RETURN(l_return_status);
2768: END populate_new_record;
2769: ---------------------------------------------

Line 2770: -- Set_Attributes for:OKL_EXT_CSH_RCPTS_TL --

2766: END IF;
2767: RETURN(l_return_status);
2768: END populate_new_record;
2769: ---------------------------------------------
2770: -- Set_Attributes for:OKL_EXT_CSH_RCPTS_TL --
2771: ---------------------------------------------
2772: FUNCTION Set_Attributes (
2773: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
2774: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type

Line 2773: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,

2769: ---------------------------------------------
2770: -- Set_Attributes for:OKL_EXT_CSH_RCPTS_TL --
2771: ---------------------------------------------
2772: FUNCTION Set_Attributes (
2773: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
2774: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type
2775: ) RETURN VARCHAR2 IS
2776: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2777: BEGIN

Line 2774: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type

2770: -- Set_Attributes for:OKL_EXT_CSH_RCPTS_TL --
2771: ---------------------------------------------
2772: FUNCTION Set_Attributes (
2773: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
2774: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type
2775: ) RETURN VARCHAR2 IS
2776: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2777: BEGIN
2778: x_okl_ext_csh_rcpts_tl_rec := p_okl_ext_csh_rcpts_tl_rec;

Line 2778: x_okl_ext_csh_rcpts_tl_rec := p_okl_ext_csh_rcpts_tl_rec;

2774: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type
2775: ) RETURN VARCHAR2 IS
2776: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2777: BEGIN
2778: x_okl_ext_csh_rcpts_tl_rec := p_okl_ext_csh_rcpts_tl_rec;
2779: x_okl_ext_csh_rcpts_tl_rec.LANGUAGE := USERENV('LANG');
2780: x_okl_ext_csh_rcpts_tl_rec.SOURCE_LANG := USERENV('LANG');
2781: RETURN(l_return_status);
2782: END Set_Attributes;

Line 2779: x_okl_ext_csh_rcpts_tl_rec.LANGUAGE := USERENV('LANG');

2775: ) RETURN VARCHAR2 IS
2776: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2777: BEGIN
2778: x_okl_ext_csh_rcpts_tl_rec := p_okl_ext_csh_rcpts_tl_rec;
2779: x_okl_ext_csh_rcpts_tl_rec.LANGUAGE := USERENV('LANG');
2780: x_okl_ext_csh_rcpts_tl_rec.SOURCE_LANG := USERENV('LANG');
2781: RETURN(l_return_status);
2782: END Set_Attributes;
2783: BEGIN

Line 2780: x_okl_ext_csh_rcpts_tl_rec.SOURCE_LANG := USERENV('LANG');

2776: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2777: BEGIN
2778: x_okl_ext_csh_rcpts_tl_rec := p_okl_ext_csh_rcpts_tl_rec;
2779: x_okl_ext_csh_rcpts_tl_rec.LANGUAGE := USERENV('LANG');
2780: x_okl_ext_csh_rcpts_tl_rec.SOURCE_LANG := USERENV('LANG');
2781: RETURN(l_return_status);
2782: END Set_Attributes;
2783: BEGIN
2784: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 2795: p_okl_ext_csh_rcpts_tl_rec, -- IN

2791: RAISE Okl_Api.G_EXCEPTION_ERROR;
2792: END IF;
2793: --- Setting item attributes
2794: l_return_status := Set_Attributes(
2795: p_okl_ext_csh_rcpts_tl_rec, -- IN
2796: l_okl_ext_csh_rcpts_tl_rec); -- OUT
2797: --- If any errors happen abort API
2798: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2799: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2796: l_okl_ext_csh_rcpts_tl_rec); -- OUT

2792: END IF;
2793: --- Setting item attributes
2794: l_return_status := Set_Attributes(
2795: p_okl_ext_csh_rcpts_tl_rec, -- IN
2796: l_okl_ext_csh_rcpts_tl_rec); -- OUT
2797: --- If any errors happen abort API
2798: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2799: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2800: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2803: l_return_status := populate_new_record(l_okl_ext_csh_rcpts_tl_rec, ldefoklextcshrcptstlrec);

2799: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2800: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2801: RAISE Okl_Api.G_EXCEPTION_ERROR;
2802: END IF;
2803: l_return_status := populate_new_record(l_okl_ext_csh_rcpts_tl_rec, ldefoklextcshrcptstlrec);
2804: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2805: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2806: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2807: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 2809: UPDATE OKL_EXT_CSH_RCPTS_TL

2805: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2806: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2807: RAISE Okl_Api.G_EXCEPTION_ERROR;
2808: END IF;
2809: UPDATE OKL_EXT_CSH_RCPTS_TL
2810: SET COMMENTS = ldefoklextcshrcptstlrec.comments,
2811: SOURCE_LANG = ldefoklextcshrcptstlrec.source_lang,
2812: CREATED_BY = ldefoklextcshrcptstlrec.created_by,
2813: CREATION_DATE = ldefoklextcshrcptstlrec.creation_date,

Line 2820: UPDATE OKL_EXT_CSH_RCPTS_TL

2816: LAST_UPDATE_LOGIN = ldefoklextcshrcptstlrec.last_update_login
2817: WHERE ID = ldefoklextcshrcptstlrec.id
2818: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2819:
2820: UPDATE OKL_EXT_CSH_RCPTS_TL
2821: SET SFWT_FLAG = 'Y'
2822: WHERE ID = ldefoklextcshrcptstlrec.id
2823: AND SOURCE_LANG <> USERENV('LANG');
2824:

Line 2825: x_okl_ext_csh_rcpts_tl_rec := ldefoklextcshrcptstlrec;

2821: SET SFWT_FLAG = 'Y'
2822: WHERE ID = ldefoklextcshrcptstlrec.id
2823: AND SOURCE_LANG <> USERENV('LANG');
2824:
2825: x_okl_ext_csh_rcpts_tl_rec := ldefoklextcshrcptstlrec;
2826: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2827: EXCEPTION
2828: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2829: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 2890: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;

2886: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2887: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2888: l_xcrv_rec xcrv_rec_type := p_xcrv_rec;
2889: l_def_xcrv_rec xcrv_rec_type;
2890: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
2891: lx_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
2892: l_xcr_rec xcr_rec_type;
2893: lx_xcr_rec xcr_rec_type;
2894: -------------------------------

Line 2891: lx_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;

2887: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2888: l_xcrv_rec xcrv_rec_type := p_xcrv_rec;
2889: l_def_xcrv_rec xcrv_rec_type;
2890: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
2891: lx_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
2892: l_xcr_rec xcr_rec_type;
2893: lx_xcr_rec xcr_rec_type;
2894: -------------------------------
2895: -- FUNCTION fill_who_columns --

Line 3228: migrate(l_def_xcrv_rec, l_okl_ext_csh_rcpts_tl_rec);

3224:
3225: --------------------------------------
3226: -- Move VIEW record to "Child" records
3227: --------------------------------------
3228: migrate(l_def_xcrv_rec, l_okl_ext_csh_rcpts_tl_rec);
3229: migrate(l_def_xcrv_rec, l_xcr_rec);
3230: --------------------------------------------
3231: -- Call the UPDATE_ROW for each child record
3232: --------------------------------------------

Line 3238: l_okl_ext_csh_rcpts_tl_rec,

3234: p_init_msg_list,
3235: x_return_status,
3236: x_msg_count,
3237: x_msg_data,
3238: l_okl_ext_csh_rcpts_tl_rec,
3239: lx_okl_ext_csh_rcpts_tl_rec
3240: );
3241: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3242: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3239: lx_okl_ext_csh_rcpts_tl_rec

3235: x_return_status,
3236: x_msg_count,
3237: x_msg_data,
3238: l_okl_ext_csh_rcpts_tl_rec,
3239: lx_okl_ext_csh_rcpts_tl_rec
3240: );
3241: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3242: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3243: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 3246: migrate(lx_okl_ext_csh_rcpts_tl_rec, l_def_xcrv_rec);

3242: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3243: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3244: RAISE Okl_Api.G_EXCEPTION_ERROR;
3245: END IF;
3246: migrate(lx_okl_ext_csh_rcpts_tl_rec, l_def_xcrv_rec);
3247: update_row(
3248: p_init_msg_list,
3249: x_return_status,
3250: x_msg_count,

Line 3447: -- delete_row for:OKL_EXT_CSH_RCPTS_TL --

3443: '_PVT'
3444: );
3445: END delete_row;
3446: -----------------------------------------
3447: -- delete_row for:OKL_EXT_CSH_RCPTS_TL --
3448: -----------------------------------------
3449: PROCEDURE delete_row(
3450: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
3451: x_return_status OUT NOCOPY VARCHAR2,

Line 3454: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type) IS

3450: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
3451: x_return_status OUT NOCOPY VARCHAR2,
3452: x_msg_count OUT NOCOPY NUMBER,
3453: x_msg_data OUT NOCOPY VARCHAR2,
3454: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type) IS
3455:
3456: l_api_version CONSTANT NUMBER := 1;
3457: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3458: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 3459: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type:= p_okl_ext_csh_rcpts_tl_rec;

3455:
3456: l_api_version CONSTANT NUMBER := 1;
3457: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3458: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3459: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type:= p_okl_ext_csh_rcpts_tl_rec;
3460: l_row_notfound BOOLEAN := TRUE;
3461: ---------------------------------------------
3462: -- Set_Attributes for:OKL_EXT_CSH_RCPTS_TL --
3463: ---------------------------------------------

Line 3462: -- Set_Attributes for:OKL_EXT_CSH_RCPTS_TL --

3458: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3459: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type:= p_okl_ext_csh_rcpts_tl_rec;
3460: l_row_notfound BOOLEAN := TRUE;
3461: ---------------------------------------------
3462: -- Set_Attributes for:OKL_EXT_CSH_RCPTS_TL --
3463: ---------------------------------------------
3464: FUNCTION Set_Attributes (
3465: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
3466: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type

Line 3465: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,

3461: ---------------------------------------------
3462: -- Set_Attributes for:OKL_EXT_CSH_RCPTS_TL --
3463: ---------------------------------------------
3464: FUNCTION Set_Attributes (
3465: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
3466: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type
3467: ) RETURN VARCHAR2 IS
3468: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3469: BEGIN

Line 3466: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type

3462: -- Set_Attributes for:OKL_EXT_CSH_RCPTS_TL --
3463: ---------------------------------------------
3464: FUNCTION Set_Attributes (
3465: p_okl_ext_csh_rcpts_tl_rec IN okl_ext_csh_rcpts_tl_rec_type,
3466: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type
3467: ) RETURN VARCHAR2 IS
3468: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3469: BEGIN
3470: x_okl_ext_csh_rcpts_tl_rec := p_okl_ext_csh_rcpts_tl_rec;

Line 3470: x_okl_ext_csh_rcpts_tl_rec := p_okl_ext_csh_rcpts_tl_rec;

3466: x_okl_ext_csh_rcpts_tl_rec OUT NOCOPY okl_ext_csh_rcpts_tl_rec_type
3467: ) RETURN VARCHAR2 IS
3468: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3469: BEGIN
3470: x_okl_ext_csh_rcpts_tl_rec := p_okl_ext_csh_rcpts_tl_rec;
3471: x_okl_ext_csh_rcpts_tl_rec.LANGUAGE := USERENV('LANG');
3472: RETURN(l_return_status);
3473: END Set_Attributes;
3474: BEGIN

Line 3471: x_okl_ext_csh_rcpts_tl_rec.LANGUAGE := USERENV('LANG');

3467: ) RETURN VARCHAR2 IS
3468: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3469: BEGIN
3470: x_okl_ext_csh_rcpts_tl_rec := p_okl_ext_csh_rcpts_tl_rec;
3471: x_okl_ext_csh_rcpts_tl_rec.LANGUAGE := USERENV('LANG');
3472: RETURN(l_return_status);
3473: END Set_Attributes;
3474: BEGIN
3475: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 3486: p_okl_ext_csh_rcpts_tl_rec, -- IN

3482: RAISE Okl_Api.G_EXCEPTION_ERROR;
3483: END IF;
3484: --- Setting item attributes
3485: l_return_status := Set_Attributes(
3486: p_okl_ext_csh_rcpts_tl_rec, -- IN
3487: l_okl_ext_csh_rcpts_tl_rec); -- OUT
3488: --- If any errors happen abort API
3489: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3490: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3487: l_okl_ext_csh_rcpts_tl_rec); -- OUT

3483: END IF;
3484: --- Setting item attributes
3485: l_return_status := Set_Attributes(
3486: p_okl_ext_csh_rcpts_tl_rec, -- IN
3487: l_okl_ext_csh_rcpts_tl_rec); -- OUT
3488: --- If any errors happen abort API
3489: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3490: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3491: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 3494: DELETE FROM OKL_EXT_CSH_RCPTS_TL

3490: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3491: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3492: RAISE Okl_Api.G_EXCEPTION_ERROR;
3493: END IF;
3494: DELETE FROM OKL_EXT_CSH_RCPTS_TL
3495: WHERE ID = l_okl_ext_csh_rcpts_tl_rec.id;
3496:
3497: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3498: EXCEPTION

Line 3495: WHERE ID = l_okl_ext_csh_rcpts_tl_rec.id;

3491: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3492: RAISE Okl_Api.G_EXCEPTION_ERROR;
3493: END IF;
3494: DELETE FROM OKL_EXT_CSH_RCPTS_TL
3495: WHERE ID = l_okl_ext_csh_rcpts_tl_rec.id;
3496:
3497: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3498: EXCEPTION
3499: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

Line 3545: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;

3541: l_api_version CONSTANT NUMBER := 1;
3542: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3543: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3544: l_xcrv_rec xcrv_rec_type := p_xcrv_rec;
3545: l_okl_ext_csh_rcpts_tl_rec okl_ext_csh_rcpts_tl_rec_type;
3546: l_xcr_rec xcr_rec_type;
3547: BEGIN
3548: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
3549: G_PKG_NAME,

Line 3563: migrate(l_xcrv_rec, l_okl_ext_csh_rcpts_tl_rec);

3559: END IF;
3560: --------------------------------------
3561: -- Move VIEW record to "Child" records
3562: --------------------------------------
3563: migrate(l_xcrv_rec, l_okl_ext_csh_rcpts_tl_rec);
3564: migrate(l_xcrv_rec, l_xcr_rec);
3565: --------------------------------------------
3566: -- Call the DELETE_ROW for each child record
3567: --------------------------------------------

Line 3573: l_okl_ext_csh_rcpts_tl_rec

3569: p_init_msg_list,
3570: x_return_status,
3571: x_msg_count,
3572: x_msg_data,
3573: l_okl_ext_csh_rcpts_tl_rec
3574: );
3575: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3576: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3577: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN