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_TRY_PVT dependencies on OKL_TRX_TYPES_TL

Line 40: delete from OKL_TRX_TYPES_TL T

36: -- PROCEDURE add_language
37: ---------------------------------------------------------------------------
38: procedure add_language is
39: begin
40: delete from OKL_TRX_TYPES_TL T
41: where not exists (
42: select null
43: from OKL_TRX_TYPES_B B --fixed bug 3321017 by kmotepal
44: where B.ID = T.ID

Line 47: update OKL_TRX_TYPES_TL T set (

43: from OKL_TRX_TYPES_B B --fixed bug 3321017 by kmotepal
44: where B.ID = T.ID
45: );
46:
47: update OKL_TRX_TYPES_TL T set (
48: name,
49: DESCRIPTION,
50: CONTRACT_HEADER_LINE_FLAG,
51: TRANSACTION_HEADER_LINE_DETAIL) = (select

Line 56: from OKL_TRX_TYPES_TL B

52: B.name,
53: B.DESCRIPTION,
54: B.CONTRACT_HEADER_LINE_FLAG,
55: B.TRANSACTION_HEADER_LINE_DETAIL
56: from OKL_TRX_TYPES_TL B
57: where B.ID = T.ID
58: and B.language = T.SOURCE_LANG)
59: where (
60: T.ID,

Line 65: from OKL_TRX_TYPES_TL SUBB, OKL_TRX_TYPES_TL SUBT

61: T.language)
62: in (select
63: SUBT.ID,
64: SUBT.language
65: from OKL_TRX_TYPES_TL SUBB, OKL_TRX_TYPES_TL SUBT
66: where SUBB.ID = SUBT.ID
67: and SUBB.language = SUBT.SOURCE_LANG
68: and (SUBB.name <> SUBT.name
69: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 76: insert into OKL_TRX_TYPES_TL (

72: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
73: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
74: ));
75:
76: insert into OKL_TRX_TYPES_TL (
77: ID,
78: language,
79: SOURCE_LANG,
80: SFWT_FLAG,

Line 104: from OKL_TRX_TYPES_TL B, FND_LANGUAGES L

100: B.CREATION_DATE,
101: B.LAST_UPDATED_BY,
102: B.LAST_UPDATE_DATE,
103: B.LAST_UPDATE_LOGIN
104: from OKL_TRX_TYPES_TL B, FND_LANGUAGES L
105: where L.INSTALLED_FLAG in ('I', 'B')
106: and B.language = USERENV('LANG')
107: and not exists(
108: select null

Line 109: from OKL_TRX_TYPES_TL T

105: where L.INSTALLED_FLAG in ('I', 'B')
106: and B.language = USERENV('LANG')
107: and not exists(
108: select null
109: from OKL_TRX_TYPES_TL T
110: where T.ID = B.ID
111: and T.language = L.LANGUAGE_CODE
112: );
113:

Line 193: -- FUNCTION get_rec for: OKL_TRX_TYPES_TL

189: begin
190: return(get_rec(p_try_rec, l_row_notfound));
191: end get_rec;
192: ---------------------------------------------------------------------------
193: -- FUNCTION get_rec for: OKL_TRX_TYPES_TL
194: ---------------------------------------------------------------------------
195: function get_rec (
196: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
197: x_no_data_found out NOCOPY boolean

Line 196: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,

192: ---------------------------------------------------------------------------
193: -- FUNCTION get_rec for: OKL_TRX_TYPES_TL
194: ---------------------------------------------------------------------------
195: function get_rec (
196: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
197: x_no_data_found out NOCOPY boolean
198: ) return okl_trx_types_tl_rec_type is
199: cursor okl_trx_types_tl_pk_csr (p_id in number,
200: p_language in varchar2) is

Line 198: ) return okl_trx_types_tl_rec_type is

194: ---------------------------------------------------------------------------
195: function get_rec (
196: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
197: x_no_data_found out NOCOPY boolean
198: ) return okl_trx_types_tl_rec_type is
199: cursor okl_trx_types_tl_pk_csr (p_id in number,
200: p_language in varchar2) is
201: select
202: ID,

Line 199: cursor okl_trx_types_tl_pk_csr (p_id in number,

195: function get_rec (
196: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
197: x_no_data_found out NOCOPY boolean
198: ) return okl_trx_types_tl_rec_type is
199: cursor okl_trx_types_tl_pk_csr (p_id in number,
200: p_language in varchar2) is
201: select
202: ID,
203: language,

Line 215: from Okl_Trx_Types_Tl

211: CREATION_DATE,
212: LAST_UPDATED_BY,
213: LAST_UPDATE_DATE,
214: LAST_UPDATE_LOGIN
215: from Okl_Trx_Types_Tl
216: where okl_trx_types_tl.id = p_id
217: and okl_trx_types_tl.language = p_language;
218: l_okl_trx_types_tl_pk okl_trx_types_tl_pk_csr%rowtype;
219: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;

Line 216: where okl_trx_types_tl.id = p_id

212: LAST_UPDATED_BY,
213: LAST_UPDATE_DATE,
214: LAST_UPDATE_LOGIN
215: from Okl_Trx_Types_Tl
216: where okl_trx_types_tl.id = p_id
217: and okl_trx_types_tl.language = p_language;
218: l_okl_trx_types_tl_pk okl_trx_types_tl_pk_csr%rowtype;
219: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
220: begin

Line 217: and okl_trx_types_tl.language = p_language;

213: LAST_UPDATE_DATE,
214: LAST_UPDATE_LOGIN
215: from Okl_Trx_Types_Tl
216: where okl_trx_types_tl.id = p_id
217: and okl_trx_types_tl.language = p_language;
218: l_okl_trx_types_tl_pk okl_trx_types_tl_pk_csr%rowtype;
219: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
220: begin
221: x_no_data_found := true;

Line 218: l_okl_trx_types_tl_pk okl_trx_types_tl_pk_csr%rowtype;

214: LAST_UPDATE_LOGIN
215: from Okl_Trx_Types_Tl
216: where okl_trx_types_tl.id = p_id
217: and okl_trx_types_tl.language = p_language;
218: l_okl_trx_types_tl_pk okl_trx_types_tl_pk_csr%rowtype;
219: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
220: begin
221: x_no_data_found := true;
222: -- Get current database values

Line 219: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;

215: from Okl_Trx_Types_Tl
216: where okl_trx_types_tl.id = p_id
217: and okl_trx_types_tl.language = p_language;
218: l_okl_trx_types_tl_pk okl_trx_types_tl_pk_csr%rowtype;
219: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
220: begin
221: x_no_data_found := true;
222: -- Get current database values
223: open okl_trx_types_tl_pk_csr (p_okl_trx_types_tl_rec.id,

Line 223: open okl_trx_types_tl_pk_csr (p_okl_trx_types_tl_rec.id,

219: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
220: begin
221: x_no_data_found := true;
222: -- Get current database values
223: open okl_trx_types_tl_pk_csr (p_okl_trx_types_tl_rec.id,
224: p_okl_trx_types_tl_rec.language);
225: fetch okl_trx_types_tl_pk_csr into
226: l_okl_trx_types_tl_rec.ID,
227: l_okl_trx_types_tl_rec.language,

Line 224: p_okl_trx_types_tl_rec.language);

220: begin
221: x_no_data_found := true;
222: -- Get current database values
223: open okl_trx_types_tl_pk_csr (p_okl_trx_types_tl_rec.id,
224: p_okl_trx_types_tl_rec.language);
225: fetch okl_trx_types_tl_pk_csr into
226: l_okl_trx_types_tl_rec.ID,
227: l_okl_trx_types_tl_rec.language,
228: l_okl_trx_types_tl_rec.SOURCE_LANG,

Line 225: fetch okl_trx_types_tl_pk_csr into

221: x_no_data_found := true;
222: -- Get current database values
223: open okl_trx_types_tl_pk_csr (p_okl_trx_types_tl_rec.id,
224: p_okl_trx_types_tl_rec.language);
225: fetch okl_trx_types_tl_pk_csr into
226: l_okl_trx_types_tl_rec.ID,
227: l_okl_trx_types_tl_rec.language,
228: l_okl_trx_types_tl_rec.SOURCE_LANG,
229: l_okl_trx_types_tl_rec.SFWT_FLAG,

Line 226: l_okl_trx_types_tl_rec.ID,

222: -- Get current database values
223: open okl_trx_types_tl_pk_csr (p_okl_trx_types_tl_rec.id,
224: p_okl_trx_types_tl_rec.language);
225: fetch okl_trx_types_tl_pk_csr into
226: l_okl_trx_types_tl_rec.ID,
227: l_okl_trx_types_tl_rec.language,
228: l_okl_trx_types_tl_rec.SOURCE_LANG,
229: l_okl_trx_types_tl_rec.SFWT_FLAG,
230: l_okl_trx_types_tl_rec.name,

Line 227: l_okl_trx_types_tl_rec.language,

223: open okl_trx_types_tl_pk_csr (p_okl_trx_types_tl_rec.id,
224: p_okl_trx_types_tl_rec.language);
225: fetch okl_trx_types_tl_pk_csr into
226: l_okl_trx_types_tl_rec.ID,
227: l_okl_trx_types_tl_rec.language,
228: l_okl_trx_types_tl_rec.SOURCE_LANG,
229: l_okl_trx_types_tl_rec.SFWT_FLAG,
230: l_okl_trx_types_tl_rec.name,
231: l_okl_trx_types_tl_rec.DESCRIPTION,

Line 228: l_okl_trx_types_tl_rec.SOURCE_LANG,

224: p_okl_trx_types_tl_rec.language);
225: fetch okl_trx_types_tl_pk_csr into
226: l_okl_trx_types_tl_rec.ID,
227: l_okl_trx_types_tl_rec.language,
228: l_okl_trx_types_tl_rec.SOURCE_LANG,
229: l_okl_trx_types_tl_rec.SFWT_FLAG,
230: l_okl_trx_types_tl_rec.name,
231: l_okl_trx_types_tl_rec.DESCRIPTION,
232: l_okl_trx_types_tl_rec.CONTRACT_HEADER_LINE_FLAG,

Line 229: l_okl_trx_types_tl_rec.SFWT_FLAG,

225: fetch okl_trx_types_tl_pk_csr into
226: l_okl_trx_types_tl_rec.ID,
227: l_okl_trx_types_tl_rec.language,
228: l_okl_trx_types_tl_rec.SOURCE_LANG,
229: l_okl_trx_types_tl_rec.SFWT_FLAG,
230: l_okl_trx_types_tl_rec.name,
231: l_okl_trx_types_tl_rec.DESCRIPTION,
232: l_okl_trx_types_tl_rec.CONTRACT_HEADER_LINE_FLAG,
233: l_okl_trx_types_tl_rec.TRANSACTION_HEADER_LINE_DETAIL,

Line 230: l_okl_trx_types_tl_rec.name,

226: l_okl_trx_types_tl_rec.ID,
227: l_okl_trx_types_tl_rec.language,
228: l_okl_trx_types_tl_rec.SOURCE_LANG,
229: l_okl_trx_types_tl_rec.SFWT_FLAG,
230: l_okl_trx_types_tl_rec.name,
231: l_okl_trx_types_tl_rec.DESCRIPTION,
232: l_okl_trx_types_tl_rec.CONTRACT_HEADER_LINE_FLAG,
233: l_okl_trx_types_tl_rec.TRANSACTION_HEADER_LINE_DETAIL,
234: l_okl_trx_types_tl_rec.CREATED_BY,

Line 231: l_okl_trx_types_tl_rec.DESCRIPTION,

227: l_okl_trx_types_tl_rec.language,
228: l_okl_trx_types_tl_rec.SOURCE_LANG,
229: l_okl_trx_types_tl_rec.SFWT_FLAG,
230: l_okl_trx_types_tl_rec.name,
231: l_okl_trx_types_tl_rec.DESCRIPTION,
232: l_okl_trx_types_tl_rec.CONTRACT_HEADER_LINE_FLAG,
233: l_okl_trx_types_tl_rec.TRANSACTION_HEADER_LINE_DETAIL,
234: l_okl_trx_types_tl_rec.CREATED_BY,
235: l_okl_trx_types_tl_rec.CREATION_DATE,

Line 232: l_okl_trx_types_tl_rec.CONTRACT_HEADER_LINE_FLAG,

228: l_okl_trx_types_tl_rec.SOURCE_LANG,
229: l_okl_trx_types_tl_rec.SFWT_FLAG,
230: l_okl_trx_types_tl_rec.name,
231: l_okl_trx_types_tl_rec.DESCRIPTION,
232: l_okl_trx_types_tl_rec.CONTRACT_HEADER_LINE_FLAG,
233: l_okl_trx_types_tl_rec.TRANSACTION_HEADER_LINE_DETAIL,
234: l_okl_trx_types_tl_rec.CREATED_BY,
235: l_okl_trx_types_tl_rec.CREATION_DATE,
236: l_okl_trx_types_tl_rec.LAST_UPDATED_BY,

Line 233: l_okl_trx_types_tl_rec.TRANSACTION_HEADER_LINE_DETAIL,

229: l_okl_trx_types_tl_rec.SFWT_FLAG,
230: l_okl_trx_types_tl_rec.name,
231: l_okl_trx_types_tl_rec.DESCRIPTION,
232: l_okl_trx_types_tl_rec.CONTRACT_HEADER_LINE_FLAG,
233: l_okl_trx_types_tl_rec.TRANSACTION_HEADER_LINE_DETAIL,
234: l_okl_trx_types_tl_rec.CREATED_BY,
235: l_okl_trx_types_tl_rec.CREATION_DATE,
236: l_okl_trx_types_tl_rec.LAST_UPDATED_BY,
237: l_okl_trx_types_tl_rec.LAST_UPDATE_DATE,

Line 234: l_okl_trx_types_tl_rec.CREATED_BY,

230: l_okl_trx_types_tl_rec.name,
231: l_okl_trx_types_tl_rec.DESCRIPTION,
232: l_okl_trx_types_tl_rec.CONTRACT_HEADER_LINE_FLAG,
233: l_okl_trx_types_tl_rec.TRANSACTION_HEADER_LINE_DETAIL,
234: l_okl_trx_types_tl_rec.CREATED_BY,
235: l_okl_trx_types_tl_rec.CREATION_DATE,
236: l_okl_trx_types_tl_rec.LAST_UPDATED_BY,
237: l_okl_trx_types_tl_rec.LAST_UPDATE_DATE,
238: l_okl_trx_types_tl_rec.LAST_UPDATE_LOGIN;

Line 235: l_okl_trx_types_tl_rec.CREATION_DATE,

231: l_okl_trx_types_tl_rec.DESCRIPTION,
232: l_okl_trx_types_tl_rec.CONTRACT_HEADER_LINE_FLAG,
233: l_okl_trx_types_tl_rec.TRANSACTION_HEADER_LINE_DETAIL,
234: l_okl_trx_types_tl_rec.CREATED_BY,
235: l_okl_trx_types_tl_rec.CREATION_DATE,
236: l_okl_trx_types_tl_rec.LAST_UPDATED_BY,
237: l_okl_trx_types_tl_rec.LAST_UPDATE_DATE,
238: l_okl_trx_types_tl_rec.LAST_UPDATE_LOGIN;
239: x_no_data_found := okl_trx_types_tl_pk_csr%notfound;

Line 236: l_okl_trx_types_tl_rec.LAST_UPDATED_BY,

232: l_okl_trx_types_tl_rec.CONTRACT_HEADER_LINE_FLAG,
233: l_okl_trx_types_tl_rec.TRANSACTION_HEADER_LINE_DETAIL,
234: l_okl_trx_types_tl_rec.CREATED_BY,
235: l_okl_trx_types_tl_rec.CREATION_DATE,
236: l_okl_trx_types_tl_rec.LAST_UPDATED_BY,
237: l_okl_trx_types_tl_rec.LAST_UPDATE_DATE,
238: l_okl_trx_types_tl_rec.LAST_UPDATE_LOGIN;
239: x_no_data_found := okl_trx_types_tl_pk_csr%notfound;
240: close okl_trx_types_tl_pk_csr;

Line 237: l_okl_trx_types_tl_rec.LAST_UPDATE_DATE,

233: l_okl_trx_types_tl_rec.TRANSACTION_HEADER_LINE_DETAIL,
234: l_okl_trx_types_tl_rec.CREATED_BY,
235: l_okl_trx_types_tl_rec.CREATION_DATE,
236: l_okl_trx_types_tl_rec.LAST_UPDATED_BY,
237: l_okl_trx_types_tl_rec.LAST_UPDATE_DATE,
238: l_okl_trx_types_tl_rec.LAST_UPDATE_LOGIN;
239: x_no_data_found := okl_trx_types_tl_pk_csr%notfound;
240: close okl_trx_types_tl_pk_csr;
241: return(l_okl_trx_types_tl_rec);

Line 238: l_okl_trx_types_tl_rec.LAST_UPDATE_LOGIN;

234: l_okl_trx_types_tl_rec.CREATED_BY,
235: l_okl_trx_types_tl_rec.CREATION_DATE,
236: l_okl_trx_types_tl_rec.LAST_UPDATED_BY,
237: l_okl_trx_types_tl_rec.LAST_UPDATE_DATE,
238: l_okl_trx_types_tl_rec.LAST_UPDATE_LOGIN;
239: x_no_data_found := okl_trx_types_tl_pk_csr%notfound;
240: close okl_trx_types_tl_pk_csr;
241: return(l_okl_trx_types_tl_rec);
242: end get_rec;

Line 239: x_no_data_found := okl_trx_types_tl_pk_csr%notfound;

235: l_okl_trx_types_tl_rec.CREATION_DATE,
236: l_okl_trx_types_tl_rec.LAST_UPDATED_BY,
237: l_okl_trx_types_tl_rec.LAST_UPDATE_DATE,
238: l_okl_trx_types_tl_rec.LAST_UPDATE_LOGIN;
239: x_no_data_found := okl_trx_types_tl_pk_csr%notfound;
240: close okl_trx_types_tl_pk_csr;
241: return(l_okl_trx_types_tl_rec);
242: end get_rec;
243:

Line 240: close okl_trx_types_tl_pk_csr;

236: l_okl_trx_types_tl_rec.LAST_UPDATED_BY,
237: l_okl_trx_types_tl_rec.LAST_UPDATE_DATE,
238: l_okl_trx_types_tl_rec.LAST_UPDATE_LOGIN;
239: x_no_data_found := okl_trx_types_tl_pk_csr%notfound;
240: close okl_trx_types_tl_pk_csr;
241: return(l_okl_trx_types_tl_rec);
242: end get_rec;
243:
244: function get_rec (

Line 241: return(l_okl_trx_types_tl_rec);

237: l_okl_trx_types_tl_rec.LAST_UPDATE_DATE,
238: l_okl_trx_types_tl_rec.LAST_UPDATE_LOGIN;
239: x_no_data_found := okl_trx_types_tl_pk_csr%notfound;
240: close okl_trx_types_tl_pk_csr;
241: return(l_okl_trx_types_tl_rec);
242: end get_rec;
243:
244: function get_rec (
245: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type

Line 245: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type

241: return(l_okl_trx_types_tl_rec);
242: end get_rec;
243:
244: function get_rec (
245: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type
246: ) return okl_trx_types_tl_rec_type is
247: l_row_notfound boolean := true;
248: begin
249: return(get_rec(p_okl_trx_types_tl_rec, l_row_notfound));

Line 246: ) return okl_trx_types_tl_rec_type is

242: end get_rec;
243:
244: function get_rec (
245: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type
246: ) return okl_trx_types_tl_rec_type is
247: l_row_notfound boolean := true;
248: begin
249: return(get_rec(p_okl_trx_types_tl_rec, l_row_notfound));
250: end get_rec;

Line 249: return(get_rec(p_okl_trx_types_tl_rec, l_row_notfound));

245: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type
246: ) return okl_trx_types_tl_rec_type is
247: l_row_notfound boolean := true;
248: begin
249: return(get_rec(p_okl_trx_types_tl_rec, l_row_notfound));
250: end get_rec;
251: ---------------------------------------------------------------------------
252: -- FUNCTION get_rec for: OKL_TRX_TYPES_V
253: ---------------------------------------------------------------------------

Line 1839: l_language OKL_TRX_TYPES_TL.language%type := USERENV('LANG');

1835: is
1836:
1837: l_dummy varchar2(1);
1838: l_row_found boolean := false;
1839: l_language OKL_TRX_TYPES_TL.language%type := USERENV('LANG');
1840: cursor unique_try_csr(p_name okl_trx_types_tl.name%type
1841: ,p_language OKL_TRX_TYPES_TL.language%type
1842: ,p_id OKL_TRX_TYPES_TL.id%type ) is
1843: select 1

Line 1840: cursor unique_try_csr(p_name okl_trx_types_tl.name%type

1836:
1837: l_dummy varchar2(1);
1838: l_row_found boolean := false;
1839: l_language OKL_TRX_TYPES_TL.language%type := USERENV('LANG');
1840: cursor unique_try_csr(p_name okl_trx_types_tl.name%type
1841: ,p_language OKL_TRX_TYPES_TL.language%type
1842: ,p_id OKL_TRX_TYPES_TL.id%type ) is
1843: select 1
1844: from okl_trx_types_tl

Line 1841: ,p_language OKL_TRX_TYPES_TL.language%type

1837: l_dummy varchar2(1);
1838: l_row_found boolean := false;
1839: l_language OKL_TRX_TYPES_TL.language%type := USERENV('LANG');
1840: cursor unique_try_csr(p_name okl_trx_types_tl.name%type
1841: ,p_language OKL_TRX_TYPES_TL.language%type
1842: ,p_id OKL_TRX_TYPES_TL.id%type ) is
1843: select 1
1844: from okl_trx_types_tl
1845: where name = p_name

Line 1842: ,p_id OKL_TRX_TYPES_TL.id%type ) is

1838: l_row_found boolean := false;
1839: l_language OKL_TRX_TYPES_TL.language%type := USERENV('LANG');
1840: cursor unique_try_csr(p_name okl_trx_types_tl.name%type
1841: ,p_language OKL_TRX_TYPES_TL.language%type
1842: ,p_id OKL_TRX_TYPES_TL.id%type ) is
1843: select 1
1844: from okl_trx_types_tl
1845: where name = p_name
1846: and language = l_language

Line 1844: from okl_trx_types_tl

1840: cursor unique_try_csr(p_name okl_trx_types_tl.name%type
1841: ,p_language OKL_TRX_TYPES_TL.language%type
1842: ,p_id OKL_TRX_TYPES_TL.id%type ) is
1843: select 1
1844: from okl_trx_types_tl
1845: where name = p_name
1846: and language = l_language
1847: and id <> p_id;
1848:

Line 2008: p_to in out NOCOPY okl_trx_types_tl_rec_type

2004: p_to.accounting_event_class_code := p_from.accounting_event_class_code;
2005: end migrate;
2006: procedure migrate (
2007: p_from in tryv_rec_type,
2008: p_to in out NOCOPY okl_trx_types_tl_rec_type
2009: ) is
2010: begin
2011: p_to.id := p_from.id;
2012: p_to.sfwt_flag := p_from.sfwt_flag;

Line 2024: p_from in okl_trx_types_tl_rec_type,

2020: p_to.last_update_date := p_from.last_update_date;
2021: p_to.last_update_login := p_from.last_update_login;
2022: end migrate;
2023: procedure migrate (
2024: p_from in okl_trx_types_tl_rec_type,
2025: p_to in out NOCOPY tryv_rec_type
2026: ) is
2027: begin
2028: p_to.id := p_from.id;

Line 2060: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;

2056: l_api_name constant varchar2(30) := 'V_validate_row';
2057: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
2058: l_tryv_rec tryv_rec_type := p_tryv_rec;
2059: l_try_rec try_rec_type;
2060: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
2061: begin
2062: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2063: G_PKG_NAME,
2064: p_init_msg_list,

Line 2332: -- insert_row for:OKL_TRX_TYPES_TL --

2328: '_PVT'
2329: );
2330: end insert_row;
2331: -------------------------------------
2332: -- insert_row for:OKL_TRX_TYPES_TL --
2333: -------------------------------------
2334: procedure insert_row(
2335: p_init_msg_list in varchar2,
2336: x_return_status out NOCOPY varchar2,

Line 2339: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,

2335: p_init_msg_list in varchar2,
2336: x_return_status out NOCOPY varchar2,
2337: x_msg_count out NOCOPY number,
2338: x_msg_data out NOCOPY varchar2,
2339: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
2340: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type) is
2341:
2342: l_api_version constant number := 1;
2343: l_api_name constant varchar2(30) := 'TL_insert_row';

Line 2340: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type) is

2336: x_return_status out NOCOPY varchar2,
2337: x_msg_count out NOCOPY number,
2338: x_msg_data out NOCOPY varchar2,
2339: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
2340: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type) is
2341:
2342: l_api_version constant number := 1;
2343: l_api_name constant varchar2(30) := 'TL_insert_row';
2344: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 2345: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type := p_okl_trx_types_tl_rec;

2341:
2342: l_api_version constant number := 1;
2343: l_api_name constant varchar2(30) := 'TL_insert_row';
2344: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
2345: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type := p_okl_trx_types_tl_rec;
2346: l_def_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
2347: cursor get_languages is
2348: select *
2349: from FND_LANGUAGES

Line 2346: l_def_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;

2342: l_api_version constant number := 1;
2343: l_api_name constant varchar2(30) := 'TL_insert_row';
2344: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
2345: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type := p_okl_trx_types_tl_rec;
2346: l_def_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
2347: cursor get_languages is
2348: select *
2349: from FND_LANGUAGES
2350: where INSTALLED_FLAG in ('I', 'B');

Line 2352: -- Set_Attributes for:OKL_TRX_TYPES_TL --

2348: select *
2349: from FND_LANGUAGES
2350: where INSTALLED_FLAG in ('I', 'B');
2351: -----------------------------------------
2352: -- Set_Attributes for:OKL_TRX_TYPES_TL --
2353: -----------------------------------------
2354: function Set_Attributes (
2355: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
2356: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type

Line 2355: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,

2351: -----------------------------------------
2352: -- Set_Attributes for:OKL_TRX_TYPES_TL --
2353: -----------------------------------------
2354: function Set_Attributes (
2355: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
2356: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type
2357: ) return varchar2 is
2358: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
2359: begin

Line 2356: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type

2352: -- Set_Attributes for:OKL_TRX_TYPES_TL --
2353: -----------------------------------------
2354: function Set_Attributes (
2355: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
2356: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type
2357: ) return varchar2 is
2358: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
2359: begin
2360: x_okl_trx_types_tl_rec := p_okl_trx_types_tl_rec;

Line 2360: x_okl_trx_types_tl_rec := p_okl_trx_types_tl_rec;

2356: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type
2357: ) return varchar2 is
2358: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
2359: begin
2360: x_okl_trx_types_tl_rec := p_okl_trx_types_tl_rec;
2361: x_okl_trx_types_tl_rec.language := USERENV('LANG');
2362: x_okl_trx_types_tl_rec.SOURCE_LANG := USERENV('LANG');
2363: return(l_return_status);
2364: end Set_Attributes;

Line 2361: x_okl_trx_types_tl_rec.language := USERENV('LANG');

2357: ) return varchar2 is
2358: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
2359: begin
2360: x_okl_trx_types_tl_rec := p_okl_trx_types_tl_rec;
2361: x_okl_trx_types_tl_rec.language := USERENV('LANG');
2362: x_okl_trx_types_tl_rec.SOURCE_LANG := USERENV('LANG');
2363: return(l_return_status);
2364: end Set_Attributes;
2365: begin

Line 2362: x_okl_trx_types_tl_rec.SOURCE_LANG := USERENV('LANG');

2358: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
2359: begin
2360: x_okl_trx_types_tl_rec := p_okl_trx_types_tl_rec;
2361: x_okl_trx_types_tl_rec.language := USERENV('LANG');
2362: x_okl_trx_types_tl_rec.SOURCE_LANG := USERENV('LANG');
2363: return(l_return_status);
2364: end Set_Attributes;
2365: begin
2366: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 2378: p_okl_trx_types_tl_rec, -- IN

2374: raise Okc_Api.G_EXCEPTION_ERROR;
2375: end if;
2376: --- Setting item attributes
2377: l_return_status := Set_Attributes(
2378: p_okl_trx_types_tl_rec, -- IN
2379: l_okl_trx_types_tl_rec); -- OUT
2380:
2381: --- If any errors happen abort API
2382: if (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) then

Line 2379: l_okl_trx_types_tl_rec); -- OUT

2375: end if;
2376: --- Setting item attributes
2377: l_return_status := Set_Attributes(
2378: p_okl_trx_types_tl_rec, -- IN
2379: l_okl_trx_types_tl_rec); -- OUT
2380:
2381: --- If any errors happen abort API
2382: if (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) then
2383: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2388: l_okl_trx_types_tl_rec.language := l_lang_rec.language_code;

2384: elsif (l_return_status = Okc_Api.G_RET_STS_ERROR) then
2385: raise Okc_Api.G_EXCEPTION_ERROR;
2386: end if;
2387: for l_lang_rec in get_languages loop
2388: l_okl_trx_types_tl_rec.language := l_lang_rec.language_code;
2389: insert into OKL_TRX_TYPES_TL(
2390: id,
2391: language,
2392: source_lang,

Line 2389: insert into OKL_TRX_TYPES_TL(

2385: raise Okc_Api.G_EXCEPTION_ERROR;
2386: end if;
2387: for l_lang_rec in get_languages loop
2388: l_okl_trx_types_tl_rec.language := l_lang_rec.language_code;
2389: insert into OKL_TRX_TYPES_TL(
2390: id,
2391: language,
2392: source_lang,
2393: sfwt_flag,

Line 2404: l_okl_trx_types_tl_rec.id,

2400: last_updated_by,
2401: last_update_date,
2402: last_update_login)
2403: values (
2404: l_okl_trx_types_tl_rec.id,
2405: l_okl_trx_types_tl_rec.language,
2406: l_okl_trx_types_tl_rec.source_lang,
2407: l_okl_trx_types_tl_rec.sfwt_flag,
2408: l_okl_trx_types_tl_rec.name,

Line 2405: l_okl_trx_types_tl_rec.language,

2401: last_update_date,
2402: last_update_login)
2403: values (
2404: l_okl_trx_types_tl_rec.id,
2405: l_okl_trx_types_tl_rec.language,
2406: l_okl_trx_types_tl_rec.source_lang,
2407: l_okl_trx_types_tl_rec.sfwt_flag,
2408: l_okl_trx_types_tl_rec.name,
2409: l_okl_trx_types_tl_rec.description,

Line 2406: l_okl_trx_types_tl_rec.source_lang,

2402: last_update_login)
2403: values (
2404: l_okl_trx_types_tl_rec.id,
2405: l_okl_trx_types_tl_rec.language,
2406: l_okl_trx_types_tl_rec.source_lang,
2407: l_okl_trx_types_tl_rec.sfwt_flag,
2408: l_okl_trx_types_tl_rec.name,
2409: l_okl_trx_types_tl_rec.description,
2410: l_okl_trx_types_tl_rec.contract_header_line_flag,

Line 2407: l_okl_trx_types_tl_rec.sfwt_flag,

2403: values (
2404: l_okl_trx_types_tl_rec.id,
2405: l_okl_trx_types_tl_rec.language,
2406: l_okl_trx_types_tl_rec.source_lang,
2407: l_okl_trx_types_tl_rec.sfwt_flag,
2408: l_okl_trx_types_tl_rec.name,
2409: l_okl_trx_types_tl_rec.description,
2410: l_okl_trx_types_tl_rec.contract_header_line_flag,
2411: l_okl_trx_types_tl_rec.transaction_header_line_detail,

Line 2408: l_okl_trx_types_tl_rec.name,

2404: l_okl_trx_types_tl_rec.id,
2405: l_okl_trx_types_tl_rec.language,
2406: l_okl_trx_types_tl_rec.source_lang,
2407: l_okl_trx_types_tl_rec.sfwt_flag,
2408: l_okl_trx_types_tl_rec.name,
2409: l_okl_trx_types_tl_rec.description,
2410: l_okl_trx_types_tl_rec.contract_header_line_flag,
2411: l_okl_trx_types_tl_rec.transaction_header_line_detail,
2412: l_okl_trx_types_tl_rec.created_by,

Line 2409: l_okl_trx_types_tl_rec.description,

2405: l_okl_trx_types_tl_rec.language,
2406: l_okl_trx_types_tl_rec.source_lang,
2407: l_okl_trx_types_tl_rec.sfwt_flag,
2408: l_okl_trx_types_tl_rec.name,
2409: l_okl_trx_types_tl_rec.description,
2410: l_okl_trx_types_tl_rec.contract_header_line_flag,
2411: l_okl_trx_types_tl_rec.transaction_header_line_detail,
2412: l_okl_trx_types_tl_rec.created_by,
2413: l_okl_trx_types_tl_rec.creation_date,

Line 2410: l_okl_trx_types_tl_rec.contract_header_line_flag,

2406: l_okl_trx_types_tl_rec.source_lang,
2407: l_okl_trx_types_tl_rec.sfwt_flag,
2408: l_okl_trx_types_tl_rec.name,
2409: l_okl_trx_types_tl_rec.description,
2410: l_okl_trx_types_tl_rec.contract_header_line_flag,
2411: l_okl_trx_types_tl_rec.transaction_header_line_detail,
2412: l_okl_trx_types_tl_rec.created_by,
2413: l_okl_trx_types_tl_rec.creation_date,
2414: l_okl_trx_types_tl_rec.last_updated_by,

Line 2411: l_okl_trx_types_tl_rec.transaction_header_line_detail,

2407: l_okl_trx_types_tl_rec.sfwt_flag,
2408: l_okl_trx_types_tl_rec.name,
2409: l_okl_trx_types_tl_rec.description,
2410: l_okl_trx_types_tl_rec.contract_header_line_flag,
2411: l_okl_trx_types_tl_rec.transaction_header_line_detail,
2412: l_okl_trx_types_tl_rec.created_by,
2413: l_okl_trx_types_tl_rec.creation_date,
2414: l_okl_trx_types_tl_rec.last_updated_by,
2415: l_okl_trx_types_tl_rec.last_update_date,

Line 2412: l_okl_trx_types_tl_rec.created_by,

2408: l_okl_trx_types_tl_rec.name,
2409: l_okl_trx_types_tl_rec.description,
2410: l_okl_trx_types_tl_rec.contract_header_line_flag,
2411: l_okl_trx_types_tl_rec.transaction_header_line_detail,
2412: l_okl_trx_types_tl_rec.created_by,
2413: l_okl_trx_types_tl_rec.creation_date,
2414: l_okl_trx_types_tl_rec.last_updated_by,
2415: l_okl_trx_types_tl_rec.last_update_date,
2416: l_okl_trx_types_tl_rec.last_update_login);

Line 2413: l_okl_trx_types_tl_rec.creation_date,

2409: l_okl_trx_types_tl_rec.description,
2410: l_okl_trx_types_tl_rec.contract_header_line_flag,
2411: l_okl_trx_types_tl_rec.transaction_header_line_detail,
2412: l_okl_trx_types_tl_rec.created_by,
2413: l_okl_trx_types_tl_rec.creation_date,
2414: l_okl_trx_types_tl_rec.last_updated_by,
2415: l_okl_trx_types_tl_rec.last_update_date,
2416: l_okl_trx_types_tl_rec.last_update_login);
2417: end loop;

Line 2414: l_okl_trx_types_tl_rec.last_updated_by,

2410: l_okl_trx_types_tl_rec.contract_header_line_flag,
2411: l_okl_trx_types_tl_rec.transaction_header_line_detail,
2412: l_okl_trx_types_tl_rec.created_by,
2413: l_okl_trx_types_tl_rec.creation_date,
2414: l_okl_trx_types_tl_rec.last_updated_by,
2415: l_okl_trx_types_tl_rec.last_update_date,
2416: l_okl_trx_types_tl_rec.last_update_login);
2417: end loop;
2418: -- Set OUT values

Line 2415: l_okl_trx_types_tl_rec.last_update_date,

2411: l_okl_trx_types_tl_rec.transaction_header_line_detail,
2412: l_okl_trx_types_tl_rec.created_by,
2413: l_okl_trx_types_tl_rec.creation_date,
2414: l_okl_trx_types_tl_rec.last_updated_by,
2415: l_okl_trx_types_tl_rec.last_update_date,
2416: l_okl_trx_types_tl_rec.last_update_login);
2417: end loop;
2418: -- Set OUT values
2419: x_okl_trx_types_tl_rec := l_okl_trx_types_tl_rec;

Line 2416: l_okl_trx_types_tl_rec.last_update_login);

2412: l_okl_trx_types_tl_rec.created_by,
2413: l_okl_trx_types_tl_rec.creation_date,
2414: l_okl_trx_types_tl_rec.last_updated_by,
2415: l_okl_trx_types_tl_rec.last_update_date,
2416: l_okl_trx_types_tl_rec.last_update_login);
2417: end loop;
2418: -- Set OUT values
2419: x_okl_trx_types_tl_rec := l_okl_trx_types_tl_rec;
2420: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2419: x_okl_trx_types_tl_rec := l_okl_trx_types_tl_rec;

2415: l_okl_trx_types_tl_rec.last_update_date,
2416: l_okl_trx_types_tl_rec.last_update_login);
2417: end loop;
2418: -- Set OUT values
2419: x_okl_trx_types_tl_rec := l_okl_trx_types_tl_rec;
2420: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2421: exception
2422: when Okc_Api.G_EXCEPTION_ERROR then
2423: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

Line 2472: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;

2468: l_tryv_rec tryv_rec_type;
2469: l_def_tryv_rec tryv_rec_type;
2470: l_try_rec try_rec_type;
2471: lx_try_rec try_rec_type;
2472: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
2473: lx_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
2474: -------------------------------
2475: -- FUNCTION fill_who_columns --
2476: -------------------------------

Line 2473: lx_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;

2469: l_def_tryv_rec tryv_rec_type;
2470: l_try_rec try_rec_type;
2471: lx_try_rec try_rec_type;
2472: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
2473: lx_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
2474: -------------------------------
2475: -- FUNCTION fill_who_columns --
2476: -------------------------------
2477: function fill_who_columns (

Line 2556: migrate(l_def_tryv_rec, l_okl_trx_types_tl_rec);

2552: --------------------------------------
2553: -- Move VIEW record to "Child" records
2554: --------------------------------------
2555: migrate(l_def_tryv_rec, l_try_rec);
2556: migrate(l_def_tryv_rec, l_okl_trx_types_tl_rec);
2557: --------------------------------------------
2558: -- Call the INSERT_ROW for each child record
2559: --------------------------------------------
2560: insert_row(

Line 2579: l_okl_trx_types_tl_rec,

2575: p_init_msg_list,
2576: x_return_status,
2577: x_msg_count,
2578: x_msg_data,
2579: l_okl_trx_types_tl_rec,
2580: lx_okl_trx_types_tl_rec
2581: );
2582: if (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) then
2583: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2580: lx_okl_trx_types_tl_rec

2576: x_return_status,
2577: x_msg_count,
2578: x_msg_data,
2579: l_okl_trx_types_tl_rec,
2580: lx_okl_trx_types_tl_rec
2581: );
2582: if (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) then
2583: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2584: elsif (x_return_status = Okc_Api.G_RET_STS_ERROR) then

Line 2587: migrate(lx_okl_trx_types_tl_rec, l_def_tryv_rec);

2583: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2584: elsif (x_return_status = Okc_Api.G_RET_STS_ERROR) then
2585: raise Okc_Api.G_EXCEPTION_ERROR;
2586: end if;
2587: migrate(lx_okl_trx_types_tl_rec, l_def_tryv_rec);
2588: -- Set OUT values
2589: x_tryv_rec := l_def_tryv_rec;
2590: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2591: exception

Line 2810: -- lock_row for:OKL_TRX_TYPES_TL --

2806: '_PVT'
2807: );
2808: end lock_row;
2809: -----------------------------------
2810: -- lock_row for:OKL_TRX_TYPES_TL --
2811: -----------------------------------
2812: procedure lock_row(
2813: p_init_msg_list in varchar2,
2814: x_return_status out NOCOPY varchar2,

Line 2817: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type) is

2813: p_init_msg_list in varchar2,
2814: x_return_status out NOCOPY varchar2,
2815: x_msg_count out NOCOPY number,
2816: x_msg_data out NOCOPY varchar2,
2817: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type) is
2818:
2819: E_Resource_Busy exception;
2820: pragma exception_init(E_Resource_Busy, -00054);
2821: cursor lock_csr (p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type) is

Line 2821: cursor lock_csr (p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type) is

2817: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type) is
2818:
2819: E_Resource_Busy exception;
2820: pragma exception_init(E_Resource_Busy, -00054);
2821: cursor lock_csr (p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type) is
2822: select *
2823: from OKL_TRX_TYPES_TL
2824: where ID = p_okl_trx_types_tl_rec.id
2825: for update nowait;

Line 2823: from OKL_TRX_TYPES_TL

2819: E_Resource_Busy exception;
2820: pragma exception_init(E_Resource_Busy, -00054);
2821: cursor lock_csr (p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type) is
2822: select *
2823: from OKL_TRX_TYPES_TL
2824: where ID = p_okl_trx_types_tl_rec.id
2825: for update nowait;
2826:
2827: l_api_version constant number := 1;

Line 2824: where ID = p_okl_trx_types_tl_rec.id

2820: pragma exception_init(E_Resource_Busy, -00054);
2821: cursor lock_csr (p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type) is
2822: select *
2823: from OKL_TRX_TYPES_TL
2824: where ID = p_okl_trx_types_tl_rec.id
2825: for update nowait;
2826:
2827: l_api_version constant number := 1;
2828: l_api_name constant varchar2(30) := 'TL_lock_row';

Line 2844: open lock_csr(p_okl_trx_types_tl_rec);

2840: elsif (l_return_status = Okc_Api.G_RET_STS_ERROR) then
2841: raise Okc_Api.G_EXCEPTION_ERROR;
2842: end if;
2843: begin
2844: open lock_csr(p_okl_trx_types_tl_rec);
2845: fetch lock_csr into l_lock_var;
2846: l_row_notfound := lock_csr%notfound;
2847: close lock_csr;
2848: exception

Line 2909: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;

2905: l_api_version constant number := 1;
2906: l_api_name constant varchar2(30) := 'V_lock_row';
2907: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
2908: l_try_rec try_rec_type;
2909: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
2910: begin
2911: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2912: G_PKG_NAME,
2913: p_init_msg_list,

Line 2927: migrate(p_tryv_rec, l_okl_trx_types_tl_rec);

2923: --------------------------------------
2924: -- Move VIEW record to "Child" records
2925: --------------------------------------
2926: migrate(p_tryv_rec, l_try_rec);
2927: migrate(p_tryv_rec, l_okl_trx_types_tl_rec);
2928: --------------------------------------------
2929: -- Call the LOCK_ROW for each child record
2930: --------------------------------------------
2931: lock_row(

Line 2948: l_okl_trx_types_tl_rec

2944: p_init_msg_list,
2945: x_return_status,
2946: x_msg_count,
2947: x_msg_data,
2948: l_okl_trx_types_tl_rec
2949: );
2950: if (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) then
2951: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2952: elsif (x_return_status = Okc_Api.G_RET_STS_ERROR) then

Line 3279: -- update_row for:OKL_TRX_TYPES_TL --

3275: '_PVT'
3276: );
3277: end update_row;
3278: -------------------------------------
3279: -- update_row for:OKL_TRX_TYPES_TL --
3280: -------------------------------------
3281: procedure update_row(
3282: p_init_msg_list in varchar2,
3283: x_return_status out NOCOPY varchar2,

Line 3286: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,

3282: p_init_msg_list in varchar2,
3283: x_return_status out NOCOPY varchar2,
3284: x_msg_count out NOCOPY number,
3285: x_msg_data out NOCOPY varchar2,
3286: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
3287: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type) is
3288:
3289: l_api_version constant number := 1;
3290: l_api_name constant varchar2(30) := 'TL_update_row';

Line 3287: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type) is

3283: x_return_status out NOCOPY varchar2,
3284: x_msg_count out NOCOPY number,
3285: x_msg_data out NOCOPY varchar2,
3286: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
3287: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type) is
3288:
3289: l_api_version constant number := 1;
3290: l_api_name constant varchar2(30) := 'TL_update_row';
3291: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 3292: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type := p_okl_trx_types_tl_rec;

3288:
3289: l_api_version constant number := 1;
3290: l_api_name constant varchar2(30) := 'TL_update_row';
3291: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3292: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type := p_okl_trx_types_tl_rec;
3293: l_def_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
3294: l_row_notfound boolean := true;
3295: ----------------------------------
3296: -- FUNCTION populate_new_record --

Line 3293: l_def_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;

3289: l_api_version constant number := 1;
3290: l_api_name constant varchar2(30) := 'TL_update_row';
3291: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3292: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type := p_okl_trx_types_tl_rec;
3293: l_def_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
3294: l_row_notfound boolean := true;
3295: ----------------------------------
3296: -- FUNCTION populate_new_record --
3297: ----------------------------------

Line 3299: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,

3295: ----------------------------------
3296: -- FUNCTION populate_new_record --
3297: ----------------------------------
3298: function populate_new_record (
3299: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
3300: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type
3301: ) return varchar2 is
3302: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
3303: l_row_notfound boolean := true;

Line 3300: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type

3296: -- FUNCTION populate_new_record --
3297: ----------------------------------
3298: function populate_new_record (
3299: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
3300: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type
3301: ) return varchar2 is
3302: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
3303: l_row_notfound boolean := true;
3304: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 3302: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;

3298: function populate_new_record (
3299: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
3300: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type
3301: ) return varchar2 is
3302: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
3303: l_row_notfound boolean := true;
3304: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3305: begin
3306: x_okl_trx_types_tl_rec := p_okl_trx_types_tl_rec;

Line 3306: x_okl_trx_types_tl_rec := p_okl_trx_types_tl_rec;

3302: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
3303: l_row_notfound boolean := true;
3304: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3305: begin
3306: x_okl_trx_types_tl_rec := p_okl_trx_types_tl_rec;
3307: -- Get current database values
3308: l_okl_trx_types_tl_rec := get_rec(p_okl_trx_types_tl_rec, l_row_notfound);
3309: if (l_row_notfound) then
3310: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

Line 3308: l_okl_trx_types_tl_rec := get_rec(p_okl_trx_types_tl_rec, l_row_notfound);

3304: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3305: begin
3306: x_okl_trx_types_tl_rec := p_okl_trx_types_tl_rec;
3307: -- Get current database values
3308: l_okl_trx_types_tl_rec := get_rec(p_okl_trx_types_tl_rec, l_row_notfound);
3309: if (l_row_notfound) then
3310: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
3311: end if;
3312: if (x_okl_trx_types_tl_rec.id = Okc_Api.G_MISS_NUM)

Line 3312: if (x_okl_trx_types_tl_rec.id = Okc_Api.G_MISS_NUM)

3308: l_okl_trx_types_tl_rec := get_rec(p_okl_trx_types_tl_rec, l_row_notfound);
3309: if (l_row_notfound) then
3310: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
3311: end if;
3312: if (x_okl_trx_types_tl_rec.id = Okc_Api.G_MISS_NUM)
3313: then
3314: x_okl_trx_types_tl_rec.id := l_okl_trx_types_tl_rec.id;
3315: end if;
3316: if (x_okl_trx_types_tl_rec.language = Okc_Api.G_MISS_CHAR)

Line 3314: x_okl_trx_types_tl_rec.id := l_okl_trx_types_tl_rec.id;

3310: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
3311: end if;
3312: if (x_okl_trx_types_tl_rec.id = Okc_Api.G_MISS_NUM)
3313: then
3314: x_okl_trx_types_tl_rec.id := l_okl_trx_types_tl_rec.id;
3315: end if;
3316: if (x_okl_trx_types_tl_rec.language = Okc_Api.G_MISS_CHAR)
3317: then
3318: x_okl_trx_types_tl_rec.language := l_okl_trx_types_tl_rec.language;

Line 3316: if (x_okl_trx_types_tl_rec.language = Okc_Api.G_MISS_CHAR)

3312: if (x_okl_trx_types_tl_rec.id = Okc_Api.G_MISS_NUM)
3313: then
3314: x_okl_trx_types_tl_rec.id := l_okl_trx_types_tl_rec.id;
3315: end if;
3316: if (x_okl_trx_types_tl_rec.language = Okc_Api.G_MISS_CHAR)
3317: then
3318: x_okl_trx_types_tl_rec.language := l_okl_trx_types_tl_rec.language;
3319: end if;
3320: if (x_okl_trx_types_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)

Line 3318: x_okl_trx_types_tl_rec.language := l_okl_trx_types_tl_rec.language;

3314: x_okl_trx_types_tl_rec.id := l_okl_trx_types_tl_rec.id;
3315: end if;
3316: if (x_okl_trx_types_tl_rec.language = Okc_Api.G_MISS_CHAR)
3317: then
3318: x_okl_trx_types_tl_rec.language := l_okl_trx_types_tl_rec.language;
3319: end if;
3320: if (x_okl_trx_types_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
3321: then
3322: x_okl_trx_types_tl_rec.source_lang := l_okl_trx_types_tl_rec.source_lang;

Line 3320: if (x_okl_trx_types_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)

3316: if (x_okl_trx_types_tl_rec.language = Okc_Api.G_MISS_CHAR)
3317: then
3318: x_okl_trx_types_tl_rec.language := l_okl_trx_types_tl_rec.language;
3319: end if;
3320: if (x_okl_trx_types_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
3321: then
3322: x_okl_trx_types_tl_rec.source_lang := l_okl_trx_types_tl_rec.source_lang;
3323: end if;
3324: if (x_okl_trx_types_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)

Line 3322: x_okl_trx_types_tl_rec.source_lang := l_okl_trx_types_tl_rec.source_lang;

3318: x_okl_trx_types_tl_rec.language := l_okl_trx_types_tl_rec.language;
3319: end if;
3320: if (x_okl_trx_types_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
3321: then
3322: x_okl_trx_types_tl_rec.source_lang := l_okl_trx_types_tl_rec.source_lang;
3323: end if;
3324: if (x_okl_trx_types_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
3325: then
3326: x_okl_trx_types_tl_rec.sfwt_flag := l_okl_trx_types_tl_rec.sfwt_flag;

Line 3324: if (x_okl_trx_types_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)

3320: if (x_okl_trx_types_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
3321: then
3322: x_okl_trx_types_tl_rec.source_lang := l_okl_trx_types_tl_rec.source_lang;
3323: end if;
3324: if (x_okl_trx_types_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
3325: then
3326: x_okl_trx_types_tl_rec.sfwt_flag := l_okl_trx_types_tl_rec.sfwt_flag;
3327: end if;
3328: if (x_okl_trx_types_tl_rec.name = Okc_Api.G_MISS_CHAR)

Line 3326: x_okl_trx_types_tl_rec.sfwt_flag := l_okl_trx_types_tl_rec.sfwt_flag;

3322: x_okl_trx_types_tl_rec.source_lang := l_okl_trx_types_tl_rec.source_lang;
3323: end if;
3324: if (x_okl_trx_types_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
3325: then
3326: x_okl_trx_types_tl_rec.sfwt_flag := l_okl_trx_types_tl_rec.sfwt_flag;
3327: end if;
3328: if (x_okl_trx_types_tl_rec.name = Okc_Api.G_MISS_CHAR)
3329: then
3330: x_okl_trx_types_tl_rec.name := l_okl_trx_types_tl_rec.name;

Line 3328: if (x_okl_trx_types_tl_rec.name = Okc_Api.G_MISS_CHAR)

3324: if (x_okl_trx_types_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
3325: then
3326: x_okl_trx_types_tl_rec.sfwt_flag := l_okl_trx_types_tl_rec.sfwt_flag;
3327: end if;
3328: if (x_okl_trx_types_tl_rec.name = Okc_Api.G_MISS_CHAR)
3329: then
3330: x_okl_trx_types_tl_rec.name := l_okl_trx_types_tl_rec.name;
3331: end if;
3332: if (x_okl_trx_types_tl_rec.description = Okc_Api.G_MISS_CHAR)

Line 3330: x_okl_trx_types_tl_rec.name := l_okl_trx_types_tl_rec.name;

3326: x_okl_trx_types_tl_rec.sfwt_flag := l_okl_trx_types_tl_rec.sfwt_flag;
3327: end if;
3328: if (x_okl_trx_types_tl_rec.name = Okc_Api.G_MISS_CHAR)
3329: then
3330: x_okl_trx_types_tl_rec.name := l_okl_trx_types_tl_rec.name;
3331: end if;
3332: if (x_okl_trx_types_tl_rec.description = Okc_Api.G_MISS_CHAR)
3333: then
3334: x_okl_trx_types_tl_rec.description := l_okl_trx_types_tl_rec.description;

Line 3332: if (x_okl_trx_types_tl_rec.description = Okc_Api.G_MISS_CHAR)

3328: if (x_okl_trx_types_tl_rec.name = Okc_Api.G_MISS_CHAR)
3329: then
3330: x_okl_trx_types_tl_rec.name := l_okl_trx_types_tl_rec.name;
3331: end if;
3332: if (x_okl_trx_types_tl_rec.description = Okc_Api.G_MISS_CHAR)
3333: then
3334: x_okl_trx_types_tl_rec.description := l_okl_trx_types_tl_rec.description;
3335: end if;
3336: if (x_okl_trx_types_tl_rec.contract_header_line_flag = Okc_Api.G_MISS_CHAR)

Line 3334: x_okl_trx_types_tl_rec.description := l_okl_trx_types_tl_rec.description;

3330: x_okl_trx_types_tl_rec.name := l_okl_trx_types_tl_rec.name;
3331: end if;
3332: if (x_okl_trx_types_tl_rec.description = Okc_Api.G_MISS_CHAR)
3333: then
3334: x_okl_trx_types_tl_rec.description := l_okl_trx_types_tl_rec.description;
3335: end if;
3336: if (x_okl_trx_types_tl_rec.contract_header_line_flag = Okc_Api.G_MISS_CHAR)
3337: then
3338: x_okl_trx_types_tl_rec.contract_header_line_flag := l_okl_trx_types_tl_rec.contract_header_line_flag;

Line 3336: if (x_okl_trx_types_tl_rec.contract_header_line_flag = Okc_Api.G_MISS_CHAR)

3332: if (x_okl_trx_types_tl_rec.description = Okc_Api.G_MISS_CHAR)
3333: then
3334: x_okl_trx_types_tl_rec.description := l_okl_trx_types_tl_rec.description;
3335: end if;
3336: if (x_okl_trx_types_tl_rec.contract_header_line_flag = Okc_Api.G_MISS_CHAR)
3337: then
3338: x_okl_trx_types_tl_rec.contract_header_line_flag := l_okl_trx_types_tl_rec.contract_header_line_flag;
3339: end if;
3340: if (x_okl_trx_types_tl_rec.transaction_header_line_detail = Okc_Api.G_MISS_CHAR)

Line 3338: x_okl_trx_types_tl_rec.contract_header_line_flag := l_okl_trx_types_tl_rec.contract_header_line_flag;

3334: x_okl_trx_types_tl_rec.description := l_okl_trx_types_tl_rec.description;
3335: end if;
3336: if (x_okl_trx_types_tl_rec.contract_header_line_flag = Okc_Api.G_MISS_CHAR)
3337: then
3338: x_okl_trx_types_tl_rec.contract_header_line_flag := l_okl_trx_types_tl_rec.contract_header_line_flag;
3339: end if;
3340: if (x_okl_trx_types_tl_rec.transaction_header_line_detail = Okc_Api.G_MISS_CHAR)
3341: then
3342: x_okl_trx_types_tl_rec.transaction_header_line_detail := l_okl_trx_types_tl_rec.transaction_header_line_detail;

Line 3340: if (x_okl_trx_types_tl_rec.transaction_header_line_detail = Okc_Api.G_MISS_CHAR)

3336: if (x_okl_trx_types_tl_rec.contract_header_line_flag = Okc_Api.G_MISS_CHAR)
3337: then
3338: x_okl_trx_types_tl_rec.contract_header_line_flag := l_okl_trx_types_tl_rec.contract_header_line_flag;
3339: end if;
3340: if (x_okl_trx_types_tl_rec.transaction_header_line_detail = Okc_Api.G_MISS_CHAR)
3341: then
3342: x_okl_trx_types_tl_rec.transaction_header_line_detail := l_okl_trx_types_tl_rec.transaction_header_line_detail;
3343: end if;
3344: if (x_okl_trx_types_tl_rec.created_by = Okc_Api.G_MISS_NUM)

Line 3342: x_okl_trx_types_tl_rec.transaction_header_line_detail := l_okl_trx_types_tl_rec.transaction_header_line_detail;

3338: x_okl_trx_types_tl_rec.contract_header_line_flag := l_okl_trx_types_tl_rec.contract_header_line_flag;
3339: end if;
3340: if (x_okl_trx_types_tl_rec.transaction_header_line_detail = Okc_Api.G_MISS_CHAR)
3341: then
3342: x_okl_trx_types_tl_rec.transaction_header_line_detail := l_okl_trx_types_tl_rec.transaction_header_line_detail;
3343: end if;
3344: if (x_okl_trx_types_tl_rec.created_by = Okc_Api.G_MISS_NUM)
3345: then
3346: x_okl_trx_types_tl_rec.created_by := l_okl_trx_types_tl_rec.created_by;

Line 3344: if (x_okl_trx_types_tl_rec.created_by = Okc_Api.G_MISS_NUM)

3340: if (x_okl_trx_types_tl_rec.transaction_header_line_detail = Okc_Api.G_MISS_CHAR)
3341: then
3342: x_okl_trx_types_tl_rec.transaction_header_line_detail := l_okl_trx_types_tl_rec.transaction_header_line_detail;
3343: end if;
3344: if (x_okl_trx_types_tl_rec.created_by = Okc_Api.G_MISS_NUM)
3345: then
3346: x_okl_trx_types_tl_rec.created_by := l_okl_trx_types_tl_rec.created_by;
3347: end if;
3348: if (x_okl_trx_types_tl_rec.creation_date = Okc_Api.G_MISS_DATE)

Line 3346: x_okl_trx_types_tl_rec.created_by := l_okl_trx_types_tl_rec.created_by;

3342: x_okl_trx_types_tl_rec.transaction_header_line_detail := l_okl_trx_types_tl_rec.transaction_header_line_detail;
3343: end if;
3344: if (x_okl_trx_types_tl_rec.created_by = Okc_Api.G_MISS_NUM)
3345: then
3346: x_okl_trx_types_tl_rec.created_by := l_okl_trx_types_tl_rec.created_by;
3347: end if;
3348: if (x_okl_trx_types_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
3349: then
3350: x_okl_trx_types_tl_rec.creation_date := l_okl_trx_types_tl_rec.creation_date;

Line 3348: if (x_okl_trx_types_tl_rec.creation_date = Okc_Api.G_MISS_DATE)

3344: if (x_okl_trx_types_tl_rec.created_by = Okc_Api.G_MISS_NUM)
3345: then
3346: x_okl_trx_types_tl_rec.created_by := l_okl_trx_types_tl_rec.created_by;
3347: end if;
3348: if (x_okl_trx_types_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
3349: then
3350: x_okl_trx_types_tl_rec.creation_date := l_okl_trx_types_tl_rec.creation_date;
3351: end if;
3352: if (x_okl_trx_types_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)

Line 3350: x_okl_trx_types_tl_rec.creation_date := l_okl_trx_types_tl_rec.creation_date;

3346: x_okl_trx_types_tl_rec.created_by := l_okl_trx_types_tl_rec.created_by;
3347: end if;
3348: if (x_okl_trx_types_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
3349: then
3350: x_okl_trx_types_tl_rec.creation_date := l_okl_trx_types_tl_rec.creation_date;
3351: end if;
3352: if (x_okl_trx_types_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
3353: then
3354: x_okl_trx_types_tl_rec.last_updated_by := l_okl_trx_types_tl_rec.last_updated_by;

Line 3352: if (x_okl_trx_types_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)

3348: if (x_okl_trx_types_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
3349: then
3350: x_okl_trx_types_tl_rec.creation_date := l_okl_trx_types_tl_rec.creation_date;
3351: end if;
3352: if (x_okl_trx_types_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
3353: then
3354: x_okl_trx_types_tl_rec.last_updated_by := l_okl_trx_types_tl_rec.last_updated_by;
3355: end if;
3356: if (x_okl_trx_types_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)

Line 3354: x_okl_trx_types_tl_rec.last_updated_by := l_okl_trx_types_tl_rec.last_updated_by;

3350: x_okl_trx_types_tl_rec.creation_date := l_okl_trx_types_tl_rec.creation_date;
3351: end if;
3352: if (x_okl_trx_types_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
3353: then
3354: x_okl_trx_types_tl_rec.last_updated_by := l_okl_trx_types_tl_rec.last_updated_by;
3355: end if;
3356: if (x_okl_trx_types_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
3357: then
3358: x_okl_trx_types_tl_rec.last_update_date := l_okl_trx_types_tl_rec.last_update_date;

Line 3356: if (x_okl_trx_types_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)

3352: if (x_okl_trx_types_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
3353: then
3354: x_okl_trx_types_tl_rec.last_updated_by := l_okl_trx_types_tl_rec.last_updated_by;
3355: end if;
3356: if (x_okl_trx_types_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
3357: then
3358: x_okl_trx_types_tl_rec.last_update_date := l_okl_trx_types_tl_rec.last_update_date;
3359: end if;
3360: if (x_okl_trx_types_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)

Line 3358: x_okl_trx_types_tl_rec.last_update_date := l_okl_trx_types_tl_rec.last_update_date;

3354: x_okl_trx_types_tl_rec.last_updated_by := l_okl_trx_types_tl_rec.last_updated_by;
3355: end if;
3356: if (x_okl_trx_types_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
3357: then
3358: x_okl_trx_types_tl_rec.last_update_date := l_okl_trx_types_tl_rec.last_update_date;
3359: end if;
3360: if (x_okl_trx_types_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)
3361: then
3362: x_okl_trx_types_tl_rec.last_update_login := l_okl_trx_types_tl_rec.last_update_login;

Line 3360: if (x_okl_trx_types_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)

3356: if (x_okl_trx_types_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
3357: then
3358: x_okl_trx_types_tl_rec.last_update_date := l_okl_trx_types_tl_rec.last_update_date;
3359: end if;
3360: if (x_okl_trx_types_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)
3361: then
3362: x_okl_trx_types_tl_rec.last_update_login := l_okl_trx_types_tl_rec.last_update_login;
3363: end if;
3364: return(l_return_status);

Line 3362: x_okl_trx_types_tl_rec.last_update_login := l_okl_trx_types_tl_rec.last_update_login;

3358: x_okl_trx_types_tl_rec.last_update_date := l_okl_trx_types_tl_rec.last_update_date;
3359: end if;
3360: if (x_okl_trx_types_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)
3361: then
3362: x_okl_trx_types_tl_rec.last_update_login := l_okl_trx_types_tl_rec.last_update_login;
3363: end if;
3364: return(l_return_status);
3365: end populate_new_record;
3366: -----------------------------------------

Line 3367: -- Set_Attributes for:OKL_TRX_TYPES_TL --

3363: end if;
3364: return(l_return_status);
3365: end populate_new_record;
3366: -----------------------------------------
3367: -- Set_Attributes for:OKL_TRX_TYPES_TL --
3368: -----------------------------------------
3369: function Set_Attributes (
3370: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
3371: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type

Line 3370: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,

3366: -----------------------------------------
3367: -- Set_Attributes for:OKL_TRX_TYPES_TL --
3368: -----------------------------------------
3369: function Set_Attributes (
3370: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
3371: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type
3372: ) return varchar2 is
3373: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3374: begin

Line 3371: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type

3367: -- Set_Attributes for:OKL_TRX_TYPES_TL --
3368: -----------------------------------------
3369: function Set_Attributes (
3370: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
3371: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type
3372: ) return varchar2 is
3373: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3374: begin
3375: x_okl_trx_types_tl_rec := p_okl_trx_types_tl_rec;

Line 3375: x_okl_trx_types_tl_rec := p_okl_trx_types_tl_rec;

3371: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type
3372: ) return varchar2 is
3373: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3374: begin
3375: x_okl_trx_types_tl_rec := p_okl_trx_types_tl_rec;
3376: x_okl_trx_types_tl_rec.language := USERENV('LANG');
3377: x_okl_trx_types_tl_rec.SOURCE_LANG := USERENV('LANG');
3378: return(l_return_status);
3379: end Set_Attributes;

Line 3376: x_okl_trx_types_tl_rec.language := USERENV('LANG');

3372: ) return varchar2 is
3373: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3374: begin
3375: x_okl_trx_types_tl_rec := p_okl_trx_types_tl_rec;
3376: x_okl_trx_types_tl_rec.language := USERENV('LANG');
3377: x_okl_trx_types_tl_rec.SOURCE_LANG := USERENV('LANG');
3378: return(l_return_status);
3379: end Set_Attributes;
3380: begin

Line 3377: x_okl_trx_types_tl_rec.SOURCE_LANG := USERENV('LANG');

3373: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3374: begin
3375: x_okl_trx_types_tl_rec := p_okl_trx_types_tl_rec;
3376: x_okl_trx_types_tl_rec.language := USERENV('LANG');
3377: x_okl_trx_types_tl_rec.SOURCE_LANG := USERENV('LANG');
3378: return(l_return_status);
3379: end Set_Attributes;
3380: begin
3381: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 3392: p_okl_trx_types_tl_rec, -- IN

3388: raise Okc_Api.G_EXCEPTION_ERROR;
3389: end if;
3390: --- Setting item attributes
3391: l_return_status := Set_Attributes(
3392: p_okl_trx_types_tl_rec, -- IN
3393: l_okl_trx_types_tl_rec); -- OUT
3394: --- If any errors happen abort API
3395: if (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) then
3396: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3393: l_okl_trx_types_tl_rec); -- OUT

3389: end if;
3390: --- Setting item attributes
3391: l_return_status := Set_Attributes(
3392: p_okl_trx_types_tl_rec, -- IN
3393: l_okl_trx_types_tl_rec); -- OUT
3394: --- If any errors happen abort API
3395: if (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) then
3396: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3397: elsif (l_return_status = Okc_Api.G_RET_STS_ERROR) then

Line 3400: l_return_status := populate_new_record(l_okl_trx_types_tl_rec, l_def_okl_trx_types_tl_rec);

3396: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3397: elsif (l_return_status = Okc_Api.G_RET_STS_ERROR) then
3398: raise Okc_Api.G_EXCEPTION_ERROR;
3399: end if;
3400: l_return_status := populate_new_record(l_okl_trx_types_tl_rec, l_def_okl_trx_types_tl_rec);
3401: if (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) then
3402: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3403: elsif (l_return_status = Okc_Api.G_RET_STS_ERROR) then
3404: raise Okc_Api.G_EXCEPTION_ERROR;

Line 3406: update OKL_TRX_TYPES_TL

3402: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3403: elsif (l_return_status = Okc_Api.G_RET_STS_ERROR) then
3404: raise Okc_Api.G_EXCEPTION_ERROR;
3405: end if;
3406: update OKL_TRX_TYPES_TL
3407: set name = l_def_okl_trx_types_tl_rec.name,
3408: DESCRIPTION = l_def_okl_trx_types_tl_rec.description,
3409: CONTRACT_HEADER_LINE_FLAG = l_def_okl_trx_types_tl_rec.contract_header_line_flag,
3410: TRANSACTION_HEADER_LINE_DETAIL = l_def_okl_trx_types_tl_rec.transaction_header_line_detail,

Line 3407: set name = l_def_okl_trx_types_tl_rec.name,

3403: elsif (l_return_status = Okc_Api.G_RET_STS_ERROR) then
3404: raise Okc_Api.G_EXCEPTION_ERROR;
3405: end if;
3406: update OKL_TRX_TYPES_TL
3407: set name = l_def_okl_trx_types_tl_rec.name,
3408: DESCRIPTION = l_def_okl_trx_types_tl_rec.description,
3409: CONTRACT_HEADER_LINE_FLAG = l_def_okl_trx_types_tl_rec.contract_header_line_flag,
3410: TRANSACTION_HEADER_LINE_DETAIL = l_def_okl_trx_types_tl_rec.transaction_header_line_detail,
3411: CREATED_BY = l_def_okl_trx_types_tl_rec.created_by,

Line 3408: DESCRIPTION = l_def_okl_trx_types_tl_rec.description,

3404: raise Okc_Api.G_EXCEPTION_ERROR;
3405: end if;
3406: update OKL_TRX_TYPES_TL
3407: set name = l_def_okl_trx_types_tl_rec.name,
3408: DESCRIPTION = l_def_okl_trx_types_tl_rec.description,
3409: CONTRACT_HEADER_LINE_FLAG = l_def_okl_trx_types_tl_rec.contract_header_line_flag,
3410: TRANSACTION_HEADER_LINE_DETAIL = l_def_okl_trx_types_tl_rec.transaction_header_line_detail,
3411: CREATED_BY = l_def_okl_trx_types_tl_rec.created_by,
3412: SOURCE_LANG = l_def_okl_trx_types_tl_rec.source_lang,

Line 3409: CONTRACT_HEADER_LINE_FLAG = l_def_okl_trx_types_tl_rec.contract_header_line_flag,

3405: end if;
3406: update OKL_TRX_TYPES_TL
3407: set name = l_def_okl_trx_types_tl_rec.name,
3408: DESCRIPTION = l_def_okl_trx_types_tl_rec.description,
3409: CONTRACT_HEADER_LINE_FLAG = l_def_okl_trx_types_tl_rec.contract_header_line_flag,
3410: TRANSACTION_HEADER_LINE_DETAIL = l_def_okl_trx_types_tl_rec.transaction_header_line_detail,
3411: CREATED_BY = l_def_okl_trx_types_tl_rec.created_by,
3412: SOURCE_LANG = l_def_okl_trx_types_tl_rec.source_lang,
3413: CREATION_DATE = l_def_okl_trx_types_tl_rec.creation_date,

Line 3410: TRANSACTION_HEADER_LINE_DETAIL = l_def_okl_trx_types_tl_rec.transaction_header_line_detail,

3406: update OKL_TRX_TYPES_TL
3407: set name = l_def_okl_trx_types_tl_rec.name,
3408: DESCRIPTION = l_def_okl_trx_types_tl_rec.description,
3409: CONTRACT_HEADER_LINE_FLAG = l_def_okl_trx_types_tl_rec.contract_header_line_flag,
3410: TRANSACTION_HEADER_LINE_DETAIL = l_def_okl_trx_types_tl_rec.transaction_header_line_detail,
3411: CREATED_BY = l_def_okl_trx_types_tl_rec.created_by,
3412: SOURCE_LANG = l_def_okl_trx_types_tl_rec.source_lang,
3413: CREATION_DATE = l_def_okl_trx_types_tl_rec.creation_date,
3414: LAST_UPDATED_BY = l_def_okl_trx_types_tl_rec.last_updated_by,

Line 3411: CREATED_BY = l_def_okl_trx_types_tl_rec.created_by,

3407: set name = l_def_okl_trx_types_tl_rec.name,
3408: DESCRIPTION = l_def_okl_trx_types_tl_rec.description,
3409: CONTRACT_HEADER_LINE_FLAG = l_def_okl_trx_types_tl_rec.contract_header_line_flag,
3410: TRANSACTION_HEADER_LINE_DETAIL = l_def_okl_trx_types_tl_rec.transaction_header_line_detail,
3411: CREATED_BY = l_def_okl_trx_types_tl_rec.created_by,
3412: SOURCE_LANG = l_def_okl_trx_types_tl_rec.source_lang,
3413: CREATION_DATE = l_def_okl_trx_types_tl_rec.creation_date,
3414: LAST_UPDATED_BY = l_def_okl_trx_types_tl_rec.last_updated_by,
3415: LAST_UPDATE_DATE = l_def_okl_trx_types_tl_rec.last_update_date,

Line 3412: SOURCE_LANG = l_def_okl_trx_types_tl_rec.source_lang,

3408: DESCRIPTION = l_def_okl_trx_types_tl_rec.description,
3409: CONTRACT_HEADER_LINE_FLAG = l_def_okl_trx_types_tl_rec.contract_header_line_flag,
3410: TRANSACTION_HEADER_LINE_DETAIL = l_def_okl_trx_types_tl_rec.transaction_header_line_detail,
3411: CREATED_BY = l_def_okl_trx_types_tl_rec.created_by,
3412: SOURCE_LANG = l_def_okl_trx_types_tl_rec.source_lang,
3413: CREATION_DATE = l_def_okl_trx_types_tl_rec.creation_date,
3414: LAST_UPDATED_BY = l_def_okl_trx_types_tl_rec.last_updated_by,
3415: LAST_UPDATE_DATE = l_def_okl_trx_types_tl_rec.last_update_date,
3416: LAST_UPDATE_LOGIN = l_def_okl_trx_types_tl_rec.last_update_login

Line 3413: CREATION_DATE = l_def_okl_trx_types_tl_rec.creation_date,

3409: CONTRACT_HEADER_LINE_FLAG = l_def_okl_trx_types_tl_rec.contract_header_line_flag,
3410: TRANSACTION_HEADER_LINE_DETAIL = l_def_okl_trx_types_tl_rec.transaction_header_line_detail,
3411: CREATED_BY = l_def_okl_trx_types_tl_rec.created_by,
3412: SOURCE_LANG = l_def_okl_trx_types_tl_rec.source_lang,
3413: CREATION_DATE = l_def_okl_trx_types_tl_rec.creation_date,
3414: LAST_UPDATED_BY = l_def_okl_trx_types_tl_rec.last_updated_by,
3415: LAST_UPDATE_DATE = l_def_okl_trx_types_tl_rec.last_update_date,
3416: LAST_UPDATE_LOGIN = l_def_okl_trx_types_tl_rec.last_update_login
3417: where ID = l_def_okl_trx_types_tl_rec.id

Line 3414: LAST_UPDATED_BY = l_def_okl_trx_types_tl_rec.last_updated_by,

3410: TRANSACTION_HEADER_LINE_DETAIL = l_def_okl_trx_types_tl_rec.transaction_header_line_detail,
3411: CREATED_BY = l_def_okl_trx_types_tl_rec.created_by,
3412: SOURCE_LANG = l_def_okl_trx_types_tl_rec.source_lang,
3413: CREATION_DATE = l_def_okl_trx_types_tl_rec.creation_date,
3414: LAST_UPDATED_BY = l_def_okl_trx_types_tl_rec.last_updated_by,
3415: LAST_UPDATE_DATE = l_def_okl_trx_types_tl_rec.last_update_date,
3416: LAST_UPDATE_LOGIN = l_def_okl_trx_types_tl_rec.last_update_login
3417: where ID = l_def_okl_trx_types_tl_rec.id
3418: and USERENV('LANG') in (SOURCE_LANG, language);

Line 3415: LAST_UPDATE_DATE = l_def_okl_trx_types_tl_rec.last_update_date,

3411: CREATED_BY = l_def_okl_trx_types_tl_rec.created_by,
3412: SOURCE_LANG = l_def_okl_trx_types_tl_rec.source_lang,
3413: CREATION_DATE = l_def_okl_trx_types_tl_rec.creation_date,
3414: LAST_UPDATED_BY = l_def_okl_trx_types_tl_rec.last_updated_by,
3415: LAST_UPDATE_DATE = l_def_okl_trx_types_tl_rec.last_update_date,
3416: LAST_UPDATE_LOGIN = l_def_okl_trx_types_tl_rec.last_update_login
3417: where ID = l_def_okl_trx_types_tl_rec.id
3418: and USERENV('LANG') in (SOURCE_LANG, language);
3419: -- AND SOURCE_LANG = USERENV('LANG');

Line 3416: LAST_UPDATE_LOGIN = l_def_okl_trx_types_tl_rec.last_update_login

3412: SOURCE_LANG = l_def_okl_trx_types_tl_rec.source_lang,
3413: CREATION_DATE = l_def_okl_trx_types_tl_rec.creation_date,
3414: LAST_UPDATED_BY = l_def_okl_trx_types_tl_rec.last_updated_by,
3415: LAST_UPDATE_DATE = l_def_okl_trx_types_tl_rec.last_update_date,
3416: LAST_UPDATE_LOGIN = l_def_okl_trx_types_tl_rec.last_update_login
3417: where ID = l_def_okl_trx_types_tl_rec.id
3418: and USERENV('LANG') in (SOURCE_LANG, language);
3419: -- AND SOURCE_LANG = USERENV('LANG');
3420:

Line 3417: where ID = l_def_okl_trx_types_tl_rec.id

3413: CREATION_DATE = l_def_okl_trx_types_tl_rec.creation_date,
3414: LAST_UPDATED_BY = l_def_okl_trx_types_tl_rec.last_updated_by,
3415: LAST_UPDATE_DATE = l_def_okl_trx_types_tl_rec.last_update_date,
3416: LAST_UPDATE_LOGIN = l_def_okl_trx_types_tl_rec.last_update_login
3417: where ID = l_def_okl_trx_types_tl_rec.id
3418: and USERENV('LANG') in (SOURCE_LANG, language);
3419: -- AND SOURCE_LANG = USERENV('LANG');
3420:
3421: update OKL_TRX_TYPES_TL

Line 3421: update OKL_TRX_TYPES_TL

3417: where ID = l_def_okl_trx_types_tl_rec.id
3418: and USERENV('LANG') in (SOURCE_LANG, language);
3419: -- AND SOURCE_LANG = USERENV('LANG');
3420:
3421: update OKL_TRX_TYPES_TL
3422: set SFWT_FLAG = 'Y'
3423: where ID = l_def_okl_trx_types_tl_rec.id
3424: and SOURCE_LANG <> USERENV('LANG');
3425:

Line 3423: where ID = l_def_okl_trx_types_tl_rec.id

3419: -- AND SOURCE_LANG = USERENV('LANG');
3420:
3421: update OKL_TRX_TYPES_TL
3422: set SFWT_FLAG = 'Y'
3423: where ID = l_def_okl_trx_types_tl_rec.id
3424: and SOURCE_LANG <> USERENV('LANG');
3425:
3426: x_okl_trx_types_tl_rec := l_def_okl_trx_types_tl_rec;
3427: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3426: x_okl_trx_types_tl_rec := l_def_okl_trx_types_tl_rec;

3422: set SFWT_FLAG = 'Y'
3423: where ID = l_def_okl_trx_types_tl_rec.id
3424: and SOURCE_LANG <> USERENV('LANG');
3425:
3426: x_okl_trx_types_tl_rec := l_def_okl_trx_types_tl_rec;
3427: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3428: exception
3429: when Okc_Api.G_EXCEPTION_ERROR then
3430: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

Line 3477: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;

3473: l_api_name constant varchar2(30) := 'V_update_row';
3474: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3475: l_tryv_rec tryv_rec_type := p_tryv_rec;
3476: l_def_tryv_rec tryv_rec_type;
3477: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
3478: lx_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
3479: l_try_rec try_rec_type;
3480: lx_try_rec try_rec_type;
3481: -------------------------------

Line 3478: lx_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;

3474: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3475: l_tryv_rec tryv_rec_type := p_tryv_rec;
3476: l_def_tryv_rec tryv_rec_type;
3477: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
3478: lx_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
3479: l_try_rec try_rec_type;
3480: lx_try_rec try_rec_type;
3481: -------------------------------
3482: -- FUNCTION fill_who_columns --

Line 3674: migrate(l_def_tryv_rec, l_okl_trx_types_tl_rec);

3670:
3671: --------------------------------------
3672: -- Move VIEW record to "Child" records
3673: --------------------------------------
3674: migrate(l_def_tryv_rec, l_okl_trx_types_tl_rec);
3675: migrate(l_def_tryv_rec, l_try_rec);
3676: --------------------------------------------
3677: -- Call the UPDATE_ROW for each child record
3678: --------------------------------------------

Line 3684: l_okl_trx_types_tl_rec,

3680: p_init_msg_list,
3681: x_return_status,
3682: x_msg_count,
3683: x_msg_data,
3684: l_okl_trx_types_tl_rec,
3685: lx_okl_trx_types_tl_rec
3686: );
3687: if (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) then
3688: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3685: lx_okl_trx_types_tl_rec

3681: x_return_status,
3682: x_msg_count,
3683: x_msg_data,
3684: l_okl_trx_types_tl_rec,
3685: lx_okl_trx_types_tl_rec
3686: );
3687: if (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) then
3688: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3689: elsif (x_return_status = Okc_Api.G_RET_STS_ERROR) then

Line 3692: migrate(lx_okl_trx_types_tl_rec, l_def_tryv_rec);

3688: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3689: elsif (x_return_status = Okc_Api.G_RET_STS_ERROR) then
3690: raise Okc_Api.G_EXCEPTION_ERROR;
3691: end if;
3692: migrate(lx_okl_trx_types_tl_rec, l_def_tryv_rec);
3693: update_row(
3694: p_init_msg_list,
3695: x_return_status,
3696: x_msg_count,

Line 3882: -- delete_row for:OKL_TRX_TYPES_TL --

3878: '_PVT'
3879: );
3880: end delete_row;
3881: -------------------------------------
3882: -- delete_row for:OKL_TRX_TYPES_TL --
3883: -------------------------------------
3884: procedure delete_row(
3885: p_init_msg_list in varchar2,
3886: x_return_status out NOCOPY varchar2,

Line 3889: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type) is

3885: p_init_msg_list in varchar2,
3886: x_return_status out NOCOPY varchar2,
3887: x_msg_count out NOCOPY number,
3888: x_msg_data out NOCOPY varchar2,
3889: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type) is
3890:
3891: l_api_version constant number := 1;
3892: l_api_name constant varchar2(30) := 'TL_delete_row';
3893: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 3894: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type:= p_okl_trx_types_tl_rec;

3890:
3891: l_api_version constant number := 1;
3892: l_api_name constant varchar2(30) := 'TL_delete_row';
3893: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3894: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type:= p_okl_trx_types_tl_rec;
3895: l_row_notfound boolean := true;
3896: -----------------------------------------
3897: -- Set_Attributes for:OKL_TRX_TYPES_TL --
3898: -----------------------------------------

Line 3897: -- Set_Attributes for:OKL_TRX_TYPES_TL --

3893: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3894: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type:= p_okl_trx_types_tl_rec;
3895: l_row_notfound boolean := true;
3896: -----------------------------------------
3897: -- Set_Attributes for:OKL_TRX_TYPES_TL --
3898: -----------------------------------------
3899: function Set_Attributes (
3900: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
3901: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type

Line 3900: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,

3896: -----------------------------------------
3897: -- Set_Attributes for:OKL_TRX_TYPES_TL --
3898: -----------------------------------------
3899: function Set_Attributes (
3900: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
3901: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type
3902: ) return varchar2 is
3903: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3904: begin

Line 3901: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type

3897: -- Set_Attributes for:OKL_TRX_TYPES_TL --
3898: -----------------------------------------
3899: function Set_Attributes (
3900: p_okl_trx_types_tl_rec in okl_trx_types_tl_rec_type,
3901: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type
3902: ) return varchar2 is
3903: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3904: begin
3905: x_okl_trx_types_tl_rec := p_okl_trx_types_tl_rec;

Line 3905: x_okl_trx_types_tl_rec := p_okl_trx_types_tl_rec;

3901: x_okl_trx_types_tl_rec out NOCOPY okl_trx_types_tl_rec_type
3902: ) return varchar2 is
3903: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3904: begin
3905: x_okl_trx_types_tl_rec := p_okl_trx_types_tl_rec;
3906: x_okl_trx_types_tl_rec.language := USERENV('LANG');
3907: return(l_return_status);
3908: end Set_Attributes;
3909: begin

Line 3906: x_okl_trx_types_tl_rec.language := USERENV('LANG');

3902: ) return varchar2 is
3903: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3904: begin
3905: x_okl_trx_types_tl_rec := p_okl_trx_types_tl_rec;
3906: x_okl_trx_types_tl_rec.language := USERENV('LANG');
3907: return(l_return_status);
3908: end Set_Attributes;
3909: begin
3910: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 3921: p_okl_trx_types_tl_rec, -- IN

3917: raise Okc_Api.G_EXCEPTION_ERROR;
3918: end if;
3919: --- Setting item attributes
3920: l_return_status := Set_Attributes(
3921: p_okl_trx_types_tl_rec, -- IN
3922: l_okl_trx_types_tl_rec); -- OUT
3923: --- If any errors happen abort API
3924: if (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) then
3925: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3922: l_okl_trx_types_tl_rec); -- OUT

3918: end if;
3919: --- Setting item attributes
3920: l_return_status := Set_Attributes(
3921: p_okl_trx_types_tl_rec, -- IN
3922: l_okl_trx_types_tl_rec); -- OUT
3923: --- If any errors happen abort API
3924: if (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) then
3925: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3926: elsif (l_return_status = Okc_Api.G_RET_STS_ERROR) then

Line 3929: delete from OKL_TRX_TYPES_TL

3925: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3926: elsif (l_return_status = Okc_Api.G_RET_STS_ERROR) then
3927: raise Okc_Api.G_EXCEPTION_ERROR;
3928: end if;
3929: delete from OKL_TRX_TYPES_TL
3930: where ID = l_okl_trx_types_tl_rec.id;
3931:
3932: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3933: exception

Line 3930: where ID = l_okl_trx_types_tl_rec.id;

3926: elsif (l_return_status = Okc_Api.G_RET_STS_ERROR) then
3927: raise Okc_Api.G_EXCEPTION_ERROR;
3928: end if;
3929: delete from OKL_TRX_TYPES_TL
3930: where ID = l_okl_trx_types_tl_rec.id;
3931:
3932: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3933: exception
3934: when Okc_Api.G_EXCEPTION_ERROR then

Line 3980: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;

3976: l_api_version constant number := 1;
3977: l_api_name constant varchar2(30) := 'V_delete_row';
3978: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
3979: l_tryv_rec tryv_rec_type := p_tryv_rec;
3980: l_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
3981: l_try_rec try_rec_type;
3982: begin
3983: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
3984: G_PKG_NAME,

Line 3998: migrate(l_tryv_rec, l_okl_trx_types_tl_rec);

3994: end if;
3995: --------------------------------------
3996: -- Move VIEW record to "Child" records
3997: --------------------------------------
3998: migrate(l_tryv_rec, l_okl_trx_types_tl_rec);
3999: migrate(l_tryv_rec, l_try_rec);
4000: --------------------------------------------
4001: -- Call the DELETE_ROW for each child record
4002: --------------------------------------------

Line 4008: l_okl_trx_types_tl_rec

4004: p_init_msg_list,
4005: x_return_status,
4006: x_msg_count,
4007: x_msg_data,
4008: l_okl_trx_types_tl_rec
4009: );
4010: if (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) then
4011: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4012: elsif (x_return_status = Okc_Api.G_RET_STS_ERROR) then

Line 4157: FROM OKL_TRX_TYPES_TL

4153: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
4154:
4155: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
4156: INTO db_luby, db_ludate
4157: FROM OKL_TRX_TYPES_TL
4158: where ID = to_number(p_tryv_rec.id)
4159: and USERENV('LANG') =language;
4160:
4161: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 4163: UPDATE OKL_TRX_TYPES_TL

4159: and USERENV('LANG') =language;
4160:
4161: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
4162: db_ludate, '')) then
4163: UPDATE OKL_TRX_TYPES_TL
4164: SET
4165: NAME = p_tryv_rec.name,
4166: DESCRIPTION = p_tryv_rec.description,
4167: LAST_UPDATE_DATE = f_ludate,

Line 4227: UPDATE OKL_TRX_TYPES_TL

4223: ACCOUNTING_EVENT_CLASS_CODE = p_tryv_rec.accounting_event_class_code
4224: WHERE ID = to_number(p_tryv_rec.id);
4225:
4226: --Update _TL
4227: UPDATE OKL_TRX_TYPES_TL
4228: SET
4229: DESCRIPTION = p_tryv_rec.DESCRIPTION,
4230: NAME = p_tryv_rec.NAME,
4231: LAST_UPDATE_DATE = f_ludate,

Line 4240: INSERT INTO OKL_TRX_TYPES_TL

4236: AND USERENV('LANG') IN (language,source_lang);
4237:
4238: IF(sql%notfound) THEN
4239:
4240: INSERT INTO OKL_TRX_TYPES_TL
4241: (ID,
4242: LANGUAGE,
4243: SOURCE_LANG,
4244: SFWT_FLAG,

Line 4272: from OKL_TRX_TYPES_TL TL

4268: from FND_LANGUAGES L
4269: where L.INSTALLED_FLAG IN ('I','B')
4270: and not exists
4271: ( SELECT NULL
4272: from OKL_TRX_TYPES_TL TL
4273: where TL.ID = TO_NUMBER(p_tryv_rec.id)
4274: and TL.LANGUAGE = L.LANGUAGE_CODE);
4275:
4276: END IF;

Line 4329: INSERT INTO OKL_TRX_TYPES_TL

4325: --Bug 5707866 dpsingh
4326: p_tryv_rec.FORMULA_YN,
4327: p_tryv_rec.ACCOUNTING_EVENT_CLASS_CODE);
4328:
4329: INSERT INTO OKL_TRX_TYPES_TL
4330: (
4331: ID,
4332: LANGUAGE,
4333: SOURCE_LANG,

Line 4362: FROM OKL_TRX_TYPES_TL TL

4358: FROM FND_LANGUAGES L
4359: WHERE L.INSTALLED_FLAG IN ('I','B')
4360: AND NOT EXISTS
4361: (SELECT NULL
4362: FROM OKL_TRX_TYPES_TL TL
4363: WHERE TL.ID = TO_NUMBER(p_tryv_rec.ID)
4364: AND TL.LANGUAGE = L.LANGUAGE_CODE);
4365:
4366: END LOAD_ROW;