[Home] [Help]
1125: l_primary_set_of_books_id_tbl(i)
1126: -- ledger_id/sob_id
1127: );
1128:
1129: -- Business Rules for xla_distribution_links
1130: -- * accounting_line_code is similar to adjustment_type
1131: -- * accounting_line_type_code is S
1132: -- * merge_duplicate_code is N
1133: -- * source_distribution_type is TRX
1134: -- * source_distribution_id_num_1 is trx_reference_id
1135: -- * source_distribution_id_num_2 is event_id
1136:
1137: forall j IN 1..l_xla_gl_sl_link_id_tbl.count
1138: insert into xla_distribution_links (
1139: upg_batch_id,
1140: application_id,
1141: event_id,
1142: ae_header_id,
1543: l_cal_period_close_date_tbl(i), -- accounting_date,
1544: l_rep_set_of_books_id_tbl(k) -- ledger_id/sob_id
1545: );
1546:
1547: -- Business Rules for xla_distribution_links
1548: -- * accounting_line_code is similar to adjustment_type
1549: -- * accounting_line_type_code is S
1550: -- * merge_duplicate_code is N
1551: -- * source_distribution_type is TRX
1552: -- * source_distribution_id_num_1 is trx_reference_id
1553: -- * source_distribution_id_num_2 is event_id
1554:
1555: forall j IN 1..l_xla_gl_sl_link_id_tbl.count
1556: insert into xla_distribution_links (
1557: upg_batch_id,
1558: application_id,
1559: event_id,
1560: ae_header_id,
1837: l_primary_set_of_books_id_tbl(i)
1838: -- ledger_id/sob_id
1839: );
1840:
1841: -- Business Rules for xla_distribution_links
1842: -- * accounting_line_code is similar to adjustment_type
1843: -- * accounting_line_type_code is S
1844: -- * merge_duplicate_code is N
1845: -- * source_distribution_type is TRX
1846: -- * source_distribution_id_num_1 is transaction_header_id
1847: -- * source_distribution_id_num_2 is event_id
1848:
1849: forall j IN 1..l_xla_gl_sl_link_id_tbl.count
1850: insert into xla_distribution_links (
1851: upg_batch_id,
1852: application_id,
1853: event_id,
1854: ae_header_id,
2250: l_cal_period_close_date_tbl(i), -- accounting_date,
2251: l_rep_set_of_books_id_tbl(k) -- ledger_id/sob_id
2252: );
2253:
2254: -- Business Rules for xla_distribution_links
2255: -- * accounting_line_code is similar to adjustment_type
2256: -- * accounting_line_type_code is S
2257: -- * merge_duplicate_code is N
2258: -- * source_distribution_type is TRX
2259: -- * source_distribution_id_num_1 is trx_reference_id
2260: -- * source_distribution_id_num_2 is event_id
2261:
2262: forall j IN 1..l_xla_gl_sl_link_id_tbl.count
2263: insert into xla_distribution_links (
2264: upg_batch_id,
2265: application_id,
2266: event_id,
2267: ae_header_id,
3626: l_primary_set_of_books_id_tbl(i)
3627: -- ledger_id/sob_id
3628: );
3629:
3630: -- Business Rules for xla_distribution_links
3631: -- * accounting_line_code is similar to adjustment_type
3632: -- * accounting_line_type_code is S
3633: -- * merge_duplicate_code is N
3634: -- * source_distribution_type is TRX
3635: -- * source_distribution_id_num_1 is transaction_header_id
3636: -- * source_distribution_id_num_2 is event_id
3637:
3638: forall j IN 1..l_xla_gl_sl_link_id_tbl.count
3639: insert into xla_distribution_links (
3640: upg_batch_id,
3641: application_id,
3642: event_id,
3643: ae_header_id,
4037: l_cal_period_close_date_tbl(i), -- accounting_date,
4038: l_rep_set_of_books_id_tbl(k) -- ledger_id/sob_id
4039: );
4040:
4041: -- Business Rules for xla_distribution_links
4042: -- * accounting_line_code is similar to adjustment_type
4043: -- * accounting_line_type_code is S
4044: -- * merge_duplicate_code is N
4045: -- * source_distribution_type is TRX
4046: -- * source_distribution_id_num_1 is transaction_header_id
4047: -- * source_distribution_id_num_2 is event_id
4048:
4049: forall j IN 1..l_xla_gl_sl_link_id_tbl.count
4050: insert into xla_distribution_links (
4051: upg_batch_id,
4052: application_id,
4053: event_id,
4054: ae_header_id,
4889: cal_period_close_date, -- accounting_date
4890: set_of_books_id -- ledger_id
4891: )
4892: when (adj_row = 1) then
4893: into xla_distribution_links (
4894: upg_batch_id,
4895: application_id,
4896: event_id,
4897: ae_header_id,
5103: cal_period_close_date, -- accounting_date
5104: set_of_books_id -- ledger_id
5105: )
5106: when (adj_row = 2) then
5107: into xla_distribution_links (
5108: upg_batch_id,
5109: application_id,
5110: event_id,
5111: ae_header_id,
5318: cal_period_close_date, -- accounting_date
5319: set_of_books_id -- ledger_id
5320: )
5321: when (adj_row = 3) then
5322: into xla_distribution_links (
5323: upg_batch_id,
5324: application_id,
5325: event_id,
5326: ae_header_id,
5808: cal_period_close_date, -- accounting_date
5809: set_of_books_id -- ledger_id
5810: )
5811: when (adj_row = 1) then
5812: into xla_distribution_links (
5813: upg_batch_id,
5814: application_id,
5815: event_id,
5816: ae_header_id,
6022: cal_period_close_date, -- accounting_date
6023: set_of_books_id -- ledger_id
6024: )
6025: when (adj_row = 2) then
6026: into xla_distribution_links (
6027: upg_batch_id,
6028: application_id,
6029: event_id,
6030: ae_header_id,
6237: cal_period_close_date, -- accounting_date
6238: set_of_books_id -- ledger_id
6239: )
6240: when (adj_row = 3) then
6241: into xla_distribution_links (
6242: upg_batch_id,
6243: application_id,
6244: event_id,
6245: ae_header_id,
7410: cal_period_close_date, -- accounting_date,
7411: set_of_books_id -- ledger_id/sob_id
7412: )
7413: when (1 = 1) then
7414: into xla_distribution_links (
7415: upg_batch_id,
7416: application_id,
7417: event_id,
7418: ae_header_id,
7932: cal_period_close_date, -- accounting_date,
7933: set_of_books_id -- ledger_id/sob_id
7934: )
7935: when (1 = 1) then
7936: into xla_distribution_links (
7937: upg_batch_id,
7938: application_id,
7939: event_id,
7940: ae_header_id,
8998: l_cal_period_close_date_tbl(i), -- accounting_date,
8999: l_set_of_books_id_tbl(i) -- ledger_id/sob_id
9000: );
9001:
9002: -- Business Rules for xla_distribution_links
9003: -- * accounting_line_code is similar to adjustment_type
9004: -- * accounting_line_type_code is S
9005: -- * merge_duplicate_code is N
9006: -- * source_distribution_type is DEFERRED
9007: -- * source_distribution_id_num_1 is transaction_header_id
9008: -- * source_distribution_id_num_2 is event_id
9009:
9010: FORALL j IN 1..l_distribution_id_tbl.count
9011: insert into xla_distribution_links (
9012: upg_batch_id,
9013: application_id,
9014: event_id,
9015: ae_header_id,
9082: l_event_class_code_tbl(i) -- event_type_code
9083: );
9084:
9085: FORALL j IN 1..l_distribution_id_tbl.count
9086: insert into xla_distribution_links (
9087: upg_batch_id,
9088: application_id,
9089: event_id,
9090: ae_header_id,
9633: l_cal_period_close_date_tbl(i), -- accounting_date,
9634: l_rep_set_of_books_id_tbl(k) -- ledger_id/sob_id
9635: );
9636:
9637: -- Business Rules for xla_distribution_links
9638: -- * accounting_line_code is similar to adjustment_type
9639: -- * accounting_line_type_code is S
9640: -- * merge_duplicate_code is N
9641: -- * source_distribution_type is DEFERRED
9642: -- * source_distribution_id_num_1 is transaction_header_id
9643: -- * source_distribution_id_num_2 is event_id
9644:
9645: FORALL j IN 1..l_distribution_id_tbl.count
9646: insert into xla_distribution_links (
9647: upg_batch_id,
9648: application_id,
9649: event_id,
9650: ae_header_id,
9728: l_event_class_code_tbl(i) -- event_type_code
9729: );
9730:
9731: FORALL j IN 1..l_distribution_id_tbl.count
9732: insert into xla_distribution_links (
9733: upg_batch_id,
9734: application_id,
9735: event_id,
9736: ae_header_id,