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_RCT_PVT dependencies on OKL_TRX_CSH_RECEIPT_TL

Line 40: DELETE FROM OKL_TRX_CSH_RECEIPT_TL T

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

Line 47: UPDATE OKL_TRX_CSH_RECEIPT_TL T SET (

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

Line 50: FROM OKL_TRX_CSH_RECEIPT_TL B

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

Line 59: FROM OKL_TRX_CSH_RECEIPT_TL SUBB, OKL_TRX_CSH_RECEIPT_TL SUBT

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

Line 67: INSERT INTO OKL_TRX_CSH_RECEIPT_TL (

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

Line 89: FROM OKL_TRX_CSH_RECEIPT_TL B, FND_LANGUAGES L

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

Line 94: FROM OKL_TRX_CSH_RECEIPT_TL T

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

Line 237: -- FUNCTION get_rec for: OKL_TRX_CSH_RECEIPT_TL

233: BEGIN
234: RETURN(get_rec(p_rct_rec, l_row_notfound));
235: END get_rec;
236: ---------------------------------------------------------------------------
237: -- FUNCTION get_rec for: OKL_TRX_CSH_RECEIPT_TL
238: ---------------------------------------------------------------------------
239: FUNCTION get_rec (
240: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
241: x_no_data_found OUT NOCOPY BOOLEAN

Line 240: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,

236: ---------------------------------------------------------------------------
237: -- FUNCTION get_rec for: OKL_TRX_CSH_RECEIPT_TL
238: ---------------------------------------------------------------------------
239: FUNCTION get_rec (
240: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
241: x_no_data_found OUT NOCOPY BOOLEAN
242: ) RETURN OklTrxCshReceiptTlRecType IS
243: CURSOR okl_trx_csh_receipt_tl_pk_csr (p_id IN NUMBER,
244: p_language IN VARCHAR2) IS

Line 243: CURSOR okl_trx_csh_receipt_tl_pk_csr (p_id IN NUMBER,

239: FUNCTION get_rec (
240: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
241: x_no_data_found OUT NOCOPY BOOLEAN
242: ) RETURN OklTrxCshReceiptTlRecType IS
243: CURSOR okl_trx_csh_receipt_tl_pk_csr (p_id IN NUMBER,
244: p_language IN VARCHAR2) IS
245: SELECT
246: ID,
247: LANGUAGE,

Line 256: FROM Okl_Trx_Csh_Receipt_Tl

252: CREATION_DATE,
253: LAST_UPDATED_BY,
254: LAST_UPDATE_DATE,
255: LAST_UPDATE_LOGIN
256: FROM Okl_Trx_Csh_Receipt_Tl
257: WHERE okl_trx_csh_receipt_tl.id = p_id
258: AND okl_trx_csh_receipt_tl.LANGUAGE = p_language;
259: l_okl_trx_csh_receipt_tl_pk okl_trx_csh_receipt_tl_pk_csr%ROWTYPE;
260: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;

Line 257: WHERE okl_trx_csh_receipt_tl.id = p_id

253: LAST_UPDATED_BY,
254: LAST_UPDATE_DATE,
255: LAST_UPDATE_LOGIN
256: FROM Okl_Trx_Csh_Receipt_Tl
257: WHERE okl_trx_csh_receipt_tl.id = p_id
258: AND okl_trx_csh_receipt_tl.LANGUAGE = p_language;
259: l_okl_trx_csh_receipt_tl_pk okl_trx_csh_receipt_tl_pk_csr%ROWTYPE;
260: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
261: BEGIN

Line 258: AND okl_trx_csh_receipt_tl.LANGUAGE = p_language;

254: LAST_UPDATE_DATE,
255: LAST_UPDATE_LOGIN
256: FROM Okl_Trx_Csh_Receipt_Tl
257: WHERE okl_trx_csh_receipt_tl.id = p_id
258: AND okl_trx_csh_receipt_tl.LANGUAGE = p_language;
259: l_okl_trx_csh_receipt_tl_pk okl_trx_csh_receipt_tl_pk_csr%ROWTYPE;
260: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
261: BEGIN
262: x_no_data_found := TRUE;

Line 259: l_okl_trx_csh_receipt_tl_pk okl_trx_csh_receipt_tl_pk_csr%ROWTYPE;

255: LAST_UPDATE_LOGIN
256: FROM Okl_Trx_Csh_Receipt_Tl
257: WHERE okl_trx_csh_receipt_tl.id = p_id
258: AND okl_trx_csh_receipt_tl.LANGUAGE = p_language;
259: l_okl_trx_csh_receipt_tl_pk okl_trx_csh_receipt_tl_pk_csr%ROWTYPE;
260: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
261: BEGIN
262: x_no_data_found := TRUE;
263: -- Get current database values

Line 260: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;

256: FROM Okl_Trx_Csh_Receipt_Tl
257: WHERE okl_trx_csh_receipt_tl.id = p_id
258: AND okl_trx_csh_receipt_tl.LANGUAGE = p_language;
259: l_okl_trx_csh_receipt_tl_pk okl_trx_csh_receipt_tl_pk_csr%ROWTYPE;
260: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
261: BEGIN
262: x_no_data_found := TRUE;
263: -- Get current database values
264: OPEN okl_trx_csh_receipt_tl_pk_csr (p_okl_trx_csh_receipt_tl_rec.id,

Line 264: OPEN okl_trx_csh_receipt_tl_pk_csr (p_okl_trx_csh_receipt_tl_rec.id,

260: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
261: BEGIN
262: x_no_data_found := TRUE;
263: -- Get current database values
264: OPEN okl_trx_csh_receipt_tl_pk_csr (p_okl_trx_csh_receipt_tl_rec.id,
265: p_okl_trx_csh_receipt_tl_rec.LANGUAGE);
266: FETCH okl_trx_csh_receipt_tl_pk_csr INTO
267: l_okl_trx_csh_receipt_tl_rec.ID,
268: l_okl_trx_csh_receipt_tl_rec.LANGUAGE,

Line 265: p_okl_trx_csh_receipt_tl_rec.LANGUAGE);

261: BEGIN
262: x_no_data_found := TRUE;
263: -- Get current database values
264: OPEN okl_trx_csh_receipt_tl_pk_csr (p_okl_trx_csh_receipt_tl_rec.id,
265: p_okl_trx_csh_receipt_tl_rec.LANGUAGE);
266: FETCH okl_trx_csh_receipt_tl_pk_csr INTO
267: l_okl_trx_csh_receipt_tl_rec.ID,
268: l_okl_trx_csh_receipt_tl_rec.LANGUAGE,
269: l_okl_trx_csh_receipt_tl_rec.SOURCE_LANG,

Line 266: FETCH okl_trx_csh_receipt_tl_pk_csr INTO

262: x_no_data_found := TRUE;
263: -- Get current database values
264: OPEN okl_trx_csh_receipt_tl_pk_csr (p_okl_trx_csh_receipt_tl_rec.id,
265: p_okl_trx_csh_receipt_tl_rec.LANGUAGE);
266: FETCH okl_trx_csh_receipt_tl_pk_csr INTO
267: l_okl_trx_csh_receipt_tl_rec.ID,
268: l_okl_trx_csh_receipt_tl_rec.LANGUAGE,
269: l_okl_trx_csh_receipt_tl_rec.SOURCE_LANG,
270: l_okl_trx_csh_receipt_tl_rec.SFWT_FLAG,

Line 267: l_okl_trx_csh_receipt_tl_rec.ID,

263: -- Get current database values
264: OPEN okl_trx_csh_receipt_tl_pk_csr (p_okl_trx_csh_receipt_tl_rec.id,
265: p_okl_trx_csh_receipt_tl_rec.LANGUAGE);
266: FETCH okl_trx_csh_receipt_tl_pk_csr INTO
267: l_okl_trx_csh_receipt_tl_rec.ID,
268: l_okl_trx_csh_receipt_tl_rec.LANGUAGE,
269: l_okl_trx_csh_receipt_tl_rec.SOURCE_LANG,
270: l_okl_trx_csh_receipt_tl_rec.SFWT_FLAG,
271: l_okl_trx_csh_receipt_tl_rec.DESCRIPTION,

Line 268: l_okl_trx_csh_receipt_tl_rec.LANGUAGE,

264: OPEN okl_trx_csh_receipt_tl_pk_csr (p_okl_trx_csh_receipt_tl_rec.id,
265: p_okl_trx_csh_receipt_tl_rec.LANGUAGE);
266: FETCH okl_trx_csh_receipt_tl_pk_csr INTO
267: l_okl_trx_csh_receipt_tl_rec.ID,
268: l_okl_trx_csh_receipt_tl_rec.LANGUAGE,
269: l_okl_trx_csh_receipt_tl_rec.SOURCE_LANG,
270: l_okl_trx_csh_receipt_tl_rec.SFWT_FLAG,
271: l_okl_trx_csh_receipt_tl_rec.DESCRIPTION,
272: l_okl_trx_csh_receipt_tl_rec.CREATED_BY,

Line 269: l_okl_trx_csh_receipt_tl_rec.SOURCE_LANG,

265: p_okl_trx_csh_receipt_tl_rec.LANGUAGE);
266: FETCH okl_trx_csh_receipt_tl_pk_csr INTO
267: l_okl_trx_csh_receipt_tl_rec.ID,
268: l_okl_trx_csh_receipt_tl_rec.LANGUAGE,
269: l_okl_trx_csh_receipt_tl_rec.SOURCE_LANG,
270: l_okl_trx_csh_receipt_tl_rec.SFWT_FLAG,
271: l_okl_trx_csh_receipt_tl_rec.DESCRIPTION,
272: l_okl_trx_csh_receipt_tl_rec.CREATED_BY,
273: l_okl_trx_csh_receipt_tl_rec.CREATION_DATE,

Line 270: l_okl_trx_csh_receipt_tl_rec.SFWT_FLAG,

266: FETCH okl_trx_csh_receipt_tl_pk_csr INTO
267: l_okl_trx_csh_receipt_tl_rec.ID,
268: l_okl_trx_csh_receipt_tl_rec.LANGUAGE,
269: l_okl_trx_csh_receipt_tl_rec.SOURCE_LANG,
270: l_okl_trx_csh_receipt_tl_rec.SFWT_FLAG,
271: l_okl_trx_csh_receipt_tl_rec.DESCRIPTION,
272: l_okl_trx_csh_receipt_tl_rec.CREATED_BY,
273: l_okl_trx_csh_receipt_tl_rec.CREATION_DATE,
274: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATED_BY,

Line 271: l_okl_trx_csh_receipt_tl_rec.DESCRIPTION,

267: l_okl_trx_csh_receipt_tl_rec.ID,
268: l_okl_trx_csh_receipt_tl_rec.LANGUAGE,
269: l_okl_trx_csh_receipt_tl_rec.SOURCE_LANG,
270: l_okl_trx_csh_receipt_tl_rec.SFWT_FLAG,
271: l_okl_trx_csh_receipt_tl_rec.DESCRIPTION,
272: l_okl_trx_csh_receipt_tl_rec.CREATED_BY,
273: l_okl_trx_csh_receipt_tl_rec.CREATION_DATE,
274: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATED_BY,
275: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_DATE,

Line 272: l_okl_trx_csh_receipt_tl_rec.CREATED_BY,

268: l_okl_trx_csh_receipt_tl_rec.LANGUAGE,
269: l_okl_trx_csh_receipt_tl_rec.SOURCE_LANG,
270: l_okl_trx_csh_receipt_tl_rec.SFWT_FLAG,
271: l_okl_trx_csh_receipt_tl_rec.DESCRIPTION,
272: l_okl_trx_csh_receipt_tl_rec.CREATED_BY,
273: l_okl_trx_csh_receipt_tl_rec.CREATION_DATE,
274: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATED_BY,
275: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_DATE,
276: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_LOGIN;

Line 273: l_okl_trx_csh_receipt_tl_rec.CREATION_DATE,

269: l_okl_trx_csh_receipt_tl_rec.SOURCE_LANG,
270: l_okl_trx_csh_receipt_tl_rec.SFWT_FLAG,
271: l_okl_trx_csh_receipt_tl_rec.DESCRIPTION,
272: l_okl_trx_csh_receipt_tl_rec.CREATED_BY,
273: l_okl_trx_csh_receipt_tl_rec.CREATION_DATE,
274: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATED_BY,
275: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_DATE,
276: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_LOGIN;
277: x_no_data_found := okl_trx_csh_receipt_tl_pk_csr%NOTFOUND;

Line 274: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATED_BY,

270: l_okl_trx_csh_receipt_tl_rec.SFWT_FLAG,
271: l_okl_trx_csh_receipt_tl_rec.DESCRIPTION,
272: l_okl_trx_csh_receipt_tl_rec.CREATED_BY,
273: l_okl_trx_csh_receipt_tl_rec.CREATION_DATE,
274: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATED_BY,
275: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_DATE,
276: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_LOGIN;
277: x_no_data_found := okl_trx_csh_receipt_tl_pk_csr%NOTFOUND;
278: CLOSE okl_trx_csh_receipt_tl_pk_csr;

Line 275: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_DATE,

271: l_okl_trx_csh_receipt_tl_rec.DESCRIPTION,
272: l_okl_trx_csh_receipt_tl_rec.CREATED_BY,
273: l_okl_trx_csh_receipt_tl_rec.CREATION_DATE,
274: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATED_BY,
275: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_DATE,
276: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_LOGIN;
277: x_no_data_found := okl_trx_csh_receipt_tl_pk_csr%NOTFOUND;
278: CLOSE okl_trx_csh_receipt_tl_pk_csr;
279: RETURN(l_okl_trx_csh_receipt_tl_rec);

Line 276: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_LOGIN;

272: l_okl_trx_csh_receipt_tl_rec.CREATED_BY,
273: l_okl_trx_csh_receipt_tl_rec.CREATION_DATE,
274: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATED_BY,
275: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_DATE,
276: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_LOGIN;
277: x_no_data_found := okl_trx_csh_receipt_tl_pk_csr%NOTFOUND;
278: CLOSE okl_trx_csh_receipt_tl_pk_csr;
279: RETURN(l_okl_trx_csh_receipt_tl_rec);
280: END get_rec;

Line 277: x_no_data_found := okl_trx_csh_receipt_tl_pk_csr%NOTFOUND;

273: l_okl_trx_csh_receipt_tl_rec.CREATION_DATE,
274: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATED_BY,
275: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_DATE,
276: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_LOGIN;
277: x_no_data_found := okl_trx_csh_receipt_tl_pk_csr%NOTFOUND;
278: CLOSE okl_trx_csh_receipt_tl_pk_csr;
279: RETURN(l_okl_trx_csh_receipt_tl_rec);
280: END get_rec;
281:

Line 278: CLOSE okl_trx_csh_receipt_tl_pk_csr;

274: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATED_BY,
275: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_DATE,
276: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_LOGIN;
277: x_no_data_found := okl_trx_csh_receipt_tl_pk_csr%NOTFOUND;
278: CLOSE okl_trx_csh_receipt_tl_pk_csr;
279: RETURN(l_okl_trx_csh_receipt_tl_rec);
280: END get_rec;
281:
282: FUNCTION get_rec (

Line 279: RETURN(l_okl_trx_csh_receipt_tl_rec);

275: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_DATE,
276: l_okl_trx_csh_receipt_tl_rec.LAST_UPDATE_LOGIN;
277: x_no_data_found := okl_trx_csh_receipt_tl_pk_csr%NOTFOUND;
278: CLOSE okl_trx_csh_receipt_tl_pk_csr;
279: RETURN(l_okl_trx_csh_receipt_tl_rec);
280: END get_rec;
281:
282: FUNCTION get_rec (
283: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType

Line 283: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType

279: RETURN(l_okl_trx_csh_receipt_tl_rec);
280: END get_rec;
281:
282: FUNCTION get_rec (
283: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType
284: ) RETURN OklTrxCshReceiptTlRecType IS
285: l_row_notfound BOOLEAN := TRUE;
286: BEGIN
287: RETURN(get_rec(p_okl_trx_csh_receipt_tl_rec, l_row_notfound));

Line 287: RETURN(get_rec(p_okl_trx_csh_receipt_tl_rec, l_row_notfound));

283: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType
284: ) RETURN OklTrxCshReceiptTlRecType IS
285: l_row_notfound BOOLEAN := TRUE;
286: BEGIN
287: RETURN(get_rec(p_okl_trx_csh_receipt_tl_rec, l_row_notfound));
288: END get_rec;
289: ---------------------------------------------------------------------------
290: -- FUNCTION get_rec for: OKL_TRX_CSH_RECEIPT_V
291: ---------------------------------------------------------------------------

Line 1412: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;

1408: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1409: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1410: l_rctv_rec rctv_rec_type := p_rctv_rec;
1411: l_rct_rec rct_rec_type;
1412: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
1413: BEGIN
1414: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1415: G_PKG_NAME,
1416: p_init_msg_list,

Line 1754: -- insert_row for:OKL_TRX_CSH_RECEIPT_TL --

1750: '_PVT'
1751: );
1752: END insert_row;
1753: -------------------------------------------
1754: -- insert_row for:OKL_TRX_CSH_RECEIPT_TL --
1755: -------------------------------------------
1756: PROCEDURE insert_row(
1757: p_init_msg_list IN VARCHAR2,
1758: x_return_status OUT NOCOPY VARCHAR2,

Line 1761: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,

1757: p_init_msg_list IN VARCHAR2,
1758: x_return_status OUT NOCOPY VARCHAR2,
1759: x_msg_count OUT NOCOPY NUMBER,
1760: x_msg_data OUT NOCOPY VARCHAR2,
1761: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
1762: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType) IS
1763:
1764: l_api_version CONSTANT NUMBER := 1;
1765: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1762: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType) IS

1758: x_return_status OUT NOCOPY VARCHAR2,
1759: x_msg_count OUT NOCOPY NUMBER,
1760: x_msg_data OUT NOCOPY VARCHAR2,
1761: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
1762: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType) IS
1763:
1764: l_api_version CONSTANT NUMBER := 1;
1765: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1766: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 1767: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType := p_okl_trx_csh_receipt_tl_rec;

1763:
1764: l_api_version CONSTANT NUMBER := 1;
1765: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1766: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1767: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType := p_okl_trx_csh_receipt_tl_rec;
1768: ldefokltrxcshreceipttlrec OklTrxCshReceiptTlRecType;
1769: CURSOR get_languages IS
1770: SELECT *
1771: FROM FND_LANGUAGES

Line 1774: -- Set_Attributes for:OKL_TRX_CSH_RECEIPT_TL --

1770: SELECT *
1771: FROM FND_LANGUAGES
1772: WHERE INSTALLED_FLAG IN ('I', 'B');
1773: -----------------------------------------------
1774: -- Set_Attributes for:OKL_TRX_CSH_RECEIPT_TL --
1775: -----------------------------------------------
1776: FUNCTION Set_Attributes (
1777: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
1778: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType

Line 1777: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,

1773: -----------------------------------------------
1774: -- Set_Attributes for:OKL_TRX_CSH_RECEIPT_TL --
1775: -----------------------------------------------
1776: FUNCTION Set_Attributes (
1777: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
1778: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType
1779: ) RETURN VARCHAR2 IS
1780: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1781: BEGIN

Line 1778: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType

1774: -- Set_Attributes for:OKL_TRX_CSH_RECEIPT_TL --
1775: -----------------------------------------------
1776: FUNCTION Set_Attributes (
1777: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
1778: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType
1779: ) RETURN VARCHAR2 IS
1780: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1781: BEGIN
1782: x_okl_trx_csh_receipt_tl_rec := p_okl_trx_csh_receipt_tl_rec;

Line 1782: x_okl_trx_csh_receipt_tl_rec := p_okl_trx_csh_receipt_tl_rec;

1778: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType
1779: ) RETURN VARCHAR2 IS
1780: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1781: BEGIN
1782: x_okl_trx_csh_receipt_tl_rec := p_okl_trx_csh_receipt_tl_rec;
1783: x_okl_trx_csh_receipt_tl_rec.LANGUAGE := USERENV('LANG');
1784: x_okl_trx_csh_receipt_tl_rec.SOURCE_LANG := USERENV('LANG');
1785: RETURN(l_return_status);
1786: END Set_Attributes;

Line 1783: x_okl_trx_csh_receipt_tl_rec.LANGUAGE := USERENV('LANG');

1779: ) RETURN VARCHAR2 IS
1780: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1781: BEGIN
1782: x_okl_trx_csh_receipt_tl_rec := p_okl_trx_csh_receipt_tl_rec;
1783: x_okl_trx_csh_receipt_tl_rec.LANGUAGE := USERENV('LANG');
1784: x_okl_trx_csh_receipt_tl_rec.SOURCE_LANG := USERENV('LANG');
1785: RETURN(l_return_status);
1786: END Set_Attributes;
1787: BEGIN

Line 1784: x_okl_trx_csh_receipt_tl_rec.SOURCE_LANG := USERENV('LANG');

1780: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1781: BEGIN
1782: x_okl_trx_csh_receipt_tl_rec := p_okl_trx_csh_receipt_tl_rec;
1783: x_okl_trx_csh_receipt_tl_rec.LANGUAGE := USERENV('LANG');
1784: x_okl_trx_csh_receipt_tl_rec.SOURCE_LANG := USERENV('LANG');
1785: RETURN(l_return_status);
1786: END Set_Attributes;
1787: BEGIN
1788: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 1799: p_okl_trx_csh_receipt_tl_rec, -- IN

1795: RAISE Okl_Api.G_EXCEPTION_ERROR;
1796: END IF;
1797: --- Setting item attributes
1798: l_return_status := Set_Attributes(
1799: p_okl_trx_csh_receipt_tl_rec, -- IN
1800: l_okl_trx_csh_receipt_tl_rec); -- OUT
1801: --- If any errors happen abort API
1802: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1803: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1800: l_okl_trx_csh_receipt_tl_rec); -- OUT

1796: END IF;
1797: --- Setting item attributes
1798: l_return_status := Set_Attributes(
1799: p_okl_trx_csh_receipt_tl_rec, -- IN
1800: l_okl_trx_csh_receipt_tl_rec); -- OUT
1801: --- If any errors happen abort API
1802: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1803: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1804: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 1808: l_okl_trx_csh_receipt_tl_rec.LANGUAGE := l_lang_rec.language_code;

1804: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1805: RAISE Okl_Api.G_EXCEPTION_ERROR;
1806: END IF;
1807: FOR l_lang_rec IN get_languages LOOP
1808: l_okl_trx_csh_receipt_tl_rec.LANGUAGE := l_lang_rec.language_code;
1809: INSERT INTO OKL_TRX_CSH_RECEIPT_TL(
1810: id,
1811: LANGUAGE,
1812: source_lang,

Line 1809: INSERT INTO OKL_TRX_CSH_RECEIPT_TL(

1805: RAISE Okl_Api.G_EXCEPTION_ERROR;
1806: END IF;
1807: FOR l_lang_rec IN get_languages LOOP
1808: l_okl_trx_csh_receipt_tl_rec.LANGUAGE := l_lang_rec.language_code;
1809: INSERT INTO OKL_TRX_CSH_RECEIPT_TL(
1810: id,
1811: LANGUAGE,
1812: source_lang,
1813: sfwt_flag,

Line 1821: l_okl_trx_csh_receipt_tl_rec.id,

1817: last_updated_by,
1818: last_update_date,
1819: last_update_login)
1820: VALUES (
1821: l_okl_trx_csh_receipt_tl_rec.id,
1822: l_okl_trx_csh_receipt_tl_rec.LANGUAGE,
1823: l_okl_trx_csh_receipt_tl_rec.source_lang,
1824: l_okl_trx_csh_receipt_tl_rec.sfwt_flag,
1825: l_okl_trx_csh_receipt_tl_rec.description,

Line 1822: l_okl_trx_csh_receipt_tl_rec.LANGUAGE,

1818: last_update_date,
1819: last_update_login)
1820: VALUES (
1821: l_okl_trx_csh_receipt_tl_rec.id,
1822: l_okl_trx_csh_receipt_tl_rec.LANGUAGE,
1823: l_okl_trx_csh_receipt_tl_rec.source_lang,
1824: l_okl_trx_csh_receipt_tl_rec.sfwt_flag,
1825: l_okl_trx_csh_receipt_tl_rec.description,
1826: l_okl_trx_csh_receipt_tl_rec.created_by,

Line 1823: l_okl_trx_csh_receipt_tl_rec.source_lang,

1819: last_update_login)
1820: VALUES (
1821: l_okl_trx_csh_receipt_tl_rec.id,
1822: l_okl_trx_csh_receipt_tl_rec.LANGUAGE,
1823: l_okl_trx_csh_receipt_tl_rec.source_lang,
1824: l_okl_trx_csh_receipt_tl_rec.sfwt_flag,
1825: l_okl_trx_csh_receipt_tl_rec.description,
1826: l_okl_trx_csh_receipt_tl_rec.created_by,
1827: l_okl_trx_csh_receipt_tl_rec.creation_date,

Line 1824: l_okl_trx_csh_receipt_tl_rec.sfwt_flag,

1820: VALUES (
1821: l_okl_trx_csh_receipt_tl_rec.id,
1822: l_okl_trx_csh_receipt_tl_rec.LANGUAGE,
1823: l_okl_trx_csh_receipt_tl_rec.source_lang,
1824: l_okl_trx_csh_receipt_tl_rec.sfwt_flag,
1825: l_okl_trx_csh_receipt_tl_rec.description,
1826: l_okl_trx_csh_receipt_tl_rec.created_by,
1827: l_okl_trx_csh_receipt_tl_rec.creation_date,
1828: l_okl_trx_csh_receipt_tl_rec.last_updated_by,

Line 1825: l_okl_trx_csh_receipt_tl_rec.description,

1821: l_okl_trx_csh_receipt_tl_rec.id,
1822: l_okl_trx_csh_receipt_tl_rec.LANGUAGE,
1823: l_okl_trx_csh_receipt_tl_rec.source_lang,
1824: l_okl_trx_csh_receipt_tl_rec.sfwt_flag,
1825: l_okl_trx_csh_receipt_tl_rec.description,
1826: l_okl_trx_csh_receipt_tl_rec.created_by,
1827: l_okl_trx_csh_receipt_tl_rec.creation_date,
1828: l_okl_trx_csh_receipt_tl_rec.last_updated_by,
1829: l_okl_trx_csh_receipt_tl_rec.last_update_date,

Line 1826: l_okl_trx_csh_receipt_tl_rec.created_by,

1822: l_okl_trx_csh_receipt_tl_rec.LANGUAGE,
1823: l_okl_trx_csh_receipt_tl_rec.source_lang,
1824: l_okl_trx_csh_receipt_tl_rec.sfwt_flag,
1825: l_okl_trx_csh_receipt_tl_rec.description,
1826: l_okl_trx_csh_receipt_tl_rec.created_by,
1827: l_okl_trx_csh_receipt_tl_rec.creation_date,
1828: l_okl_trx_csh_receipt_tl_rec.last_updated_by,
1829: l_okl_trx_csh_receipt_tl_rec.last_update_date,
1830: l_okl_trx_csh_receipt_tl_rec.last_update_login);

Line 1827: l_okl_trx_csh_receipt_tl_rec.creation_date,

1823: l_okl_trx_csh_receipt_tl_rec.source_lang,
1824: l_okl_trx_csh_receipt_tl_rec.sfwt_flag,
1825: l_okl_trx_csh_receipt_tl_rec.description,
1826: l_okl_trx_csh_receipt_tl_rec.created_by,
1827: l_okl_trx_csh_receipt_tl_rec.creation_date,
1828: l_okl_trx_csh_receipt_tl_rec.last_updated_by,
1829: l_okl_trx_csh_receipt_tl_rec.last_update_date,
1830: l_okl_trx_csh_receipt_tl_rec.last_update_login);
1831: END LOOP;

Line 1828: l_okl_trx_csh_receipt_tl_rec.last_updated_by,

1824: l_okl_trx_csh_receipt_tl_rec.sfwt_flag,
1825: l_okl_trx_csh_receipt_tl_rec.description,
1826: l_okl_trx_csh_receipt_tl_rec.created_by,
1827: l_okl_trx_csh_receipt_tl_rec.creation_date,
1828: l_okl_trx_csh_receipt_tl_rec.last_updated_by,
1829: l_okl_trx_csh_receipt_tl_rec.last_update_date,
1830: l_okl_trx_csh_receipt_tl_rec.last_update_login);
1831: END LOOP;
1832: -- Set OUT values

Line 1829: l_okl_trx_csh_receipt_tl_rec.last_update_date,

1825: l_okl_trx_csh_receipt_tl_rec.description,
1826: l_okl_trx_csh_receipt_tl_rec.created_by,
1827: l_okl_trx_csh_receipt_tl_rec.creation_date,
1828: l_okl_trx_csh_receipt_tl_rec.last_updated_by,
1829: l_okl_trx_csh_receipt_tl_rec.last_update_date,
1830: l_okl_trx_csh_receipt_tl_rec.last_update_login);
1831: END LOOP;
1832: -- Set OUT values
1833: x_okl_trx_csh_receipt_tl_rec := l_okl_trx_csh_receipt_tl_rec;

Line 1830: l_okl_trx_csh_receipt_tl_rec.last_update_login);

1826: l_okl_trx_csh_receipt_tl_rec.created_by,
1827: l_okl_trx_csh_receipt_tl_rec.creation_date,
1828: l_okl_trx_csh_receipt_tl_rec.last_updated_by,
1829: l_okl_trx_csh_receipt_tl_rec.last_update_date,
1830: l_okl_trx_csh_receipt_tl_rec.last_update_login);
1831: END LOOP;
1832: -- Set OUT values
1833: x_okl_trx_csh_receipt_tl_rec := l_okl_trx_csh_receipt_tl_rec;
1834: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1833: x_okl_trx_csh_receipt_tl_rec := l_okl_trx_csh_receipt_tl_rec;

1829: l_okl_trx_csh_receipt_tl_rec.last_update_date,
1830: l_okl_trx_csh_receipt_tl_rec.last_update_login);
1831: END LOOP;
1832: -- Set OUT values
1833: x_okl_trx_csh_receipt_tl_rec := l_okl_trx_csh_receipt_tl_rec;
1834: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1835: EXCEPTION
1836: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1837: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 1886: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;

1882: l_rctv_rec rctv_rec_type;
1883: l_def_rctv_rec rctv_rec_type;
1884: l_rct_rec rct_rec_type;
1885: lx_rct_rec rct_rec_type;
1886: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
1887: lx_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
1888: -------------------------------
1889: -- FUNCTION fill_who_columns --
1890: -------------------------------

Line 1887: lx_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;

1883: l_def_rctv_rec rctv_rec_type;
1884: l_rct_rec rct_rec_type;
1885: lx_rct_rec rct_rec_type;
1886: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
1887: lx_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
1888: -------------------------------
1889: -- FUNCTION fill_who_columns --
1890: -------------------------------
1891: FUNCTION fill_who_columns (

Line 1967: migrate(l_def_rctv_rec, l_okl_trx_csh_receipt_tl_rec);

1963: --------------------------------------
1964: -- Move VIEW record to "Child" records
1965: --------------------------------------
1966: migrate(l_def_rctv_rec, l_rct_rec);
1967: migrate(l_def_rctv_rec, l_okl_trx_csh_receipt_tl_rec);
1968: --------------------------------------------
1969: -- Call the INSERT_ROW for each child record
1970: --------------------------------------------
1971:

Line 1992: l_okl_trx_csh_receipt_tl_rec,

1988: p_init_msg_list,
1989: x_return_status,
1990: x_msg_count,
1991: x_msg_data,
1992: l_okl_trx_csh_receipt_tl_rec,
1993: lx_okl_trx_csh_receipt_tl_rec
1994: );
1995: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1996: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1993: lx_okl_trx_csh_receipt_tl_rec

1989: x_return_status,
1990: x_msg_count,
1991: x_msg_data,
1992: l_okl_trx_csh_receipt_tl_rec,
1993: lx_okl_trx_csh_receipt_tl_rec
1994: );
1995: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1996: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1997: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2000: migrate(lx_okl_trx_csh_receipt_tl_rec, l_def_rctv_rec);

1996: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1997: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1998: RAISE Okl_Api.G_EXCEPTION_ERROR;
1999: END IF;
2000: migrate(lx_okl_trx_csh_receipt_tl_rec, l_def_rctv_rec);
2001: -- Set OUT values
2002: x_rctv_rec := l_def_rctv_rec;
2003: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2004: EXCEPTION

Line 2233: -- lock_row for:OKL_TRX_CSH_RECEIPT_TL --

2229: '_PVT'
2230: );
2231: END lock_row;
2232: -----------------------------------------
2233: -- lock_row for:OKL_TRX_CSH_RECEIPT_TL --
2234: -----------------------------------------
2235: PROCEDURE lock_row(
2236: p_init_msg_list IN VARCHAR2,
2237: x_return_status OUT NOCOPY VARCHAR2,

Line 2240: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType) IS

2236: p_init_msg_list IN VARCHAR2,
2237: x_return_status OUT NOCOPY VARCHAR2,
2238: x_msg_count OUT NOCOPY NUMBER,
2239: x_msg_data OUT NOCOPY VARCHAR2,
2240: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType) IS
2241:
2242: E_Resource_Busy EXCEPTION;
2243: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2244: CURSOR lock_csr (p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType) IS

Line 2244: CURSOR lock_csr (p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType) IS

2240: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType) IS
2241:
2242: E_Resource_Busy EXCEPTION;
2243: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2244: CURSOR lock_csr (p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType) IS
2245: SELECT *
2246: FROM OKL_TRX_CSH_RECEIPT_TL
2247: WHERE ID = p_okl_trx_csh_receipt_tl_rec.id
2248: FOR UPDATE NOWAIT;

Line 2246: FROM OKL_TRX_CSH_RECEIPT_TL

2242: E_Resource_Busy EXCEPTION;
2243: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2244: CURSOR lock_csr (p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType) IS
2245: SELECT *
2246: FROM OKL_TRX_CSH_RECEIPT_TL
2247: WHERE ID = p_okl_trx_csh_receipt_tl_rec.id
2248: FOR UPDATE NOWAIT;
2249:
2250: l_api_version CONSTANT NUMBER := 1;

Line 2247: WHERE ID = p_okl_trx_csh_receipt_tl_rec.id

2243: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2244: CURSOR lock_csr (p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType) IS
2245: SELECT *
2246: FROM OKL_TRX_CSH_RECEIPT_TL
2247: WHERE ID = p_okl_trx_csh_receipt_tl_rec.id
2248: FOR UPDATE NOWAIT;
2249:
2250: l_api_version CONSTANT NUMBER := 1;
2251: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2267: OPEN lock_csr(p_okl_trx_csh_receipt_tl_rec);

2263: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2264: RAISE Okl_Api.G_EXCEPTION_ERROR;
2265: END IF;
2266: BEGIN
2267: OPEN lock_csr(p_okl_trx_csh_receipt_tl_rec);
2268: FETCH lock_csr INTO l_lock_var;
2269: l_row_notfound := lock_csr%NOTFOUND;
2270: CLOSE lock_csr;
2271: EXCEPTION

Line 2332: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;

2328: l_api_version CONSTANT NUMBER := 1;
2329: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2330: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2331: l_rct_rec rct_rec_type;
2332: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
2333: BEGIN
2334: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
2335: G_PKG_NAME,
2336: p_init_msg_list,

Line 2350: migrate(p_rctv_rec, l_okl_trx_csh_receipt_tl_rec);

2346: --------------------------------------
2347: -- Move VIEW record to "Child" records
2348: --------------------------------------
2349: migrate(p_rctv_rec, l_rct_rec);
2350: migrate(p_rctv_rec, l_okl_trx_csh_receipt_tl_rec);
2351: --------------------------------------------
2352: -- Call the LOCK_ROW for each child record
2353: --------------------------------------------
2354: lock_row(

Line 2371: l_okl_trx_csh_receipt_tl_rec

2367: p_init_msg_list,
2368: x_return_status,
2369: x_msg_count,
2370: x_msg_data,
2371: l_okl_trx_csh_receipt_tl_rec
2372: );
2373: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2374: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2375: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2854: -- update_row for:OKL_TRX_CSH_RECEIPT_TL --

2850: '_PVT'
2851: );
2852: END update_row;
2853: -------------------------------------------
2854: -- update_row for:OKL_TRX_CSH_RECEIPT_TL --
2855: -------------------------------------------
2856: PROCEDURE update_row(
2857: p_init_msg_list IN VARCHAR2,
2858: x_return_status OUT NOCOPY VARCHAR2,

Line 2861: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,

2857: p_init_msg_list IN VARCHAR2,
2858: x_return_status OUT NOCOPY VARCHAR2,
2859: x_msg_count OUT NOCOPY NUMBER,
2860: x_msg_data OUT NOCOPY VARCHAR2,
2861: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
2862: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType) IS
2863:
2864: l_api_version CONSTANT NUMBER := 1;
2865: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2862: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType) IS

2858: x_return_status OUT NOCOPY VARCHAR2,
2859: x_msg_count OUT NOCOPY NUMBER,
2860: x_msg_data OUT NOCOPY VARCHAR2,
2861: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
2862: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType) IS
2863:
2864: l_api_version CONSTANT NUMBER := 1;
2865: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2866: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2867: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType := p_okl_trx_csh_receipt_tl_rec;

2863:
2864: l_api_version CONSTANT NUMBER := 1;
2865: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2866: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2867: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType := p_okl_trx_csh_receipt_tl_rec;
2868: ldefokltrxcshreceipttlrec OklTrxCshReceiptTlRecType;
2869: l_row_notfound BOOLEAN := TRUE;
2870: ----------------------------------
2871: -- FUNCTION populate_new_record --

Line 2874: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,

2870: ----------------------------------
2871: -- FUNCTION populate_new_record --
2872: ----------------------------------
2873: FUNCTION populate_new_record (
2874: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
2875: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType
2876: ) RETURN VARCHAR2 IS
2877: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
2878: l_row_notfound BOOLEAN := TRUE;

Line 2875: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType

2871: -- FUNCTION populate_new_record --
2872: ----------------------------------
2873: FUNCTION populate_new_record (
2874: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
2875: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType
2876: ) RETURN VARCHAR2 IS
2877: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
2878: l_row_notfound BOOLEAN := TRUE;
2879: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2877: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;

2873: FUNCTION populate_new_record (
2874: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
2875: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType
2876: ) RETURN VARCHAR2 IS
2877: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
2878: l_row_notfound BOOLEAN := TRUE;
2879: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2880: BEGIN
2881: x_okl_trx_csh_receipt_tl_rec := p_okl_trx_csh_receipt_tl_rec;

Line 2881: x_okl_trx_csh_receipt_tl_rec := p_okl_trx_csh_receipt_tl_rec;

2877: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
2878: l_row_notfound BOOLEAN := TRUE;
2879: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2880: BEGIN
2881: x_okl_trx_csh_receipt_tl_rec := p_okl_trx_csh_receipt_tl_rec;
2882: -- Get current database values
2883: l_okl_trx_csh_receipt_tl_rec := get_rec(p_okl_trx_csh_receipt_tl_rec, l_row_notfound);
2884: IF (l_row_notfound) THEN
2885: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 2883: l_okl_trx_csh_receipt_tl_rec := get_rec(p_okl_trx_csh_receipt_tl_rec, l_row_notfound);

2879: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2880: BEGIN
2881: x_okl_trx_csh_receipt_tl_rec := p_okl_trx_csh_receipt_tl_rec;
2882: -- Get current database values
2883: l_okl_trx_csh_receipt_tl_rec := get_rec(p_okl_trx_csh_receipt_tl_rec, l_row_notfound);
2884: IF (l_row_notfound) THEN
2885: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2886: END IF;
2887: IF (x_okl_trx_csh_receipt_tl_rec.id = Okl_Api.G_MISS_NUM)

Line 2887: IF (x_okl_trx_csh_receipt_tl_rec.id = Okl_Api.G_MISS_NUM)

2883: l_okl_trx_csh_receipt_tl_rec := get_rec(p_okl_trx_csh_receipt_tl_rec, l_row_notfound);
2884: IF (l_row_notfound) THEN
2885: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2886: END IF;
2887: IF (x_okl_trx_csh_receipt_tl_rec.id = Okl_Api.G_MISS_NUM)
2888: THEN
2889: x_okl_trx_csh_receipt_tl_rec.id := l_okl_trx_csh_receipt_tl_rec.id;
2890: END IF;
2891: IF (x_okl_trx_csh_receipt_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)

Line 2889: x_okl_trx_csh_receipt_tl_rec.id := l_okl_trx_csh_receipt_tl_rec.id;

2885: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2886: END IF;
2887: IF (x_okl_trx_csh_receipt_tl_rec.id = Okl_Api.G_MISS_NUM)
2888: THEN
2889: x_okl_trx_csh_receipt_tl_rec.id := l_okl_trx_csh_receipt_tl_rec.id;
2890: END IF;
2891: IF (x_okl_trx_csh_receipt_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2892: THEN
2893: x_okl_trx_csh_receipt_tl_rec.LANGUAGE := l_okl_trx_csh_receipt_tl_rec.LANGUAGE;

Line 2891: IF (x_okl_trx_csh_receipt_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)

2887: IF (x_okl_trx_csh_receipt_tl_rec.id = Okl_Api.G_MISS_NUM)
2888: THEN
2889: x_okl_trx_csh_receipt_tl_rec.id := l_okl_trx_csh_receipt_tl_rec.id;
2890: END IF;
2891: IF (x_okl_trx_csh_receipt_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2892: THEN
2893: x_okl_trx_csh_receipt_tl_rec.LANGUAGE := l_okl_trx_csh_receipt_tl_rec.LANGUAGE;
2894: END IF;
2895: IF (x_okl_trx_csh_receipt_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)

Line 2893: x_okl_trx_csh_receipt_tl_rec.LANGUAGE := l_okl_trx_csh_receipt_tl_rec.LANGUAGE;

2889: x_okl_trx_csh_receipt_tl_rec.id := l_okl_trx_csh_receipt_tl_rec.id;
2890: END IF;
2891: IF (x_okl_trx_csh_receipt_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2892: THEN
2893: x_okl_trx_csh_receipt_tl_rec.LANGUAGE := l_okl_trx_csh_receipt_tl_rec.LANGUAGE;
2894: END IF;
2895: IF (x_okl_trx_csh_receipt_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2896: THEN
2897: x_okl_trx_csh_receipt_tl_rec.source_lang := l_okl_trx_csh_receipt_tl_rec.source_lang;

Line 2895: IF (x_okl_trx_csh_receipt_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)

2891: IF (x_okl_trx_csh_receipt_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2892: THEN
2893: x_okl_trx_csh_receipt_tl_rec.LANGUAGE := l_okl_trx_csh_receipt_tl_rec.LANGUAGE;
2894: END IF;
2895: IF (x_okl_trx_csh_receipt_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2896: THEN
2897: x_okl_trx_csh_receipt_tl_rec.source_lang := l_okl_trx_csh_receipt_tl_rec.source_lang;
2898: END IF;
2899: IF (x_okl_trx_csh_receipt_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)

Line 2897: x_okl_trx_csh_receipt_tl_rec.source_lang := l_okl_trx_csh_receipt_tl_rec.source_lang;

2893: x_okl_trx_csh_receipt_tl_rec.LANGUAGE := l_okl_trx_csh_receipt_tl_rec.LANGUAGE;
2894: END IF;
2895: IF (x_okl_trx_csh_receipt_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2896: THEN
2897: x_okl_trx_csh_receipt_tl_rec.source_lang := l_okl_trx_csh_receipt_tl_rec.source_lang;
2898: END IF;
2899: IF (x_okl_trx_csh_receipt_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2900: THEN
2901: x_okl_trx_csh_receipt_tl_rec.sfwt_flag := l_okl_trx_csh_receipt_tl_rec.sfwt_flag;

Line 2899: IF (x_okl_trx_csh_receipt_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)

2895: IF (x_okl_trx_csh_receipt_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2896: THEN
2897: x_okl_trx_csh_receipt_tl_rec.source_lang := l_okl_trx_csh_receipt_tl_rec.source_lang;
2898: END IF;
2899: IF (x_okl_trx_csh_receipt_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2900: THEN
2901: x_okl_trx_csh_receipt_tl_rec.sfwt_flag := l_okl_trx_csh_receipt_tl_rec.sfwt_flag;
2902: END IF;
2903: IF (x_okl_trx_csh_receipt_tl_rec.description = Okl_Api.G_MISS_CHAR)

Line 2901: x_okl_trx_csh_receipt_tl_rec.sfwt_flag := l_okl_trx_csh_receipt_tl_rec.sfwt_flag;

2897: x_okl_trx_csh_receipt_tl_rec.source_lang := l_okl_trx_csh_receipt_tl_rec.source_lang;
2898: END IF;
2899: IF (x_okl_trx_csh_receipt_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2900: THEN
2901: x_okl_trx_csh_receipt_tl_rec.sfwt_flag := l_okl_trx_csh_receipt_tl_rec.sfwt_flag;
2902: END IF;
2903: IF (x_okl_trx_csh_receipt_tl_rec.description = Okl_Api.G_MISS_CHAR)
2904: THEN
2905: x_okl_trx_csh_receipt_tl_rec.description := l_okl_trx_csh_receipt_tl_rec.description;

Line 2903: IF (x_okl_trx_csh_receipt_tl_rec.description = Okl_Api.G_MISS_CHAR)

2899: IF (x_okl_trx_csh_receipt_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2900: THEN
2901: x_okl_trx_csh_receipt_tl_rec.sfwt_flag := l_okl_trx_csh_receipt_tl_rec.sfwt_flag;
2902: END IF;
2903: IF (x_okl_trx_csh_receipt_tl_rec.description = Okl_Api.G_MISS_CHAR)
2904: THEN
2905: x_okl_trx_csh_receipt_tl_rec.description := l_okl_trx_csh_receipt_tl_rec.description;
2906: END IF;
2907: IF (x_okl_trx_csh_receipt_tl_rec.created_by = Okl_Api.G_MISS_NUM)

Line 2905: x_okl_trx_csh_receipt_tl_rec.description := l_okl_trx_csh_receipt_tl_rec.description;

2901: x_okl_trx_csh_receipt_tl_rec.sfwt_flag := l_okl_trx_csh_receipt_tl_rec.sfwt_flag;
2902: END IF;
2903: IF (x_okl_trx_csh_receipt_tl_rec.description = Okl_Api.G_MISS_CHAR)
2904: THEN
2905: x_okl_trx_csh_receipt_tl_rec.description := l_okl_trx_csh_receipt_tl_rec.description;
2906: END IF;
2907: IF (x_okl_trx_csh_receipt_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2908: THEN
2909: x_okl_trx_csh_receipt_tl_rec.created_by := l_okl_trx_csh_receipt_tl_rec.created_by;

Line 2907: IF (x_okl_trx_csh_receipt_tl_rec.created_by = Okl_Api.G_MISS_NUM)

2903: IF (x_okl_trx_csh_receipt_tl_rec.description = Okl_Api.G_MISS_CHAR)
2904: THEN
2905: x_okl_trx_csh_receipt_tl_rec.description := l_okl_trx_csh_receipt_tl_rec.description;
2906: END IF;
2907: IF (x_okl_trx_csh_receipt_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2908: THEN
2909: x_okl_trx_csh_receipt_tl_rec.created_by := l_okl_trx_csh_receipt_tl_rec.created_by;
2910: END IF;
2911: IF (x_okl_trx_csh_receipt_tl_rec.creation_date = Okl_Api.G_MISS_DATE)

Line 2909: x_okl_trx_csh_receipt_tl_rec.created_by := l_okl_trx_csh_receipt_tl_rec.created_by;

2905: x_okl_trx_csh_receipt_tl_rec.description := l_okl_trx_csh_receipt_tl_rec.description;
2906: END IF;
2907: IF (x_okl_trx_csh_receipt_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2908: THEN
2909: x_okl_trx_csh_receipt_tl_rec.created_by := l_okl_trx_csh_receipt_tl_rec.created_by;
2910: END IF;
2911: IF (x_okl_trx_csh_receipt_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2912: THEN
2913: x_okl_trx_csh_receipt_tl_rec.creation_date := l_okl_trx_csh_receipt_tl_rec.creation_date;

Line 2911: IF (x_okl_trx_csh_receipt_tl_rec.creation_date = Okl_Api.G_MISS_DATE)

2907: IF (x_okl_trx_csh_receipt_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2908: THEN
2909: x_okl_trx_csh_receipt_tl_rec.created_by := l_okl_trx_csh_receipt_tl_rec.created_by;
2910: END IF;
2911: IF (x_okl_trx_csh_receipt_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2912: THEN
2913: x_okl_trx_csh_receipt_tl_rec.creation_date := l_okl_trx_csh_receipt_tl_rec.creation_date;
2914: END IF;
2915: IF (x_okl_trx_csh_receipt_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)

Line 2913: x_okl_trx_csh_receipt_tl_rec.creation_date := l_okl_trx_csh_receipt_tl_rec.creation_date;

2909: x_okl_trx_csh_receipt_tl_rec.created_by := l_okl_trx_csh_receipt_tl_rec.created_by;
2910: END IF;
2911: IF (x_okl_trx_csh_receipt_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2912: THEN
2913: x_okl_trx_csh_receipt_tl_rec.creation_date := l_okl_trx_csh_receipt_tl_rec.creation_date;
2914: END IF;
2915: IF (x_okl_trx_csh_receipt_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2916: THEN
2917: x_okl_trx_csh_receipt_tl_rec.last_updated_by := l_okl_trx_csh_receipt_tl_rec.last_updated_by;

Line 2915: IF (x_okl_trx_csh_receipt_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)

2911: IF (x_okl_trx_csh_receipt_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2912: THEN
2913: x_okl_trx_csh_receipt_tl_rec.creation_date := l_okl_trx_csh_receipt_tl_rec.creation_date;
2914: END IF;
2915: IF (x_okl_trx_csh_receipt_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2916: THEN
2917: x_okl_trx_csh_receipt_tl_rec.last_updated_by := l_okl_trx_csh_receipt_tl_rec.last_updated_by;
2918: END IF;
2919: IF (x_okl_trx_csh_receipt_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)

Line 2917: x_okl_trx_csh_receipt_tl_rec.last_updated_by := l_okl_trx_csh_receipt_tl_rec.last_updated_by;

2913: x_okl_trx_csh_receipt_tl_rec.creation_date := l_okl_trx_csh_receipt_tl_rec.creation_date;
2914: END IF;
2915: IF (x_okl_trx_csh_receipt_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2916: THEN
2917: x_okl_trx_csh_receipt_tl_rec.last_updated_by := l_okl_trx_csh_receipt_tl_rec.last_updated_by;
2918: END IF;
2919: IF (x_okl_trx_csh_receipt_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2920: THEN
2921: x_okl_trx_csh_receipt_tl_rec.last_update_date := l_okl_trx_csh_receipt_tl_rec.last_update_date;

Line 2919: IF (x_okl_trx_csh_receipt_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)

2915: IF (x_okl_trx_csh_receipt_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2916: THEN
2917: x_okl_trx_csh_receipt_tl_rec.last_updated_by := l_okl_trx_csh_receipt_tl_rec.last_updated_by;
2918: END IF;
2919: IF (x_okl_trx_csh_receipt_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2920: THEN
2921: x_okl_trx_csh_receipt_tl_rec.last_update_date := l_okl_trx_csh_receipt_tl_rec.last_update_date;
2922: END IF;
2923: IF (x_okl_trx_csh_receipt_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)

Line 2921: x_okl_trx_csh_receipt_tl_rec.last_update_date := l_okl_trx_csh_receipt_tl_rec.last_update_date;

2917: x_okl_trx_csh_receipt_tl_rec.last_updated_by := l_okl_trx_csh_receipt_tl_rec.last_updated_by;
2918: END IF;
2919: IF (x_okl_trx_csh_receipt_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2920: THEN
2921: x_okl_trx_csh_receipt_tl_rec.last_update_date := l_okl_trx_csh_receipt_tl_rec.last_update_date;
2922: END IF;
2923: IF (x_okl_trx_csh_receipt_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2924: THEN
2925: x_okl_trx_csh_receipt_tl_rec.last_update_login := l_okl_trx_csh_receipt_tl_rec.last_update_login;

Line 2923: IF (x_okl_trx_csh_receipt_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)

2919: IF (x_okl_trx_csh_receipt_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2920: THEN
2921: x_okl_trx_csh_receipt_tl_rec.last_update_date := l_okl_trx_csh_receipt_tl_rec.last_update_date;
2922: END IF;
2923: IF (x_okl_trx_csh_receipt_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2924: THEN
2925: x_okl_trx_csh_receipt_tl_rec.last_update_login := l_okl_trx_csh_receipt_tl_rec.last_update_login;
2926: END IF;
2927: RETURN(l_return_status);

Line 2925: x_okl_trx_csh_receipt_tl_rec.last_update_login := l_okl_trx_csh_receipt_tl_rec.last_update_login;

2921: x_okl_trx_csh_receipt_tl_rec.last_update_date := l_okl_trx_csh_receipt_tl_rec.last_update_date;
2922: END IF;
2923: IF (x_okl_trx_csh_receipt_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2924: THEN
2925: x_okl_trx_csh_receipt_tl_rec.last_update_login := l_okl_trx_csh_receipt_tl_rec.last_update_login;
2926: END IF;
2927: RETURN(l_return_status);
2928: END populate_new_record;
2929: -----------------------------------------------

Line 2930: -- Set_Attributes for:OKL_TRX_CSH_RECEIPT_TL --

2926: END IF;
2927: RETURN(l_return_status);
2928: END populate_new_record;
2929: -----------------------------------------------
2930: -- Set_Attributes for:OKL_TRX_CSH_RECEIPT_TL --
2931: -----------------------------------------------
2932: FUNCTION Set_Attributes (
2933: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
2934: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType

Line 2933: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,

2929: -----------------------------------------------
2930: -- Set_Attributes for:OKL_TRX_CSH_RECEIPT_TL --
2931: -----------------------------------------------
2932: FUNCTION Set_Attributes (
2933: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
2934: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType
2935: ) RETURN VARCHAR2 IS
2936: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2937: BEGIN

Line 2934: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType

2930: -- Set_Attributes for:OKL_TRX_CSH_RECEIPT_TL --
2931: -----------------------------------------------
2932: FUNCTION Set_Attributes (
2933: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
2934: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType
2935: ) RETURN VARCHAR2 IS
2936: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2937: BEGIN
2938: x_okl_trx_csh_receipt_tl_rec := p_okl_trx_csh_receipt_tl_rec;

Line 2938: x_okl_trx_csh_receipt_tl_rec := p_okl_trx_csh_receipt_tl_rec;

2934: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType
2935: ) RETURN VARCHAR2 IS
2936: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2937: BEGIN
2938: x_okl_trx_csh_receipt_tl_rec := p_okl_trx_csh_receipt_tl_rec;
2939: x_okl_trx_csh_receipt_tl_rec.LANGUAGE := USERENV('LANG');
2940: x_okl_trx_csh_receipt_tl_rec.SOURCE_LANG := USERENV('LANG');
2941: RETURN(l_return_status);
2942: END Set_Attributes;

Line 2939: x_okl_trx_csh_receipt_tl_rec.LANGUAGE := USERENV('LANG');

2935: ) RETURN VARCHAR2 IS
2936: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2937: BEGIN
2938: x_okl_trx_csh_receipt_tl_rec := p_okl_trx_csh_receipt_tl_rec;
2939: x_okl_trx_csh_receipt_tl_rec.LANGUAGE := USERENV('LANG');
2940: x_okl_trx_csh_receipt_tl_rec.SOURCE_LANG := USERENV('LANG');
2941: RETURN(l_return_status);
2942: END Set_Attributes;
2943: BEGIN

Line 2940: x_okl_trx_csh_receipt_tl_rec.SOURCE_LANG := USERENV('LANG');

2936: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2937: BEGIN
2938: x_okl_trx_csh_receipt_tl_rec := p_okl_trx_csh_receipt_tl_rec;
2939: x_okl_trx_csh_receipt_tl_rec.LANGUAGE := USERENV('LANG');
2940: x_okl_trx_csh_receipt_tl_rec.SOURCE_LANG := USERENV('LANG');
2941: RETURN(l_return_status);
2942: END Set_Attributes;
2943: BEGIN
2944: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 2955: p_okl_trx_csh_receipt_tl_rec, -- IN

2951: RAISE Okl_Api.G_EXCEPTION_ERROR;
2952: END IF;
2953: --- Setting item attributes
2954: l_return_status := Set_Attributes(
2955: p_okl_trx_csh_receipt_tl_rec, -- IN
2956: l_okl_trx_csh_receipt_tl_rec); -- OUT
2957: --- If any errors happen abort API
2958: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2959: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2956: l_okl_trx_csh_receipt_tl_rec); -- OUT

2952: END IF;
2953: --- Setting item attributes
2954: l_return_status := Set_Attributes(
2955: p_okl_trx_csh_receipt_tl_rec, -- IN
2956: l_okl_trx_csh_receipt_tl_rec); -- OUT
2957: --- If any errors happen abort API
2958: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2959: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2960: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2963: l_return_status := populate_new_record(l_okl_trx_csh_receipt_tl_rec, ldefokltrxcshreceipttlrec);

2959: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2960: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2961: RAISE Okl_Api.G_EXCEPTION_ERROR;
2962: END IF;
2963: l_return_status := populate_new_record(l_okl_trx_csh_receipt_tl_rec, ldefokltrxcshreceipttlrec);
2964: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2965: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2966: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2967: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 2969: UPDATE OKL_TRX_CSH_RECEIPT_TL

2965: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2966: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2967: RAISE Okl_Api.G_EXCEPTION_ERROR;
2968: END IF;
2969: UPDATE OKL_TRX_CSH_RECEIPT_TL
2970: SET DESCRIPTION = ldefokltrxcshreceipttlrec.description,
2971: SOURCE_LANG = ldefokltrxcshreceipttlrec.source_lang,
2972: CREATED_BY = ldefokltrxcshreceipttlrec.created_by,
2973: CREATION_DATE = ldefokltrxcshreceipttlrec.creation_date,

Line 2980: UPDATE OKL_TRX_CSH_RECEIPT_TL

2976: LAST_UPDATE_LOGIN = ldefokltrxcshreceipttlrec.last_update_login
2977: WHERE ID = ldefokltrxcshreceipttlrec.id
2978: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2979:
2980: UPDATE OKL_TRX_CSH_RECEIPT_TL
2981: SET SFWT_FLAG = 'Y'
2982: WHERE ID = ldefokltrxcshreceipttlrec.id
2983: AND SOURCE_LANG <> USERENV('LANG');
2984:

Line 2985: x_okl_trx_csh_receipt_tl_rec := ldefokltrxcshreceipttlrec;

2981: SET SFWT_FLAG = 'Y'
2982: WHERE ID = ldefokltrxcshreceipttlrec.id
2983: AND SOURCE_LANG <> USERENV('LANG');
2984:
2985: x_okl_trx_csh_receipt_tl_rec := ldefokltrxcshreceipttlrec;
2986: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2987: EXCEPTION
2988: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2989: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 3050: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;

3046: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
3047: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3048: l_rctv_rec rctv_rec_type := p_rctv_rec;
3049: l_def_rctv_rec rctv_rec_type;
3050: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
3051: lx_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
3052: l_rct_rec rct_rec_type;
3053: lx_rct_rec rct_rec_type;
3054: -------------------------------

Line 3051: lx_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;

3047: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3048: l_rctv_rec rctv_rec_type := p_rctv_rec;
3049: l_def_rctv_rec rctv_rec_type;
3050: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
3051: lx_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
3052: l_rct_rec rct_rec_type;
3053: lx_rct_rec rct_rec_type;
3054: -------------------------------
3055: -- FUNCTION fill_who_columns --

Line 3338: migrate(l_def_rctv_rec, l_okl_trx_csh_receipt_tl_rec);

3334:
3335: --------------------------------------
3336: -- Move VIEW record to "Child" records
3337: --------------------------------------
3338: migrate(l_def_rctv_rec, l_okl_trx_csh_receipt_tl_rec);
3339: migrate(l_def_rctv_rec, l_rct_rec);
3340: --------------------------------------------
3341: -- Call the UPDATE_ROW for each child record
3342: --------------------------------------------

Line 3348: l_okl_trx_csh_receipt_tl_rec,

3344: p_init_msg_list,
3345: x_return_status,
3346: x_msg_count,
3347: x_msg_data,
3348: l_okl_trx_csh_receipt_tl_rec,
3349: lx_okl_trx_csh_receipt_tl_rec
3350: );
3351: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3352: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3349: lx_okl_trx_csh_receipt_tl_rec

3345: x_return_status,
3346: x_msg_count,
3347: x_msg_data,
3348: l_okl_trx_csh_receipt_tl_rec,
3349: lx_okl_trx_csh_receipt_tl_rec
3350: );
3351: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3352: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3353: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 3356: migrate(lx_okl_trx_csh_receipt_tl_rec, l_def_rctv_rec);

3352: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3353: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3354: RAISE Okl_Api.G_EXCEPTION_ERROR;
3355: END IF;
3356: migrate(lx_okl_trx_csh_receipt_tl_rec, l_def_rctv_rec);
3357: update_row(
3358: p_init_msg_list,
3359: x_return_status,
3360: x_msg_count,

Line 3558: -- delete_row for:OKL_TRX_CSH_RECEIPT_TL --

3554: '_PVT'
3555: );
3556: END delete_row;
3557: -------------------------------------------
3558: -- delete_row for:OKL_TRX_CSH_RECEIPT_TL --
3559: -------------------------------------------
3560: PROCEDURE delete_row(
3561: p_init_msg_list IN VARCHAR2,
3562: x_return_status OUT NOCOPY VARCHAR2,

Line 3565: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType) IS

3561: p_init_msg_list IN VARCHAR2,
3562: x_return_status OUT NOCOPY VARCHAR2,
3563: x_msg_count OUT NOCOPY NUMBER,
3564: x_msg_data OUT NOCOPY VARCHAR2,
3565: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType) IS
3566:
3567: l_api_version CONSTANT NUMBER := 1;
3568: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3569: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 3570: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType:= p_okl_trx_csh_receipt_tl_rec;

3566:
3567: l_api_version CONSTANT NUMBER := 1;
3568: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3569: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3570: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType:= p_okl_trx_csh_receipt_tl_rec;
3571: l_row_notfound BOOLEAN := TRUE;
3572: -----------------------------------------------
3573: -- Set_Attributes for:OKL_TRX_CSH_RECEIPT_TL --
3574: -----------------------------------------------

Line 3573: -- Set_Attributes for:OKL_TRX_CSH_RECEIPT_TL --

3569: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3570: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType:= p_okl_trx_csh_receipt_tl_rec;
3571: l_row_notfound BOOLEAN := TRUE;
3572: -----------------------------------------------
3573: -- Set_Attributes for:OKL_TRX_CSH_RECEIPT_TL --
3574: -----------------------------------------------
3575: FUNCTION Set_Attributes (
3576: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
3577: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType

Line 3576: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,

3572: -----------------------------------------------
3573: -- Set_Attributes for:OKL_TRX_CSH_RECEIPT_TL --
3574: -----------------------------------------------
3575: FUNCTION Set_Attributes (
3576: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
3577: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType
3578: ) RETURN VARCHAR2 IS
3579: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3580: BEGIN

Line 3577: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType

3573: -- Set_Attributes for:OKL_TRX_CSH_RECEIPT_TL --
3574: -----------------------------------------------
3575: FUNCTION Set_Attributes (
3576: p_okl_trx_csh_receipt_tl_rec IN OklTrxCshReceiptTlRecType,
3577: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType
3578: ) RETURN VARCHAR2 IS
3579: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3580: BEGIN
3581: x_okl_trx_csh_receipt_tl_rec := p_okl_trx_csh_receipt_tl_rec;

Line 3581: x_okl_trx_csh_receipt_tl_rec := p_okl_trx_csh_receipt_tl_rec;

3577: x_okl_trx_csh_receipt_tl_rec OUT NOCOPY OklTrxCshReceiptTlRecType
3578: ) RETURN VARCHAR2 IS
3579: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3580: BEGIN
3581: x_okl_trx_csh_receipt_tl_rec := p_okl_trx_csh_receipt_tl_rec;
3582: x_okl_trx_csh_receipt_tl_rec.LANGUAGE := USERENV('LANG');
3583: RETURN(l_return_status);
3584: END Set_Attributes;
3585: BEGIN

Line 3582: x_okl_trx_csh_receipt_tl_rec.LANGUAGE := USERENV('LANG');

3578: ) RETURN VARCHAR2 IS
3579: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3580: BEGIN
3581: x_okl_trx_csh_receipt_tl_rec := p_okl_trx_csh_receipt_tl_rec;
3582: x_okl_trx_csh_receipt_tl_rec.LANGUAGE := USERENV('LANG');
3583: RETURN(l_return_status);
3584: END Set_Attributes;
3585: BEGIN
3586: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 3597: p_okl_trx_csh_receipt_tl_rec, -- IN

3593: RAISE Okl_Api.G_EXCEPTION_ERROR;
3594: END IF;
3595: --- Setting item attributes
3596: l_return_status := Set_Attributes(
3597: p_okl_trx_csh_receipt_tl_rec, -- IN
3598: l_okl_trx_csh_receipt_tl_rec); -- OUT
3599: --- If any errors happen abort API
3600: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3601: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3598: l_okl_trx_csh_receipt_tl_rec); -- OUT

3594: END IF;
3595: --- Setting item attributes
3596: l_return_status := Set_Attributes(
3597: p_okl_trx_csh_receipt_tl_rec, -- IN
3598: l_okl_trx_csh_receipt_tl_rec); -- OUT
3599: --- If any errors happen abort API
3600: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3601: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3602: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 3605: DELETE FROM OKL_TRX_CSH_RECEIPT_TL

3601: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3602: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3603: RAISE Okl_Api.G_EXCEPTION_ERROR;
3604: END IF;
3605: DELETE FROM OKL_TRX_CSH_RECEIPT_TL
3606: WHERE ID = l_okl_trx_csh_receipt_tl_rec.id;
3607:
3608: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3609: EXCEPTION

Line 3606: WHERE ID = l_okl_trx_csh_receipt_tl_rec.id;

3602: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3603: RAISE Okl_Api.G_EXCEPTION_ERROR;
3604: END IF;
3605: DELETE FROM OKL_TRX_CSH_RECEIPT_TL
3606: WHERE ID = l_okl_trx_csh_receipt_tl_rec.id;
3607:
3608: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3609: EXCEPTION
3610: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

Line 3656: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;

3652: l_api_version CONSTANT NUMBER := 1;
3653: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3654: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3655: l_rctv_rec rctv_rec_type := p_rctv_rec;
3656: l_okl_trx_csh_receipt_tl_rec OklTrxCshReceiptTlRecType;
3657: l_rct_rec rct_rec_type;
3658: BEGIN
3659: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
3660: G_PKG_NAME,

Line 3677: migrate(l_rctv_rec, l_okl_trx_csh_receipt_tl_rec);

3673:
3674: --------------------------------------
3675: -- Move VIEW record to "Child" records
3676: --------------------------------------
3677: migrate(l_rctv_rec, l_okl_trx_csh_receipt_tl_rec);
3678: migrate(l_rctv_rec, l_rct_rec);
3679: --------------------------------------------
3680: -- Call the DELETE_ROW for each child record
3681: --------------------------------------------

Line 3687: l_okl_trx_csh_receipt_tl_rec

3683: p_init_msg_list,
3684: x_return_status,
3685: x_msg_count,
3686: x_msg_data,
3687: l_okl_trx_csh_receipt_tl_rec
3688: );
3689: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3690: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3691: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN