[Home] [Help]
1073: l_primary_set_of_books_id_tbl(i)
1074: -- ledger_id/sob_id
1075: );
1076:
1077: -- Business Rules for xla_distribution_links
1078: -- * accounting_line_code is similar to adjustment_type
1079: -- * accounting_line_type_code is S
1080: -- * merge_duplicate_code is N
1081: -- * source_distribution_type is TRX
1082: -- * source_distribution_id_num_1 is trx_reference_id
1083: -- * source_distribution_id_num_2 is event_id
1084:
1085: forall j IN 1..l_xla_gl_sl_link_id_tbl.count
1086: insert into xla_distribution_links (
1087: upg_batch_id,
1088: application_id,
1089: event_id,
1090: ae_header_id,
1484: l_cal_period_close_date_tbl(i), -- accounting_date,
1485: l_rep_set_of_books_id_tbl(k) -- ledger_id/sob_id
1486: );
1487:
1488: -- Business Rules for xla_distribution_links
1489: -- * accounting_line_code is similar to adjustment_type
1490: -- * accounting_line_type_code is S
1491: -- * merge_duplicate_code is N
1492: -- * source_distribution_type is TRX
1493: -- * source_distribution_id_num_1 is trx_reference_id
1494: -- * source_distribution_id_num_2 is event_id
1495:
1496: forall j IN 1..l_xla_gl_sl_link_id_tbl.count
1497: insert into xla_distribution_links (
1498: upg_batch_id,
1499: application_id,
1500: event_id,
1501: ae_header_id,
1777: l_primary_set_of_books_id_tbl(i)
1778: -- ledger_id/sob_id
1779: );
1780:
1781: -- Business Rules for xla_distribution_links
1782: -- * accounting_line_code is similar to adjustment_type
1783: -- * accounting_line_type_code is S
1784: -- * merge_duplicate_code is N
1785: -- * source_distribution_type is TRX
1786: -- * source_distribution_id_num_1 is transaction_header_id
1787: -- * source_distribution_id_num_2 is event_id
1788:
1789: forall j IN 1..l_xla_gl_sl_link_id_tbl.count
1790: insert into xla_distribution_links (
1791: upg_batch_id,
1792: application_id,
1793: event_id,
1794: ae_header_id,
2188: l_cal_period_close_date_tbl(i), -- accounting_date,
2189: l_rep_set_of_books_id_tbl(k) -- ledger_id/sob_id
2190: );
2191:
2192: -- Business Rules for xla_distribution_links
2193: -- * accounting_line_code is similar to adjustment_type
2194: -- * accounting_line_type_code is S
2195: -- * merge_duplicate_code is N
2196: -- * source_distribution_type is TRX
2197: -- * source_distribution_id_num_1 is trx_reference_id
2198: -- * source_distribution_id_num_2 is event_id
2199:
2200: forall j IN 1..l_xla_gl_sl_link_id_tbl.count
2201: insert into xla_distribution_links (
2202: upg_batch_id,
2203: application_id,
2204: event_id,
2205: ae_header_id,
3532: l_primary_set_of_books_id_tbl(i)
3533: -- ledger_id/sob_id
3534: );
3535:
3536: -- Business Rules for xla_distribution_links
3537: -- * accounting_line_code is similar to adjustment_type
3538: -- * accounting_line_type_code is S
3539: -- * merge_duplicate_code is N
3540: -- * source_distribution_type is TRX
3541: -- * source_distribution_id_num_1 is transaction_header_id
3542: -- * source_distribution_id_num_2 is event_id
3543:
3544: forall j IN 1..l_xla_gl_sl_link_id_tbl.count
3545: insert into xla_distribution_links (
3546: upg_batch_id,
3547: application_id,
3548: event_id,
3549: ae_header_id,
3943: l_cal_period_close_date_tbl(i), -- accounting_date,
3944: l_rep_set_of_books_id_tbl(k) -- ledger_id/sob_id
3945: );
3946:
3947: -- Business Rules for xla_distribution_links
3948: -- * accounting_line_code is similar to adjustment_type
3949: -- * accounting_line_type_code is S
3950: -- * merge_duplicate_code is N
3951: -- * source_distribution_type is TRX
3952: -- * source_distribution_id_num_1 is transaction_header_id
3953: -- * source_distribution_id_num_2 is event_id
3954:
3955: forall j IN 1..l_xla_gl_sl_link_id_tbl.count
3956: insert into xla_distribution_links (
3957: upg_batch_id,
3958: application_id,
3959: event_id,
3960: ae_header_id,
4751: cal_period_close_date, -- accounting_date
4752: set_of_books_id -- ledger_id
4753: )
4754: when (adj_row = 1) then
4755: into xla_distribution_links (
4756: upg_batch_id,
4757: application_id,
4758: event_id,
4759: ae_header_id,
4965: cal_period_close_date, -- accounting_date
4966: set_of_books_id -- ledger_id
4967: )
4968: when (adj_row = 2) then
4969: into xla_distribution_links (
4970: upg_batch_id,
4971: application_id,
4972: event_id,
4973: ae_header_id,
5180: cal_period_close_date, -- accounting_date
5181: set_of_books_id -- ledger_id
5182: )
5183: when (adj_row = 3) then
5184: into xla_distribution_links (
5185: upg_batch_id,
5186: application_id,
5187: event_id,
5188: ae_header_id,
5669: cal_period_close_date, -- accounting_date
5670: set_of_books_id -- ledger_id
5671: )
5672: when (adj_row = 1) then
5673: into xla_distribution_links (
5674: upg_batch_id,
5675: application_id,
5676: event_id,
5677: ae_header_id,
5883: cal_period_close_date, -- accounting_date
5884: set_of_books_id -- ledger_id
5885: )
5886: when (adj_row = 2) then
5887: into xla_distribution_links (
5888: upg_batch_id,
5889: application_id,
5890: event_id,
5891: ae_header_id,
6098: cal_period_close_date, -- accounting_date
6099: set_of_books_id -- ledger_id
6100: )
6101: when (adj_row = 3) then
6102: into xla_distribution_links (
6103: upg_batch_id,
6104: application_id,
6105: event_id,
6106: ae_header_id,
7336: cal_period_close_date, -- accounting_date,
7337: set_of_books_id -- ledger_id/sob_id
7338: )
7339: when (1 = 1) then
7340: into xla_distribution_links (
7341: upg_batch_id,
7342: application_id,
7343: event_id,
7344: ae_header_id,
7852: cal_period_close_date, -- accounting_date,
7853: set_of_books_id -- ledger_id/sob_id
7854: )
7855: when (1 = 1) then
7856: into xla_distribution_links (
7857: upg_batch_id,
7858: application_id,
7859: event_id,
7860: ae_header_id,
8917: l_cal_period_close_date_tbl(i), -- accounting_date,
8918: l_set_of_books_id_tbl(i) -- ledger_id/sob_id
8919: );
8920:
8921: -- Business Rules for xla_distribution_links
8922: -- * accounting_line_code is similar to adjustment_type
8923: -- * accounting_line_type_code is S
8924: -- * merge_duplicate_code is N
8925: -- * source_distribution_type is DEFERRED
8926: -- * source_distribution_id_num_1 is transaction_header_id
8927: -- * source_distribution_id_num_2 is event_id
8928:
8929: FORALL j IN 1..l_distribution_id_tbl.count
8930: insert into xla_distribution_links (
8931: upg_batch_id,
8932: application_id,
8933: event_id,
8934: ae_header_id,
9001: l_event_class_code_tbl(i) -- event_type_code
9002: );
9003:
9004: FORALL j IN 1..l_distribution_id_tbl.count
9005: insert into xla_distribution_links (
9006: upg_batch_id,
9007: application_id,
9008: event_id,
9009: ae_header_id,
9552: l_cal_period_close_date_tbl(i), -- accounting_date,
9553: l_rep_set_of_books_id_tbl(k) -- ledger_id/sob_id
9554: );
9555:
9556: -- Business Rules for xla_distribution_links
9557: -- * accounting_line_code is similar to adjustment_type
9558: -- * accounting_line_type_code is S
9559: -- * merge_duplicate_code is N
9560: -- * source_distribution_type is DEFERRED
9561: -- * source_distribution_id_num_1 is transaction_header_id
9562: -- * source_distribution_id_num_2 is event_id
9563:
9564: FORALL j IN 1..l_distribution_id_tbl.count
9565: insert into xla_distribution_links (
9566: upg_batch_id,
9567: application_id,
9568: event_id,
9569: ae_header_id,
9647: l_event_class_code_tbl(i) -- event_type_code
9648: );
9649:
9650: FORALL j IN 1..l_distribution_id_tbl.count
9651: insert into xla_distribution_links (
9652: upg_batch_id,
9653: application_id,
9654: event_id,
9655: ae_header_id,