10: p_event_status IN VARCHAR2 DEFAULT NULL,
11: p_calling_fn IN VARCHAR2,
12: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
13:
14: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
15: l_security_context XLA_EVENTS_PUB_PKG.t_security;
16:
17: l_event_type_code varchar2(30) ;
18: l_event_date date := px_trans_rec.transaction_date_entered;
11: p_calling_fn IN VARCHAR2,
12: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
13:
14: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
15: l_security_context XLA_EVENTS_PUB_PKG.t_security;
16:
17: l_event_type_code varchar2(30) ;
18: l_event_date date := px_trans_rec.transaction_date_entered;
19: l_event_status varchar2(30) ;
88:
89: -- set the status correctly
90: -- only retirements / reinstatements should use incomplete
91: if (p_event_status is null or
92: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
93: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
94: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
95: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
96: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
89: -- set the status correctly
90: -- only retirements / reinstatements should use incomplete
91: if (p_event_status is null or
92: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
93: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
94: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
95: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
96: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
97: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;
90: -- only retirements / reinstatements should use incomplete
91: if (p_event_status is null or
92: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
93: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
94: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
95: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
96: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
97: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;
98: else
91: if (p_event_status is null or
92: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
93: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
94: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
95: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
96: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
97: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;
98: else
99: -- invalid type
92: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
93: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
94: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
95: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
96: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
97: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;
98: else
99: -- invalid type
100: raise invalid_event_status;
93: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
94: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
95: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
96: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
97: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;
98: else
99: -- invalid type
100: raise invalid_event_status;
101: end if;
127: end if;
128:
129: -- Call XLA API
130: px_trans_rec.event_id :=
131: XLA_EVENTS_PUB_PKG.create_event
132: (p_event_source_info => l_trx_source_info,
133: p_event_type_code => l_event_type_code,
134: p_event_date => l_event_date,
135: p_event_status_code => l_event_status,
176: p_event_status IN VARCHAR2 DEFAULT NULL,
177: p_calling_fn IN VARCHAR2,
178: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean is
179:
180: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
181: l_security_context XLA_EVENTS_PUB_PKG.t_security;
182:
183: l_event_type_code varchar2(30) ;
184: l_event_date date := px_trans_rec_src.transaction_date_entered;
177: p_calling_fn IN VARCHAR2,
178: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean is
179:
180: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
181: l_security_context XLA_EVENTS_PUB_PKG.t_security;
182:
183: l_event_type_code varchar2(30) ;
184: l_event_date date := px_trans_rec_src.transaction_date_entered;
185: l_event_status varchar2(30) ;
224:
225: -- set the status correctly
226: -- only retirements / reinstatements should use incomplete
227: if (p_event_status is null or
228: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
229: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
230: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
231: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
232: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
225: -- set the status correctly
226: -- only retirements / reinstatements should use incomplete
227: if (p_event_status is null or
228: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
229: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
230: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
231: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
232: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
233: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;
226: -- only retirements / reinstatements should use incomplete
227: if (p_event_status is null or
228: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
229: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
230: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
231: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
232: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
233: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;
234: else
227: if (p_event_status is null or
228: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
229: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
230: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
231: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
232: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
233: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;
234: else
235: -- invalid type
228: p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
229: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
230: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
231: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
232: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
233: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;
234: else
235: -- invalid type
236: raise invalid_event_status;
229: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
230: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE) then
231: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE;
232: elsif (p_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION) then
233: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION;
234: else
235: -- invalid type
236: raise invalid_event_status;
237: end if;
240: fa_cache_pkg.fazcdp_record.calendar_period_open_date);
241:
242: -- Call XLA API
243: px_trans_rec_src.event_id :=
244: XLA_EVENTS_PUB_PKG.create_event
245: (p_event_source_info => l_trx_source_info,
246: p_event_type_code => l_event_type_code,
247: p_event_date => l_event_date,
248: p_event_status_code => l_event_status,
289: x_event_id OUT NOCOPY number,
290: p_calling_fn IN VARCHAR2,
291: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
292:
293: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
294: l_security_context XLA_EVENTS_PUB_PKG.t_security;
295:
296: l_event_type_code varchar2(30) ;
297: l_event_date date := p_period_close_date;
290: p_calling_fn IN VARCHAR2,
291: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
292:
293: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
294: l_security_context XLA_EVENTS_PUB_PKG.t_security;
295:
296: l_event_type_code varchar2(30) ;
297: l_event_date date := p_period_close_date;
298: l_event_status varchar2(30) ;
313: -- based on calling interface and other factors
314:
315: l_deprn_source_info.entity_type_code := 'DEPRECIATION';
316:
317: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
318:
319: -- Call XLA API
320: x_event_id :=
321: XLA_EVENTS_PUB_PKG.create_event
317: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
318:
319: -- Call XLA API
320: x_event_id :=
321: XLA_EVENTS_PUB_PKG.create_event
322: (p_event_source_info => l_deprn_source_info,
323: p_event_type_code => 'ROLLBACK_DEPRECIATION',
324: p_event_date => l_event_date,
325: p_event_status_code => l_event_status,
357: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
358:
359: l_legal_entity_id number;
360:
361: l_entity_event_info_tbl_in xla_events_pub_pkg.t_array_entity_event_info_s;
362: l_entity_event_info_tbl_out xla_events_pub_pkg.t_array_entity_event_info_s;
363:
364: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.create_bulk_deprn_event';
365:
358:
359: l_legal_entity_id number;
360:
361: l_entity_event_info_tbl_in xla_events_pub_pkg.t_array_entity_event_info_s;
362: l_entity_event_info_tbl_out xla_events_pub_pkg.t_array_entity_event_info_s;
363:
364: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.create_bulk_deprn_event';
365:
366: l_dummy_number number_tbl_type;
398: p_entity_type_code ,
399: 'DEPRECIATION' ,
400: p_period_close_date ,
401: l_dummy_number(i) ,
402: XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,
403: l_dummy_number(i) ,
404: p_asset_id_tbl(i) ,
405: p_book_type_code ,
406: p_period_counter ,
407: p_deprn_run_id ,
408: p_book_type_code
409: );
410:
411: XLA_EVENTS_PUB_PKG.create_bulk_events
412: (p_source_application_id => 140,
413: p_application_id => 140,
414: p_legal_entity_id => l_legal_entity_id,
415: p_ledger_id => fa_cache_pkg.fazcbc_record.set_of_books_id,
452:
453: l_dummy_number number_tbl_type;
454: l_legal_entity_id number;
455:
456: l_entity_event_info_tbl_in xla_events_pub_pkg.t_array_entity_event_info_s;
457: l_entity_event_info_tbl_out xla_events_pub_pkg.t_array_entity_event_info_s;
458:
459: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.create_bulk_deferred_event';
460:
453: l_dummy_number number_tbl_type;
454: l_legal_entity_id number;
455:
456: l_entity_event_info_tbl_in xla_events_pub_pkg.t_array_entity_event_info_s;
457: l_entity_event_info_tbl_out xla_events_pub_pkg.t_array_entity_event_info_s;
458:
459: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.create_bulk_deferred_event';
460:
461: BEGIN
491: p_entity_type_code ,
492: 'DEFERRED_DEPRECIATION' ,
493: p_period_close_date ,
494: l_dummy_number(i) ,
495: XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,
496: l_dummy_number(i) ,
497: p_asset_id_tbl(i) ,
498: p_corp_book ,
499: p_tax_book ,
500: p_corp_period_counter,
501: p_corp_book
502: );
503:
504: XLA_EVENTS_PUB_PKG.create_bulk_events
505: (p_source_application_id => 140,
506: p_application_id => 140,
507: p_legal_entity_id => l_legal_entity_id,
508: p_ledger_id => fa_cache_pkg.fazcbc_record.set_of_books_id,
530:
531: /*
532:
533: PROCEDURE update_event_status
534: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
535: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
536: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
537: ,p_event_date IN DATE DEFAULT NULL
538: ,p_event_status_code IN VARCHAR2
536: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
537: ,p_event_date IN DATE DEFAULT NULL
538: ,p_event_status_code IN VARCHAR2
539: ,p_valuation_method IN VARCHAR2
540: ,p_security_context IN xla_events_pub_pkg.t_security
541:
542: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
543:
544: */
552: p_event_status_code IN VARCHAR2,
553: p_calling_fn IN VARCHAR2,
554: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
555:
556: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
557: l_security_context XLA_EVENTS_PUB_PKG.t_security;
558: l_event_type varchar2(30);
559: l_event_id number;
560:
553: p_calling_fn IN VARCHAR2,
554: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
555:
556: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
557: l_security_context XLA_EVENTS_PUB_PKG.t_security;
558: l_event_type varchar2(30);
559: l_event_id number;
560:
561: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.update_transaction_event';
571: into l_event_id
572: from fa_transaction_headers
573: where transaction_header_id = p_transaction_header_id;
574:
575: XLA_EVENTS_PUB_PKG.update_event
576: (p_event_source_info => l_trx_source_info,
577: p_event_id => l_event_id,
578: p_event_type_code => p_event_type_code,
579: p_event_date => p_event_date,
601: p_calling_fn IN VARCHAR2,
602: p_log_level_rec in fa_api_types.log_level_rec_type default null
603: ) return boolean is
604:
605: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
606: l_security_context XLA_EVENTS_PUB_PKG.t_security;
607: l_event_type varchar2(30);
608: l_event_id number;
609:
602: p_log_level_rec in fa_api_types.log_level_rec_type default null
603: ) return boolean is
604:
605: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
606: l_security_context XLA_EVENTS_PUB_PKG.t_security;
607: l_event_type varchar2(30);
608: l_event_id number;
609:
610: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.update_inter_transaction_event';
620: into l_event_id
621: from fa_trx_references
622: where trx_reference_id = p_trx_reference_id;
623:
624: XLA_EVENTS_PUB_PKG.update_event
625: (p_event_source_info => l_trx_source_info,
626: p_event_id => l_event_id,
627: p_event_type_code => p_event_type_code,
628: p_event_date => p_event_date,
651: p_calling_fn IN VARCHAR2,
652: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
653:
654: l_event_id NUMBER;
655: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
656: l_security_context XLA_EVENTS_PUB_PKG.t_security;
657:
658: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.delete_transaction_event';
659:
652: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
653:
654: l_event_id NUMBER;
655: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
656: l_security_context XLA_EVENTS_PUB_PKG.t_security;
657:
658: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.delete_transaction_event';
659:
660: BEGIN
668: into l_event_id
669: from fa_transaction_headers
670: where transaction_header_id = p_transaction_header_id;
671:
672: XLA_EVENTS_PUB_PKG.delete_event
673: (p_event_source_info => l_trx_source_info,
674: p_event_id => l_event_id,
675: p_valuation_method => p_book_type_code,
676: p_security_context => l_security_context);
695: p_calling_fn IN VARCHAR2,
696: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
697:
698: l_event_id NUMBER;
699: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
700: l_security_context XLA_EVENTS_PUB_PKG.t_security;
701:
702: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.delete_deprn_event';
703:
696: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
697:
698: l_event_id NUMBER;
699: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
700: l_security_context XLA_EVENTS_PUB_PKG.t_security;
701:
702: l_calling_fn varchar2(80) := 'fa_xla_events_pvt.delete_deprn_event';
703:
704: BEGIN
710: l_deprn_source_info.source_id_int_2 := p_period_counter;
711: l_deprn_source_info.source_id_int_3 := p_deprn_run_id;
712: l_deprn_source_info.entity_type_code := 'DEPRECIATION';
713:
714: XLA_EVENTS_PUB_PKG.delete_event
715: (p_event_source_info => l_deprn_source_info,
716: p_event_id => p_event_id,
717: p_valuation_method => p_book_type_code,
718: p_security_context => l_security_context);