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_ADJ_PVT dependencies on OKL_TRX_AR_ADJSTS_TL

Line 57: DELETE FROM OKL_TRX_AR_ADJSTS_TL T

53: -- PROCEDURE add_language
54: ---------------------------------------------------------------------------
55: PROCEDURE add_language IS
56: BEGIN
57: DELETE FROM OKL_TRX_AR_ADJSTS_TL T
58: WHERE NOT EXISTS (
59: SELECT NULL
60: FROM OKL_TRX_AR_ADJSTS_ALL_B B --fixed bug 3321017 by kmotepal
61: WHERE B.ID = T.ID

Line 64: UPDATE OKL_TRX_AR_ADJSTS_TL T SET (

60: FROM OKL_TRX_AR_ADJSTS_ALL_B B --fixed bug 3321017 by kmotepal
61: WHERE B.ID = T.ID
62: );
63:
64: UPDATE OKL_TRX_AR_ADJSTS_TL T SET (
65: COMMENTS,
66: CREATED_BY,
67: LAST_UPDATED_BY,
68: LAST_UPDATE_LOGIN) = (SELECT

Line 73: FROM OKL_TRX_AR_ADJSTS_TL B

69: B.COMMENTS,
70: B.CREATED_BY,
71: B.LAST_UPDATED_BY,
72: B.LAST_UPDATE_LOGIN
73: FROM OKL_TRX_AR_ADJSTS_TL B
74: WHERE B.ID = T.ID
75: AND B.LANGUAGE = T.SOURCE_LANG)
76: WHERE (
77: T.ID,

Line 82: FROM OKL_TRX_AR_ADJSTS_TL SUBB, OKL_TRX_AR_ADJSTS_TL SUBT

78: T.LANGUAGE)
79: IN (SELECT
80: SUBT.ID,
81: SUBT.LANGUAGE
82: FROM OKL_TRX_AR_ADJSTS_TL SUBB, OKL_TRX_AR_ADJSTS_TL SUBT
83: WHERE SUBB.ID = SUBT.ID
84: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
85: AND (SUBB.COMMENTS <> SUBT.COMMENTS
86: OR SUBB.CREATED_BY <> SUBT.CREATED_BY

Line 95: INSERT INTO OKL_TRX_AR_ADJSTS_TL (

91: OR (SUBB.LAST_UPDATE_LOGIN IS NULL AND SUBT.LAST_UPDATE_LOGIN IS NOT NULL)
92: OR (SUBB.LAST_UPDATE_LOGIN IS NOT NULL AND SUBT.LAST_UPDATE_LOGIN IS NULL)
93: ));
94:
95: INSERT INTO OKL_TRX_AR_ADJSTS_TL (
96: ID,
97: LANGUAGE,
98: SOURCE_LANG,
99: SFWT_FLAG,

Line 117: FROM OKL_TRX_AR_ADJSTS_TL B, FND_LANGUAGES L

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

Line 122: FROM OKL_TRX_AR_ADJSTS_TL T

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

Line 235: -- FUNCTION get_rec for: OKL_TRX_AR_ADJSTS_TL

231: BEGIN
232: RETURN(get_rec(p_adj_rec, l_row_notfound));
233: END get_rec;
234: ---------------------------------------------------------------------------
235: -- FUNCTION get_rec for: OKL_TRX_AR_ADJSTS_TL
236: ---------------------------------------------------------------------------
237: FUNCTION get_rec (
238: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
239: x_no_data_found OUT NOCOPY BOOLEAN

Line 238: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,

234: ---------------------------------------------------------------------------
235: -- FUNCTION get_rec for: OKL_TRX_AR_ADJSTS_TL
236: ---------------------------------------------------------------------------
237: FUNCTION get_rec (
238: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
239: x_no_data_found OUT NOCOPY BOOLEAN
240: ) RETURN okl_trx_ar_adjsts_tl_rec_type IS
241: CURSOR okl_trx_ar_adjsts_tl_pk_csr (p_id IN NUMBER,
242: p_language IN VARCHAR2) IS

Line 240: ) RETURN okl_trx_ar_adjsts_tl_rec_type IS

236: ---------------------------------------------------------------------------
237: FUNCTION get_rec (
238: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
239: x_no_data_found OUT NOCOPY BOOLEAN
240: ) RETURN okl_trx_ar_adjsts_tl_rec_type IS
241: CURSOR okl_trx_ar_adjsts_tl_pk_csr (p_id IN NUMBER,
242: p_language IN VARCHAR2) IS
243: SELECT
244: ID,

Line 241: CURSOR okl_trx_ar_adjsts_tl_pk_csr (p_id IN NUMBER,

237: FUNCTION get_rec (
238: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
239: x_no_data_found OUT NOCOPY BOOLEAN
240: ) RETURN okl_trx_ar_adjsts_tl_rec_type IS
241: CURSOR okl_trx_ar_adjsts_tl_pk_csr (p_id IN NUMBER,
242: p_language IN VARCHAR2) IS
243: SELECT
244: ID,
245: LANGUAGE,

Line 254: FROM Okl_Trx_Ar_Adjsts_Tl

250: CREATION_DATE,
251: LAST_UPDATED_BY,
252: LAST_UPDATE_DATE,
253: LAST_UPDATE_LOGIN
254: FROM Okl_Trx_Ar_Adjsts_Tl
255: WHERE okl_trx_ar_adjsts_tl.id = p_id
256: AND okl_trx_ar_adjsts_tl.language = p_language;
257: l_okl_trx_ar_adjsts_tl_pk okl_trx_ar_adjsts_tl_pk_csr%ROWTYPE;
258: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;

Line 255: WHERE okl_trx_ar_adjsts_tl.id = p_id

251: LAST_UPDATED_BY,
252: LAST_UPDATE_DATE,
253: LAST_UPDATE_LOGIN
254: FROM Okl_Trx_Ar_Adjsts_Tl
255: WHERE okl_trx_ar_adjsts_tl.id = p_id
256: AND okl_trx_ar_adjsts_tl.language = p_language;
257: l_okl_trx_ar_adjsts_tl_pk okl_trx_ar_adjsts_tl_pk_csr%ROWTYPE;
258: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;
259: BEGIN

Line 256: AND okl_trx_ar_adjsts_tl.language = p_language;

252: LAST_UPDATE_DATE,
253: LAST_UPDATE_LOGIN
254: FROM Okl_Trx_Ar_Adjsts_Tl
255: WHERE okl_trx_ar_adjsts_tl.id = p_id
256: AND okl_trx_ar_adjsts_tl.language = p_language;
257: l_okl_trx_ar_adjsts_tl_pk okl_trx_ar_adjsts_tl_pk_csr%ROWTYPE;
258: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;
259: BEGIN
260: x_no_data_found := TRUE;

Line 257: l_okl_trx_ar_adjsts_tl_pk okl_trx_ar_adjsts_tl_pk_csr%ROWTYPE;

253: LAST_UPDATE_LOGIN
254: FROM Okl_Trx_Ar_Adjsts_Tl
255: WHERE okl_trx_ar_adjsts_tl.id = p_id
256: AND okl_trx_ar_adjsts_tl.language = p_language;
257: l_okl_trx_ar_adjsts_tl_pk okl_trx_ar_adjsts_tl_pk_csr%ROWTYPE;
258: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;
259: BEGIN
260: x_no_data_found := TRUE;
261: -- Get current database values

Line 258: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;

254: FROM Okl_Trx_Ar_Adjsts_Tl
255: WHERE okl_trx_ar_adjsts_tl.id = p_id
256: AND okl_trx_ar_adjsts_tl.language = p_language;
257: l_okl_trx_ar_adjsts_tl_pk okl_trx_ar_adjsts_tl_pk_csr%ROWTYPE;
258: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;
259: BEGIN
260: x_no_data_found := TRUE;
261: -- Get current database values
262: OPEN okl_trx_ar_adjsts_tl_pk_csr (p_okl_trx_ar_adjsts_tl_rec.id,

Line 262: OPEN okl_trx_ar_adjsts_tl_pk_csr (p_okl_trx_ar_adjsts_tl_rec.id,

258: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;
259: BEGIN
260: x_no_data_found := TRUE;
261: -- Get current database values
262: OPEN okl_trx_ar_adjsts_tl_pk_csr (p_okl_trx_ar_adjsts_tl_rec.id,
263: p_okl_trx_ar_adjsts_tl_rec.language);
264: FETCH okl_trx_ar_adjsts_tl_pk_csr INTO
265: l_okl_trx_ar_adjsts_tl_rec.ID,
266: l_okl_trx_ar_adjsts_tl_rec.LANGUAGE,

Line 263: p_okl_trx_ar_adjsts_tl_rec.language);

259: BEGIN
260: x_no_data_found := TRUE;
261: -- Get current database values
262: OPEN okl_trx_ar_adjsts_tl_pk_csr (p_okl_trx_ar_adjsts_tl_rec.id,
263: p_okl_trx_ar_adjsts_tl_rec.language);
264: FETCH okl_trx_ar_adjsts_tl_pk_csr INTO
265: l_okl_trx_ar_adjsts_tl_rec.ID,
266: l_okl_trx_ar_adjsts_tl_rec.LANGUAGE,
267: l_okl_trx_ar_adjsts_tl_rec.SOURCE_LANG,

Line 264: FETCH okl_trx_ar_adjsts_tl_pk_csr INTO

260: x_no_data_found := TRUE;
261: -- Get current database values
262: OPEN okl_trx_ar_adjsts_tl_pk_csr (p_okl_trx_ar_adjsts_tl_rec.id,
263: p_okl_trx_ar_adjsts_tl_rec.language);
264: FETCH okl_trx_ar_adjsts_tl_pk_csr INTO
265: l_okl_trx_ar_adjsts_tl_rec.ID,
266: l_okl_trx_ar_adjsts_tl_rec.LANGUAGE,
267: l_okl_trx_ar_adjsts_tl_rec.SOURCE_LANG,
268: l_okl_trx_ar_adjsts_tl_rec.SFWT_FLAG,

Line 265: l_okl_trx_ar_adjsts_tl_rec.ID,

261: -- Get current database values
262: OPEN okl_trx_ar_adjsts_tl_pk_csr (p_okl_trx_ar_adjsts_tl_rec.id,
263: p_okl_trx_ar_adjsts_tl_rec.language);
264: FETCH okl_trx_ar_adjsts_tl_pk_csr INTO
265: l_okl_trx_ar_adjsts_tl_rec.ID,
266: l_okl_trx_ar_adjsts_tl_rec.LANGUAGE,
267: l_okl_trx_ar_adjsts_tl_rec.SOURCE_LANG,
268: l_okl_trx_ar_adjsts_tl_rec.SFWT_FLAG,
269: l_okl_trx_ar_adjsts_tl_rec.COMMENTS,

Line 266: l_okl_trx_ar_adjsts_tl_rec.LANGUAGE,

262: OPEN okl_trx_ar_adjsts_tl_pk_csr (p_okl_trx_ar_adjsts_tl_rec.id,
263: p_okl_trx_ar_adjsts_tl_rec.language);
264: FETCH okl_trx_ar_adjsts_tl_pk_csr INTO
265: l_okl_trx_ar_adjsts_tl_rec.ID,
266: l_okl_trx_ar_adjsts_tl_rec.LANGUAGE,
267: l_okl_trx_ar_adjsts_tl_rec.SOURCE_LANG,
268: l_okl_trx_ar_adjsts_tl_rec.SFWT_FLAG,
269: l_okl_trx_ar_adjsts_tl_rec.COMMENTS,
270: l_okl_trx_ar_adjsts_tl_rec.CREATED_BY,

Line 267: l_okl_trx_ar_adjsts_tl_rec.SOURCE_LANG,

263: p_okl_trx_ar_adjsts_tl_rec.language);
264: FETCH okl_trx_ar_adjsts_tl_pk_csr INTO
265: l_okl_trx_ar_adjsts_tl_rec.ID,
266: l_okl_trx_ar_adjsts_tl_rec.LANGUAGE,
267: l_okl_trx_ar_adjsts_tl_rec.SOURCE_LANG,
268: l_okl_trx_ar_adjsts_tl_rec.SFWT_FLAG,
269: l_okl_trx_ar_adjsts_tl_rec.COMMENTS,
270: l_okl_trx_ar_adjsts_tl_rec.CREATED_BY,
271: l_okl_trx_ar_adjsts_tl_rec.CREATION_DATE,

Line 268: l_okl_trx_ar_adjsts_tl_rec.SFWT_FLAG,

264: FETCH okl_trx_ar_adjsts_tl_pk_csr INTO
265: l_okl_trx_ar_adjsts_tl_rec.ID,
266: l_okl_trx_ar_adjsts_tl_rec.LANGUAGE,
267: l_okl_trx_ar_adjsts_tl_rec.SOURCE_LANG,
268: l_okl_trx_ar_adjsts_tl_rec.SFWT_FLAG,
269: l_okl_trx_ar_adjsts_tl_rec.COMMENTS,
270: l_okl_trx_ar_adjsts_tl_rec.CREATED_BY,
271: l_okl_trx_ar_adjsts_tl_rec.CREATION_DATE,
272: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATED_BY,

Line 269: l_okl_trx_ar_adjsts_tl_rec.COMMENTS,

265: l_okl_trx_ar_adjsts_tl_rec.ID,
266: l_okl_trx_ar_adjsts_tl_rec.LANGUAGE,
267: l_okl_trx_ar_adjsts_tl_rec.SOURCE_LANG,
268: l_okl_trx_ar_adjsts_tl_rec.SFWT_FLAG,
269: l_okl_trx_ar_adjsts_tl_rec.COMMENTS,
270: l_okl_trx_ar_adjsts_tl_rec.CREATED_BY,
271: l_okl_trx_ar_adjsts_tl_rec.CREATION_DATE,
272: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATED_BY,
273: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_DATE,

Line 270: l_okl_trx_ar_adjsts_tl_rec.CREATED_BY,

266: l_okl_trx_ar_adjsts_tl_rec.LANGUAGE,
267: l_okl_trx_ar_adjsts_tl_rec.SOURCE_LANG,
268: l_okl_trx_ar_adjsts_tl_rec.SFWT_FLAG,
269: l_okl_trx_ar_adjsts_tl_rec.COMMENTS,
270: l_okl_trx_ar_adjsts_tl_rec.CREATED_BY,
271: l_okl_trx_ar_adjsts_tl_rec.CREATION_DATE,
272: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATED_BY,
273: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_DATE,
274: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_LOGIN;

Line 271: l_okl_trx_ar_adjsts_tl_rec.CREATION_DATE,

267: l_okl_trx_ar_adjsts_tl_rec.SOURCE_LANG,
268: l_okl_trx_ar_adjsts_tl_rec.SFWT_FLAG,
269: l_okl_trx_ar_adjsts_tl_rec.COMMENTS,
270: l_okl_trx_ar_adjsts_tl_rec.CREATED_BY,
271: l_okl_trx_ar_adjsts_tl_rec.CREATION_DATE,
272: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATED_BY,
273: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_DATE,
274: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_LOGIN;
275: x_no_data_found := okl_trx_ar_adjsts_tl_pk_csr%NOTFOUND;

Line 272: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATED_BY,

268: l_okl_trx_ar_adjsts_tl_rec.SFWT_FLAG,
269: l_okl_trx_ar_adjsts_tl_rec.COMMENTS,
270: l_okl_trx_ar_adjsts_tl_rec.CREATED_BY,
271: l_okl_trx_ar_adjsts_tl_rec.CREATION_DATE,
272: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATED_BY,
273: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_DATE,
274: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_LOGIN;
275: x_no_data_found := okl_trx_ar_adjsts_tl_pk_csr%NOTFOUND;
276: CLOSE okl_trx_ar_adjsts_tl_pk_csr;

Line 273: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_DATE,

269: l_okl_trx_ar_adjsts_tl_rec.COMMENTS,
270: l_okl_trx_ar_adjsts_tl_rec.CREATED_BY,
271: l_okl_trx_ar_adjsts_tl_rec.CREATION_DATE,
272: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATED_BY,
273: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_DATE,
274: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_LOGIN;
275: x_no_data_found := okl_trx_ar_adjsts_tl_pk_csr%NOTFOUND;
276: CLOSE okl_trx_ar_adjsts_tl_pk_csr;
277: RETURN(l_okl_trx_ar_adjsts_tl_rec);

Line 274: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_LOGIN;

270: l_okl_trx_ar_adjsts_tl_rec.CREATED_BY,
271: l_okl_trx_ar_adjsts_tl_rec.CREATION_DATE,
272: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATED_BY,
273: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_DATE,
274: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_LOGIN;
275: x_no_data_found := okl_trx_ar_adjsts_tl_pk_csr%NOTFOUND;
276: CLOSE okl_trx_ar_adjsts_tl_pk_csr;
277: RETURN(l_okl_trx_ar_adjsts_tl_rec);
278: END get_rec;

Line 275: x_no_data_found := okl_trx_ar_adjsts_tl_pk_csr%NOTFOUND;

271: l_okl_trx_ar_adjsts_tl_rec.CREATION_DATE,
272: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATED_BY,
273: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_DATE,
274: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_LOGIN;
275: x_no_data_found := okl_trx_ar_adjsts_tl_pk_csr%NOTFOUND;
276: CLOSE okl_trx_ar_adjsts_tl_pk_csr;
277: RETURN(l_okl_trx_ar_adjsts_tl_rec);
278: END get_rec;
279:

Line 276: CLOSE okl_trx_ar_adjsts_tl_pk_csr;

272: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATED_BY,
273: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_DATE,
274: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_LOGIN;
275: x_no_data_found := okl_trx_ar_adjsts_tl_pk_csr%NOTFOUND;
276: CLOSE okl_trx_ar_adjsts_tl_pk_csr;
277: RETURN(l_okl_trx_ar_adjsts_tl_rec);
278: END get_rec;
279:
280: FUNCTION get_rec (

Line 277: RETURN(l_okl_trx_ar_adjsts_tl_rec);

273: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_DATE,
274: l_okl_trx_ar_adjsts_tl_rec.LAST_UPDATE_LOGIN;
275: x_no_data_found := okl_trx_ar_adjsts_tl_pk_csr%NOTFOUND;
276: CLOSE okl_trx_ar_adjsts_tl_pk_csr;
277: RETURN(l_okl_trx_ar_adjsts_tl_rec);
278: END get_rec;
279:
280: FUNCTION get_rec (
281: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type

Line 281: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type

277: RETURN(l_okl_trx_ar_adjsts_tl_rec);
278: END get_rec;
279:
280: FUNCTION get_rec (
281: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type
282: ) RETURN okl_trx_ar_adjsts_tl_rec_type IS
283: l_row_notfound BOOLEAN := TRUE;
284: BEGIN
285: RETURN(get_rec(p_okl_trx_ar_adjsts_tl_rec, l_row_notfound));

Line 282: ) RETURN okl_trx_ar_adjsts_tl_rec_type IS

278: END get_rec;
279:
280: FUNCTION get_rec (
281: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type
282: ) RETURN okl_trx_ar_adjsts_tl_rec_type IS
283: l_row_notfound BOOLEAN := TRUE;
284: BEGIN
285: RETURN(get_rec(p_okl_trx_ar_adjsts_tl_rec, l_row_notfound));
286: END get_rec;

Line 285: RETURN(get_rec(p_okl_trx_ar_adjsts_tl_rec, l_row_notfound));

281: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type
282: ) RETURN okl_trx_ar_adjsts_tl_rec_type IS
283: l_row_notfound BOOLEAN := TRUE;
284: BEGIN
285: RETURN(get_rec(p_okl_trx_ar_adjsts_tl_rec, l_row_notfound));
286: END get_rec;
287: ---------------------------------------------------------------------------
288: -- FUNCTION get_rec for: OKL_TRX_AR_ADJSTS_V
289: ---------------------------------------------------------------------------

Line 1279: p_to IN OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type

1275: --gkhuntet end 02-Nov-07
1276: END migrate;
1277: PROCEDURE migrate (
1278: p_from IN adjv_rec_type,
1279: p_to IN OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type
1280: ) IS
1281: BEGIN
1282: p_to.id := p_from.id;
1283: p_to.sfwt_flag := p_from.sfwt_flag;

Line 1292: p_from IN okl_trx_ar_adjsts_tl_rec_type,

1288: p_to.last_update_date := p_from.last_update_date;
1289: p_to.last_update_login := p_from.last_update_login;
1290: END migrate;
1291: PROCEDURE migrate (
1292: p_from IN okl_trx_ar_adjsts_tl_rec_type,
1293: p_to IN OUT NOCOPY adjv_rec_type
1294: ) IS
1295: BEGIN
1296: p_to.id := p_from.id;

Line 1325: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;

1321: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1322: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1323: l_adjv_rec adjv_rec_type := p_adjv_rec;
1324: l_adj_rec adj_rec_type;
1325: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;
1326: BEGIN
1327: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1328: G_PKG_NAME,
1329: p_init_msg_list,

Line 1644: -- insert_row for:OKL_TRX_AR_ADJSTS_TL --

1640: '_PVT'
1641: );
1642: END insert_row;
1643: -----------------------------------------
1644: -- insert_row for:OKL_TRX_AR_ADJSTS_TL --
1645: -----------------------------------------
1646: PROCEDURE insert_row(
1647: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1648: x_return_status OUT NOCOPY VARCHAR2,

Line 1651: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,

1647: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1648: x_return_status OUT NOCOPY VARCHAR2,
1649: x_msg_count OUT NOCOPY NUMBER,
1650: x_msg_data OUT NOCOPY VARCHAR2,
1651: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
1652: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type) IS
1653:
1654: l_api_version CONSTANT NUMBER := 1;
1655: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1652: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type) IS

1648: x_return_status OUT NOCOPY VARCHAR2,
1649: x_msg_count OUT NOCOPY NUMBER,
1650: x_msg_data OUT NOCOPY VARCHAR2,
1651: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
1652: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type) IS
1653:
1654: l_api_version CONSTANT NUMBER := 1;
1655: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1656: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1657: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type := p_okl_trx_ar_adjsts_tl_rec;

1653:
1654: l_api_version CONSTANT NUMBER := 1;
1655: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1656: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1657: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type := p_okl_trx_ar_adjsts_tl_rec;
1658: ldefokltrxaradjststlrec okl_trx_ar_adjsts_tl_rec_type;
1659: CURSOR get_languages IS
1660: SELECT *
1661: FROM FND_LANGUAGES

Line 1658: ldefokltrxaradjststlrec okl_trx_ar_adjsts_tl_rec_type;

1654: l_api_version CONSTANT NUMBER := 1;
1655: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1656: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1657: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type := p_okl_trx_ar_adjsts_tl_rec;
1658: ldefokltrxaradjststlrec okl_trx_ar_adjsts_tl_rec_type;
1659: CURSOR get_languages IS
1660: SELECT *
1661: FROM FND_LANGUAGES
1662: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1664: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_TL --

1660: SELECT *
1661: FROM FND_LANGUAGES
1662: WHERE INSTALLED_FLAG IN ('I', 'B');
1663: ---------------------------------------------
1664: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_TL --
1665: ---------------------------------------------
1666: FUNCTION Set_Attributes (
1667: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
1668: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type

Line 1667: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,

1663: ---------------------------------------------
1664: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_TL --
1665: ---------------------------------------------
1666: FUNCTION Set_Attributes (
1667: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
1668: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type
1669: ) RETURN VARCHAR2 IS
1670: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1671: BEGIN

Line 1668: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type

1664: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_TL --
1665: ---------------------------------------------
1666: FUNCTION Set_Attributes (
1667: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
1668: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type
1669: ) RETURN VARCHAR2 IS
1670: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1671: BEGIN
1672: x_okl_trx_ar_adjsts_tl_rec := p_okl_trx_ar_adjsts_tl_rec;

Line 1672: x_okl_trx_ar_adjsts_tl_rec := p_okl_trx_ar_adjsts_tl_rec;

1668: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type
1669: ) RETURN VARCHAR2 IS
1670: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1671: BEGIN
1672: x_okl_trx_ar_adjsts_tl_rec := p_okl_trx_ar_adjsts_tl_rec;
1673: x_okl_trx_ar_adjsts_tl_rec.LANGUAGE := USERENV('LANG');
1674: x_okl_trx_ar_adjsts_tl_rec.SOURCE_LANG := USERENV('LANG');
1675: RETURN(l_return_status);
1676: END Set_Attributes;

Line 1673: x_okl_trx_ar_adjsts_tl_rec.LANGUAGE := USERENV('LANG');

1669: ) RETURN VARCHAR2 IS
1670: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1671: BEGIN
1672: x_okl_trx_ar_adjsts_tl_rec := p_okl_trx_ar_adjsts_tl_rec;
1673: x_okl_trx_ar_adjsts_tl_rec.LANGUAGE := USERENV('LANG');
1674: x_okl_trx_ar_adjsts_tl_rec.SOURCE_LANG := USERENV('LANG');
1675: RETURN(l_return_status);
1676: END Set_Attributes;
1677: BEGIN

