[Home] [Help]
852: into l_xla_gl_sl_link_id_tbl(j)
853: from dual;
854: END LOOP;
855:
856: select xla_ae_headers_s.nextval
857: into l_ae_header_id
858: from dual;
859:
860: -- Business Rules for xla_ae_headers
856: select xla_ae_headers_s.nextval
857: into l_ae_header_id
858: from dual;
859:
860: -- Business Rules for xla_ae_headers
861: -- * amb_context_code is DEFAULT
862: -- * reference_date must be null
863: -- * balance_type_code:
864: -- A: Actual
871: -- * accounting_entry_status_code must be F
872: -- * accounting_entry_type_code must be STANDARD
873: -- * product_rule_* not relevant for upgrade
874:
875: insert into xla_ae_headers (
876: upg_batch_id,
877: application_id,
878: amb_context_code,
879: entity_id,
1265: into l_xla_gl_sl_link_id_tbl(j)
1266: from dual;
1267: END LOOP;
1268:
1269: select xla_ae_headers_s.nextval
1270: into l_ae_header_id
1271: from dual;
1272:
1273: -- Business Rules for xla_ae_headers
1269: select xla_ae_headers_s.nextval
1270: into l_ae_header_id
1271: from dual;
1272:
1273: -- Business Rules for xla_ae_headers
1274: -- * amb_context_code is DEFAULT
1275: -- * reference_date must be null
1276: -- * balance_type_code:
1277: -- A: Actual
1284: -- * accounting_entry_status_code must be F
1285: -- * accounting_entry_type_code must be STANDARD
1286: -- * product_rule_* not relevant for upgrade
1287:
1288: insert into xla_ae_headers (
1289: upg_batch_id,
1290: application_id,
1291: amb_context_code,
1292: entity_id,
1673: into l_xla_gl_sl_link_id_tbl(j)
1674: from dual;
1675: END LOOP;
1676:
1677: select xla_ae_headers_s.nextval
1678: into l_ae_header_id
1679: from dual;
1680:
1681: -- Business Rules for xla_ae_lines
1969: into l_xla_gl_sl_link_id_tbl(j)
1970: from dual;
1971: END LOOP;
1972:
1973: select xla_ae_headers_s.nextval
1974: into l_ae_header_id
1975: from dual;
1976:
1977: -- Business Rules for xla_ae_headers
1973: select xla_ae_headers_s.nextval
1974: into l_ae_header_id
1975: from dual;
1976:
1977: -- Business Rules for xla_ae_headers
1978: -- * amb_context_code is DEFAULT
1979: -- * reference_date must be null
1980: -- * balance_type_code:
1981: -- A: Actual
1988: -- * accounting_entry_status_code must be F
1989: -- * accounting_entry_type_code must be STANDARD
1990: -- * product_rule_* not relevant for upgrade
1991:
1992: insert into xla_ae_headers (
1993: upg_batch_id,
1994: application_id,
1995: amb_context_code,
1996: entity_id,
3313: into l_xla_gl_sl_link_id_tbl(j)
3314: from dual;
3315: END LOOP;
3316:
3317: select xla_ae_headers_s.nextval
3318: into l_ae_header_id
3319: from dual;
3320:
3321: -- Business Rules for xla_ae_headers
3317: select xla_ae_headers_s.nextval
3318: into l_ae_header_id
3319: from dual;
3320:
3321: -- Business Rules for xla_ae_headers
3322: -- * amb_context_code is DEFAULT
3323: -- * reference_date must be null
3324: -- * balance_type_code:
3325: -- A: Actual
3332: -- * accounting_entry_status_code must be F
3333: -- * accounting_entry_type_code must be STANDARD
3334: -- * product_rule_* not relevant for upgrade
3335:
3336: insert into xla_ae_headers (
3337: upg_batch_id,
3338: application_id,
3339: amb_context_code,
3340: entity_id,
3724: into l_xla_gl_sl_link_id_tbl(j)
3725: from dual;
3726: END LOOP;
3727:
3728: select xla_ae_headers_s.nextval
3729: into l_ae_header_id
3730: from dual;
3731:
3732: -- Business Rules for xla_ae_headers
3728: select xla_ae_headers_s.nextval
3729: into l_ae_header_id
3730: from dual;
3731:
3732: -- Business Rules for xla_ae_headers
3733: -- * amb_context_code is DEFAULT
3734: -- * reference_date must be null
3735: -- * balance_type_code:
3736: -- A: Actual
3743: -- * accounting_entry_status_code must be F
3744: -- * accounting_entry_type_code must be STANDARD
3745: -- * product_rule_* not relevant for upgrade
3746:
3747: insert into xla_ae_headers (
3748: upg_batch_id,
3749: application_id,
3750: amb_context_code,
3751: entity_id,
4336: ae_header_id,
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
4341: xla_events_s.currval,
4342: set_of_books_id
4343: )
4344: when 1 = 1 then
4345: into xla_ae_headers (
4346: upg_batch_id,
4347: application_id,
4348: amb_context_code,
4349: entity_id,
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
4405: period_name, -- period_name
4406: null, -- reference_date
5459: ae_header_id,
5460: event_id,
5461: set_of_books_id
5462: ) values (
5463: xla_ae_headers_s.nextval,
5464: event_id,
5465: set_of_books_id
5466: )
5467: when 1 = 1 then
5464: event_id,
5465: set_of_books_id
5466: )
5467: when 1 = 1 then
5468: into xla_ae_headers (
5469: upg_batch_id,
5470: application_id,
5471: amb_context_code,
5472: entity_id,
5520: c_amb_context_code, -- amb_context_code
5521: entity_id, -- entity_id
5522: event_id, -- event_id
5523: event_type_code, -- event_type_code
5524: xla_ae_headers_s.currval, -- ae_header_id
5525: set_of_books_id, -- ledger_id
5526: calendar_period_close_date, -- accounting_date
5527: period_name, -- period_name
5528: null, -- reference_date
6674: ae_header_id,
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
6679: xla_events_s.currval,
6680: set_of_books_id
6681: )
6682: when 1 = 1 then
6683: into xla_ae_headers (
6684: upg_batch_id,
6685: application_id,
6686: amb_context_code,
6687: entity_id,
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
6743: period_name, -- period_name
6744: null, -- reference_date
7008: ae_header_id,
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
7013: xla_events_s.currval,
7014: set_of_books_id
7015: )
7016: when 1 = 1 then
7017: into xla_ae_headers (
7018: upg_batch_id,
7019: application_id,
7020: amb_context_code,
7021: entity_id,
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
7077: period_name, -- period_name
7078: null, -- reference_date
7601: ae_header_id,
7602: event_id,
7603: set_of_books_id
7604: ) values (
7605: xla_ae_headers_s.nextval,
7606: event_id,
7607: set_of_books_id
7608: )
7609: when 1 = 1 then
7606: event_id,
7607: set_of_books_id
7608: )
7609: when 1 = 1 then
7610: into xla_ae_headers (
7611: upg_batch_id,
7612: application_id,
7613: amb_context_code,
7614: entity_id,
7662: c_amb_context_code, -- amb_context_code
7663: entity_id, -- entity_id
7664: event_id, -- event_id
7665: event_type_code, -- event_type_code
7666: xla_ae_headers_s.currval, -- ae_header_id
7667: set_of_books_id, -- ledger_id
7668: calendar_period_close_date, -- accounting_date
7669: period_name, -- period_name
7670: null, -- reference_date
8594: l_je_header_id_tbl,
8595: l_gl_transfer_status_code_tbl;
8596: close c_detail;
8597:
8598: select xla_ae_headers_s.nextval
8599: into l_ae_header_id
8600: from dual;
8601:
8602: FOR j IN 1..l_distribution_id_tbl.count LOOP
8611:
8612: l_line_num_tbl(j) := (j - 1) * 2;
8613: END LOOP;
8614:
8615: -- Business Rules for xla_ae_headers
8616: -- * amb_context_code is DEFAULT
8617: -- * reference_date must be null
8618: -- * balance_type_code:
8619: -- A: Actual
8626: -- * accounting_entry_status_code must be F
8627: -- * accounting_entry_type_code must be STANDARD
8628: -- * product_rule_* not relevant for upgrade
8629:
8630: insert into xla_ae_headers (
8631: upg_batch_id,
8632: application_id,
8633: amb_context_code,
8634: entity_id,
9229: l_gl_transfer_status_code_tbl,
9230: l_currency_code_tbl;
9231: close c_mc_detail;
9232:
9233: select xla_ae_headers_s.nextval
9234: into l_ae_header_id
9235: from dual;
9236:
9237: FOR j IN 1..l_distribution_id_tbl.count LOOP
9246:
9247: l_line_num_tbl(j) := (j - 1) * 2;
9248: END LOOP;
9249:
9250: -- Business Rules for xla_ae_headers
9251: -- * amb_context_code is DEFAULT
9252: -- * reference_date must be null
9253: -- * balance_type_code:
9254: -- A: Actual
9261: -- * accounting_entry_status_code must be F
9262: -- * accounting_entry_type_code must be STANDARD
9263: -- * product_rule_* not relevant for upgrade
9264:
9265: insert into xla_ae_headers (
9266: upg_batch_id,
9267: application_id,
9268: amb_context_code,
9269: entity_id,