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_BTC_PVT dependencies on OKL_TRX_CSH_BATCH_TL

Line 40: DELETE FROM OKL_TRX_CSH_BATCH_TL T

36: -- PROCEDURE add_language
37: ---------------------------------------------------------------------------
38: PROCEDURE add_language IS
39: BEGIN
40: DELETE FROM OKL_TRX_CSH_BATCH_TL T
41: WHERE NOT EXISTS (
42: SELECT NULL
43: FROM OKL_TRX_CSH_BATCH_ALL_B B --fixed bug 3321017 by kmotepal
44: WHERE B.ID = T.ID

Line 47: UPDATE OKL_TRX_CSH_BATCH_TL T SET (

43: FROM OKL_TRX_CSH_BATCH_ALL_B B --fixed bug 3321017 by kmotepal
44: WHERE B.ID = T.ID
45: );
46:
47: UPDATE OKL_TRX_CSH_BATCH_TL T SET (
48: NAME,
49: DESCRIPTION) = (SELECT
50: B.NAME,
51: B.DESCRIPTION

Line 52: FROM OKL_TRX_CSH_BATCH_TL B

48: NAME,
49: DESCRIPTION) = (SELECT
50: B.NAME,
51: B.DESCRIPTION
52: FROM OKL_TRX_CSH_BATCH_TL B
53: WHERE B.ID = T.ID
54: AND B.LANGUAGE = T.SOURCE_LANG)
55: WHERE (
56: T.ID,

Line 61: FROM OKL_TRX_CSH_BATCH_TL SUBB, OKL_TRX_CSH_BATCH_TL SUBT

57: T.LANGUAGE)
58: IN (SELECT
59: SUBT.ID,
60: SUBT.LANGUAGE
61: FROM OKL_TRX_CSH_BATCH_TL SUBB, OKL_TRX_CSH_BATCH_TL SUBT
62: WHERE SUBB.ID = SUBT.ID
63: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
64: AND (SUBB.NAME <> SUBT.NAME
65: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 70: INSERT INTO OKL_TRX_CSH_BATCH_TL (

66: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
67: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
68: ));
69:
70: INSERT INTO OKL_TRX_CSH_BATCH_TL (
71: ID,
72: LANGUAGE,
73: SOURCE_LANG,
74: SFWT_FLAG,

Line 94: FROM OKL_TRX_CSH_BATCH_TL B, FND_LANGUAGES L

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

Line 99: FROM OKL_TRX_CSH_BATCH_TL T

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

Line 215: -- FUNCTION get_rec for: OKL_TRX_CSH_BATCH_TL

211: BEGIN
212: RETURN(get_rec(p_btc_rec, l_row_notfound));
213: END get_rec;
214: ---------------------------------------------------------------------------
215: -- FUNCTION get_rec for: OKL_TRX_CSH_BATCH_TL
216: ---------------------------------------------------------------------------
217: FUNCTION get_rec (
218: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
219: x_no_data_found OUT NOCOPY BOOLEAN

Line 218: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,

214: ---------------------------------------------------------------------------
215: -- FUNCTION get_rec for: OKL_TRX_CSH_BATCH_TL
216: ---------------------------------------------------------------------------
217: FUNCTION get_rec (
218: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
219: x_no_data_found OUT NOCOPY BOOLEAN
220: ) RETURN okl_trx_csh_batch_tl_rec_type IS
221: CURSOR okl_trx_csh_batch_tl_pk_csr (p_id IN NUMBER,
222: p_language IN VARCHAR2) IS

Line 220: ) RETURN okl_trx_csh_batch_tl_rec_type IS

216: ---------------------------------------------------------------------------
217: FUNCTION get_rec (
218: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
219: x_no_data_found OUT NOCOPY BOOLEAN
220: ) RETURN okl_trx_csh_batch_tl_rec_type IS
221: CURSOR okl_trx_csh_batch_tl_pk_csr (p_id IN NUMBER,
222: p_language IN VARCHAR2) IS
223: SELECT
224: ID,

Line 221: CURSOR okl_trx_csh_batch_tl_pk_csr (p_id IN NUMBER,

217: FUNCTION get_rec (
218: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
219: x_no_data_found OUT NOCOPY BOOLEAN
220: ) RETURN okl_trx_csh_batch_tl_rec_type IS
221: CURSOR okl_trx_csh_batch_tl_pk_csr (p_id IN NUMBER,
222: p_language IN VARCHAR2) IS
223: SELECT
224: ID,
225: LANGUAGE,

Line 235: FROM Okl_Trx_Csh_Batch_Tl

231: CREATION_DATE,
232: LAST_UPDATED_BY,
233: LAST_UPDATE_DATE,
234: LAST_UPDATE_LOGIN
235: FROM Okl_Trx_Csh_Batch_Tl
236: WHERE okl_trx_csh_batch_tl.id = p_id
237: AND okl_trx_csh_batch_tl.LANGUAGE = p_language;
238: l_okl_trx_csh_batch_tl_pk okl_trx_csh_batch_tl_pk_csr%ROWTYPE;
239: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;

Line 236: WHERE okl_trx_csh_batch_tl.id = p_id

232: LAST_UPDATED_BY,
233: LAST_UPDATE_DATE,
234: LAST_UPDATE_LOGIN
235: FROM Okl_Trx_Csh_Batch_Tl
236: WHERE okl_trx_csh_batch_tl.id = p_id
237: AND okl_trx_csh_batch_tl.LANGUAGE = p_language;
238: l_okl_trx_csh_batch_tl_pk okl_trx_csh_batch_tl_pk_csr%ROWTYPE;
239: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
240: BEGIN

Line 237: AND okl_trx_csh_batch_tl.LANGUAGE = p_language;

233: LAST_UPDATE_DATE,
234: LAST_UPDATE_LOGIN
235: FROM Okl_Trx_Csh_Batch_Tl
236: WHERE okl_trx_csh_batch_tl.id = p_id
237: AND okl_trx_csh_batch_tl.LANGUAGE = p_language;
238: l_okl_trx_csh_batch_tl_pk okl_trx_csh_batch_tl_pk_csr%ROWTYPE;
239: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
240: BEGIN
241: x_no_data_found := TRUE;

Line 238: l_okl_trx_csh_batch_tl_pk okl_trx_csh_batch_tl_pk_csr%ROWTYPE;

234: LAST_UPDATE_LOGIN
235: FROM Okl_Trx_Csh_Batch_Tl
236: WHERE okl_trx_csh_batch_tl.id = p_id
237: AND okl_trx_csh_batch_tl.LANGUAGE = p_language;
238: l_okl_trx_csh_batch_tl_pk okl_trx_csh_batch_tl_pk_csr%ROWTYPE;
239: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
240: BEGIN
241: x_no_data_found := TRUE;
242: -- Get current database values

Line 239: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;

235: FROM Okl_Trx_Csh_Batch_Tl
236: WHERE okl_trx_csh_batch_tl.id = p_id
237: AND okl_trx_csh_batch_tl.LANGUAGE = p_language;
238: l_okl_trx_csh_batch_tl_pk okl_trx_csh_batch_tl_pk_csr%ROWTYPE;
239: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
240: BEGIN
241: x_no_data_found := TRUE;
242: -- Get current database values
243: OPEN okl_trx_csh_batch_tl_pk_csr (p_okl_trx_csh_batch_tl_rec.id,

Line 243: OPEN okl_trx_csh_batch_tl_pk_csr (p_okl_trx_csh_batch_tl_rec.id,

239: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
240: BEGIN
241: x_no_data_found := TRUE;
242: -- Get current database values
243: OPEN okl_trx_csh_batch_tl_pk_csr (p_okl_trx_csh_batch_tl_rec.id,
244: p_okl_trx_csh_batch_tl_rec.LANGUAGE);
245: FETCH okl_trx_csh_batch_tl_pk_csr INTO
246: l_okl_trx_csh_batch_tl_rec.ID,
247: l_okl_trx_csh_batch_tl_rec.LANGUAGE,

Line 244: p_okl_trx_csh_batch_tl_rec.LANGUAGE);

240: BEGIN
241: x_no_data_found := TRUE;
242: -- Get current database values
243: OPEN okl_trx_csh_batch_tl_pk_csr (p_okl_trx_csh_batch_tl_rec.id,
244: p_okl_trx_csh_batch_tl_rec.LANGUAGE);
245: FETCH okl_trx_csh_batch_tl_pk_csr INTO
246: l_okl_trx_csh_batch_tl_rec.ID,
247: l_okl_trx_csh_batch_tl_rec.LANGUAGE,
248: l_okl_trx_csh_batch_tl_rec.SOURCE_LANG,

Line 245: FETCH okl_trx_csh_batch_tl_pk_csr INTO

241: x_no_data_found := TRUE;
242: -- Get current database values
243: OPEN okl_trx_csh_batch_tl_pk_csr (p_okl_trx_csh_batch_tl_rec.id,
244: p_okl_trx_csh_batch_tl_rec.LANGUAGE);
245: FETCH okl_trx_csh_batch_tl_pk_csr INTO
246: l_okl_trx_csh_batch_tl_rec.ID,
247: l_okl_trx_csh_batch_tl_rec.LANGUAGE,
248: l_okl_trx_csh_batch_tl_rec.SOURCE_LANG,
249: l_okl_trx_csh_batch_tl_rec.SFWT_FLAG,

Line 246: l_okl_trx_csh_batch_tl_rec.ID,

242: -- Get current database values
243: OPEN okl_trx_csh_batch_tl_pk_csr (p_okl_trx_csh_batch_tl_rec.id,
244: p_okl_trx_csh_batch_tl_rec.LANGUAGE);
245: FETCH okl_trx_csh_batch_tl_pk_csr INTO
246: l_okl_trx_csh_batch_tl_rec.ID,
247: l_okl_trx_csh_batch_tl_rec.LANGUAGE,
248: l_okl_trx_csh_batch_tl_rec.SOURCE_LANG,
249: l_okl_trx_csh_batch_tl_rec.SFWT_FLAG,
250: l_okl_trx_csh_batch_tl_rec.NAME,

Line 247: l_okl_trx_csh_batch_tl_rec.LANGUAGE,

243: OPEN okl_trx_csh_batch_tl_pk_csr (p_okl_trx_csh_batch_tl_rec.id,
244: p_okl_trx_csh_batch_tl_rec.LANGUAGE);
245: FETCH okl_trx_csh_batch_tl_pk_csr INTO
246: l_okl_trx_csh_batch_tl_rec.ID,
247: l_okl_trx_csh_batch_tl_rec.LANGUAGE,
248: l_okl_trx_csh_batch_tl_rec.SOURCE_LANG,
249: l_okl_trx_csh_batch_tl_rec.SFWT_FLAG,
250: l_okl_trx_csh_batch_tl_rec.NAME,
251: l_okl_trx_csh_batch_tl_rec.DESCRIPTION,

Line 248: l_okl_trx_csh_batch_tl_rec.SOURCE_LANG,

244: p_okl_trx_csh_batch_tl_rec.LANGUAGE);
245: FETCH okl_trx_csh_batch_tl_pk_csr INTO
246: l_okl_trx_csh_batch_tl_rec.ID,
247: l_okl_trx_csh_batch_tl_rec.LANGUAGE,
248: l_okl_trx_csh_batch_tl_rec.SOURCE_LANG,
249: l_okl_trx_csh_batch_tl_rec.SFWT_FLAG,
250: l_okl_trx_csh_batch_tl_rec.NAME,
251: l_okl_trx_csh_batch_tl_rec.DESCRIPTION,
252: l_okl_trx_csh_batch_tl_rec.CREATED_BY,

Line 249: l_okl_trx_csh_batch_tl_rec.SFWT_FLAG,

245: FETCH okl_trx_csh_batch_tl_pk_csr INTO
246: l_okl_trx_csh_batch_tl_rec.ID,
247: l_okl_trx_csh_batch_tl_rec.LANGUAGE,
248: l_okl_trx_csh_batch_tl_rec.SOURCE_LANG,
249: l_okl_trx_csh_batch_tl_rec.SFWT_FLAG,
250: l_okl_trx_csh_batch_tl_rec.NAME,
251: l_okl_trx_csh_batch_tl_rec.DESCRIPTION,
252: l_okl_trx_csh_batch_tl_rec.CREATED_BY,
253: l_okl_trx_csh_batch_tl_rec.CREATION_DATE,

Line 250: l_okl_trx_csh_batch_tl_rec.NAME,

246: l_okl_trx_csh_batch_tl_rec.ID,
247: l_okl_trx_csh_batch_tl_rec.LANGUAGE,
248: l_okl_trx_csh_batch_tl_rec.SOURCE_LANG,
249: l_okl_trx_csh_batch_tl_rec.SFWT_FLAG,
250: l_okl_trx_csh_batch_tl_rec.NAME,
251: l_okl_trx_csh_batch_tl_rec.DESCRIPTION,
252: l_okl_trx_csh_batch_tl_rec.CREATED_BY,
253: l_okl_trx_csh_batch_tl_rec.CREATION_DATE,
254: l_okl_trx_csh_batch_tl_rec.LAST_UPDATED_BY,

Line 251: l_okl_trx_csh_batch_tl_rec.DESCRIPTION,

247: l_okl_trx_csh_batch_tl_rec.LANGUAGE,
248: l_okl_trx_csh_batch_tl_rec.SOURCE_LANG,
249: l_okl_trx_csh_batch_tl_rec.SFWT_FLAG,
250: l_okl_trx_csh_batch_tl_rec.NAME,
251: l_okl_trx_csh_batch_tl_rec.DESCRIPTION,
252: l_okl_trx_csh_batch_tl_rec.CREATED_BY,
253: l_okl_trx_csh_batch_tl_rec.CREATION_DATE,
254: l_okl_trx_csh_batch_tl_rec.LAST_UPDATED_BY,
255: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_DATE,

Line 252: l_okl_trx_csh_batch_tl_rec.CREATED_BY,

248: l_okl_trx_csh_batch_tl_rec.SOURCE_LANG,
249: l_okl_trx_csh_batch_tl_rec.SFWT_FLAG,
250: l_okl_trx_csh_batch_tl_rec.NAME,
251: l_okl_trx_csh_batch_tl_rec.DESCRIPTION,
252: l_okl_trx_csh_batch_tl_rec.CREATED_BY,
253: l_okl_trx_csh_batch_tl_rec.CREATION_DATE,
254: l_okl_trx_csh_batch_tl_rec.LAST_UPDATED_BY,
255: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_DATE,
256: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_LOGIN;

Line 253: l_okl_trx_csh_batch_tl_rec.CREATION_DATE,

249: l_okl_trx_csh_batch_tl_rec.SFWT_FLAG,
250: l_okl_trx_csh_batch_tl_rec.NAME,
251: l_okl_trx_csh_batch_tl_rec.DESCRIPTION,
252: l_okl_trx_csh_batch_tl_rec.CREATED_BY,
253: l_okl_trx_csh_batch_tl_rec.CREATION_DATE,
254: l_okl_trx_csh_batch_tl_rec.LAST_UPDATED_BY,
255: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_DATE,
256: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_LOGIN;
257: x_no_data_found := okl_trx_csh_batch_tl_pk_csr%NOTFOUND;

Line 254: l_okl_trx_csh_batch_tl_rec.LAST_UPDATED_BY,

250: l_okl_trx_csh_batch_tl_rec.NAME,
251: l_okl_trx_csh_batch_tl_rec.DESCRIPTION,
252: l_okl_trx_csh_batch_tl_rec.CREATED_BY,
253: l_okl_trx_csh_batch_tl_rec.CREATION_DATE,
254: l_okl_trx_csh_batch_tl_rec.LAST_UPDATED_BY,
255: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_DATE,
256: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_LOGIN;
257: x_no_data_found := okl_trx_csh_batch_tl_pk_csr%NOTFOUND;
258: CLOSE okl_trx_csh_batch_tl_pk_csr;

Line 255: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_DATE,

251: l_okl_trx_csh_batch_tl_rec.DESCRIPTION,
252: l_okl_trx_csh_batch_tl_rec.CREATED_BY,
253: l_okl_trx_csh_batch_tl_rec.CREATION_DATE,
254: l_okl_trx_csh_batch_tl_rec.LAST_UPDATED_BY,
255: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_DATE,
256: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_LOGIN;
257: x_no_data_found := okl_trx_csh_batch_tl_pk_csr%NOTFOUND;
258: CLOSE okl_trx_csh_batch_tl_pk_csr;
259: RETURN(l_okl_trx_csh_batch_tl_rec);

Line 256: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_LOGIN;

252: l_okl_trx_csh_batch_tl_rec.CREATED_BY,
253: l_okl_trx_csh_batch_tl_rec.CREATION_DATE,
254: l_okl_trx_csh_batch_tl_rec.LAST_UPDATED_BY,
255: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_DATE,
256: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_LOGIN;
257: x_no_data_found := okl_trx_csh_batch_tl_pk_csr%NOTFOUND;
258: CLOSE okl_trx_csh_batch_tl_pk_csr;
259: RETURN(l_okl_trx_csh_batch_tl_rec);
260: END get_rec;

Line 257: x_no_data_found := okl_trx_csh_batch_tl_pk_csr%NOTFOUND;

253: l_okl_trx_csh_batch_tl_rec.CREATION_DATE,
254: l_okl_trx_csh_batch_tl_rec.LAST_UPDATED_BY,
255: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_DATE,
256: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_LOGIN;
257: x_no_data_found := okl_trx_csh_batch_tl_pk_csr%NOTFOUND;
258: CLOSE okl_trx_csh_batch_tl_pk_csr;
259: RETURN(l_okl_trx_csh_batch_tl_rec);
260: END get_rec;
261:

Line 258: CLOSE okl_trx_csh_batch_tl_pk_csr;

254: l_okl_trx_csh_batch_tl_rec.LAST_UPDATED_BY,
255: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_DATE,
256: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_LOGIN;
257: x_no_data_found := okl_trx_csh_batch_tl_pk_csr%NOTFOUND;
258: CLOSE okl_trx_csh_batch_tl_pk_csr;
259: RETURN(l_okl_trx_csh_batch_tl_rec);
260: END get_rec;
261:
262: FUNCTION get_rec (

Line 259: RETURN(l_okl_trx_csh_batch_tl_rec);

255: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_DATE,
256: l_okl_trx_csh_batch_tl_rec.LAST_UPDATE_LOGIN;
257: x_no_data_found := okl_trx_csh_batch_tl_pk_csr%NOTFOUND;
258: CLOSE okl_trx_csh_batch_tl_pk_csr;
259: RETURN(l_okl_trx_csh_batch_tl_rec);
260: END get_rec;
261:
262: FUNCTION get_rec (
263: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type

Line 263: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type

259: RETURN(l_okl_trx_csh_batch_tl_rec);
260: END get_rec;
261:
262: FUNCTION get_rec (
263: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type
264: ) RETURN okl_trx_csh_batch_tl_rec_type IS
265: l_row_notfound BOOLEAN := TRUE;
266: BEGIN
267: RETURN(get_rec(p_okl_trx_csh_batch_tl_rec, l_row_notfound));

Line 264: ) RETURN okl_trx_csh_batch_tl_rec_type IS

260: END get_rec;
261:
262: FUNCTION get_rec (
263: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type
264: ) RETURN okl_trx_csh_batch_tl_rec_type IS
265: l_row_notfound BOOLEAN := TRUE;
266: BEGIN
267: RETURN(get_rec(p_okl_trx_csh_batch_tl_rec, l_row_notfound));
268: END get_rec;

Line 267: RETURN(get_rec(p_okl_trx_csh_batch_tl_rec, l_row_notfound));

263: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type
264: ) RETURN okl_trx_csh_batch_tl_rec_type IS
265: l_row_notfound BOOLEAN := TRUE;
266: BEGIN
267: RETURN(get_rec(p_okl_trx_csh_batch_tl_rec, l_row_notfound));
268: END get_rec;
269: ---------------------------------------------------------------------------
270: -- FUNCTION get_rec for: OKL_TRX_CSH_BATCH_V
271: ---------------------------------------------------------------------------

Line 1141: p_to IN OUT NOCOPY okl_trx_csh_batch_tl_rec_type

1137: p_to.REMIT_BANK_ID := p_from.REMIT_BANK_ID;
1138: END migrate;
1139: PROCEDURE migrate (
1140: p_from IN btcv_rec_type,
1141: p_to IN OUT NOCOPY okl_trx_csh_batch_tl_rec_type
1142: ) IS
1143: BEGIN
1144: p_to.id := p_from.id;
1145: p_to.sfwt_flag := p_from.sfwt_flag;

Line 1155: p_from IN okl_trx_csh_batch_tl_rec_type,

1151: p_to.last_update_date := p_from.last_update_date;
1152: p_to.last_update_login := p_from.last_update_login;
1153: END migrate;
1154: PROCEDURE migrate (
1155: p_from IN okl_trx_csh_batch_tl_rec_type,
1156: p_to IN OUT NOCOPY btcv_rec_type
1157: ) IS
1158: BEGIN
1159: p_to.id := p_from.id;

Line 1189: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;

1185: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1186: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1187: l_btcv_rec btcv_rec_type := p_btcv_rec;
1188: l_btc_rec btc_rec_type;
1189: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
1190: BEGIN
1191: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1192: G_PKG_NAME,
1193: p_init_msg_list,

Line 1501: -- insert_row for:OKL_TRX_CSH_BATCH_TL --

1497: '_PVT'
1498: );
1499: END insert_row;
1500: -----------------------------------------
1501: -- insert_row for:OKL_TRX_CSH_BATCH_TL --
1502: -----------------------------------------
1503: PROCEDURE insert_row(
1504: p_init_msg_list IN VARCHAR2,
1505: x_return_status OUT NOCOPY VARCHAR2,

Line 1508: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,

1504: p_init_msg_list IN VARCHAR2,
1505: x_return_status OUT NOCOPY VARCHAR2,
1506: x_msg_count OUT NOCOPY NUMBER,
1507: x_msg_data OUT NOCOPY VARCHAR2,
1508: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
1509: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type) IS
1510:
1511: l_api_version CONSTANT NUMBER := 1;
1512: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1509: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type) IS

1505: x_return_status OUT NOCOPY VARCHAR2,
1506: x_msg_count OUT NOCOPY NUMBER,
1507: x_msg_data OUT NOCOPY VARCHAR2,
1508: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
1509: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type) IS
1510:
1511: l_api_version CONSTANT NUMBER := 1;
1512: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1513: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 1514: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type := p_okl_trx_csh_batch_tl_rec;

1510:
1511: l_api_version CONSTANT NUMBER := 1;
1512: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1513: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1514: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type := p_okl_trx_csh_batch_tl_rec;
1515: ldefokltrxcshbatchtlrec okl_trx_csh_batch_tl_rec_type;
1516: CURSOR get_languages IS
1517: SELECT *
1518: FROM FND_LANGUAGES

Line 1515: ldefokltrxcshbatchtlrec okl_trx_csh_batch_tl_rec_type;

1511: l_api_version CONSTANT NUMBER := 1;
1512: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1513: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1514: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type := p_okl_trx_csh_batch_tl_rec;
1515: ldefokltrxcshbatchtlrec okl_trx_csh_batch_tl_rec_type;
1516: CURSOR get_languages IS
1517: SELECT *
1518: FROM FND_LANGUAGES
1519: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1521: -- Set_Attributes for:OKL_TRX_CSH_BATCH_TL --

1517: SELECT *
1518: FROM FND_LANGUAGES
1519: WHERE INSTALLED_FLAG IN ('I', 'B');
1520: ---------------------------------------------
1521: -- Set_Attributes for:OKL_TRX_CSH_BATCH_TL --
1522: ---------------------------------------------
1523: FUNCTION Set_Attributes (
1524: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
1525: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type

Line 1524: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,

1520: ---------------------------------------------
1521: -- Set_Attributes for:OKL_TRX_CSH_BATCH_TL --
1522: ---------------------------------------------
1523: FUNCTION Set_Attributes (
1524: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
1525: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type
1526: ) RETURN VARCHAR2 IS
1527: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1528: BEGIN

Line 1525: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type

1521: -- Set_Attributes for:OKL_TRX_CSH_BATCH_TL --
1522: ---------------------------------------------
1523: FUNCTION Set_Attributes (
1524: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
1525: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type
1526: ) RETURN VARCHAR2 IS
1527: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1528: BEGIN
1529: x_okl_trx_csh_batch_tl_rec := p_okl_trx_csh_batch_tl_rec;

Line 1529: x_okl_trx_csh_batch_tl_rec := p_okl_trx_csh_batch_tl_rec;

1525: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type
1526: ) RETURN VARCHAR2 IS
1527: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1528: BEGIN
1529: x_okl_trx_csh_batch_tl_rec := p_okl_trx_csh_batch_tl_rec;
1530: x_okl_trx_csh_batch_tl_rec.LANGUAGE := USERENV('LANG');
1531: x_okl_trx_csh_batch_tl_rec.SOURCE_LANG := USERENV('LANG');
1532: RETURN(l_return_status);
1533: END Set_Attributes;

Line 1530: x_okl_trx_csh_batch_tl_rec.LANGUAGE := USERENV('LANG');

1526: ) RETURN VARCHAR2 IS
1527: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1528: BEGIN
1529: x_okl_trx_csh_batch_tl_rec := p_okl_trx_csh_batch_tl_rec;
1530: x_okl_trx_csh_batch_tl_rec.LANGUAGE := USERENV('LANG');
1531: x_okl_trx_csh_batch_tl_rec.SOURCE_LANG := USERENV('LANG');
1532: RETURN(l_return_status);
1533: END Set_Attributes;
1534: BEGIN

