[Home] [Help]
104: th2.transaction_header_id,
105: th1.rowid,
106: th2.rowid,
107: tr.rowid,
108: xla_transaction_entities_s.nextval,
109: decode(tr.transaction_type,
110: 'RESERVE TRANSFER', 'RESERVE_TRANSFERS',
111: 'INVOICE TRANSFER',
112: decode (th1.transaction_type_code,
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:
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,
4306: calendar_period_close_date,
4372: c_fnd_user, -- created_by
4373: sysdate, -- last_update_date
4374: c_fnd_user, -- last_updated_by
4375: c_upgrade_bugno, -- last_update_login
4376: xla_transaction_entities_s.currval,
4377: -- entity_id
4378: c_application_id -- upg_source_application_id
4379: )
4380: when 1 = 1 then
4418: null, -- program_update_date
4419: null, -- program_id
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
4490: ) values (
4491: l_upg_batch_id, -- upg_batch_id
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
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,
6659: je_category_name,
6755: c_fnd_user, -- created_by
6756: sysdate, -- last_update_date
6757: c_fnd_user, -- last_updated_by
6758: c_upgrade_bugno, -- last_update_login
6759: xla_transaction_entities_s.currval,
6760: -- entity_id
6761: c_application_id -- upg_source_application_id
6762: )
6763: when 1 = 1 then
6802: null, -- program_update_date
6803: null, -- program_id
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
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,
6884: je_category_name,
6980: c_fnd_user, -- created_by
6981: sysdate, -- last_update_date
6982: c_fnd_user, -- last_updated_by
6983: c_upgrade_bugno, -- last_update_login
6984: xla_transaction_entities_s.currval,
6985: -- entity_id
6986: c_application_id -- upg_source_application_id
6987: )
6988: when 1 = 1 then
7027: null, -- program_update_date
7028: null, -- program_id
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
7098: ) values (
7099: l_upg_batch_id, -- upg_batch_id
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
8441: l_je_category_name_tbl
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;