[Home] [Help]
85: l_error_message_name_tbl char_tbl_type;
86:
87: CURSOR c_trans IS
88: select /*+ leading(tr) rowid(tr) */
89: xla_events_s.nextval,
90: th1.asset_id,
91: th2.asset_id,
92: tr.book_type_code,
93: bc.set_of_books_id,
761: l_entity_id_tbl(i), -- entity_id
762: c_application_id -- upg_source_application_id
763: );
764:
765: -- Business Rules for xla_events
766: -- * event_type_code is similar to transaction_type_code
767: -- * event_number is 1, but is the serial event for chronological order
768: -- * event_status_code: N if event creates no journal entries
769: -- P if event would ultimately yield journals
777: -- * on_hold_flag: N should always be this value for upgraded entries
778: -- * event_date is basically transaction_date_entered
779:
780: FORALL i IN 1..l_event_id_tbl.count
781: insert into xla_events (
782: upg_batch_id,
783: application_id,
784: event_type_code,
785: event_number,
3126: into l_upg_batch_id
3127: from dual;
3128:
3129: FOR i IN 1..l_rowid_tbl.count LOOP
3130: select xla_events_s.nextval, xla_transaction_entities_s.nextval
3131: into l_event_id_tbl(i), l_entity_id_tbl(i)
3132: from dual;
3133: END LOOP;
3134:
3222: l_entity_id_tbl(i), -- entity_id
3223: c_application_id -- upg_source_application_id
3224: );
3225:
3226: -- Business Rules for xla_events
3227: -- * event_type_code is similar to transaction_type_code
3228: -- * event_number is 1, but is the serial event for chronological order
3229: -- * event_status_code: N if event creates no journal entries
3230: -- P if event would ultimately yield journals
3238: -- * on_hold_flag: N should always be this value for upgraded entries
3239: -- * event_date is basically transaction_date_entered
3240:
3241: FORALL i IN 1..l_event_id_tbl.count
3242: insert into xla_events (
3243: upg_batch_id,
3244: application_id,
3245: event_type_code,
3246: event_number,
4202: asset_id,
4203: book_type_code,
4204: period_counter
4205: ) values (
4206: xla_events_s.nextval,
4207: xla_transaction_entities_s.nextval,
4208: transaction_header_id,
4209: set_of_books_id,
4210: period_name,
4282: -- entity_id
4283: c_application_id -- upg_source_application_id
4284: )
4285: when 1 = 1 then
4286: into xla_events (
4287: upg_batch_id,
4288: application_id,
4289: event_type_code,
4290: event_number,
4325: null, -- program_application_id
4326: null, -- request_id
4327: xla_transaction_entities_s.currval,
4328: -- entity_id
4329: xla_events_s.currval, -- event_id
4330: c_application_id, -- upg_source_application_id
4331: transaction_date_entered
4332: -- transaction_date
4333: )
4337: event_id,
4338: set_of_books_id
4339: ) values (
4340: xla_ae_headers_s.nextval,
4341: xla_events_s.currval,
4342: set_of_books_id
4343: )
4344: when 1 = 1 then
4345: into xla_ae_headers (
4396: c_application_id, -- application_id
4397: c_amb_context_code, -- amb_context_code
4398: xla_transaction_entities_s.currval,
4399: -- entity_id
4400: xla_events_s.currval, -- event_id
4401: event_type_code, -- event_type_code
4402: xla_ae_headers_s.currval, -- ae_header_id
4403: set_of_books_id, -- ledger_id
4404: calendar_period_close_date, -- accounting_date
6510: bonus_reserve_acct_ccid,
6511: reval_amort_acct_ccid,
6512: reval_reserve_acct_ccid
6513: ) values (
6514: xla_events_s.nextval,
6515: xla_transaction_entities_s.nextval,
6516: set_of_books_id,
6517: period_name,
6518: calendar_period_close_date,
6547: book_type_code,
6548: period_counter,
6549: transaction_date_entered,
6550: 1,
6551: xla_events_s.currval,
6552: null,
6553: null,
6554: sysdate,
6555: c_upgrade_bugno,
6620: -- entity_id
6621: c_application_id -- upg_source_application_id
6622: )
6623: when 1 = 1 then
6624: into xla_events (
6625: upg_batch_id,
6626: application_id,
6627: event_type_code,
6628: event_number,
6663: null, -- program_application_id
6664: null, -- request_id
6665: xla_transaction_entities_s.currval,
6666: -- entity_id
6667: xla_events_s.currval, -- event_id
6668: c_application_id, -- upg_source_application_id
6669: transaction_date_entered
6670: -- transaction_date
6671: )
6675: event_id,
6676: set_of_books_id
6677: ) values (
6678: xla_ae_headers_s.nextval,
6679: xla_events_s.currval,
6680: set_of_books_id
6681: )
6682: when 1 = 1 then
6683: into xla_ae_headers (
6734: c_application_id, -- application_id
6735: c_amb_context_code, -- amb_context_code
6736: xla_transaction_entities_s.currval,
6737: -- entity_id
6738: xla_events_s.currval, -- event_id
6739: event_type_code, -- event_type_code
6740: xla_ae_headers_s.currval, -- ae_header_id
6741: set_of_books_id, -- ledger_id
6742: calendar_period_close_date, -- accounting_date
6844: bonus_reserve_acct_ccid,
6845: reval_amort_acct_ccid,
6846: reval_reserve_acct_ccid
6847: ) values (
6848: xla_events_s.nextval,
6849: xla_transaction_entities_s.nextval,
6850: set_of_books_id,
6851: period_name,
6852: calendar_period_close_date,
6881: book_type_code,
6882: period_counter,
6883: transaction_date_entered,
6884: 1,
6885: xla_events_s.currval,
6886: null,
6887: null,
6888: sysdate,
6889: c_upgrade_bugno,
6954: -- entity_id
6955: c_application_id -- upg_source_application_id
6956: )
6957: when 1 = 1 then
6958: into xla_events (
6959: upg_batch_id,
6960: application_id,
6961: event_type_code,
6962: event_number,
6997: null, -- program_application_id
6998: null, -- request_id
6999: xla_transaction_entities_s.currval,
7000: -- entity_id
7001: xla_events_s.currval, -- event_id
7002: c_application_id, -- upg_source_application_id
7003: transaction_date_entered
7004: -- transaction_date
7005: )
7009: event_id,
7010: set_of_books_id
7011: ) values (
7012: xla_ae_headers_s.nextval,
7013: xla_events_s.currval,
7014: set_of_books_id
7015: )
7016: when 1 = 1 then
7017: into xla_ae_headers (
7068: c_application_id, -- application_id
7069: c_amb_context_code, -- amb_context_code
7070: xla_transaction_entities_s.currval,
7071: -- entity_id
7072: xla_events_s.currval, -- event_id
7073: event_type_code, -- event_type_code
7074: xla_ae_headers_s.currval, -- ae_header_id
7075: set_of_books_id, -- ledger_id
7076: calendar_period_close_date, -- accounting_date
8362: limit l_batch_size;
8363:
8364: FOR i IN 1..l_asset_id_tbl.count LOOP
8365: select xla_transaction_entities_s.nextval,
8366: xla_events_s.nextval
8367: into l_entity_id_tbl(i),
8368: l_event_id_tbl(i)
8369: from dual;
8370:
8526: -- * on_hold_flag: N should always be this value for upgraded entries
8527: -- * event_date is basically transaction_date_entered
8528:
8529: FORALL i IN 1..l_event_id_tbl.count
8530: insert into xla_events (
8531: upg_batch_id,
8532: application_id,
8533: event_type_code,
8534: event_number,