[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,
928: /*========================================================================
929: | PUBLIC PROCEDURE UPGRADE_MC_RECEIPTS
930: |
931: | DESCRIPTION
932: | Will create the records in XLA_AE_HEADERS, XLA_AE_LINES and
933: | XLA_DISTRIBUTION_LINKS for records related to receipts.
934: |
935: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
936: |
1323: --------------------------------------------
1324:
1325: INSERT ALL
1326: WHEN 1 = 1 THEN
1327: INTO XLA_AE_LINES
1328: (upg_batch_id,
1329: ae_header_id,
1330: ae_line_num,
1331: application_id,
1826: /*========================================================================
1827: | PUBLIC PROCEDURE UPGRADE_MC_ADJUSTMENTS
1828: |
1829: | DESCRIPTION
1830: | Will create the records in XLA_AE_HEADERS, XLA_AE_LINES and
1831: | XLA_DISTRIBUTION_LINKS for records related to adjustments.
1832: |
1833: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1834: |
2075: --------------------------------------------
2076:
2077: INSERT ALL
2078: WHEN 1 = 1 THEN
2079: INTO XLA_AE_LINES
2080: (upg_batch_id,
2081: ae_header_id,
2082: ae_line_num,
2083: application_id,
2363: /*========================================================================
2364: | PRIVATE PROCEDURE UPGRADE_MC_GAIN_LOSS
2365: |
2366: | DESCRIPTION
2367: | Will create the records in XLA_AE_HEADERS, XLA_AE_LINES and
2368: | XLA_DISTRIBUTION_LINKS for records related to exchange_gain/loss
2369: | which doesnt have any parent record in AR and exist in MRC.
2370: |
2371: | CALLED FROM PROCEDURES/FUNCTIONS
2401: IF (l_table_name = 'AR_MC_CASH_RECEIPTS') THEN
2402:
2403: INSERT ALL
2404: WHEN 1 = 1 THEN
2405: INTO XLA_AE_LINES
2406: (upg_batch_id,
2407: ae_header_id,
2408: ae_line_num,
2409: application_id,
2580: RANK() OVER (PARTITION BY event_id, ae_header_id, sob_id
2581: ORDER BY line_id, ln_order) AS line_num
2582: FROM
2583: (select /*+ ordered rowid(cr) use_nl(rec,app,ra,dist,dist1,dl,lin,lin1,hdr) use_hash(gps) swap_join_inputs(gps)
2584: index(DL,XLA_DISTRIBUTION_LINKS_N1) index(LIN,XLA_AE_LINES_U1) index(LIN1,XLA_AE_LINES_U1) index(HDR,XLA_AE_HEADERS_U1) */
2585: hdr.ae_header_id ae_header_id,
2586: hdr.event_id event_id,
2587: dist.set_of_books_id sob_id,
2588: dist.source_type account_class,
2620: gl_sets_of_books gsb,
2621: ar_mc_distributions_all dist,
2622: ar_mc_distributions_all dist1,
2623: xla_distribution_links dl,
2624: xla_ae_lines lin,
2625: xla_ae_lines lin1,
2626: xla_ae_headers hdr
2627: --
2628: where cr.rowid >= l_start_rowid
2621: ar_mc_distributions_all dist,
2622: ar_mc_distributions_all dist1,
2623: xla_distribution_links dl,
2624: xla_ae_lines lin,
2625: xla_ae_lines lin1,
2626: xla_ae_headers hdr
2627: --
2628: where cr.rowid >= l_start_rowid
2629: and cr.rowid <= l_end_rowid
2680: and lin.upg_batch_id = l_batch_id
2681: --
2682: and lin1.ae_header_id = lin.ae_header_id
2683: and lin1.ae_line_num = (select max(ae_line_num)
2684: from xla_ae_lines
2685: where ae_header_id = lin1.ae_header_id
2686: and application_id = 222
2687: and upg_batch_id = l_batch_id)
2688: and lin1.application_id = 222
2699: ELSIF (l_table_name = 'RA_MC_CUSTOMER_TRX') THEN
2700:
2701: INSERT ALL
2702: WHEN 1 = 1 THEN
2703: INTO XLA_AE_LINES
2704: (upg_batch_id,
2705: ae_header_id,
2706: ae_line_num,
2707: application_id,
2878: RANK() OVER (PARTITION BY event_id, ae_header_id, sob_id
2879: ORDER BY line_id, ln_order) AS line_num
2880: FROM
2881: (select /*+ ordered rowid(ct) use_nl(trx,app,ra,dist,dist1,dl,lin,lin1,hdr) use_hash(gps) swap_join_inputs(gps)
2882: index(DL,XLA_DISTRIBUTION_LINKS_N1) index(LIN,XLA_AE_LINES_U1) index(LIN1,XLA_AE_LINES_U1) index(HDR,XLA_AE_HEADERS_U1) */
2883: hdr.ae_header_id ae_header_id,
2884: hdr.event_id event_id,
2885: dist.set_of_books_id sob_id,
2886: dist.source_type account_class,
2918: ar_mc_receivable_apps ra,
2919: ar_mc_distributions_all dist,
2920: ar_mc_distributions_all dist1,
2921: xla_distribution_links dl,
2922: xla_ae_lines lin,
2923: xla_ae_lines lin1,
2924: xla_ae_headers hdr
2925: --
2926: where ct.rowid >= l_start_rowid
2919: ar_mc_distributions_all dist,
2920: ar_mc_distributions_all dist1,
2921: xla_distribution_links dl,
2922: xla_ae_lines lin,
2923: xla_ae_lines lin1,
2924: xla_ae_headers hdr
2925: --
2926: where ct.rowid >= l_start_rowid
2927: and ct.rowid <= l_end_rowid
2979: and lin.upg_batch_id = l_batch_id
2980: --
2981: and lin1.ae_header_id = lin.ae_header_id
2982: and lin1.ae_line_num = (select max(ae_line_num)
2983: from xla_ae_lines
2984: where ae_header_id = lin1.ae_header_id
2985: and application_id = 222
2986: and upg_batch_id = l_batch_id)
2987: and lin1.application_id = 222