[Home] [Help]
900: from dual;
901:
902: END LOOP;
903:
904: select xla_ae_headers_s.nextval
905: into l_ae_header_id
906: from dual;
907:
908: l_line_num_tbl(1) := l_adj_line_id_tbl.count; -- Bug 6827893
907:
908: l_line_num_tbl(1) := l_adj_line_id_tbl.count; -- Bug 6827893
909: l_ae_header_id_tbl(1) := l_ae_header_id; -- Bug 6827893
910:
911: -- Business Rules for xla_ae_headers
912: -- * amb_context_code is DEFAULT
913: -- * reference_date must be null
914: -- * balance_type_code:
915: -- A: Actual
922: -- * accounting_entry_status_code must be F
923: -- * accounting_entry_type_code must be STANDARD
924: -- * product_rule_* not relevant for upgrade
925:
926: insert into xla_ae_headers (
927: upg_batch_id,
928: application_id,
929: amb_context_code,
930: entity_id,
1320: into l_xla_gl_sl_link_id_tbl(j)
1321: from dual;
1322: END LOOP;
1323:
1324: select xla_ae_headers_s.nextval
1325: into l_ae_header_id
1326: from dual;
1327:
1328: l_line_num_tbl(k+1) := l_adj_line_id_tbl.count; -- Bug 6827893
1327:
1328: l_line_num_tbl(k+1) := l_adj_line_id_tbl.count; -- Bug 6827893
1329: l_ae_header_id_tbl(k+1) := l_ae_header_id; -- Bug 6827893
1330:
1331: -- Business Rules for xla_ae_headers
1332: -- * amb_context_code is DEFAULT
1333: -- * reference_date must be null
1334: -- * balance_type_code:
1335: -- A: Actual
1342: -- * accounting_entry_status_code must be F
1343: -- * accounting_entry_type_code must be STANDARD
1344: -- * product_rule_* not relevant for upgrade
1345:
1346: insert into xla_ae_headers (
1347: upg_batch_id,
1348: application_id,
1349: amb_context_code,
1350: entity_id,
2034:
2035: -- Bug 6827893: No need to create new ae_hdr_id. Use same as src
2036: l_ae_header_id := l_ae_header_id_tbl(k+1);
2037:
2038: -- Business Rules for xla_ae_headers
2039: -- * amb_context_code is DEFAULT
2040: -- * reference_date must be null
2041: -- * balance_type_code:
2042: -- A: Actual
2049: -- * accounting_entry_status_code must be F
2050: -- * accounting_entry_type_code must be STANDARD
2051: -- * product_rule_* not relevant for upgrade
2052:
2053: insert into xla_ae_headers (
2054: upg_batch_id,
2055: application_id,
2056: amb_context_code,
2057: entity_id,
3407: into l_xla_gl_sl_link_id_tbl(j)
3408: from dual;
3409: END LOOP;
3410:
3411: select xla_ae_headers_s.nextval
3412: into l_ae_header_id
3413: from dual;
3414:
3415: -- Business Rules for xla_ae_headers
3411: select xla_ae_headers_s.nextval
3412: into l_ae_header_id
3413: from dual;
3414:
3415: -- Business Rules for xla_ae_headers
3416: -- * amb_context_code is DEFAULT
3417: -- * reference_date must be null
3418: -- * balance_type_code:
3419: -- A: Actual
3426: -- * accounting_entry_status_code must be F
3427: -- * accounting_entry_type_code must be STANDARD
3428: -- * product_rule_* not relevant for upgrade
3429:
3430: insert into xla_ae_headers (
3431: upg_batch_id,
3432: application_id,
3433: amb_context_code,
3434: entity_id,
3818: into l_xla_gl_sl_link_id_tbl(j)
3819: from dual;
3820: END LOOP;
3821:
3822: select xla_ae_headers_s.nextval
3823: into l_ae_header_id
3824: from dual;
3825:
3826: -- Business Rules for xla_ae_headers
3822: select xla_ae_headers_s.nextval
3823: into l_ae_header_id
3824: from dual;
3825:
3826: -- Business Rules for xla_ae_headers
3827: -- * amb_context_code is DEFAULT
3828: -- * reference_date must be null
3829: -- * balance_type_code:
3830: -- A: Actual
3837: -- * accounting_entry_status_code must be F
3838: -- * accounting_entry_type_code must be STANDARD
3839: -- * product_rule_* not relevant for upgrade
3840:
3841: insert into xla_ae_headers (
3842: upg_batch_id,
3843: application_id,
3844: amb_context_code,
3845: entity_id,
4431: ae_header_id,
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
4437: set_of_books_id
4438: )
4439: -- when 1 = 1 then
4440: when event_id is null then -- Bug 6811554
4441: into xla_ae_headers (
4442: upg_batch_id,
4443: application_id,
4444: amb_context_code,
4445: entity_id,
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
4501: period_name, -- period_name
4502: null, -- reference_date
5598: ae_header_id,
5599: event_id,
5600: set_of_books_id
5601: ) values (
5602: xla_ae_headers_s.nextval,
5603: event_id,
5604: set_of_books_id
5605: )
5606: when 1 = 1 then
5603: event_id,
5604: set_of_books_id
5605: )
5606: when 1 = 1 then
5607: into xla_ae_headers (
5608: upg_batch_id,
5609: application_id,
5610: amb_context_code,
5611: entity_id,
5659: c_amb_context_code, -- amb_context_code
5660: entity_id, -- entity_id
5661: event_id, -- event_id
5662: event_type_code, -- event_type_code
5663: xla_ae_headers_s.currval, -- ae_header_id
5664: set_of_books_id, -- ledger_id
5665: calendar_period_close_date, -- accounting_date
5666: period_name, -- period_name
5667: null, -- reference_date
7040: ae_header_id,
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
7045: xla_events_s.currval,
7046: set_of_books_id
7047: )
7048: when 1 = 1 then
7049: into xla_ae_headers (
7050: upg_batch_id,
7051: application_id,
7052: amb_context_code,
7053: entity_id,
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
7109: period_name, -- period_name
7110: null, -- reference_date
7678: ae_header_id,
7679: event_id,
7680: set_of_books_id
7681: ) values (
7682: xla_ae_headers_s.nextval,
7683: event_id,
7684: set_of_books_id
7685: )
7686: when 1 = 1 then
7683: event_id,
7684: set_of_books_id
7685: )
7686: when 1 = 1 then
7687: into xla_ae_headers (
7688: upg_batch_id,
7689: application_id,
7690: amb_context_code,
7691: entity_id,
7739: c_amb_context_code, -- amb_context_code
7740: entity_id, -- entity_id
7741: event_id, -- event_id
7742: event_type_code, -- event_type_code
7743: xla_ae_headers_s.currval, -- ae_header_id
7744: set_of_books_id, -- ledger_id
7745: calendar_period_close_date, -- accounting_date
7746: period_name, -- period_name
7747: null, -- reference_date
8675: l_je_header_id_tbl,
8676: l_gl_transfer_status_code_tbl;
8677: close c_detail;
8678:
8679: select xla_ae_headers_s.nextval
8680: into l_ae_header_id
8681: from dual;
8682:
8683: FOR j IN 1..l_distribution_id_tbl.count LOOP
8692:
8693: l_line_num_tbl(j) := (j - 1) * 2;
8694: END LOOP;
8695:
8696: -- Business Rules for xla_ae_headers
8697: -- * amb_context_code is DEFAULT
8698: -- * reference_date must be null
8699: -- * balance_type_code:
8700: -- A: Actual
8707: -- * accounting_entry_status_code must be F
8708: -- * accounting_entry_type_code must be STANDARD
8709: -- * product_rule_* not relevant for upgrade
8710:
8711: insert into xla_ae_headers (
8712: upg_batch_id,
8713: application_id,
8714: amb_context_code,
8715: entity_id,
9310: l_gl_transfer_status_code_tbl,
9311: l_currency_code_tbl;
9312: close c_mc_detail;
9313:
9314: select xla_ae_headers_s.nextval
9315: into l_ae_header_id
9316: from dual;
9317:
9318: FOR j IN 1..l_distribution_id_tbl.count LOOP
9327:
9328: l_line_num_tbl(j) := (j - 1) * 2;
9329: END LOOP;
9330:
9331: -- Business Rules for xla_ae_headers
9332: -- * amb_context_code is DEFAULT
9333: -- * reference_date must be null
9334: -- * balance_type_code:
9335: -- A: Actual
9342: -- * accounting_entry_status_code must be F
9343: -- * accounting_entry_type_code must be STANDARD
9344: -- * product_rule_* not relevant for upgrade
9345:
9346: insert into xla_ae_headers (
9347: upg_batch_id,
9348: application_id,
9349: amb_context_code,
9350: entity_id,