Line 1674: x_okl_trx_ar_adjsts_tl_rec.SOURCE_LANG := USERENV('LANG');

1670: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1671: BEGIN
1672: x_okl_trx_ar_adjsts_tl_rec := p_okl_trx_ar_adjsts_tl_rec;
1673: x_okl_trx_ar_adjsts_tl_rec.LANGUAGE := USERENV('LANG');
1674: x_okl_trx_ar_adjsts_tl_rec.SOURCE_LANG := USERENV('LANG');
1675: RETURN(l_return_status);
1676: END Set_Attributes;
1677: BEGIN
1678: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1689: p_okl_trx_ar_adjsts_tl_rec, -- IN

1685: RAISE OKL_API.G_EXCEPTION_ERROR;
1686: END IF;
1687: --- Setting item attributes
1688: l_return_status := Set_Attributes(
1689: p_okl_trx_ar_adjsts_tl_rec, -- IN
1690: l_okl_trx_ar_adjsts_tl_rec); -- OUT
1691: --- If any errors happen abort API
1692: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1690: l_okl_trx_ar_adjsts_tl_rec); -- OUT

1686: END IF;
1687: --- Setting item attributes
1688: l_return_status := Set_Attributes(
1689: p_okl_trx_ar_adjsts_tl_rec, -- IN
1690: l_okl_trx_ar_adjsts_tl_rec); -- OUT
1691: --- If any errors happen abort API
1692: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1694: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 1698: l_okl_trx_ar_adjsts_tl_rec.language := l_lang_rec.language_code;

1694: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1695: RAISE OKL_API.G_EXCEPTION_ERROR;
1696: END IF;
1697: FOR l_lang_rec IN get_languages LOOP
1698: l_okl_trx_ar_adjsts_tl_rec.language := l_lang_rec.language_code;
1699: INSERT INTO OKL_TRX_AR_ADJSTS_TL(
1700: id,
1701: language,
1702: source_lang,

Line 1699: INSERT INTO OKL_TRX_AR_ADJSTS_TL(

1695: RAISE OKL_API.G_EXCEPTION_ERROR;
1696: END IF;
1697: FOR l_lang_rec IN get_languages LOOP
1698: l_okl_trx_ar_adjsts_tl_rec.language := l_lang_rec.language_code;
1699: INSERT INTO OKL_TRX_AR_ADJSTS_TL(
1700: id,
1701: language,
1702: source_lang,
1703: sfwt_flag,

Line 1711: l_okl_trx_ar_adjsts_tl_rec.id,

1707: last_updated_by,
1708: last_update_date,
1709: last_update_login)
1710: VALUES (
1711: l_okl_trx_ar_adjsts_tl_rec.id,
1712: l_okl_trx_ar_adjsts_tl_rec.language,
1713: l_okl_trx_ar_adjsts_tl_rec.source_lang,
1714: l_okl_trx_ar_adjsts_tl_rec.sfwt_flag,
1715: l_okl_trx_ar_adjsts_tl_rec.comments,

Line 1712: l_okl_trx_ar_adjsts_tl_rec.language,

1708: last_update_date,
1709: last_update_login)
1710: VALUES (
1711: l_okl_trx_ar_adjsts_tl_rec.id,
1712: l_okl_trx_ar_adjsts_tl_rec.language,
1713: l_okl_trx_ar_adjsts_tl_rec.source_lang,
1714: l_okl_trx_ar_adjsts_tl_rec.sfwt_flag,
1715: l_okl_trx_ar_adjsts_tl_rec.comments,
1716: l_okl_trx_ar_adjsts_tl_rec.created_by,

Line 1713: l_okl_trx_ar_adjsts_tl_rec.source_lang,

1709: last_update_login)
1710: VALUES (
1711: l_okl_trx_ar_adjsts_tl_rec.id,
1712: l_okl_trx_ar_adjsts_tl_rec.language,
1713: l_okl_trx_ar_adjsts_tl_rec.source_lang,
1714: l_okl_trx_ar_adjsts_tl_rec.sfwt_flag,
1715: l_okl_trx_ar_adjsts_tl_rec.comments,
1716: l_okl_trx_ar_adjsts_tl_rec.created_by,
1717: l_okl_trx_ar_adjsts_tl_rec.creation_date,

Line 1714: l_okl_trx_ar_adjsts_tl_rec.sfwt_flag,

1710: VALUES (
1711: l_okl_trx_ar_adjsts_tl_rec.id,
1712: l_okl_trx_ar_adjsts_tl_rec.language,
1713: l_okl_trx_ar_adjsts_tl_rec.source_lang,
1714: l_okl_trx_ar_adjsts_tl_rec.sfwt_flag,
1715: l_okl_trx_ar_adjsts_tl_rec.comments,
1716: l_okl_trx_ar_adjsts_tl_rec.created_by,
1717: l_okl_trx_ar_adjsts_tl_rec.creation_date,
1718: l_okl_trx_ar_adjsts_tl_rec.last_updated_by,

Line 1715: l_okl_trx_ar_adjsts_tl_rec.comments,

1711: l_okl_trx_ar_adjsts_tl_rec.id,
1712: l_okl_trx_ar_adjsts_tl_rec.language,
1713: l_okl_trx_ar_adjsts_tl_rec.source_lang,
1714: l_okl_trx_ar_adjsts_tl_rec.sfwt_flag,
1715: l_okl_trx_ar_adjsts_tl_rec.comments,
1716: l_okl_trx_ar_adjsts_tl_rec.created_by,
1717: l_okl_trx_ar_adjsts_tl_rec.creation_date,
1718: l_okl_trx_ar_adjsts_tl_rec.last_updated_by,
1719: l_okl_trx_ar_adjsts_tl_rec.last_update_date,

Line 1716: l_okl_trx_ar_adjsts_tl_rec.created_by,

1712: l_okl_trx_ar_adjsts_tl_rec.language,
1713: l_okl_trx_ar_adjsts_tl_rec.source_lang,
1714: l_okl_trx_ar_adjsts_tl_rec.sfwt_flag,
1715: l_okl_trx_ar_adjsts_tl_rec.comments,
1716: l_okl_trx_ar_adjsts_tl_rec.created_by,
1717: l_okl_trx_ar_adjsts_tl_rec.creation_date,
1718: l_okl_trx_ar_adjsts_tl_rec.last_updated_by,
1719: l_okl_trx_ar_adjsts_tl_rec.last_update_date,
1720: l_okl_trx_ar_adjsts_tl_rec.last_update_login);

Line 1717: l_okl_trx_ar_adjsts_tl_rec.creation_date,

1713: l_okl_trx_ar_adjsts_tl_rec.source_lang,
1714: l_okl_trx_ar_adjsts_tl_rec.sfwt_flag,
1715: l_okl_trx_ar_adjsts_tl_rec.comments,
1716: l_okl_trx_ar_adjsts_tl_rec.created_by,
1717: l_okl_trx_ar_adjsts_tl_rec.creation_date,
1718: l_okl_trx_ar_adjsts_tl_rec.last_updated_by,
1719: l_okl_trx_ar_adjsts_tl_rec.last_update_date,
1720: l_okl_trx_ar_adjsts_tl_rec.last_update_login);
1721: END LOOP;

Line 1718: l_okl_trx_ar_adjsts_tl_rec.last_updated_by,

1714: l_okl_trx_ar_adjsts_tl_rec.sfwt_flag,
1715: l_okl_trx_ar_adjsts_tl_rec.comments,
1716: l_okl_trx_ar_adjsts_tl_rec.created_by,
1717: l_okl_trx_ar_adjsts_tl_rec.creation_date,
1718: l_okl_trx_ar_adjsts_tl_rec.last_updated_by,
1719: l_okl_trx_ar_adjsts_tl_rec.last_update_date,
1720: l_okl_trx_ar_adjsts_tl_rec.last_update_login);
1721: END LOOP;
1722: -- Set OUT values

Line 1719: l_okl_trx_ar_adjsts_tl_rec.last_update_date,

1715: l_okl_trx_ar_adjsts_tl_rec.comments,
1716: l_okl_trx_ar_adjsts_tl_rec.created_by,
1717: l_okl_trx_ar_adjsts_tl_rec.creation_date,
1718: l_okl_trx_ar_adjsts_tl_rec.last_updated_by,
1719: l_okl_trx_ar_adjsts_tl_rec.last_update_date,
1720: l_okl_trx_ar_adjsts_tl_rec.last_update_login);
1721: END LOOP;
1722: -- Set OUT values
1723: x_okl_trx_ar_adjsts_tl_rec := l_okl_trx_ar_adjsts_tl_rec;

Line 1720: l_okl_trx_ar_adjsts_tl_rec.last_update_login);

1716: l_okl_trx_ar_adjsts_tl_rec.created_by,
1717: l_okl_trx_ar_adjsts_tl_rec.creation_date,
1718: l_okl_trx_ar_adjsts_tl_rec.last_updated_by,
1719: l_okl_trx_ar_adjsts_tl_rec.last_update_date,
1720: l_okl_trx_ar_adjsts_tl_rec.last_update_login);
1721: END LOOP;
1722: -- Set OUT values
1723: x_okl_trx_ar_adjsts_tl_rec := l_okl_trx_ar_adjsts_tl_rec;
1724: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1723: x_okl_trx_ar_adjsts_tl_rec := l_okl_trx_ar_adjsts_tl_rec;

1719: l_okl_trx_ar_adjsts_tl_rec.last_update_date,
1720: l_okl_trx_ar_adjsts_tl_rec.last_update_login);
1721: END LOOP;
1722: -- Set OUT values
1723: x_okl_trx_ar_adjsts_tl_rec := l_okl_trx_ar_adjsts_tl_rec;
1724: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1725: EXCEPTION
1726: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1727: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 1776: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;

1772: l_adjv_rec adjv_rec_type;
1773: l_def_adjv_rec adjv_rec_type;
1774: l_adj_rec adj_rec_type;
1775: lx_adj_rec adj_rec_type;
1776: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;
1777: lx_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;
1778: -------------------------------
1779: -- FUNCTION fill_who_columns --
1780: -------------------------------

Line 1777: lx_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;

1773: l_def_adjv_rec adjv_rec_type;
1774: l_adj_rec adj_rec_type;
1775: lx_adj_rec adj_rec_type;
1776: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;
1777: lx_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;
1778: -------------------------------
1779: -- FUNCTION fill_who_columns --
1780: -------------------------------
1781: FUNCTION fill_who_columns (

Line 1873: migrate(l_def_adjv_rec, l_okl_trx_ar_adjsts_tl_rec);

1869: --------------------------------------
1870: -- Move VIEW record to "Child" records
1871: --------------------------------------
1872: migrate(l_def_adjv_rec, l_adj_rec);
1873: migrate(l_def_adjv_rec, l_okl_trx_ar_adjsts_tl_rec);
1874: --------------------------------------------
1875: -- Call the INSERT_ROW for each child record
1876: --------------------------------------------
1877: insert_row(

Line 1896: l_okl_trx_ar_adjsts_tl_rec,

1892: p_init_msg_list,
1893: x_return_status,
1894: x_msg_count,
1895: x_msg_data,
1896: l_okl_trx_ar_adjsts_tl_rec,
1897: lx_okl_trx_ar_adjsts_tl_rec
1898: );
1899: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1900: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1897: lx_okl_trx_ar_adjsts_tl_rec

1893: x_return_status,
1894: x_msg_count,
1895: x_msg_data,
1896: l_okl_trx_ar_adjsts_tl_rec,
1897: lx_okl_trx_ar_adjsts_tl_rec
1898: );
1899: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1900: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1901: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 1904: migrate(lx_okl_trx_ar_adjsts_tl_rec, l_def_adjv_rec);

1900: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1901: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1902: RAISE OKL_API.G_EXCEPTION_ERROR;
1903: END IF;
1904: migrate(lx_okl_trx_ar_adjsts_tl_rec, l_def_adjv_rec);
1905: -- Set OUT values
1906: x_adjv_rec := l_def_adjv_rec;
1907: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1908: EXCEPTION

Line 2134: -- lock_row for:OKL_TRX_AR_ADJSTS_TL --

2130: '_PVT'
2131: );
2132: END lock_row;
2133: ---------------------------------------
2134: -- lock_row for:OKL_TRX_AR_ADJSTS_TL --
2135: ---------------------------------------
2136: PROCEDURE lock_row(
2137: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2138: x_return_status OUT NOCOPY VARCHAR2,

Line 2141: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type) IS

2137: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2138: x_return_status OUT NOCOPY VARCHAR2,
2139: x_msg_count OUT NOCOPY NUMBER,
2140: x_msg_data OUT NOCOPY VARCHAR2,
2141: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type) IS
2142:
2143: E_Resource_Busy EXCEPTION;
2144: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2145: CURSOR lock_csr (p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type) IS

Line 2145: CURSOR lock_csr (p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type) IS

2141: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type) IS
2142:
2143: E_Resource_Busy EXCEPTION;
2144: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2145: CURSOR lock_csr (p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type) IS
2146: SELECT *
2147: FROM OKL_TRX_AR_ADJSTS_TL
2148: WHERE ID = p_okl_trx_ar_adjsts_tl_rec.id
2149: FOR UPDATE NOWAIT;

Line 2147: FROM OKL_TRX_AR_ADJSTS_TL

2143: E_Resource_Busy EXCEPTION;
2144: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2145: CURSOR lock_csr (p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type) IS
2146: SELECT *
2147: FROM OKL_TRX_AR_ADJSTS_TL
2148: WHERE ID = p_okl_trx_ar_adjsts_tl_rec.id
2149: FOR UPDATE NOWAIT;
2150:
2151: l_api_version CONSTANT NUMBER := 1;

Line 2148: WHERE ID = p_okl_trx_ar_adjsts_tl_rec.id

2144: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2145: CURSOR lock_csr (p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type) IS
2146: SELECT *
2147: FROM OKL_TRX_AR_ADJSTS_TL
2148: WHERE ID = p_okl_trx_ar_adjsts_tl_rec.id
2149: FOR UPDATE NOWAIT;
2150:
2151: l_api_version CONSTANT NUMBER := 1;
2152: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2168: OPEN lock_csr(p_okl_trx_ar_adjsts_tl_rec);

2164: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2165: RAISE OKL_API.G_EXCEPTION_ERROR;
2166: END IF;
2167: BEGIN
2168: OPEN lock_csr(p_okl_trx_ar_adjsts_tl_rec);
2169: FETCH lock_csr INTO l_lock_var;
2170: l_row_notfound := lock_csr%NOTFOUND;
2171: CLOSE lock_csr;
2172: EXCEPTION

Line 2233: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;

2229: l_api_version CONSTANT NUMBER := 1;
2230: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2231: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2232: l_adj_rec adj_rec_type;
2233: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;
2234: BEGIN
2235: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2236: G_PKG_NAME,
2237: p_init_msg_list,

Line 2251: migrate(p_adjv_rec, l_okl_trx_ar_adjsts_tl_rec);

2247: --------------------------------------
2248: -- Move VIEW record to "Child" records
2249: --------------------------------------
2250: migrate(p_adjv_rec, l_adj_rec);
2251: migrate(p_adjv_rec, l_okl_trx_ar_adjsts_tl_rec);
2252: --------------------------------------------
2253: -- Call the LOCK_ROW for each child record
2254: --------------------------------------------
2255: lock_row(

Line 2272: l_okl_trx_ar_adjsts_tl_rec

2268: p_init_msg_list,
2269: x_return_status,
2270: x_msg_count,
2271: x_msg_data,
2272: l_okl_trx_ar_adjsts_tl_rec
2273: );
2274: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2275: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2276: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 2694: -- update_row for:OKL_TRX_AR_ADJSTS_TL --

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

Line 2701: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,

2697: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
2702: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_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_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_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_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
2702: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_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_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type := p_okl_trx_ar_adjsts_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_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type := p_okl_trx_ar_adjsts_tl_rec;
2708: ldefokltrxaradjststlrec okl_trx_ar_adjsts_tl_rec_type;
2709: l_row_notfound BOOLEAN := TRUE;
2710: ----------------------------------
2711: -- FUNCTION populate_new_record --

Line 2708: ldefokltrxaradjststlrec okl_trx_ar_adjsts_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_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type := p_okl_trx_ar_adjsts_tl_rec;
2708: ldefokltrxaradjststlrec okl_trx_ar_adjsts_tl_rec_type;
2709: l_row_notfound BOOLEAN := TRUE;
2710: ----------------------------------
2711: -- FUNCTION populate_new_record --
2712: ----------------------------------

Line 2714: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,

2710: ----------------------------------
2711: -- FUNCTION populate_new_record --
2712: ----------------------------------
2713: FUNCTION populate_new_record (
2714: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
2715: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type
2716: ) RETURN VARCHAR2 IS
2717: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;
2718: l_row_notfound BOOLEAN := TRUE;

Line 2715: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type

2711: -- FUNCTION populate_new_record --
2712: ----------------------------------
2713: FUNCTION populate_new_record (
2714: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
2715: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type
2716: ) RETURN VARCHAR2 IS
2717: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_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_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;

2713: FUNCTION populate_new_record (
2714: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
2715: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type
2716: ) RETURN VARCHAR2 IS
2717: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;
2718: l_row_notfound BOOLEAN := TRUE;
2719: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2720: BEGIN
2721:

Line 2722: x_okl_trx_ar_adjsts_tl_rec := p_okl_trx_ar_adjsts_tl_rec;

2718: l_row_notfound BOOLEAN := TRUE;
2719: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2720: BEGIN
2721:
2722: x_okl_trx_ar_adjsts_tl_rec := p_okl_trx_ar_adjsts_tl_rec;
2723: -- Get current database values
2724: l_okl_trx_ar_adjsts_tl_rec := get_rec(p_okl_trx_ar_adjsts_tl_rec, l_row_notfound);
2725: IF (l_row_notfound) THEN
2726: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2724: l_okl_trx_ar_adjsts_tl_rec := get_rec(p_okl_trx_ar_adjsts_tl_rec, l_row_notfound);

2720: BEGIN
2721:
2722: x_okl_trx_ar_adjsts_tl_rec := p_okl_trx_ar_adjsts_tl_rec;
2723: -- Get current database values
2724: l_okl_trx_ar_adjsts_tl_rec := get_rec(p_okl_trx_ar_adjsts_tl_rec, l_row_notfound);
2725: IF (l_row_notfound) THEN
2726: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2727: END IF;
2728: IF (x_okl_trx_ar_adjsts_tl_rec.id = OKL_API.G_MISS_NUM)

Line 2728: IF (x_okl_trx_ar_adjsts_tl_rec.id = OKL_API.G_MISS_NUM)

2724: l_okl_trx_ar_adjsts_tl_rec := get_rec(p_okl_trx_ar_adjsts_tl_rec, l_row_notfound);
2725: IF (l_row_notfound) THEN
2726: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2727: END IF;
2728: IF (x_okl_trx_ar_adjsts_tl_rec.id = OKL_API.G_MISS_NUM)
2729: THEN
2730: x_okl_trx_ar_adjsts_tl_rec.id := l_okl_trx_ar_adjsts_tl_rec.id;
2731: END IF;
2732: IF (x_okl_trx_ar_adjsts_tl_rec.language = OKL_API.G_MISS_CHAR)

Line 2730: x_okl_trx_ar_adjsts_tl_rec.id := l_okl_trx_ar_adjsts_tl_rec.id;

2726: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2727: END IF;
2728: IF (x_okl_trx_ar_adjsts_tl_rec.id = OKL_API.G_MISS_NUM)
2729: THEN
2730: x_okl_trx_ar_adjsts_tl_rec.id := l_okl_trx_ar_adjsts_tl_rec.id;
2731: END IF;
2732: IF (x_okl_trx_ar_adjsts_tl_rec.language = OKL_API.G_MISS_CHAR)
2733: THEN
2734: x_okl_trx_ar_adjsts_tl_rec.language := l_okl_trx_ar_adjsts_tl_rec.language;

Line 2732: IF (x_okl_trx_ar_adjsts_tl_rec.language = OKL_API.G_MISS_CHAR)

2728: IF (x_okl_trx_ar_adjsts_tl_rec.id = OKL_API.G_MISS_NUM)
2729: THEN
2730: x_okl_trx_ar_adjsts_tl_rec.id := l_okl_trx_ar_adjsts_tl_rec.id;
2731: END IF;
2732: IF (x_okl_trx_ar_adjsts_tl_rec.language = OKL_API.G_MISS_CHAR)
2733: THEN
2734: x_okl_trx_ar_adjsts_tl_rec.language := l_okl_trx_ar_adjsts_tl_rec.language;
2735: END IF;
2736: IF (x_okl_trx_ar_adjsts_tl_rec.source_lang = OKL_API.G_MISS_CHAR)

Line 2734: x_okl_trx_ar_adjsts_tl_rec.language := l_okl_trx_ar_adjsts_tl_rec.language;

2730: x_okl_trx_ar_adjsts_tl_rec.id := l_okl_trx_ar_adjsts_tl_rec.id;
2731: END IF;
2732: IF (x_okl_trx_ar_adjsts_tl_rec.language = OKL_API.G_MISS_CHAR)
2733: THEN
2734: x_okl_trx_ar_adjsts_tl_rec.language := l_okl_trx_ar_adjsts_tl_rec.language;
2735: END IF;
2736: IF (x_okl_trx_ar_adjsts_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2737: THEN
2738: x_okl_trx_ar_adjsts_tl_rec.source_lang := l_okl_trx_ar_adjsts_tl_rec.source_lang;

Line 2736: IF (x_okl_trx_ar_adjsts_tl_rec.source_lang = OKL_API.G_MISS_CHAR)

2732: IF (x_okl_trx_ar_adjsts_tl_rec.language = OKL_API.G_MISS_CHAR)
2733: THEN
2734: x_okl_trx_ar_adjsts_tl_rec.language := l_okl_trx_ar_adjsts_tl_rec.language;
2735: END IF;
2736: IF (x_okl_trx_ar_adjsts_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2737: THEN
2738: x_okl_trx_ar_adjsts_tl_rec.source_lang := l_okl_trx_ar_adjsts_tl_rec.source_lang;
2739: END IF;
2740: IF (x_okl_trx_ar_adjsts_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)

Line 2738: x_okl_trx_ar_adjsts_tl_rec.source_lang := l_okl_trx_ar_adjsts_tl_rec.source_lang;

2734: x_okl_trx_ar_adjsts_tl_rec.language := l_okl_trx_ar_adjsts_tl_rec.language;
2735: END IF;
2736: IF (x_okl_trx_ar_adjsts_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2737: THEN
2738: x_okl_trx_ar_adjsts_tl_rec.source_lang := l_okl_trx_ar_adjsts_tl_rec.source_lang;
2739: END IF;
2740: IF (x_okl_trx_ar_adjsts_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2741: THEN
2742: x_okl_trx_ar_adjsts_tl_rec.sfwt_flag := l_okl_trx_ar_adjsts_tl_rec.sfwt_flag;

Line 2740: IF (x_okl_trx_ar_adjsts_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)

2736: IF (x_okl_trx_ar_adjsts_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2737: THEN
2738: x_okl_trx_ar_adjsts_tl_rec.source_lang := l_okl_trx_ar_adjsts_tl_rec.source_lang;
2739: END IF;
2740: IF (x_okl_trx_ar_adjsts_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2741: THEN
2742: x_okl_trx_ar_adjsts_tl_rec.sfwt_flag := l_okl_trx_ar_adjsts_tl_rec.sfwt_flag;
2743: END IF;
2744: IF (x_okl_trx_ar_adjsts_tl_rec.comments = OKL_API.G_MISS_CHAR)

Line 2742: x_okl_trx_ar_adjsts_tl_rec.sfwt_flag := l_okl_trx_ar_adjsts_tl_rec.sfwt_flag;

2738: x_okl_trx_ar_adjsts_tl_rec.source_lang := l_okl_trx_ar_adjsts_tl_rec.source_lang;
2739: END IF;
2740: IF (x_okl_trx_ar_adjsts_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2741: THEN
2742: x_okl_trx_ar_adjsts_tl_rec.sfwt_flag := l_okl_trx_ar_adjsts_tl_rec.sfwt_flag;
2743: END IF;
2744: IF (x_okl_trx_ar_adjsts_tl_rec.comments = OKL_API.G_MISS_CHAR)
2745: THEN
2746: x_okl_trx_ar_adjsts_tl_rec.comments := l_okl_trx_ar_adjsts_tl_rec.comments;

Line 2744: IF (x_okl_trx_ar_adjsts_tl_rec.comments = OKL_API.G_MISS_CHAR)

2740: IF (x_okl_trx_ar_adjsts_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2741: THEN
2742: x_okl_trx_ar_adjsts_tl_rec.sfwt_flag := l_okl_trx_ar_adjsts_tl_rec.sfwt_flag;
2743: END IF;
2744: IF (x_okl_trx_ar_adjsts_tl_rec.comments = OKL_API.G_MISS_CHAR)
2745: THEN
2746: x_okl_trx_ar_adjsts_tl_rec.comments := l_okl_trx_ar_adjsts_tl_rec.comments;
2747: END IF;
2748: IF (x_okl_trx_ar_adjsts_tl_rec.created_by = OKL_API.G_MISS_NUM)

Line 2746: x_okl_trx_ar_adjsts_tl_rec.comments := l_okl_trx_ar_adjsts_tl_rec.comments;

2742: x_okl_trx_ar_adjsts_tl_rec.sfwt_flag := l_okl_trx_ar_adjsts_tl_rec.sfwt_flag;
2743: END IF;
2744: IF (x_okl_trx_ar_adjsts_tl_rec.comments = OKL_API.G_MISS_CHAR)
2745: THEN
2746: x_okl_trx_ar_adjsts_tl_rec.comments := l_okl_trx_ar_adjsts_tl_rec.comments;
2747: END IF;
2748: IF (x_okl_trx_ar_adjsts_tl_rec.created_by = OKL_API.G_MISS_NUM)
2749: THEN
2750: x_okl_trx_ar_adjsts_tl_rec.created_by := l_okl_trx_ar_adjsts_tl_rec.created_by;

Line 2748: IF (x_okl_trx_ar_adjsts_tl_rec.created_by = OKL_API.G_MISS_NUM)

2744: IF (x_okl_trx_ar_adjsts_tl_rec.comments = OKL_API.G_MISS_CHAR)
2745: THEN
2746: x_okl_trx_ar_adjsts_tl_rec.comments := l_okl_trx_ar_adjsts_tl_rec.comments;
2747: END IF;
2748: IF (x_okl_trx_ar_adjsts_tl_rec.created_by = OKL_API.G_MISS_NUM)
2749: THEN
2750: x_okl_trx_ar_adjsts_tl_rec.created_by := l_okl_trx_ar_adjsts_tl_rec.created_by;
2751: END IF;
2752: IF (x_okl_trx_ar_adjsts_tl_rec.creation_date = OKL_API.G_MISS_DATE)

Line 2750: x_okl_trx_ar_adjsts_tl_rec.created_by := l_okl_trx_ar_adjsts_tl_rec.created_by;

2746: x_okl_trx_ar_adjsts_tl_rec.comments := l_okl_trx_ar_adjsts_tl_rec.comments;
2747: END IF;
2748: IF (x_okl_trx_ar_adjsts_tl_rec.created_by = OKL_API.G_MISS_NUM)
2749: THEN
2750: x_okl_trx_ar_adjsts_tl_rec.created_by := l_okl_trx_ar_adjsts_tl_rec.created_by;
2751: END IF;
2752: IF (x_okl_trx_ar_adjsts_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2753: THEN
2754: x_okl_trx_ar_adjsts_tl_rec.creation_date := l_okl_trx_ar_adjsts_tl_rec.creation_date;

Line 2752: IF (x_okl_trx_ar_adjsts_tl_rec.creation_date = OKL_API.G_MISS_DATE)

2748: IF (x_okl_trx_ar_adjsts_tl_rec.created_by = OKL_API.G_MISS_NUM)
2749: THEN
2750: x_okl_trx_ar_adjsts_tl_rec.created_by := l_okl_trx_ar_adjsts_tl_rec.created_by;
2751: END IF;
2752: IF (x_okl_trx_ar_adjsts_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2753: THEN
2754: x_okl_trx_ar_adjsts_tl_rec.creation_date := l_okl_trx_ar_adjsts_tl_rec.creation_date;
2755: END IF;
2756: IF (x_okl_trx_ar_adjsts_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 2754: x_okl_trx_ar_adjsts_tl_rec.creation_date := l_okl_trx_ar_adjsts_tl_rec.creation_date;

2750: x_okl_trx_ar_adjsts_tl_rec.created_by := l_okl_trx_ar_adjsts_tl_rec.created_by;
2751: END IF;
2752: IF (x_okl_trx_ar_adjsts_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2753: THEN
2754: x_okl_trx_ar_adjsts_tl_rec.creation_date := l_okl_trx_ar_adjsts_tl_rec.creation_date;
2755: END IF;
2756: IF (x_okl_trx_ar_adjsts_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2757: THEN
2758: x_okl_trx_ar_adjsts_tl_rec.last_updated_by := l_okl_trx_ar_adjsts_tl_rec.last_updated_by;

Line 2756: IF (x_okl_trx_ar_adjsts_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)

2752: IF (x_okl_trx_ar_adjsts_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2753: THEN
2754: x_okl_trx_ar_adjsts_tl_rec.creation_date := l_okl_trx_ar_adjsts_tl_rec.creation_date;
2755: END IF;
2756: IF (x_okl_trx_ar_adjsts_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2757: THEN
2758: x_okl_trx_ar_adjsts_tl_rec.last_updated_by := l_okl_trx_ar_adjsts_tl_rec.last_updated_by;
2759: END IF;
2760: IF (x_okl_trx_ar_adjsts_tl_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 2758: x_okl_trx_ar_adjsts_tl_rec.last_updated_by := l_okl_trx_ar_adjsts_tl_rec.last_updated_by;

2754: x_okl_trx_ar_adjsts_tl_rec.creation_date := l_okl_trx_ar_adjsts_tl_rec.creation_date;
2755: END IF;
2756: IF (x_okl_trx_ar_adjsts_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2757: THEN
2758: x_okl_trx_ar_adjsts_tl_rec.last_updated_by := l_okl_trx_ar_adjsts_tl_rec.last_updated_by;
2759: END IF;
2760: IF (x_okl_trx_ar_adjsts_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2761: THEN
2762: x_okl_trx_ar_adjsts_tl_rec.last_update_date := l_okl_trx_ar_adjsts_tl_rec.last_update_date;

Line 2760: IF (x_okl_trx_ar_adjsts_tl_rec.last_update_date = OKL_API.G_MISS_DATE)

2756: IF (x_okl_trx_ar_adjsts_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2757: THEN
2758: x_okl_trx_ar_adjsts_tl_rec.last_updated_by := l_okl_trx_ar_adjsts_tl_rec.last_updated_by;
2759: END IF;
2760: IF (x_okl_trx_ar_adjsts_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2761: THEN
2762: x_okl_trx_ar_adjsts_tl_rec.last_update_date := l_okl_trx_ar_adjsts_tl_rec.last_update_date;
2763: END IF;
2764: IF (x_okl_trx_ar_adjsts_tl_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 2762: x_okl_trx_ar_adjsts_tl_rec.last_update_date := l_okl_trx_ar_adjsts_tl_rec.last_update_date;

2758: x_okl_trx_ar_adjsts_tl_rec.last_updated_by := l_okl_trx_ar_adjsts_tl_rec.last_updated_by;
2759: END IF;
2760: IF (x_okl_trx_ar_adjsts_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2761: THEN
2762: x_okl_trx_ar_adjsts_tl_rec.last_update_date := l_okl_trx_ar_adjsts_tl_rec.last_update_date;
2763: END IF;
2764: IF (x_okl_trx_ar_adjsts_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
2765: THEN
2766: x_okl_trx_ar_adjsts_tl_rec.last_update_login := l_okl_trx_ar_adjsts_tl_rec.last_update_login;

Line 2764: IF (x_okl_trx_ar_adjsts_tl_rec.last_update_login = OKL_API.G_MISS_NUM)

2760: IF (x_okl_trx_ar_adjsts_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2761: THEN
2762: x_okl_trx_ar_adjsts_tl_rec.last_update_date := l_okl_trx_ar_adjsts_tl_rec.last_update_date;
2763: END IF;
2764: IF (x_okl_trx_ar_adjsts_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
2765: THEN
2766: x_okl_trx_ar_adjsts_tl_rec.last_update_login := l_okl_trx_ar_adjsts_tl_rec.last_update_login;
2767: END IF;
2768:

Line 2766: x_okl_trx_ar_adjsts_tl_rec.last_update_login := l_okl_trx_ar_adjsts_tl_rec.last_update_login;

2762: x_okl_trx_ar_adjsts_tl_rec.last_update_date := l_okl_trx_ar_adjsts_tl_rec.last_update_date;
2763: END IF;
2764: IF (x_okl_trx_ar_adjsts_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
2765: THEN
2766: x_okl_trx_ar_adjsts_tl_rec.last_update_login := l_okl_trx_ar_adjsts_tl_rec.last_update_login;
2767: END IF;
2768:
2769: RETURN(l_return_status);
2770:

Line 2773: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_TL --

2769: RETURN(l_return_status);
2770:
2771: END populate_new_record;
2772: ---------------------------------------------
2773: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_TL --
2774: ---------------------------------------------
2775: FUNCTION Set_Attributes (
2776: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
2777: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type

Line 2776: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,

2772: ---------------------------------------------
2773: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_TL --
2774: ---------------------------------------------
2775: FUNCTION Set_Attributes (
2776: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
2777: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type
2778: ) RETURN VARCHAR2 IS
2779: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2780: BEGIN

Line 2777: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type

2773: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_TL --
2774: ---------------------------------------------
2775: FUNCTION Set_Attributes (
2776: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
2777: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type
2778: ) RETURN VARCHAR2 IS
2779: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2780: BEGIN
2781: x_okl_trx_ar_adjsts_tl_rec := p_okl_trx_ar_adjsts_tl_rec;

Line 2781: x_okl_trx_ar_adjsts_tl_rec := p_okl_trx_ar_adjsts_tl_rec;

2777: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type
2778: ) RETURN VARCHAR2 IS
2779: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2780: BEGIN
2781: x_okl_trx_ar_adjsts_tl_rec := p_okl_trx_ar_adjsts_tl_rec;
2782: x_okl_trx_ar_adjsts_tl_rec.LANGUAGE := USERENV('LANG');
2783: x_okl_trx_ar_adjsts_tl_rec.SOURCE_LANG := USERENV('LANG');
2784: RETURN(l_return_status);
2785: END Set_Attributes;

Line 2782: x_okl_trx_ar_adjsts_tl_rec.LANGUAGE := USERENV('LANG');

2778: ) RETURN VARCHAR2 IS
2779: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2780: BEGIN
2781: x_okl_trx_ar_adjsts_tl_rec := p_okl_trx_ar_adjsts_tl_rec;
2782: x_okl_trx_ar_adjsts_tl_rec.LANGUAGE := USERENV('LANG');
2783: x_okl_trx_ar_adjsts_tl_rec.SOURCE_LANG := USERENV('LANG');
2784: RETURN(l_return_status);
2785: END Set_Attributes;
2786: BEGIN

Line 2783: x_okl_trx_ar_adjsts_tl_rec.SOURCE_LANG := USERENV('LANG');

2779: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2780: BEGIN
2781: x_okl_trx_ar_adjsts_tl_rec := p_okl_trx_ar_adjsts_tl_rec;
2782: x_okl_trx_ar_adjsts_tl_rec.LANGUAGE := USERENV('LANG');
2783: x_okl_trx_ar_adjsts_tl_rec.SOURCE_LANG := USERENV('LANG');
2784: RETURN(l_return_status);
2785: END Set_Attributes;
2786: BEGIN
2787: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2799: p_okl_trx_ar_adjsts_tl_rec, -- IN

2795: RAISE OKL_API.G_EXCEPTION_ERROR;
2796: END IF;
2797: --- Setting item attributes
2798: l_return_status := Set_Attributes(
2799: p_okl_trx_ar_adjsts_tl_rec, -- IN
2800: l_okl_trx_ar_adjsts_tl_rec); -- OUT
2801: --- If any errors happen abort API
2802:
2803: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2800: l_okl_trx_ar_adjsts_tl_rec); -- OUT

2796: END IF;
2797: --- Setting item attributes
2798: l_return_status := Set_Attributes(
2799: p_okl_trx_ar_adjsts_tl_rec, -- IN
2800: l_okl_trx_ar_adjsts_tl_rec); -- OUT
2801: --- If any errors happen abort API
2802:
2803: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2804: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2809: l_return_status := populate_new_record(l_okl_trx_ar_adjsts_tl_rec, ldefokltrxaradjststlrec);

2805: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2806: RAISE OKL_API.G_EXCEPTION_ERROR;
2807: END IF;
2808:
2809: l_return_status := populate_new_record(l_okl_trx_ar_adjsts_tl_rec, ldefokltrxaradjststlrec);
2810:
2811: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2812: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2813: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 2816: UPDATE OKL_TRX_AR_ADJSTS_TL

2812: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2813: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2814: RAISE OKL_API.G_EXCEPTION_ERROR;
2815: END IF;
2816: UPDATE OKL_TRX_AR_ADJSTS_TL
2817: SET COMMENTS = ldefokltrxaradjststlrec.comments,
2818: CREATED_BY = ldefokltrxaradjststlrec.created_by,
2819: CREATION_DATE = ldefokltrxaradjststlrec.creation_date,
2820: LAST_UPDATED_BY = ldefokltrxaradjststlrec.last_updated_by,

Line 2827: UPDATE OKL_TRX_AR_ADJSTS_TL

2823: WHERE ID = ldefokltrxaradjststlrec.id
2824: --AND SOURCE_LANG = USERENV('LANG');
2825: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2826:
2827: UPDATE OKL_TRX_AR_ADJSTS_TL
2828: SET SFWT_FLAG = 'Y'
2829: WHERE ID = ldefokltrxaradjststlrec.id
2830: AND SOURCE_LANG <> USERENV('LANG');
2831:

Line 2832: x_okl_trx_ar_adjsts_tl_rec := ldefokltrxaradjststlrec;

2828: SET SFWT_FLAG = 'Y'
2829: WHERE ID = ldefokltrxaradjststlrec.id
2830: AND SOURCE_LANG <> USERENV('LANG');
2831:
2832: x_okl_trx_ar_adjsts_tl_rec := ldefokltrxaradjststlrec;
2833: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2834: EXCEPTION
2835: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2836:

Line 2884: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;

2880: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2881: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2882: l_adjv_rec adjv_rec_type := p_adjv_rec;
2883: l_def_adjv_rec adjv_rec_type;
2884: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;
2885: lx_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;
2886: l_adj_rec adj_rec_type;
2887: lx_adj_rec adj_rec_type;
2888: -------------------------------

Line 2885: lx_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;

2881: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2882: l_adjv_rec adjv_rec_type := p_adjv_rec;
2883: l_def_adjv_rec adjv_rec_type;
2884: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;
2885: lx_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;
2886: l_adj_rec adj_rec_type;
2887: lx_adj_rec adj_rec_type;
2888: -------------------------------
2889: -- FUNCTION fill_who_columns --

Line 3154: migrate(l_def_adjv_rec, l_okl_trx_ar_adjsts_tl_rec);

3150:
3151: --------------------------------------
3152: -- Move VIEW record to "Child" records
3153: --------------------------------------
3154: migrate(l_def_adjv_rec, l_okl_trx_ar_adjsts_tl_rec);
3155: migrate(l_def_adjv_rec, l_adj_rec);
3156: --------------------------------------------
3157: -- Call the UPDATE_ROW for each child record
3158: --------------------------------------------

Line 3165: l_okl_trx_ar_adjsts_tl_rec,

3161: p_init_msg_list,
3162: x_return_status,
3163: x_msg_count,
3164: x_msg_data,
3165: l_okl_trx_ar_adjsts_tl_rec,
3166: lx_okl_trx_ar_adjsts_tl_rec
3167: );
3168:
3169: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3166: lx_okl_trx_ar_adjsts_tl_rec

3162: x_return_status,
3163: x_msg_count,
3164: x_msg_data,
3165: l_okl_trx_ar_adjsts_tl_rec,
3166: lx_okl_trx_ar_adjsts_tl_rec
3167: );
3168:
3169: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3174: migrate(lx_okl_trx_ar_adjsts_tl_rec, l_def_adjv_rec);

3170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3171: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3172: RAISE OKL_API.G_EXCEPTION_ERROR;
3173: END IF;
3174: migrate(lx_okl_trx_ar_adjsts_tl_rec, l_def_adjv_rec);
3175: update_row(
3176: p_init_msg_list,
3177: x_return_status,
3178: x_msg_count,

Line 3374: -- delete_row for:OKL_TRX_AR_ADJSTS_TL --

3370: '_PVT'
3371: );
3372: END delete_row;
3373: -----------------------------------------
3374: -- delete_row for:OKL_TRX_AR_ADJSTS_TL --
3375: -----------------------------------------
3376: PROCEDURE delete_row(
3377: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3378: x_return_status OUT NOCOPY VARCHAR2,

Line 3381: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type) IS

3377: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3378: x_return_status OUT NOCOPY VARCHAR2,
3379: x_msg_count OUT NOCOPY NUMBER,
3380: x_msg_data OUT NOCOPY VARCHAR2,
3381: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type) IS
3382:
3383: l_api_version CONSTANT NUMBER := 1;
3384: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3385: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 3386: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type:= p_okl_trx_ar_adjsts_tl_rec;

3382:
3383: l_api_version CONSTANT NUMBER := 1;
3384: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3385: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3386: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type:= p_okl_trx_ar_adjsts_tl_rec;
3387: l_row_notfound BOOLEAN := TRUE;
3388: ---------------------------------------------
3389: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_TL --
3390: ---------------------------------------------

Line 3389: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_TL --

3385: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3386: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type:= p_okl_trx_ar_adjsts_tl_rec;
3387: l_row_notfound BOOLEAN := TRUE;
3388: ---------------------------------------------
3389: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_TL --
3390: ---------------------------------------------
3391: FUNCTION Set_Attributes (
3392: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
3393: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type

Line 3392: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,

3388: ---------------------------------------------
3389: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_TL --
3390: ---------------------------------------------
3391: FUNCTION Set_Attributes (
3392: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
3393: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type
3394: ) RETURN VARCHAR2 IS
3395: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3396: BEGIN

Line 3393: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type

3389: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_TL --
3390: ---------------------------------------------
3391: FUNCTION Set_Attributes (
3392: p_okl_trx_ar_adjsts_tl_rec IN okl_trx_ar_adjsts_tl_rec_type,
3393: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type
3394: ) RETURN VARCHAR2 IS
3395: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3396: BEGIN
3397: x_okl_trx_ar_adjsts_tl_rec := p_okl_trx_ar_adjsts_tl_rec;

Line 3397: x_okl_trx_ar_adjsts_tl_rec := p_okl_trx_ar_adjsts_tl_rec;

3393: x_okl_trx_ar_adjsts_tl_rec OUT NOCOPY okl_trx_ar_adjsts_tl_rec_type
3394: ) RETURN VARCHAR2 IS
3395: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3396: BEGIN
3397: x_okl_trx_ar_adjsts_tl_rec := p_okl_trx_ar_adjsts_tl_rec;
3398: x_okl_trx_ar_adjsts_tl_rec.LANGUAGE := USERENV('LANG');
3399: RETURN(l_return_status);
3400: END Set_Attributes;
3401: BEGIN

Line 3398: x_okl_trx_ar_adjsts_tl_rec.LANGUAGE := USERENV('LANG');

3394: ) RETURN VARCHAR2 IS
3395: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3396: BEGIN
3397: x_okl_trx_ar_adjsts_tl_rec := p_okl_trx_ar_adjsts_tl_rec;
3398: x_okl_trx_ar_adjsts_tl_rec.LANGUAGE := USERENV('LANG');
3399: RETURN(l_return_status);
3400: END Set_Attributes;
3401: BEGIN
3402: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 3413: p_okl_trx_ar_adjsts_tl_rec, -- IN

3409: RAISE OKL_API.G_EXCEPTION_ERROR;
3410: END IF;
3411: --- Setting item attributes
3412: l_return_status := Set_Attributes(
3413: p_okl_trx_ar_adjsts_tl_rec, -- IN
3414: l_okl_trx_ar_adjsts_tl_rec); -- OUT
3415: --- If any errors happen abort API
3416: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3417: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3414: l_okl_trx_ar_adjsts_tl_rec); -- OUT

3410: END IF;
3411: --- Setting item attributes
3412: l_return_status := Set_Attributes(
3413: p_okl_trx_ar_adjsts_tl_rec, -- IN
3414: l_okl_trx_ar_adjsts_tl_rec); -- OUT
3415: --- If any errors happen abort API
3416: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3417: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3418: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3421: DELETE FROM OKL_TRX_AR_ADJSTS_TL

3417: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3418: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3419: RAISE OKL_API.G_EXCEPTION_ERROR;
3420: END IF;
3421: DELETE FROM OKL_TRX_AR_ADJSTS_TL
3422: WHERE ID = l_okl_trx_ar_adjsts_tl_rec.id;
3423:
3424: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3425: EXCEPTION

Line 3422: WHERE ID = l_okl_trx_ar_adjsts_tl_rec.id;

3418: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3419: RAISE OKL_API.G_EXCEPTION_ERROR;
3420: END IF;
3421: DELETE FROM OKL_TRX_AR_ADJSTS_TL
3422: WHERE ID = l_okl_trx_ar_adjsts_tl_rec.id;
3423:
3424: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3425: EXCEPTION
3426: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 3472: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;

3468: l_api_version CONSTANT NUMBER := 1;
3469: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3470: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3471: l_adjv_rec adjv_rec_type := p_adjv_rec;
3472: l_okl_trx_ar_adjsts_tl_rec okl_trx_ar_adjsts_tl_rec_type;
3473: l_adj_rec adj_rec_type;
3474: BEGIN
3475: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
3476: G_PKG_NAME,

Line 3490: migrate(l_adjv_rec, l_okl_trx_ar_adjsts_tl_rec);

3486: END IF;
3487: --------------------------------------
3488: -- Move VIEW record to "Child" records
3489: --------------------------------------
3490: migrate(l_adjv_rec, l_okl_trx_ar_adjsts_tl_rec);
3491: migrate(l_adjv_rec, l_adj_rec);
3492: --------------------------------------------
3493: -- Call the DELETE_ROW for each child record
3494: --------------------------------------------

Line 3500: l_okl_trx_ar_adjsts_tl_rec

3496: p_init_msg_list,
3497: x_return_status,
3498: x_msg_count,
3499: x_msg_data,
3500: l_okl_trx_ar_adjsts_tl_rec
3501: );
3502: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3503: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3504: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN