[Home] [Help]
10: /*========================================================================
11: | PUBLIC PROCEDURE UPGRADE_MC_TRANSACTIONS
12: |
13: | DESCRIPTION
14: | Will create the records in XLA_AE_HEADERS, XLA_AE_LINES and
15: | XLA_DISTRIBUTION_LINKS for records related to transactions.
16: |
17: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
18: |
406: --------------------------------------------
407:
408: INSERT ALL
409: WHEN 1 = 1 THEN
410: INTO XLA_AE_LINES
411: (upg_batch_id,
412: ae_header_id,
413: ae_line_num,
414: application_id,
906: /*========================================================================
907: | PUBLIC PROCEDURE UPGRADE_MC_RECEIPTS
908: |
909: | DESCRIPTION
910: | Will create the records in XLA_AE_HEADERS, XLA_AE_LINES and
911: | XLA_DISTRIBUTION_LINKS for records related to receipts.
912: |
913: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
914: |
1301: --------------------------------------------
1302:
1303: INSERT ALL
1304: WHEN 1 = 1 THEN
1305: INTO XLA_AE_LINES
1306: (upg_batch_id,
1307: ae_header_id,
1308: ae_line_num,
1309: application_id,
1774: /*========================================================================
1775: | PUBLIC PROCEDURE UPGRADE_MC_ADJUSTMENTS
1776: |
1777: | DESCRIPTION
1778: | Will create the records in XLA_AE_HEADERS, XLA_AE_LINES and
1779: | XLA_DISTRIBUTION_LINKS for records related to adjustments.
1780: |
1781: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1782: |
2023: --------------------------------------------
2024:
2025: INSERT ALL
2026: WHEN 1 = 1 THEN
2027: INTO XLA_AE_LINES
2028: (upg_batch_id,
2029: ae_header_id,
2030: ae_line_num,
2031: application_id,
2310: /*========================================================================
2311: | PRIVATE PROCEDURE UPGRADE_MC_GAIN_LOSS
2312: |
2313: | DESCRIPTION
2314: | Will create the records in XLA_AE_HEADERS, XLA_AE_LINES and
2315: | XLA_DISTRIBUTION_LINKS for records related to exchange_gain/loss
2316: | which doesnt have any parent record in AR and exist in MRC.
2317: |
2318: | CALLED FROM PROCEDURES/FUNCTIONS
2348: IF (l_table_name = 'AR_MC_CASH_RECEIPTS') THEN
2349:
2350: INSERT ALL
2351: WHEN 1 = 1 THEN
2352: INTO XLA_AE_LINES
2353: (upg_batch_id,
2354: ae_header_id,
2355: ae_line_num,
2356: application_id,
2527: RANK() OVER (PARTITION BY event_id, ae_header_id, sob_id
2528: ORDER BY line_id, ln_order) AS line_num
2529: FROM
2530: (select /*+ ordered rowid(cr) use_nl(rec,app,ra,dist,dist1,dl,lin,lin1,hdr) use_hash(gps) swap_join_inputs(gps)
2531: index(DL,XLA_DISTRIBUTION_LINKS_N1) index(LIN,XLA_AE_LINES_U1) index(LIN1,XLA_AE_LINES_U1) index(HDR,XLA_AE_HEADERS_U1) */
2532: hdr.ae_header_id ae_header_id,
2533: hdr.event_id event_id,
2534: dist.set_of_books_id sob_id,
2535: dist.source_type account_class,
2563: ar_mc_receivable_apps ra,
2564: ar_mc_distributions_all dist,
2565: ar_mc_distributions_all dist1,
2566: xla_distribution_links dl,
2567: xla_ae_lines lin,
2568: xla_ae_lines lin1,
2569: xla_ae_headers hdr
2570: --
2571: where cr.rowid >= l_start_rowid
2564: ar_mc_distributions_all dist,
2565: ar_mc_distributions_all dist1,
2566: xla_distribution_links dl,
2567: xla_ae_lines lin,
2568: xla_ae_lines lin1,
2569: xla_ae_headers hdr
2570: --
2571: where cr.rowid >= l_start_rowid
2572: and cr.rowid <= l_end_rowid
2612: and lin.upg_batch_id = l_batch_id
2613: --
2614: and lin1.ae_header_id = lin.ae_header_id
2615: and lin1.ae_line_num = (select max(ae_line_num)
2616: from xla_ae_lines
2617: where ae_header_id = lin1.ae_header_id
2618: and application_id = 222
2619: and upg_batch_id = l_batch_id)
2620: and lin1.application_id = 222
2631: ELSIF (l_table_name = 'RA_MC_CUSTOMER_TRX') THEN
2632:
2633: INSERT ALL
2634: WHEN 1 = 1 THEN
2635: INTO XLA_AE_LINES
2636: (upg_batch_id,
2637: ae_header_id,
2638: ae_line_num,
2639: application_id,
2810: RANK() OVER (PARTITION BY event_id, ae_header_id, sob_id
2811: ORDER BY line_id, ln_order) AS line_num
2812: FROM
2813: (select /*+ ordered rowid(ct) use_nl(trx,app,ra,dist,dist1,dl,lin,lin1,hdr) use_hash(gps) swap_join_inputs(gps)
2814: index(DL,XLA_DISTRIBUTION_LINKS_N1) index(LIN,XLA_AE_LINES_U1) index(LIN1,XLA_AE_LINES_U1) index(HDR,XLA_AE_HEADERS_U1) */
2815: hdr.ae_header_id ae_header_id,
2816: hdr.event_id event_id,
2817: dist.set_of_books_id sob_id,
2818: dist.source_type account_class,
2846: ar_mc_receivable_apps ra,
2847: ar_mc_distributions_all dist,
2848: ar_mc_distributions_all dist1,
2849: xla_distribution_links dl,
2850: xla_ae_lines lin,
2851: xla_ae_lines lin1,
2852: xla_ae_headers hdr
2853: --
2854: where ct.rowid >= l_start_rowid
2847: ar_mc_distributions_all dist,
2848: ar_mc_distributions_all dist1,
2849: xla_distribution_links dl,
2850: xla_ae_lines lin,
2851: xla_ae_lines lin1,
2852: xla_ae_headers hdr
2853: --
2854: where ct.rowid >= l_start_rowid
2855: and ct.rowid <= l_end_rowid
2896: and lin.upg_batch_id = l_batch_id
2897: --
2898: and lin1.ae_header_id = lin.ae_header_id
2899: and lin1.ae_line_num = (select max(ae_line_num)
2900: from xla_ae_lines
2901: where ae_header_id = lin1.ae_header_id
2902: and application_id = 222
2903: and upg_batch_id = l_batch_id)
2904: and lin1.application_id = 222