Line 1531: x_okl_trx_csh_batch_tl_rec.SOURCE_LANG := USERENV('LANG');

1527: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1528: BEGIN
1529: x_okl_trx_csh_batch_tl_rec := p_okl_trx_csh_batch_tl_rec;
1530: x_okl_trx_csh_batch_tl_rec.LANGUAGE := USERENV('LANG');
1531: x_okl_trx_csh_batch_tl_rec.SOURCE_LANG := USERENV('LANG');
1532: RETURN(l_return_status);
1533: END Set_Attributes;
1534: BEGIN
1535: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 1546: p_okl_trx_csh_batch_tl_rec, -- IN

1542: RAISE Okl_Api.G_EXCEPTION_ERROR;
1543: END IF;
1544: --- Setting item attributes
1545: l_return_status := Set_Attributes(
1546: p_okl_trx_csh_batch_tl_rec, -- IN
1547: l_okl_trx_csh_batch_tl_rec); -- OUT
1548: --- If any errors happen abort API
1549: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1550: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1547: l_okl_trx_csh_batch_tl_rec); -- OUT

1543: END IF;
1544: --- Setting item attributes
1545: l_return_status := Set_Attributes(
1546: p_okl_trx_csh_batch_tl_rec, -- IN
1547: l_okl_trx_csh_batch_tl_rec); -- OUT
1548: --- If any errors happen abort API
1549: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1550: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1551: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 1555: l_okl_trx_csh_batch_tl_rec.LANGUAGE := l_lang_rec.language_code;

1551: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1552: RAISE Okl_Api.G_EXCEPTION_ERROR;
1553: END IF;
1554: FOR l_lang_rec IN get_languages LOOP
1555: l_okl_trx_csh_batch_tl_rec.LANGUAGE := l_lang_rec.language_code;
1556: INSERT INTO OKL_TRX_CSH_BATCH_TL(
1557: id,
1558: LANGUAGE,
1559: source_lang,

Line 1556: INSERT INTO OKL_TRX_CSH_BATCH_TL(

1552: RAISE Okl_Api.G_EXCEPTION_ERROR;
1553: END IF;
1554: FOR l_lang_rec IN get_languages LOOP
1555: l_okl_trx_csh_batch_tl_rec.LANGUAGE := l_lang_rec.language_code;
1556: INSERT INTO OKL_TRX_CSH_BATCH_TL(
1557: id,
1558: LANGUAGE,
1559: source_lang,
1560: sfwt_flag,

Line 1569: l_okl_trx_csh_batch_tl_rec.id,

1565: last_updated_by,
1566: last_update_date,
1567: last_update_login)
1568: VALUES (
1569: l_okl_trx_csh_batch_tl_rec.id,
1570: l_okl_trx_csh_batch_tl_rec.LANGUAGE,
1571: l_okl_trx_csh_batch_tl_rec.source_lang,
1572: l_okl_trx_csh_batch_tl_rec.sfwt_flag,
1573: l_okl_trx_csh_batch_tl_rec.name,

Line 1570: l_okl_trx_csh_batch_tl_rec.LANGUAGE,

1566: last_update_date,
1567: last_update_login)
1568: VALUES (
1569: l_okl_trx_csh_batch_tl_rec.id,
1570: l_okl_trx_csh_batch_tl_rec.LANGUAGE,
1571: l_okl_trx_csh_batch_tl_rec.source_lang,
1572: l_okl_trx_csh_batch_tl_rec.sfwt_flag,
1573: l_okl_trx_csh_batch_tl_rec.name,
1574: l_okl_trx_csh_batch_tl_rec.description,

Line 1571: l_okl_trx_csh_batch_tl_rec.source_lang,

1567: last_update_login)
1568: VALUES (
1569: l_okl_trx_csh_batch_tl_rec.id,
1570: l_okl_trx_csh_batch_tl_rec.LANGUAGE,
1571: l_okl_trx_csh_batch_tl_rec.source_lang,
1572: l_okl_trx_csh_batch_tl_rec.sfwt_flag,
1573: l_okl_trx_csh_batch_tl_rec.name,
1574: l_okl_trx_csh_batch_tl_rec.description,
1575: l_okl_trx_csh_batch_tl_rec.created_by,

Line 1572: l_okl_trx_csh_batch_tl_rec.sfwt_flag,

1568: VALUES (
1569: l_okl_trx_csh_batch_tl_rec.id,
1570: l_okl_trx_csh_batch_tl_rec.LANGUAGE,
1571: l_okl_trx_csh_batch_tl_rec.source_lang,
1572: l_okl_trx_csh_batch_tl_rec.sfwt_flag,
1573: l_okl_trx_csh_batch_tl_rec.name,
1574: l_okl_trx_csh_batch_tl_rec.description,
1575: l_okl_trx_csh_batch_tl_rec.created_by,
1576: l_okl_trx_csh_batch_tl_rec.creation_date,

Line 1573: l_okl_trx_csh_batch_tl_rec.name,

1569: l_okl_trx_csh_batch_tl_rec.id,
1570: l_okl_trx_csh_batch_tl_rec.LANGUAGE,
1571: l_okl_trx_csh_batch_tl_rec.source_lang,
1572: l_okl_trx_csh_batch_tl_rec.sfwt_flag,
1573: l_okl_trx_csh_batch_tl_rec.name,
1574: l_okl_trx_csh_batch_tl_rec.description,
1575: l_okl_trx_csh_batch_tl_rec.created_by,
1576: l_okl_trx_csh_batch_tl_rec.creation_date,
1577: l_okl_trx_csh_batch_tl_rec.last_updated_by,

Line 1574: l_okl_trx_csh_batch_tl_rec.description,

1570: l_okl_trx_csh_batch_tl_rec.LANGUAGE,
1571: l_okl_trx_csh_batch_tl_rec.source_lang,
1572: l_okl_trx_csh_batch_tl_rec.sfwt_flag,
1573: l_okl_trx_csh_batch_tl_rec.name,
1574: l_okl_trx_csh_batch_tl_rec.description,
1575: l_okl_trx_csh_batch_tl_rec.created_by,
1576: l_okl_trx_csh_batch_tl_rec.creation_date,
1577: l_okl_trx_csh_batch_tl_rec.last_updated_by,
1578: l_okl_trx_csh_batch_tl_rec.last_update_date,

Line 1575: l_okl_trx_csh_batch_tl_rec.created_by,

1571: l_okl_trx_csh_batch_tl_rec.source_lang,
1572: l_okl_trx_csh_batch_tl_rec.sfwt_flag,
1573: l_okl_trx_csh_batch_tl_rec.name,
1574: l_okl_trx_csh_batch_tl_rec.description,
1575: l_okl_trx_csh_batch_tl_rec.created_by,
1576: l_okl_trx_csh_batch_tl_rec.creation_date,
1577: l_okl_trx_csh_batch_tl_rec.last_updated_by,
1578: l_okl_trx_csh_batch_tl_rec.last_update_date,
1579: l_okl_trx_csh_batch_tl_rec.last_update_login);

Line 1576: l_okl_trx_csh_batch_tl_rec.creation_date,

1572: l_okl_trx_csh_batch_tl_rec.sfwt_flag,
1573: l_okl_trx_csh_batch_tl_rec.name,
1574: l_okl_trx_csh_batch_tl_rec.description,
1575: l_okl_trx_csh_batch_tl_rec.created_by,
1576: l_okl_trx_csh_batch_tl_rec.creation_date,
1577: l_okl_trx_csh_batch_tl_rec.last_updated_by,
1578: l_okl_trx_csh_batch_tl_rec.last_update_date,
1579: l_okl_trx_csh_batch_tl_rec.last_update_login);
1580: END LOOP;

Line 1577: l_okl_trx_csh_batch_tl_rec.last_updated_by,

1573: l_okl_trx_csh_batch_tl_rec.name,
1574: l_okl_trx_csh_batch_tl_rec.description,
1575: l_okl_trx_csh_batch_tl_rec.created_by,
1576: l_okl_trx_csh_batch_tl_rec.creation_date,
1577: l_okl_trx_csh_batch_tl_rec.last_updated_by,
1578: l_okl_trx_csh_batch_tl_rec.last_update_date,
1579: l_okl_trx_csh_batch_tl_rec.last_update_login);
1580: END LOOP;
1581: -- Set OUT values

Line 1578: l_okl_trx_csh_batch_tl_rec.last_update_date,

1574: l_okl_trx_csh_batch_tl_rec.description,
1575: l_okl_trx_csh_batch_tl_rec.created_by,
1576: l_okl_trx_csh_batch_tl_rec.creation_date,
1577: l_okl_trx_csh_batch_tl_rec.last_updated_by,
1578: l_okl_trx_csh_batch_tl_rec.last_update_date,
1579: l_okl_trx_csh_batch_tl_rec.last_update_login);
1580: END LOOP;
1581: -- Set OUT values
1582: x_okl_trx_csh_batch_tl_rec := l_okl_trx_csh_batch_tl_rec;

