[Home] [Help]
89: l_error_message_name_tbl char_tbl_type;
90:
91: CURSOR c_trans IS
92: select /*+ leading(tr) rowid(tr) */
93: xla_events_s.nextval,
94: th1.asset_id,
95: th2.asset_id,
96: tr.book_type_code,
97: bc.set_of_books_id,
807: l_entity_id_tbl(i), -- entity_id
808: c_application_id -- upg_source_application_id
809: );
810:
811: -- Business Rules for xla_events
812: -- * event_type_code is similar to transaction_type_code
813: -- * event_number is 1, but is the serial event for chronological order
814: -- * event_status_code: N if event creates no journal entries
815: -- P if event would ultimately yield journals
823: -- * on_hold_flag: N should always be this value for upgraded entries
824: -- * event_date is basically transaction_date_entered
825:
826: FORALL i IN 1..l_event_id_tbl.count
827: insert into xla_events (
828: upg_batch_id,
829: application_id,
830: event_type_code,
831: event_number,
3220: into l_upg_batch_id
3221: from dual;
3222:
3223: FOR i IN 1..l_rowid_tbl.count LOOP
3224: select xla_events_s.nextval, xla_transaction_entities_s.nextval
3225: into l_event_id_tbl(i), l_entity_id_tbl(i)
3226: from dual;
3227: END LOOP;
3228:
3316: l_entity_id_tbl(i), -- entity_id
3317: c_application_id -- upg_source_application_id
3318: );
3319:
3320: -- Business Rules for xla_events
3321: -- * event_type_code is similar to transaction_type_code
3322: -- * event_number is 1, but is the serial event for chronological order
3323: -- * event_status_code: N if event creates no journal entries
3324: -- P if event would ultimately yield journals
3332: -- * on_hold_flag: N should always be this value for upgraded entries
3333: -- * event_date is basically transaction_date_entered
3334:
3335: FORALL i IN 1..l_event_id_tbl.count
3336: insert into xla_events (
3337: upg_batch_id,
3338: application_id,
3339: event_type_code,
3340: event_number,
4297: asset_id,
4298: book_type_code,
4299: period_counter
4300: ) values (
4301: xla_events_s.nextval,
4302: xla_transaction_entities_s.nextval,
4303: transaction_header_id,
4304: set_of_books_id,
4305: period_name,
4377: -- entity_id
4378: c_application_id -- upg_source_application_id
4379: )
4380: when 1 = 1 then
4381: into xla_events (
4382: upg_batch_id,
4383: application_id,
4384: event_type_code,
4385: event_number,
4420: null, -- program_application_id
4421: null, -- request_id
4422: xla_transaction_entities_s.currval,
4423: -- entity_id
4424: xla_events_s.currval, -- event_id
4425: c_application_id, -- upg_source_application_id
4426: transaction_date_entered
4427: -- transaction_date
4428: )
4432: event_id,
4433: set_of_books_id
4434: ) values (
4435: xla_ae_headers_s.nextval,
4436: xla_events_s.currval,
4437: set_of_books_id
4438: )
4439: -- when 1 = 1 then
4440: when event_id is null then -- Bug 6811554
4492: c_application_id, -- application_id
4493: c_amb_context_code, -- amb_context_code
4494: xla_transaction_entities_s.currval,
4495: -- entity_id
4496: xla_events_s.currval, -- event_id
4497: event_type_code, -- event_type_code
4498: xla_ae_headers_s.currval, -- ae_header_id
4499: set_of_books_id, -- ledger_id
4500: calendar_period_close_date, -- accounting_date
6650: bonus_reserve_acct_ccid,
6651: reval_amort_acct_ccid,
6652: reval_reserve_acct_ccid
6653: ) values (
6654: xla_events_s.nextval,
6655: xla_transaction_entities_s.nextval,
6656: set_of_books_id,
6657: period_name,
6658: calendar_period_close_date,
6687: book_type_code,
6688: period_counter,
6689: transaction_date_entered,
6690: 1,
6691: xla_events_s.currval,
6692: null,
6693: null,
6694: sysdate,
6695: c_upgrade_bugno,
6760: -- entity_id
6761: c_application_id -- upg_source_application_id
6762: )
6763: when 1 = 1 then
6764: into xla_events (
6765: upg_batch_id,
6766: application_id,
6767: event_type_code,
6768: event_number,
6804: null, -- program_application_id
6805: null, -- request_id
6806: xla_transaction_entities_s.currval,
6807: -- entity_id
6808: xla_events_s.currval, -- event_id
6809: c_application_id, -- upg_source_application_id
6810: transaction_date_entered
6811: -- transaction_date
6812: )
6875: bonus_reserve_acct_ccid,
6876: reval_amort_acct_ccid,
6877: reval_reserve_acct_ccid
6878: ) values (
6879: xla_events_s.nextval,
6880: xla_transaction_entities_s.nextval,
6881: set_of_books_id,
6882: period_name,
6883: calendar_period_close_date,
6912: book_type_code,
6913: period_counter,
6914: transaction_date_entered,
6915: 1,
6916: xla_events_s.currval,
6917: null,
6918: null,
6919: sysdate,
6920: c_upgrade_bugno,
6985: -- entity_id
6986: c_application_id -- upg_source_application_id
6987: )
6988: when 1 = 1 then
6989: into xla_events (
6990: upg_batch_id,
6991: application_id,
6992: event_type_code,
6993: event_number,
7029: null, -- program_application_id
7030: null, -- request_id
7031: xla_transaction_entities_s.currval,
7032: -- entity_id
7033: xla_events_s.currval, -- event_id
7034: c_application_id, -- upg_source_application_id
7035: transaction_date_entered
7036: -- transaction_date
7037: )
7041: event_id,
7042: set_of_books_id
7043: ) values (
7044: xla_ae_headers_s.nextval,
7045: xla_events_s.currval,
7046: set_of_books_id
7047: )
7048: when 1 = 1 then
7049: into xla_ae_headers (
7100: c_application_id, -- application_id
7101: c_amb_context_code, -- amb_context_code
7102: xla_transaction_entities_s.currval,
7103: -- entity_id
7104: xla_events_s.currval, -- event_id
7105: event_type_code, -- event_type_code
7106: xla_ae_headers_s.currval, -- ae_header_id
7107: set_of_books_id, -- ledger_id
7108: calendar_period_close_date, -- accounting_date
8442: limit l_batch_size;
8443:
8444: FOR i IN 1..l_asset_id_tbl.count LOOP
8445: select xla_transaction_entities_s.nextval,
8446: xla_events_s.nextval
8447: into l_entity_id_tbl(i),
8448: l_event_id_tbl(i)
8449: from dual;
8450:
8606: -- * on_hold_flag: N should always be this value for upgraded entries
8607: -- * event_date is basically transaction_date_entered
8608:
8609: FORALL i IN 1..l_event_id_tbl.count
8610: insert into xla_events (
8611: upg_batch_id,
8612: application_id,
8613: event_type_code,
8614: event_number,