[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
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
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
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
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
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
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
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
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
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
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
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