Line 1579: l_okl_trx_csh_batch_tl_rec.last_update_login);

1575: l_okl_trx_csh_batch_tl_rec.created_by,
1576: l_okl_trx_csh_batch_tl_rec.creation_date,
1577: l_okl_trx_csh_batch_tl_rec.last_updated_by,
1578: l_okl_trx_csh_batch_tl_rec.last_update_date,
1579: l_okl_trx_csh_batch_tl_rec.last_update_login);
1580: END LOOP;
1581: -- Set OUT values
1582: x_okl_trx_csh_batch_tl_rec := l_okl_trx_csh_batch_tl_rec;
1583: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1582: x_okl_trx_csh_batch_tl_rec := l_okl_trx_csh_batch_tl_rec;

1578: l_okl_trx_csh_batch_tl_rec.last_update_date,
1579: l_okl_trx_csh_batch_tl_rec.last_update_login);
1580: END LOOP;
1581: -- Set OUT values
1582: x_okl_trx_csh_batch_tl_rec := l_okl_trx_csh_batch_tl_rec;
1583: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1584: EXCEPTION
1585: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1586: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 1635: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;

1631: l_btcv_rec btcv_rec_type;
1632: l_def_btcv_rec btcv_rec_type;
1633: l_btc_rec btc_rec_type;
1634: lx_btc_rec btc_rec_type;
1635: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
1636: lx_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
1637: -------------------------------
1638: -- FUNCTION fill_who_columns --
1639: -------------------------------

Line 1636: lx_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;

1632: l_def_btcv_rec btcv_rec_type;
1633: l_btc_rec btc_rec_type;
1634: lx_btc_rec btc_rec_type;
1635: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
1636: lx_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
1637: -------------------------------
1638: -- FUNCTION fill_who_columns --
1639: -------------------------------
1640: FUNCTION fill_who_columns (

Line 1729: migrate(l_def_btcv_rec, l_okl_trx_csh_batch_tl_rec);

1725: --------------------------------------
1726: -- Move VIEW record to "Child" records
1727: --------------------------------------
1728: migrate(l_def_btcv_rec, l_btc_rec);
1729: migrate(l_def_btcv_rec, l_okl_trx_csh_batch_tl_rec);
1730: --------------------------------------------
1731: -- Call the INSERT_ROW for each child record
1732: --------------------------------------------
1733: insert_row(

Line 1752: l_okl_trx_csh_batch_tl_rec,

1748: p_init_msg_list,
1749: x_return_status,
1750: x_msg_count,
1751: x_msg_data,
1752: l_okl_trx_csh_batch_tl_rec,
1753: lx_okl_trx_csh_batch_tl_rec
1754: );
1755: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1756: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1753: lx_okl_trx_csh_batch_tl_rec

1749: x_return_status,
1750: x_msg_count,
1751: x_msg_data,
1752: l_okl_trx_csh_batch_tl_rec,
1753: lx_okl_trx_csh_batch_tl_rec
1754: );
1755: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1756: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1757: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 1760: migrate(lx_okl_trx_csh_batch_tl_rec, l_def_btcv_rec);

1756: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1757: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1758: RAISE Okl_Api.G_EXCEPTION_ERROR;
1759: END IF;
1760: migrate(lx_okl_trx_csh_batch_tl_rec, l_def_btcv_rec);
1761: -- Set OUT values
1762: x_btcv_rec := l_def_btcv_rec;
1763: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1764: EXCEPTION

Line 1998: -- lock_row for:OKL_TRX_CSH_BATCH_TL --

1994: '_PVT'
1995: );
1996: END lock_row;
1997: ---------------------------------------
1998: -- lock_row for:OKL_TRX_CSH_BATCH_TL --
1999: ---------------------------------------
2000: PROCEDURE lock_row(
2001: p_init_msg_list IN VARCHAR2,
2002: x_return_status OUT NOCOPY VARCHAR2,

Line 2005: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type) IS

2001: p_init_msg_list IN VARCHAR2,
2002: x_return_status OUT NOCOPY VARCHAR2,
2003: x_msg_count OUT NOCOPY NUMBER,
2004: x_msg_data OUT NOCOPY VARCHAR2,
2005: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type) IS
2006:
2007: E_Resource_Busy EXCEPTION;
2008: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2009: CURSOR lock_csr (p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type) IS

Line 2009: CURSOR lock_csr (p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type) IS

2005: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type) IS
2006:
2007: E_Resource_Busy EXCEPTION;
2008: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2009: CURSOR lock_csr (p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type) IS
2010: SELECT *
2011: FROM OKL_TRX_CSH_BATCH_TL
2012: WHERE ID = p_okl_trx_csh_batch_tl_rec.id
2013: FOR UPDATE NOWAIT;

Line 2011: FROM OKL_TRX_CSH_BATCH_TL

2007: E_Resource_Busy EXCEPTION;
2008: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2009: CURSOR lock_csr (p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type) IS
2010: SELECT *
2011: FROM OKL_TRX_CSH_BATCH_TL
2012: WHERE ID = p_okl_trx_csh_batch_tl_rec.id
2013: FOR UPDATE NOWAIT;
2014:
2015: l_api_version CONSTANT NUMBER := 1;

Line 2012: WHERE ID = p_okl_trx_csh_batch_tl_rec.id

2008: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2009: CURSOR lock_csr (p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type) IS
2010: SELECT *
2011: FROM OKL_TRX_CSH_BATCH_TL
2012: WHERE ID = p_okl_trx_csh_batch_tl_rec.id
2013: FOR UPDATE NOWAIT;
2014:
2015: l_api_version CONSTANT NUMBER := 1;
2016: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2032: OPEN lock_csr(p_okl_trx_csh_batch_tl_rec);

2028: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2029: RAISE Okl_Api.G_EXCEPTION_ERROR;
2030: END IF;
2031: BEGIN
2032: OPEN lock_csr(p_okl_trx_csh_batch_tl_rec);
2033: FETCH lock_csr INTO l_lock_var;
2034: l_row_notfound := lock_csr%NOTFOUND;
2035: CLOSE lock_csr;
2036: EXCEPTION

Line 2097: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;

2093: l_api_version CONSTANT NUMBER := 1;
2094: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2095: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2096: l_btc_rec btc_rec_type;
2097: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
2098: BEGIN
2099: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
2100: G_PKG_NAME,
2101: p_init_msg_list,

Line 2115: migrate(p_btcv_rec, l_okl_trx_csh_batch_tl_rec);

2111: --------------------------------------
2112: -- Move VIEW record to "Child" records
2113: --------------------------------------
2114: migrate(p_btcv_rec, l_btc_rec);
2115: migrate(p_btcv_rec, l_okl_trx_csh_batch_tl_rec);
2116: --------------------------------------------
2117: -- Call the LOCK_ROW for each child record
2118: --------------------------------------------
2119: lock_row(

Line 2136: l_okl_trx_csh_batch_tl_rec

2132: p_init_msg_list,
2133: x_return_status,
2134: x_msg_count,
2135: x_msg_data,
2136: l_okl_trx_csh_batch_tl_rec
2137: );
2138: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2139: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2140: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2580: -- update_row for:OKL_TRX_CSH_BATCH_TL --

2576: '_PVT'
2577: );
2578: END update_row;
2579: -----------------------------------------
2580: -- update_row for:OKL_TRX_CSH_BATCH_TL --
2581: -----------------------------------------
2582: PROCEDURE update_row(
2583: p_init_msg_list IN VARCHAR2,
2584: x_return_status OUT NOCOPY VARCHAR2,

Line 2587: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,

2583: p_init_msg_list IN VARCHAR2,
2584: x_return_status OUT NOCOPY VARCHAR2,
2585: x_msg_count OUT NOCOPY NUMBER,
2586: x_msg_data OUT NOCOPY VARCHAR2,
2587: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
2588: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type) IS
2589:
2590: l_api_version CONSTANT NUMBER := 1;
2591: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2588: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type) IS

2584: x_return_status OUT NOCOPY VARCHAR2,
2585: x_msg_count OUT NOCOPY NUMBER,
2586: x_msg_data OUT NOCOPY VARCHAR2,
2587: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
2588: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type) IS
2589:
2590: l_api_version CONSTANT NUMBER := 1;
2591: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2592: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2593: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type := p_okl_trx_csh_batch_tl_rec;

2589:
2590: l_api_version CONSTANT NUMBER := 1;
2591: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2592: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2593: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type := p_okl_trx_csh_batch_tl_rec;
2594: ldefokltrxcshbatchtlrec okl_trx_csh_batch_tl_rec_type;
2595: l_row_notfound BOOLEAN := TRUE;
2596: ----------------------------------
2597: -- FUNCTION populate_new_record --

Line 2594: ldefokltrxcshbatchtlrec okl_trx_csh_batch_tl_rec_type;

2590: l_api_version CONSTANT NUMBER := 1;
2591: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2592: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2593: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type := p_okl_trx_csh_batch_tl_rec;
2594: ldefokltrxcshbatchtlrec okl_trx_csh_batch_tl_rec_type;
2595: l_row_notfound BOOLEAN := TRUE;
2596: ----------------------------------
2597: -- FUNCTION populate_new_record --
2598: ----------------------------------

Line 2600: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,

2596: ----------------------------------
2597: -- FUNCTION populate_new_record --
2598: ----------------------------------
2599: FUNCTION populate_new_record (
2600: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
2601: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type
2602: ) RETURN VARCHAR2 IS
2603: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
2604: l_row_notfound BOOLEAN := TRUE;

Line 2601: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type

2597: -- FUNCTION populate_new_record --
2598: ----------------------------------
2599: FUNCTION populate_new_record (
2600: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
2601: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type
2602: ) RETURN VARCHAR2 IS
2603: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
2604: l_row_notfound BOOLEAN := TRUE;
2605: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2603: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;

2599: FUNCTION populate_new_record (
2600: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
2601: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type
2602: ) RETURN VARCHAR2 IS
2603: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
2604: l_row_notfound BOOLEAN := TRUE;
2605: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2606: BEGIN
2607: x_okl_trx_csh_batch_tl_rec := p_okl_trx_csh_batch_tl_rec;

Line 2607: x_okl_trx_csh_batch_tl_rec := p_okl_trx_csh_batch_tl_rec;

2603: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
2604: l_row_notfound BOOLEAN := TRUE;
2605: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2606: BEGIN
2607: x_okl_trx_csh_batch_tl_rec := p_okl_trx_csh_batch_tl_rec;
2608: -- Get current database values
2609: l_okl_trx_csh_batch_tl_rec := get_rec(p_okl_trx_csh_batch_tl_rec, l_row_notfound);
2610: IF (l_row_notfound) THEN
2611: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 2609: l_okl_trx_csh_batch_tl_rec := get_rec(p_okl_trx_csh_batch_tl_rec, l_row_notfound);

2605: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2606: BEGIN
2607: x_okl_trx_csh_batch_tl_rec := p_okl_trx_csh_batch_tl_rec;
2608: -- Get current database values
2609: l_okl_trx_csh_batch_tl_rec := get_rec(p_okl_trx_csh_batch_tl_rec, l_row_notfound);
2610: IF (l_row_notfound) THEN
2611: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2612: END IF;
2613: IF (x_okl_trx_csh_batch_tl_rec.id = Okl_Api.G_MISS_NUM)

Line 2613: IF (x_okl_trx_csh_batch_tl_rec.id = Okl_Api.G_MISS_NUM)

2609: l_okl_trx_csh_batch_tl_rec := get_rec(p_okl_trx_csh_batch_tl_rec, l_row_notfound);
2610: IF (l_row_notfound) THEN
2611: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2612: END IF;
2613: IF (x_okl_trx_csh_batch_tl_rec.id = Okl_Api.G_MISS_NUM)
2614: THEN
2615: x_okl_trx_csh_batch_tl_rec.id := l_okl_trx_csh_batch_tl_rec.id;
2616: END IF;
2617: IF (x_okl_trx_csh_batch_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)

Line 2615: x_okl_trx_csh_batch_tl_rec.id := l_okl_trx_csh_batch_tl_rec.id;

