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_XHR_PVT dependencies on OKL_EXT_FUND_RQNS_TL

Line 40: DELETE FROM OKL_EXT_FUND_RQNS_TL T

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

Line 65: FROM OKL_EXT_FUND_RQNS_TL SUBB, OKL_EXT_FUND_RQNS_TL SUBT

61: T.LANGUAGE)
62: IN (SELECT
63: SUBT.ID,
64: SUBT.LANGUAGE
65: FROM OKL_EXT_FUND_RQNS_TL SUBB, OKL_EXT_FUND_RQNS_TL SUBT
66: WHERE SUBB.ID = SUBT.ID
67: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
68:
69: */

Line 71: INSERT INTO OKL_EXT_FUND_RQNS_TL (

67: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
68:
69: */
70:
71: INSERT INTO OKL_EXT_FUND_RQNS_TL (
72: ID,
73: LANGUAGE,
74: SOURCE_LANG,
75: SFWT_FLAG,

Line 91: FROM OKL_EXT_FUND_RQNS_TL B, FND_LANGUAGES L

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

Line 96: FROM OKL_EXT_FUND_RQNS_TL T

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

Line 192: -- FUNCTION get_rec for: OKL_EXT_FUND_RQNS_TL

188: BEGIN
189: RETURN(get_rec(p_xhr_rec, l_row_notfound));
190: END get_rec;
191: ---------------------------------------------------------------------------
192: -- FUNCTION get_rec for: OKL_EXT_FUND_RQNS_TL
193: ---------------------------------------------------------------------------
194: FUNCTION get_rec (
195: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
196: x_no_data_found OUT NOCOPY BOOLEAN

Line 195: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,

191: ---------------------------------------------------------------------------
192: -- FUNCTION get_rec for: OKL_EXT_FUND_RQNS_TL
193: ---------------------------------------------------------------------------
194: FUNCTION get_rec (
195: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
196: x_no_data_found OUT NOCOPY BOOLEAN
197: ) RETURN okl_ext_fund_rqns_tl_rec_type IS
198: CURSOR okl_ext_fund_rqns_tl_pk_csr (p_id IN NUMBER,
199: p_language IN VARCHAR2) IS

Line 197: ) RETURN okl_ext_fund_rqns_tl_rec_type IS

193: ---------------------------------------------------------------------------
194: FUNCTION get_rec (
195: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
196: x_no_data_found OUT NOCOPY BOOLEAN
197: ) RETURN okl_ext_fund_rqns_tl_rec_type IS
198: CURSOR okl_ext_fund_rqns_tl_pk_csr (p_id IN NUMBER,
199: p_language IN VARCHAR2) IS
200: SELECT
201: ID,

Line 198: CURSOR okl_ext_fund_rqns_tl_pk_csr (p_id IN NUMBER,

194: FUNCTION get_rec (
195: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
196: x_no_data_found OUT NOCOPY BOOLEAN
197: ) RETURN okl_ext_fund_rqns_tl_rec_type IS
198: CURSOR okl_ext_fund_rqns_tl_pk_csr (p_id IN NUMBER,
199: p_language IN VARCHAR2) IS
200: SELECT
201: ID,
202: LANGUAGE,

Line 210: FROM Okl_Ext_Fund_Rqns_Tl

206: CREATION_DATE,
207: LAST_UPDATED_BY,
208: LAST_UPDATE_DATE,
209: LAST_UPDATE_LOGIN
210: FROM Okl_Ext_Fund_Rqns_Tl
211: WHERE okl_ext_fund_rqns_tl.id = p_id
212: AND okl_ext_fund_rqns_tl.language = p_language;
213: l_okl_ext_fund_rqns_tl_pk okl_ext_fund_rqns_tl_pk_csr%ROWTYPE;
214: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;

Line 211: WHERE okl_ext_fund_rqns_tl.id = p_id

207: LAST_UPDATED_BY,
208: LAST_UPDATE_DATE,
209: LAST_UPDATE_LOGIN
210: FROM Okl_Ext_Fund_Rqns_Tl
211: WHERE okl_ext_fund_rqns_tl.id = p_id
212: AND okl_ext_fund_rqns_tl.language = p_language;
213: l_okl_ext_fund_rqns_tl_pk okl_ext_fund_rqns_tl_pk_csr%ROWTYPE;
214: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
215: BEGIN

Line 212: AND okl_ext_fund_rqns_tl.language = p_language;

208: LAST_UPDATE_DATE,
209: LAST_UPDATE_LOGIN
210: FROM Okl_Ext_Fund_Rqns_Tl
211: WHERE okl_ext_fund_rqns_tl.id = p_id
212: AND okl_ext_fund_rqns_tl.language = p_language;
213: l_okl_ext_fund_rqns_tl_pk okl_ext_fund_rqns_tl_pk_csr%ROWTYPE;
214: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
215: BEGIN
216: x_no_data_found := TRUE;

Line 213: l_okl_ext_fund_rqns_tl_pk okl_ext_fund_rqns_tl_pk_csr%ROWTYPE;

209: LAST_UPDATE_LOGIN
210: FROM Okl_Ext_Fund_Rqns_Tl
211: WHERE okl_ext_fund_rqns_tl.id = p_id
212: AND okl_ext_fund_rqns_tl.language = p_language;
213: l_okl_ext_fund_rqns_tl_pk okl_ext_fund_rqns_tl_pk_csr%ROWTYPE;
214: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
215: BEGIN
216: x_no_data_found := TRUE;
217: -- Get current database values

Line 214: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;

210: FROM Okl_Ext_Fund_Rqns_Tl
211: WHERE okl_ext_fund_rqns_tl.id = p_id
212: AND okl_ext_fund_rqns_tl.language = p_language;
213: l_okl_ext_fund_rqns_tl_pk okl_ext_fund_rqns_tl_pk_csr%ROWTYPE;
214: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
215: BEGIN
216: x_no_data_found := TRUE;
217: -- Get current database values
218: OPEN okl_ext_fund_rqns_tl_pk_csr (p_okl_ext_fund_rqns_tl_rec.id,

Line 218: OPEN okl_ext_fund_rqns_tl_pk_csr (p_okl_ext_fund_rqns_tl_rec.id,

214: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
215: BEGIN
216: x_no_data_found := TRUE;
217: -- Get current database values
218: OPEN okl_ext_fund_rqns_tl_pk_csr (p_okl_ext_fund_rqns_tl_rec.id,
219: p_okl_ext_fund_rqns_tl_rec.language);
220: FETCH okl_ext_fund_rqns_tl_pk_csr INTO
221: l_okl_ext_fund_rqns_tl_rec.ID,
222: l_okl_ext_fund_rqns_tl_rec.LANGUAGE,

Line 219: p_okl_ext_fund_rqns_tl_rec.language);

215: BEGIN
216: x_no_data_found := TRUE;
217: -- Get current database values
218: OPEN okl_ext_fund_rqns_tl_pk_csr (p_okl_ext_fund_rqns_tl_rec.id,
219: p_okl_ext_fund_rqns_tl_rec.language);
220: FETCH okl_ext_fund_rqns_tl_pk_csr INTO
221: l_okl_ext_fund_rqns_tl_rec.ID,
222: l_okl_ext_fund_rqns_tl_rec.LANGUAGE,
223: l_okl_ext_fund_rqns_tl_rec.SOURCE_LANG,

Line 220: FETCH okl_ext_fund_rqns_tl_pk_csr INTO

216: x_no_data_found := TRUE;
217: -- Get current database values
218: OPEN okl_ext_fund_rqns_tl_pk_csr (p_okl_ext_fund_rqns_tl_rec.id,
219: p_okl_ext_fund_rqns_tl_rec.language);
220: FETCH okl_ext_fund_rqns_tl_pk_csr INTO
221: l_okl_ext_fund_rqns_tl_rec.ID,
222: l_okl_ext_fund_rqns_tl_rec.LANGUAGE,
223: l_okl_ext_fund_rqns_tl_rec.SOURCE_LANG,
224: l_okl_ext_fund_rqns_tl_rec.SFWT_FLAG,

Line 221: l_okl_ext_fund_rqns_tl_rec.ID,

217: -- Get current database values
218: OPEN okl_ext_fund_rqns_tl_pk_csr (p_okl_ext_fund_rqns_tl_rec.id,
219: p_okl_ext_fund_rqns_tl_rec.language);
220: FETCH okl_ext_fund_rqns_tl_pk_csr INTO
221: l_okl_ext_fund_rqns_tl_rec.ID,
222: l_okl_ext_fund_rqns_tl_rec.LANGUAGE,
223: l_okl_ext_fund_rqns_tl_rec.SOURCE_LANG,
224: l_okl_ext_fund_rqns_tl_rec.SFWT_FLAG,
225: l_okl_ext_fund_rqns_tl_rec.CREATED_BY,

Line 222: l_okl_ext_fund_rqns_tl_rec.LANGUAGE,

218: OPEN okl_ext_fund_rqns_tl_pk_csr (p_okl_ext_fund_rqns_tl_rec.id,
219: p_okl_ext_fund_rqns_tl_rec.language);
220: FETCH okl_ext_fund_rqns_tl_pk_csr INTO
221: l_okl_ext_fund_rqns_tl_rec.ID,
222: l_okl_ext_fund_rqns_tl_rec.LANGUAGE,
223: l_okl_ext_fund_rqns_tl_rec.SOURCE_LANG,
224: l_okl_ext_fund_rqns_tl_rec.SFWT_FLAG,
225: l_okl_ext_fund_rqns_tl_rec.CREATED_BY,
226: l_okl_ext_fund_rqns_tl_rec.CREATION_DATE,

Line 223: l_okl_ext_fund_rqns_tl_rec.SOURCE_LANG,

219: p_okl_ext_fund_rqns_tl_rec.language);
220: FETCH okl_ext_fund_rqns_tl_pk_csr INTO
221: l_okl_ext_fund_rqns_tl_rec.ID,
222: l_okl_ext_fund_rqns_tl_rec.LANGUAGE,
223: l_okl_ext_fund_rqns_tl_rec.SOURCE_LANG,
224: l_okl_ext_fund_rqns_tl_rec.SFWT_FLAG,
225: l_okl_ext_fund_rqns_tl_rec.CREATED_BY,
226: l_okl_ext_fund_rqns_tl_rec.CREATION_DATE,
227: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATED_BY,

Line 224: l_okl_ext_fund_rqns_tl_rec.SFWT_FLAG,

220: FETCH okl_ext_fund_rqns_tl_pk_csr INTO
221: l_okl_ext_fund_rqns_tl_rec.ID,
222: l_okl_ext_fund_rqns_tl_rec.LANGUAGE,
223: l_okl_ext_fund_rqns_tl_rec.SOURCE_LANG,
224: l_okl_ext_fund_rqns_tl_rec.SFWT_FLAG,
225: l_okl_ext_fund_rqns_tl_rec.CREATED_BY,
226: l_okl_ext_fund_rqns_tl_rec.CREATION_DATE,
227: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATED_BY,
228: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_DATE,

Line 225: l_okl_ext_fund_rqns_tl_rec.CREATED_BY,

221: l_okl_ext_fund_rqns_tl_rec.ID,
222: l_okl_ext_fund_rqns_tl_rec.LANGUAGE,
223: l_okl_ext_fund_rqns_tl_rec.SOURCE_LANG,
224: l_okl_ext_fund_rqns_tl_rec.SFWT_FLAG,
225: l_okl_ext_fund_rqns_tl_rec.CREATED_BY,
226: l_okl_ext_fund_rqns_tl_rec.CREATION_DATE,
227: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATED_BY,
228: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_DATE,
229: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_LOGIN;

Line 226: l_okl_ext_fund_rqns_tl_rec.CREATION_DATE,

222: l_okl_ext_fund_rqns_tl_rec.LANGUAGE,
223: l_okl_ext_fund_rqns_tl_rec.SOURCE_LANG,
224: l_okl_ext_fund_rqns_tl_rec.SFWT_FLAG,
225: l_okl_ext_fund_rqns_tl_rec.CREATED_BY,
226: l_okl_ext_fund_rqns_tl_rec.CREATION_DATE,
227: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATED_BY,
228: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_DATE,
229: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_LOGIN;
230: x_no_data_found := okl_ext_fund_rqns_tl_pk_csr%NOTFOUND;

Line 227: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATED_BY,

223: l_okl_ext_fund_rqns_tl_rec.SOURCE_LANG,
224: l_okl_ext_fund_rqns_tl_rec.SFWT_FLAG,
225: l_okl_ext_fund_rqns_tl_rec.CREATED_BY,
226: l_okl_ext_fund_rqns_tl_rec.CREATION_DATE,
227: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATED_BY,
228: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_DATE,
229: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_LOGIN;
230: x_no_data_found := okl_ext_fund_rqns_tl_pk_csr%NOTFOUND;
231: CLOSE okl_ext_fund_rqns_tl_pk_csr;

Line 228: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_DATE,

224: l_okl_ext_fund_rqns_tl_rec.SFWT_FLAG,
225: l_okl_ext_fund_rqns_tl_rec.CREATED_BY,
226: l_okl_ext_fund_rqns_tl_rec.CREATION_DATE,
227: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATED_BY,
228: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_DATE,
229: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_LOGIN;
230: x_no_data_found := okl_ext_fund_rqns_tl_pk_csr%NOTFOUND;
231: CLOSE okl_ext_fund_rqns_tl_pk_csr;
232: RETURN(l_okl_ext_fund_rqns_tl_rec);

Line 229: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_LOGIN;

225: l_okl_ext_fund_rqns_tl_rec.CREATED_BY,
226: l_okl_ext_fund_rqns_tl_rec.CREATION_DATE,
227: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATED_BY,
228: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_DATE,
229: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_LOGIN;
230: x_no_data_found := okl_ext_fund_rqns_tl_pk_csr%NOTFOUND;
231: CLOSE okl_ext_fund_rqns_tl_pk_csr;
232: RETURN(l_okl_ext_fund_rqns_tl_rec);
233: END get_rec;

Line 230: x_no_data_found := okl_ext_fund_rqns_tl_pk_csr%NOTFOUND;

226: l_okl_ext_fund_rqns_tl_rec.CREATION_DATE,
227: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATED_BY,
228: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_DATE,
229: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_LOGIN;
230: x_no_data_found := okl_ext_fund_rqns_tl_pk_csr%NOTFOUND;
231: CLOSE okl_ext_fund_rqns_tl_pk_csr;
232: RETURN(l_okl_ext_fund_rqns_tl_rec);
233: END get_rec;
234:

Line 231: CLOSE okl_ext_fund_rqns_tl_pk_csr;

227: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATED_BY,
228: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_DATE,
229: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_LOGIN;
230: x_no_data_found := okl_ext_fund_rqns_tl_pk_csr%NOTFOUND;
231: CLOSE okl_ext_fund_rqns_tl_pk_csr;
232: RETURN(l_okl_ext_fund_rqns_tl_rec);
233: END get_rec;
234:
235: FUNCTION get_rec (

Line 232: RETURN(l_okl_ext_fund_rqns_tl_rec);

228: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_DATE,
229: l_okl_ext_fund_rqns_tl_rec.LAST_UPDATE_LOGIN;
230: x_no_data_found := okl_ext_fund_rqns_tl_pk_csr%NOTFOUND;
231: CLOSE okl_ext_fund_rqns_tl_pk_csr;
232: RETURN(l_okl_ext_fund_rqns_tl_rec);
233: END get_rec;
234:
235: FUNCTION get_rec (
236: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type

Line 236: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type

232: RETURN(l_okl_ext_fund_rqns_tl_rec);
233: END get_rec;
234:
235: FUNCTION get_rec (
236: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type
237: ) RETURN okl_ext_fund_rqns_tl_rec_type IS
238: l_row_notfound BOOLEAN := TRUE;
239: BEGIN
240: RETURN(get_rec(p_okl_ext_fund_rqns_tl_rec, l_row_notfound));

Line 237: ) RETURN okl_ext_fund_rqns_tl_rec_type IS

233: END get_rec;
234:
235: FUNCTION get_rec (
236: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type
237: ) RETURN okl_ext_fund_rqns_tl_rec_type IS
238: l_row_notfound BOOLEAN := TRUE;
239: BEGIN
240: RETURN(get_rec(p_okl_ext_fund_rqns_tl_rec, l_row_notfound));
241: END get_rec;

Line 240: RETURN(get_rec(p_okl_ext_fund_rqns_tl_rec, l_row_notfound));

236: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type
237: ) RETURN okl_ext_fund_rqns_tl_rec_type IS
238: l_row_notfound BOOLEAN := TRUE;
239: BEGIN
240: RETURN(get_rec(p_okl_ext_fund_rqns_tl_rec, l_row_notfound));
241: END get_rec;
242: ---------------------------------------------------------------------------
243: -- FUNCTION get_rec for: OKL_EXT_FUND_RQNS_V
244: ---------------------------------------------------------------------------

Line 544: p_to OUT NOCOPY okl_ext_fund_rqns_tl_rec_type

540: p_to.last_update_login := p_from.last_update_login;
541: END migrate;
542: PROCEDURE migrate (
543: p_from IN xhrv_rec_type,
544: p_to OUT NOCOPY okl_ext_fund_rqns_tl_rec_type
545: ) IS
546: BEGIN
547: p_to.id := p_from.id;
548: p_to.sfwt_flag := p_from.sfwt_flag;

Line 556: p_from IN okl_ext_fund_rqns_tl_rec_type,

552: p_to.last_update_date := p_from.last_update_date;
553: p_to.last_update_login := p_from.last_update_login;
554: END migrate;
555: PROCEDURE migrate (
556: p_from IN okl_ext_fund_rqns_tl_rec_type,
557: p_to OUT NOCOPY xhrv_rec_type
558: ) IS
559: BEGIN
560: p_to.id := p_from.id;

Line 588: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;

584: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
585: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
586: l_xhrv_rec xhrv_rec_type := p_xhrv_rec;
587: l_xhr_rec xhr_rec_type;
588: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
589: BEGIN
590: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
591: G_PKG_NAME,
592: p_init_msg_list,

Line 861: -- insert_row for:OKL_EXT_FUND_RQNS_TL --

857: '_PVT'
858: );
859: END insert_row;
860: -----------------------------------------
861: -- insert_row for:OKL_EXT_FUND_RQNS_TL --
862: -----------------------------------------
863: PROCEDURE insert_row(
864: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
865: x_return_status OUT NOCOPY VARCHAR2,

Line 868: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,

864: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
865: x_return_status OUT NOCOPY VARCHAR2,
866: x_msg_count OUT NOCOPY NUMBER,
867: x_msg_data OUT NOCOPY VARCHAR2,
868: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
869: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type) IS
870:
871: l_api_version CONSTANT NUMBER := 1;
872: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 869: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type) IS

865: x_return_status OUT NOCOPY VARCHAR2,
866: x_msg_count OUT NOCOPY NUMBER,
867: x_msg_data OUT NOCOPY VARCHAR2,
868: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
869: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type) IS
870:
871: l_api_version CONSTANT NUMBER := 1;
872: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
873: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 874: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type := p_okl_ext_fund_rqns_tl_rec;

870:
871: l_api_version CONSTANT NUMBER := 1;
872: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
873: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
874: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type := p_okl_ext_fund_rqns_tl_rec;
875: ldefoklextfundrqnstlrec okl_ext_fund_rqns_tl_rec_type;
876: CURSOR get_languages IS
877: SELECT *
878: FROM FND_LANGUAGES

Line 875: ldefoklextfundrqnstlrec okl_ext_fund_rqns_tl_rec_type;

871: l_api_version CONSTANT NUMBER := 1;
872: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
873: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
874: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type := p_okl_ext_fund_rqns_tl_rec;
875: ldefoklextfundrqnstlrec okl_ext_fund_rqns_tl_rec_type;
876: CURSOR get_languages IS
877: SELECT *
878: FROM FND_LANGUAGES
879: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 881: -- Set_Attributes for:OKL_EXT_FUND_RQNS_TL --

877: SELECT *
878: FROM FND_LANGUAGES
879: WHERE INSTALLED_FLAG IN ('I', 'B');
880: ---------------------------------------------
881: -- Set_Attributes for:OKL_EXT_FUND_RQNS_TL --
882: ---------------------------------------------
883: FUNCTION Set_Attributes (
884: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
885: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type

Line 884: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,

880: ---------------------------------------------
881: -- Set_Attributes for:OKL_EXT_FUND_RQNS_TL --
882: ---------------------------------------------
883: FUNCTION Set_Attributes (
884: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
885: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type
886: ) RETURN VARCHAR2 IS
887: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
888: BEGIN

Line 885: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type

881: -- Set_Attributes for:OKL_EXT_FUND_RQNS_TL --
882: ---------------------------------------------
883: FUNCTION Set_Attributes (
884: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
885: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type
886: ) RETURN VARCHAR2 IS
887: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
888: BEGIN
889: x_okl_ext_fund_rqns_tl_rec := p_okl_ext_fund_rqns_tl_rec;

Line 889: x_okl_ext_fund_rqns_tl_rec := p_okl_ext_fund_rqns_tl_rec;

885: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type
886: ) RETURN VARCHAR2 IS
887: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
888: BEGIN
889: x_okl_ext_fund_rqns_tl_rec := p_okl_ext_fund_rqns_tl_rec;
890: x_okl_ext_fund_rqns_tl_rec.LANGUAGE := USERENV('LANG');
891: x_okl_ext_fund_rqns_tl_rec.SOURCE_LANG := USERENV('LANG');
892: RETURN(l_return_status);
893: END Set_Attributes;

Line 890: x_okl_ext_fund_rqns_tl_rec.LANGUAGE := USERENV('LANG');

886: ) RETURN VARCHAR2 IS
887: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
888: BEGIN
889: x_okl_ext_fund_rqns_tl_rec := p_okl_ext_fund_rqns_tl_rec;
890: x_okl_ext_fund_rqns_tl_rec.LANGUAGE := USERENV('LANG');
891: x_okl_ext_fund_rqns_tl_rec.SOURCE_LANG := USERENV('LANG');
892: RETURN(l_return_status);
893: END Set_Attributes;
894: BEGIN

Line 891: x_okl_ext_fund_rqns_tl_rec.SOURCE_LANG := USERENV('LANG');

887: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
888: BEGIN
889: x_okl_ext_fund_rqns_tl_rec := p_okl_ext_fund_rqns_tl_rec;
890: x_okl_ext_fund_rqns_tl_rec.LANGUAGE := USERENV('LANG');
891: x_okl_ext_fund_rqns_tl_rec.SOURCE_LANG := USERENV('LANG');
892: RETURN(l_return_status);
893: END Set_Attributes;
894: BEGIN
895: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 906: p_okl_ext_fund_rqns_tl_rec, -- IN

902: RAISE OKC_API.G_EXCEPTION_ERROR;
903: END IF;
904: --- Setting item attributes
905: l_return_status := Set_Attributes(
906: p_okl_ext_fund_rqns_tl_rec, -- IN
907: l_okl_ext_fund_rqns_tl_rec); -- OUT
908: --- If any errors happen abort API
909: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
910: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 907: l_okl_ext_fund_rqns_tl_rec); -- OUT

903: END IF;
904: --- Setting item attributes
905: l_return_status := Set_Attributes(
906: p_okl_ext_fund_rqns_tl_rec, -- IN
907: l_okl_ext_fund_rqns_tl_rec); -- OUT
908: --- If any errors happen abort API
909: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
910: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
911: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 915: l_okl_ext_fund_rqns_tl_rec.language := l_lang_rec.language_code;

911: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
912: RAISE OKC_API.G_EXCEPTION_ERROR;
913: END IF;
914: FOR l_lang_rec IN get_languages LOOP
915: l_okl_ext_fund_rqns_tl_rec.language := l_lang_rec.language_code;
916: INSERT INTO OKL_EXT_FUND_RQNS_TL(
917: id,
918: language,
919: source_lang,

Line 916: INSERT INTO OKL_EXT_FUND_RQNS_TL(

912: RAISE OKC_API.G_EXCEPTION_ERROR;
913: END IF;
914: FOR l_lang_rec IN get_languages LOOP
915: l_okl_ext_fund_rqns_tl_rec.language := l_lang_rec.language_code;
916: INSERT INTO OKL_EXT_FUND_RQNS_TL(
917: id,
918: language,
919: source_lang,
920: sfwt_flag,

Line 927: l_okl_ext_fund_rqns_tl_rec.id,

923: last_updated_by,
924: last_update_date,
925: last_update_login)
926: VALUES (
927: l_okl_ext_fund_rqns_tl_rec.id,
928: l_okl_ext_fund_rqns_tl_rec.language,
929: l_okl_ext_fund_rqns_tl_rec.source_lang,
930: l_okl_ext_fund_rqns_tl_rec.sfwt_flag,
931: l_okl_ext_fund_rqns_tl_rec.created_by,

Line 928: l_okl_ext_fund_rqns_tl_rec.language,

924: last_update_date,
925: last_update_login)
926: VALUES (
927: l_okl_ext_fund_rqns_tl_rec.id,
928: l_okl_ext_fund_rqns_tl_rec.language,
929: l_okl_ext_fund_rqns_tl_rec.source_lang,
930: l_okl_ext_fund_rqns_tl_rec.sfwt_flag,
931: l_okl_ext_fund_rqns_tl_rec.created_by,
932: l_okl_ext_fund_rqns_tl_rec.creation_date,

Line 929: l_okl_ext_fund_rqns_tl_rec.source_lang,

925: last_update_login)
926: VALUES (
927: l_okl_ext_fund_rqns_tl_rec.id,
928: l_okl_ext_fund_rqns_tl_rec.language,
929: l_okl_ext_fund_rqns_tl_rec.source_lang,
930: l_okl_ext_fund_rqns_tl_rec.sfwt_flag,
931: l_okl_ext_fund_rqns_tl_rec.created_by,
932: l_okl_ext_fund_rqns_tl_rec.creation_date,
933: l_okl_ext_fund_rqns_tl_rec.last_updated_by,

Line 930: l_okl_ext_fund_rqns_tl_rec.sfwt_flag,

926: VALUES (
927: l_okl_ext_fund_rqns_tl_rec.id,
928: l_okl_ext_fund_rqns_tl_rec.language,
929: l_okl_ext_fund_rqns_tl_rec.source_lang,
930: l_okl_ext_fund_rqns_tl_rec.sfwt_flag,
931: l_okl_ext_fund_rqns_tl_rec.created_by,
932: l_okl_ext_fund_rqns_tl_rec.creation_date,
933: l_okl_ext_fund_rqns_tl_rec.last_updated_by,
934: l_okl_ext_fund_rqns_tl_rec.last_update_date,

Line 931: l_okl_ext_fund_rqns_tl_rec.created_by,

927: l_okl_ext_fund_rqns_tl_rec.id,
928: l_okl_ext_fund_rqns_tl_rec.language,
929: l_okl_ext_fund_rqns_tl_rec.source_lang,
930: l_okl_ext_fund_rqns_tl_rec.sfwt_flag,
931: l_okl_ext_fund_rqns_tl_rec.created_by,
932: l_okl_ext_fund_rqns_tl_rec.creation_date,
933: l_okl_ext_fund_rqns_tl_rec.last_updated_by,
934: l_okl_ext_fund_rqns_tl_rec.last_update_date,
935: l_okl_ext_fund_rqns_tl_rec.last_update_login);

Line 932: l_okl_ext_fund_rqns_tl_rec.creation_date,

928: l_okl_ext_fund_rqns_tl_rec.language,
929: l_okl_ext_fund_rqns_tl_rec.source_lang,
930: l_okl_ext_fund_rqns_tl_rec.sfwt_flag,
931: l_okl_ext_fund_rqns_tl_rec.created_by,
932: l_okl_ext_fund_rqns_tl_rec.creation_date,
933: l_okl_ext_fund_rqns_tl_rec.last_updated_by,
934: l_okl_ext_fund_rqns_tl_rec.last_update_date,
935: l_okl_ext_fund_rqns_tl_rec.last_update_login);
936: END LOOP;

Line 933: l_okl_ext_fund_rqns_tl_rec.last_updated_by,

929: l_okl_ext_fund_rqns_tl_rec.source_lang,
930: l_okl_ext_fund_rqns_tl_rec.sfwt_flag,
931: l_okl_ext_fund_rqns_tl_rec.created_by,
932: l_okl_ext_fund_rqns_tl_rec.creation_date,
933: l_okl_ext_fund_rqns_tl_rec.last_updated_by,
934: l_okl_ext_fund_rqns_tl_rec.last_update_date,
935: l_okl_ext_fund_rqns_tl_rec.last_update_login);
936: END LOOP;
937: -- Set OUT values

Line 934: l_okl_ext_fund_rqns_tl_rec.last_update_date,

930: l_okl_ext_fund_rqns_tl_rec.sfwt_flag,
931: l_okl_ext_fund_rqns_tl_rec.created_by,
932: l_okl_ext_fund_rqns_tl_rec.creation_date,
933: l_okl_ext_fund_rqns_tl_rec.last_updated_by,
934: l_okl_ext_fund_rqns_tl_rec.last_update_date,
935: l_okl_ext_fund_rqns_tl_rec.last_update_login);
936: END LOOP;
937: -- Set OUT values
938: x_okl_ext_fund_rqns_tl_rec := l_okl_ext_fund_rqns_tl_rec;

Line 935: l_okl_ext_fund_rqns_tl_rec.last_update_login);

931: l_okl_ext_fund_rqns_tl_rec.created_by,
932: l_okl_ext_fund_rqns_tl_rec.creation_date,
933: l_okl_ext_fund_rqns_tl_rec.last_updated_by,
934: l_okl_ext_fund_rqns_tl_rec.last_update_date,
935: l_okl_ext_fund_rqns_tl_rec.last_update_login);
936: END LOOP;
937: -- Set OUT values
938: x_okl_ext_fund_rqns_tl_rec := l_okl_ext_fund_rqns_tl_rec;
939: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 938: x_okl_ext_fund_rqns_tl_rec := l_okl_ext_fund_rqns_tl_rec;

934: l_okl_ext_fund_rqns_tl_rec.last_update_date,
935: l_okl_ext_fund_rqns_tl_rec.last_update_login);
936: END LOOP;
937: -- Set OUT values
938: x_okl_ext_fund_rqns_tl_rec := l_okl_ext_fund_rqns_tl_rec;
939: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
940: EXCEPTION
941: WHEN OKC_API.G_EXCEPTION_ERROR THEN
942: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 991: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;

987: l_xhrv_rec xhrv_rec_type;
988: l_def_xhrv_rec xhrv_rec_type;
989: l_xhr_rec xhr_rec_type;
990: lx_xhr_rec xhr_rec_type;
991: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
992: lx_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
993: -------------------------------
994: -- FUNCTION fill_who_columns --
995: -------------------------------

Line 992: lx_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;

988: l_def_xhrv_rec xhrv_rec_type;
989: l_xhr_rec xhr_rec_type;
990: lx_xhr_rec xhr_rec_type;
991: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
992: lx_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
993: -------------------------------
994: -- FUNCTION fill_who_columns --
995: -------------------------------
996: FUNCTION fill_who_columns (

Line 1067: migrate(l_def_xhrv_rec, l_okl_ext_fund_rqns_tl_rec);

1063: --------------------------------------
1064: -- Move VIEW record to "Child" records
1065: --------------------------------------
1066: migrate(l_def_xhrv_rec, l_xhr_rec);
1067: migrate(l_def_xhrv_rec, l_okl_ext_fund_rqns_tl_rec);
1068: --------------------------------------------
1069: -- Call the INSERT_ROW for each child record
1070: --------------------------------------------
1071: insert_row(

Line 1090: l_okl_ext_fund_rqns_tl_rec,

1086: p_init_msg_list,
1087: x_return_status,
1088: x_msg_count,
1089: x_msg_data,
1090: l_okl_ext_fund_rqns_tl_rec,
1091: lx_okl_ext_fund_rqns_tl_rec
1092: );
1093: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1094: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1091: lx_okl_ext_fund_rqns_tl_rec

1087: x_return_status,
1088: x_msg_count,
1089: x_msg_data,
1090: l_okl_ext_fund_rqns_tl_rec,
1091: lx_okl_ext_fund_rqns_tl_rec
1092: );
1093: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1094: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1095: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1098: migrate(lx_okl_ext_fund_rqns_tl_rec, l_def_xhrv_rec);

1094: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1095: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1096: RAISE OKC_API.G_EXCEPTION_ERROR;
1097: END IF;
1098: migrate(lx_okl_ext_fund_rqns_tl_rec, l_def_xhrv_rec);
1099: -- Set OUT values
1100: x_xhrv_rec := l_def_xhrv_rec;
1101: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1102: EXCEPTION

Line 1311: -- lock_row for:OKL_EXT_FUND_RQNS_TL --

1307: '_PVT'
1308: );
1309: END lock_row;
1310: ---------------------------------------
1311: -- lock_row for:OKL_EXT_FUND_RQNS_TL --
1312: ---------------------------------------
1313: PROCEDURE lock_row(
1314: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1315: x_return_status OUT NOCOPY VARCHAR2,

Line 1318: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type) IS

1314: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1315: x_return_status OUT NOCOPY VARCHAR2,
1316: x_msg_count OUT NOCOPY NUMBER,
1317: x_msg_data OUT NOCOPY VARCHAR2,
1318: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type) IS
1319:
1320: E_Resource_Busy EXCEPTION;
1321: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1322: CURSOR lock_csr (p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type) IS

Line 1322: CURSOR lock_csr (p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type) IS

1318: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type) IS
1319:
1320: E_Resource_Busy EXCEPTION;
1321: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1322: CURSOR lock_csr (p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type) IS
1323: SELECT *
1324: FROM OKL_EXT_FUND_RQNS_TL
1325: WHERE ID = p_okl_ext_fund_rqns_tl_rec.id
1326: FOR UPDATE NOWAIT;

Line 1324: FROM OKL_EXT_FUND_RQNS_TL

1320: E_Resource_Busy EXCEPTION;
1321: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1322: CURSOR lock_csr (p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type) IS
1323: SELECT *
1324: FROM OKL_EXT_FUND_RQNS_TL
1325: WHERE ID = p_okl_ext_fund_rqns_tl_rec.id
1326: FOR UPDATE NOWAIT;
1327:
1328: l_api_version CONSTANT NUMBER := 1;

Line 1325: WHERE ID = p_okl_ext_fund_rqns_tl_rec.id

1321: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1322: CURSOR lock_csr (p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type) IS
1323: SELECT *
1324: FROM OKL_EXT_FUND_RQNS_TL
1325: WHERE ID = p_okl_ext_fund_rqns_tl_rec.id
1326: FOR UPDATE NOWAIT;
1327:
1328: l_api_version CONSTANT NUMBER := 1;
1329: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1345: OPEN lock_csr(p_okl_ext_fund_rqns_tl_rec);

1341: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1342: RAISE OKC_API.G_EXCEPTION_ERROR;
1343: END IF;
1344: BEGIN
1345: OPEN lock_csr(p_okl_ext_fund_rqns_tl_rec);
1346: FETCH lock_csr INTO l_lock_var;
1347: l_row_notfound := lock_csr%NOTFOUND;
1348: CLOSE lock_csr;
1349: EXCEPTION

Line 1410: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;

1406: l_api_version CONSTANT NUMBER := 1;
1407: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1408: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1409: l_xhr_rec xhr_rec_type;
1410: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
1411: BEGIN
1412: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1413: G_PKG_NAME,
1414: p_init_msg_list,

Line 1428: migrate(p_xhrv_rec, l_okl_ext_fund_rqns_tl_rec);

1424: --------------------------------------
1425: -- Move VIEW record to "Child" records
1426: --------------------------------------
1427: migrate(p_xhrv_rec, l_xhr_rec);
1428: migrate(p_xhrv_rec, l_okl_ext_fund_rqns_tl_rec);
1429: --------------------------------------------
1430: -- Call the LOCK_ROW for each child record
1431: --------------------------------------------
1432: lock_row(

Line 1449: l_okl_ext_fund_rqns_tl_rec

1445: p_init_msg_list,
1446: x_return_status,
1447: x_msg_count,
1448: x_msg_data,
1449: l_okl_ext_fund_rqns_tl_rec
1450: );
1451: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1452: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1453: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1813: -- update_row for:OKL_EXT_FUND_RQNS_TL --

1809: '_PVT'
1810: );
1811: END update_row;
1812: -----------------------------------------
1813: -- update_row for:OKL_EXT_FUND_RQNS_TL --
1814: -----------------------------------------
1815: PROCEDURE update_row(
1816: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1817: x_return_status OUT NOCOPY VARCHAR2,

Line 1820: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,

1816: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1817: x_return_status OUT NOCOPY VARCHAR2,
1818: x_msg_count OUT NOCOPY NUMBER,
1819: x_msg_data OUT NOCOPY VARCHAR2,
1820: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
1821: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type) IS
1822:
1823: l_api_version CONSTANT NUMBER := 1;
1824: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 1821: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type) IS

1817: x_return_status OUT NOCOPY VARCHAR2,
1818: x_msg_count OUT NOCOPY NUMBER,
1819: x_msg_data OUT NOCOPY VARCHAR2,
1820: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
1821: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type) IS
1822:
1823: l_api_version CONSTANT NUMBER := 1;
1824: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
1825: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1826: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type := p_okl_ext_fund_rqns_tl_rec;

1822:
1823: l_api_version CONSTANT NUMBER := 1;
1824: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
1825: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1826: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type := p_okl_ext_fund_rqns_tl_rec;
1827: ldefoklextfundrqnstlrec okl_ext_fund_rqns_tl_rec_type;
1828: l_row_notfound BOOLEAN := TRUE;
1829: ----------------------------------
1830: -- FUNCTION populate_new_record --

Line 1827: ldefoklextfundrqnstlrec okl_ext_fund_rqns_tl_rec_type;

1823: l_api_version CONSTANT NUMBER := 1;
1824: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
1825: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1826: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type := p_okl_ext_fund_rqns_tl_rec;
1827: ldefoklextfundrqnstlrec okl_ext_fund_rqns_tl_rec_type;
1828: l_row_notfound BOOLEAN := TRUE;
1829: ----------------------------------
1830: -- FUNCTION populate_new_record --
1831: ----------------------------------

Line 1833: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,

1829: ----------------------------------
1830: -- FUNCTION populate_new_record --
1831: ----------------------------------
1832: FUNCTION populate_new_record (
1833: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
1834: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type
1835: ) RETURN VARCHAR2 IS
1836: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
1837: l_row_notfound BOOLEAN := TRUE;

Line 1834: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type

1830: -- FUNCTION populate_new_record --
1831: ----------------------------------
1832: FUNCTION populate_new_record (
1833: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
1834: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type
1835: ) RETURN VARCHAR2 IS
1836: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
1837: l_row_notfound BOOLEAN := TRUE;
1838: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1836: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;

1832: FUNCTION populate_new_record (
1833: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
1834: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type
1835: ) RETURN VARCHAR2 IS
1836: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
1837: l_row_notfound BOOLEAN := TRUE;
1838: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1839: BEGIN
1840: x_okl_ext_fund_rqns_tl_rec := p_okl_ext_fund_rqns_tl_rec;

Line 1840: x_okl_ext_fund_rqns_tl_rec := p_okl_ext_fund_rqns_tl_rec;

1836: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
1837: l_row_notfound BOOLEAN := TRUE;
1838: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1839: BEGIN
1840: x_okl_ext_fund_rqns_tl_rec := p_okl_ext_fund_rqns_tl_rec;
1841: -- Get current database values
1842: l_okl_ext_fund_rqns_tl_rec := get_rec(p_okl_ext_fund_rqns_tl_rec, l_row_notfound);
1843: IF (l_row_notfound) THEN
1844: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 1842: l_okl_ext_fund_rqns_tl_rec := get_rec(p_okl_ext_fund_rqns_tl_rec, l_row_notfound);

1838: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1839: BEGIN
1840: x_okl_ext_fund_rqns_tl_rec := p_okl_ext_fund_rqns_tl_rec;
1841: -- Get current database values
1842: l_okl_ext_fund_rqns_tl_rec := get_rec(p_okl_ext_fund_rqns_tl_rec, l_row_notfound);
1843: IF (l_row_notfound) THEN
1844: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1845: END IF;
1846: IF (x_okl_ext_fund_rqns_tl_rec.id = OKC_API.G_MISS_NUM)

Line 1846: IF (x_okl_ext_fund_rqns_tl_rec.id = OKC_API.G_MISS_NUM)

1842: l_okl_ext_fund_rqns_tl_rec := get_rec(p_okl_ext_fund_rqns_tl_rec, l_row_notfound);
1843: IF (l_row_notfound) THEN
1844: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1845: END IF;
1846: IF (x_okl_ext_fund_rqns_tl_rec.id = OKC_API.G_MISS_NUM)
1847: THEN
1848: x_okl_ext_fund_rqns_tl_rec.id := l_okl_ext_fund_rqns_tl_rec.id;
1849: END IF;
1850: IF (x_okl_ext_fund_rqns_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 1848: x_okl_ext_fund_rqns_tl_rec.id := l_okl_ext_fund_rqns_tl_rec.id;

1844: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1845: END IF;
1846: IF (x_okl_ext_fund_rqns_tl_rec.id = OKC_API.G_MISS_NUM)
1847: THEN
1848: x_okl_ext_fund_rqns_tl_rec.id := l_okl_ext_fund_rqns_tl_rec.id;
1849: END IF;
1850: IF (x_okl_ext_fund_rqns_tl_rec.language = OKC_API.G_MISS_CHAR)
1851: THEN
1852: x_okl_ext_fund_rqns_tl_rec.language := l_okl_ext_fund_rqns_tl_rec.language;

Line 1850: IF (x_okl_ext_fund_rqns_tl_rec.language = OKC_API.G_MISS_CHAR)

1846: IF (x_okl_ext_fund_rqns_tl_rec.id = OKC_API.G_MISS_NUM)
1847: THEN
1848: x_okl_ext_fund_rqns_tl_rec.id := l_okl_ext_fund_rqns_tl_rec.id;
1849: END IF;
1850: IF (x_okl_ext_fund_rqns_tl_rec.language = OKC_API.G_MISS_CHAR)
1851: THEN
1852: x_okl_ext_fund_rqns_tl_rec.language := l_okl_ext_fund_rqns_tl_rec.language;
1853: END IF;
1854: IF (x_okl_ext_fund_rqns_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 1852: x_okl_ext_fund_rqns_tl_rec.language := l_okl_ext_fund_rqns_tl_rec.language;

1848: x_okl_ext_fund_rqns_tl_rec.id := l_okl_ext_fund_rqns_tl_rec.id;
1849: END IF;
1850: IF (x_okl_ext_fund_rqns_tl_rec.language = OKC_API.G_MISS_CHAR)
1851: THEN
1852: x_okl_ext_fund_rqns_tl_rec.language := l_okl_ext_fund_rqns_tl_rec.language;
1853: END IF;
1854: IF (x_okl_ext_fund_rqns_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
1855: THEN
1856: x_okl_ext_fund_rqns_tl_rec.source_lang := l_okl_ext_fund_rqns_tl_rec.source_lang;

Line 1854: IF (x_okl_ext_fund_rqns_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

1850: IF (x_okl_ext_fund_rqns_tl_rec.language = OKC_API.G_MISS_CHAR)
1851: THEN
1852: x_okl_ext_fund_rqns_tl_rec.language := l_okl_ext_fund_rqns_tl_rec.language;
1853: END IF;
1854: IF (x_okl_ext_fund_rqns_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
1855: THEN
1856: x_okl_ext_fund_rqns_tl_rec.source_lang := l_okl_ext_fund_rqns_tl_rec.source_lang;
1857: END IF;
1858: IF (x_okl_ext_fund_rqns_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 1856: x_okl_ext_fund_rqns_tl_rec.source_lang := l_okl_ext_fund_rqns_tl_rec.source_lang;

1852: x_okl_ext_fund_rqns_tl_rec.language := l_okl_ext_fund_rqns_tl_rec.language;
1853: END IF;
1854: IF (x_okl_ext_fund_rqns_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
1855: THEN
1856: x_okl_ext_fund_rqns_tl_rec.source_lang := l_okl_ext_fund_rqns_tl_rec.source_lang;
1857: END IF;
1858: IF (x_okl_ext_fund_rqns_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
1859: THEN
1860: x_okl_ext_fund_rqns_tl_rec.sfwt_flag := l_okl_ext_fund_rqns_tl_rec.sfwt_flag;

Line 1858: IF (x_okl_ext_fund_rqns_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

1854: IF (x_okl_ext_fund_rqns_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
1855: THEN
1856: x_okl_ext_fund_rqns_tl_rec.source_lang := l_okl_ext_fund_rqns_tl_rec.source_lang;
1857: END IF;
1858: IF (x_okl_ext_fund_rqns_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
1859: THEN
1860: x_okl_ext_fund_rqns_tl_rec.sfwt_flag := l_okl_ext_fund_rqns_tl_rec.sfwt_flag;
1861: END IF;
1862: IF (x_okl_ext_fund_rqns_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 1860: x_okl_ext_fund_rqns_tl_rec.sfwt_flag := l_okl_ext_fund_rqns_tl_rec.sfwt_flag;

1856: x_okl_ext_fund_rqns_tl_rec.source_lang := l_okl_ext_fund_rqns_tl_rec.source_lang;
1857: END IF;
1858: IF (x_okl_ext_fund_rqns_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
1859: THEN
1860: x_okl_ext_fund_rqns_tl_rec.sfwt_flag := l_okl_ext_fund_rqns_tl_rec.sfwt_flag;
1861: END IF;
1862: IF (x_okl_ext_fund_rqns_tl_rec.created_by = OKC_API.G_MISS_NUM)
1863: THEN
1864: x_okl_ext_fund_rqns_tl_rec.created_by := l_okl_ext_fund_rqns_tl_rec.created_by;

Line 1862: IF (x_okl_ext_fund_rqns_tl_rec.created_by = OKC_API.G_MISS_NUM)

1858: IF (x_okl_ext_fund_rqns_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
1859: THEN
1860: x_okl_ext_fund_rqns_tl_rec.sfwt_flag := l_okl_ext_fund_rqns_tl_rec.sfwt_flag;
1861: END IF;
1862: IF (x_okl_ext_fund_rqns_tl_rec.created_by = OKC_API.G_MISS_NUM)
1863: THEN
1864: x_okl_ext_fund_rqns_tl_rec.created_by := l_okl_ext_fund_rqns_tl_rec.created_by;
1865: END IF;
1866: IF (x_okl_ext_fund_rqns_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1864: x_okl_ext_fund_rqns_tl_rec.created_by := l_okl_ext_fund_rqns_tl_rec.created_by;

1860: x_okl_ext_fund_rqns_tl_rec.sfwt_flag := l_okl_ext_fund_rqns_tl_rec.sfwt_flag;
1861: END IF;
1862: IF (x_okl_ext_fund_rqns_tl_rec.created_by = OKC_API.G_MISS_NUM)
1863: THEN
1864: x_okl_ext_fund_rqns_tl_rec.created_by := l_okl_ext_fund_rqns_tl_rec.created_by;
1865: END IF;
1866: IF (x_okl_ext_fund_rqns_tl_rec.creation_date = OKC_API.G_MISS_DATE)
1867: THEN
1868: x_okl_ext_fund_rqns_tl_rec.creation_date := l_okl_ext_fund_rqns_tl_rec.creation_date;

Line 1866: IF (x_okl_ext_fund_rqns_tl_rec.creation_date = OKC_API.G_MISS_DATE)

1862: IF (x_okl_ext_fund_rqns_tl_rec.created_by = OKC_API.G_MISS_NUM)
1863: THEN
1864: x_okl_ext_fund_rqns_tl_rec.created_by := l_okl_ext_fund_rqns_tl_rec.created_by;
1865: END IF;
1866: IF (x_okl_ext_fund_rqns_tl_rec.creation_date = OKC_API.G_MISS_DATE)
1867: THEN
1868: x_okl_ext_fund_rqns_tl_rec.creation_date := l_okl_ext_fund_rqns_tl_rec.creation_date;
1869: END IF;
1870: IF (x_okl_ext_fund_rqns_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1868: x_okl_ext_fund_rqns_tl_rec.creation_date := l_okl_ext_fund_rqns_tl_rec.creation_date;

1864: x_okl_ext_fund_rqns_tl_rec.created_by := l_okl_ext_fund_rqns_tl_rec.created_by;
1865: END IF;
1866: IF (x_okl_ext_fund_rqns_tl_rec.creation_date = OKC_API.G_MISS_DATE)
1867: THEN
1868: x_okl_ext_fund_rqns_tl_rec.creation_date := l_okl_ext_fund_rqns_tl_rec.creation_date;
1869: END IF;
1870: IF (x_okl_ext_fund_rqns_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
1871: THEN
1872: x_okl_ext_fund_rqns_tl_rec.last_updated_by := l_okl_ext_fund_rqns_tl_rec.last_updated_by;

Line 1870: IF (x_okl_ext_fund_rqns_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

1866: IF (x_okl_ext_fund_rqns_tl_rec.creation_date = OKC_API.G_MISS_DATE)
1867: THEN
1868: x_okl_ext_fund_rqns_tl_rec.creation_date := l_okl_ext_fund_rqns_tl_rec.creation_date;
1869: END IF;
1870: IF (x_okl_ext_fund_rqns_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
1871: THEN
1872: x_okl_ext_fund_rqns_tl_rec.last_updated_by := l_okl_ext_fund_rqns_tl_rec.last_updated_by;
1873: END IF;
1874: IF (x_okl_ext_fund_rqns_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1872: x_okl_ext_fund_rqns_tl_rec.last_updated_by := l_okl_ext_fund_rqns_tl_rec.last_updated_by;

1868: x_okl_ext_fund_rqns_tl_rec.creation_date := l_okl_ext_fund_rqns_tl_rec.creation_date;
1869: END IF;
1870: IF (x_okl_ext_fund_rqns_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
1871: THEN
1872: x_okl_ext_fund_rqns_tl_rec.last_updated_by := l_okl_ext_fund_rqns_tl_rec.last_updated_by;
1873: END IF;
1874: IF (x_okl_ext_fund_rqns_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
1875: THEN
1876: x_okl_ext_fund_rqns_tl_rec.last_update_date := l_okl_ext_fund_rqns_tl_rec.last_update_date;

Line 1874: IF (x_okl_ext_fund_rqns_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

1870: IF (x_okl_ext_fund_rqns_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
1871: THEN
1872: x_okl_ext_fund_rqns_tl_rec.last_updated_by := l_okl_ext_fund_rqns_tl_rec.last_updated_by;
1873: END IF;
1874: IF (x_okl_ext_fund_rqns_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
1875: THEN
1876: x_okl_ext_fund_rqns_tl_rec.last_update_date := l_okl_ext_fund_rqns_tl_rec.last_update_date;
1877: END IF;
1878: IF (x_okl_ext_fund_rqns_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1876: x_okl_ext_fund_rqns_tl_rec.last_update_date := l_okl_ext_fund_rqns_tl_rec.last_update_date;

1872: x_okl_ext_fund_rqns_tl_rec.last_updated_by := l_okl_ext_fund_rqns_tl_rec.last_updated_by;
1873: END IF;
1874: IF (x_okl_ext_fund_rqns_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
1875: THEN
1876: x_okl_ext_fund_rqns_tl_rec.last_update_date := l_okl_ext_fund_rqns_tl_rec.last_update_date;
1877: END IF;
1878: IF (x_okl_ext_fund_rqns_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
1879: THEN
1880: x_okl_ext_fund_rqns_tl_rec.last_update_login := l_okl_ext_fund_rqns_tl_rec.last_update_login;

Line 1878: IF (x_okl_ext_fund_rqns_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

1874: IF (x_okl_ext_fund_rqns_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
1875: THEN
1876: x_okl_ext_fund_rqns_tl_rec.last_update_date := l_okl_ext_fund_rqns_tl_rec.last_update_date;
1877: END IF;
1878: IF (x_okl_ext_fund_rqns_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
1879: THEN
1880: x_okl_ext_fund_rqns_tl_rec.last_update_login := l_okl_ext_fund_rqns_tl_rec.last_update_login;
1881: END IF;
1882: RETURN(l_return_status);

Line 1880: x_okl_ext_fund_rqns_tl_rec.last_update_login := l_okl_ext_fund_rqns_tl_rec.last_update_login;

1876: x_okl_ext_fund_rqns_tl_rec.last_update_date := l_okl_ext_fund_rqns_tl_rec.last_update_date;
1877: END IF;
1878: IF (x_okl_ext_fund_rqns_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
1879: THEN
1880: x_okl_ext_fund_rqns_tl_rec.last_update_login := l_okl_ext_fund_rqns_tl_rec.last_update_login;
1881: END IF;
1882: RETURN(l_return_status);
1883: END populate_new_record;
1884: ---------------------------------------------

Line 1885: -- Set_Attributes for:OKL_EXT_FUND_RQNS_TL --

1881: END IF;
1882: RETURN(l_return_status);
1883: END populate_new_record;
1884: ---------------------------------------------
1885: -- Set_Attributes for:OKL_EXT_FUND_RQNS_TL --
1886: ---------------------------------------------
1887: FUNCTION Set_Attributes (
1888: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
1889: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type

Line 1888: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,

1884: ---------------------------------------------
1885: -- Set_Attributes for:OKL_EXT_FUND_RQNS_TL --
1886: ---------------------------------------------
1887: FUNCTION Set_Attributes (
1888: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
1889: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type
1890: ) RETURN VARCHAR2 IS
1891: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1892: BEGIN

Line 1889: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type

1885: -- Set_Attributes for:OKL_EXT_FUND_RQNS_TL --
1886: ---------------------------------------------
1887: FUNCTION Set_Attributes (
1888: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
1889: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type
1890: ) RETURN VARCHAR2 IS
1891: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1892: BEGIN
1893: x_okl_ext_fund_rqns_tl_rec := p_okl_ext_fund_rqns_tl_rec;

Line 1893: x_okl_ext_fund_rqns_tl_rec := p_okl_ext_fund_rqns_tl_rec;

1889: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type
1890: ) RETURN VARCHAR2 IS
1891: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1892: BEGIN
1893: x_okl_ext_fund_rqns_tl_rec := p_okl_ext_fund_rqns_tl_rec;
1894: x_okl_ext_fund_rqns_tl_rec.LANGUAGE := USERENV('LANG');
1895: x_okl_ext_fund_rqns_tl_rec.SOURCE_LANG := USERENV('LANG');
1896: RETURN(l_return_status);
1897: END Set_Attributes;

Line 1894: x_okl_ext_fund_rqns_tl_rec.LANGUAGE := USERENV('LANG');

1890: ) RETURN VARCHAR2 IS
1891: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1892: BEGIN
1893: x_okl_ext_fund_rqns_tl_rec := p_okl_ext_fund_rqns_tl_rec;
1894: x_okl_ext_fund_rqns_tl_rec.LANGUAGE := USERENV('LANG');
1895: x_okl_ext_fund_rqns_tl_rec.SOURCE_LANG := USERENV('LANG');
1896: RETURN(l_return_status);
1897: END Set_Attributes;
1898: BEGIN

Line 1895: x_okl_ext_fund_rqns_tl_rec.SOURCE_LANG := USERENV('LANG');

1891: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1892: BEGIN
1893: x_okl_ext_fund_rqns_tl_rec := p_okl_ext_fund_rqns_tl_rec;
1894: x_okl_ext_fund_rqns_tl_rec.LANGUAGE := USERENV('LANG');
1895: x_okl_ext_fund_rqns_tl_rec.SOURCE_LANG := USERENV('LANG');
1896: RETURN(l_return_status);
1897: END Set_Attributes;
1898: BEGIN
1899: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1910: p_okl_ext_fund_rqns_tl_rec, -- IN

1906: RAISE OKC_API.G_EXCEPTION_ERROR;
1907: END IF;
1908: --- Setting item attributes
1909: l_return_status := Set_Attributes(
1910: p_okl_ext_fund_rqns_tl_rec, -- IN
1911: l_okl_ext_fund_rqns_tl_rec); -- OUT
1912: --- If any errors happen abort API
1913: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1914: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1911: l_okl_ext_fund_rqns_tl_rec); -- OUT

1907: END IF;
1908: --- Setting item attributes
1909: l_return_status := Set_Attributes(
1910: p_okl_ext_fund_rqns_tl_rec, -- IN
1911: l_okl_ext_fund_rqns_tl_rec); -- OUT
1912: --- If any errors happen abort API
1913: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1914: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1915: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1918: l_return_status := populate_new_record(l_okl_ext_fund_rqns_tl_rec, ldefoklextfundrqnstlrec);

1914: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1915: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1916: RAISE OKC_API.G_EXCEPTION_ERROR;
1917: END IF;
1918: l_return_status := populate_new_record(l_okl_ext_fund_rqns_tl_rec, ldefoklextfundrqnstlrec);
1919: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1920: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1921: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1922: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1924: UPDATE OKL_EXT_FUND_RQNS_TL

1920: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1921: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1922: RAISE OKC_API.G_EXCEPTION_ERROR;
1923: END IF;
1924: UPDATE OKL_EXT_FUND_RQNS_TL
1925: SET SOURCE_LANG = ldefoklextfundrqnstlrec.source_lang,
1926: CREATED_BY = ldefoklextfundrqnstlrec.created_by,
1927: CREATION_DATE = ldefoklextfundrqnstlrec.creation_date,
1928: LAST_UPDATED_BY = ldefoklextfundrqnstlrec.last_updated_by,

Line 1934: UPDATE OKL_EXT_FUND_RQNS_TL

1930: LAST_UPDATE_LOGIN = ldefoklextfundrqnstlrec.last_update_login
1931: WHERE ID = ldefoklextfundrqnstlrec.id
1932: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
1933:
1934: UPDATE OKL_EXT_FUND_RQNS_TL
1935: SET SFWT_FLAG = 'Y'
1936: WHERE ID = ldefoklextfundrqnstlrec.id
1937: AND SOURCE_LANG <> USERENV('LANG');
1938:

Line 1939: x_okl_ext_fund_rqns_tl_rec := ldefoklextfundrqnstlrec;

1935: SET SFWT_FLAG = 'Y'
1936: WHERE ID = ldefoklextfundrqnstlrec.id
1937: AND SOURCE_LANG <> USERENV('LANG');
1938:
1939: x_okl_ext_fund_rqns_tl_rec := ldefoklextfundrqnstlrec;
1940: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1941: EXCEPTION
1942: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1943: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1990: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;

1986: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1987: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1988: l_xhrv_rec xhrv_rec_type := p_xhrv_rec;
1989: l_def_xhrv_rec xhrv_rec_type;
1990: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
1991: lx_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
1992: l_xhr_rec xhr_rec_type;
1993: lx_xhr_rec xhr_rec_type;
1994: -------------------------------

Line 1991: lx_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;

1987: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1988: l_xhrv_rec xhrv_rec_type := p_xhrv_rec;
1989: l_def_xhrv_rec xhrv_rec_type;
1990: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
1991: lx_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
1992: l_xhr_rec xhr_rec_type;
1993: lx_xhr_rec xhr_rec_type;
1994: -------------------------------
1995: -- FUNCTION fill_who_columns --

Line 2207: migrate(l_def_xhrv_rec, l_okl_ext_fund_rqns_tl_rec);

2203:
2204: --------------------------------------
2205: -- Move VIEW record to "Child" records
2206: --------------------------------------
2207: migrate(l_def_xhrv_rec, l_okl_ext_fund_rqns_tl_rec);
2208: migrate(l_def_xhrv_rec, l_xhr_rec);
2209: --------------------------------------------
2210: -- Call the UPDATE_ROW for each child record
2211: --------------------------------------------

Line 2217: l_okl_ext_fund_rqns_tl_rec,

2213: p_init_msg_list,
2214: x_return_status,
2215: x_msg_count,
2216: x_msg_data,
2217: l_okl_ext_fund_rqns_tl_rec,
2218: lx_okl_ext_fund_rqns_tl_rec
2219: );
2220: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2221: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2218: lx_okl_ext_fund_rqns_tl_rec

2214: x_return_status,
2215: x_msg_count,
2216: x_msg_data,
2217: l_okl_ext_fund_rqns_tl_rec,
2218: lx_okl_ext_fund_rqns_tl_rec
2219: );
2220: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2221: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2222: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2225: migrate(lx_okl_ext_fund_rqns_tl_rec, l_def_xhrv_rec);

2221: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2222: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2223: RAISE OKC_API.G_EXCEPTION_ERROR;
2224: END IF;
2225: migrate(lx_okl_ext_fund_rqns_tl_rec, l_def_xhrv_rec);
2226: update_row(
2227: p_init_msg_list,
2228: x_return_status,
2229: x_msg_count,

Line 2406: -- delete_row for:OKL_EXT_FUND_RQNS_TL --

2402: '_PVT'
2403: );
2404: END delete_row;
2405: -----------------------------------------
2406: -- delete_row for:OKL_EXT_FUND_RQNS_TL --
2407: -----------------------------------------
2408: PROCEDURE delete_row(
2409: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2410: x_return_status OUT NOCOPY VARCHAR2,

Line 2413: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type) IS

2409: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2410: x_return_status OUT NOCOPY VARCHAR2,
2411: x_msg_count OUT NOCOPY NUMBER,
2412: x_msg_data OUT NOCOPY VARCHAR2,
2413: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type) IS
2414:
2415: l_api_version CONSTANT NUMBER := 1;
2416: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2417: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2418: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type:= p_okl_ext_fund_rqns_tl_rec;

2414:
2415: l_api_version CONSTANT NUMBER := 1;
2416: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2417: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2418: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type:= p_okl_ext_fund_rqns_tl_rec;
2419: l_row_notfound BOOLEAN := TRUE;
2420: ---------------------------------------------
2421: -- Set_Attributes for:OKL_EXT_FUND_RQNS_TL --
2422: ---------------------------------------------

Line 2421: -- Set_Attributes for:OKL_EXT_FUND_RQNS_TL --

2417: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2418: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type:= p_okl_ext_fund_rqns_tl_rec;
2419: l_row_notfound BOOLEAN := TRUE;
2420: ---------------------------------------------
2421: -- Set_Attributes for:OKL_EXT_FUND_RQNS_TL --
2422: ---------------------------------------------
2423: FUNCTION Set_Attributes (
2424: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
2425: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type

Line 2424: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,

2420: ---------------------------------------------
2421: -- Set_Attributes for:OKL_EXT_FUND_RQNS_TL --
2422: ---------------------------------------------
2423: FUNCTION Set_Attributes (
2424: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
2425: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type
2426: ) RETURN VARCHAR2 IS
2427: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2428: BEGIN

Line 2425: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type

2421: -- Set_Attributes for:OKL_EXT_FUND_RQNS_TL --
2422: ---------------------------------------------
2423: FUNCTION Set_Attributes (
2424: p_okl_ext_fund_rqns_tl_rec IN okl_ext_fund_rqns_tl_rec_type,
2425: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type
2426: ) RETURN VARCHAR2 IS
2427: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2428: BEGIN
2429: x_okl_ext_fund_rqns_tl_rec := p_okl_ext_fund_rqns_tl_rec;

Line 2429: x_okl_ext_fund_rqns_tl_rec := p_okl_ext_fund_rqns_tl_rec;

2425: x_okl_ext_fund_rqns_tl_rec OUT NOCOPY okl_ext_fund_rqns_tl_rec_type
2426: ) RETURN VARCHAR2 IS
2427: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2428: BEGIN
2429: x_okl_ext_fund_rqns_tl_rec := p_okl_ext_fund_rqns_tl_rec;
2430: x_okl_ext_fund_rqns_tl_rec.LANGUAGE := USERENV('LANG');
2431: RETURN(l_return_status);
2432: END Set_Attributes;
2433: BEGIN

Line 2430: x_okl_ext_fund_rqns_tl_rec.LANGUAGE := USERENV('LANG');

2426: ) RETURN VARCHAR2 IS
2427: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2428: BEGIN
2429: x_okl_ext_fund_rqns_tl_rec := p_okl_ext_fund_rqns_tl_rec;
2430: x_okl_ext_fund_rqns_tl_rec.LANGUAGE := USERENV('LANG');
2431: RETURN(l_return_status);
2432: END Set_Attributes;
2433: BEGIN
2434: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2445: p_okl_ext_fund_rqns_tl_rec, -- IN

2441: RAISE OKC_API.G_EXCEPTION_ERROR;
2442: END IF;
2443: --- Setting item attributes
2444: l_return_status := Set_Attributes(
2445: p_okl_ext_fund_rqns_tl_rec, -- IN
2446: l_okl_ext_fund_rqns_tl_rec); -- OUT
2447: --- If any errors happen abort API
2448: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2449: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2446: l_okl_ext_fund_rqns_tl_rec); -- OUT

2442: END IF;
2443: --- Setting item attributes
2444: l_return_status := Set_Attributes(
2445: p_okl_ext_fund_rqns_tl_rec, -- IN
2446: l_okl_ext_fund_rqns_tl_rec); -- OUT
2447: --- If any errors happen abort API
2448: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2449: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2450: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2453: DELETE FROM OKL_EXT_FUND_RQNS_TL

2449: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2450: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2451: RAISE OKC_API.G_EXCEPTION_ERROR;
2452: END IF;
2453: DELETE FROM OKL_EXT_FUND_RQNS_TL
2454: WHERE ID = l_okl_ext_fund_rqns_tl_rec.id;
2455:
2456: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2457: EXCEPTION

Line 2454: WHERE ID = l_okl_ext_fund_rqns_tl_rec.id;

2450: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2451: RAISE OKC_API.G_EXCEPTION_ERROR;
2452: END IF;
2453: DELETE FROM OKL_EXT_FUND_RQNS_TL
2454: WHERE ID = l_okl_ext_fund_rqns_tl_rec.id;
2455:
2456: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2457: EXCEPTION
2458: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2504: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;

2500: l_api_version CONSTANT NUMBER := 1;
2501: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2502: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2503: l_xhrv_rec xhrv_rec_type := p_xhrv_rec;
2504: l_okl_ext_fund_rqns_tl_rec okl_ext_fund_rqns_tl_rec_type;
2505: l_xhr_rec xhr_rec_type;
2506: BEGIN
2507: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2508: G_PKG_NAME,

Line 2522: migrate(l_xhrv_rec, l_okl_ext_fund_rqns_tl_rec);

2518: END IF;
2519: --------------------------------------
2520: -- Move VIEW record to "Child" records
2521: --------------------------------------
2522: migrate(l_xhrv_rec, l_okl_ext_fund_rqns_tl_rec);
2523: migrate(l_xhrv_rec, l_xhr_rec);
2524: --------------------------------------------
2525: -- Call the DELETE_ROW for each child record
2526: --------------------------------------------

Line 2532: l_okl_ext_fund_rqns_tl_rec

2528: p_init_msg_list,
2529: x_return_status,
2530: x_msg_count,
2531: x_msg_data,
2532: l_okl_ext_fund_rqns_tl_rec
2533: );
2534: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2535: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2536: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN