44: g_adj_yn VARCHAR2(1) := 'N';
45:
46: PROCEDURE localdebug(p_txt IN VARCHAR2);
47:
48: PROCEDURE display_ra_ar_gt
49: (p_code IN VARCHAR2 DEFAULT NULL,
50: p_gt_id IN VARCHAR2);
51:
52: PROCEDURE display_cust_trx_gt(p_customer_trx_id IN NUMBER);
618:
619: /*-----------------------------------------------------------------------+
620: | update_line |
621: +-----------------------------------------------------------------------+
622: | Read ra_ar_gt for proration info |
623: | Does the proration plsql_proration |
624: | update ra_ar_gt with the result |
625: | for lines of a transaction |
626: +-----------------------------------------------------------------------+
620: | update_line |
621: +-----------------------------------------------------------------------+
622: | Read ra_ar_gt for proration info |
623: | Does the proration plsql_proration |
624: | update ra_ar_gt with the result |
625: | for lines of a transaction |
626: +-----------------------------------------------------------------------+
627: | parameter: |
628: | p_customer_trx_id transaction id |
717: | This procedure determine the base |
718: | the element |
719: | the bucket |
720: | group of lines proration |
721: | It inserts into ra_ar_gt with gp_level = 'GPL' |
722: +-------------------------------------------------------------------------+
723: | p_pay_adj APP / ADJ |
724: | in case of APP ED/UNED will be |
725: | kicked off. |
739: | update_ctl_rem_orig |
740: +-------------------------------------------------------------------------+
741: | Update ra_customer_trx_lines |
742: | remaining and original amount |
743: | base on result in ra_ar_gt |
744: +-------------------------------------------------------------------------+
745: | parameter: |
746: | p_gt_id global id |
747: | p_customer_trx_id transaction id |
790:
791: /*-------------------------------------------------------------------------+
792: | update_group_line |
793: +-------------------------------------------------------------------------+
794: | Read ra_ar_gt for proration info |
795: | Does the proration plsql_proration |
796: | update ra_ar_gt with the result |
797: | for group of line of all lines of a invoice |
798: +-------------------------------------------------------------------------+
792: | update_group_line |
793: +-------------------------------------------------------------------------+
794: | Read ra_ar_gt for proration info |
795: | Does the proration plsql_proration |
796: | update ra_ar_gt with the result |
797: | for group of line of all lines of a invoice |
798: +-------------------------------------------------------------------------+
799: | parameter: |
800: | p_customer_trx_id transaction id |
2439: b.TO_CURRENCY ,
2440: b.FROM_CURRENCY ,
2441: -- Rowid
2442: b.rowid
2443: FROM RA_AR_GT b,
2444: RA_AR_AMOUNTS_GT d
2445: WHERE b.gt_id = p_gt_id
2446: AND b.ref_customer_trx_id = p_customer_trx_id
2447: AND b.gp_level = 'L'
2715: x_run_uned_tax_acctd_alloc => l_run_uned_tax_acctd_alloc
2716: );
2717:
2718: IF PG_DEBUG = 'Y' THEN
2719: localdebug(' update ra_ar_gt trx_line_all ');
2720: END IF;
2721: FORALL i IN l_tab.ROWID_ID.FIRST .. l_tab.ROWID_ID.LAST
2722: UPDATE ra_ar_gt
2723: SET
2718: IF PG_DEBUG = 'Y' THEN
2719: localdebug(' update ra_ar_gt trx_line_all ');
2720: END IF;
2721: FORALL i IN l_tab.ROWID_ID.FIRST .. l_tab.ROWID_ID.LAST
2722: UPDATE ra_ar_gt
2723: SET
2724: -- ADJ and APP
2725: tl_alloc_amt = l_tab.tl_alloc_amt(i),
2726: tl_alloc_acctd_amt = l_tab.tl_alloc_acctd_amt(i),
2749: tl_uned_tax_alloc_amt = l_tab.tl_uned_tax_alloc_amt(i),
2750: tl_uned_tax_alloc_acctd_amt = l_tab.tl_uned_tax_alloc_acctd_amt(i)
2751: WHERE rowid = l_tab.ROWID_ID(i);
2752: IF PG_DEBUG = 'Y' THEN
2753: localdebug(' update ra_ar_gt trx_line_all ');
2754: END IF;
2755:
2756: END LOOP;
2757: CLOSE c_read_for_line;
2781:
2782: IF PG_DEBUG = 'Y' THEN
2783: localdebug(' for regular transaction');
2784: END IF;
2785: INSERT INTO RA_AR_GT
2786: ( GT_ID ,
2787: BASE_CURRENCY ,
2788: TO_CURRENCY ,
2789: REF_CUSTOMER_TRX_ID ,
3213: localdebug(' rows inserted = ' || l_rows);
3214: END IF;
3215:
3216: IF PG_DEBUG = 'Y' THEN
3217: display_ra_ar_gt(p_gt_id => p_gt_id);
3218: END IF;
3219:
3220: IF PG_DEBUG = 'Y' THEN
3221: localdebug('arp_det_dist_pkg.get_invoice_line_info()-');
3270: ------------------------------------------------------------------------
3271: -- Create groups
3272: -- The group_id used currently is ra_customer_trx_lines.SOURCE_DATA_KEY1
3273: ------------------------------------------------------------------------
3274: INSERT INTO ra_ar_gt
3275: (gt_id,
3276: gp_level,
3277: group_id,
3278: --{HYUBPAGP
3414: --{Taxable Amount
3415: -- ,rar.tax_link_id
3416: -- ,rar.tax_inc_flag
3417: --}
3418: FROM ra_ar_gt rar,
3419: (SELECT /*+INDEX (b ra_ar_n1)*/
3420: SUM(DECODE(b.line_type,'LINE' ,b.FRT_ADJ_REM_AMT,
3421: 'CB' ,b.FRT_ADJ_REM_AMT,
3422: 'FREIGHT',b.FRT_REM_AMT,
3434: ,b.source_data_key5
3435: --{HYUIssue
3436: ,b.ref_customer_trx_line_id
3437: --}
3438: FROM ra_ar_gt b
3439: WHERE b.ref_customer_trx_id = p_customer_trx_id
3440: AND b.gt_id = p_gt_id
3441: AND b.gp_level = 'L'
3442: AND b.set_of_books_id = p_ae_sys_rec.set_of_books_id
3474: --{HYUIssue
3475: ,b.ref_customer_trx_line_id
3476: --}
3477: --}
3478: FROM ra_ar_gt b
3479: WHERE b.ref_customer_trx_id = p_customer_trx_id
3480: AND b.gt_id = p_gt_id
3481: AND b.gp_level = 'L'
3482: AND b.set_of_books_id = p_ae_sys_rec.set_of_books_id
3578: localdebug(' rows inserted = ' || l_rows);
3579: END IF;
3580:
3581: IF PG_DEBUG = 'Y' THEN
3582: display_ra_ar_gt(p_code => 'GPL', p_gt_id => p_gt_id);
3583: END IF;
3584:
3585: ---------------------------------
3586: -- Determine the bucket for group
3990: 'Y',
3991: 'Y',
3992: 'N')
3993: else 0 end
3994: FROM RA_AR_GT a
3995: WHERE a.gt_id = p_gt_id
3996: AND a.ref_customer_trx_id = p_customer_trx_id
3997: AND a.gp_level = 'GPL'
3998: AND a.set_of_books_id = p_ae_sys_rec.set_of_books_id
3999: AND (a.sob_type = p_ae_sys_rec.sob_type OR
4000: (a.sob_type IS NULL AND p_ae_sys_rec.sob_type IS NULL));
4001:
4002: IF PG_DEBUG = 'Y' THEN
4003: display_ra_ar_gt(p_code => 'GPL',p_gt_id => p_gt_id);
4004: END IF;
4005:
4006: IF PG_DEBUG = 'Y' THEN
4007: localdebug('arp_det_dist_pkg.prepare_group_for_proration()-');
4959: else 0 end
4960: END
4961: ,c.TL_UNED_CHRG_ALLOC_AMT
4962: ,c.TL_UNED_CHRG_ALLOC_ACCTD_AMT
4963: FROM RA_AR_GT b,
4964: RA_AR_GT c,
4965: RA_AR_AMOUNTS_GT d
4966: WHERE b.gt_id = p_gt_id
4967: -- AND b.se_gt_id = g_se_gt_id
4960: END
4961: ,c.TL_UNED_CHRG_ALLOC_AMT
4962: ,c.TL_UNED_CHRG_ALLOC_ACCTD_AMT
4963: FROM RA_AR_GT b,
4964: RA_AR_GT c,
4965: RA_AR_AMOUNTS_GT d
4966: WHERE b.gt_id = p_gt_id
4967: -- AND b.se_gt_id = g_se_gt_id
4968: AND b.ref_customer_trx_id = p_customer_trx_id
4993: AND c.ref_customer_trx_line_id = b.ref_customer_trx_line_id;
4994: --}
4995:
4996: IF PG_DEBUG = 'Y' THEN
4997: display_ra_ar_gt(p_code => 'L', p_gt_id => p_gt_id);
4998: END IF;
4999:
5000: IF PG_DEBUG = 'Y' THEN
5001: localdebug('arp_det_dist_pkg.prepare_trx_line_proration()-');
5169: ,NVL(a.frt_uned_acctd_amount,0)
5170: + DECODE(p_pay_adj,'ADJ',0,
5171: DECODE(b.line_type,'LINE',NVL(b.tl_uned_frt_alloc_acctd_amt,0),
5172: 'CB' ,NVL(b.tl_uned_frt_alloc_acctd_amt,0),0))
5173: FROM RA_AR_GT b
5174: WHERE b.gt_id = p_gt_id
5175: -- AND b.se_gt_id = g_se_gt_id
5176: AND a.customer_trx_id = b.ref_customer_trx_id
5177: AND a.customer_trx_line_id = b.ref_customer_trx_line_id
5338: ,NVL(a.frt_uned_acctd_amount,0)
5339: + DECODE(p_pay_adj,'ADJ',0,
5340: DECODE(b.line_type,'LINE',NVL(b.tl_uned_frt_alloc_acctd_amt,0),
5341: 'CB' ,NVL(b.tl_uned_frt_alloc_acctd_amt,0),0))
5342: FROM RA_AR_GT b
5343: WHERE b.gt_id = p_gt_id
5344: -- AND b.se_gt_id = g_se_gt_id
5345: AND a.customer_trx_id = b.ref_customer_trx_id
5346: AND a.customer_trx_line_id = b.ref_customer_trx_line_id
5506: ,NVL(a.frt_uned_acctd_amount,0)
5507: + DECODE(p_pay_adj,'ADJ',0,
5508: DECODE(b.line_type,'LINE',NVL(b.tl_uned_frt_alloc_acctd_amt,0),
5509: 'CB' ,NVL(b.tl_uned_frt_alloc_acctd_amt,0),0))
5510: FROM RA_AR_GT b
5511: WHERE b.gt_id = p_gt_id
5512: -- AND b.se_gt_id = g_se_gt_id
5513: AND a.customer_trx_id = b.ref_customer_trx_id
5514: AND a.customer_trx_line_id = b.ref_customer_trx_line_id
5675: ,NVL(a.frt_uned_acctd_amount,0)
5676: + DECODE(p_pay_adj,'ADJ',0,
5677: DECODE(b.line_type,'LINE',NVL(b.tl_uned_frt_alloc_acctd_amt,0),
5678: 'CB' ,NVL(b.tl_uned_frt_alloc_acctd_amt,0),0))
5679: FROM RA_AR_GT b
5680: WHERE b.gt_id = p_gt_id
5681: -- AND b.se_gt_id = g_se_gt_id
5682: AND a.customer_trx_id = b.ref_customer_trx_id
5683: AND a.customer_trx_line_id = b.ref_customer_trx_line_id
5746: localdebug(' p_ae_sys_rec.set_of_books_id :'||p_ae_sys_rec.set_of_books_id);
5747: localdebug(' p_ae_sys_rec.sob_type :'||p_ae_sys_rec.sob_type);
5748: END IF;
5749:
5750: INSERT INTO RA_AR_GT
5751: ( GT_ID ,
5752: AMT ,
5753: ACCTD_AMT ,
5754: ACCOUNT_CLASS ,
5960: p_ae_sys_rec.set_of_books_id,
5961: p_ae_sys_rec.sob_type,
5962: rar.tax_link_id,
5963: rar.tax_inc_flag
5964: FROM ra_ar_gt rar,
5965: ra_cust_trx_line_gl_dist ctlgd
5966: WHERE rar.gt_id = p_gt_id
5967: AND rar.ref_customer_trx_id = p_customer_trx_id
5968: AND rar.gp_level = 'L'
6005: localdebug(' Normal R12 distributions');
6006: END IF;
6007:
6008: -- Adj Distribution R12
6009: INSERT INTO RA_AR_GT
6010: ( GT_ID ,
6011: AMT ,
6012: ACCTD_AMT ,
6013: ACCOUNT_CLASS ,
6634: DECODE(rrc.ref_account_class,'TAX','Y',
6635: --'REV',DECODE(NVL(adj.tax_adjusted,0),0, 'N','Y'),
6636: 'REV','Y', -- BUG 7597090
6637: 'N') -- tax_inc_flag
6638: FROM ra_ar_gt rar,
6639: ar_distributions rrc,
6640: ar_adjustments adj
6641: WHERE rar.gt_id = p_gt_id
6642: AND rar.ref_customer_trx_id = p_customer_trx_id
6657: --{Boundary distributions
6658: localdebug(' Boundary R12 distributions');
6659: END IF;
6660:
6661: INSERT INTO RA_AR_GT
6662: ( GT_ID ,
6663: AMT ,
6664: ACCTD_AMT ,
6665: ACCOUNT_CLASS ,
6863: p_ae_sys_rec.sob_type,
6864: rrc.tax_link_id, -- tax_link_id
6865: 'N' -- tax_inc_flag
6866: FROM ar_distributions rrc,
6867: (SELECT /*+INDEX (ra_ar_gt ra_ar_n1)*/
6868: MAX(group_id) group_id,
6869: --{HYUBPAGP
6870: MAX(source_data_key1) source_data_key1,
6871: MAX(source_data_key2) source_data_key2,
6872: MAX(source_data_key3) source_data_key3,
6873: MAX(source_data_key4) source_data_key4,
6874: MAX(source_data_key5) source_data_key5
6875: --}
6876: FROM ra_ar_gt
6877: WHERE gt_id = p_gt_id
6878: AND ref_customer_trx_id = p_customer_trx_id
6879: AND gp_level = 'L') g,
6880: ar_adjustments adj,
6908: IF g_mode_process = 'R12_11IMFAR' THEN
6909: IF PG_DEBUG = 'Y' THEN
6910: localdebug(' Mfar 11I legacy to R12 distributions');
6911: END IF;
6912: INSERT INTO RA_AR_GT
6913: ( GT_ID ,
6914: AMT ,
6915: ACCTD_AMT ,
6916: ACCOUNT_CLASS ,
7103: DECODE(ctl.line_type,'TAX','Y',
7104: 'REV',DECODE(NVL(adj.tax_adjusted,0),0, 'N','Y'),
7105: 'N'), -- tax_inc_flag
7106: 'Y' -- ref_mf_dist_flag
7107: FROM ra_ar_gt rar,
7108: psa_mf_adj_dist_all rrc,
7109: ra_cust_trx_line_gl_dist ctlgd,
7110: ra_customer_trx_lines ctl,
7111: ar_adjustments adj
7195: ,SUM(b.dist_uned_tax_amt) base_uned_dist_tax_amt
7196: ,SUM(b.dist_uned_tax_acctd_amt) base_uned_dist_tax_acctd_amt
7197: ,set_of_books_id
7198: ,sob_type
7199: FROM ra_ar_gt b
7200: WHERE b.gt_id = p_gt_id
7201: AND b.gp_level = 'D'
7202: AND b.set_of_books_id = p_ae_sys_rec.set_of_books_id
7203: AND (b.sob_type = p_ae_sys_rec.sob_type OR
7318: TO_CURRENCY ,
7319: FROM_CURRENCY ,
7320: -- Rowid
7321: a.rowid
7322: FROM RA_AR_GT a,AR_BASE_DIST_AMTS_GT b--[bug 6454022]
7323: WHERE a.gt_id = p_gt_id
7324: -- AND se_gt_id = g_se_gt_id
7325: AND a.ref_customer_trx_id = p_customer_trx_id
7326: AND a.ref_cust_trx_line_gl_dist_id IS NOT NULL
7602: x_run_uned_tax_acctd_amt => l_run_uned_tax_acctd_amt,
7603: x_run_uned_tax_acctd_alloc => l_run_uned_tax_acctd_alloc);
7604:
7605: FORALL i IN l_tab.ROWID_ID.FIRST .. l_tab.ROWID_ID.LAST
7606: UPDATE ra_ar_gt
7607: SET
7608: -- ADJ and APP
7609: tl_alloc_amt = l_tab.tl_alloc_amt(i),
7610: tl_alloc_acctd_amt = l_tab.tl_alloc_acctd_amt(i),
7794: ,tax_inc_flag
7795: , p_ae_sys_rec.set_of_books_id
7796: , ref_mf_dist_flag
7797: , g_org_id
7798: FROM RA_AR_GT a,
7799: (SELECT DECODE(ROWNUM,1, 'RAADJLINE',
7800: 2,'RAADJFREIGHT',
7801: 3,'RAADJTAX',
7802: 4,'RAADJCHARGES',
7973: tax_inc_flag,
7974: p_ae_sys_rec.set_of_books_id,
7975: ref_mf_dist_flag,
7976: arp_standard.sysparm.org_id
7977: FROM RA_AR_GT a,
7978: (SELECT DECODE(ROWNUM,1, 'RAADJLINE',
7979: 2,'RAADJFREIGHT',
7980: 3,'RAADJTAX',
7981: 4,'RAADJCHARGES',
8897: RAISE;
8898: END set_original_rem_amt;
8899:
8900:
8901: PROCEDURE insert_ra_ar_gt
8902: ( p_ra_ar_gt IN ra_ar_gt%ROWTYPE,
8903: p_ar_base_dist_amts_gt IN ar_base_dist_amts_gt%ROWTYPE,
8904: p_ra_ar_amounts_gt IN ra_ar_amounts_gt%ROWTYPE
8905: )
8898: END set_original_rem_amt;
8899:
8900:
8901: PROCEDURE insert_ra_ar_gt
8902: ( p_ra_ar_gt IN ra_ar_gt%ROWTYPE,
8903: p_ar_base_dist_amts_gt IN ar_base_dist_amts_gt%ROWTYPE,
8904: p_ra_ar_amounts_gt IN ra_ar_amounts_gt%ROWTYPE
8905: )
8906: IS
8906: IS
8907: l_rows NUMBER;
8908: l_base_rowid ROWID;
8909: BEGIN
8910: INSERT INTO ra_ar_gt
8911: (
8912: GT_ID
8913: ,BASE_CURRENCY
8914: ,TO_CURRENCY
9030: , activity_bucket
9031: )
9032: VALUES
9033: (
9034: p_ra_ar_gt.GT_ID --GT_ID
9035: ,p_ra_ar_gt.BASE_CURRENCY --BASE_CURRENCY
9036: ,p_ra_ar_gt.TO_CURRENCY --TO_CURRENCY
9037: ,p_ra_ar_gt.FROM_CURRENCY --FROM_CURRENCY
9038: ,p_ra_ar_gt.DET_ID --DET_ID
9031: )
9032: VALUES
9033: (
9034: p_ra_ar_gt.GT_ID --GT_ID
9035: ,p_ra_ar_gt.BASE_CURRENCY --BASE_CURRENCY
9036: ,p_ra_ar_gt.TO_CURRENCY --TO_CURRENCY
9037: ,p_ra_ar_gt.FROM_CURRENCY --FROM_CURRENCY
9038: ,p_ra_ar_gt.DET_ID --DET_ID
9039: ,p_ra_ar_gt.LINE_ID --LINE_ID
9032: VALUES
9033: (
9034: p_ra_ar_gt.GT_ID --GT_ID
9035: ,p_ra_ar_gt.BASE_CURRENCY --BASE_CURRENCY
9036: ,p_ra_ar_gt.TO_CURRENCY --TO_CURRENCY
9037: ,p_ra_ar_gt.FROM_CURRENCY --FROM_CURRENCY
9038: ,p_ra_ar_gt.DET_ID --DET_ID
9039: ,p_ra_ar_gt.LINE_ID --LINE_ID
9040: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID
9033: (
9034: p_ra_ar_gt.GT_ID --GT_ID
9035: ,p_ra_ar_gt.BASE_CURRENCY --BASE_CURRENCY
9036: ,p_ra_ar_gt.TO_CURRENCY --TO_CURRENCY
9037: ,p_ra_ar_gt.FROM_CURRENCY --FROM_CURRENCY
9038: ,p_ra_ar_gt.DET_ID --DET_ID
9039: ,p_ra_ar_gt.LINE_ID --LINE_ID
9040: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID
9041: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID
9034: p_ra_ar_gt.GT_ID --GT_ID
9035: ,p_ra_ar_gt.BASE_CURRENCY --BASE_CURRENCY
9036: ,p_ra_ar_gt.TO_CURRENCY --TO_CURRENCY
9037: ,p_ra_ar_gt.FROM_CURRENCY --FROM_CURRENCY
9038: ,p_ra_ar_gt.DET_ID --DET_ID
9039: ,p_ra_ar_gt.LINE_ID --LINE_ID
9040: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID
9041: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID
9042: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID
9035: ,p_ra_ar_gt.BASE_CURRENCY --BASE_CURRENCY
9036: ,p_ra_ar_gt.TO_CURRENCY --TO_CURRENCY
9037: ,p_ra_ar_gt.FROM_CURRENCY --FROM_CURRENCY
9038: ,p_ra_ar_gt.DET_ID --DET_ID
9039: ,p_ra_ar_gt.LINE_ID --LINE_ID
9040: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID
9041: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID
9042: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID
9043: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID
9036: ,p_ra_ar_gt.TO_CURRENCY --TO_CURRENCY
9037: ,p_ra_ar_gt.FROM_CURRENCY --FROM_CURRENCY
9038: ,p_ra_ar_gt.DET_ID --DET_ID
9039: ,p_ra_ar_gt.LINE_ID --LINE_ID
9040: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID
9041: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID
9042: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID
9043: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID
9044: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID
9037: ,p_ra_ar_gt.FROM_CURRENCY --FROM_CURRENCY
9038: ,p_ra_ar_gt.DET_ID --DET_ID
9039: ,p_ra_ar_gt.LINE_ID --LINE_ID
9040: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID
9041: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID
9042: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID
9043: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID
9044: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID
9045: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS
9038: ,p_ra_ar_gt.DET_ID --DET_ID
9039: ,p_ra_ar_gt.LINE_ID --LINE_ID
9040: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID
9041: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID
9042: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID
9043: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID
9044: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID
9045: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS
9046: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE
9039: ,p_ra_ar_gt.LINE_ID --LINE_ID
9040: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID
9041: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID
9042: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID
9043: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID
9044: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID
9045: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS
9046: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE
9047: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE
9040: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID
9041: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID
9042: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID
9043: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID
9044: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID
9045: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS
9046: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE
9047: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE
9048: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID
9041: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID
9042: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID
9043: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID
9044: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID
9045: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS
9046: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE
9047: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE
9048: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID
9049: ,p_ra_ar_gt.AMT --AMT
9042: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID
9043: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID
9044: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID
9045: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS
9046: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE
9047: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE
9048: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID
9049: ,p_ra_ar_gt.AMT --AMT
9050: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT
9043: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID
9044: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID
9045: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS
9046: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE
9047: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE
9048: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID
9049: ,p_ra_ar_gt.AMT --AMT
9050: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT
9051: ,p_ra_ar_gt.AMT_DR --AMT_DR
9044: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID
9045: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS
9046: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE
9047: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE
9048: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID
9049: ,p_ra_ar_gt.AMT --AMT
9050: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT
9051: ,p_ra_ar_gt.AMT_DR --AMT_DR
9052: ,p_ra_ar_gt.AMT_CR --AMT_CR
9045: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS
9046: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE
9047: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE
9048: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID
9049: ,p_ra_ar_gt.AMT --AMT
9050: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT
9051: ,p_ra_ar_gt.AMT_DR --AMT_DR
9052: ,p_ra_ar_gt.AMT_CR --AMT_CR
9053: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR
9046: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE
9047: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE
9048: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID
9049: ,p_ra_ar_gt.AMT --AMT
9050: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT
9051: ,p_ra_ar_gt.AMT_DR --AMT_DR
9052: ,p_ra_ar_gt.AMT_CR --AMT_CR
9053: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR
9054: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR
9047: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE
9048: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID
9049: ,p_ra_ar_gt.AMT --AMT
9050: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT
9051: ,p_ra_ar_gt.AMT_DR --AMT_DR
9052: ,p_ra_ar_gt.AMT_CR --AMT_CR
9053: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR
9054: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR
9055: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR
9048: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID
9049: ,p_ra_ar_gt.AMT --AMT
9050: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT
9051: ,p_ra_ar_gt.AMT_DR --AMT_DR
9052: ,p_ra_ar_gt.AMT_CR --AMT_CR
9053: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR
9054: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR
9055: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR
9056: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR
9049: ,p_ra_ar_gt.AMT --AMT
9050: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT
9051: ,p_ra_ar_gt.AMT_DR --AMT_DR
9052: ,p_ra_ar_gt.AMT_CR --AMT_CR
9053: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR
9054: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR
9055: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR
9056: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR
9057: ,p_ra_ar_gt.CCID --CCID
9050: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT
9051: ,p_ra_ar_gt.AMT_DR --AMT_DR
9052: ,p_ra_ar_gt.AMT_CR --AMT_CR
9053: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR
9054: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR
9055: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR
9056: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR
9057: ,p_ra_ar_gt.CCID --CCID
9058: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY
9051: ,p_ra_ar_gt.AMT_DR --AMT_DR
9052: ,p_ra_ar_gt.AMT_CR --AMT_CR
9053: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR
9054: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR
9055: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR
9056: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR
9057: ,p_ra_ar_gt.CCID --CCID
9058: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY
9059: ,p_ra_ar_gt.DIST_AMT --DIST_AMT
9052: ,p_ra_ar_gt.AMT_CR --AMT_CR
9053: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR
9054: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR
9055: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR
9056: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR
9057: ,p_ra_ar_gt.CCID --CCID
9058: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY
9059: ,p_ra_ar_gt.DIST_AMT --DIST_AMT
9060: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT
9053: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR
9054: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR
9055: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR
9056: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR
9057: ,p_ra_ar_gt.CCID --CCID
9058: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY
9059: ,p_ra_ar_gt.DIST_AMT --DIST_AMT
9060: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT
9061: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT
9054: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR
9055: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR
9056: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR
9057: ,p_ra_ar_gt.CCID --CCID
9058: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY
9059: ,p_ra_ar_gt.DIST_AMT --DIST_AMT
9060: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT
9061: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT
9062: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT
9055: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR
9056: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR
9057: ,p_ra_ar_gt.CCID --CCID
9058: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY
9059: ,p_ra_ar_gt.DIST_AMT --DIST_AMT
9060: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT
9061: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT
9062: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT
9063: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT
9056: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR
9057: ,p_ra_ar_gt.CCID --CCID
9058: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY
9059: ,p_ra_ar_gt.DIST_AMT --DIST_AMT
9060: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT
9061: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT
9062: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT
9063: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT
9064: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT
9057: ,p_ra_ar_gt.CCID --CCID
9058: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY
9059: ,p_ra_ar_gt.DIST_AMT --DIST_AMT
9060: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT
9061: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT
9062: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT
9063: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT
9064: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT
9065: ,p_ra_ar_gt.tl_alloc_amt --TL_ALLOC_AMT
9058: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY
9059: ,p_ra_ar_gt.DIST_AMT --DIST_AMT
9060: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT
9061: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT
9062: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT
9063: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT
9064: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT
9065: ,p_ra_ar_gt.tl_alloc_amt --TL_ALLOC_AMT
9066: ,p_ra_ar_gt.tl_alloc_acctd_amt --TL_ALLOC_ACCTD_AMT
9059: ,p_ra_ar_gt.DIST_AMT --DIST_AMT
9060: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT
9061: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT
9062: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT
9063: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT
9064: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT
9065: ,p_ra_ar_gt.tl_alloc_amt --TL_ALLOC_AMT
9066: ,p_ra_ar_gt.tl_alloc_acctd_amt --TL_ALLOC_ACCTD_AMT
9067: ,p_ra_ar_gt.tl_chrg_alloc_amt
9060: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT
9061: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT
9062: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT
9063: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT
9064: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT
9065: ,p_ra_ar_gt.tl_alloc_amt --TL_ALLOC_AMT
9066: ,p_ra_ar_gt.tl_alloc_acctd_amt --TL_ALLOC_ACCTD_AMT
9067: ,p_ra_ar_gt.tl_chrg_alloc_amt
9068: ,p_ra_ar_gt.tl_chrg_alloc_acctd_amt
9061: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT
9062: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT
9063: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT
9064: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT
9065: ,p_ra_ar_gt.tl_alloc_amt --TL_ALLOC_AMT
9066: ,p_ra_ar_gt.tl_alloc_acctd_amt --TL_ALLOC_ACCTD_AMT
9067: ,p_ra_ar_gt.tl_chrg_alloc_amt
9068: ,p_ra_ar_gt.tl_chrg_alloc_acctd_amt
9069: --
9062: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT
9063: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT
9064: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT
9065: ,p_ra_ar_gt.tl_alloc_amt --TL_ALLOC_AMT
9066: ,p_ra_ar_gt.tl_alloc_acctd_amt --TL_ALLOC_ACCTD_AMT
9067: ,p_ra_ar_gt.tl_chrg_alloc_amt
9068: ,p_ra_ar_gt.tl_chrg_alloc_acctd_amt
9069: --
9070: ,p_ra_ar_gt.tl_frt_alloc_amt --TL_FRT_ALLOC_AMT
9063: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT
9064: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT
9065: ,p_ra_ar_gt.tl_alloc_amt --TL_ALLOC_AMT
9066: ,p_ra_ar_gt.tl_alloc_acctd_amt --TL_ALLOC_ACCTD_AMT
9067: ,p_ra_ar_gt.tl_chrg_alloc_amt
9068: ,p_ra_ar_gt.tl_chrg_alloc_acctd_amt
9069: --
9070: ,p_ra_ar_gt.tl_frt_alloc_amt --TL_FRT_ALLOC_AMT
9071: ,p_ra_ar_gt.tl_frt_alloc_acctd_amt --TL_FRT_ALLOC_ACCTD_AMT
9064: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT
9065: ,p_ra_ar_gt.tl_alloc_amt --TL_ALLOC_AMT
9066: ,p_ra_ar_gt.tl_alloc_acctd_amt --TL_ALLOC_ACCTD_AMT
9067: ,p_ra_ar_gt.tl_chrg_alloc_amt
9068: ,p_ra_ar_gt.tl_chrg_alloc_acctd_amt
9069: --
9070: ,p_ra_ar_gt.tl_frt_alloc_amt --TL_FRT_ALLOC_AMT
9071: ,p_ra_ar_gt.tl_frt_alloc_acctd_amt --TL_FRT_ALLOC_ACCTD_AMT
9072: ,p_ra_ar_gt.tl_tax_alloc_amt
9066: ,p_ra_ar_gt.tl_alloc_acctd_amt --TL_ALLOC_ACCTD_AMT
9067: ,p_ra_ar_gt.tl_chrg_alloc_amt
9068: ,p_ra_ar_gt.tl_chrg_alloc_acctd_amt
9069: --
9070: ,p_ra_ar_gt.tl_frt_alloc_amt --TL_FRT_ALLOC_AMT
9071: ,p_ra_ar_gt.tl_frt_alloc_acctd_amt --TL_FRT_ALLOC_ACCTD_AMT
9072: ,p_ra_ar_gt.tl_tax_alloc_amt
9073: ,p_ra_ar_gt.tl_tax_alloc_acctd_amt
9074: --
9067: ,p_ra_ar_gt.tl_chrg_alloc_amt
9068: ,p_ra_ar_gt.tl_chrg_alloc_acctd_amt
9069: --
9070: ,p_ra_ar_gt.tl_frt_alloc_amt --TL_FRT_ALLOC_AMT
9071: ,p_ra_ar_gt.tl_frt_alloc_acctd_amt --TL_FRT_ALLOC_ACCTD_AMT
9072: ,p_ra_ar_gt.tl_tax_alloc_amt
9073: ,p_ra_ar_gt.tl_tax_alloc_acctd_amt
9074: --
9075: ,p_ra_ar_gt.DUE_REM_AMT
9068: ,p_ra_ar_gt.tl_chrg_alloc_acctd_amt
9069: --
9070: ,p_ra_ar_gt.tl_frt_alloc_amt --TL_FRT_ALLOC_AMT
9071: ,p_ra_ar_gt.tl_frt_alloc_acctd_amt --TL_FRT_ALLOC_ACCTD_AMT
9072: ,p_ra_ar_gt.tl_tax_alloc_amt
9073: ,p_ra_ar_gt.tl_tax_alloc_acctd_amt
9074: --
9075: ,p_ra_ar_gt.DUE_REM_AMT
9076: ,p_ra_ar_gt.DUE_REM_ACCTD_AMT
9069: --
9070: ,p_ra_ar_gt.tl_frt_alloc_amt --TL_FRT_ALLOC_AMT
9071: ,p_ra_ar_gt.tl_frt_alloc_acctd_amt --TL_FRT_ALLOC_ACCTD_AMT
9072: ,p_ra_ar_gt.tl_tax_alloc_amt
9073: ,p_ra_ar_gt.tl_tax_alloc_acctd_amt
9074: --
9075: ,p_ra_ar_gt.DUE_REM_AMT
9076: ,p_ra_ar_gt.DUE_REM_ACCTD_AMT
9077: --
9071: ,p_ra_ar_gt.tl_frt_alloc_acctd_amt --TL_FRT_ALLOC_ACCTD_AMT
9072: ,p_ra_ar_gt.tl_tax_alloc_amt
9073: ,p_ra_ar_gt.tl_tax_alloc_acctd_amt
9074: --
9075: ,p_ra_ar_gt.DUE_REM_AMT
9076: ,p_ra_ar_gt.DUE_REM_ACCTD_AMT
9077: --
9078: ,p_ra_ar_gt.FRT_REM_AMT
9079: ,p_ra_ar_gt.FRT_REM_ACCTD_AMT
9072: ,p_ra_ar_gt.tl_tax_alloc_amt
9073: ,p_ra_ar_gt.tl_tax_alloc_acctd_amt
9074: --
9075: ,p_ra_ar_gt.DUE_REM_AMT
9076: ,p_ra_ar_gt.DUE_REM_ACCTD_AMT
9077: --
9078: ,p_ra_ar_gt.FRT_REM_AMT
9079: ,p_ra_ar_gt.FRT_REM_ACCTD_AMT
9080: ,p_ra_ar_gt.TAX_REM_AMT
9074: --
9075: ,p_ra_ar_gt.DUE_REM_AMT
9076: ,p_ra_ar_gt.DUE_REM_ACCTD_AMT
9077: --
9078: ,p_ra_ar_gt.FRT_REM_AMT
9079: ,p_ra_ar_gt.FRT_REM_ACCTD_AMT
9080: ,p_ra_ar_gt.TAX_REM_AMT
9081: ,p_ra_ar_gt.TAX_REM_ACCTD_AMT
9082: --
9075: ,p_ra_ar_gt.DUE_REM_AMT
9076: ,p_ra_ar_gt.DUE_REM_ACCTD_AMT
9077: --
9078: ,p_ra_ar_gt.FRT_REM_AMT
9079: ,p_ra_ar_gt.FRT_REM_ACCTD_AMT
9080: ,p_ra_ar_gt.TAX_REM_AMT
9081: ,p_ra_ar_gt.TAX_REM_ACCTD_AMT
9082: --
9083: ,p_ra_ar_gt.DUE_ORIG_AMT
9076: ,p_ra_ar_gt.DUE_REM_ACCTD_AMT
9077: --
9078: ,p_ra_ar_gt.FRT_REM_AMT
9079: ,p_ra_ar_gt.FRT_REM_ACCTD_AMT
9080: ,p_ra_ar_gt.TAX_REM_AMT
9081: ,p_ra_ar_gt.TAX_REM_ACCTD_AMT
9082: --
9083: ,p_ra_ar_gt.DUE_ORIG_AMT
9084: ,p_ra_ar_gt.DUE_ORIG_ACCTD_AMT
9077: --
9078: ,p_ra_ar_gt.FRT_REM_AMT
9079: ,p_ra_ar_gt.FRT_REM_ACCTD_AMT
9080: ,p_ra_ar_gt.TAX_REM_AMT
9081: ,p_ra_ar_gt.TAX_REM_ACCTD_AMT
9082: --
9083: ,p_ra_ar_gt.DUE_ORIG_AMT
9084: ,p_ra_ar_gt.DUE_ORIG_ACCTD_AMT
9085: --
9079: ,p_ra_ar_gt.FRT_REM_ACCTD_AMT
9080: ,p_ra_ar_gt.TAX_REM_AMT
9081: ,p_ra_ar_gt.TAX_REM_ACCTD_AMT
9082: --
9083: ,p_ra_ar_gt.DUE_ORIG_AMT
9084: ,p_ra_ar_gt.DUE_ORIG_ACCTD_AMT
9085: --
9086: ,p_ra_ar_gt.FRT_ORIG_AMT
9087: ,p_ra_ar_gt.FRT_ORIG_ACCTD_AMT
9080: ,p_ra_ar_gt.TAX_REM_AMT
9081: ,p_ra_ar_gt.TAX_REM_ACCTD_AMT
9082: --
9083: ,p_ra_ar_gt.DUE_ORIG_AMT
9084: ,p_ra_ar_gt.DUE_ORIG_ACCTD_AMT
9085: --
9086: ,p_ra_ar_gt.FRT_ORIG_AMT
9087: ,p_ra_ar_gt.FRT_ORIG_ACCTD_AMT
9088: ,p_ra_ar_gt.TAX_ORIG_AMT
9082: --
9083: ,p_ra_ar_gt.DUE_ORIG_AMT
9084: ,p_ra_ar_gt.DUE_ORIG_ACCTD_AMT
9085: --
9086: ,p_ra_ar_gt.FRT_ORIG_AMT
9087: ,p_ra_ar_gt.FRT_ORIG_ACCTD_AMT
9088: ,p_ra_ar_gt.TAX_ORIG_AMT
9089: ,p_ra_ar_gt.TAX_ORIG_ACCTD_AMT
9090: --
9083: ,p_ra_ar_gt.DUE_ORIG_AMT
9084: ,p_ra_ar_gt.DUE_ORIG_ACCTD_AMT
9085: --
9086: ,p_ra_ar_gt.FRT_ORIG_AMT
9087: ,p_ra_ar_gt.FRT_ORIG_ACCTD_AMT
9088: ,p_ra_ar_gt.TAX_ORIG_AMT
9089: ,p_ra_ar_gt.TAX_ORIG_ACCTD_AMT
9090: --
9091: ,p_ra_ar_gt.CHRG_REM_AMT
9084: ,p_ra_ar_gt.DUE_ORIG_ACCTD_AMT
9085: --
9086: ,p_ra_ar_gt.FRT_ORIG_AMT
9087: ,p_ra_ar_gt.FRT_ORIG_ACCTD_AMT
9088: ,p_ra_ar_gt.TAX_ORIG_AMT
9089: ,p_ra_ar_gt.TAX_ORIG_ACCTD_AMT
9090: --
9091: ,p_ra_ar_gt.CHRG_REM_AMT
9092: ,p_ra_ar_gt.CHRG_REM_ACCTD_AMT
9085: --
9086: ,p_ra_ar_gt.FRT_ORIG_AMT
9087: ,p_ra_ar_gt.FRT_ORIG_ACCTD_AMT
9088: ,p_ra_ar_gt.TAX_ORIG_AMT
9089: ,p_ra_ar_gt.TAX_ORIG_ACCTD_AMT
9090: --
9091: ,p_ra_ar_gt.CHRG_REM_AMT
9092: ,p_ra_ar_gt.CHRG_REM_ACCTD_AMT
9093: --
9087: ,p_ra_ar_gt.FRT_ORIG_ACCTD_AMT
9088: ,p_ra_ar_gt.TAX_ORIG_AMT
9089: ,p_ra_ar_gt.TAX_ORIG_ACCTD_AMT
9090: --
9091: ,p_ra_ar_gt.CHRG_REM_AMT
9092: ,p_ra_ar_gt.CHRG_REM_ACCTD_AMT
9093: --
9094: ,p_ra_ar_gt.FRT_ADJ_REM_AMT
9095: ,p_ra_ar_gt.FRT_ADJ_REM_ACCTD_AMT
9088: ,p_ra_ar_gt.TAX_ORIG_AMT
9089: ,p_ra_ar_gt.TAX_ORIG_ACCTD_AMT
9090: --
9091: ,p_ra_ar_gt.CHRG_REM_AMT
9092: ,p_ra_ar_gt.CHRG_REM_ACCTD_AMT
9093: --
9094: ,p_ra_ar_gt.FRT_ADJ_REM_AMT
9095: ,p_ra_ar_gt.FRT_ADJ_REM_ACCTD_AMT
9096: --
9090: --
9091: ,p_ra_ar_gt.CHRG_REM_AMT
9092: ,p_ra_ar_gt.CHRG_REM_ACCTD_AMT
9093: --
9094: ,p_ra_ar_gt.FRT_ADJ_REM_AMT
9095: ,p_ra_ar_gt.FRT_ADJ_REM_ACCTD_AMT
9096: --
9097: ,p_ra_ar_gt.LINE_TYPE
9098: ,p_ra_ar_gt.SUM_LINE_REM_AMT
9091: ,p_ra_ar_gt.CHRG_REM_AMT
9092: ,p_ra_ar_gt.CHRG_REM_ACCTD_AMT
9093: --
9094: ,p_ra_ar_gt.FRT_ADJ_REM_AMT
9095: ,p_ra_ar_gt.FRT_ADJ_REM_ACCTD_AMT
9096: --
9097: ,p_ra_ar_gt.LINE_TYPE
9098: ,p_ra_ar_gt.SUM_LINE_REM_AMT
9099: ,p_ra_ar_gt.SUM_LINE_REM_ACCTD_AMT
9093: --
9094: ,p_ra_ar_gt.FRT_ADJ_REM_AMT
9095: ,p_ra_ar_gt.FRT_ADJ_REM_ACCTD_AMT
9096: --
9097: ,p_ra_ar_gt.LINE_TYPE
9098: ,p_ra_ar_gt.SUM_LINE_REM_AMT
9099: ,p_ra_ar_gt.SUM_LINE_REM_ACCTD_AMT
9100: --
9101: ,p_ra_ar_gt.SUM_LINE_FRT_REM_AMT
9094: ,p_ra_ar_gt.FRT_ADJ_REM_AMT
9095: ,p_ra_ar_gt.FRT_ADJ_REM_ACCTD_AMT
9096: --
9097: ,p_ra_ar_gt.LINE_TYPE
9098: ,p_ra_ar_gt.SUM_LINE_REM_AMT
9099: ,p_ra_ar_gt.SUM_LINE_REM_ACCTD_AMT
9100: --
9101: ,p_ra_ar_gt.SUM_LINE_FRT_REM_AMT
9102: ,p_ra_ar_gt.SUM_LINE_FRT_REM_ACCTD_AMT
9095: ,p_ra_ar_gt.FRT_ADJ_REM_ACCTD_AMT
9096: --
9097: ,p_ra_ar_gt.LINE_TYPE
9098: ,p_ra_ar_gt.SUM_LINE_REM_AMT
9099: ,p_ra_ar_gt.SUM_LINE_REM_ACCTD_AMT
9100: --
9101: ,p_ra_ar_gt.SUM_LINE_FRT_REM_AMT
9102: ,p_ra_ar_gt.SUM_LINE_FRT_REM_ACCTD_AMT
9103: ,p_ra_ar_gt.SUM_LINE_TAX_REM_AMT
9097: ,p_ra_ar_gt.LINE_TYPE
9098: ,p_ra_ar_gt.SUM_LINE_REM_AMT
9099: ,p_ra_ar_gt.SUM_LINE_REM_ACCTD_AMT
9100: --
9101: ,p_ra_ar_gt.SUM_LINE_FRT_REM_AMT
9102: ,p_ra_ar_gt.SUM_LINE_FRT_REM_ACCTD_AMT
9103: ,p_ra_ar_gt.SUM_LINE_TAX_REM_AMT
9104: ,p_ra_ar_gt.SUM_LINE_TAX_REM_ACCTD_AMT
9105: --
9098: ,p_ra_ar_gt.SUM_LINE_REM_AMT
9099: ,p_ra_ar_gt.SUM_LINE_REM_ACCTD_AMT
9100: --
9101: ,p_ra_ar_gt.SUM_LINE_FRT_REM_AMT
9102: ,p_ra_ar_gt.SUM_LINE_FRT_REM_ACCTD_AMT
9103: ,p_ra_ar_gt.SUM_LINE_TAX_REM_AMT
9104: ,p_ra_ar_gt.SUM_LINE_TAX_REM_ACCTD_AMT
9105: --
9106: ,p_ra_ar_gt.SUM_LINE_ORIG_AMT
9099: ,p_ra_ar_gt.SUM_LINE_REM_ACCTD_AMT
9100: --
9101: ,p_ra_ar_gt.SUM_LINE_FRT_REM_AMT
9102: ,p_ra_ar_gt.SUM_LINE_FRT_REM_ACCTD_AMT
9103: ,p_ra_ar_gt.SUM_LINE_TAX_REM_AMT
9104: ,p_ra_ar_gt.SUM_LINE_TAX_REM_ACCTD_AMT
9105: --
9106: ,p_ra_ar_gt.SUM_LINE_ORIG_AMT
9107: ,p_ra_ar_gt.SUM_LINE_ORIG_ACCTD_AMT
9100: --
9101: ,p_ra_ar_gt.SUM_LINE_FRT_REM_AMT
9102: ,p_ra_ar_gt.SUM_LINE_FRT_REM_ACCTD_AMT
9103: ,p_ra_ar_gt.SUM_LINE_TAX_REM_AMT
9104: ,p_ra_ar_gt.SUM_LINE_TAX_REM_ACCTD_AMT
9105: --
9106: ,p_ra_ar_gt.SUM_LINE_ORIG_AMT
9107: ,p_ra_ar_gt.SUM_LINE_ORIG_ACCTD_AMT
9108: --
9102: ,p_ra_ar_gt.SUM_LINE_FRT_REM_ACCTD_AMT
9103: ,p_ra_ar_gt.SUM_LINE_TAX_REM_AMT
9104: ,p_ra_ar_gt.SUM_LINE_TAX_REM_ACCTD_AMT
9105: --
9106: ,p_ra_ar_gt.SUM_LINE_ORIG_AMT
9107: ,p_ra_ar_gt.SUM_LINE_ORIG_ACCTD_AMT
9108: --
9109: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_AMT
9110: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_ACCTD_AMT
9103: ,p_ra_ar_gt.SUM_LINE_TAX_REM_AMT
9104: ,p_ra_ar_gt.SUM_LINE_TAX_REM_ACCTD_AMT
9105: --
9106: ,p_ra_ar_gt.SUM_LINE_ORIG_AMT
9107: ,p_ra_ar_gt.SUM_LINE_ORIG_ACCTD_AMT
9108: --
9109: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_AMT
9110: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_ACCTD_AMT
9111: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_AMT
9105: --
9106: ,p_ra_ar_gt.SUM_LINE_ORIG_AMT
9107: ,p_ra_ar_gt.SUM_LINE_ORIG_ACCTD_AMT
9108: --
9109: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_AMT
9110: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_ACCTD_AMT
9111: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_AMT
9112: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_ACCTD_AMT
9113: --
9106: ,p_ra_ar_gt.SUM_LINE_ORIG_AMT
9107: ,p_ra_ar_gt.SUM_LINE_ORIG_ACCTD_AMT
9108: --
9109: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_AMT
9110: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_ACCTD_AMT
9111: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_AMT
9112: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_ACCTD_AMT
9113: --
9114: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_AMT
9107: ,p_ra_ar_gt.SUM_LINE_ORIG_ACCTD_AMT
9108: --
9109: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_AMT
9110: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_ACCTD_AMT
9111: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_AMT
9112: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_ACCTD_AMT
9113: --
9114: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_AMT
9115: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_ACCTD_AMT
9108: --
9109: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_AMT
9110: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_ACCTD_AMT
9111: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_AMT
9112: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_ACCTD_AMT
9113: --
9114: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_AMT
9115: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_ACCTD_AMT
9116: --
9110: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_ACCTD_AMT
9111: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_AMT
9112: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_ACCTD_AMT
9113: --
9114: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_AMT
9115: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_ACCTD_AMT
9116: --
9117: ,p_ra_ar_gt.TL_ED_ALLOC_AMT
9118: ,p_ra_ar_gt.TL_ED_ALLOC_ACCTD_AMT
9111: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_AMT
9112: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_ACCTD_AMT
9113: --
9114: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_AMT
9115: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_ACCTD_AMT
9116: --
9117: ,p_ra_ar_gt.TL_ED_ALLOC_AMT
9118: ,p_ra_ar_gt.TL_ED_ALLOC_ACCTD_AMT
9119: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_AMT
9113: --
9114: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_AMT
9115: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_ACCTD_AMT
9116: --
9117: ,p_ra_ar_gt.TL_ED_ALLOC_AMT
9118: ,p_ra_ar_gt.TL_ED_ALLOC_ACCTD_AMT
9119: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_AMT
9120: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_ACCTD_AMT
9121: --
9114: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_AMT
9115: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_ACCTD_AMT
9116: --
9117: ,p_ra_ar_gt.TL_ED_ALLOC_AMT
9118: ,p_ra_ar_gt.TL_ED_ALLOC_ACCTD_AMT
9119: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_AMT
9120: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_ACCTD_AMT
9121: --
9122: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_AMT
9115: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_ACCTD_AMT
9116: --
9117: ,p_ra_ar_gt.TL_ED_ALLOC_AMT
9118: ,p_ra_ar_gt.TL_ED_ALLOC_ACCTD_AMT
9119: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_AMT
9120: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_ACCTD_AMT
9121: --
9122: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_AMT
9123: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_ACCTD_AMT
9116: --
9117: ,p_ra_ar_gt.TL_ED_ALLOC_AMT
9118: ,p_ra_ar_gt.TL_ED_ALLOC_ACCTD_AMT
9119: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_AMT
9120: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_ACCTD_AMT
9121: --
9122: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_AMT
9123: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_ACCTD_AMT
9124: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_AMT
9118: ,p_ra_ar_gt.TL_ED_ALLOC_ACCTD_AMT
9119: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_AMT
9120: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_ACCTD_AMT
9121: --
9122: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_AMT
9123: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_ACCTD_AMT
9124: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_AMT
9125: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_ACCTD_AMT
9126: --
9119: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_AMT
9120: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_ACCTD_AMT
9121: --
9122: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_AMT
9123: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_ACCTD_AMT
9124: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_AMT
9125: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_ACCTD_AMT
9126: --
9127: ,p_ra_ar_gt.TL_UNED_ALLOC_AMT
9120: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_ACCTD_AMT
9121: --
9122: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_AMT
9123: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_ACCTD_AMT
9124: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_AMT
9125: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_ACCTD_AMT
9126: --
9127: ,p_ra_ar_gt.TL_UNED_ALLOC_AMT
9128: ,p_ra_ar_gt.TL_UNED_ALLOC_ACCTD_AMT
9121: --
9122: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_AMT
9123: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_ACCTD_AMT
9124: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_AMT
9125: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_ACCTD_AMT
9126: --
9127: ,p_ra_ar_gt.TL_UNED_ALLOC_AMT
9128: ,p_ra_ar_gt.TL_UNED_ALLOC_ACCTD_AMT
9129: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_AMT
9123: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_ACCTD_AMT
9124: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_AMT
9125: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_ACCTD_AMT
9126: --
9127: ,p_ra_ar_gt.TL_UNED_ALLOC_AMT
9128: ,p_ra_ar_gt.TL_UNED_ALLOC_ACCTD_AMT
9129: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_AMT
9130: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_ACCTD_AMT
9131: --
9124: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_AMT
9125: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_ACCTD_AMT
9126: --
9127: ,p_ra_ar_gt.TL_UNED_ALLOC_AMT
9128: ,p_ra_ar_gt.TL_UNED_ALLOC_ACCTD_AMT
9129: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_AMT
9130: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_ACCTD_AMT
9131: --
9132: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_AMT
9125: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_ACCTD_AMT
9126: --
9127: ,p_ra_ar_gt.TL_UNED_ALLOC_AMT
9128: ,p_ra_ar_gt.TL_UNED_ALLOC_ACCTD_AMT
9129: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_AMT
9130: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_ACCTD_AMT
9131: --
9132: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_AMT
9133: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_ACCTD_AMT
9126: --
9127: ,p_ra_ar_gt.TL_UNED_ALLOC_AMT
9128: ,p_ra_ar_gt.TL_UNED_ALLOC_ACCTD_AMT
9129: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_AMT
9130: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_ACCTD_AMT
9131: --
9132: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_AMT
9133: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_ACCTD_AMT
9134: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_AMT
9128: ,p_ra_ar_gt.TL_UNED_ALLOC_ACCTD_AMT
9129: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_AMT
9130: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_ACCTD_AMT
9131: --
9132: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_AMT
9133: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_ACCTD_AMT
9134: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_AMT
9135: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_ACCTD_AMT
9136: --
9129: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_AMT
9130: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_ACCTD_AMT
9131: --
9132: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_AMT
9133: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_ACCTD_AMT
9134: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_AMT
9135: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_ACCTD_AMT
9136: --
9137: ,p_ra_ar_gt.DIST_ED_AMT
9130: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_ACCTD_AMT
9131: --
9132: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_AMT
9133: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_ACCTD_AMT
9134: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_AMT
9135: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_ACCTD_AMT
9136: --
9137: ,p_ra_ar_gt.DIST_ED_AMT
9138: ,p_ra_ar_gt.DIST_ED_ACCTD_AMT
9131: --
9132: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_AMT
9133: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_ACCTD_AMT
9134: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_AMT
9135: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_ACCTD_AMT
9136: --
9137: ,p_ra_ar_gt.DIST_ED_AMT
9138: ,p_ra_ar_gt.DIST_ED_ACCTD_AMT
9139: ,p_ra_ar_gt.DIST_UNED_AMT
9133: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_ACCTD_AMT
9134: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_AMT
9135: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_ACCTD_AMT
9136: --
9137: ,p_ra_ar_gt.DIST_ED_AMT
9138: ,p_ra_ar_gt.DIST_ED_ACCTD_AMT
9139: ,p_ra_ar_gt.DIST_UNED_AMT
9140: ,p_ra_ar_gt.DIST_UNED_ACCTD_AMT
9141: ,p_ra_ar_gt.gp_level
9134: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_AMT
9135: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_ACCTD_AMT
9136: --
9137: ,p_ra_ar_gt.DIST_ED_AMT
9138: ,p_ra_ar_gt.DIST_ED_ACCTD_AMT
9139: ,p_ra_ar_gt.DIST_UNED_AMT
9140: ,p_ra_ar_gt.DIST_UNED_ACCTD_AMT
9141: ,p_ra_ar_gt.gp_level
9142: ,p_ra_ar_gt.group_id
9135: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_ACCTD_AMT
9136: --
9137: ,p_ra_ar_gt.DIST_ED_AMT
9138: ,p_ra_ar_gt.DIST_ED_ACCTD_AMT
9139: ,p_ra_ar_gt.DIST_UNED_AMT
9140: ,p_ra_ar_gt.DIST_UNED_ACCTD_AMT
9141: ,p_ra_ar_gt.gp_level
9142: ,p_ra_ar_gt.group_id
9143:
9136: --
9137: ,p_ra_ar_gt.DIST_ED_AMT
9138: ,p_ra_ar_gt.DIST_ED_ACCTD_AMT
9139: ,p_ra_ar_gt.DIST_UNED_AMT
9140: ,p_ra_ar_gt.DIST_UNED_ACCTD_AMT
9141: ,p_ra_ar_gt.gp_level
9142: ,p_ra_ar_gt.group_id
9143:
9144: ,p_ra_ar_gt.source_data_key1
9137: ,p_ra_ar_gt.DIST_ED_AMT
9138: ,p_ra_ar_gt.DIST_ED_ACCTD_AMT
9139: ,p_ra_ar_gt.DIST_UNED_AMT
9140: ,p_ra_ar_gt.DIST_UNED_ACCTD_AMT
9141: ,p_ra_ar_gt.gp_level
9142: ,p_ra_ar_gt.group_id
9143:
9144: ,p_ra_ar_gt.source_data_key1
9145: ,p_ra_ar_gt.source_data_key2
9138: ,p_ra_ar_gt.DIST_ED_ACCTD_AMT
9139: ,p_ra_ar_gt.DIST_UNED_AMT
9140: ,p_ra_ar_gt.DIST_UNED_ACCTD_AMT
9141: ,p_ra_ar_gt.gp_level
9142: ,p_ra_ar_gt.group_id
9143:
9144: ,p_ra_ar_gt.source_data_key1
9145: ,p_ra_ar_gt.source_data_key2
9146: ,p_ra_ar_gt.source_data_key3
9140: ,p_ra_ar_gt.DIST_UNED_ACCTD_AMT
9141: ,p_ra_ar_gt.gp_level
9142: ,p_ra_ar_gt.group_id
9143:
9144: ,p_ra_ar_gt.source_data_key1
9145: ,p_ra_ar_gt.source_data_key2
9146: ,p_ra_ar_gt.source_data_key3
9147: ,p_ra_ar_gt.source_data_key4
9148: ,p_ra_ar_gt.source_data_key5
9141: ,p_ra_ar_gt.gp_level
9142: ,p_ra_ar_gt.group_id
9143:
9144: ,p_ra_ar_gt.source_data_key1
9145: ,p_ra_ar_gt.source_data_key2
9146: ,p_ra_ar_gt.source_data_key3
9147: ,p_ra_ar_gt.source_data_key4
9148: ,p_ra_ar_gt.source_data_key5
9149:
9142: ,p_ra_ar_gt.group_id
9143:
9144: ,p_ra_ar_gt.source_data_key1
9145: ,p_ra_ar_gt.source_data_key2
9146: ,p_ra_ar_gt.source_data_key3
9147: ,p_ra_ar_gt.source_data_key4
9148: ,p_ra_ar_gt.source_data_key5
9149:
9150: ,p_ra_ar_gt.SET_OF_BOOKS_ID
9143:
9144: ,p_ra_ar_gt.source_data_key1
9145: ,p_ra_ar_gt.source_data_key2
9146: ,p_ra_ar_gt.source_data_key3
9147: ,p_ra_ar_gt.source_data_key4
9148: ,p_ra_ar_gt.source_data_key5
9149:
9150: ,p_ra_ar_gt.SET_OF_BOOKS_ID
9151: ,p_ra_ar_gt.SOB_TYPE
9144: ,p_ra_ar_gt.source_data_key1
9145: ,p_ra_ar_gt.source_data_key2
9146: ,p_ra_ar_gt.source_data_key3
9147: ,p_ra_ar_gt.source_data_key4
9148: ,p_ra_ar_gt.source_data_key5
9149:
9150: ,p_ra_ar_gt.SET_OF_BOOKS_ID
9151: ,p_ra_ar_gt.SOB_TYPE
9152: ,p_ra_ar_gt.activity_bucket
9146: ,p_ra_ar_gt.source_data_key3
9147: ,p_ra_ar_gt.source_data_key4
9148: ,p_ra_ar_gt.source_data_key5
9149:
9150: ,p_ra_ar_gt.SET_OF_BOOKS_ID
9151: ,p_ra_ar_gt.SOB_TYPE
9152: ,p_ra_ar_gt.activity_bucket
9153: ) RETURNING ROWID INTO l_base_rowid;
9154:
9147: ,p_ra_ar_gt.source_data_key4
9148: ,p_ra_ar_gt.source_data_key5
9149:
9150: ,p_ra_ar_gt.SET_OF_BOOKS_ID
9151: ,p_ra_ar_gt.SOB_TYPE
9152: ,p_ra_ar_gt.activity_bucket
9153: ) RETURNING ROWID INTO l_base_rowid;
9154:
9155: l_rows := sql%rowcount;
9148: ,p_ra_ar_gt.source_data_key5
9149:
9150: ,p_ra_ar_gt.SET_OF_BOOKS_ID
9151: ,p_ra_ar_gt.SOB_TYPE
9152: ,p_ra_ar_gt.activity_bucket
9153: ) RETURNING ROWID INTO l_base_rowid;
9154:
9155: l_rows := sql%rowcount;
9156: IF PG_DEBUG = 'Y' THEN
9175: ,source_table
9176: )
9177: VALUES
9178: (
9179: p_ra_ar_gt.gt_id
9180: ,p_ra_ar_gt.gp_level
9181: ,p_ra_ar_gt.ref_customer_trx_id
9182: ,p_ra_ar_gt.ref_customer_trx_line_id
9183: ,p_ar_base_dist_amts_gt.base_dist_amt
9176: )
9177: VALUES
9178: (
9179: p_ra_ar_gt.gt_id
9180: ,p_ra_ar_gt.gp_level
9181: ,p_ra_ar_gt.ref_customer_trx_id
9182: ,p_ra_ar_gt.ref_customer_trx_line_id
9183: ,p_ar_base_dist_amts_gt.base_dist_amt
9184: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt
9177: VALUES
9178: (
9179: p_ra_ar_gt.gt_id
9180: ,p_ra_ar_gt.gp_level
9181: ,p_ra_ar_gt.ref_customer_trx_id
9182: ,p_ra_ar_gt.ref_customer_trx_line_id
9183: ,p_ar_base_dist_amts_gt.base_dist_amt
9184: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt
9185: ,p_ar_base_dist_amts_gt.base_ed_dist_amt
9178: (
9179: p_ra_ar_gt.gt_id
9180: ,p_ra_ar_gt.gp_level
9181: ,p_ra_ar_gt.ref_customer_trx_id
9182: ,p_ra_ar_gt.ref_customer_trx_line_id
9183: ,p_ar_base_dist_amts_gt.base_dist_amt
9184: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt
9185: ,p_ar_base_dist_amts_gt.base_ed_dist_amt
9186: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt
9185: ,p_ar_base_dist_amts_gt.base_ed_dist_amt
9186: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt
9187: ,p_ar_base_dist_amts_gt.base_uned_dist_amt
9188: ,p_ar_base_dist_amts_gt.base_uned_dist_acctd_amt
9189: ,p_ra_ar_gt.SET_OF_BOOKS_ID
9190: ,p_ra_ar_gt.SOB_TYPE
9191: ,p_ra_ar_gt.SOURCE_TABLE
9192: );
9193:
9186: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt
9187: ,p_ar_base_dist_amts_gt.base_uned_dist_amt
9188: ,p_ar_base_dist_amts_gt.base_uned_dist_acctd_amt
9189: ,p_ra_ar_gt.SET_OF_BOOKS_ID
9190: ,p_ra_ar_gt.SOB_TYPE
9191: ,p_ra_ar_gt.SOURCE_TABLE
9192: );
9193:
9194: INSERT INTO RA_AR_AMOUNTS_GT
9187: ,p_ar_base_dist_amts_gt.base_uned_dist_amt
9188: ,p_ar_base_dist_amts_gt.base_uned_dist_acctd_amt
9189: ,p_ra_ar_gt.SET_OF_BOOKS_ID
9190: ,p_ra_ar_gt.SOB_TYPE
9191: ,p_ra_ar_gt.SOURCE_TABLE
9192: );
9193:
9194: INSERT INTO RA_AR_AMOUNTS_GT
9195: (
9290: ,BASE_UNED_TAX_PRO_ACCTD_AMT
9291: )
9292: VALUES
9293: (
9294: p_ra_ar_gt.gt_id
9295: ,p_ra_ar_gt.gp_level
9296: ,l_base_rowid
9297: ,p_ra_ar_gt.ref_customer_trx_id
9298: ,p_ra_ar_gt.ref_customer_trx_line_id
9291: )
9292: VALUES
9293: (
9294: p_ra_ar_gt.gt_id
9295: ,p_ra_ar_gt.gp_level
9296: ,l_base_rowid
9297: ,p_ra_ar_gt.ref_customer_trx_id
9298: ,p_ra_ar_gt.ref_customer_trx_line_id
9299:
9293: (
9294: p_ra_ar_gt.gt_id
9295: ,p_ra_ar_gt.gp_level
9296: ,l_base_rowid
9297: ,p_ra_ar_gt.ref_customer_trx_id
9298: ,p_ra_ar_gt.ref_customer_trx_line_id
9299:
9300: ,p_ra_ar_amounts_gt.base_pro_amt
9301: ,p_ra_ar_amounts_gt.base_pro_acctd_amt
9294: p_ra_ar_gt.gt_id
9295: ,p_ra_ar_gt.gp_level
9296: ,l_base_rowid
9297: ,p_ra_ar_gt.ref_customer_trx_id
9298: ,p_ra_ar_gt.ref_customer_trx_line_id
9299:
9300: ,p_ra_ar_amounts_gt.base_pro_amt
9301: ,p_ra_ar_amounts_gt.base_pro_acctd_amt
9302: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_AMT
9390: l_rows := sql%rowcount;
9391: IF PG_DEBUG = 'Y' THEN
9392: localdebug(' rows inserted into AR_BASE_DIST_AMTS_GT = ' || l_rows);
9393: END IF;
9394: END insert_ra_ar_gt;
9395:
9396:
9397: PROCEDURE adjustment_detemination
9398: (p_customer_trx_id IN NUMBER,
9401: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
9402: p_adj_rec IN ar_adjustments%ROWTYPE)
9403: IS
9404: CURSOR get_sum_per_line_type IS
9405: SELECT /*+INDEX (RA_AR_GT ra_ar_n1)*/
9406: MAX(sum_line_rem_amt),
9407: MAX(sum_line_rem_acctd_amt),
9408: MAX(sum_line_orig_amt),
9409: MAX(sum_line_orig_acctd_amt),
9420: MAX(sum_line_tax_orig_amt),
9421: MAX(sum_line_tax_orig_acctd_amt),
9422: --
9423: line_type
9424: FROM ra_ar_gt
9425: WHERE gt_id = p_gt_id
9426: -- AND se_gt_id = g_se_gt_id
9427: AND ref_customer_trx_id = p_customer_trx_id
9428: AND gp_level = 'L' --'D'
9451: l_sum_line_tax_orig_amt DBMS_SQL.NUMBER_TABLE;
9452: l_sum_line_tax_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9453: --
9454: l_line_type DBMS_SQL.VARCHAR2_TABLE;
9455: l_ra_ar_gt ra_ar_gt%ROWTYPE;
9456: invoice_has_no_lines EXCEPTION;
9457: not_an_adjustment EXCEPTION;
9458: l_freight_boundary_done VARCHAR2(1) := 'N';
9459: l_line_boundary_done VARCHAR2(1) := 'N';
9468: p_gt_id IN VARCHAR2,
9469: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
9470: P_exchange_rate IN ra_customer_trx.exchange_rate%type)
9471: IS
9472: l_ra_ar_gt ra_ar_gt%ROWTYPE;
9473: l_ar_base_dist_amts_gt ar_base_dist_amts_gt%ROWTYPE;
9474: l_ra_ar_amounts_gt ra_ar_amounts_gt%ROWTYPE;
9475: BEGIN
9476: --Rev line boundary
9480: THEN
9481: IF PG_DEBUG = 'Y' THEN
9482: localdebug(' -6 Adjustment Boundary LINE condition met');
9483: END IF;
9484: l_ra_ar_gt.GT_ID := p_gt_id;
9485: l_ra_ar_gt.AMT := p_adj_rec.line_adjusted;
9486: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9487: p_ae_sys_rec.base_currency);
9488: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9481: IF PG_DEBUG = 'Y' THEN
9482: localdebug(' -6 Adjustment Boundary LINE condition met');
9483: END IF;
9484: l_ra_ar_gt.GT_ID := p_gt_id;
9485: l_ra_ar_gt.AMT := p_adj_rec.line_adjusted;
9486: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9487: p_ae_sys_rec.base_currency);
9488: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9489: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9482: localdebug(' -6 Adjustment Boundary LINE condition met');
9483: END IF;
9484: l_ra_ar_gt.GT_ID := p_gt_id;
9485: l_ra_ar_gt.AMT := p_adj_rec.line_adjusted;
9486: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9487: p_ae_sys_rec.base_currency);
9488: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9489: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9490: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -6;
9484: l_ra_ar_gt.GT_ID := p_gt_id;
9485: l_ra_ar_gt.AMT := p_adj_rec.line_adjusted;
9486: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9487: p_ae_sys_rec.base_currency);
9488: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9489: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9490: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -6;
9491: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -6;
9492: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9485: l_ra_ar_gt.AMT := p_adj_rec.line_adjusted;
9486: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9487: p_ae_sys_rec.base_currency);
9488: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9489: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9490: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -6;
9491: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -6;
9492: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9493: l_ra_ar_gt.DIST_AMT := p_adj_rec.line_adjusted;
9486: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9487: p_ae_sys_rec.base_currency);
9488: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9489: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9490: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -6;
9491: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -6;
9492: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9493: l_ra_ar_gt.DIST_AMT := p_adj_rec.line_adjusted;
9494: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9487: p_ae_sys_rec.base_currency);
9488: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9489: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9490: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -6;
9491: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -6;
9492: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9493: l_ra_ar_gt.DIST_AMT := p_adj_rec.line_adjusted;
9494: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9495: p_ae_sys_rec.base_currency);
9488: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9489: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9490: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -6;
9491: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -6;
9492: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9493: l_ra_ar_gt.DIST_AMT := p_adj_rec.line_adjusted;
9494: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9495: p_ae_sys_rec.base_currency);
9496: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9489: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9490: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -6;
9491: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -6;
9492: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9493: l_ra_ar_gt.DIST_AMT := p_adj_rec.line_adjusted;
9494: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9495: p_ae_sys_rec.base_currency);
9496: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9497: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9490: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -6;
9491: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -6;
9492: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9493: l_ra_ar_gt.DIST_AMT := p_adj_rec.line_adjusted;
9494: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9495: p_ae_sys_rec.base_currency);
9496: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9497: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9498: l_ra_ar_gt.tl_alloc_amt := p_adj_rec.line_adjusted;
9492: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9493: l_ra_ar_gt.DIST_AMT := p_adj_rec.line_adjusted;
9494: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9495: p_ae_sys_rec.base_currency);
9496: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9497: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9498: l_ra_ar_gt.tl_alloc_amt := p_adj_rec.line_adjusted;
9499: l_ra_ar_gt.tl_alloc_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9500: p_ae_sys_rec.base_currency);
9493: l_ra_ar_gt.DIST_AMT := p_adj_rec.line_adjusted;
9494: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9495: p_ae_sys_rec.base_currency);
9496: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9497: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9498: l_ra_ar_gt.tl_alloc_amt := p_adj_rec.line_adjusted;
9499: l_ra_ar_gt.tl_alloc_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9500: p_ae_sys_rec.base_currency);
9501: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9494: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9495: p_ae_sys_rec.base_currency);
9496: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9497: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9498: l_ra_ar_gt.tl_alloc_amt := p_adj_rec.line_adjusted;
9499: l_ra_ar_gt.tl_alloc_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9500: p_ae_sys_rec.base_currency);
9501: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9502: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9495: p_ae_sys_rec.base_currency);
9496: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9497: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9498: l_ra_ar_gt.tl_alloc_amt := p_adj_rec.line_adjusted;
9499: l_ra_ar_gt.tl_alloc_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9500: p_ae_sys_rec.base_currency);
9501: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9502: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9503: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9497: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9498: l_ra_ar_gt.tl_alloc_amt := p_adj_rec.line_adjusted;
9499: l_ra_ar_gt.tl_alloc_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9500: p_ae_sys_rec.base_currency);
9501: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9502: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9503: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9504: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9505: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9498: l_ra_ar_gt.tl_alloc_amt := p_adj_rec.line_adjusted;
9499: l_ra_ar_gt.tl_alloc_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9500: p_ae_sys_rec.base_currency);
9501: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9502: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9503: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9504: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9505: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9506: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9499: l_ra_ar_gt.tl_alloc_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9500: p_ae_sys_rec.base_currency);
9501: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9502: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9503: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9504: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9505: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9506: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9507: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.line_adjusted;
9500: p_ae_sys_rec.base_currency);
9501: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9502: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9503: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9504: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9505: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9506: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9507: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.line_adjusted;
9508: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9501: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9502: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9503: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9504: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9505: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9506: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9507: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.line_adjusted;
9508: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9509: p_ae_sys_rec.base_currency);
9502: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9503: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9504: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9505: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9506: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9507: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.line_adjusted;
9508: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9509: p_ae_sys_rec.base_currency);
9510: l_ra_ar_gt.source_type := 'LINE';
9506: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9507: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.line_adjusted;
9508: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9509: p_ae_sys_rec.base_currency);
9510: l_ra_ar_gt.source_type := 'LINE';
9511: l_ra_ar_gt.source_table := 'ADJ';
9512: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9513: l_ra_ar_gt.gp_level := 'D';
9514: l_ra_ar_gt.group_id := '00';
9507: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.line_adjusted;
9508: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9509: p_ae_sys_rec.base_currency);
9510: l_ra_ar_gt.source_type := 'LINE';
9511: l_ra_ar_gt.source_table := 'ADJ';
9512: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9513: l_ra_ar_gt.gp_level := 'D';
9514: l_ra_ar_gt.group_id := '00';
9515: --{HYUBPAGP
9508: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
9509: p_ae_sys_rec.base_currency);
9510: l_ra_ar_gt.source_type := 'LINE';
9511: l_ra_ar_gt.source_table := 'ADJ';
9512: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9513: l_ra_ar_gt.gp_level := 'D';
9514: l_ra_ar_gt.group_id := '00';
9515: --{HYUBPAGP
9516: l_ra_ar_gt.source_data_key1 := '00';
9509: p_ae_sys_rec.base_currency);
9510: l_ra_ar_gt.source_type := 'LINE';
9511: l_ra_ar_gt.source_table := 'ADJ';
9512: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9513: l_ra_ar_gt.gp_level := 'D';
9514: l_ra_ar_gt.group_id := '00';
9515: --{HYUBPAGP
9516: l_ra_ar_gt.source_data_key1 := '00';
9517: l_ra_ar_gt.source_data_key2 := '00';
9510: l_ra_ar_gt.source_type := 'LINE';
9511: l_ra_ar_gt.source_table := 'ADJ';
9512: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9513: l_ra_ar_gt.gp_level := 'D';
9514: l_ra_ar_gt.group_id := '00';
9515: --{HYUBPAGP
9516: l_ra_ar_gt.source_data_key1 := '00';
9517: l_ra_ar_gt.source_data_key2 := '00';
9518: l_ra_ar_gt.source_data_key3 := '00';
9512: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9513: l_ra_ar_gt.gp_level := 'D';
9514: l_ra_ar_gt.group_id := '00';
9515: --{HYUBPAGP
9516: l_ra_ar_gt.source_data_key1 := '00';
9517: l_ra_ar_gt.source_data_key2 := '00';
9518: l_ra_ar_gt.source_data_key3 := '00';
9519: l_ra_ar_gt.source_data_key4 := '00';
9520: l_ra_ar_gt.source_data_key5 := '00';
9513: l_ra_ar_gt.gp_level := 'D';
9514: l_ra_ar_gt.group_id := '00';
9515: --{HYUBPAGP
9516: l_ra_ar_gt.source_data_key1 := '00';
9517: l_ra_ar_gt.source_data_key2 := '00';
9518: l_ra_ar_gt.source_data_key3 := '00';
9519: l_ra_ar_gt.source_data_key4 := '00';
9520: l_ra_ar_gt.source_data_key5 := '00';
9521: --}
9514: l_ra_ar_gt.group_id := '00';
9515: --{HYUBPAGP
9516: l_ra_ar_gt.source_data_key1 := '00';
9517: l_ra_ar_gt.source_data_key2 := '00';
9518: l_ra_ar_gt.source_data_key3 := '00';
9519: l_ra_ar_gt.source_data_key4 := '00';
9520: l_ra_ar_gt.source_data_key5 := '00';
9521: --}
9522: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9515: --{HYUBPAGP
9516: l_ra_ar_gt.source_data_key1 := '00';
9517: l_ra_ar_gt.source_data_key2 := '00';
9518: l_ra_ar_gt.source_data_key3 := '00';
9519: l_ra_ar_gt.source_data_key4 := '00';
9520: l_ra_ar_gt.source_data_key5 := '00';
9521: --}
9522: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9523: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9516: l_ra_ar_gt.source_data_key1 := '00';
9517: l_ra_ar_gt.source_data_key2 := '00';
9518: l_ra_ar_gt.source_data_key3 := '00';
9519: l_ra_ar_gt.source_data_key4 := '00';
9520: l_ra_ar_gt.source_data_key5 := '00';
9521: --}
9522: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9523: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9524: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9518: l_ra_ar_gt.source_data_key3 := '00';
9519: l_ra_ar_gt.source_data_key4 := '00';
9520: l_ra_ar_gt.source_data_key5 := '00';
9521: --}
9522: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9523: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9524: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9525: l_ra_ar_gt.activity_bucket := 'ADJ';
9526: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9519: l_ra_ar_gt.source_data_key4 := '00';
9520: l_ra_ar_gt.source_data_key5 := '00';
9521: --}
9522: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9523: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9524: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9525: l_ra_ar_gt.activity_bucket := 'ADJ';
9526: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9527: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9520: l_ra_ar_gt.source_data_key5 := '00';
9521: --}
9522: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9523: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9524: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9525: l_ra_ar_gt.activity_bucket := 'ADJ';
9526: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9527: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9528: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9521: --}
9522: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9523: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9524: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9525: l_ra_ar_gt.activity_bucket := 'ADJ';
9526: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9527: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9528: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9529: );
9522: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9523: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9524: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9525: l_ra_ar_gt.activity_bucket := 'ADJ';
9526: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9527: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9528: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9529: );
9530: END IF;
9536: THEN
9537: IF PG_DEBUG = 'Y' THEN
9538: localdebug(' -7 Adjustment Boundary CHARGES condition met');
9539: END IF;
9540: l_ra_ar_gt.GT_ID := p_gt_id;
9541: l_ra_ar_gt.AMT := p_adj_rec.receivables_charges_adjusted;
9542: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9543: p_ae_sys_rec.base_currency);
9544: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9537: IF PG_DEBUG = 'Y' THEN
9538: localdebug(' -7 Adjustment Boundary CHARGES condition met');
9539: END IF;
9540: l_ra_ar_gt.GT_ID := p_gt_id;
9541: l_ra_ar_gt.AMT := p_adj_rec.receivables_charges_adjusted;
9542: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9543: p_ae_sys_rec.base_currency);
9544: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9545: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9538: localdebug(' -7 Adjustment Boundary CHARGES condition met');
9539: END IF;
9540: l_ra_ar_gt.GT_ID := p_gt_id;
9541: l_ra_ar_gt.AMT := p_adj_rec.receivables_charges_adjusted;
9542: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9543: p_ae_sys_rec.base_currency);
9544: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9545: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9546: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -7;
9540: l_ra_ar_gt.GT_ID := p_gt_id;
9541: l_ra_ar_gt.AMT := p_adj_rec.receivables_charges_adjusted;
9542: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9543: p_ae_sys_rec.base_currency);
9544: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9545: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9546: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -7;
9547: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -7;
9548: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9541: l_ra_ar_gt.AMT := p_adj_rec.receivables_charges_adjusted;
9542: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9543: p_ae_sys_rec.base_currency);
9544: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9545: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9546: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -7;
9547: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -7;
9548: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9549: l_ra_ar_gt.DIST_AMT := p_adj_rec.receivables_charges_adjusted;
9542: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9543: p_ae_sys_rec.base_currency);
9544: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9545: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9546: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -7;
9547: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -7;
9548: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9549: l_ra_ar_gt.DIST_AMT := p_adj_rec.receivables_charges_adjusted;
9550: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9543: p_ae_sys_rec.base_currency);
9544: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9545: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9546: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -7;
9547: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -7;
9548: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9549: l_ra_ar_gt.DIST_AMT := p_adj_rec.receivables_charges_adjusted;
9550: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9551: p_ae_sys_rec.base_currency);
9544: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9545: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9546: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -7;
9547: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -7;
9548: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9549: l_ra_ar_gt.DIST_AMT := p_adj_rec.receivables_charges_adjusted;
9550: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9551: p_ae_sys_rec.base_currency);
9552: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9545: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9546: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -7;
9547: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -7;
9548: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9549: l_ra_ar_gt.DIST_AMT := p_adj_rec.receivables_charges_adjusted;
9550: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9551: p_ae_sys_rec.base_currency);
9552: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9553: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9546: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -7;
9547: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -7;
9548: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9549: l_ra_ar_gt.DIST_AMT := p_adj_rec.receivables_charges_adjusted;
9550: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9551: p_ae_sys_rec.base_currency);
9552: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9553: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9554: l_ra_ar_gt.tl_alloc_amt := 0;
9548: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9549: l_ra_ar_gt.DIST_AMT := p_adj_rec.receivables_charges_adjusted;
9550: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9551: p_ae_sys_rec.base_currency);
9552: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9553: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9554: l_ra_ar_gt.tl_alloc_amt := 0;
9555: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9556: l_ra_ar_gt.tl_chrg_alloc_amt := p_adj_rec.receivables_charges_adjusted;
9549: l_ra_ar_gt.DIST_AMT := p_adj_rec.receivables_charges_adjusted;
9550: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9551: p_ae_sys_rec.base_currency);
9552: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9553: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9554: l_ra_ar_gt.tl_alloc_amt := 0;
9555: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9556: l_ra_ar_gt.tl_chrg_alloc_amt := p_adj_rec.receivables_charges_adjusted;
9557: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9550: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9551: p_ae_sys_rec.base_currency);
9552: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9553: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9554: l_ra_ar_gt.tl_alloc_amt := 0;
9555: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9556: l_ra_ar_gt.tl_chrg_alloc_amt := p_adj_rec.receivables_charges_adjusted;
9557: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9558: p_ae_sys_rec.base_currency);
9551: p_ae_sys_rec.base_currency);
9552: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9553: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9554: l_ra_ar_gt.tl_alloc_amt := 0;
9555: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9556: l_ra_ar_gt.tl_chrg_alloc_amt := p_adj_rec.receivables_charges_adjusted;
9557: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9558: p_ae_sys_rec.base_currency);
9559: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9552: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9553: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9554: l_ra_ar_gt.tl_alloc_amt := 0;
9555: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9556: l_ra_ar_gt.tl_chrg_alloc_amt := p_adj_rec.receivables_charges_adjusted;
9557: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9558: p_ae_sys_rec.base_currency);
9559: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9560: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9553: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9554: l_ra_ar_gt.tl_alloc_amt := 0;
9555: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9556: l_ra_ar_gt.tl_chrg_alloc_amt := p_adj_rec.receivables_charges_adjusted;
9557: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9558: p_ae_sys_rec.base_currency);
9559: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9560: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9561: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9555: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9556: l_ra_ar_gt.tl_chrg_alloc_amt := p_adj_rec.receivables_charges_adjusted;
9557: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9558: p_ae_sys_rec.base_currency);
9559: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9560: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9561: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9562: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9563: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.receivables_charges_adjusted;
9556: l_ra_ar_gt.tl_chrg_alloc_amt := p_adj_rec.receivables_charges_adjusted;
9557: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9558: p_ae_sys_rec.base_currency);
9559: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9560: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9561: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9562: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9563: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.receivables_charges_adjusted;
9564: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9557: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9558: p_ae_sys_rec.base_currency);
9559: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9560: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9561: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9562: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9563: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.receivables_charges_adjusted;
9564: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9565: p_ae_sys_rec.base_currency);
9558: p_ae_sys_rec.base_currency);
9559: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9560: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9561: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9562: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9563: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.receivables_charges_adjusted;
9564: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9565: p_ae_sys_rec.base_currency);
9566: l_ra_ar_gt.source_type := 'CHARGES';
9562: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9563: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.receivables_charges_adjusted;
9564: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9565: p_ae_sys_rec.base_currency);
9566: l_ra_ar_gt.source_type := 'CHARGES';
9567: l_ra_ar_gt.source_table := 'ADJ';
9568: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9569: l_ra_ar_gt.gp_level := 'D';
9570: l_ra_ar_gt.group_id := '00';
9563: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.receivables_charges_adjusted;
9564: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9565: p_ae_sys_rec.base_currency);
9566: l_ra_ar_gt.source_type := 'CHARGES';
9567: l_ra_ar_gt.source_table := 'ADJ';
9568: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9569: l_ra_ar_gt.gp_level := 'D';
9570: l_ra_ar_gt.group_id := '00';
9571: --{HYUBPAGP
9564: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
9565: p_ae_sys_rec.base_currency);
9566: l_ra_ar_gt.source_type := 'CHARGES';
9567: l_ra_ar_gt.source_table := 'ADJ';
9568: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9569: l_ra_ar_gt.gp_level := 'D';
9570: l_ra_ar_gt.group_id := '00';
9571: --{HYUBPAGP
9572: l_ra_ar_gt.source_data_key1 := '00';
9565: p_ae_sys_rec.base_currency);
9566: l_ra_ar_gt.source_type := 'CHARGES';
9567: l_ra_ar_gt.source_table := 'ADJ';
9568: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9569: l_ra_ar_gt.gp_level := 'D';
9570: l_ra_ar_gt.group_id := '00';
9571: --{HYUBPAGP
9572: l_ra_ar_gt.source_data_key1 := '00';
9573: l_ra_ar_gt.source_data_key2 := '00';
9566: l_ra_ar_gt.source_type := 'CHARGES';
9567: l_ra_ar_gt.source_table := 'ADJ';
9568: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9569: l_ra_ar_gt.gp_level := 'D';
9570: l_ra_ar_gt.group_id := '00';
9571: --{HYUBPAGP
9572: l_ra_ar_gt.source_data_key1 := '00';
9573: l_ra_ar_gt.source_data_key2 := '00';
9574: l_ra_ar_gt.source_data_key3 := '00';
9568: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9569: l_ra_ar_gt.gp_level := 'D';
9570: l_ra_ar_gt.group_id := '00';
9571: --{HYUBPAGP
9572: l_ra_ar_gt.source_data_key1 := '00';
9573: l_ra_ar_gt.source_data_key2 := '00';
9574: l_ra_ar_gt.source_data_key3 := '00';
9575: l_ra_ar_gt.source_data_key4 := '00';
9576: l_ra_ar_gt.source_data_key5 := '00';
9569: l_ra_ar_gt.gp_level := 'D';
9570: l_ra_ar_gt.group_id := '00';
9571: --{HYUBPAGP
9572: l_ra_ar_gt.source_data_key1 := '00';
9573: l_ra_ar_gt.source_data_key2 := '00';
9574: l_ra_ar_gt.source_data_key3 := '00';
9575: l_ra_ar_gt.source_data_key4 := '00';
9576: l_ra_ar_gt.source_data_key5 := '00';
9577: --}
9570: l_ra_ar_gt.group_id := '00';
9571: --{HYUBPAGP
9572: l_ra_ar_gt.source_data_key1 := '00';
9573: l_ra_ar_gt.source_data_key2 := '00';
9574: l_ra_ar_gt.source_data_key3 := '00';
9575: l_ra_ar_gt.source_data_key4 := '00';
9576: l_ra_ar_gt.source_data_key5 := '00';
9577: --}
9578: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9571: --{HYUBPAGP
9572: l_ra_ar_gt.source_data_key1 := '00';
9573: l_ra_ar_gt.source_data_key2 := '00';
9574: l_ra_ar_gt.source_data_key3 := '00';
9575: l_ra_ar_gt.source_data_key4 := '00';
9576: l_ra_ar_gt.source_data_key5 := '00';
9577: --}
9578: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9579: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9572: l_ra_ar_gt.source_data_key1 := '00';
9573: l_ra_ar_gt.source_data_key2 := '00';
9574: l_ra_ar_gt.source_data_key3 := '00';
9575: l_ra_ar_gt.source_data_key4 := '00';
9576: l_ra_ar_gt.source_data_key5 := '00';
9577: --}
9578: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9579: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9580: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9574: l_ra_ar_gt.source_data_key3 := '00';
9575: l_ra_ar_gt.source_data_key4 := '00';
9576: l_ra_ar_gt.source_data_key5 := '00';
9577: --}
9578: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9579: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9580: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9581: l_ra_ar_gt.activity_bucket := 'ADJ';
9582: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9575: l_ra_ar_gt.source_data_key4 := '00';
9576: l_ra_ar_gt.source_data_key5 := '00';
9577: --}
9578: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9579: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9580: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9581: l_ra_ar_gt.activity_bucket := 'ADJ';
9582: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9583: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9576: l_ra_ar_gt.source_data_key5 := '00';
9577: --}
9578: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9579: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9580: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9581: l_ra_ar_gt.activity_bucket := 'ADJ';
9582: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9583: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9584: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9577: --}
9578: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9579: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9580: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9581: l_ra_ar_gt.activity_bucket := 'ADJ';
9582: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9583: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9584: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9585: );
9578: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9579: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9580: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9581: l_ra_ar_gt.activity_bucket := 'ADJ';
9582: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9583: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9584: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9585: );
9586: END IF;
9592: THEN
9593: IF PG_DEBUG = 'Y' THEN
9594: localdebug(' -9 Adjustment Boundary FREIGHT condition met');
9595: END IF;
9596: l_ra_ar_gt.GT_ID := p_gt_id;
9597: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
9598: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9599: p_ae_sys_rec.base_currency);
9600: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9593: IF PG_DEBUG = 'Y' THEN
9594: localdebug(' -9 Adjustment Boundary FREIGHT condition met');
9595: END IF;
9596: l_ra_ar_gt.GT_ID := p_gt_id;
9597: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
9598: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9599: p_ae_sys_rec.base_currency);
9600: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9601: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9594: localdebug(' -9 Adjustment Boundary FREIGHT condition met');
9595: END IF;
9596: l_ra_ar_gt.GT_ID := p_gt_id;
9597: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
9598: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9599: p_ae_sys_rec.base_currency);
9600: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9601: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9602: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
9596: l_ra_ar_gt.GT_ID := p_gt_id;
9597: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
9598: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9599: p_ae_sys_rec.base_currency);
9600: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9601: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9602: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
9603: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
9604: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9597: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
9598: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9599: p_ae_sys_rec.base_currency);
9600: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9601: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9602: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
9603: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
9604: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9605: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
9598: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9599: p_ae_sys_rec.base_currency);
9600: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9601: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9602: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
9603: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
9604: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9605: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
9606: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9599: p_ae_sys_rec.base_currency);
9600: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9601: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9602: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
9603: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
9604: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9605: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
9606: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9607: p_ae_sys_rec.base_currency);
9600: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
9601: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9602: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
9603: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
9604: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9605: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
9606: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9607: p_ae_sys_rec.base_currency);
9608: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9601: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9602: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
9603: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
9604: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9605: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
9606: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9607: p_ae_sys_rec.base_currency);
9608: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9609: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9602: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
9603: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
9604: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9605: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
9606: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9607: p_ae_sys_rec.base_currency);
9608: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9609: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9610: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9604: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9605: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
9606: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9607: p_ae_sys_rec.base_currency);
9608: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9609: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9610: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9611: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9612: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9605: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
9606: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9607: p_ae_sys_rec.base_currency);
9608: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9609: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9610: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9611: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9612: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9613: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9606: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9607: p_ae_sys_rec.base_currency);
9608: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9609: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9610: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9611: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9612: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9613: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9614: l_ra_ar_gt.tl_alloc_amt := 0;
9607: p_ae_sys_rec.base_currency);
9608: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9609: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9610: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9611: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9612: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9613: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9614: l_ra_ar_gt.tl_alloc_amt := 0;
9615: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9608: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9609: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9610: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9611: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9612: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9613: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9614: l_ra_ar_gt.tl_alloc_amt := 0;
9615: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9616: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
9609: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9610: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9611: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9612: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9613: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9614: l_ra_ar_gt.tl_alloc_amt := 0;
9615: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9616: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
9617: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9610: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9611: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9612: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9613: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9614: l_ra_ar_gt.tl_alloc_amt := 0;
9615: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9616: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
9617: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9618: p_ae_sys_rec.base_currency);
9611: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9612: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9613: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9614: l_ra_ar_gt.tl_alloc_amt := 0;
9615: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9616: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
9617: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9618: p_ae_sys_rec.base_currency);
9619: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.freight_adjusted;
9612: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9613: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9614: l_ra_ar_gt.tl_alloc_amt := 0;
9615: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9616: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
9617: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9618: p_ae_sys_rec.base_currency);
9619: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.freight_adjusted;
9620: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9613: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9614: l_ra_ar_gt.tl_alloc_amt := 0;
9615: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9616: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
9617: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9618: p_ae_sys_rec.base_currency);
9619: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.freight_adjusted;
9620: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9621: p_ae_sys_rec.base_currency);
9618: p_ae_sys_rec.base_currency);
9619: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.freight_adjusted;
9620: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9621: p_ae_sys_rec.base_currency);
9622: l_ra_ar_gt.source_type := 'FREIGHT';
9623: l_ra_ar_gt.source_table := 'ADJ';
9624: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9625: l_ra_ar_gt.gp_level := 'D';
9626: l_ra_ar_gt.group_id := '00';
9619: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.freight_adjusted;
9620: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9621: p_ae_sys_rec.base_currency);
9622: l_ra_ar_gt.source_type := 'FREIGHT';
9623: l_ra_ar_gt.source_table := 'ADJ';
9624: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9625: l_ra_ar_gt.gp_level := 'D';
9626: l_ra_ar_gt.group_id := '00';
9627: --{HYUBPAGP
9620: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
9621: p_ae_sys_rec.base_currency);
9622: l_ra_ar_gt.source_type := 'FREIGHT';
9623: l_ra_ar_gt.source_table := 'ADJ';
9624: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9625: l_ra_ar_gt.gp_level := 'D';
9626: l_ra_ar_gt.group_id := '00';
9627: --{HYUBPAGP
9628: l_ra_ar_gt.source_data_key1 := '00';
9621: p_ae_sys_rec.base_currency);
9622: l_ra_ar_gt.source_type := 'FREIGHT';
9623: l_ra_ar_gt.source_table := 'ADJ';
9624: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9625: l_ra_ar_gt.gp_level := 'D';
9626: l_ra_ar_gt.group_id := '00';
9627: --{HYUBPAGP
9628: l_ra_ar_gt.source_data_key1 := '00';
9629: l_ra_ar_gt.source_data_key2 := '00';
9622: l_ra_ar_gt.source_type := 'FREIGHT';
9623: l_ra_ar_gt.source_table := 'ADJ';
9624: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9625: l_ra_ar_gt.gp_level := 'D';
9626: l_ra_ar_gt.group_id := '00';
9627: --{HYUBPAGP
9628: l_ra_ar_gt.source_data_key1 := '00';
9629: l_ra_ar_gt.source_data_key2 := '00';
9630: l_ra_ar_gt.source_data_key3 := '00';
9624: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9625: l_ra_ar_gt.gp_level := 'D';
9626: l_ra_ar_gt.group_id := '00';
9627: --{HYUBPAGP
9628: l_ra_ar_gt.source_data_key1 := '00';
9629: l_ra_ar_gt.source_data_key2 := '00';
9630: l_ra_ar_gt.source_data_key3 := '00';
9631: l_ra_ar_gt.source_data_key4 := '00';
9632: l_ra_ar_gt.source_data_key5 := '00';
9625: l_ra_ar_gt.gp_level := 'D';
9626: l_ra_ar_gt.group_id := '00';
9627: --{HYUBPAGP
9628: l_ra_ar_gt.source_data_key1 := '00';
9629: l_ra_ar_gt.source_data_key2 := '00';
9630: l_ra_ar_gt.source_data_key3 := '00';
9631: l_ra_ar_gt.source_data_key4 := '00';
9632: l_ra_ar_gt.source_data_key5 := '00';
9633: --}
9626: l_ra_ar_gt.group_id := '00';
9627: --{HYUBPAGP
9628: l_ra_ar_gt.source_data_key1 := '00';
9629: l_ra_ar_gt.source_data_key2 := '00';
9630: l_ra_ar_gt.source_data_key3 := '00';
9631: l_ra_ar_gt.source_data_key4 := '00';
9632: l_ra_ar_gt.source_data_key5 := '00';
9633: --}
9634: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9627: --{HYUBPAGP
9628: l_ra_ar_gt.source_data_key1 := '00';
9629: l_ra_ar_gt.source_data_key2 := '00';
9630: l_ra_ar_gt.source_data_key3 := '00';
9631: l_ra_ar_gt.source_data_key4 := '00';
9632: l_ra_ar_gt.source_data_key5 := '00';
9633: --}
9634: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9635: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9628: l_ra_ar_gt.source_data_key1 := '00';
9629: l_ra_ar_gt.source_data_key2 := '00';
9630: l_ra_ar_gt.source_data_key3 := '00';
9631: l_ra_ar_gt.source_data_key4 := '00';
9632: l_ra_ar_gt.source_data_key5 := '00';
9633: --}
9634: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9635: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9636: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9630: l_ra_ar_gt.source_data_key3 := '00';
9631: l_ra_ar_gt.source_data_key4 := '00';
9632: l_ra_ar_gt.source_data_key5 := '00';
9633: --}
9634: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9635: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9636: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9637: l_ra_ar_gt.activity_bucket := 'ADJ';
9638: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9631: l_ra_ar_gt.source_data_key4 := '00';
9632: l_ra_ar_gt.source_data_key5 := '00';
9633: --}
9634: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9635: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9636: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9637: l_ra_ar_gt.activity_bucket := 'ADJ';
9638: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9639: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9632: l_ra_ar_gt.source_data_key5 := '00';
9633: --}
9634: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9635: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9636: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9637: l_ra_ar_gt.activity_bucket := 'ADJ';
9638: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9639: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9640: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9633: --}
9634: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9635: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9636: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9637: l_ra_ar_gt.activity_bucket := 'ADJ';
9638: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9639: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9640: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9641: );
9634: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9635: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9636: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9637: l_ra_ar_gt.activity_bucket := 'ADJ';
9638: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9639: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9640: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9641: );
9642: END IF;
9651: p_gt_id IN VARCHAR2,
9652: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
9653: P_exchange_rate IN ra_customer_trx.exchange_rate%type)
9654: IS
9655: l_ra_ar_gt ra_ar_gt%ROWTYPE;
9656: l_ar_base_dist_amts_gt ar_base_dist_amts_gt%ROWTYPE;
9657: l_ra_ar_amounts_gt ra_ar_amounts_gt%ROWTYPE;
9658: BEGIN
9659: IF NVL(p_adj_rec.tax_adjusted,0) <> 0 AND
9662: THEN
9663: IF PG_DEBUG = 'Y' THEN
9664: localdebug(' -8 Adjustment Boundary TAX condition met');
9665: END IF;
9666: l_ra_ar_gt.GT_ID := p_gt_id;
9667: l_ra_ar_gt.AMT := p_adj_rec.tax_adjusted;
9668: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9669: p_ae_sys_rec.base_currency);
9670: l_ra_ar_gt.ACCOUNT_CLASS := 'TAX';
9663: IF PG_DEBUG = 'Y' THEN
9664: localdebug(' -8 Adjustment Boundary TAX condition met');
9665: END IF;
9666: l_ra_ar_gt.GT_ID := p_gt_id;
9667: l_ra_ar_gt.AMT := p_adj_rec.tax_adjusted;
9668: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9669: p_ae_sys_rec.base_currency);
9670: l_ra_ar_gt.ACCOUNT_CLASS := 'TAX';
9671: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9664: localdebug(' -8 Adjustment Boundary TAX condition met');
9665: END IF;
9666: l_ra_ar_gt.GT_ID := p_gt_id;
9667: l_ra_ar_gt.AMT := p_adj_rec.tax_adjusted;
9668: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9669: p_ae_sys_rec.base_currency);
9670: l_ra_ar_gt.ACCOUNT_CLASS := 'TAX';
9671: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9672: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -8;
9666: l_ra_ar_gt.GT_ID := p_gt_id;
9667: l_ra_ar_gt.AMT := p_adj_rec.tax_adjusted;
9668: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9669: p_ae_sys_rec.base_currency);
9670: l_ra_ar_gt.ACCOUNT_CLASS := 'TAX';
9671: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9672: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -8;
9673: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -8;
9674: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9667: l_ra_ar_gt.AMT := p_adj_rec.tax_adjusted;
9668: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9669: p_ae_sys_rec.base_currency);
9670: l_ra_ar_gt.ACCOUNT_CLASS := 'TAX';
9671: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9672: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -8;
9673: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -8;
9674: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9675: l_ra_ar_gt.DIST_AMT := p_adj_rec.tax_adjusted;
9668: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9669: p_ae_sys_rec.base_currency);
9670: l_ra_ar_gt.ACCOUNT_CLASS := 'TAX';
9671: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9672: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -8;
9673: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -8;
9674: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9675: l_ra_ar_gt.DIST_AMT := p_adj_rec.tax_adjusted;
9676: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9669: p_ae_sys_rec.base_currency);
9670: l_ra_ar_gt.ACCOUNT_CLASS := 'TAX';
9671: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9672: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -8;
9673: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -8;
9674: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9675: l_ra_ar_gt.DIST_AMT := p_adj_rec.tax_adjusted;
9676: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9677: p_ae_sys_rec.base_currency);
9670: l_ra_ar_gt.ACCOUNT_CLASS := 'TAX';
9671: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9672: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -8;
9673: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -8;
9674: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9675: l_ra_ar_gt.DIST_AMT := p_adj_rec.tax_adjusted;
9676: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9677: p_ae_sys_rec.base_currency);
9678: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9671: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9672: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -8;
9673: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -8;
9674: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9675: l_ra_ar_gt.DIST_AMT := p_adj_rec.tax_adjusted;
9676: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9677: p_ae_sys_rec.base_currency);
9678: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9679: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9672: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -8;
9673: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -8;
9674: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9675: l_ra_ar_gt.DIST_AMT := p_adj_rec.tax_adjusted;
9676: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9677: p_ae_sys_rec.base_currency);
9678: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9679: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9680: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9674: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9675: l_ra_ar_gt.DIST_AMT := p_adj_rec.tax_adjusted;
9676: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9677: p_ae_sys_rec.base_currency);
9678: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9679: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9680: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9681: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9682: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9675: l_ra_ar_gt.DIST_AMT := p_adj_rec.tax_adjusted;
9676: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9677: p_ae_sys_rec.base_currency);
9678: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9679: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9680: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9681: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9682: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9683: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9676: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9677: p_ae_sys_rec.base_currency);
9678: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9679: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9680: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9681: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9682: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9683: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9684: l_ra_ar_gt.tl_alloc_amt := 0;
9677: p_ae_sys_rec.base_currency);
9678: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9679: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9680: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9681: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9682: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9683: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9684: l_ra_ar_gt.tl_alloc_amt := 0;
9685: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9678: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9679: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9680: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9681: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9682: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9683: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9684: l_ra_ar_gt.tl_alloc_amt := 0;
9685: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9686: l_ra_ar_gt.tl_tax_alloc_amt := p_adj_rec.tax_adjusted;
9679: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9680: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9681: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9682: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9683: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9684: l_ra_ar_gt.tl_alloc_amt := 0;
9685: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9686: l_ra_ar_gt.tl_tax_alloc_amt := p_adj_rec.tax_adjusted;
9687: l_ra_ar_gt.tl_tax_alloc_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9680: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9681: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9682: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9683: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9684: l_ra_ar_gt.tl_alloc_amt := 0;
9685: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9686: l_ra_ar_gt.tl_tax_alloc_amt := p_adj_rec.tax_adjusted;
9687: l_ra_ar_gt.tl_tax_alloc_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9688: p_ae_sys_rec.base_currency);
9681: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9682: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9683: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9684: l_ra_ar_gt.tl_alloc_amt := 0;
9685: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9686: l_ra_ar_gt.tl_tax_alloc_amt := p_adj_rec.tax_adjusted;
9687: l_ra_ar_gt.tl_tax_alloc_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9688: p_ae_sys_rec.base_currency);
9689: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.tax_adjusted;
9682: l_ra_ar_gt.tl_frt_alloc_amt := 0;
9683: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9684: l_ra_ar_gt.tl_alloc_amt := 0;
9685: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9686: l_ra_ar_gt.tl_tax_alloc_amt := p_adj_rec.tax_adjusted;
9687: l_ra_ar_gt.tl_tax_alloc_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9688: p_ae_sys_rec.base_currency);
9689: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.tax_adjusted;
9690: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9683: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
9684: l_ra_ar_gt.tl_alloc_amt := 0;
9685: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9686: l_ra_ar_gt.tl_tax_alloc_amt := p_adj_rec.tax_adjusted;
9687: l_ra_ar_gt.tl_tax_alloc_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9688: p_ae_sys_rec.base_currency);
9689: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.tax_adjusted;
9690: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9691: p_ae_sys_rec.base_currency);
9688: p_ae_sys_rec.base_currency);
9689: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.tax_adjusted;
9690: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9691: p_ae_sys_rec.base_currency);
9692: l_ra_ar_gt.source_type := 'TAX';
9693: l_ra_ar_gt.source_table := 'ADJ';
9694: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9695: l_ra_ar_gt.gp_level := 'D';
9696: l_ra_ar_gt.group_id := '00';
9689: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.tax_adjusted;
9690: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9691: p_ae_sys_rec.base_currency);
9692: l_ra_ar_gt.source_type := 'TAX';
9693: l_ra_ar_gt.source_table := 'ADJ';
9694: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9695: l_ra_ar_gt.gp_level := 'D';
9696: l_ra_ar_gt.group_id := '00';
9697: --{HYUBPAGP
9690: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
9691: p_ae_sys_rec.base_currency);
9692: l_ra_ar_gt.source_type := 'TAX';
9693: l_ra_ar_gt.source_table := 'ADJ';
9694: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9695: l_ra_ar_gt.gp_level := 'D';
9696: l_ra_ar_gt.group_id := '00';
9697: --{HYUBPAGP
9698: l_ra_ar_gt.source_data_key1 := '00';
9691: p_ae_sys_rec.base_currency);
9692: l_ra_ar_gt.source_type := 'TAX';
9693: l_ra_ar_gt.source_table := 'ADJ';
9694: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9695: l_ra_ar_gt.gp_level := 'D';
9696: l_ra_ar_gt.group_id := '00';
9697: --{HYUBPAGP
9698: l_ra_ar_gt.source_data_key1 := '00';
9699: l_ra_ar_gt.source_data_key2 := '00';
9692: l_ra_ar_gt.source_type := 'TAX';
9693: l_ra_ar_gt.source_table := 'ADJ';
9694: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9695: l_ra_ar_gt.gp_level := 'D';
9696: l_ra_ar_gt.group_id := '00';
9697: --{HYUBPAGP
9698: l_ra_ar_gt.source_data_key1 := '00';
9699: l_ra_ar_gt.source_data_key2 := '00';
9700: l_ra_ar_gt.source_data_key3 := '00';
9694: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9695: l_ra_ar_gt.gp_level := 'D';
9696: l_ra_ar_gt.group_id := '00';
9697: --{HYUBPAGP
9698: l_ra_ar_gt.source_data_key1 := '00';
9699: l_ra_ar_gt.source_data_key2 := '00';
9700: l_ra_ar_gt.source_data_key3 := '00';
9701: l_ra_ar_gt.source_data_key4 := '00';
9702: l_ra_ar_gt.source_data_key5 := '00';
9695: l_ra_ar_gt.gp_level := 'D';
9696: l_ra_ar_gt.group_id := '00';
9697: --{HYUBPAGP
9698: l_ra_ar_gt.source_data_key1 := '00';
9699: l_ra_ar_gt.source_data_key2 := '00';
9700: l_ra_ar_gt.source_data_key3 := '00';
9701: l_ra_ar_gt.source_data_key4 := '00';
9702: l_ra_ar_gt.source_data_key5 := '00';
9703: --}
9696: l_ra_ar_gt.group_id := '00';
9697: --{HYUBPAGP
9698: l_ra_ar_gt.source_data_key1 := '00';
9699: l_ra_ar_gt.source_data_key2 := '00';
9700: l_ra_ar_gt.source_data_key3 := '00';
9701: l_ra_ar_gt.source_data_key4 := '00';
9702: l_ra_ar_gt.source_data_key5 := '00';
9703: --}
9704: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9697: --{HYUBPAGP
9698: l_ra_ar_gt.source_data_key1 := '00';
9699: l_ra_ar_gt.source_data_key2 := '00';
9700: l_ra_ar_gt.source_data_key3 := '00';
9701: l_ra_ar_gt.source_data_key4 := '00';
9702: l_ra_ar_gt.source_data_key5 := '00';
9703: --}
9704: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9705: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9698: l_ra_ar_gt.source_data_key1 := '00';
9699: l_ra_ar_gt.source_data_key2 := '00';
9700: l_ra_ar_gt.source_data_key3 := '00';
9701: l_ra_ar_gt.source_data_key4 := '00';
9702: l_ra_ar_gt.source_data_key5 := '00';
9703: --}
9704: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9705: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9706: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9700: l_ra_ar_gt.source_data_key3 := '00';
9701: l_ra_ar_gt.source_data_key4 := '00';
9702: l_ra_ar_gt.source_data_key5 := '00';
9703: --}
9704: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9705: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9706: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9707: l_ra_ar_gt.activity_bucket := 'ADJ';
9708: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9701: l_ra_ar_gt.source_data_key4 := '00';
9702: l_ra_ar_gt.source_data_key5 := '00';
9703: --}
9704: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9705: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9706: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9707: l_ra_ar_gt.activity_bucket := 'ADJ';
9708: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9709: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9702: l_ra_ar_gt.source_data_key5 := '00';
9703: --}
9704: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9705: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9706: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9707: l_ra_ar_gt.activity_bucket := 'ADJ';
9708: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9709: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9710: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9703: --}
9704: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9705: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9706: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9707: l_ra_ar_gt.activity_bucket := 'ADJ';
9708: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9709: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9710: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9711: );
9704: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
9705: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
9706: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
9707: l_ra_ar_gt.activity_bucket := 'ADJ';
9708: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
9709: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
9710: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
9711: );
9712: END IF;
9724: p_customer_trx_id IN NUMBER,
9725: p_gt_id IN NUMBER,
9726: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
9727: IS
9728: l_ra_ar_gt ra_ar_gt%ROWTYPE;
9729: BEGIN
9730: IF NVL(p_adj_rec.freight_adjusted,0) <> 0 AND
9731: NVL(p_sum_line_frt_orig_amt,0) = 0 AND
9732: NVL(p_sum_line_frt_rem_amt,0) = 0
9731: NVL(p_sum_line_frt_orig_amt,0) = 0 AND
9732: NVL(p_sum_line_frt_rem_amt,0) = 0
9733: THEN
9734: localdebug(' -9 Adjustment Boundary FREIGHT condition met');
9735: l_ra_ar_gt.GT_ID := p_gt_id;
9736: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
9737: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted,
9738: p_ae_sys_rec.base_currency);
9739: l_ra_ar_gt.ACCOUNT_CLASS := 'FREIGHT';
9732: NVL(p_sum_line_frt_rem_amt,0) = 0
9733: THEN
9734: localdebug(' -9 Adjustment Boundary FREIGHT condition met');
9735: l_ra_ar_gt.GT_ID := p_gt_id;
9736: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
9737: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted,
9738: p_ae_sys_rec.base_currency);
9739: l_ra_ar_gt.ACCOUNT_CLASS := 'FREIGHT';
9740: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9733: THEN
9734: localdebug(' -9 Adjustment Boundary FREIGHT condition met');
9735: l_ra_ar_gt.GT_ID := p_gt_id;
9736: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
9737: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted,
9738: p_ae_sys_rec.base_currency);
9739: l_ra_ar_gt.ACCOUNT_CLASS := 'FREIGHT';
9740: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9741: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
9735: l_ra_ar_gt.GT_ID := p_gt_id;
9736: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
9737: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted,
9738: p_ae_sys_rec.base_currency);
9739: l_ra_ar_gt.ACCOUNT_CLASS := 'FREIGHT';
9740: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9741: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
9742: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
9743: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9736: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
9737: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted,
9738: p_ae_sys_rec.base_currency);
9739: l_ra_ar_gt.ACCOUNT_CLASS := 'FREIGHT';
9740: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9741: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
9742: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
9743: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9744: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
9737: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted,
9738: p_ae_sys_rec.base_currency);
9739: l_ra_ar_gt.ACCOUNT_CLASS := 'FREIGHT';
9740: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9741: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
9742: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
9743: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9744: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
9745: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted,
9738: p_ae_sys_rec.base_currency);
9739: l_ra_ar_gt.ACCOUNT_CLASS := 'FREIGHT';
9740: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9741: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
9742: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
9743: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9744: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
9745: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted,
9746: p_ae_sys_rec.base_currency);
9739: l_ra_ar_gt.ACCOUNT_CLASS := 'FREIGHT';
9740: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9741: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
9742: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
9743: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9744: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
9745: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted,
9746: p_ae_sys_rec.base_currency);
9747: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9740: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
9741: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
9742: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
9743: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9744: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
9745: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted,
9746: p_ae_sys_rec.base_currency);
9747: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9748: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9741: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
9742: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
9743: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9744: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
9745: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted,
9746: p_ae_sys_rec.base_currency);
9747: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9748: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9749: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9743: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
9744: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
9745: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted,
9746: p_ae_sys_rec.base_currency);
9747: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9748: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9749: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9750: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9751: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9744: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
9745: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted,
9746: p_ae_sys_rec.base_currency);
9747: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9748: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9749: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9750: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9751: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9752: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9745: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted,
9746: p_ae_sys_rec.base_currency);
9747: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9748: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9749: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9750: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9751: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9752: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9753: l_ra_ar_gt.tl_alloc_amt := 0;
9746: p_ae_sys_rec.base_currency);
9747: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9748: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9749: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9750: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9751: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9752: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9753: l_ra_ar_gt.tl_alloc_amt := 0;
9754: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9747: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
9748: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9749: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9750: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9751: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9752: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9753: l_ra_ar_gt.tl_alloc_amt := 0;
9754: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9755: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
9748: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
9749: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9750: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9751: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9752: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9753: l_ra_ar_gt.tl_alloc_amt := 0;
9754: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9755: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
9756: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted,
9749: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
9750: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9751: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9752: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9753: l_ra_ar_gt.tl_alloc_amt := 0;
9754: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9755: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
9756: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted,
9757: p_ae_sys_rec.base_currency);
9750: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
9751: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9752: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9753: l_ra_ar_gt.tl_alloc_amt := 0;
9754: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9755: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
9756: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted,
9757: p_ae_sys_rec.base_currency);
9758: l_ra_ar_gt.base_dist_amt := p_adj_rec.freight_adjusted;
9751: l_ra_ar_gt.tl_tax_alloc_amt := 0;
9752: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9753: l_ra_ar_gt.tl_alloc_amt := 0;
9754: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9755: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
9756: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted,
9757: p_ae_sys_rec.base_currency);
9758: l_ra_ar_gt.base_dist_amt := p_adj_rec.freight_adjusted;
9759: l_ra_ar_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted,
9752: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
9753: l_ra_ar_gt.tl_alloc_amt := 0;
9754: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9755: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
9756: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted,
9757: p_ae_sys_rec.base_currency);
9758: l_ra_ar_gt.base_dist_amt := p_adj_rec.freight_adjusted;
9759: l_ra_ar_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted,
9760: p_ae_sys_rec.base_currency);
9754: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
9755: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
9756: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted,
9757: p_ae_sys_rec.base_currency);
9758: l_ra_ar_gt.base_dist_amt := p_adj_rec.freight_adjusted;
9759: l_ra_ar_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted,
9760: p_ae_sys_rec.base_currency);
9761: l_ra_ar_gt.source_type := 'FREIGHT';
9762: l_ra_ar_gt.source_table := 'ADJ';
9755: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
9756: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted,
9757: p_ae_sys_rec.base_currency);
9758: l_ra_ar_gt.base_dist_amt := p_adj_rec.freight_adjusted;
9759: l_ra_ar_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted,
9760: p_ae_sys_rec.base_currency);
9761: l_ra_ar_gt.source_type := 'FREIGHT';
9762: l_ra_ar_gt.source_table := 'ADJ';
9763: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9757: p_ae_sys_rec.base_currency);
9758: l_ra_ar_gt.base_dist_amt := p_adj_rec.freight_adjusted;
9759: l_ra_ar_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted,
9760: p_ae_sys_rec.base_currency);
9761: l_ra_ar_gt.source_type := 'FREIGHT';
9762: l_ra_ar_gt.source_table := 'ADJ';
9763: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9764: l_ra_ar_gt.gp_level := 'D';
9765: l_ra_ar_gt.group_id := '00';
9758: l_ra_ar_gt.base_dist_amt := p_adj_rec.freight_adjusted;
9759: l_ra_ar_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted,
9760: p_ae_sys_rec.base_currency);
9761: l_ra_ar_gt.source_type := 'FREIGHT';
9762: l_ra_ar_gt.source_table := 'ADJ';
9763: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9764: l_ra_ar_gt.gp_level := 'D';
9765: l_ra_ar_gt.group_id := '00';
9766: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt);
9759: l_ra_ar_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted,
9760: p_ae_sys_rec.base_currency);
9761: l_ra_ar_gt.source_type := 'FREIGHT';
9762: l_ra_ar_gt.source_table := 'ADJ';
9763: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9764: l_ra_ar_gt.gp_level := 'D';
9765: l_ra_ar_gt.group_id := '00';
9766: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt);
9767: END IF;
9760: p_ae_sys_rec.base_currency);
9761: l_ra_ar_gt.source_type := 'FREIGHT';
9762: l_ra_ar_gt.source_table := 'ADJ';
9763: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9764: l_ra_ar_gt.gp_level := 'D';
9765: l_ra_ar_gt.group_id := '00';
9766: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt);
9767: END IF;
9768: END freight_boundary;
9761: l_ra_ar_gt.source_type := 'FREIGHT';
9762: l_ra_ar_gt.source_table := 'ADJ';
9763: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9764: l_ra_ar_gt.gp_level := 'D';
9765: l_ra_ar_gt.group_id := '00';
9766: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt);
9767: END IF;
9768: END freight_boundary;
9769: */
9762: l_ra_ar_gt.source_table := 'ADJ';
9763: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
9764: l_ra_ar_gt.gp_level := 'D';
9765: l_ra_ar_gt.group_id := '00';
9766: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt);
9767: END IF;
9768: END freight_boundary;
9769: */
9770: BEGIN
10033: b.TO_CURRENCY ,
10034: b.FROM_CURRENCY ,
10035: -- Rowid
10036: b.rowid
10037: FROM RA_AR_GT b,
10038: RA_AR_AMOUNTS_GT d
10039: WHERE b.gt_id = p_gt_id
10040: AND b.ref_customer_trx_id = p_customer_trx_id
10041: AND b.gp_level = 'GPL'
10308: x_run_uned_chrg_acctd_amt => l_run_uned_chrg_acctd_amt,
10309: x_run_uned_chrg_acctd_alloc => l_run_uned_chrg_acctd_alloc);
10310:
10311: IF PG_DEBUG = 'Y' THEN
10312: localdebug('update ra_ar_gt trx_line_all ');
10313: END IF;
10314: FORALL i IN l_tab.ROWID_ID.FIRST .. l_tab.ROWID_ID.LAST
10315: UPDATE ra_ar_gt
10316: SET
10311: IF PG_DEBUG = 'Y' THEN
10312: localdebug('update ra_ar_gt trx_line_all ');
10313: END IF;
10314: FORALL i IN l_tab.ROWID_ID.FIRST .. l_tab.ROWID_ID.LAST
10315: UPDATE ra_ar_gt
10316: SET
10317: -- ADJ and APP
10318: tl_alloc_amt = l_tab.tl_alloc_amt(i),
10319: tl_alloc_acctd_amt = l_tab.tl_alloc_acctd_amt(i),
10377: localdebug(' p_source_data_key5 :'||p_source_data_key5);
10378: localdebug(' p_gt_id :'||p_gt_id);
10379: END IF;
10380:
10381: INSERT INTO RA_AR_GT
10382: ( GT_ID ,
10383: BASE_CURRENCY ,
10384: TO_CURRENCY ,
10385: REF_CUSTOMER_TRX_ID ,
10723: localdebug(' p_customer_trx_line_id :'||p_customer_trx_line_id);
10724: localdebug(' p_gt_id :'||p_gt_id);
10725: END IF;
10726:
10727: INSERT INTO RA_AR_GT
10728: ( GT_ID ,
10729: BASE_CURRENCY ,
10730: TO_CURRENCY ,
10731: REF_CUSTOMER_TRX_ID ,
12398: -- END IF;
12399:
12400: --HYU
12401: -- delete from ra_ar_st;
12402: -- insert into ra_ar_st select * from ra_ar_gt;
12403:
12404: --{HYUNLB
12405: -- final_update_inv_ctl_rem_orig(p_customer_trx => p_customer_trx);
12406: --}
12444: RAISE;
12445: END Trx_level_direct_cash_apply;
12446:
12447:
12448: PROCEDURE display_ra_ar_row(p_ra_ar_rec IN ra_ar_gt%ROWTYPE)
12449: IS
12450: BEGIN
12451: IF PG_DEBUG = 'Y' THEN
12452: localdebug( 'display_ra_ar_row +');
12682: END IF;
12683: END;
12684:
12685:
12686: PROCEDURE display_ra_ar_gt
12687: (p_code IN VARCHAR2 DEFAULT NULL,
12688: p_gt_id IN VARCHAR2)
12689: IS
12690: CURSOR c1 IS
12687: (p_code IN VARCHAR2 DEFAULT NULL,
12688: p_gt_id IN VARCHAR2)
12689: IS
12690: CURSOR c1 IS
12691: SELECT * FROM ra_ar_gt
12692: WHERE gt_id = p_gt_id;
12693:
12694: CURSOR c2 IS
12695: SELECT * FROM ra_ar_gt
12691: SELECT * FROM ra_ar_gt
12692: WHERE gt_id = p_gt_id;
12693:
12694: CURSOR c2 IS
12695: SELECT * FROM ra_ar_gt
12696: WHERE gp_level = p_code
12697: AND gt_id = p_gt_id;
12698:
12699: l_record c1%ROWTYPE;
12699: l_record c1%ROWTYPE;
12700: l_record2 c2%ROWTYPE;
12701: BEGIN
12702: IF (PG_DEBUG = 'Y') THEN
12703: localdebug('arp_det_dist_pkg.display_ra_ar_gt()+');
12704: localdebug(' p_code : '||p_code);
12705: IF p_code IS NULL THEN
12706: OPEN c1;
12707: LOOP
12718: display_ra_ar_row(l_record2);
12719: END LOOP;
12720: CLOSE c2;
12721: END IF;
12722: localdebug('arp_det_dist_pkg.display_ra_ar_gt()-');
12723: END IF;
12724: END;
12725:
12726:
15639: IF PG_DEBUG = 'Y' THEN
15640: localdebug('p_gt_id:'||p_gt_id);
15641: END IF;
15642:
15643: UPDATE RA_AR_GT SET
15644: tl_alloc_amt = DECODE(account_class,'REV' ,g_line_applied,
15645: 'INVOICE' ,g_line_applied,0)
15646: , tl_alloc_acctd_amt = DECODE(account_class,'REV' ,g_acctd_line_applied,
15647: 'INVOICE' ,g_acctd_line_applied,0)
15690:
15691:
15692: ELSIF p_cash_mfar = 'MFAR' THEN
15693:
15694: UPDATE RA_AR_GT SET
15695: tl_alloc_amt = DECODE(account_class,'REV' ,g_line_applied,0)
15696: ,tl_alloc_acctd_amt = DECODE(account_class,'REV' ,g_acctd_line_applied,0)
15697: ,tl_chrg_alloc_amt = g_chrg_applied
15698: ,tl_chrg_alloc_acctd_amt = g_acctd_chrg_applied
15733:
15734: END IF;
15735:
15736: -- delete from ra_ar;
15737: -- insert into ra_ar select * from ra_ar_gt;
15738:
15739:
15740: --g_se_gt_id := USERENV('SESSIONID');
15741:
16014: g_uned_req := 'N';
16015: END IF;
16016:
16017:
16018: UPDATE RA_AR_GT a SET
16019: ( tl_alloc_amt ,
16020: tl_alloc_acctd_amt ,
16021: tl_chrg_alloc_amt ,
16022: tl_chrg_alloc_acctd_amt,
16087: --, USERENV('SESSIONID')
16088: , p_app_rec.receivable_application_id
16089: , 'RA'
16090: , p_ae_sys_rec.base_currency
16091: FROM ra_ar_gt b
16092: WHERE a.rowid = b.rowid
16093: AND a.gt_id = p_gt_id);
16094:
16095: -- delete from ra_ar;
16092: WHERE a.rowid = b.rowid
16093: AND a.gt_id = p_gt_id);
16094:
16095: -- delete from ra_ar;
16096: -- insert into ra_ar select * from ra_ar_gt;
16097:
16098: update_dist
16099: (p_gt_id => p_gt_id,
16100: p_customer_trx_id => l_app_rec.applied_customer_trx_id,
16324: b.base_dist_tax_amt tax_balance,
16325: b.base_dist_frt_amt freight_balance,
16326: b.base_dist_chrg_amt charges_balance,
16327: a.to_currency invoice_currency_code
16328: FROM ra_ar_gt a,ar_base_dist_amts_gt b
16329: WHERE a.ref_customer_trx_id = p_customer_trx_id
16330: AND b.gt_id = a.gt_id
16331: AND b.gp_level = 'D'
16332: AND a.ref_customer_trx_id = b.ref_customer_trx_id
17809: SUM_INT_ED_LINE_AMOUNT ,
17810: SUM_INT_ED_TAX_AMOUNT ,
17811: SUM_INT_UNED_LINE_AMOUNT ,
17812: SUM_INT_UNED_TAX_AMOUNT
17813: FROM ra_ar_gt
17814: WHERE gt_id = l_gt_id;
17815: */
17816:
17817: OPEN c(l_gt_id);