2611: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2612: END IF;
2613: IF (x_okl_trx_csh_batch_tl_rec.id = Okl_Api.G_MISS_NUM)
2614: THEN
2615: x_okl_trx_csh_batch_tl_rec.id := l_okl_trx_csh_batch_tl_rec.id;
2616: END IF;
2617: IF (x_okl_trx_csh_batch_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2618: THEN
2619: x_okl_trx_csh_batch_tl_rec.LANGUAGE := l_okl_trx_csh_batch_tl_rec.LANGUAGE;

Line 2617: IF (x_okl_trx_csh_batch_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)

2613: IF (x_okl_trx_csh_batch_tl_rec.id = Okl_Api.G_MISS_NUM)
2614: THEN
2615: x_okl_trx_csh_batch_tl_rec.id := l_okl_trx_csh_batch_tl_rec.id;
2616: END IF;
2617: IF (x_okl_trx_csh_batch_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2618: THEN
2619: x_okl_trx_csh_batch_tl_rec.LANGUAGE := l_okl_trx_csh_batch_tl_rec.LANGUAGE;
2620: END IF;
2621: IF (x_okl_trx_csh_batch_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)

Line 2619: x_okl_trx_csh_batch_tl_rec.LANGUAGE := l_okl_trx_csh_batch_tl_rec.LANGUAGE;

2615: x_okl_trx_csh_batch_tl_rec.id := l_okl_trx_csh_batch_tl_rec.id;
2616: END IF;
2617: IF (x_okl_trx_csh_batch_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2618: THEN
2619: x_okl_trx_csh_batch_tl_rec.LANGUAGE := l_okl_trx_csh_batch_tl_rec.LANGUAGE;
2620: END IF;
2621: IF (x_okl_trx_csh_batch_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2622: THEN
2623: x_okl_trx_csh_batch_tl_rec.source_lang := l_okl_trx_csh_batch_tl_rec.source_lang;

Line 2621: IF (x_okl_trx_csh_batch_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)

2617: IF (x_okl_trx_csh_batch_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2618: THEN
2619: x_okl_trx_csh_batch_tl_rec.LANGUAGE := l_okl_trx_csh_batch_tl_rec.LANGUAGE;
2620: END IF;
2621: IF (x_okl_trx_csh_batch_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2622: THEN
2623: x_okl_trx_csh_batch_tl_rec.source_lang := l_okl_trx_csh_batch_tl_rec.source_lang;
2624: END IF;
2625: IF (x_okl_trx_csh_batch_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)

Line 2623: x_okl_trx_csh_batch_tl_rec.source_lang := l_okl_trx_csh_batch_tl_rec.source_lang;

2619: x_okl_trx_csh_batch_tl_rec.LANGUAGE := l_okl_trx_csh_batch_tl_rec.LANGUAGE;
2620: END IF;
2621: IF (x_okl_trx_csh_batch_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2622: THEN
2623: x_okl_trx_csh_batch_tl_rec.source_lang := l_okl_trx_csh_batch_tl_rec.source_lang;
2624: END IF;
2625: IF (x_okl_trx_csh_batch_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2626: THEN
2627: x_okl_trx_csh_batch_tl_rec.sfwt_flag := l_okl_trx_csh_batch_tl_rec.sfwt_flag;

Line 2625: IF (x_okl_trx_csh_batch_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)

2621: IF (x_okl_trx_csh_batch_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2622: THEN
2623: x_okl_trx_csh_batch_tl_rec.source_lang := l_okl_trx_csh_batch_tl_rec.source_lang;
2624: END IF;
2625: IF (x_okl_trx_csh_batch_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2626: THEN
2627: x_okl_trx_csh_batch_tl_rec.sfwt_flag := l_okl_trx_csh_batch_tl_rec.sfwt_flag;
2628: END IF;
2629: IF (x_okl_trx_csh_batch_tl_rec.name = Okl_Api.G_MISS_CHAR)

Line 2627: x_okl_trx_csh_batch_tl_rec.sfwt_flag := l_okl_trx_csh_batch_tl_rec.sfwt_flag;

2623: x_okl_trx_csh_batch_tl_rec.source_lang := l_okl_trx_csh_batch_tl_rec.source_lang;
2624: END IF;
2625: IF (x_okl_trx_csh_batch_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2626: THEN
2627: x_okl_trx_csh_batch_tl_rec.sfwt_flag := l_okl_trx_csh_batch_tl_rec.sfwt_flag;
2628: END IF;
2629: IF (x_okl_trx_csh_batch_tl_rec.name = Okl_Api.G_MISS_CHAR)
2630: THEN
2631: x_okl_trx_csh_batch_tl_rec.name := l_okl_trx_csh_batch_tl_rec.name;

Line 2629: IF (x_okl_trx_csh_batch_tl_rec.name = Okl_Api.G_MISS_CHAR)

2625: IF (x_okl_trx_csh_batch_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2626: THEN
2627: x_okl_trx_csh_batch_tl_rec.sfwt_flag := l_okl_trx_csh_batch_tl_rec.sfwt_flag;
2628: END IF;
2629: IF (x_okl_trx_csh_batch_tl_rec.name = Okl_Api.G_MISS_CHAR)
2630: THEN
2631: x_okl_trx_csh_batch_tl_rec.name := l_okl_trx_csh_batch_tl_rec.name;
2632: END IF;
2633: IF (x_okl_trx_csh_batch_tl_rec.description = Okl_Api.G_MISS_CHAR)

Line 2631: x_okl_trx_csh_batch_tl_rec.name := l_okl_trx_csh_batch_tl_rec.name;

2627: x_okl_trx_csh_batch_tl_rec.sfwt_flag := l_okl_trx_csh_batch_tl_rec.sfwt_flag;
2628: END IF;
2629: IF (x_okl_trx_csh_batch_tl_rec.name = Okl_Api.G_MISS_CHAR)
2630: THEN
2631: x_okl_trx_csh_batch_tl_rec.name := l_okl_trx_csh_batch_tl_rec.name;
2632: END IF;
2633: IF (x_okl_trx_csh_batch_tl_rec.description = Okl_Api.G_MISS_CHAR)
2634: THEN
2635: x_okl_trx_csh_batch_tl_rec.description := l_okl_trx_csh_batch_tl_rec.description;

Line 2633: IF (x_okl_trx_csh_batch_tl_rec.description = Okl_Api.G_MISS_CHAR)

2629: IF (x_okl_trx_csh_batch_tl_rec.name = Okl_Api.G_MISS_CHAR)
2630: THEN
2631: x_okl_trx_csh_batch_tl_rec.name := l_okl_trx_csh_batch_tl_rec.name;
2632: END IF;
2633: IF (x_okl_trx_csh_batch_tl_rec.description = Okl_Api.G_MISS_CHAR)
2634: THEN
2635: x_okl_trx_csh_batch_tl_rec.description := l_okl_trx_csh_batch_tl_rec.description;
2636: END IF;
2637: IF (x_okl_trx_csh_batch_tl_rec.created_by = Okl_Api.G_MISS_NUM)

Line 2635: x_okl_trx_csh_batch_tl_rec.description := l_okl_trx_csh_batch_tl_rec.description;

2631: x_okl_trx_csh_batch_tl_rec.name := l_okl_trx_csh_batch_tl_rec.name;
2632: END IF;
2633: IF (x_okl_trx_csh_batch_tl_rec.description = Okl_Api.G_MISS_CHAR)
2634: THEN
2635: x_okl_trx_csh_batch_tl_rec.description := l_okl_trx_csh_batch_tl_rec.description;
2636: END IF;
2637: IF (x_okl_trx_csh_batch_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2638: THEN
2639: x_okl_trx_csh_batch_tl_rec.created_by := l_okl_trx_csh_batch_tl_rec.created_by;

Line 2637: IF (x_okl_trx_csh_batch_tl_rec.created_by = Okl_Api.G_MISS_NUM)

2633: IF (x_okl_trx_csh_batch_tl_rec.description = Okl_Api.G_MISS_CHAR)
2634: THEN
2635: x_okl_trx_csh_batch_tl_rec.description := l_okl_trx_csh_batch_tl_rec.description;
2636: END IF;
2637: IF (x_okl_trx_csh_batch_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2638: THEN
2639: x_okl_trx_csh_batch_tl_rec.created_by := l_okl_trx_csh_batch_tl_rec.created_by;
2640: END IF;
2641: IF (x_okl_trx_csh_batch_tl_rec.creation_date = Okl_Api.G_MISS_DATE)

Line 2639: x_okl_trx_csh_batch_tl_rec.created_by := l_okl_trx_csh_batch_tl_rec.created_by;

2635: x_okl_trx_csh_batch_tl_rec.description := l_okl_trx_csh_batch_tl_rec.description;
2636: END IF;
2637: IF (x_okl_trx_csh_batch_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2638: THEN
2639: x_okl_trx_csh_batch_tl_rec.created_by := l_okl_trx_csh_batch_tl_rec.created_by;
2640: END IF;
2641: IF (x_okl_trx_csh_batch_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2642: THEN
2643: x_okl_trx_csh_batch_tl_rec.creation_date := l_okl_trx_csh_batch_tl_rec.creation_date;

Line 2641: IF (x_okl_trx_csh_batch_tl_rec.creation_date = Okl_Api.G_MISS_DATE)

2637: IF (x_okl_trx_csh_batch_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2638: THEN
2639: x_okl_trx_csh_batch_tl_rec.created_by := l_okl_trx_csh_batch_tl_rec.created_by;
2640: END IF;
2641: IF (x_okl_trx_csh_batch_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2642: THEN
2643: x_okl_trx_csh_batch_tl_rec.creation_date := l_okl_trx_csh_batch_tl_rec.creation_date;
2644: END IF;
2645: IF (x_okl_trx_csh_batch_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)

Line 2643: x_okl_trx_csh_batch_tl_rec.creation_date := l_okl_trx_csh_batch_tl_rec.creation_date;

2639: x_okl_trx_csh_batch_tl_rec.created_by := l_okl_trx_csh_batch_tl_rec.created_by;
2640: END IF;
2641: IF (x_okl_trx_csh_batch_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2642: THEN
2643: x_okl_trx_csh_batch_tl_rec.creation_date := l_okl_trx_csh_batch_tl_rec.creation_date;
2644: END IF;
2645: IF (x_okl_trx_csh_batch_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2646: THEN
2647: x_okl_trx_csh_batch_tl_rec.last_updated_by := l_okl_trx_csh_batch_tl_rec.last_updated_by;

Line 2645: IF (x_okl_trx_csh_batch_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)

2641: IF (x_okl_trx_csh_batch_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2642: THEN
2643: x_okl_trx_csh_batch_tl_rec.creation_date := l_okl_trx_csh_batch_tl_rec.creation_date;
2644: END IF;
2645: IF (x_okl_trx_csh_batch_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2646: THEN
2647: x_okl_trx_csh_batch_tl_rec.last_updated_by := l_okl_trx_csh_batch_tl_rec.last_updated_by;
2648: END IF;
2649: IF (x_okl_trx_csh_batch_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)

Line 2647: x_okl_trx_csh_batch_tl_rec.last_updated_by := l_okl_trx_csh_batch_tl_rec.last_updated_by;

2643: x_okl_trx_csh_batch_tl_rec.creation_date := l_okl_trx_csh_batch_tl_rec.creation_date;
2644: END IF;
2645: IF (x_okl_trx_csh_batch_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2646: THEN
2647: x_okl_trx_csh_batch_tl_rec.last_updated_by := l_okl_trx_csh_batch_tl_rec.last_updated_by;
2648: END IF;
2649: IF (x_okl_trx_csh_batch_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2650: THEN
2651: x_okl_trx_csh_batch_tl_rec.last_update_date := l_okl_trx_csh_batch_tl_rec.last_update_date;

Line 2649: IF (x_okl_trx_csh_batch_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)

2645: IF (x_okl_trx_csh_batch_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2646: THEN
2647: x_okl_trx_csh_batch_tl_rec.last_updated_by := l_okl_trx_csh_batch_tl_rec.last_updated_by;
2648: END IF;
2649: IF (x_okl_trx_csh_batch_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2650: THEN
2651: x_okl_trx_csh_batch_tl_rec.last_update_date := l_okl_trx_csh_batch_tl_rec.last_update_date;
2652: END IF;
2653: IF (x_okl_trx_csh_batch_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)

Line 2651: x_okl_trx_csh_batch_tl_rec.last_update_date := l_okl_trx_csh_batch_tl_rec.last_update_date;

2647: x_okl_trx_csh_batch_tl_rec.last_updated_by := l_okl_trx_csh_batch_tl_rec.last_updated_by;
2648: END IF;
2649: IF (x_okl_trx_csh_batch_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2650: THEN
2651: x_okl_trx_csh_batch_tl_rec.last_update_date := l_okl_trx_csh_batch_tl_rec.last_update_date;
2652: END IF;
2653: IF (x_okl_trx_csh_batch_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2654: THEN
2655: x_okl_trx_csh_batch_tl_rec.last_update_login := l_okl_trx_csh_batch_tl_rec.last_update_login;

Line 2653: IF (x_okl_trx_csh_batch_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)

2649: IF (x_okl_trx_csh_batch_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2650: THEN
2651: x_okl_trx_csh_batch_tl_rec.last_update_date := l_okl_trx_csh_batch_tl_rec.last_update_date;
2652: END IF;
2653: IF (x_okl_trx_csh_batch_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2654: THEN
2655: x_okl_trx_csh_batch_tl_rec.last_update_login := l_okl_trx_csh_batch_tl_rec.last_update_login;
2656: END IF;
2657:

Line 2655: x_okl_trx_csh_batch_tl_rec.last_update_login := l_okl_trx_csh_batch_tl_rec.last_update_login;

2651: x_okl_trx_csh_batch_tl_rec.last_update_date := l_okl_trx_csh_batch_tl_rec.last_update_date;
2652: END IF;
2653: IF (x_okl_trx_csh_batch_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2654: THEN
2655: x_okl_trx_csh_batch_tl_rec.last_update_login := l_okl_trx_csh_batch_tl_rec.last_update_login;
2656: END IF;
2657:
2658: RETURN(l_return_status);
2659: END populate_new_record;

Line 2661: -- Set_Attributes for:OKL_TRX_CSH_BATCH_TL --

2657:
2658: RETURN(l_return_status);
2659: END populate_new_record;
2660: ---------------------------------------------
2661: -- Set_Attributes for:OKL_TRX_CSH_BATCH_TL --
2662: ---------------------------------------------
2663: FUNCTION Set_Attributes (
2664: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
2665: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type

Line 2664: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,

2660: ---------------------------------------------
2661: -- Set_Attributes for:OKL_TRX_CSH_BATCH_TL --
2662: ---------------------------------------------
2663: FUNCTION Set_Attributes (
2664: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
2665: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type
2666: ) RETURN VARCHAR2 IS
2667: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2668: BEGIN

Line 2665: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type

2661: -- Set_Attributes for:OKL_TRX_CSH_BATCH_TL --
2662: ---------------------------------------------
2663: FUNCTION Set_Attributes (
2664: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
2665: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type
2666: ) RETURN VARCHAR2 IS
2667: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2668: BEGIN
2669: x_okl_trx_csh_batch_tl_rec := p_okl_trx_csh_batch_tl_rec;

Line 2669: x_okl_trx_csh_batch_tl_rec := p_okl_trx_csh_batch_tl_rec;

2665: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type
2666: ) RETURN VARCHAR2 IS
2667: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2668: BEGIN
2669: x_okl_trx_csh_batch_tl_rec := p_okl_trx_csh_batch_tl_rec;
2670: x_okl_trx_csh_batch_tl_rec.LANGUAGE := USERENV('LANG');
2671: x_okl_trx_csh_batch_tl_rec.SOURCE_LANG := USERENV('LANG');
2672: RETURN(l_return_status);
2673: END Set_Attributes;

Line 2670: x_okl_trx_csh_batch_tl_rec.LANGUAGE := USERENV('LANG');

2666: ) RETURN VARCHAR2 IS
2667: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2668: BEGIN
2669: x_okl_trx_csh_batch_tl_rec := p_okl_trx_csh_batch_tl_rec;
2670: x_okl_trx_csh_batch_tl_rec.LANGUAGE := USERENV('LANG');
2671: x_okl_trx_csh_batch_tl_rec.SOURCE_LANG := USERENV('LANG');
2672: RETURN(l_return_status);
2673: END Set_Attributes;
2674: BEGIN

Line 2671: x_okl_trx_csh_batch_tl_rec.SOURCE_LANG := USERENV('LANG');

2667: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2668: BEGIN
2669: x_okl_trx_csh_batch_tl_rec := p_okl_trx_csh_batch_tl_rec;
2670: x_okl_trx_csh_batch_tl_rec.LANGUAGE := USERENV('LANG');
2671: x_okl_trx_csh_batch_tl_rec.SOURCE_LANG := USERENV('LANG');
2672: RETURN(l_return_status);
2673: END Set_Attributes;
2674: BEGIN
2675: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 2686: p_okl_trx_csh_batch_tl_rec, -- IN

2682: RAISE Okl_Api.G_EXCEPTION_ERROR;
2683: END IF;
2684: --- Setting item attributes
2685: l_return_status := Set_Attributes(
2686: p_okl_trx_csh_batch_tl_rec, -- IN
2687: l_okl_trx_csh_batch_tl_rec); -- OUT
2688: --- If any errors happen abort API
2689: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2690: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2687: l_okl_trx_csh_batch_tl_rec); -- OUT

2683: END IF;
2684: --- Setting item attributes
2685: l_return_status := Set_Attributes(
2686: p_okl_trx_csh_batch_tl_rec, -- IN
2687: l_okl_trx_csh_batch_tl_rec); -- OUT
2688: --- If any errors happen abort API
2689: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2690: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2691: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2694: l_return_status := populate_new_record(l_okl_trx_csh_batch_tl_rec, ldefokltrxcshbatchtlrec);

2690: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2691: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2692: RAISE Okl_Api.G_EXCEPTION_ERROR;
2693: END IF;
2694: l_return_status := populate_new_record(l_okl_trx_csh_batch_tl_rec, ldefokltrxcshbatchtlrec);
2695: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2696: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2697: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2698: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 2700: UPDATE OKL_TRX_CSH_BATCH_TL

2696: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2697: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2698: RAISE Okl_Api.G_EXCEPTION_ERROR;
2699: END IF;
2700: UPDATE OKL_TRX_CSH_BATCH_TL
2701: SET NAME = ldefokltrxcshbatchtlrec.name,
2702: DESCRIPTION = ldefokltrxcshbatchtlrec.description,
2703: CREATED_BY = ldefokltrxcshbatchtlrec.created_by,
2704: CREATION_DATE = ldefokltrxcshbatchtlrec.creation_date,

Line 2712: UPDATE OKL_TRX_CSH_BATCH_TL

2708: WHERE ID = ldefokltrxcshbatchtlrec.id
2709: --AND SOURCE_LANG = USERENV('LANG');
2710: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2711:
2712: UPDATE OKL_TRX_CSH_BATCH_TL
2713: SET SFWT_FLAG = 'Y'
2714: WHERE ID = ldefokltrxcshbatchtlrec.id
2715: AND SOURCE_LANG <> USERENV('LANG');
2716:

Line 2717: x_okl_trx_csh_batch_tl_rec := ldefokltrxcshbatchtlrec;

2713: SET SFWT_FLAG = 'Y'
2714: WHERE ID = ldefokltrxcshbatchtlrec.id
2715: AND SOURCE_LANG <> USERENV('LANG');
2716:
2717: x_okl_trx_csh_batch_tl_rec := ldefokltrxcshbatchtlrec;
2718: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2719: EXCEPTION
2720: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2721: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 2768: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;

2764: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2765: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2766: l_btcv_rec btcv_rec_type := p_btcv_rec;
2767: l_def_btcv_rec btcv_rec_type;
2768: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
2769: lx_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
2770: l_btc_rec btc_rec_type;
2771: lx_btc_rec btc_rec_type;
2772: -------------------------------

Line 2769: lx_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;

2765: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2766: l_btcv_rec btcv_rec_type := p_btcv_rec;
2767: l_def_btcv_rec btcv_rec_type;
2768: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
2769: lx_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
2770: l_btc_rec btc_rec_type;
2771: lx_btc_rec btc_rec_type;
2772: -------------------------------
2773: -- FUNCTION fill_who_columns --

Line 3042: migrate(l_def_btcv_rec, l_okl_trx_csh_batch_tl_rec);

3038:
3039: --------------------------------------
3040: -- Move VIEW record to "Child" records
3041: --------------------------------------
3042: migrate(l_def_btcv_rec, l_okl_trx_csh_batch_tl_rec);
3043: migrate(l_def_btcv_rec, l_btc_rec);
3044: --------------------------------------------
3045: -- Call the UPDATE_ROW for each child record
3046: --------------------------------------------

Line 3052: l_okl_trx_csh_batch_tl_rec,

3048: p_init_msg_list,
3049: x_return_status,
3050: x_msg_count,
3051: x_msg_data,
3052: l_okl_trx_csh_batch_tl_rec,
3053: lx_okl_trx_csh_batch_tl_rec
3054: );
3055: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3056: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3053: lx_okl_trx_csh_batch_tl_rec

3049: x_return_status,
3050: x_msg_count,
3051: x_msg_data,
3052: l_okl_trx_csh_batch_tl_rec,
3053: lx_okl_trx_csh_batch_tl_rec
3054: );
3055: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3056: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3057: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 3060: migrate(lx_okl_trx_csh_batch_tl_rec, l_def_btcv_rec);

3056: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3057: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3058: RAISE Okl_Api.G_EXCEPTION_ERROR;
3059: END IF;
3060: migrate(lx_okl_trx_csh_batch_tl_rec, l_def_btcv_rec);
3061: update_row(
3062: p_init_msg_list,
3063: x_return_status,
3064: x_msg_count,

Line 3262: -- delete_row for:OKL_TRX_CSH_BATCH_TL --

3258: '_PVT'
3259: );
3260: END delete_row;
3261: -----------------------------------------
3262: -- delete_row for:OKL_TRX_CSH_BATCH_TL --
3263: -----------------------------------------
3264: PROCEDURE delete_row(
3265: p_init_msg_list IN VARCHAR2,
3266: x_return_status OUT NOCOPY VARCHAR2,

Line 3269: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type) IS

3265: p_init_msg_list IN VARCHAR2,
3266: x_return_status OUT NOCOPY VARCHAR2,
3267: x_msg_count OUT NOCOPY NUMBER,
3268: x_msg_data OUT NOCOPY VARCHAR2,
3269: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type) IS
3270:
3271: l_api_version CONSTANT NUMBER := 1;
3272: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3273: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 3274: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type:= p_okl_trx_csh_batch_tl_rec;

3270:
3271: l_api_version CONSTANT NUMBER := 1;
3272: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3273: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3274: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type:= p_okl_trx_csh_batch_tl_rec;
3275: l_row_notfound BOOLEAN := TRUE;
3276: ---------------------------------------------
3277: -- Set_Attributes for:OKL_TRX_CSH_BATCH_TL --
3278: ---------------------------------------------

Line 3277: -- Set_Attributes for:OKL_TRX_CSH_BATCH_TL --

3273: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3274: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type:= p_okl_trx_csh_batch_tl_rec;
3275: l_row_notfound BOOLEAN := TRUE;
3276: ---------------------------------------------
3277: -- Set_Attributes for:OKL_TRX_CSH_BATCH_TL --
3278: ---------------------------------------------
3279: FUNCTION Set_Attributes (
3280: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
3281: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type

Line 3280: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,

3276: ---------------------------------------------
3277: -- Set_Attributes for:OKL_TRX_CSH_BATCH_TL --
3278: ---------------------------------------------
3279: FUNCTION Set_Attributes (
3280: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
3281: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type
3282: ) RETURN VARCHAR2 IS
3283: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3284: BEGIN

Line 3281: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type

3277: -- Set_Attributes for:OKL_TRX_CSH_BATCH_TL --
3278: ---------------------------------------------
3279: FUNCTION Set_Attributes (
3280: p_okl_trx_csh_batch_tl_rec IN okl_trx_csh_batch_tl_rec_type,
3281: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type
3282: ) RETURN VARCHAR2 IS
3283: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3284: BEGIN
3285: x_okl_trx_csh_batch_tl_rec := p_okl_trx_csh_batch_tl_rec;

Line 3285: x_okl_trx_csh_batch_tl_rec := p_okl_trx_csh_batch_tl_rec;

3281: x_okl_trx_csh_batch_tl_rec OUT NOCOPY okl_trx_csh_batch_tl_rec_type
3282: ) RETURN VARCHAR2 IS
3283: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3284: BEGIN
3285: x_okl_trx_csh_batch_tl_rec := p_okl_trx_csh_batch_tl_rec;
3286: x_okl_trx_csh_batch_tl_rec.LANGUAGE := USERENV('LANG');
3287: RETURN(l_return_status);
3288: END Set_Attributes;
3289: BEGIN

Line 3286: x_okl_trx_csh_batch_tl_rec.LANGUAGE := USERENV('LANG');

3282: ) RETURN VARCHAR2 IS
3283: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3284: BEGIN
3285: x_okl_trx_csh_batch_tl_rec := p_okl_trx_csh_batch_tl_rec;
3286: x_okl_trx_csh_batch_tl_rec.LANGUAGE := USERENV('LANG');
3287: RETURN(l_return_status);
3288: END Set_Attributes;
3289: BEGIN
3290: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 3301: p_okl_trx_csh_batch_tl_rec, -- IN

3297: RAISE Okl_Api.G_EXCEPTION_ERROR;
3298: END IF;
3299: --- Setting item attributes
3300: l_return_status := Set_Attributes(
3301: p_okl_trx_csh_batch_tl_rec, -- IN
3302: l_okl_trx_csh_batch_tl_rec); -- OUT
3303: --- If any errors happen abort API
3304: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3305: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3302: l_okl_trx_csh_batch_tl_rec); -- OUT

3298: END IF;
3299: --- Setting item attributes
3300: l_return_status := Set_Attributes(
3301: p_okl_trx_csh_batch_tl_rec, -- IN
3302: l_okl_trx_csh_batch_tl_rec); -- OUT
3303: --- If any errors happen abort API
3304: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3305: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3306: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 3309: DELETE FROM OKL_TRX_CSH_BATCH_TL

3305: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3306: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3307: RAISE Okl_Api.G_EXCEPTION_ERROR;
3308: END IF;
3309: DELETE FROM OKL_TRX_CSH_BATCH_TL
3310: WHERE ID = l_okl_trx_csh_batch_tl_rec.id;
3311:
3312: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3313: EXCEPTION

Line 3310: WHERE ID = l_okl_trx_csh_batch_tl_rec.id;

3306: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3307: RAISE Okl_Api.G_EXCEPTION_ERROR;
3308: END IF;
3309: DELETE FROM OKL_TRX_CSH_BATCH_TL
3310: WHERE ID = l_okl_trx_csh_batch_tl_rec.id;
3311:
3312: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3313: EXCEPTION
3314: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

Line 3360: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;

3356: l_api_version CONSTANT NUMBER := 1;
3357: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3358: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3359: l_btcv_rec btcv_rec_type := p_btcv_rec;
3360: l_okl_trx_csh_batch_tl_rec okl_trx_csh_batch_tl_rec_type;
3361: l_btc_rec btc_rec_type;
3362: BEGIN
3363: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
3364: G_PKG_NAME,

Line 3378: migrate(l_btcv_rec, l_okl_trx_csh_batch_tl_rec);

3374: END IF;
3375: --------------------------------------
3376: -- Move VIEW record to "Child" records
3377: --------------------------------------
3378: migrate(l_btcv_rec, l_okl_trx_csh_batch_tl_rec);
3379: migrate(l_btcv_rec, l_btc_rec);
3380: --------------------------------------------
3381: -- Call the DELETE_ROW for each child record
3382: --------------------------------------------

Line 3388: l_okl_trx_csh_batch_tl_rec

3384: p_init_msg_list,
3385: x_return_status,
3386: x_msg_count,
3387: x_msg_data,
3388: l_okl_trx_csh_batch_tl_rec
3389: );
3390: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3391: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3392: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN