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_AJL_PVT dependencies on OKL_TXL_ADJSTS_LNS_TL

Line 57: DELETE FROM OKL_TXL_ADJSTS_LNS_TL T

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

Line 64: UPDATE OKL_TXL_ADJSTS_LNS_TL T SET (

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

Line 71: FROM OKL_TXL_ADJSTS_LNS_TL B

67: LAST_UPDATE_LOGIN) = (SELECT
68: B.CREATED_BY,
69: B.LAST_UPDATED_BY,
70: B.LAST_UPDATE_LOGIN
71: FROM OKL_TXL_ADJSTS_LNS_TL B
72: WHERE B.ID = T.ID
73: AND B.LANGUAGE = T.SOURCE_LANG)
74: WHERE (
75: T.ID,

Line 80: FROM OKL_TXL_ADJSTS_LNS_TL SUBB, OKL_TXL_ADJSTS_LNS_TL SUBT

76: T.LANGUAGE)
77: IN (SELECT
78: SUBT.ID,
79: SUBT.LANGUAGE
80: FROM OKL_TXL_ADJSTS_LNS_TL SUBB, OKL_TXL_ADJSTS_LNS_TL SUBT
81: WHERE SUBB.ID = SUBT.ID
82: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
83: AND (SUBB.CREATED_BY <> SUBT.CREATED_BY
84: OR SUBB.LAST_UPDATED_BY <> SUBT.LAST_UPDATED_BY

Line 90: INSERT INTO OKL_TXL_ADJSTS_LNS_TL (

86: OR (SUBB.LAST_UPDATE_LOGIN IS NULL AND SUBT.LAST_UPDATE_LOGIN IS NOT NULL)
87: OR (SUBB.LAST_UPDATE_LOGIN IS NOT NULL AND SUBT.LAST_UPDATE_LOGIN IS NULL)
88: ));
89:
90: INSERT INTO OKL_TXL_ADJSTS_LNS_TL (
91: ID,
92: LANGUAGE,
93: SOURCE_LANG,
94: SFWT_FLAG,

Line 110: FROM OKL_TXL_ADJSTS_LNS_TL B, FND_LANGUAGES L

106: B.CREATION_DATE,
107: B.LAST_UPDATED_BY,
108: B.LAST_UPDATE_DATE,
109: B.LAST_UPDATE_LOGIN
110: FROM OKL_TXL_ADJSTS_LNS_TL B, FND_LANGUAGES L
111: WHERE L.INSTALLED_FLAG IN ('I', 'B')
112: AND B.LANGUAGE = USERENV('LANG')
113: AND NOT EXISTS(
114: SELECT NULL

Line 115: FROM OKL_TXL_ADJSTS_LNS_TL T

111: WHERE L.INSTALLED_FLAG IN ('I', 'B')
112: AND B.LANGUAGE = USERENV('LANG')
113: AND NOT EXISTS(
114: SELECT NULL
115: FROM OKL_TXL_ADJSTS_LNS_TL T
116: WHERE T.ID = B.ID
117: AND T.LANGUAGE = L.LANGUAGE_CODE
118: );
119:

Line 231: -- FUNCTION get_rec for: OKL_TXL_ADJSTS_LNS_TL

227: BEGIN
228: RETURN(get_rec(p_ajl_rec, l_row_notfound));
229: END get_rec;
230: ---------------------------------------------------------------------------
231: -- FUNCTION get_rec for: OKL_TXL_ADJSTS_LNS_TL
232: ---------------------------------------------------------------------------
233: FUNCTION get_rec (
234: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
235: x_no_data_found OUT NOCOPY BOOLEAN

Line 234: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,

230: ---------------------------------------------------------------------------
231: -- FUNCTION get_rec for: OKL_TXL_ADJSTS_LNS_TL
232: ---------------------------------------------------------------------------
233: FUNCTION get_rec (
234: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
235: x_no_data_found OUT NOCOPY BOOLEAN
236: ) RETURN okl_txl_adjsts_lns_tl_rec_type IS
237: CURSOR okl_txl_adjsts_lns_tl_pk_csr (p_id IN NUMBER,
238: p_language IN VARCHAR2) IS

Line 236: ) RETURN okl_txl_adjsts_lns_tl_rec_type IS

232: ---------------------------------------------------------------------------
233: FUNCTION get_rec (
234: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
235: x_no_data_found OUT NOCOPY BOOLEAN
236: ) RETURN okl_txl_adjsts_lns_tl_rec_type IS
237: CURSOR okl_txl_adjsts_lns_tl_pk_csr (p_id IN NUMBER,
238: p_language IN VARCHAR2) IS
239: SELECT
240: ID,

Line 237: CURSOR okl_txl_adjsts_lns_tl_pk_csr (p_id IN NUMBER,

233: FUNCTION get_rec (
234: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
235: x_no_data_found OUT NOCOPY BOOLEAN
236: ) RETURN okl_txl_adjsts_lns_tl_rec_type IS
237: CURSOR okl_txl_adjsts_lns_tl_pk_csr (p_id IN NUMBER,
238: p_language IN VARCHAR2) IS
239: SELECT
240: ID,
241: LANGUAGE,

Line 249: FROM Okl_Txl_Adjsts_Lns_Tl

245: CREATION_DATE,
246: LAST_UPDATED_BY,
247: LAST_UPDATE_DATE,
248: LAST_UPDATE_LOGIN
249: FROM Okl_Txl_Adjsts_Lns_Tl
250: WHERE okl_txl_adjsts_lns_tl.id = p_id
251: AND okl_txl_adjsts_lns_tl.language = p_language;
252: l_okl_txl_adjsts_lns_tl_pk okl_txl_adjsts_lns_tl_pk_csr%ROWTYPE;
253: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;

Line 250: WHERE okl_txl_adjsts_lns_tl.id = p_id

246: LAST_UPDATED_BY,
247: LAST_UPDATE_DATE,
248: LAST_UPDATE_LOGIN
249: FROM Okl_Txl_Adjsts_Lns_Tl
250: WHERE okl_txl_adjsts_lns_tl.id = p_id
251: AND okl_txl_adjsts_lns_tl.language = p_language;
252: l_okl_txl_adjsts_lns_tl_pk okl_txl_adjsts_lns_tl_pk_csr%ROWTYPE;
253: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
254: BEGIN

Line 251: AND okl_txl_adjsts_lns_tl.language = p_language;

247: LAST_UPDATE_DATE,
248: LAST_UPDATE_LOGIN
249: FROM Okl_Txl_Adjsts_Lns_Tl
250: WHERE okl_txl_adjsts_lns_tl.id = p_id
251: AND okl_txl_adjsts_lns_tl.language = p_language;
252: l_okl_txl_adjsts_lns_tl_pk okl_txl_adjsts_lns_tl_pk_csr%ROWTYPE;
253: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
254: BEGIN
255: x_no_data_found := TRUE;

Line 252: l_okl_txl_adjsts_lns_tl_pk okl_txl_adjsts_lns_tl_pk_csr%ROWTYPE;

248: LAST_UPDATE_LOGIN
249: FROM Okl_Txl_Adjsts_Lns_Tl
250: WHERE okl_txl_adjsts_lns_tl.id = p_id
251: AND okl_txl_adjsts_lns_tl.language = p_language;
252: l_okl_txl_adjsts_lns_tl_pk okl_txl_adjsts_lns_tl_pk_csr%ROWTYPE;
253: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
254: BEGIN
255: x_no_data_found := TRUE;
256: -- Get current database values

Line 253: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;

249: FROM Okl_Txl_Adjsts_Lns_Tl
250: WHERE okl_txl_adjsts_lns_tl.id = p_id
251: AND okl_txl_adjsts_lns_tl.language = p_language;
252: l_okl_txl_adjsts_lns_tl_pk okl_txl_adjsts_lns_tl_pk_csr%ROWTYPE;
253: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
254: BEGIN
255: x_no_data_found := TRUE;
256: -- Get current database values
257: OPEN okl_txl_adjsts_lns_tl_pk_csr (p_okl_txl_adjsts_lns_tl_rec.id,

Line 257: OPEN okl_txl_adjsts_lns_tl_pk_csr (p_okl_txl_adjsts_lns_tl_rec.id,

253: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
254: BEGIN
255: x_no_data_found := TRUE;
256: -- Get current database values
257: OPEN okl_txl_adjsts_lns_tl_pk_csr (p_okl_txl_adjsts_lns_tl_rec.id,
258: p_okl_txl_adjsts_lns_tl_rec.language);
259: FETCH okl_txl_adjsts_lns_tl_pk_csr INTO
260: l_okl_txl_adjsts_lns_tl_rec.ID,
261: l_okl_txl_adjsts_lns_tl_rec.LANGUAGE,

Line 258: p_okl_txl_adjsts_lns_tl_rec.language);

254: BEGIN
255: x_no_data_found := TRUE;
256: -- Get current database values
257: OPEN okl_txl_adjsts_lns_tl_pk_csr (p_okl_txl_adjsts_lns_tl_rec.id,
258: p_okl_txl_adjsts_lns_tl_rec.language);
259: FETCH okl_txl_adjsts_lns_tl_pk_csr INTO
260: l_okl_txl_adjsts_lns_tl_rec.ID,
261: l_okl_txl_adjsts_lns_tl_rec.LANGUAGE,
262: l_okl_txl_adjsts_lns_tl_rec.SOURCE_LANG,

Line 259: FETCH okl_txl_adjsts_lns_tl_pk_csr INTO

255: x_no_data_found := TRUE;
256: -- Get current database values
257: OPEN okl_txl_adjsts_lns_tl_pk_csr (p_okl_txl_adjsts_lns_tl_rec.id,
258: p_okl_txl_adjsts_lns_tl_rec.language);
259: FETCH okl_txl_adjsts_lns_tl_pk_csr INTO
260: l_okl_txl_adjsts_lns_tl_rec.ID,
261: l_okl_txl_adjsts_lns_tl_rec.LANGUAGE,
262: l_okl_txl_adjsts_lns_tl_rec.SOURCE_LANG,
263: l_okl_txl_adjsts_lns_tl_rec.SFWT_FLAG,

Line 260: l_okl_txl_adjsts_lns_tl_rec.ID,

256: -- Get current database values
257: OPEN okl_txl_adjsts_lns_tl_pk_csr (p_okl_txl_adjsts_lns_tl_rec.id,
258: p_okl_txl_adjsts_lns_tl_rec.language);
259: FETCH okl_txl_adjsts_lns_tl_pk_csr INTO
260: l_okl_txl_adjsts_lns_tl_rec.ID,
261: l_okl_txl_adjsts_lns_tl_rec.LANGUAGE,
262: l_okl_txl_adjsts_lns_tl_rec.SOURCE_LANG,
263: l_okl_txl_adjsts_lns_tl_rec.SFWT_FLAG,
264: l_okl_txl_adjsts_lns_tl_rec.CREATED_BY,

Line 261: l_okl_txl_adjsts_lns_tl_rec.LANGUAGE,

257: OPEN okl_txl_adjsts_lns_tl_pk_csr (p_okl_txl_adjsts_lns_tl_rec.id,
258: p_okl_txl_adjsts_lns_tl_rec.language);
259: FETCH okl_txl_adjsts_lns_tl_pk_csr INTO
260: l_okl_txl_adjsts_lns_tl_rec.ID,
261: l_okl_txl_adjsts_lns_tl_rec.LANGUAGE,
262: l_okl_txl_adjsts_lns_tl_rec.SOURCE_LANG,
263: l_okl_txl_adjsts_lns_tl_rec.SFWT_FLAG,
264: l_okl_txl_adjsts_lns_tl_rec.CREATED_BY,
265: l_okl_txl_adjsts_lns_tl_rec.CREATION_DATE,

Line 262: l_okl_txl_adjsts_lns_tl_rec.SOURCE_LANG,

258: p_okl_txl_adjsts_lns_tl_rec.language);
259: FETCH okl_txl_adjsts_lns_tl_pk_csr INTO
260: l_okl_txl_adjsts_lns_tl_rec.ID,
261: l_okl_txl_adjsts_lns_tl_rec.LANGUAGE,
262: l_okl_txl_adjsts_lns_tl_rec.SOURCE_LANG,
263: l_okl_txl_adjsts_lns_tl_rec.SFWT_FLAG,
264: l_okl_txl_adjsts_lns_tl_rec.CREATED_BY,
265: l_okl_txl_adjsts_lns_tl_rec.CREATION_DATE,
266: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATED_BY,

Line 263: l_okl_txl_adjsts_lns_tl_rec.SFWT_FLAG,

259: FETCH okl_txl_adjsts_lns_tl_pk_csr INTO
260: l_okl_txl_adjsts_lns_tl_rec.ID,
261: l_okl_txl_adjsts_lns_tl_rec.LANGUAGE,
262: l_okl_txl_adjsts_lns_tl_rec.SOURCE_LANG,
263: l_okl_txl_adjsts_lns_tl_rec.SFWT_FLAG,
264: l_okl_txl_adjsts_lns_tl_rec.CREATED_BY,
265: l_okl_txl_adjsts_lns_tl_rec.CREATION_DATE,
266: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATED_BY,
267: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATE_DATE,

Line 264: l_okl_txl_adjsts_lns_tl_rec.CREATED_BY,

260: l_okl_txl_adjsts_lns_tl_rec.ID,
261: l_okl_txl_adjsts_lns_tl_rec.LANGUAGE,
262: l_okl_txl_adjsts_lns_tl_rec.SOURCE_LANG,
263: l_okl_txl_adjsts_lns_tl_rec.SFWT_FLAG,
264: l_okl_txl_adjsts_lns_tl_rec.CREATED_BY,
265: l_okl_txl_adjsts_lns_tl_rec.CREATION_DATE,
266: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATED_BY,
267: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATE_DATE,
268: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATE_LOGIN;

Line 265: l_okl_txl_adjsts_lns_tl_rec.CREATION_DATE,

261: l_okl_txl_adjsts_lns_tl_rec.LANGUAGE,
262: l_okl_txl_adjsts_lns_tl_rec.SOURCE_LANG,
263: l_okl_txl_adjsts_lns_tl_rec.SFWT_FLAG,
264: l_okl_txl_adjsts_lns_tl_rec.CREATED_BY,
265: l_okl_txl_adjsts_lns_tl_rec.CREATION_DATE,
266: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATED_BY,
267: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATE_DATE,
268: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATE_LOGIN;
269: x_no_data_found := okl_txl_adjsts_lns_tl_pk_csr%NOTFOUND;

Line 266: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATED_BY,

262: l_okl_txl_adjsts_lns_tl_rec.SOURCE_LANG,
263: l_okl_txl_adjsts_lns_tl_rec.SFWT_FLAG,
264: l_okl_txl_adjsts_lns_tl_rec.CREATED_BY,
265: l_okl_txl_adjsts_lns_tl_rec.CREATION_DATE,
266: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATED_BY,
267: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATE_DATE,
268: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATE_LOGIN;
269: x_no_data_found := okl_txl_adjsts_lns_tl_pk_csr%NOTFOUND;
270: CLOSE okl_txl_adjsts_lns_tl_pk_csr;

Line 267: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATE_DATE,

263: l_okl_txl_adjsts_lns_tl_rec.SFWT_FLAG,
264: l_okl_txl_adjsts_lns_tl_rec.CREATED_BY,
265: l_okl_txl_adjsts_lns_tl_rec.CREATION_DATE,
266: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATED_BY,
267: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATE_DATE,
268: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATE_LOGIN;
269: x_no_data_found := okl_txl_adjsts_lns_tl_pk_csr%NOTFOUND;
270: CLOSE okl_txl_adjsts_lns_tl_pk_csr;
271: RETURN(l_okl_txl_adjsts_lns_tl_rec);

Line 268: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATE_LOGIN;

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

Line 269: x_no_data_found := okl_txl_adjsts_lns_tl_pk_csr%NOTFOUND;

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

Line 270: CLOSE okl_txl_adjsts_lns_tl_pk_csr;

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

Line 271: RETURN(l_okl_txl_adjsts_lns_tl_rec);

267: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATE_DATE,
268: l_okl_txl_adjsts_lns_tl_rec.LAST_UPDATE_LOGIN;
269: x_no_data_found := okl_txl_adjsts_lns_tl_pk_csr%NOTFOUND;
270: CLOSE okl_txl_adjsts_lns_tl_pk_csr;
271: RETURN(l_okl_txl_adjsts_lns_tl_rec);
272: END get_rec;
273:
274: FUNCTION get_rec (
275: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type

Line 275: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type

271: RETURN(l_okl_txl_adjsts_lns_tl_rec);
272: END get_rec;
273:
274: FUNCTION get_rec (
275: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type
276: ) RETURN okl_txl_adjsts_lns_tl_rec_type IS
277: l_row_notfound BOOLEAN := TRUE;
278: BEGIN
279: RETURN(get_rec(p_okl_txl_adjsts_lns_tl_rec, l_row_notfound));

Line 276: ) RETURN okl_txl_adjsts_lns_tl_rec_type IS

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

Line 279: RETURN(get_rec(p_okl_txl_adjsts_lns_tl_rec, l_row_notfound));

275: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type
276: ) RETURN okl_txl_adjsts_lns_tl_rec_type IS
277: l_row_notfound BOOLEAN := TRUE;
278: BEGIN
279: RETURN(get_rec(p_okl_txl_adjsts_lns_tl_rec, l_row_notfound));
280: END get_rec;
281: ---------------------------------------------------------------------------
282: -- FUNCTION get_rec for: OKL_TXL_ADJSTS_LNS_V
283: ---------------------------------------------------------------------------

Line 1516: p_to IN OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type

1512: p_to.last_update_login := p_from.last_update_login;
1513: END migrate;
1514: PROCEDURE migrate (
1515: p_from IN ajlv_rec_type,
1516: p_to IN OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type
1517: ) IS
1518: BEGIN
1519: p_to.id := p_from.id;
1520: p_to.sfwt_flag := p_from.sfwt_flag;

Line 1528: p_from IN okl_txl_adjsts_lns_tl_rec_type,

1524: p_to.last_update_date := p_from.last_update_date;
1525: p_to.last_update_login := p_from.last_update_login;
1526: END migrate;
1527: PROCEDURE migrate (
1528: p_from IN okl_txl_adjsts_lns_tl_rec_type,
1529: p_to IN OUT NOCOPY ajlv_rec_type
1530: ) IS
1531: BEGIN
1532: p_to.id := p_from.id;

Line 1560: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;

1556: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1557: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1558: l_ajlv_rec ajlv_rec_type := p_ajlv_rec;
1559: l_ajl_rec ajl_rec_type;
1560: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
1561: BEGIN
1562: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1563: G_PKG_NAME,
1564: p_init_msg_list,

Line 1870: -- insert_row for:OKL_TXL_ADJSTS_LNS_TL --

1866: '_PVT'
1867: );
1868: END insert_row;
1869: ------------------------------------------
1870: -- insert_row for:OKL_TXL_ADJSTS_LNS_TL --
1871: ------------------------------------------
1872: PROCEDURE insert_row(
1873: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1874: x_return_status OUT NOCOPY VARCHAR2,

Line 1877: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,

1873: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1874: x_return_status OUT NOCOPY VARCHAR2,
1875: x_msg_count OUT NOCOPY NUMBER,
1876: x_msg_data OUT NOCOPY VARCHAR2,
1877: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
1878: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type) IS
1879:
1880: l_api_version CONSTANT NUMBER := 1;
1881: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1878: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type) IS

1874: x_return_status OUT NOCOPY VARCHAR2,
1875: x_msg_count OUT NOCOPY NUMBER,
1876: x_msg_data OUT NOCOPY VARCHAR2,
1877: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
1878: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type) IS
1879:
1880: l_api_version CONSTANT NUMBER := 1;
1881: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1882: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1883: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type := p_okl_txl_adjsts_lns_tl_rec;

1879:
1880: l_api_version CONSTANT NUMBER := 1;
1881: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1882: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1883: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type := p_okl_txl_adjsts_lns_tl_rec;
1884: ldefokltxladjstslnstlrec okl_txl_adjsts_lns_tl_rec_type;
1885: CURSOR get_languages IS
1886: SELECT *
1887: FROM FND_LANGUAGES

Line 1884: ldefokltxladjstslnstlrec okl_txl_adjsts_lns_tl_rec_type;

1880: l_api_version CONSTANT NUMBER := 1;
1881: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1882: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1883: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type := p_okl_txl_adjsts_lns_tl_rec;
1884: ldefokltxladjstslnstlrec okl_txl_adjsts_lns_tl_rec_type;
1885: CURSOR get_languages IS
1886: SELECT *
1887: FROM FND_LANGUAGES
1888: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1890: -- Set_Attributes for:OKL_TXL_ADJSTS_LNS_TL --

1886: SELECT *
1887: FROM FND_LANGUAGES
1888: WHERE INSTALLED_FLAG IN ('I', 'B');
1889: ----------------------------------------------
1890: -- Set_Attributes for:OKL_TXL_ADJSTS_LNS_TL --
1891: ----------------------------------------------
1892: FUNCTION Set_Attributes (
1893: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
1894: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type

Line 1893: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,

1889: ----------------------------------------------
1890: -- Set_Attributes for:OKL_TXL_ADJSTS_LNS_TL --
1891: ----------------------------------------------
1892: FUNCTION Set_Attributes (
1893: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
1894: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type
1895: ) RETURN VARCHAR2 IS
1896: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1897: BEGIN

Line 1894: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type

1890: -- Set_Attributes for:OKL_TXL_ADJSTS_LNS_TL --
1891: ----------------------------------------------
1892: FUNCTION Set_Attributes (
1893: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
1894: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type
1895: ) RETURN VARCHAR2 IS
1896: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1897: BEGIN
1898: x_okl_txl_adjsts_lns_tl_rec := p_okl_txl_adjsts_lns_tl_rec;

Line 1898: x_okl_txl_adjsts_lns_tl_rec := p_okl_txl_adjsts_lns_tl_rec;

1894: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type
1895: ) RETURN VARCHAR2 IS
1896: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1897: BEGIN
1898: x_okl_txl_adjsts_lns_tl_rec := p_okl_txl_adjsts_lns_tl_rec;
1899: x_okl_txl_adjsts_lns_tl_rec.LANGUAGE := USERENV('LANG');
1900: x_okl_txl_adjsts_lns_tl_rec.SOURCE_LANG := USERENV('LANG');
1901: RETURN(l_return_status);
1902: END Set_Attributes;

Line 1899: x_okl_txl_adjsts_lns_tl_rec.LANGUAGE := USERENV('LANG');

1895: ) RETURN VARCHAR2 IS
1896: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1897: BEGIN
1898: x_okl_txl_adjsts_lns_tl_rec := p_okl_txl_adjsts_lns_tl_rec;
1899: x_okl_txl_adjsts_lns_tl_rec.LANGUAGE := USERENV('LANG');
1900: x_okl_txl_adjsts_lns_tl_rec.SOURCE_LANG := USERENV('LANG');
1901: RETURN(l_return_status);
1902: END Set_Attributes;
1903: BEGIN

Line 1900: x_okl_txl_adjsts_lns_tl_rec.SOURCE_LANG := USERENV('LANG');

1896: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1897: BEGIN
1898: x_okl_txl_adjsts_lns_tl_rec := p_okl_txl_adjsts_lns_tl_rec;
1899: x_okl_txl_adjsts_lns_tl_rec.LANGUAGE := USERENV('LANG');
1900: x_okl_txl_adjsts_lns_tl_rec.SOURCE_LANG := USERENV('LANG');
1901: RETURN(l_return_status);
1902: END Set_Attributes;
1903: BEGIN
1904: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1915: p_okl_txl_adjsts_lns_tl_rec, -- IN

1911: RAISE OKL_API.G_EXCEPTION_ERROR;
1912: END IF;
1913: --- Setting item attributes
1914: l_return_status := Set_Attributes(
1915: p_okl_txl_adjsts_lns_tl_rec, -- IN
1916: l_okl_txl_adjsts_lns_tl_rec); -- OUT
1917: --- If any errors happen abort API
1918: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1919: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1916: l_okl_txl_adjsts_lns_tl_rec); -- OUT

1912: END IF;
1913: --- Setting item attributes
1914: l_return_status := Set_Attributes(
1915: p_okl_txl_adjsts_lns_tl_rec, -- IN
1916: l_okl_txl_adjsts_lns_tl_rec); -- OUT
1917: --- If any errors happen abort API
1918: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1919: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1920: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 1924: l_okl_txl_adjsts_lns_tl_rec.language := l_lang_rec.language_code;

1920: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1921: RAISE OKL_API.G_EXCEPTION_ERROR;
1922: END IF;
1923: FOR l_lang_rec IN get_languages LOOP
1924: l_okl_txl_adjsts_lns_tl_rec.language := l_lang_rec.language_code;
1925: INSERT INTO OKL_TXL_ADJSTS_LNS_TL(
1926: id,
1927: language,
1928: source_lang,

Line 1925: INSERT INTO OKL_TXL_ADJSTS_LNS_TL(

1921: RAISE OKL_API.G_EXCEPTION_ERROR;
1922: END IF;
1923: FOR l_lang_rec IN get_languages LOOP
1924: l_okl_txl_adjsts_lns_tl_rec.language := l_lang_rec.language_code;
1925: INSERT INTO OKL_TXL_ADJSTS_LNS_TL(
1926: id,
1927: language,
1928: source_lang,
1929: sfwt_flag,

Line 1936: l_okl_txl_adjsts_lns_tl_rec.id,

1932: last_updated_by,
1933: last_update_date,
1934: last_update_login)
1935: VALUES (
1936: l_okl_txl_adjsts_lns_tl_rec.id,
1937: l_okl_txl_adjsts_lns_tl_rec.language,
1938: l_okl_txl_adjsts_lns_tl_rec.source_lang,
1939: l_okl_txl_adjsts_lns_tl_rec.sfwt_flag,
1940: l_okl_txl_adjsts_lns_tl_rec.created_by,

Line 1937: l_okl_txl_adjsts_lns_tl_rec.language,

1933: last_update_date,
1934: last_update_login)
1935: VALUES (
1936: l_okl_txl_adjsts_lns_tl_rec.id,
1937: l_okl_txl_adjsts_lns_tl_rec.language,
1938: l_okl_txl_adjsts_lns_tl_rec.source_lang,
1939: l_okl_txl_adjsts_lns_tl_rec.sfwt_flag,
1940: l_okl_txl_adjsts_lns_tl_rec.created_by,
1941: l_okl_txl_adjsts_lns_tl_rec.creation_date,

Line 1938: l_okl_txl_adjsts_lns_tl_rec.source_lang,

1934: last_update_login)
1935: VALUES (
1936: l_okl_txl_adjsts_lns_tl_rec.id,
1937: l_okl_txl_adjsts_lns_tl_rec.language,
1938: l_okl_txl_adjsts_lns_tl_rec.source_lang,
1939: l_okl_txl_adjsts_lns_tl_rec.sfwt_flag,
1940: l_okl_txl_adjsts_lns_tl_rec.created_by,
1941: l_okl_txl_adjsts_lns_tl_rec.creation_date,
1942: l_okl_txl_adjsts_lns_tl_rec.last_updated_by,

Line 1939: l_okl_txl_adjsts_lns_tl_rec.sfwt_flag,

1935: VALUES (
1936: l_okl_txl_adjsts_lns_tl_rec.id,
1937: l_okl_txl_adjsts_lns_tl_rec.language,
1938: l_okl_txl_adjsts_lns_tl_rec.source_lang,
1939: l_okl_txl_adjsts_lns_tl_rec.sfwt_flag,
1940: l_okl_txl_adjsts_lns_tl_rec.created_by,
1941: l_okl_txl_adjsts_lns_tl_rec.creation_date,
1942: l_okl_txl_adjsts_lns_tl_rec.last_updated_by,
1943: l_okl_txl_adjsts_lns_tl_rec.last_update_date,

Line 1940: l_okl_txl_adjsts_lns_tl_rec.created_by,

1936: l_okl_txl_adjsts_lns_tl_rec.id,
1937: l_okl_txl_adjsts_lns_tl_rec.language,
1938: l_okl_txl_adjsts_lns_tl_rec.source_lang,
1939: l_okl_txl_adjsts_lns_tl_rec.sfwt_flag,
1940: l_okl_txl_adjsts_lns_tl_rec.created_by,
1941: l_okl_txl_adjsts_lns_tl_rec.creation_date,
1942: l_okl_txl_adjsts_lns_tl_rec.last_updated_by,
1943: l_okl_txl_adjsts_lns_tl_rec.last_update_date,
1944: l_okl_txl_adjsts_lns_tl_rec.last_update_login);

Line 1941: l_okl_txl_adjsts_lns_tl_rec.creation_date,

1937: l_okl_txl_adjsts_lns_tl_rec.language,
1938: l_okl_txl_adjsts_lns_tl_rec.source_lang,
1939: l_okl_txl_adjsts_lns_tl_rec.sfwt_flag,
1940: l_okl_txl_adjsts_lns_tl_rec.created_by,
1941: l_okl_txl_adjsts_lns_tl_rec.creation_date,
1942: l_okl_txl_adjsts_lns_tl_rec.last_updated_by,
1943: l_okl_txl_adjsts_lns_tl_rec.last_update_date,
1944: l_okl_txl_adjsts_lns_tl_rec.last_update_login);
1945: END LOOP;

Line 1942: l_okl_txl_adjsts_lns_tl_rec.last_updated_by,

1938: l_okl_txl_adjsts_lns_tl_rec.source_lang,
1939: l_okl_txl_adjsts_lns_tl_rec.sfwt_flag,
1940: l_okl_txl_adjsts_lns_tl_rec.created_by,
1941: l_okl_txl_adjsts_lns_tl_rec.creation_date,
1942: l_okl_txl_adjsts_lns_tl_rec.last_updated_by,
1943: l_okl_txl_adjsts_lns_tl_rec.last_update_date,
1944: l_okl_txl_adjsts_lns_tl_rec.last_update_login);
1945: END LOOP;
1946: -- Set OUT values

Line 1943: l_okl_txl_adjsts_lns_tl_rec.last_update_date,

1939: l_okl_txl_adjsts_lns_tl_rec.sfwt_flag,
1940: l_okl_txl_adjsts_lns_tl_rec.created_by,
1941: l_okl_txl_adjsts_lns_tl_rec.creation_date,
1942: l_okl_txl_adjsts_lns_tl_rec.last_updated_by,
1943: l_okl_txl_adjsts_lns_tl_rec.last_update_date,
1944: l_okl_txl_adjsts_lns_tl_rec.last_update_login);
1945: END LOOP;
1946: -- Set OUT values
1947: x_okl_txl_adjsts_lns_tl_rec := l_okl_txl_adjsts_lns_tl_rec;

Line 1944: l_okl_txl_adjsts_lns_tl_rec.last_update_login);

1940: l_okl_txl_adjsts_lns_tl_rec.created_by,
1941: l_okl_txl_adjsts_lns_tl_rec.creation_date,
1942: l_okl_txl_adjsts_lns_tl_rec.last_updated_by,
1943: l_okl_txl_adjsts_lns_tl_rec.last_update_date,
1944: l_okl_txl_adjsts_lns_tl_rec.last_update_login);
1945: END LOOP;
1946: -- Set OUT values
1947: x_okl_txl_adjsts_lns_tl_rec := l_okl_txl_adjsts_lns_tl_rec;
1948: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1947: x_okl_txl_adjsts_lns_tl_rec := l_okl_txl_adjsts_lns_tl_rec;

1943: l_okl_txl_adjsts_lns_tl_rec.last_update_date,
1944: l_okl_txl_adjsts_lns_tl_rec.last_update_login);
1945: END LOOP;
1946: -- Set OUT values
1947: x_okl_txl_adjsts_lns_tl_rec := l_okl_txl_adjsts_lns_tl_rec;
1948: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1949: EXCEPTION
1950: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1951: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 2000: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;

1996: l_ajlv_rec ajlv_rec_type;
1997: l_def_ajlv_rec ajlv_rec_type;
1998: l_ajl_rec ajl_rec_type;
1999: lx_ajl_rec ajl_rec_type;
2000: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
2001: lx_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
2002: -------------------------------
2003: -- FUNCTION fill_who_columns --
2004: -------------------------------

Line 2001: lx_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;

1997: l_def_ajlv_rec ajlv_rec_type;
1998: l_ajl_rec ajl_rec_type;
1999: lx_ajl_rec ajl_rec_type;
2000: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
2001: lx_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
2002: -------------------------------
2003: -- FUNCTION fill_who_columns --
2004: -------------------------------
2005: FUNCTION fill_who_columns (

Line 2089: migrate(l_def_ajlv_rec, l_okl_txl_adjsts_lns_tl_rec);

2085: --------------------------------------
2086: -- Move VIEW record to "Child" records
2087: --------------------------------------
2088: migrate(l_def_ajlv_rec, l_ajl_rec);
2089: migrate(l_def_ajlv_rec, l_okl_txl_adjsts_lns_tl_rec);
2090: --------------------------------------------
2091: -- Call the INSERT_ROW for each child record
2092: --------------------------------------------
2093: insert_row(

Line 2112: l_okl_txl_adjsts_lns_tl_rec,

2108: p_init_msg_list,
2109: x_return_status,
2110: x_msg_count,
2111: x_msg_data,
2112: l_okl_txl_adjsts_lns_tl_rec,
2113: lx_okl_txl_adjsts_lns_tl_rec
2114: );
2115: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2116: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2113: lx_okl_txl_adjsts_lns_tl_rec

2109: x_return_status,
2110: x_msg_count,
2111: x_msg_data,
2112: l_okl_txl_adjsts_lns_tl_rec,
2113: lx_okl_txl_adjsts_lns_tl_rec
2114: );
2115: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2116: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2117: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 2120: migrate(lx_okl_txl_adjsts_lns_tl_rec, l_def_ajlv_rec);

2116: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2117: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2118: RAISE OKL_API.G_EXCEPTION_ERROR;
2119: END IF;
2120: migrate(lx_okl_txl_adjsts_lns_tl_rec, l_def_ajlv_rec);
2121: -- Set OUT values
2122: x_ajlv_rec := l_def_ajlv_rec;
2123: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2124: EXCEPTION

Line 2350: -- lock_row for:OKL_TXL_ADJSTS_LNS_TL --

2346: '_PVT'
2347: );
2348: END lock_row;
2349: ----------------------------------------
2350: -- lock_row for:OKL_TXL_ADJSTS_LNS_TL --
2351: ----------------------------------------
2352: PROCEDURE lock_row(
2353: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2354: x_return_status OUT NOCOPY VARCHAR2,

Line 2357: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type) IS

2353: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2354: x_return_status OUT NOCOPY VARCHAR2,
2355: x_msg_count OUT NOCOPY NUMBER,
2356: x_msg_data OUT NOCOPY VARCHAR2,
2357: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type) IS
2358:
2359: E_Resource_Busy EXCEPTION;
2360: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2361: CURSOR lock_csr (p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type) IS

Line 2361: CURSOR lock_csr (p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type) IS

2357: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type) IS
2358:
2359: E_Resource_Busy EXCEPTION;
2360: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2361: CURSOR lock_csr (p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type) IS
2362: SELECT *
2363: FROM OKL_TXL_ADJSTS_LNS_TL
2364: WHERE ID = p_okl_txl_adjsts_lns_tl_rec.id
2365: FOR UPDATE NOWAIT;

Line 2363: FROM OKL_TXL_ADJSTS_LNS_TL

2359: E_Resource_Busy EXCEPTION;
2360: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2361: CURSOR lock_csr (p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type) IS
2362: SELECT *
2363: FROM OKL_TXL_ADJSTS_LNS_TL
2364: WHERE ID = p_okl_txl_adjsts_lns_tl_rec.id
2365: FOR UPDATE NOWAIT;
2366:
2367: l_api_version CONSTANT NUMBER := 1;

Line 2364: WHERE ID = p_okl_txl_adjsts_lns_tl_rec.id

2360: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2361: CURSOR lock_csr (p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type) IS
2362: SELECT *
2363: FROM OKL_TXL_ADJSTS_LNS_TL
2364: WHERE ID = p_okl_txl_adjsts_lns_tl_rec.id
2365: FOR UPDATE NOWAIT;
2366:
2367: l_api_version CONSTANT NUMBER := 1;
2368: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2384: OPEN lock_csr(p_okl_txl_adjsts_lns_tl_rec);

2380: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2381: RAISE OKL_API.G_EXCEPTION_ERROR;
2382: END IF;
2383: BEGIN
2384: OPEN lock_csr(p_okl_txl_adjsts_lns_tl_rec);
2385: FETCH lock_csr INTO l_lock_var;
2386: l_row_notfound := lock_csr%NOTFOUND;
2387: CLOSE lock_csr;
2388: EXCEPTION

Line 2449: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;

2445: l_api_version CONSTANT NUMBER := 1;
2446: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2447: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2448: l_ajl_rec ajl_rec_type;
2449: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
2450: BEGIN
2451: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2452: G_PKG_NAME,
2453: p_init_msg_list,

Line 2467: migrate(p_ajlv_rec, l_okl_txl_adjsts_lns_tl_rec);

2463: --------------------------------------
2464: -- Move VIEW record to "Child" records
2465: --------------------------------------
2466: migrate(p_ajlv_rec, l_ajl_rec);
2467: migrate(p_ajlv_rec, l_okl_txl_adjsts_lns_tl_rec);
2468: --------------------------------------------
2469: -- Call the LOCK_ROW for each child record
2470: --------------------------------------------
2471: lock_row(

Line 2488: l_okl_txl_adjsts_lns_tl_rec

2484: p_init_msg_list,
2485: x_return_status,
2486: x_msg_count,
2487: x_msg_data,
2488: l_okl_txl_adjsts_lns_tl_rec
2489: );
2490: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2491: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2492: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 2919: -- update_row for:OKL_TXL_ADJSTS_LNS_TL --

2915: '_PVT'
2916: );
2917: END update_row;
2918: ------------------------------------------
2919: -- update_row for:OKL_TXL_ADJSTS_LNS_TL --
2920: ------------------------------------------
2921: PROCEDURE update_row(
2922: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2923: x_return_status OUT NOCOPY VARCHAR2,

Line 2926: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,

2922: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2923: x_return_status OUT NOCOPY VARCHAR2,
2924: x_msg_count OUT NOCOPY NUMBER,
2925: x_msg_data OUT NOCOPY VARCHAR2,
2926: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
2927: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type) IS
2928:
2929: l_api_version CONSTANT NUMBER := 1;
2930: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2927: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type) IS

2923: x_return_status OUT NOCOPY VARCHAR2,
2924: x_msg_count OUT NOCOPY NUMBER,
2925: x_msg_data OUT NOCOPY VARCHAR2,
2926: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
2927: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type) IS
2928:
2929: l_api_version CONSTANT NUMBER := 1;
2930: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2931: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2932: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type := p_okl_txl_adjsts_lns_tl_rec;

2928:
2929: l_api_version CONSTANT NUMBER := 1;
2930: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2931: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2932: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type := p_okl_txl_adjsts_lns_tl_rec;
2933: ldefokltxladjstslnstlrec okl_txl_adjsts_lns_tl_rec_type;
2934: l_row_notfound BOOLEAN := TRUE;
2935: ----------------------------------
2936: -- FUNCTION populate_new_record --

Line 2933: ldefokltxladjstslnstlrec okl_txl_adjsts_lns_tl_rec_type;

2929: l_api_version CONSTANT NUMBER := 1;
2930: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2931: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2932: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type := p_okl_txl_adjsts_lns_tl_rec;
2933: ldefokltxladjstslnstlrec okl_txl_adjsts_lns_tl_rec_type;
2934: l_row_notfound BOOLEAN := TRUE;
2935: ----------------------------------
2936: -- FUNCTION populate_new_record --
2937: ----------------------------------

Line 2939: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,

2935: ----------------------------------
2936: -- FUNCTION populate_new_record --
2937: ----------------------------------
2938: FUNCTION populate_new_record (
2939: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
2940: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type
2941: ) RETURN VARCHAR2 IS
2942: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
2943: l_row_notfound BOOLEAN := TRUE;

Line 2940: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type

2936: -- FUNCTION populate_new_record --
2937: ----------------------------------
2938: FUNCTION populate_new_record (
2939: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
2940: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type
2941: ) RETURN VARCHAR2 IS
2942: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
2943: l_row_notfound BOOLEAN := TRUE;
2944: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2942: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;

2938: FUNCTION populate_new_record (
2939: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
2940: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type
2941: ) RETURN VARCHAR2 IS
2942: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
2943: l_row_notfound BOOLEAN := TRUE;
2944: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2945: BEGIN
2946: x_okl_txl_adjsts_lns_tl_rec := p_okl_txl_adjsts_lns_tl_rec;

Line 2946: x_okl_txl_adjsts_lns_tl_rec := p_okl_txl_adjsts_lns_tl_rec;

2942: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
2943: l_row_notfound BOOLEAN := TRUE;
2944: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2945: BEGIN
2946: x_okl_txl_adjsts_lns_tl_rec := p_okl_txl_adjsts_lns_tl_rec;
2947: -- Get current database values
2948: l_okl_txl_adjsts_lns_tl_rec := get_rec(p_okl_txl_adjsts_lns_tl_rec, l_row_notfound);
2949: IF (l_row_notfound) THEN
2950: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2948: l_okl_txl_adjsts_lns_tl_rec := get_rec(p_okl_txl_adjsts_lns_tl_rec, l_row_notfound);

2944: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2945: BEGIN
2946: x_okl_txl_adjsts_lns_tl_rec := p_okl_txl_adjsts_lns_tl_rec;
2947: -- Get current database values
2948: l_okl_txl_adjsts_lns_tl_rec := get_rec(p_okl_txl_adjsts_lns_tl_rec, l_row_notfound);
2949: IF (l_row_notfound) THEN
2950: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2951: END IF;
2952: IF (x_okl_txl_adjsts_lns_tl_rec.id = OKL_API.G_MISS_NUM)

Line 2952: IF (x_okl_txl_adjsts_lns_tl_rec.id = OKL_API.G_MISS_NUM)

2948: l_okl_txl_adjsts_lns_tl_rec := get_rec(p_okl_txl_adjsts_lns_tl_rec, l_row_notfound);
2949: IF (l_row_notfound) THEN
2950: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2951: END IF;
2952: IF (x_okl_txl_adjsts_lns_tl_rec.id = OKL_API.G_MISS_NUM)
2953: THEN
2954: x_okl_txl_adjsts_lns_tl_rec.id := l_okl_txl_adjsts_lns_tl_rec.id;
2955: END IF;
2956: IF (x_okl_txl_adjsts_lns_tl_rec.language = OKL_API.G_MISS_CHAR)

Line 2954: x_okl_txl_adjsts_lns_tl_rec.id := l_okl_txl_adjsts_lns_tl_rec.id;

2950: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2951: END IF;
2952: IF (x_okl_txl_adjsts_lns_tl_rec.id = OKL_API.G_MISS_NUM)
2953: THEN
2954: x_okl_txl_adjsts_lns_tl_rec.id := l_okl_txl_adjsts_lns_tl_rec.id;
2955: END IF;
2956: IF (x_okl_txl_adjsts_lns_tl_rec.language = OKL_API.G_MISS_CHAR)
2957: THEN
2958: x_okl_txl_adjsts_lns_tl_rec.language := l_okl_txl_adjsts_lns_tl_rec.language;

Line 2956: IF (x_okl_txl_adjsts_lns_tl_rec.language = OKL_API.G_MISS_CHAR)

2952: IF (x_okl_txl_adjsts_lns_tl_rec.id = OKL_API.G_MISS_NUM)
2953: THEN
2954: x_okl_txl_adjsts_lns_tl_rec.id := l_okl_txl_adjsts_lns_tl_rec.id;
2955: END IF;
2956: IF (x_okl_txl_adjsts_lns_tl_rec.language = OKL_API.G_MISS_CHAR)
2957: THEN
2958: x_okl_txl_adjsts_lns_tl_rec.language := l_okl_txl_adjsts_lns_tl_rec.language;
2959: END IF;
2960: IF (x_okl_txl_adjsts_lns_tl_rec.source_lang = OKL_API.G_MISS_CHAR)

Line 2958: x_okl_txl_adjsts_lns_tl_rec.language := l_okl_txl_adjsts_lns_tl_rec.language;

2954: x_okl_txl_adjsts_lns_tl_rec.id := l_okl_txl_adjsts_lns_tl_rec.id;
2955: END IF;
2956: IF (x_okl_txl_adjsts_lns_tl_rec.language = OKL_API.G_MISS_CHAR)
2957: THEN
2958: x_okl_txl_adjsts_lns_tl_rec.language := l_okl_txl_adjsts_lns_tl_rec.language;
2959: END IF;
2960: IF (x_okl_txl_adjsts_lns_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2961: THEN
2962: x_okl_txl_adjsts_lns_tl_rec.source_lang := l_okl_txl_adjsts_lns_tl_rec.source_lang;

Line 2960: IF (x_okl_txl_adjsts_lns_tl_rec.source_lang = OKL_API.G_MISS_CHAR)

2956: IF (x_okl_txl_adjsts_lns_tl_rec.language = OKL_API.G_MISS_CHAR)
2957: THEN
2958: x_okl_txl_adjsts_lns_tl_rec.language := l_okl_txl_adjsts_lns_tl_rec.language;
2959: END IF;
2960: IF (x_okl_txl_adjsts_lns_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2961: THEN
2962: x_okl_txl_adjsts_lns_tl_rec.source_lang := l_okl_txl_adjsts_lns_tl_rec.source_lang;
2963: END IF;
2964: IF (x_okl_txl_adjsts_lns_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)

Line 2962: x_okl_txl_adjsts_lns_tl_rec.source_lang := l_okl_txl_adjsts_lns_tl_rec.source_lang;

2958: x_okl_txl_adjsts_lns_tl_rec.language := l_okl_txl_adjsts_lns_tl_rec.language;
2959: END IF;
2960: IF (x_okl_txl_adjsts_lns_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2961: THEN
2962: x_okl_txl_adjsts_lns_tl_rec.source_lang := l_okl_txl_adjsts_lns_tl_rec.source_lang;
2963: END IF;
2964: IF (x_okl_txl_adjsts_lns_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2965: THEN
2966: x_okl_txl_adjsts_lns_tl_rec.sfwt_flag := l_okl_txl_adjsts_lns_tl_rec.sfwt_flag;

Line 2964: IF (x_okl_txl_adjsts_lns_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)

2960: IF (x_okl_txl_adjsts_lns_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2961: THEN
2962: x_okl_txl_adjsts_lns_tl_rec.source_lang := l_okl_txl_adjsts_lns_tl_rec.source_lang;
2963: END IF;
2964: IF (x_okl_txl_adjsts_lns_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2965: THEN
2966: x_okl_txl_adjsts_lns_tl_rec.sfwt_flag := l_okl_txl_adjsts_lns_tl_rec.sfwt_flag;
2967: END IF;
2968: IF (x_okl_txl_adjsts_lns_tl_rec.created_by = OKL_API.G_MISS_NUM)

Line 2966: x_okl_txl_adjsts_lns_tl_rec.sfwt_flag := l_okl_txl_adjsts_lns_tl_rec.sfwt_flag;

2962: x_okl_txl_adjsts_lns_tl_rec.source_lang := l_okl_txl_adjsts_lns_tl_rec.source_lang;
2963: END IF;
2964: IF (x_okl_txl_adjsts_lns_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2965: THEN
2966: x_okl_txl_adjsts_lns_tl_rec.sfwt_flag := l_okl_txl_adjsts_lns_tl_rec.sfwt_flag;
2967: END IF;
2968: IF (x_okl_txl_adjsts_lns_tl_rec.created_by = OKL_API.G_MISS_NUM)
2969: THEN
2970: x_okl_txl_adjsts_lns_tl_rec.created_by := l_okl_txl_adjsts_lns_tl_rec.created_by;

Line 2968: IF (x_okl_txl_adjsts_lns_tl_rec.created_by = OKL_API.G_MISS_NUM)

2964: IF (x_okl_txl_adjsts_lns_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2965: THEN
2966: x_okl_txl_adjsts_lns_tl_rec.sfwt_flag := l_okl_txl_adjsts_lns_tl_rec.sfwt_flag;
2967: END IF;
2968: IF (x_okl_txl_adjsts_lns_tl_rec.created_by = OKL_API.G_MISS_NUM)
2969: THEN
2970: x_okl_txl_adjsts_lns_tl_rec.created_by := l_okl_txl_adjsts_lns_tl_rec.created_by;
2971: END IF;
2972: IF (x_okl_txl_adjsts_lns_tl_rec.creation_date = OKL_API.G_MISS_DATE)

Line 2970: x_okl_txl_adjsts_lns_tl_rec.created_by := l_okl_txl_adjsts_lns_tl_rec.created_by;

2966: x_okl_txl_adjsts_lns_tl_rec.sfwt_flag := l_okl_txl_adjsts_lns_tl_rec.sfwt_flag;
2967: END IF;
2968: IF (x_okl_txl_adjsts_lns_tl_rec.created_by = OKL_API.G_MISS_NUM)
2969: THEN
2970: x_okl_txl_adjsts_lns_tl_rec.created_by := l_okl_txl_adjsts_lns_tl_rec.created_by;
2971: END IF;
2972: IF (x_okl_txl_adjsts_lns_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2973: THEN
2974: x_okl_txl_adjsts_lns_tl_rec.creation_date := l_okl_txl_adjsts_lns_tl_rec.creation_date;

Line 2972: IF (x_okl_txl_adjsts_lns_tl_rec.creation_date = OKL_API.G_MISS_DATE)

2968: IF (x_okl_txl_adjsts_lns_tl_rec.created_by = OKL_API.G_MISS_NUM)
2969: THEN
2970: x_okl_txl_adjsts_lns_tl_rec.created_by := l_okl_txl_adjsts_lns_tl_rec.created_by;
2971: END IF;
2972: IF (x_okl_txl_adjsts_lns_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2973: THEN
2974: x_okl_txl_adjsts_lns_tl_rec.creation_date := l_okl_txl_adjsts_lns_tl_rec.creation_date;
2975: END IF;
2976: IF (x_okl_txl_adjsts_lns_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 2974: x_okl_txl_adjsts_lns_tl_rec.creation_date := l_okl_txl_adjsts_lns_tl_rec.creation_date;

2970: x_okl_txl_adjsts_lns_tl_rec.created_by := l_okl_txl_adjsts_lns_tl_rec.created_by;
2971: END IF;
2972: IF (x_okl_txl_adjsts_lns_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2973: THEN
2974: x_okl_txl_adjsts_lns_tl_rec.creation_date := l_okl_txl_adjsts_lns_tl_rec.creation_date;
2975: END IF;
2976: IF (x_okl_txl_adjsts_lns_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2977: THEN
2978: x_okl_txl_adjsts_lns_tl_rec.last_updated_by := l_okl_txl_adjsts_lns_tl_rec.last_updated_by;

Line 2976: IF (x_okl_txl_adjsts_lns_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)

2972: IF (x_okl_txl_adjsts_lns_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2973: THEN
2974: x_okl_txl_adjsts_lns_tl_rec.creation_date := l_okl_txl_adjsts_lns_tl_rec.creation_date;
2975: END IF;
2976: IF (x_okl_txl_adjsts_lns_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2977: THEN
2978: x_okl_txl_adjsts_lns_tl_rec.last_updated_by := l_okl_txl_adjsts_lns_tl_rec.last_updated_by;
2979: END IF;
2980: IF (x_okl_txl_adjsts_lns_tl_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 2978: x_okl_txl_adjsts_lns_tl_rec.last_updated_by := l_okl_txl_adjsts_lns_tl_rec.last_updated_by;

2974: x_okl_txl_adjsts_lns_tl_rec.creation_date := l_okl_txl_adjsts_lns_tl_rec.creation_date;
2975: END IF;
2976: IF (x_okl_txl_adjsts_lns_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2977: THEN
2978: x_okl_txl_adjsts_lns_tl_rec.last_updated_by := l_okl_txl_adjsts_lns_tl_rec.last_updated_by;
2979: END IF;
2980: IF (x_okl_txl_adjsts_lns_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2981: THEN
2982: x_okl_txl_adjsts_lns_tl_rec.last_update_date := l_okl_txl_adjsts_lns_tl_rec.last_update_date;

Line 2980: IF (x_okl_txl_adjsts_lns_tl_rec.last_update_date = OKL_API.G_MISS_DATE)

2976: IF (x_okl_txl_adjsts_lns_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2977: THEN
2978: x_okl_txl_adjsts_lns_tl_rec.last_updated_by := l_okl_txl_adjsts_lns_tl_rec.last_updated_by;
2979: END IF;
2980: IF (x_okl_txl_adjsts_lns_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2981: THEN
2982: x_okl_txl_adjsts_lns_tl_rec.last_update_date := l_okl_txl_adjsts_lns_tl_rec.last_update_date;
2983: END IF;
2984: IF (x_okl_txl_adjsts_lns_tl_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 2982: x_okl_txl_adjsts_lns_tl_rec.last_update_date := l_okl_txl_adjsts_lns_tl_rec.last_update_date;

2978: x_okl_txl_adjsts_lns_tl_rec.last_updated_by := l_okl_txl_adjsts_lns_tl_rec.last_updated_by;
2979: END IF;
2980: IF (x_okl_txl_adjsts_lns_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2981: THEN
2982: x_okl_txl_adjsts_lns_tl_rec.last_update_date := l_okl_txl_adjsts_lns_tl_rec.last_update_date;
2983: END IF;
2984: IF (x_okl_txl_adjsts_lns_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
2985: THEN
2986: x_okl_txl_adjsts_lns_tl_rec.last_update_login := l_okl_txl_adjsts_lns_tl_rec.last_update_login;

Line 2984: IF (x_okl_txl_adjsts_lns_tl_rec.last_update_login = OKL_API.G_MISS_NUM)

2980: IF (x_okl_txl_adjsts_lns_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2981: THEN
2982: x_okl_txl_adjsts_lns_tl_rec.last_update_date := l_okl_txl_adjsts_lns_tl_rec.last_update_date;
2983: END IF;
2984: IF (x_okl_txl_adjsts_lns_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
2985: THEN
2986: x_okl_txl_adjsts_lns_tl_rec.last_update_login := l_okl_txl_adjsts_lns_tl_rec.last_update_login;
2987: END IF;
2988: RETURN(l_return_status);

Line 2986: x_okl_txl_adjsts_lns_tl_rec.last_update_login := l_okl_txl_adjsts_lns_tl_rec.last_update_login;

2982: x_okl_txl_adjsts_lns_tl_rec.last_update_date := l_okl_txl_adjsts_lns_tl_rec.last_update_date;
2983: END IF;
2984: IF (x_okl_txl_adjsts_lns_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
2985: THEN
2986: x_okl_txl_adjsts_lns_tl_rec.last_update_login := l_okl_txl_adjsts_lns_tl_rec.last_update_login;
2987: END IF;
2988: RETURN(l_return_status);
2989: END populate_new_record;
2990: ----------------------------------------------

Line 2991: -- Set_Attributes for:OKL_TXL_ADJSTS_LNS_TL --

2987: END IF;
2988: RETURN(l_return_status);
2989: END populate_new_record;
2990: ----------------------------------------------
2991: -- Set_Attributes for:OKL_TXL_ADJSTS_LNS_TL --
2992: ----------------------------------------------
2993: FUNCTION Set_Attributes (
2994: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
2995: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type

Line 2994: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,

2990: ----------------------------------------------
2991: -- Set_Attributes for:OKL_TXL_ADJSTS_LNS_TL --
2992: ----------------------------------------------
2993: FUNCTION Set_Attributes (
2994: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
2995: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type
2996: ) RETURN VARCHAR2 IS
2997: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2998: BEGIN

Line 2995: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type

2991: -- Set_Attributes for:OKL_TXL_ADJSTS_LNS_TL --
2992: ----------------------------------------------
2993: FUNCTION Set_Attributes (
2994: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
2995: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type
2996: ) RETURN VARCHAR2 IS
2997: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2998: BEGIN
2999: x_okl_txl_adjsts_lns_tl_rec := p_okl_txl_adjsts_lns_tl_rec;

Line 2999: x_okl_txl_adjsts_lns_tl_rec := p_okl_txl_adjsts_lns_tl_rec;

2995: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type
2996: ) RETURN VARCHAR2 IS
2997: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2998: BEGIN
2999: x_okl_txl_adjsts_lns_tl_rec := p_okl_txl_adjsts_lns_tl_rec;
3000: x_okl_txl_adjsts_lns_tl_rec.LANGUAGE := USERENV('LANG');
3001: x_okl_txl_adjsts_lns_tl_rec.SOURCE_LANG := USERENV('LANG');
3002: RETURN(l_return_status);
3003: END Set_Attributes;

Line 3000: x_okl_txl_adjsts_lns_tl_rec.LANGUAGE := USERENV('LANG');

2996: ) RETURN VARCHAR2 IS
2997: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2998: BEGIN
2999: x_okl_txl_adjsts_lns_tl_rec := p_okl_txl_adjsts_lns_tl_rec;
3000: x_okl_txl_adjsts_lns_tl_rec.LANGUAGE := USERENV('LANG');
3001: x_okl_txl_adjsts_lns_tl_rec.SOURCE_LANG := USERENV('LANG');
3002: RETURN(l_return_status);
3003: END Set_Attributes;
3004: BEGIN

Line 3001: x_okl_txl_adjsts_lns_tl_rec.SOURCE_LANG := USERENV('LANG');

2997: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2998: BEGIN
2999: x_okl_txl_adjsts_lns_tl_rec := p_okl_txl_adjsts_lns_tl_rec;
3000: x_okl_txl_adjsts_lns_tl_rec.LANGUAGE := USERENV('LANG');
3001: x_okl_txl_adjsts_lns_tl_rec.SOURCE_LANG := USERENV('LANG');
3002: RETURN(l_return_status);
3003: END Set_Attributes;
3004: BEGIN
3005: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 3016: p_okl_txl_adjsts_lns_tl_rec, -- IN

3012: RAISE OKL_API.G_EXCEPTION_ERROR;
3013: END IF;
3014: --- Setting item attributes
3015: l_return_status := Set_Attributes(
3016: p_okl_txl_adjsts_lns_tl_rec, -- IN
3017: l_okl_txl_adjsts_lns_tl_rec); -- OUT
3018: --- If any errors happen abort API
3019: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3020: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3017: l_okl_txl_adjsts_lns_tl_rec); -- OUT

3013: END IF;
3014: --- Setting item attributes
3015: l_return_status := Set_Attributes(
3016: p_okl_txl_adjsts_lns_tl_rec, -- IN
3017: l_okl_txl_adjsts_lns_tl_rec); -- OUT
3018: --- If any errors happen abort API
3019: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3020: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3021: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3024: l_return_status := populate_new_record(l_okl_txl_adjsts_lns_tl_rec, ldefokltxladjstslnstlrec);

3020: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3021: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3022: RAISE OKL_API.G_EXCEPTION_ERROR;
3023: END IF;
3024: l_return_status := populate_new_record(l_okl_txl_adjsts_lns_tl_rec, ldefokltxladjstslnstlrec);
3025: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3027: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3028: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3030: UPDATE OKL_TXL_ADJSTS_LNS_TL

3026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3027: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3028: RAISE OKL_API.G_EXCEPTION_ERROR;
3029: END IF;
3030: UPDATE OKL_TXL_ADJSTS_LNS_TL
3031: SET CREATED_BY = ldefokltxladjstslnstlrec.created_by,
3032: CREATION_DATE = ldefokltxladjstslnstlrec.creation_date,
3033: LAST_UPDATED_BY = ldefokltxladjstslnstlrec.last_updated_by,
3034: LAST_UPDATE_DATE = ldefokltxladjstslnstlrec.last_update_date,

Line 3040: UPDATE OKL_TXL_ADJSTS_LNS_TL

3036: WHERE ID = ldefokltxladjstslnstlrec.id
3037: --AND SOURCE_LANG = USERENV('LANG');
3038: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
3039:
3040: UPDATE OKL_TXL_ADJSTS_LNS_TL
3041: SET SFWT_FLAG = 'Y'
3042: WHERE ID = ldefokltxladjstslnstlrec.id
3043: AND SOURCE_LANG <> USERENV('LANG');
3044:

Line 3045: x_okl_txl_adjsts_lns_tl_rec := ldefokltxladjstslnstlrec;

3041: SET SFWT_FLAG = 'Y'
3042: WHERE ID = ldefokltxladjstslnstlrec.id
3043: AND SOURCE_LANG <> USERENV('LANG');
3044:
3045: x_okl_txl_adjsts_lns_tl_rec := ldefokltxladjstslnstlrec;
3046: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3047: EXCEPTION
3048: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3049: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 3096: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;

3092: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
3093: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3094: l_ajlv_rec ajlv_rec_type := p_ajlv_rec;
3095: l_def_ajlv_rec ajlv_rec_type;
3096: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
3097: lx_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
3098: l_ajl_rec ajl_rec_type;
3099: lx_ajl_rec ajl_rec_type;
3100: -------------------------------

Line 3097: lx_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;

3093: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3094: l_ajlv_rec ajlv_rec_type := p_ajlv_rec;
3095: l_def_ajlv_rec ajlv_rec_type;
3096: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
3097: lx_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
3098: l_ajl_rec ajl_rec_type;
3099: lx_ajl_rec ajl_rec_type;
3100: -------------------------------
3101: -- FUNCTION fill_who_columns --

Line 3372: migrate(l_def_ajlv_rec, l_okl_txl_adjsts_lns_tl_rec);

3368:
3369: --------------------------------------
3370: -- Move VIEW record to "Child" records
3371: --------------------------------------
3372: migrate(l_def_ajlv_rec, l_okl_txl_adjsts_lns_tl_rec);
3373: migrate(l_def_ajlv_rec, l_ajl_rec);
3374: --------------------------------------------
3375: -- Call the UPDATE_ROW for each child record
3376: --------------------------------------------

Line 3382: l_okl_txl_adjsts_lns_tl_rec,

3378: p_init_msg_list,
3379: x_return_status,
3380: x_msg_count,
3381: x_msg_data,
3382: l_okl_txl_adjsts_lns_tl_rec,
3383: lx_okl_txl_adjsts_lns_tl_rec
3384: );
3385: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3386: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3383: lx_okl_txl_adjsts_lns_tl_rec

3379: x_return_status,
3380: x_msg_count,
3381: x_msg_data,
3382: l_okl_txl_adjsts_lns_tl_rec,
3383: lx_okl_txl_adjsts_lns_tl_rec
3384: );
3385: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3386: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3387: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3390: migrate(lx_okl_txl_adjsts_lns_tl_rec, l_def_ajlv_rec);

3386: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3387: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3388: RAISE OKL_API.G_EXCEPTION_ERROR;
3389: END IF;
3390: migrate(lx_okl_txl_adjsts_lns_tl_rec, l_def_ajlv_rec);
3391: update_row(
3392: p_init_msg_list,
3393: x_return_status,
3394: x_msg_count,

Line 3588: -- delete_row for:OKL_TXL_ADJSTS_LNS_TL --

3584: '_PVT'
3585: );
3586: END delete_row;
3587: ------------------------------------------
3588: -- delete_row for:OKL_TXL_ADJSTS_LNS_TL --
3589: ------------------------------------------
3590: PROCEDURE delete_row(
3591: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3592: x_return_status OUT NOCOPY VARCHAR2,

Line 3595: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type) IS

3591: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3592: x_return_status OUT NOCOPY VARCHAR2,
3593: x_msg_count OUT NOCOPY NUMBER,
3594: x_msg_data OUT NOCOPY VARCHAR2,
3595: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type) IS
3596:
3597: l_api_version CONSTANT NUMBER := 1;
3598: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3599: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 3600: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type:= p_okl_txl_adjsts_lns_tl_rec;

3596:
3597: l_api_version CONSTANT NUMBER := 1;
3598: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3599: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3600: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type:= p_okl_txl_adjsts_lns_tl_rec;
3601: l_row_notfound BOOLEAN := TRUE;
3602: ----------------------------------------------
3603: -- Set_Attributes for:OKL_TXL_ADJSTS_LNS_TL --
3604: ----------------------------------------------

Line 3603: -- Set_Attributes for:OKL_TXL_ADJSTS_LNS_TL --

3599: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3600: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type:= p_okl_txl_adjsts_lns_tl_rec;
3601: l_row_notfound BOOLEAN := TRUE;
3602: ----------------------------------------------
3603: -- Set_Attributes for:OKL_TXL_ADJSTS_LNS_TL --
3604: ----------------------------------------------
3605: FUNCTION Set_Attributes (
3606: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
3607: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type

Line 3606: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,

3602: ----------------------------------------------
3603: -- Set_Attributes for:OKL_TXL_ADJSTS_LNS_TL --
3604: ----------------------------------------------
3605: FUNCTION Set_Attributes (
3606: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
3607: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type
3608: ) RETURN VARCHAR2 IS
3609: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3610: BEGIN

Line 3607: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type

3603: -- Set_Attributes for:OKL_TXL_ADJSTS_LNS_TL --
3604: ----------------------------------------------
3605: FUNCTION Set_Attributes (
3606: p_okl_txl_adjsts_lns_tl_rec IN okl_txl_adjsts_lns_tl_rec_type,
3607: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type
3608: ) RETURN VARCHAR2 IS
3609: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3610: BEGIN
3611: x_okl_txl_adjsts_lns_tl_rec := p_okl_txl_adjsts_lns_tl_rec;

Line 3611: x_okl_txl_adjsts_lns_tl_rec := p_okl_txl_adjsts_lns_tl_rec;

3607: x_okl_txl_adjsts_lns_tl_rec OUT NOCOPY okl_txl_adjsts_lns_tl_rec_type
3608: ) RETURN VARCHAR2 IS
3609: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3610: BEGIN
3611: x_okl_txl_adjsts_lns_tl_rec := p_okl_txl_adjsts_lns_tl_rec;
3612: x_okl_txl_adjsts_lns_tl_rec.LANGUAGE := USERENV('LANG');
3613: RETURN(l_return_status);
3614: END Set_Attributes;
3615: BEGIN

Line 3612: x_okl_txl_adjsts_lns_tl_rec.LANGUAGE := USERENV('LANG');

3608: ) RETURN VARCHAR2 IS
3609: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3610: BEGIN
3611: x_okl_txl_adjsts_lns_tl_rec := p_okl_txl_adjsts_lns_tl_rec;
3612: x_okl_txl_adjsts_lns_tl_rec.LANGUAGE := USERENV('LANG');
3613: RETURN(l_return_status);
3614: END Set_Attributes;
3615: BEGIN
3616: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 3627: p_okl_txl_adjsts_lns_tl_rec, -- IN

3623: RAISE OKL_API.G_EXCEPTION_ERROR;
3624: END IF;
3625: --- Setting item attributes
3626: l_return_status := Set_Attributes(
3627: p_okl_txl_adjsts_lns_tl_rec, -- IN
3628: l_okl_txl_adjsts_lns_tl_rec); -- OUT
3629: --- If any errors happen abort API
3630: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3631: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3628: l_okl_txl_adjsts_lns_tl_rec); -- OUT

3624: END IF;
3625: --- Setting item attributes
3626: l_return_status := Set_Attributes(
3627: p_okl_txl_adjsts_lns_tl_rec, -- IN
3628: l_okl_txl_adjsts_lns_tl_rec); -- OUT
3629: --- If any errors happen abort API
3630: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3631: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3632: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3635: DELETE FROM OKL_TXL_ADJSTS_LNS_TL

3631: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3632: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3633: RAISE OKL_API.G_EXCEPTION_ERROR;
3634: END IF;
3635: DELETE FROM OKL_TXL_ADJSTS_LNS_TL
3636: WHERE ID = l_okl_txl_adjsts_lns_tl_rec.id;
3637:
3638: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3639: EXCEPTION

Line 3636: WHERE ID = l_okl_txl_adjsts_lns_tl_rec.id;

3632: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3633: RAISE OKL_API.G_EXCEPTION_ERROR;
3634: END IF;
3635: DELETE FROM OKL_TXL_ADJSTS_LNS_TL
3636: WHERE ID = l_okl_txl_adjsts_lns_tl_rec.id;
3637:
3638: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3639: EXCEPTION
3640: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 3686: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;

3682: l_api_version CONSTANT NUMBER := 1;
3683: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3684: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3685: l_ajlv_rec ajlv_rec_type := p_ajlv_rec;
3686: l_okl_txl_adjsts_lns_tl_rec okl_txl_adjsts_lns_tl_rec_type;
3687: l_ajl_rec ajl_rec_type;
3688: BEGIN
3689: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
3690: G_PKG_NAME,

Line 3704: migrate(l_ajlv_rec, l_okl_txl_adjsts_lns_tl_rec);

3700: END IF;
3701: --------------------------------------
3702: -- Move VIEW record to "Child" records
3703: --------------------------------------
3704: migrate(l_ajlv_rec, l_okl_txl_adjsts_lns_tl_rec);
3705: migrate(l_ajlv_rec, l_ajl_rec);
3706: --------------------------------------------
3707: -- Call the DELETE_ROW for each child record
3708: --------------------------------------------

Line 3714: l_okl_txl_adjsts_lns_tl_rec

3710: p_init_msg_list,
3711: x_return_status,
3712: x_msg_count,
3713: x_msg_data,
3714: l_okl_txl_adjsts_lns_tl_rec
3715: );
3716: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3717: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3718: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN