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.FA_XLA_EVENTS_PVT dependencies on XLA_EVENTS

Line 1: package body FA_XLA_EVENTS_PVT as

1: package body FA_XLA_EVENTS_PVT as
2: /* $Header: faeventb.pls 120.30.12020000.4 2012/12/04 18:35:05 spooyath ship $ */
3:
4: FUNCTION create_transaction_event
5: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

Line 12: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;

8: p_event_status IN VARCHAR2 DEFAULT NULL,
9: p_calling_fn IN VARCHAR2,
10: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
11:
12: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
13: l_security_context XLA_EVENTS_PUB_PKG.t_security;
14:
15: l_event_type_code varchar2(30) ;
16: l_event_date date := px_trans_rec.transaction_date_entered;

Line 13: l_security_context XLA_EVENTS_PUB_PKG.t_security;

9: p_calling_fn IN VARCHAR2,
10: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
11:
12: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
13: l_security_context XLA_EVENTS_PUB_PKG.t_security;
14:
15: l_event_type_code varchar2(30) ;
16: l_event_date date := px_trans_rec.transaction_date_entered;
17: l_event_status varchar2(30) ;

Line 20: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.create_trx_event';

16: l_event_date date := px_trans_rec.transaction_date_entered;
17: l_event_status varchar2(30) ;
18: l_valuation_method varchar2(30) := p_asset_hdr_rec.book_type_code;
19:
20: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.create_trx_event';
21:
22: invalid_calling_fn exception;
23: invalid_event_status exception;
24:

Line 95: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then

91:
92: -- set the status correctly
93: -- only retirements / reinstatements should use incomplete
94: if (p_event_status is null or
95: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
96: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
97: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
98: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
99: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then

Line 96: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;

92: -- set the status correctly
93: -- only retirements / reinstatements should use incomplete
94: if (p_event_status is null or
95: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
96: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
97: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
98: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
99: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
100: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;

Line 97: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then

93: -- only retirements / reinstatements should use incomplete
94: if (p_event_status is null or
95: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
96: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
97: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
98: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
99: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
100: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;
101: else

Line 98: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;

94: if (p_event_status is null or
95: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
96: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
97: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
98: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
99: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
100: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;
101: else
102: -- invalid type

Line 99: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then

95: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
96: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
97: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
98: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
99: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
100: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;
101: else
102: -- invalid type
103: raise invalid_event_status;

Line 100: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;

96: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
97: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
98: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
99: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
100: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;
101: else
102: -- invalid type
103: raise invalid_event_status;
104: end if;

Line 133: XLA_EVENTS_PUB_PKG.create_event

129: end if;
130:
131: -- Call XLA API
132: px_trans_rec.event_id :=
133: XLA_EVENTS_PUB_PKG.create_event
134: (p_event_source_info => l_trx_source_info,
135: p_event_type_code => l_event_type_code,
136: p_event_date => l_event_date,
137: p_event_status_code => l_event_status,

Line 182: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;

178: p_event_status IN VARCHAR2 DEFAULT NULL,
179: p_calling_fn IN VARCHAR2,
180: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean is
181:
182: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
183: l_security_context XLA_EVENTS_PUB_PKG.t_security;
184:
185: l_event_type_code varchar2(30) ;
186: l_event_date date := px_trans_rec_src.transaction_date_entered;

Line 183: l_security_context XLA_EVENTS_PUB_PKG.t_security;

179: p_calling_fn IN VARCHAR2,
180: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean is
181:
182: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
183: l_security_context XLA_EVENTS_PUB_PKG.t_security;
184:
185: l_event_type_code varchar2(30) ;
186: l_event_date date := px_trans_rec_src.transaction_date_entered;
187: l_event_status varchar2(30) ;

Line 190: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.create_dual_trx_event';

186: l_event_date date := px_trans_rec_src.transaction_date_entered;
187: l_event_status varchar2(30) ;
188: l_valuation_method varchar2(30) := p_asset_hdr_rec_src.book_type_code;
189:
190: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.create_dual_trx_event';
191:
192: invalid_calling_fn exception;
193: invalid_event_status exception;
194:

Line 230: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then

226:
227: -- set the status correctly
228: -- only retirements / reinstatements should use incomplete
229: if (p_event_status is null or
230: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
231: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
232: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
233: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
234: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then

Line 231: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;

227: -- set the status correctly
228: -- only retirements / reinstatements should use incomplete
229: if (p_event_status is null or
230: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
231: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
232: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
233: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
234: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
235: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;

Line 232: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then

228: -- only retirements / reinstatements should use incomplete
229: if (p_event_status is null or
230: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
231: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
232: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
233: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
234: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
235: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;
236: else

Line 233: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;

229: if (p_event_status is null or
230: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
231: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
232: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
233: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
234: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
235: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;
236: else
237: -- invalid type

Line 234: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then

230: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
231: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
232: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
233: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
234: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
235: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;
236: else
237: -- invalid type
238: raise invalid_event_status;

Line 235: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;

231: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
232: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
233: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
234: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
235: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;
236: else
237: -- invalid type
238: raise invalid_event_status;
239: end if;

Line 246: XLA_EVENTS_PUB_PKG.create_event

242: fa_cache_pkg.fazcdp_record.calendar_period_open_date);
243:
244: -- Call XLA API
245: px_trans_rec_src.event_id :=
246: XLA_EVENTS_PUB_PKG.create_event
247: (p_event_source_info => l_trx_source_info,
248: p_event_type_code => l_event_type_code,
249: p_event_date => l_event_date,
250: p_event_status_code => l_event_status,

Line 295: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;

291: x_event_id OUT NOCOPY number,
292: p_calling_fn IN VARCHAR2,
293: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
294:
295: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
296: l_security_context XLA_EVENTS_PUB_PKG.t_security;
297:
298: l_event_type_code varchar2(30) ;
299: l_event_date date := p_period_close_date;

Line 296: l_security_context XLA_EVENTS_PUB_PKG.t_security;

292: p_calling_fn IN VARCHAR2,
293: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
294:
295: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
296: l_security_context XLA_EVENTS_PUB_PKG.t_security;
297:
298: l_event_type_code varchar2(30) ;
299: l_event_date date := p_period_close_date;
300: l_event_status varchar2(30) ;

Line 303: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.create_deprn_event';

299: l_event_date date := p_period_close_date;
300: l_event_status varchar2(30) ;
301: l_valuation_method varchar2(30) := p_book_type_code;
302:
303: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.create_deprn_event';
304:
305: BEGIN
306:
307: l_deprn_source_info.application_id := 140;

Line 319: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;

315: -- based on calling interface and other factors
316:
317: l_deprn_source_info.entity_type_code := 'DEPRECIATION';
318:
319: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
320:
321: -- ER 14644811 : This function will be called from
322: -- FA_DEPRN_EVENTS_PKG.process_single_deprn_event
323:

Line 332: XLA_EVENTS_PUB_PKG.create_event

328: end if;
329:
330: -- Call XLA API
331: x_event_id :=
332: XLA_EVENTS_PUB_PKG.create_event
333: (p_event_source_info => l_deprn_source_info,
334: p_event_type_code => l_event_type_code,
335: p_event_date => l_event_date,
336: p_event_status_code => l_event_status,

Line 373: l_entity_event_info_tbl_in xla_events_pub_pkg.t_array_entity_event_info_s;

369: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
370:
371: l_legal_entity_id number;
372:
373: l_entity_event_info_tbl_in xla_events_pub_pkg.t_array_entity_event_info_s;
374: l_entity_event_info_tbl_out xla_events_pub_pkg.t_array_entity_event_info_s;
375:
376: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.create_bulk_deprn_event';
377:

Line 374: l_entity_event_info_tbl_out xla_events_pub_pkg.t_array_entity_event_info_s;

370:
371: l_legal_entity_id number;
372:
373: l_entity_event_info_tbl_in xla_events_pub_pkg.t_array_entity_event_info_s;
374: l_entity_event_info_tbl_out xla_events_pub_pkg.t_array_entity_event_info_s;
375:
376: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.create_bulk_deprn_event';
377:
378: l_dummy_number number_tbl_type;

Line 376: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.create_bulk_deprn_event';

372:
373: l_entity_event_info_tbl_in xla_events_pub_pkg.t_array_entity_event_info_s;
374: l_entity_event_info_tbl_out xla_events_pub_pkg.t_array_entity_event_info_s;
375:
376: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.create_bulk_deprn_event';
377:
378: l_dummy_number number_tbl_type;
379:
380: BEGIN

Line 390: insert into xla_events_int_gt

386: -- load the array as required by SLA:
387: -- verify event number and transaction number relevance here
388: -- since neither table uses a transaction sequence
389: forall i in 1..p_asset_id_tbl.count
390: insert into xla_events_int_gt
391: (APPLICATION_ID ,
392: LEDGER_ID ,
393: LEGAL_ENTITY_ID ,
394: ENTITY_CODE ,

Line 414: XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,

410: p_entity_type_code ,
411: 'DEPRECIATION' ,
412: p_period_close_date ,
413: l_dummy_number(i) ,
414: XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,
415: l_dummy_number(i) ,
416: p_asset_id_tbl(i) ,
417: p_book_type_code ,
418: p_period_counter ,

Line 423: XLA_EVENTS_PUB_PKG.create_bulk_events

419: p_deprn_run_id ,
420: p_book_type_code
421: );
422:
423: XLA_EVENTS_PUB_PKG.create_bulk_events
424: (p_source_application_id => 140,
425: p_application_id => 140,
426: p_legal_entity_id => l_legal_entity_id,
427: p_ledger_id => nvl(p_secondary_sob_id,fa_cache_pkg.fazcbc_record.set_of_books_id),

Line 433: from xla_events_int_gt

429: );
430:
431: select event_id bulk collect
432: into x_event_id_tbl
433: from xla_events_int_gt
434: where source_id_int_3 = p_deprn_run_id
435: order by event_number;
436:
437: EXCEPTION

Line 470: l_entity_event_info_tbl_in xla_events_pub_pkg.t_array_entity_event_info_s;

466:
467: l_dummy_number number_tbl_type;
468: l_legal_entity_id number;
469:
470: l_entity_event_info_tbl_in xla_events_pub_pkg.t_array_entity_event_info_s;
471: l_entity_event_info_tbl_out xla_events_pub_pkg.t_array_entity_event_info_s;
472:
473: --Secondary Changes
474: l_sob_id number;

Line 471: l_entity_event_info_tbl_out xla_events_pub_pkg.t_array_entity_event_info_s;

467: l_dummy_number number_tbl_type;
468: l_legal_entity_id number;
469:
470: l_entity_event_info_tbl_in xla_events_pub_pkg.t_array_entity_event_info_s;
471: l_entity_event_info_tbl_out xla_events_pub_pkg.t_array_entity_event_info_s;
472:
473: --Secondary Changes
474: l_sob_id number;
475:

Line 476: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.create_bulk_deferred_event';

472:
473: --Secondary Changes
474: l_sob_id number;
475:
476: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.create_bulk_deferred_event';
477:
478: BEGIN
479:
480: for i in 1..p_asset_id_tbl.count loop

Line 495: insert into xla_events_int_gt

491: -- load the array as required by SLA:
492: -- verify event number and transaction number relevance here
493: -- since neither table uses a transaction sequence
494: forall i in 1..p_asset_id_tbl.count
495: insert into xla_events_int_gt
496: (APPLICATION_ID ,
497: LEDGER_ID ,
498: LEGAL_ENTITY_ID ,
499: ENTITY_CODE ,

Line 519: XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,

515: p_entity_type_code ,
516: 'DEFERRED_DEPRECIATION' ,
517: p_period_close_date ,
518: l_dummy_number(i) ,
519: XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,
520: l_dummy_number(i) ,
521: p_asset_id_tbl(i) ,
522: p_corp_book ,
523: p_tax_book ,

Line 528: XLA_EVENTS_PUB_PKG.create_bulk_events

524: p_corp_period_counter,
525: p_corp_book
526: );
527:
528: XLA_EVENTS_PUB_PKG.create_bulk_events
529: (p_source_application_id => 140,
530: p_application_id => 140,
531: p_legal_entity_id => l_legal_entity_id,
532: p_ledger_id => fa_cache_pkg.fazcbc_record.set_of_books_id,

Line 538: from xla_events_int_gt

534: );
535:
536: select event_id bulk collect
537: into x_event_id_tbl
538: from xla_events_int_gt
539: order by event_number;
540:
541:
542: EXCEPTION

Line 558: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

554:
555: /*
556:
557: PROCEDURE update_event_status
558: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
559: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
560: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
561: ,p_event_date IN DATE DEFAULT NULL
562: ,p_event_status_code IN VARCHAR2

Line 564: ,p_security_context IN xla_events_pub_pkg.t_security

560: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
561: ,p_event_date IN DATE DEFAULT NULL
562: ,p_event_status_code IN VARCHAR2
563: ,p_valuation_method IN VARCHAR2
564: ,p_security_context IN xla_events_pub_pkg.t_security
565:
566: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
567:
568: */

Line 582: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;

578: p_secondary_sob_id IN number default null,
579: p_calling_fn IN VARCHAR2,
580: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
581:
582: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
583: l_security_context XLA_EVENTS_PUB_PKG.t_security;
584: l_event_type varchar2(30);
585: l_event_id number;
586: l_event_date date;

Line 583: l_security_context XLA_EVENTS_PUB_PKG.t_security;

579: p_calling_fn IN VARCHAR2,
580: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
581:
582: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
583: l_security_context XLA_EVENTS_PUB_PKG.t_security;
584: l_event_type varchar2(30);
585: l_event_id number;
586: l_event_date date;
587:

Line 588: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.update_transaction_event';

584: l_event_type varchar2(30);
585: l_event_id number;
586: l_event_date date;
587:
588: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.update_transaction_event';
589:
590: begin
591:
592: l_trx_source_info.application_id := 140;

Line 602: from xla_events xeve,

598: -- Secondary Ledger changes
599: if (p_secondary_flag) then
600: select event_id
601: into l_event_id
602: from xla_events xeve,
603: xla_transaction_entities xent
604: where xeve.application_id = 140
605: and xeve.event_type_code = p_event_type_code
606: and xent.application_id = xeve.application_id

Line 621: XLA_EVENTS_PUB_PKG.update_event

617:
618: l_event_date := greatest(p_event_date,
619: fa_cache_pkg.fazcdp_record.calendar_period_open_date);
620:
621: XLA_EVENTS_PUB_PKG.update_event
622: (p_event_source_info => l_trx_source_info,
623: p_event_id => l_event_id,
624: p_event_type_code => p_event_type_code,
625: p_event_date => l_event_date,

Line 652: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;

648: p_calling_fn IN VARCHAR2,
649: p_log_level_rec in fa_api_types.log_level_rec_type default null
650: ) return boolean is
651:
652: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
653: l_security_context XLA_EVENTS_PUB_PKG.t_security;
654: l_event_type varchar2(30);
655: l_event_id number;
656:

Line 653: l_security_context XLA_EVENTS_PUB_PKG.t_security;

649: p_log_level_rec in fa_api_types.log_level_rec_type default null
650: ) return boolean is
651:
652: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
653: l_security_context XLA_EVENTS_PUB_PKG.t_security;
654: l_event_type varchar2(30);
655: l_event_id number;
656:
657: l_destination_trx_header_id number;--Secondary Change

Line 659: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.update_inter_transaction_event';

655: l_event_id number;
656:
657: l_destination_trx_header_id number;--Secondary Change
658:
659: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.update_inter_transaction_event';
660:
661: begin
662:
663: l_trx_source_info.application_id := 140;

Line 679: from xla_events xeve,

675: if (p_is_secondary_ledger) then
676:
677: select event_id
678: into l_event_id
679: from xla_events xeve,
680: xla_transaction_entities xent
681: where xeve.application_id = 140
682: and xeve.event_type_code in ('SOURCE_LINE_TRANSFERS', 'CIP_SOURCE_LINE_TRANSFERS')
683: and xent.application_id = xeve.application_id

Line 689: XLA_EVENTS_PUB_PKG.update_event

685: and source_id_int_1 = l_destination_trx_header_id; --need to check. Secondary Changes
686:
687: end if;
688:
689: XLA_EVENTS_PUB_PKG.update_event
690: (p_event_source_info => l_trx_source_info,
691: p_event_id => l_event_id,
692: p_event_type_code => p_event_type_code,
693: p_event_date => p_event_date,

Line 722: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;

718: p_calling_fn IN VARCHAR2,
719: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
720:
721: l_event_id NUMBER;
722: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
723: l_security_context XLA_EVENTS_PUB_PKG.t_security;
724: l_result integer;
725:
726: --Secondary Changes

Line 723: l_security_context XLA_EVENTS_PUB_PKG.t_security;

719: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
720:
721: l_event_id NUMBER;
722: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
723: l_security_context XLA_EVENTS_PUB_PKG.t_security;
724: l_result integer;
725:
726: --Secondary Changes
727: l_event_type_code varchar2(30) ;

Line 729: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.delete_transaction_event';

725:
726: --Secondary Changes
727: l_event_type_code varchar2(30) ;
728:
729: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.delete_transaction_event';
730:
731: BEGIN
732:
733: l_trx_source_info.application_id := 140;

Line 752: from xla_events xeve,

748:
749: if (p_calling_fn = 'fa_ret_pub.undo_all_books_reinstatement.secondary') then
750: select event_id
751: into l_event_id
752: from xla_events xeve,
753: xla_transaction_entities xent
754: where xeve.application_id = 140
755: and xeve.event_type_code = 'REINSTATEMENTS'
756: and xent.application_id = xeve.application_id

Line 765: from xla_events xeve,

761:
762: elsif (p_calling_fn = 'fa_ret_pub.undo_all_books_retirement.secondary') then
763: select event_id
764: into l_event_id
765: from xla_events xeve,
766: xla_transaction_entities xent
767: where xeve.application_id = 140
768: and xeve.event_type_code = 'RETIREMENTS'
769: and xent.application_id = xeve.application_id

Line 784: from xla_events xeve,

780: end if;
781:
782: select event_id
783: into l_event_id
784: from xla_events xeve,
785: xla_transaction_entities xent
786: where xeve.application_id = 140
787: and xeve.event_type_code = 'CAPITALIZATION'
788: and xent.application_id = xeve.application_id

Line 803: XLA_EVENTS_PUB_PKG.delete_event

799: end if;
800:
801: If (nvl(p_asset_type,'XX') <> 'EXPENSED') then
802:
803: XLA_EVENTS_PUB_PKG.delete_event
804: (p_event_source_info => l_trx_source_info,
805: p_event_id => l_event_id,
806: p_valuation_method => p_book_type_code,
807: p_security_context => l_security_context);

Line 810: l_result := XLA_EVENTS_PUB_PKG.delete_entity

806: p_valuation_method => p_book_type_code,
807: p_security_context => l_security_context);
808:
809: BEGIN
810: l_result := XLA_EVENTS_PUB_PKG.delete_entity
811: (p_source_info => l_trx_source_info,
812: p_valuation_method => p_book_type_code,
813: p_security_context => l_security_context);
814:

Line 845: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;

841: p_calling_fn IN VARCHAR2,
842: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
843:
844: l_event_id NUMBER;
845: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
846: l_security_context XLA_EVENTS_PUB_PKG.t_security;
847: l_result integer;
848:
849: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.delete_deprn_event';

Line 846: l_security_context XLA_EVENTS_PUB_PKG.t_security;

842: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
843:
844: l_event_id NUMBER;
845: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
846: l_security_context XLA_EVENTS_PUB_PKG.t_security;
847: l_result integer;
848:
849: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.delete_deprn_event';
850:

Line 849: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.delete_deprn_event';

845: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
846: l_security_context XLA_EVENTS_PUB_PKG.t_security;
847: l_result integer;
848:
849: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.delete_deprn_event';
850:
851: BEGIN
852:
853: l_deprn_source_info.application_id := 140;

Line 861: XLA_EVENTS_PUB_PKG.delete_event

857: l_deprn_source_info.source_id_int_2 := p_period_counter;
858: l_deprn_source_info.source_id_int_3 := p_deprn_run_id;
859: l_deprn_source_info.entity_type_code := 'DEPRECIATION';
860:
861: XLA_EVENTS_PUB_PKG.delete_event
862: (p_event_source_info => l_deprn_source_info,
863: p_event_id => p_event_id,
864: p_valuation_method => p_book_type_code,
865: p_security_context => l_security_context);

Line 869: l_result := XLA_EVENTS_PUB_PKG.delete_entity

865: p_security_context => l_security_context);
866:
867: --6702657
868: BEGIN
869: l_result := XLA_EVENTS_PUB_PKG.delete_entity
870: (p_source_info => l_deprn_source_info,
871: p_valuation_method => p_book_type_code,
872: p_security_context => l_security_context);
873:

Line 898: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.get_event_type';

894: x_event_type_code OUT NOCOPY VARCHAR2,
895: p_log_level_rec in fa_api_types.log_level_rec_type default null
896: ) return boolean IS
897:
898: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.get_event_type';
899:
900: BEGIN
901:
902: select event_type_code

Line 904: from xla_events

900: BEGIN
901:
902: select event_type_code
903: into x_event_type_code
904: from xla_events
905: where application_id = 140
906: and event_id = p_event_id;
907:
908: return true;

Line 928: l_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;

924: ,x_event_status OUT NOCOPY varchar2
925: ,p_log_level_rec in fa_api_types.log_level_rec_type default null
926: ) return boolean IS
927:
928: l_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
929: l_security_context XLA_EVENTS_PUB_PKG.t_security;
930:
931: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.get_trx_event_status';
932:

Line 929: l_security_context XLA_EVENTS_PUB_PKG.t_security;

925: ,p_log_level_rec in fa_api_types.log_level_rec_type default null
926: ) return boolean IS
927:
928: l_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
929: l_security_context XLA_EVENTS_PUB_PKG.t_security;
930:
931: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.get_trx_event_status';
932:
933: BEGIN

Line 931: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.get_trx_event_status';

927:
928: l_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
929: l_security_context XLA_EVENTS_PUB_PKG.t_security;
930:
931: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.get_trx_event_status';
932:
933: BEGIN
934:
935: l_source_info.application_id := 140;

Line 947: x_event_status := XLA_EVENTS_PUB_PKG.get_event_status

943: ,p_log_level_rec => p_log_level_rec);
944: end if;
945:
946: -- check the event status
947: x_event_status := XLA_EVENTS_PUB_PKG.get_event_status
948: (p_event_source_info => l_source_info,
949: p_event_id => p_event_id,
950: p_valuation_method => p_book_type_code,
951: p_security_context => l_security_context);

Line 1014: from xla_events xeve,

1010: begin
1011:
1012: select event_id
1013: into l_secondary_cap_event_id
1014: from xla_events xeve,
1015: xla_transaction_entities xent
1016: where xeve.application_id = 140
1017: and xeve.event_type_code = 'CAPITALIZATION'
1018: and xent.application_id = xeve.application_id

Line 1065: from xla_events xeve,

1061: p_source_id_int_3 := l_secondary_deprn_run_id;
1062:
1063: select event_id
1064: into l_secondary_event_id
1065: from xla_events xeve,
1066: xla_transaction_entities xent
1067: where xeve.application_id = 140
1068: and xeve.event_type_code = 'DEPRECIATION'
1069: and xent.application_id = xeve.application_id

Line 1085: end FA_XLA_EVENTS_PVT;

1081: return l_secondary_event_id;
1082:
1083: end get_secondary_event_id;
1084:
1085: end FA_XLA_EVENTS_PVT;