eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_DET_DIST_PKG dependencies on RA_AR_GT

Line 47: PROCEDURE display_ra_ar_gt

43: g_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
44:
45: PROCEDURE localdebug(p_txt IN VARCHAR2);
46:
47: PROCEDURE display_ra_ar_gt
48: (p_code IN VARCHAR2 DEFAULT NULL,
49: p_gt_id IN VARCHAR2);
50:
51: PROCEDURE display_cust_trx_gt(p_customer_trx_id IN NUMBER);

Line 638: | Read ra_ar_gt for proration info |

634:
635: /*-----------------------------------------------------------------------+
636: | update_line |
637: +-----------------------------------------------------------------------+
638: | Read ra_ar_gt for proration info |
639: | Does the proration plsql_proration |
640: | update ra_ar_gt with the result |
641: | for lines of a transaction |
642: +-----------------------------------------------------------------------+

Line 640: | update ra_ar_gt with the result |

636: | update_line |
637: +-----------------------------------------------------------------------+
638: | Read ra_ar_gt for proration info |
639: | Does the proration plsql_proration |
640: | update ra_ar_gt with the result |
641: | for lines of a transaction |
642: +-----------------------------------------------------------------------+
643: | parameter: |
644: | p_customer_trx_id transaction id |

Line 753: | It inserts into ra_ar_gt with gp_level = 'GPL' |

749: | This procedure determine the base |
750: | the element |
751: | the bucket |
752: | group of lines proration |
753: | It inserts into ra_ar_gt with gp_level = 'GPL' |
754: +-------------------------------------------------------------------------+
755: | p_pay_adj APP / ADJ |
756: | in case of APP ED/UNED will be |
757: | kicked off. |

Line 775: | base on result in ra_ar_gt |

771: | update_ctl_rem_orig |
772: +-------------------------------------------------------------------------+
773: | Update ra_customer_trx_lines |
774: | remaining and original amount |
775: | base on result in ra_ar_gt |
776: +-------------------------------------------------------------------------+
777: | parameter: |
778: | p_gt_id global id |
779: | p_customer_trx_id transaction id |

Line 826: | Read ra_ar_gt for proration info |

822:
823: /*-------------------------------------------------------------------------+
824: | update_group_line |
825: +-------------------------------------------------------------------------+
826: | Read ra_ar_gt for proration info |
827: | Does the proration plsql_proration |
828: | update ra_ar_gt with the result |
829: | for group of line of all lines of a invoice |
830: +-------------------------------------------------------------------------+

Line 828: | update ra_ar_gt with the result |

824: | update_group_line |
825: +-------------------------------------------------------------------------+
826: | Read ra_ar_gt for proration info |
827: | Does the proration plsql_proration |
828: | update ra_ar_gt with the result |
829: | for group of line of all lines of a invoice |
830: +-------------------------------------------------------------------------+
831: | parameter: |
832: | p_customer_trx_id transaction id |

Line 3012: FROM RA_AR_GT b,

3008: b.FROM_CURRENCY ,
3009: -- Rowid
3010: b.rowid,
3011: b.line_type
3012: FROM RA_AR_GT b,
3013: RA_AR_AMOUNTS_GT d
3014: WHERE b.gt_id = p_gt_id
3015: AND b.ref_customer_trx_id = p_customer_trx_id
3016: AND b.gp_level = 'L'

Line 3290: localdebug(' update ra_ar_gt trx_line_all ');

3286: x_run_uned_tax_acctd_alloc => l_run_uned_tax_acctd_alloc
3287: );
3288:
3289: IF PG_DEBUG = 'Y' THEN
3290: localdebug(' update ra_ar_gt trx_line_all ');
3291: END IF;
3292: FORALL i IN l_tab.ROWID_ID.FIRST .. l_tab.ROWID_ID.LAST
3293: UPDATE ra_ar_gt
3294: SET

Line 3293: UPDATE ra_ar_gt

3289: IF PG_DEBUG = 'Y' THEN
3290: localdebug(' update ra_ar_gt trx_line_all ');
3291: END IF;
3292: FORALL i IN l_tab.ROWID_ID.FIRST .. l_tab.ROWID_ID.LAST
3293: UPDATE ra_ar_gt
3294: SET
3295: -- ADJ and APP
3296: tl_alloc_amt = l_tab.tl_alloc_amt(i),
3297: tl_alloc_acctd_amt = l_tab.tl_alloc_acctd_amt(i),

Line 3324: localdebug(' update ra_ar_gt trx_line_all ');

3320: tl_uned_tax_alloc_amt = l_tab.tl_uned_tax_alloc_amt(i),
3321: tl_uned_tax_alloc_acctd_amt = l_tab.tl_uned_tax_alloc_acctd_amt(i)
3322: WHERE rowid = l_tab.ROWID_ID(i);
3323: IF PG_DEBUG = 'Y' THEN
3324: localdebug(' update ra_ar_gt trx_line_all ');
3325: END IF;
3326:
3327: END LOOP;
3328: CLOSE c_read_for_line;

Line 3356: INSERT INTO RA_AR_GT

3352:
3353: IF PG_DEBUG = 'Y' THEN
3354: localdebug(' for regular transaction');
3355: END IF;
3356: INSERT INTO RA_AR_GT
3357: ( GT_ID ,
3358: BASE_CURRENCY ,
3359: TO_CURRENCY ,
3360: REF_CUSTOMER_TRX_ID ,

Line 3926: display_ra_ar_gt(p_gt_id => p_gt_id);

3922: localdebug(' rows inserted = ' || l_rows);
3923: END IF;
3924:
3925: IF PG_DEBUG = 'Y' THEN
3926: display_ra_ar_gt(p_gt_id => p_gt_id);
3927: END IF;
3928:
3929: IF PG_DEBUG = 'Y' THEN
3930: localdebug('arp_det_dist_pkg.get_invoice_line_info()-');

Line 3957: INSERT INTO RA_AR_GT

3953: localdebug(' sob_type :'||p_ae_sys_rec.sob_type);
3954: localdebug(' set_of_books_id :'||p_ae_sys_rec.set_of_books_id);
3955:
3956: localdebug(' for regular transaction against cm');
3957: INSERT INTO RA_AR_GT
3958: ( GT_ID ,
3959: BASE_CURRENCY ,
3960: TO_CURRENCY ,
3961: REF_CUSTOMER_TRX_ID ,

Line 4144: display_ra_ar_gt(p_gt_id => p_gt_id);

4140: l_rows := sql%rowcount;
4141: localdebug(' rows inserted = ' || l_rows);
4142:
4143: IF PG_DEBUG = 'Y' THEN
4144: display_ra_ar_gt(p_gt_id => p_gt_id);
4145: END IF;
4146:
4147: localdebug('arp_det_dist_pkg.get_invoice_line_info_cm()-');
4148: EXCEPTION

Line 4198: INSERT INTO ra_ar_gt

4194: ------------------------------------------------------------------------
4195: -- Create groups
4196: -- The group_id used currently is ra_customer_trx_lines.SOURCE_DATA_KEY1
4197: ------------------------------------------------------------------------
4198: INSERT INTO ra_ar_gt
4199: (gt_id,
4200: gp_level,
4201: group_id,
4202: --{HYUBPAGP

Line 4342: FROM ra_ar_gt rar,

4338: --{Taxable Amount
4339: -- ,rar.tax_link_id
4340: -- ,rar.tax_inc_flag
4341: --}
4342: FROM ra_ar_gt rar,
4343: (SELECT /*+INDEX (b ra_ar_n1)*/
4344: SUM(DECODE(b.line_type,'LINE' ,b.FRT_ADJ_REM_AMT,
4345: 'CB' ,b.FRT_ADJ_REM_AMT,
4346: 'FREIGHT',b.FRT_REM_AMT,

Line 4362: FROM ra_ar_gt b

4358: ,b.source_data_key5
4359: --{HYUIssue
4360: ,b.ref_customer_trx_line_id
4361: --}
4362: FROM ra_ar_gt b
4363: WHERE b.ref_customer_trx_id = p_customer_trx_id
4364: AND b.gt_id = p_gt_id
4365: AND b.gp_level = 'L'
4366: AND b.set_of_books_id = p_ae_sys_rec.set_of_books_id

Line 4402: FROM ra_ar_gt b

4398: --{HYUIssue
4399: ,b.ref_customer_trx_line_id
4400: --}
4401: --}
4402: FROM ra_ar_gt b
4403: WHERE b.ref_customer_trx_id = p_customer_trx_id
4404: AND b.gt_id = p_gt_id
4405: AND b.gp_level = 'L'
4406: AND b.set_of_books_id = p_ae_sys_rec.set_of_books_id

Line 4507: display_ra_ar_gt(p_code => 'GPL', p_gt_id => p_gt_id);

4503: localdebug(' rows inserted = ' || l_rows);
4504: END IF;
4505:
4506: IF PG_DEBUG = 'Y' THEN
4507: display_ra_ar_gt(p_code => 'GPL', p_gt_id => p_gt_id);
4508: END IF;
4509:
4510: ---------------------------------
4511: -- Determine the bucket for group

Line 4919: FROM RA_AR_GT a

4915: 'Y',
4916: 'Y',
4917: 'N')
4918: else 0 end
4919: FROM RA_AR_GT a
4920: WHERE a.gt_id = p_gt_id
4921: AND a.ref_customer_trx_id = p_customer_trx_id
4922: AND a.gp_level = 'GPL'
4923: AND a.set_of_books_id = p_ae_sys_rec.set_of_books_id

Line 4928: display_ra_ar_gt(p_code => 'GPL',p_gt_id => p_gt_id);

4924: AND (a.sob_type = p_ae_sys_rec.sob_type OR
4925: (a.sob_type IS NULL AND p_ae_sys_rec.sob_type IS NULL));
4926:
4927: IF PG_DEBUG = 'Y' THEN
4928: display_ra_ar_gt(p_code => 'GPL',p_gt_id => p_gt_id);
4929: END IF;
4930:
4931: IF PG_DEBUG = 'Y' THEN
4932: localdebug('arp_det_dist_pkg.prepare_group_for_proration()-');

Line 5888: FROM RA_AR_GT b,

5884: else 0 end
5885: END
5886: ,c.TL_UNED_CHRG_ALLOC_AMT
5887: ,c.TL_UNED_CHRG_ALLOC_ACCTD_AMT
5888: FROM RA_AR_GT b,
5889: RA_AR_GT c,
5890: RA_AR_AMOUNTS_GT d
5891: WHERE b.gt_id = p_gt_id
5892: -- AND b.se_gt_id = g_se_gt_id

Line 5889: RA_AR_GT c,

5885: END
5886: ,c.TL_UNED_CHRG_ALLOC_AMT
5887: ,c.TL_UNED_CHRG_ALLOC_ACCTD_AMT
5888: FROM RA_AR_GT b,
5889: RA_AR_GT c,
5890: RA_AR_AMOUNTS_GT d
5891: WHERE b.gt_id = p_gt_id
5892: -- AND b.se_gt_id = g_se_gt_id
5893: AND b.ref_customer_trx_id = p_customer_trx_id

Line 5922: display_ra_ar_gt(p_code => 'L', p_gt_id => p_gt_id);

5918: AND c.ref_customer_trx_line_id = b.ref_customer_trx_line_id;
5919: --}
5920:
5921: IF PG_DEBUG = 'Y' THEN
5922: display_ra_ar_gt(p_code => 'L', p_gt_id => p_gt_id);
5923: END IF;
5924:
5925: IF PG_DEBUG = 'Y' THEN
5926: localdebug('arp_det_dist_pkg.prepare_trx_line_proration()-');

Line 6099: FROM RA_AR_GT b

6095: ,NVL(a.frt_uned_acctd_amount,0)
6096: + DECODE(p_pay_adj,'ADJ',0,
6097: DECODE(b.line_type,'LINE',NVL(b.tl_uned_frt_alloc_acctd_amt,0),
6098: 'CB' ,NVL(b.tl_uned_frt_alloc_acctd_amt,0),0))
6099: FROM RA_AR_GT b
6100: WHERE b.gt_id = p_gt_id
6101: -- AND b.se_gt_id = g_se_gt_id
6102: AND a.customer_trx_id = b.ref_customer_trx_id
6103: AND a.customer_trx_line_id = b.ref_customer_trx_line_id

Line 6268: FROM RA_AR_GT b

6264: ,NVL(a.frt_uned_acctd_amount,0)
6265: + DECODE(p_pay_adj,'ADJ',0,
6266: DECODE(b.line_type,'LINE',NVL(b.tl_uned_frt_alloc_acctd_amt,0),
6267: 'CB' ,NVL(b.tl_uned_frt_alloc_acctd_amt,0),0))
6268: FROM RA_AR_GT b
6269: WHERE b.gt_id = p_gt_id
6270: -- AND b.se_gt_id = g_se_gt_id
6271: AND a.customer_trx_id = b.ref_customer_trx_id
6272: AND a.customer_trx_line_id = b.ref_customer_trx_line_id

Line 6436: FROM RA_AR_GT b

6432: ,NVL(a.frt_uned_acctd_amount,0)
6433: + DECODE(p_pay_adj,'ADJ',0,
6434: DECODE(b.line_type,'LINE',NVL(b.tl_uned_frt_alloc_acctd_amt,0),
6435: 'CB' ,NVL(b.tl_uned_frt_alloc_acctd_amt,0),0))
6436: FROM RA_AR_GT b
6437: WHERE b.gt_id = p_gt_id
6438: -- AND b.se_gt_id = g_se_gt_id
6439: AND a.customer_trx_id = b.ref_customer_trx_id
6440: AND a.customer_trx_line_id = b.ref_customer_trx_line_id

Line 6605: FROM RA_AR_GT b

6601: ,NVL(a.frt_uned_acctd_amount,0)
6602: + DECODE(p_pay_adj,'ADJ',0,
6603: DECODE(b.line_type,'LINE',NVL(b.tl_uned_frt_alloc_acctd_amt,0),
6604: 'CB' ,NVL(b.tl_uned_frt_alloc_acctd_amt,0),0))
6605: FROM RA_AR_GT b
6606: WHERE b.gt_id = p_gt_id
6607: -- AND b.se_gt_id = g_se_gt_id
6608: AND a.customer_trx_id = b.ref_customer_trx_id
6609: AND a.customer_trx_line_id = b.ref_customer_trx_line_id

Line 6646: SELECT 'X' FROM RA_AR_GT R

6642: = DECODE(p_source_data_key5, NULL, '-99', a.source_data_key5)
6643: --}
6644: AND a.line_type IN ('LINE','FREIGHT','TAX','CB','CHARGES')
6645: AND EXISTS (
6646: SELECT 'X' FROM RA_AR_GT R
6647: WHERE R.gt_id = p_gt_id
6648: AND a.customer_trx_id = R.ref_customer_trx_id
6649: AND a.customer_trx_line_id = R.ref_customer_trx_line_id
6650: AND NVL(a.source_data_key1,'00') = R.source_data_key1

Line 6690: INSERT INTO RA_AR_GT

6686: localdebug(' p_ae_sys_rec.set_of_books_id :'||p_ae_sys_rec.set_of_books_id);
6687: localdebug(' p_ae_sys_rec.sob_type :'||p_ae_sys_rec.sob_type);
6688: END IF;
6689:
6690: INSERT INTO RA_AR_GT
6691: ( GT_ID ,
6692: AMT ,
6693: ACCTD_AMT ,
6694: ACCOUNT_CLASS ,

Line 6904: FROM ra_ar_gt rar,

6900: p_ae_sys_rec.set_of_books_id,
6901: p_ae_sys_rec.sob_type,
6902: rar.tax_link_id,
6903: rar.tax_inc_flag
6904: FROM ra_ar_gt rar,
6905: ra_cust_trx_line_gl_dist ctlgd
6906: WHERE rar.gt_id = p_gt_id
6907: AND rar.ref_customer_trx_id = p_customer_trx_id
6908: AND rar.gp_level = 'L'

Line 6950: INSERT INTO RA_AR_GT

6946: localdebug(' Normal R12 distributions');
6947: END IF;
6948:
6949: -- Adj Distribution R12
6950: INSERT INTO RA_AR_GT
6951: ( GT_ID ,
6952: AMT ,
6953: ACCTD_AMT ,
6954: ACCOUNT_CLASS ,

Line 7579: FROM ra_ar_gt rar,

7575: DECODE(rrc.ref_account_class,'TAX','Y',
7576: --'REV',DECODE(NVL(adj.tax_adjusted,0),0, 'N','Y'),
7577: 'REV','Y', -- BUG 7597090
7578: 'N') -- tax_inc_flag
7579: FROM ra_ar_gt rar,
7580: ar_distributions rrc,
7581: ar_adjustments adj
7582: WHERE rar.gt_id = p_gt_id
7583: AND rar.ref_customer_trx_id = p_customer_trx_id

Line 7602: INSERT INTO RA_AR_GT

7598: localdebug(' App Frt/Chrg R12 distributions');
7599: END IF;
7600:
7601: -- App Frt/Chrg Distribution R12
7602: INSERT INTO RA_AR_GT
7603: ( GT_ID ,
7604: AMT ,
7605: ACCTD_AMT ,
7606: ACCOUNT_CLASS ,

Line 7972: FROM ra_ar_gt rar,

7968: DECODE(rrc.ref_account_class,'TAX','Y',
7969: --'REV',DECODE(NVL(adj.tax_adjusted,0),0, 'N','Y'),
7970: 'REV','Y', -- BUG 7597090
7971: 'N') -- tax_inc_flag
7972: FROM ra_ar_gt rar,
7973: ar_distributions rrc,
7974: ar_receivable_applications ra,
7975: ra_customer_trx_lines ctl
7976: WHERE rar.gt_id = p_gt_id

Line 7998: INSERT INTO RA_AR_GT

7994: --{Boundary distributions
7995: localdebug(' Boundary R12 distributions');
7996: END IF;
7997:
7998: INSERT INTO RA_AR_GT
7999: ( GT_ID ,
8000: AMT ,
8001: ACCTD_AMT ,
8002: ACCOUNT_CLASS ,

Line 8204: (SELECT /+INDEX (ra_ar_gt ra_ar_n1)/

8200: p_ae_sys_rec.sob_type,
8201: rrc.tax_link_id, -- tax_link_id
8202: 'N' -- tax_inc_flag
8203: FROM ar_distributions rrc,
8204: (SELECT /*+INDEX (ra_ar_gt ra_ar_n1)*/
8205: MAX(group_id) group_id,
8206: --{HYUBPAGP
8207: MAX(source_data_key1) source_data_key1,
8208: MAX(source_data_key2) source_data_key2,

Line 8213: FROM ra_ar_gt

8209: MAX(source_data_key3) source_data_key3,
8210: MAX(source_data_key4) source_data_key4,
8211: MAX(source_data_key5) source_data_key5
8212: --}
8213: FROM ra_ar_gt
8214: WHERE gt_id = p_gt_id
8215: AND ref_customer_trx_id = p_customer_trx_id
8216: AND gp_level = 'L') g,
8217: ar_adjustments adj,

Line 8250: INSERT INTO RA_AR_GT

8246: IF g_mode_process = 'R12_11IMFAR' THEN
8247: IF PG_DEBUG = 'Y' THEN
8248: localdebug(' Mfar 11I legacy to R12 distributions');
8249: END IF;
8250: INSERT INTO RA_AR_GT
8251: ( GT_ID ,
8252: AMT ,
8253: ACCTD_AMT ,
8254: ACCOUNT_CLASS ,

Line 8445: FROM ra_ar_gt rar,

8441: DECODE(ctl.line_type,'TAX','Y',
8442: 'REV',DECODE(NVL(adj.tax_adjusted,0),0, 'N','Y'),
8443: 'N'), -- tax_inc_flag
8444: 'Y' -- ref_mf_dist_flag
8445: FROM ra_ar_gt rar,
8446: psa_mf_adj_dist_all rrc,
8447: ra_cust_trx_line_gl_dist ctlgd,
8448: ra_customer_trx_lines ctl,
8449: ar_adjustments adj

Line 8538: FROM ra_ar_gt b

8534: ,SUM(b.dist_uned_tax_amt) base_uned_dist_tax_amt
8535: ,SUM(b.dist_uned_tax_acctd_amt) base_uned_dist_tax_acctd_amt
8536: ,set_of_books_id
8537: ,sob_type
8538: FROM ra_ar_gt b
8539: WHERE b.gt_id = p_gt_id
8540: AND b.gp_level = 'D'
8541: AND b.set_of_books_id = p_ae_sys_rec.set_of_books_id
8542: AND (b.sob_type = p_ae_sys_rec.sob_type OR

Line 8662: FROM RA_AR_GT a,AR_BASE_DIST_AMTS_GT b--[bug 6454022]

8658: FROM_CURRENCY ,
8659: -- Rowid
8660: a.rowid,
8661: a.line_type
8662: FROM RA_AR_GT a,AR_BASE_DIST_AMTS_GT b--[bug 6454022]
8663: WHERE a.gt_id = p_gt_id
8664: -- AND se_gt_id = g_se_gt_id
8665: AND a.ref_customer_trx_id = p_customer_trx_id
8666: AND a.ref_cust_trx_line_gl_dist_id IS NOT NULL

Line 8950: UPDATE ra_ar_gt

8946: x_run_uned_tax_acctd_amt => l_run_uned_tax_acctd_amt,
8947: x_run_uned_tax_acctd_alloc => l_run_uned_tax_acctd_alloc);
8948:
8949: FORALL i IN l_tab.ROWID_ID.FIRST .. l_tab.ROWID_ID.LAST
8950: UPDATE ra_ar_gt
8951: SET
8952: -- ADJ and APP
8953: tl_alloc_amt = l_tab.tl_alloc_amt(i),
8954: tl_alloc_acctd_amt = l_tab.tl_alloc_acctd_amt(i),

Line 9146: FROM RA_AR_GT a,

9142: , ref_mf_dist_flag
9143: , g_org_id
9144: , tax_code_id
9145: , location_segment_id
9146: FROM RA_AR_GT a,
9147: (SELECT DECODE(ROWNUM,1, 'RAADJLINE',
9148: 2,'RAADJFREIGHT',
9149: 3,'RAADJTAX',
9150: 4,'RAADJCHARGES',

Line 9331: FROM RA_AR_GT a,

9327: ref_mf_dist_flag,
9328: arp_standard.sysparm.org_id,
9329: tax_code_id,
9330: location_segment_id
9331: FROM RA_AR_GT a,
9332: (SELECT DECODE(ROWNUM,1, 'RAADJLINE',
9333: 2,'RAADJFREIGHT',
9334: 3,'RAADJTAX',
9335: 4,'RAADJCHARGES',

Line 10330: PROCEDURE insert_ra_ar_gt

10326: RAISE;
10327: END set_original_rem_amt;
10328:
10329:
10330: PROCEDURE insert_ra_ar_gt
10331: ( p_ra_ar_gt IN ra_ar_gt%ROWTYPE,
10332: p_ar_base_dist_amts_gt IN ar_base_dist_amts_gt%ROWTYPE,
10333: p_ra_ar_amounts_gt IN ra_ar_amounts_gt%ROWTYPE
10334: )

Line 10331: ( p_ra_ar_gt IN ra_ar_gt%ROWTYPE,

10327: END set_original_rem_amt;
10328:
10329:
10330: PROCEDURE insert_ra_ar_gt
10331: ( p_ra_ar_gt IN ra_ar_gt%ROWTYPE,
10332: p_ar_base_dist_amts_gt IN ar_base_dist_amts_gt%ROWTYPE,
10333: p_ra_ar_amounts_gt IN ra_ar_amounts_gt%ROWTYPE
10334: )
10335: IS

Line 10339: INSERT INTO ra_ar_gt

10335: IS
10336: l_rows NUMBER;
10337: l_base_rowid ROWID;
10338: BEGIN
10339: INSERT INTO ra_ar_gt
10340: (
10341: GT_ID
10342: ,BASE_CURRENCY
10343: ,TO_CURRENCY

Line 10463: p_ra_ar_gt.GT_ID --GT_ID

10459: , activity_bucket
10460: )
10461: VALUES
10462: (
10463: p_ra_ar_gt.GT_ID --GT_ID
10464: ,p_ra_ar_gt.BASE_CURRENCY --BASE_CURRENCY
10465: ,p_ra_ar_gt.TO_CURRENCY --TO_CURRENCY
10466: ,p_ra_ar_gt.FROM_CURRENCY --FROM_CURRENCY
10467: ,p_ra_ar_gt.DET_ID --DET_ID

Line 10464: ,p_ra_ar_gt.BASE_CURRENCY --BASE_CURRENCY

10460: )
10461: VALUES
10462: (
10463: p_ra_ar_gt.GT_ID --GT_ID
10464: ,p_ra_ar_gt.BASE_CURRENCY --BASE_CURRENCY
10465: ,p_ra_ar_gt.TO_CURRENCY --TO_CURRENCY
10466: ,p_ra_ar_gt.FROM_CURRENCY --FROM_CURRENCY
10467: ,p_ra_ar_gt.DET_ID --DET_ID
10468: ,p_ra_ar_gt.LINE_ID --LINE_ID

Line 10465: ,p_ra_ar_gt.TO_CURRENCY --TO_CURRENCY

10461: VALUES
10462: (
10463: p_ra_ar_gt.GT_ID --GT_ID
10464: ,p_ra_ar_gt.BASE_CURRENCY --BASE_CURRENCY
10465: ,p_ra_ar_gt.TO_CURRENCY --TO_CURRENCY
10466: ,p_ra_ar_gt.FROM_CURRENCY --FROM_CURRENCY
10467: ,p_ra_ar_gt.DET_ID --DET_ID
10468: ,p_ra_ar_gt.LINE_ID --LINE_ID
10469: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID

Line 10466: ,p_ra_ar_gt.FROM_CURRENCY --FROM_CURRENCY

10462: (
10463: p_ra_ar_gt.GT_ID --GT_ID
10464: ,p_ra_ar_gt.BASE_CURRENCY --BASE_CURRENCY
10465: ,p_ra_ar_gt.TO_CURRENCY --TO_CURRENCY
10466: ,p_ra_ar_gt.FROM_CURRENCY --FROM_CURRENCY
10467: ,p_ra_ar_gt.DET_ID --DET_ID
10468: ,p_ra_ar_gt.LINE_ID --LINE_ID
10469: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID
10470: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID

Line 10467: ,p_ra_ar_gt.DET_ID --DET_ID

10463: p_ra_ar_gt.GT_ID --GT_ID
10464: ,p_ra_ar_gt.BASE_CURRENCY --BASE_CURRENCY
10465: ,p_ra_ar_gt.TO_CURRENCY --TO_CURRENCY
10466: ,p_ra_ar_gt.FROM_CURRENCY --FROM_CURRENCY
10467: ,p_ra_ar_gt.DET_ID --DET_ID
10468: ,p_ra_ar_gt.LINE_ID --LINE_ID
10469: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID
10470: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID
10471: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID

Line 10468: ,p_ra_ar_gt.LINE_ID --LINE_ID

10464: ,p_ra_ar_gt.BASE_CURRENCY --BASE_CURRENCY
10465: ,p_ra_ar_gt.TO_CURRENCY --TO_CURRENCY
10466: ,p_ra_ar_gt.FROM_CURRENCY --FROM_CURRENCY
10467: ,p_ra_ar_gt.DET_ID --DET_ID
10468: ,p_ra_ar_gt.LINE_ID --LINE_ID
10469: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID
10470: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID
10471: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID
10472: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID

Line 10469: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID

10465: ,p_ra_ar_gt.TO_CURRENCY --TO_CURRENCY
10466: ,p_ra_ar_gt.FROM_CURRENCY --FROM_CURRENCY
10467: ,p_ra_ar_gt.DET_ID --DET_ID
10468: ,p_ra_ar_gt.LINE_ID --LINE_ID
10469: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID
10470: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID
10471: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID
10472: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID
10473: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID

Line 10470: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID

10466: ,p_ra_ar_gt.FROM_CURRENCY --FROM_CURRENCY
10467: ,p_ra_ar_gt.DET_ID --DET_ID
10468: ,p_ra_ar_gt.LINE_ID --LINE_ID
10469: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID
10470: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID
10471: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID
10472: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID
10473: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID
10474: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS

Line 10471: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID

10467: ,p_ra_ar_gt.DET_ID --DET_ID
10468: ,p_ra_ar_gt.LINE_ID --LINE_ID
10469: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID
10470: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID
10471: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID
10472: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID
10473: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID
10474: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS
10475: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE

Line 10472: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID

10468: ,p_ra_ar_gt.LINE_ID --LINE_ID
10469: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID
10470: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID
10471: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID
10472: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID
10473: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID
10474: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS
10475: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE
10476: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE

Line 10473: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID

10469: ,p_ra_ar_gt.REF_CUSTOMER_TRX_ID --REF_CUSTOMER_TRX_ID
10470: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID
10471: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID
10472: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID
10473: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID
10474: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS
10475: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE
10476: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE
10477: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID

Line 10474: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS

10470: ,p_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID --REF_CUSTOMER_TRX_LINE_ID
10471: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID
10472: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID
10473: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID
10474: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS
10475: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE
10476: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE
10477: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID
10478: ,p_ra_ar_gt.AMT --AMT

Line 10475: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE

10471: ,p_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID --REF_CUST_TRX_LINE_GL_DIST_ID
10472: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID
10473: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID
10474: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS
10475: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE
10476: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE
10477: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID
10478: ,p_ra_ar_gt.AMT --AMT
10479: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT

Line 10476: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE

10472: ,p_ra_ar_gt.REF_LINE_ID --REF_LINE_ID
10473: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID
10474: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS
10475: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE
10476: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE
10477: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID
10478: ,p_ra_ar_gt.AMT --AMT
10479: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT
10480: ,p_ra_ar_gt.AMT_DR --AMT_DR

Line 10477: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID

10473: ,p_ra_ar_gt.REF_DET_ID --REF_DET_ID
10474: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS
10475: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE
10476: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE
10477: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID
10478: ,p_ra_ar_gt.AMT --AMT
10479: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT
10480: ,p_ra_ar_gt.AMT_DR --AMT_DR
10481: ,p_ra_ar_gt.AMT_CR --AMT_CR

Line 10478: ,p_ra_ar_gt.AMT --AMT

10474: ,p_ra_ar_gt.ACCOUNT_CLASS --ACCOUNT_CLASS
10475: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE
10476: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE
10477: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID
10478: ,p_ra_ar_gt.AMT --AMT
10479: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT
10480: ,p_ra_ar_gt.AMT_DR --AMT_DR
10481: ,p_ra_ar_gt.AMT_CR --AMT_CR
10482: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR

Line 10479: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT

10475: ,p_ra_ar_gt.SOURCE_TYPE --SOURCE_TYPE
10476: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE
10477: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID
10478: ,p_ra_ar_gt.AMT --AMT
10479: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT
10480: ,p_ra_ar_gt.AMT_DR --AMT_DR
10481: ,p_ra_ar_gt.AMT_CR --AMT_CR
10482: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR
10483: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR

Line 10480: ,p_ra_ar_gt.AMT_DR --AMT_DR

10476: ,p_ra_ar_gt.SOURCE_TABLE --SOURCE_TABLE
10477: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID
10478: ,p_ra_ar_gt.AMT --AMT
10479: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT
10480: ,p_ra_ar_gt.AMT_DR --AMT_DR
10481: ,p_ra_ar_gt.AMT_CR --AMT_CR
10482: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR
10483: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR
10484: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR

Line 10481: ,p_ra_ar_gt.AMT_CR --AMT_CR

10477: ,p_ra_ar_gt.SOURCE_ID --SOURCE_ID
10478: ,p_ra_ar_gt.AMT --AMT
10479: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT
10480: ,p_ra_ar_gt.AMT_DR --AMT_DR
10481: ,p_ra_ar_gt.AMT_CR --AMT_CR
10482: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR
10483: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR
10484: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR
10485: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR

Line 10482: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR

10478: ,p_ra_ar_gt.AMT --AMT
10479: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT
10480: ,p_ra_ar_gt.AMT_DR --AMT_DR
10481: ,p_ra_ar_gt.AMT_CR --AMT_CR
10482: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR
10483: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR
10484: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR
10485: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR
10486: ,p_ra_ar_gt.CCID --CCID

Line 10483: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR

10479: ,p_ra_ar_gt.ACCTD_AMT --ACCTD_AMT
10480: ,p_ra_ar_gt.AMT_DR --AMT_DR
10481: ,p_ra_ar_gt.AMT_CR --AMT_CR
10482: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR
10483: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR
10484: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR
10485: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR
10486: ,p_ra_ar_gt.CCID --CCID
10487: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY

Line 10484: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR

10480: ,p_ra_ar_gt.AMT_DR --AMT_DR
10481: ,p_ra_ar_gt.AMT_CR --AMT_CR
10482: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR
10483: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR
10484: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR
10485: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR
10486: ,p_ra_ar_gt.CCID --CCID
10487: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY
10488: ,p_ra_ar_gt.DIST_AMT --DIST_AMT

Line 10485: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR

10481: ,p_ra_ar_gt.AMT_CR --AMT_CR
10482: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR
10483: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR
10484: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR
10485: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR
10486: ,p_ra_ar_gt.CCID --CCID
10487: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY
10488: ,p_ra_ar_gt.DIST_AMT --DIST_AMT
10489: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT

Line 10486: ,p_ra_ar_gt.CCID --CCID

10482: ,p_ra_ar_gt.ACCTD_AMT_DR --ACCTD_AMT_DR
10483: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR
10484: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR
10485: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR
10486: ,p_ra_ar_gt.CCID --CCID
10487: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY
10488: ,p_ra_ar_gt.DIST_AMT --DIST_AMT
10489: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT
10490: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT

Line 10487: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY

10483: ,p_ra_ar_gt.ACCTD_AMT_CR --ACCTD_AMT_CR
10484: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR
10485: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR
10486: ,p_ra_ar_gt.CCID --CCID
10487: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY
10488: ,p_ra_ar_gt.DIST_AMT --DIST_AMT
10489: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT
10490: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT
10491: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT

Line 10488: ,p_ra_ar_gt.DIST_AMT --DIST_AMT

10484: ,p_ra_ar_gt.FROM_ACCTD_AMT_DR --FROM_ACCTD_AMT_DR
10485: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR
10486: ,p_ra_ar_gt.CCID --CCID
10487: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY
10488: ,p_ra_ar_gt.DIST_AMT --DIST_AMT
10489: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT
10490: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT
10491: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT
10492: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT

Line 10489: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT

10485: ,p_ra_ar_gt.FROM_ACCTD_AMT_CR --FROM_ACCTD_AMT_CR
10486: ,p_ra_ar_gt.CCID --CCID
10487: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY
10488: ,p_ra_ar_gt.DIST_AMT --DIST_AMT
10489: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT
10490: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT
10491: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT
10492: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT
10493: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT

Line 10490: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT

10486: ,p_ra_ar_gt.CCID --CCID
10487: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY
10488: ,p_ra_ar_gt.DIST_AMT --DIST_AMT
10489: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT
10490: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT
10491: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT
10492: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT
10493: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT
10494: ,p_ra_ar_gt.tl_alloc_amt --TL_ALLOC_AMT

Line 10491: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT

10487: ,p_ra_ar_gt.CCID_SECONDARY --CCID_SECONDARY
10488: ,p_ra_ar_gt.DIST_AMT --DIST_AMT
10489: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT
10490: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT
10491: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT
10492: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT
10493: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT
10494: ,p_ra_ar_gt.tl_alloc_amt --TL_ALLOC_AMT
10495: ,p_ra_ar_gt.tl_alloc_acctd_amt --TL_ALLOC_ACCTD_AMT

Line 10492: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT

10488: ,p_ra_ar_gt.DIST_AMT --DIST_AMT
10489: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT
10490: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT
10491: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT
10492: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT
10493: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT
10494: ,p_ra_ar_gt.tl_alloc_amt --TL_ALLOC_AMT
10495: ,p_ra_ar_gt.tl_alloc_acctd_amt --TL_ALLOC_ACCTD_AMT
10496: ,p_ra_ar_gt.tl_chrg_alloc_amt

Line 10493: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT

10489: ,p_ra_ar_gt.DIST_ACCTD_AMT --DIST_ACCTD_AMT
10490: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT
10491: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT
10492: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT
10493: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT
10494: ,p_ra_ar_gt.tl_alloc_amt --TL_ALLOC_AMT
10495: ,p_ra_ar_gt.tl_alloc_acctd_amt --TL_ALLOC_ACCTD_AMT
10496: ,p_ra_ar_gt.tl_chrg_alloc_amt
10497: ,p_ra_ar_gt.tl_chrg_alloc_acctd_amt

Line 10494: ,p_ra_ar_gt.tl_alloc_amt --TL_ALLOC_AMT

10490: ,p_ra_ar_gt.ALLOC_AMT --ALLOC_AMT
10491: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT
10492: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT
10493: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT
10494: ,p_ra_ar_gt.tl_alloc_amt --TL_ALLOC_AMT
10495: ,p_ra_ar_gt.tl_alloc_acctd_amt --TL_ALLOC_ACCTD_AMT
10496: ,p_ra_ar_gt.tl_chrg_alloc_amt
10497: ,p_ra_ar_gt.tl_chrg_alloc_acctd_amt
10498: --

Line 10495: ,p_ra_ar_gt.tl_alloc_acctd_amt --TL_ALLOC_ACCTD_AMT

10491: ,p_ra_ar_gt.ALLOC_ACCTD_AMT --ALLOC_ACCTD_AMT
10492: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT
10493: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT
10494: ,p_ra_ar_gt.tl_alloc_amt --TL_ALLOC_AMT
10495: ,p_ra_ar_gt.tl_alloc_acctd_amt --TL_ALLOC_ACCTD_AMT
10496: ,p_ra_ar_gt.tl_chrg_alloc_amt
10497: ,p_ra_ar_gt.tl_chrg_alloc_acctd_amt
10498: --
10499: ,p_ra_ar_gt.tl_frt_alloc_amt --TL_FRT_ALLOC_AMT

Line 10496: ,p_ra_ar_gt.tl_chrg_alloc_amt

10492: ,p_ra_ar_gt.FROM_ALLOC_AMT --FROM_ALLOC_AMT
10493: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT
10494: ,p_ra_ar_gt.tl_alloc_amt --TL_ALLOC_AMT
10495: ,p_ra_ar_gt.tl_alloc_acctd_amt --TL_ALLOC_ACCTD_AMT
10496: ,p_ra_ar_gt.tl_chrg_alloc_amt
10497: ,p_ra_ar_gt.tl_chrg_alloc_acctd_amt
10498: --
10499: ,p_ra_ar_gt.tl_frt_alloc_amt --TL_FRT_ALLOC_AMT
10500: ,p_ra_ar_gt.tl_frt_alloc_acctd_amt --TL_FRT_ALLOC_ACCTD_AMT

Line 10497: ,p_ra_ar_gt.tl_chrg_alloc_acctd_amt

10493: ,p_ra_ar_gt.FROM_ALLOC_ACCTD_AMT --FROM_ALLOC_ACCTD_AMT
10494: ,p_ra_ar_gt.tl_alloc_amt --TL_ALLOC_AMT
10495: ,p_ra_ar_gt.tl_alloc_acctd_amt --TL_ALLOC_ACCTD_AMT
10496: ,p_ra_ar_gt.tl_chrg_alloc_amt
10497: ,p_ra_ar_gt.tl_chrg_alloc_acctd_amt
10498: --
10499: ,p_ra_ar_gt.tl_frt_alloc_amt --TL_FRT_ALLOC_AMT
10500: ,p_ra_ar_gt.tl_frt_alloc_acctd_amt --TL_FRT_ALLOC_ACCTD_AMT
10501: ,p_ra_ar_gt.tl_tax_alloc_amt

Line 10499: ,p_ra_ar_gt.tl_frt_alloc_amt --TL_FRT_ALLOC_AMT

10495: ,p_ra_ar_gt.tl_alloc_acctd_amt --TL_ALLOC_ACCTD_AMT
10496: ,p_ra_ar_gt.tl_chrg_alloc_amt
10497: ,p_ra_ar_gt.tl_chrg_alloc_acctd_amt
10498: --
10499: ,p_ra_ar_gt.tl_frt_alloc_amt --TL_FRT_ALLOC_AMT
10500: ,p_ra_ar_gt.tl_frt_alloc_acctd_amt --TL_FRT_ALLOC_ACCTD_AMT
10501: ,p_ra_ar_gt.tl_tax_alloc_amt
10502: ,p_ra_ar_gt.tl_tax_alloc_acctd_amt
10503: --

Line 10500: ,p_ra_ar_gt.tl_frt_alloc_acctd_amt --TL_FRT_ALLOC_ACCTD_AMT

10496: ,p_ra_ar_gt.tl_chrg_alloc_amt
10497: ,p_ra_ar_gt.tl_chrg_alloc_acctd_amt
10498: --
10499: ,p_ra_ar_gt.tl_frt_alloc_amt --TL_FRT_ALLOC_AMT
10500: ,p_ra_ar_gt.tl_frt_alloc_acctd_amt --TL_FRT_ALLOC_ACCTD_AMT
10501: ,p_ra_ar_gt.tl_tax_alloc_amt
10502: ,p_ra_ar_gt.tl_tax_alloc_acctd_amt
10503: --
10504: ,p_ra_ar_gt.DUE_REM_AMT

Line 10501: ,p_ra_ar_gt.tl_tax_alloc_amt

10497: ,p_ra_ar_gt.tl_chrg_alloc_acctd_amt
10498: --
10499: ,p_ra_ar_gt.tl_frt_alloc_amt --TL_FRT_ALLOC_AMT
10500: ,p_ra_ar_gt.tl_frt_alloc_acctd_amt --TL_FRT_ALLOC_ACCTD_AMT
10501: ,p_ra_ar_gt.tl_tax_alloc_amt
10502: ,p_ra_ar_gt.tl_tax_alloc_acctd_amt
10503: --
10504: ,p_ra_ar_gt.DUE_REM_AMT
10505: ,p_ra_ar_gt.DUE_REM_ACCTD_AMT

Line 10502: ,p_ra_ar_gt.tl_tax_alloc_acctd_amt

10498: --
10499: ,p_ra_ar_gt.tl_frt_alloc_amt --TL_FRT_ALLOC_AMT
10500: ,p_ra_ar_gt.tl_frt_alloc_acctd_amt --TL_FRT_ALLOC_ACCTD_AMT
10501: ,p_ra_ar_gt.tl_tax_alloc_amt
10502: ,p_ra_ar_gt.tl_tax_alloc_acctd_amt
10503: --
10504: ,p_ra_ar_gt.DUE_REM_AMT
10505: ,p_ra_ar_gt.DUE_REM_ACCTD_AMT
10506: --

Line 10504: ,p_ra_ar_gt.DUE_REM_AMT

10500: ,p_ra_ar_gt.tl_frt_alloc_acctd_amt --TL_FRT_ALLOC_ACCTD_AMT
10501: ,p_ra_ar_gt.tl_tax_alloc_amt
10502: ,p_ra_ar_gt.tl_tax_alloc_acctd_amt
10503: --
10504: ,p_ra_ar_gt.DUE_REM_AMT
10505: ,p_ra_ar_gt.DUE_REM_ACCTD_AMT
10506: --
10507: ,p_ra_ar_gt.FRT_REM_AMT
10508: ,p_ra_ar_gt.FRT_REM_ACCTD_AMT

Line 10505: ,p_ra_ar_gt.DUE_REM_ACCTD_AMT

10501: ,p_ra_ar_gt.tl_tax_alloc_amt
10502: ,p_ra_ar_gt.tl_tax_alloc_acctd_amt
10503: --
10504: ,p_ra_ar_gt.DUE_REM_AMT
10505: ,p_ra_ar_gt.DUE_REM_ACCTD_AMT
10506: --
10507: ,p_ra_ar_gt.FRT_REM_AMT
10508: ,p_ra_ar_gt.FRT_REM_ACCTD_AMT
10509: ,p_ra_ar_gt.TAX_REM_AMT

Line 10507: ,p_ra_ar_gt.FRT_REM_AMT

10503: --
10504: ,p_ra_ar_gt.DUE_REM_AMT
10505: ,p_ra_ar_gt.DUE_REM_ACCTD_AMT
10506: --
10507: ,p_ra_ar_gt.FRT_REM_AMT
10508: ,p_ra_ar_gt.FRT_REM_ACCTD_AMT
10509: ,p_ra_ar_gt.TAX_REM_AMT
10510: ,p_ra_ar_gt.TAX_REM_ACCTD_AMT
10511: --

Line 10508: ,p_ra_ar_gt.FRT_REM_ACCTD_AMT

10504: ,p_ra_ar_gt.DUE_REM_AMT
10505: ,p_ra_ar_gt.DUE_REM_ACCTD_AMT
10506: --
10507: ,p_ra_ar_gt.FRT_REM_AMT
10508: ,p_ra_ar_gt.FRT_REM_ACCTD_AMT
10509: ,p_ra_ar_gt.TAX_REM_AMT
10510: ,p_ra_ar_gt.TAX_REM_ACCTD_AMT
10511: --
10512: ,p_ra_ar_gt.DUE_ORIG_AMT

Line 10509: ,p_ra_ar_gt.TAX_REM_AMT

10505: ,p_ra_ar_gt.DUE_REM_ACCTD_AMT
10506: --
10507: ,p_ra_ar_gt.FRT_REM_AMT
10508: ,p_ra_ar_gt.FRT_REM_ACCTD_AMT
10509: ,p_ra_ar_gt.TAX_REM_AMT
10510: ,p_ra_ar_gt.TAX_REM_ACCTD_AMT
10511: --
10512: ,p_ra_ar_gt.DUE_ORIG_AMT
10513: ,p_ra_ar_gt.DUE_ORIG_ACCTD_AMT

Line 10510: ,p_ra_ar_gt.TAX_REM_ACCTD_AMT

10506: --
10507: ,p_ra_ar_gt.FRT_REM_AMT
10508: ,p_ra_ar_gt.FRT_REM_ACCTD_AMT
10509: ,p_ra_ar_gt.TAX_REM_AMT
10510: ,p_ra_ar_gt.TAX_REM_ACCTD_AMT
10511: --
10512: ,p_ra_ar_gt.DUE_ORIG_AMT
10513: ,p_ra_ar_gt.DUE_ORIG_ACCTD_AMT
10514: --

Line 10512: ,p_ra_ar_gt.DUE_ORIG_AMT

10508: ,p_ra_ar_gt.FRT_REM_ACCTD_AMT
10509: ,p_ra_ar_gt.TAX_REM_AMT
10510: ,p_ra_ar_gt.TAX_REM_ACCTD_AMT
10511: --
10512: ,p_ra_ar_gt.DUE_ORIG_AMT
10513: ,p_ra_ar_gt.DUE_ORIG_ACCTD_AMT
10514: --
10515: ,p_ra_ar_gt.FRT_ORIG_AMT
10516: ,p_ra_ar_gt.FRT_ORIG_ACCTD_AMT

Line 10513: ,p_ra_ar_gt.DUE_ORIG_ACCTD_AMT

10509: ,p_ra_ar_gt.TAX_REM_AMT
10510: ,p_ra_ar_gt.TAX_REM_ACCTD_AMT
10511: --
10512: ,p_ra_ar_gt.DUE_ORIG_AMT
10513: ,p_ra_ar_gt.DUE_ORIG_ACCTD_AMT
10514: --
10515: ,p_ra_ar_gt.FRT_ORIG_AMT
10516: ,p_ra_ar_gt.FRT_ORIG_ACCTD_AMT
10517: ,p_ra_ar_gt.TAX_ORIG_AMT

Line 10515: ,p_ra_ar_gt.FRT_ORIG_AMT

10511: --
10512: ,p_ra_ar_gt.DUE_ORIG_AMT
10513: ,p_ra_ar_gt.DUE_ORIG_ACCTD_AMT
10514: --
10515: ,p_ra_ar_gt.FRT_ORIG_AMT
10516: ,p_ra_ar_gt.FRT_ORIG_ACCTD_AMT
10517: ,p_ra_ar_gt.TAX_ORIG_AMT
10518: ,p_ra_ar_gt.TAX_ORIG_ACCTD_AMT
10519: --

Line 10516: ,p_ra_ar_gt.FRT_ORIG_ACCTD_AMT

10512: ,p_ra_ar_gt.DUE_ORIG_AMT
10513: ,p_ra_ar_gt.DUE_ORIG_ACCTD_AMT
10514: --
10515: ,p_ra_ar_gt.FRT_ORIG_AMT
10516: ,p_ra_ar_gt.FRT_ORIG_ACCTD_AMT
10517: ,p_ra_ar_gt.TAX_ORIG_AMT
10518: ,p_ra_ar_gt.TAX_ORIG_ACCTD_AMT
10519: --
10520: ,p_ra_ar_gt.CHRG_REM_AMT

Line 10517: ,p_ra_ar_gt.TAX_ORIG_AMT

10513: ,p_ra_ar_gt.DUE_ORIG_ACCTD_AMT
10514: --
10515: ,p_ra_ar_gt.FRT_ORIG_AMT
10516: ,p_ra_ar_gt.FRT_ORIG_ACCTD_AMT
10517: ,p_ra_ar_gt.TAX_ORIG_AMT
10518: ,p_ra_ar_gt.TAX_ORIG_ACCTD_AMT
10519: --
10520: ,p_ra_ar_gt.CHRG_REM_AMT
10521: ,p_ra_ar_gt.CHRG_REM_ACCTD_AMT

Line 10518: ,p_ra_ar_gt.TAX_ORIG_ACCTD_AMT

10514: --
10515: ,p_ra_ar_gt.FRT_ORIG_AMT
10516: ,p_ra_ar_gt.FRT_ORIG_ACCTD_AMT
10517: ,p_ra_ar_gt.TAX_ORIG_AMT
10518: ,p_ra_ar_gt.TAX_ORIG_ACCTD_AMT
10519: --
10520: ,p_ra_ar_gt.CHRG_REM_AMT
10521: ,p_ra_ar_gt.CHRG_REM_ACCTD_AMT
10522: --

Line 10520: ,p_ra_ar_gt.CHRG_REM_AMT

10516: ,p_ra_ar_gt.FRT_ORIG_ACCTD_AMT
10517: ,p_ra_ar_gt.TAX_ORIG_AMT
10518: ,p_ra_ar_gt.TAX_ORIG_ACCTD_AMT
10519: --
10520: ,p_ra_ar_gt.CHRG_REM_AMT
10521: ,p_ra_ar_gt.CHRG_REM_ACCTD_AMT
10522: --
10523: ,p_ra_ar_gt.FRT_ADJ_REM_AMT
10524: ,p_ra_ar_gt.FRT_ADJ_REM_ACCTD_AMT

Line 10521: ,p_ra_ar_gt.CHRG_REM_ACCTD_AMT

10517: ,p_ra_ar_gt.TAX_ORIG_AMT
10518: ,p_ra_ar_gt.TAX_ORIG_ACCTD_AMT
10519: --
10520: ,p_ra_ar_gt.CHRG_REM_AMT
10521: ,p_ra_ar_gt.CHRG_REM_ACCTD_AMT
10522: --
10523: ,p_ra_ar_gt.FRT_ADJ_REM_AMT
10524: ,p_ra_ar_gt.FRT_ADJ_REM_ACCTD_AMT
10525: --

Line 10523: ,p_ra_ar_gt.FRT_ADJ_REM_AMT

10519: --
10520: ,p_ra_ar_gt.CHRG_REM_AMT
10521: ,p_ra_ar_gt.CHRG_REM_ACCTD_AMT
10522: --
10523: ,p_ra_ar_gt.FRT_ADJ_REM_AMT
10524: ,p_ra_ar_gt.FRT_ADJ_REM_ACCTD_AMT
10525: --
10526: ,p_ra_ar_gt.LINE_TYPE
10527: ,p_ra_ar_gt.SUM_LINE_REM_AMT

Line 10524: ,p_ra_ar_gt.FRT_ADJ_REM_ACCTD_AMT

10520: ,p_ra_ar_gt.CHRG_REM_AMT
10521: ,p_ra_ar_gt.CHRG_REM_ACCTD_AMT
10522: --
10523: ,p_ra_ar_gt.FRT_ADJ_REM_AMT
10524: ,p_ra_ar_gt.FRT_ADJ_REM_ACCTD_AMT
10525: --
10526: ,p_ra_ar_gt.LINE_TYPE
10527: ,p_ra_ar_gt.SUM_LINE_REM_AMT
10528: ,p_ra_ar_gt.SUM_LINE_REM_ACCTD_AMT

Line 10526: ,p_ra_ar_gt.LINE_TYPE

10522: --
10523: ,p_ra_ar_gt.FRT_ADJ_REM_AMT
10524: ,p_ra_ar_gt.FRT_ADJ_REM_ACCTD_AMT
10525: --
10526: ,p_ra_ar_gt.LINE_TYPE
10527: ,p_ra_ar_gt.SUM_LINE_REM_AMT
10528: ,p_ra_ar_gt.SUM_LINE_REM_ACCTD_AMT
10529: --
10530: ,p_ra_ar_gt.SUM_LINE_FRT_REM_AMT

Line 10527: ,p_ra_ar_gt.SUM_LINE_REM_AMT

10523: ,p_ra_ar_gt.FRT_ADJ_REM_AMT
10524: ,p_ra_ar_gt.FRT_ADJ_REM_ACCTD_AMT
10525: --
10526: ,p_ra_ar_gt.LINE_TYPE
10527: ,p_ra_ar_gt.SUM_LINE_REM_AMT
10528: ,p_ra_ar_gt.SUM_LINE_REM_ACCTD_AMT
10529: --
10530: ,p_ra_ar_gt.SUM_LINE_FRT_REM_AMT
10531: ,p_ra_ar_gt.SUM_LINE_FRT_REM_ACCTD_AMT

Line 10528: ,p_ra_ar_gt.SUM_LINE_REM_ACCTD_AMT

10524: ,p_ra_ar_gt.FRT_ADJ_REM_ACCTD_AMT
10525: --
10526: ,p_ra_ar_gt.LINE_TYPE
10527: ,p_ra_ar_gt.SUM_LINE_REM_AMT
10528: ,p_ra_ar_gt.SUM_LINE_REM_ACCTD_AMT
10529: --
10530: ,p_ra_ar_gt.SUM_LINE_FRT_REM_AMT
10531: ,p_ra_ar_gt.SUM_LINE_FRT_REM_ACCTD_AMT
10532: ,p_ra_ar_gt.SUM_LINE_TAX_REM_AMT

Line 10530: ,p_ra_ar_gt.SUM_LINE_FRT_REM_AMT

10526: ,p_ra_ar_gt.LINE_TYPE
10527: ,p_ra_ar_gt.SUM_LINE_REM_AMT
10528: ,p_ra_ar_gt.SUM_LINE_REM_ACCTD_AMT
10529: --
10530: ,p_ra_ar_gt.SUM_LINE_FRT_REM_AMT
10531: ,p_ra_ar_gt.SUM_LINE_FRT_REM_ACCTD_AMT
10532: ,p_ra_ar_gt.SUM_LINE_TAX_REM_AMT
10533: ,p_ra_ar_gt.SUM_LINE_TAX_REM_ACCTD_AMT
10534: --

Line 10531: ,p_ra_ar_gt.SUM_LINE_FRT_REM_ACCTD_AMT

10527: ,p_ra_ar_gt.SUM_LINE_REM_AMT
10528: ,p_ra_ar_gt.SUM_LINE_REM_ACCTD_AMT
10529: --
10530: ,p_ra_ar_gt.SUM_LINE_FRT_REM_AMT
10531: ,p_ra_ar_gt.SUM_LINE_FRT_REM_ACCTD_AMT
10532: ,p_ra_ar_gt.SUM_LINE_TAX_REM_AMT
10533: ,p_ra_ar_gt.SUM_LINE_TAX_REM_ACCTD_AMT
10534: --
10535: ,p_ra_ar_gt.SUM_LINE_ORIG_AMT

Line 10532: ,p_ra_ar_gt.SUM_LINE_TAX_REM_AMT

10528: ,p_ra_ar_gt.SUM_LINE_REM_ACCTD_AMT
10529: --
10530: ,p_ra_ar_gt.SUM_LINE_FRT_REM_AMT
10531: ,p_ra_ar_gt.SUM_LINE_FRT_REM_ACCTD_AMT
10532: ,p_ra_ar_gt.SUM_LINE_TAX_REM_AMT
10533: ,p_ra_ar_gt.SUM_LINE_TAX_REM_ACCTD_AMT
10534: --
10535: ,p_ra_ar_gt.SUM_LINE_ORIG_AMT
10536: ,p_ra_ar_gt.SUM_LINE_ORIG_ACCTD_AMT

Line 10533: ,p_ra_ar_gt.SUM_LINE_TAX_REM_ACCTD_AMT

10529: --
10530: ,p_ra_ar_gt.SUM_LINE_FRT_REM_AMT
10531: ,p_ra_ar_gt.SUM_LINE_FRT_REM_ACCTD_AMT
10532: ,p_ra_ar_gt.SUM_LINE_TAX_REM_AMT
10533: ,p_ra_ar_gt.SUM_LINE_TAX_REM_ACCTD_AMT
10534: --
10535: ,p_ra_ar_gt.SUM_LINE_ORIG_AMT
10536: ,p_ra_ar_gt.SUM_LINE_ORIG_ACCTD_AMT
10537: --

Line 10535: ,p_ra_ar_gt.SUM_LINE_ORIG_AMT

10531: ,p_ra_ar_gt.SUM_LINE_FRT_REM_ACCTD_AMT
10532: ,p_ra_ar_gt.SUM_LINE_TAX_REM_AMT
10533: ,p_ra_ar_gt.SUM_LINE_TAX_REM_ACCTD_AMT
10534: --
10535: ,p_ra_ar_gt.SUM_LINE_ORIG_AMT
10536: ,p_ra_ar_gt.SUM_LINE_ORIG_ACCTD_AMT
10537: --
10538: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_AMT
10539: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_ACCTD_AMT

Line 10536: ,p_ra_ar_gt.SUM_LINE_ORIG_ACCTD_AMT

10532: ,p_ra_ar_gt.SUM_LINE_TAX_REM_AMT
10533: ,p_ra_ar_gt.SUM_LINE_TAX_REM_ACCTD_AMT
10534: --
10535: ,p_ra_ar_gt.SUM_LINE_ORIG_AMT
10536: ,p_ra_ar_gt.SUM_LINE_ORIG_ACCTD_AMT
10537: --
10538: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_AMT
10539: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_ACCTD_AMT
10540: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_AMT

Line 10538: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_AMT

10534: --
10535: ,p_ra_ar_gt.SUM_LINE_ORIG_AMT
10536: ,p_ra_ar_gt.SUM_LINE_ORIG_ACCTD_AMT
10537: --
10538: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_AMT
10539: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_ACCTD_AMT
10540: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_AMT
10541: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_ACCTD_AMT
10542: --

Line 10539: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_ACCTD_AMT

10535: ,p_ra_ar_gt.SUM_LINE_ORIG_AMT
10536: ,p_ra_ar_gt.SUM_LINE_ORIG_ACCTD_AMT
10537: --
10538: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_AMT
10539: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_ACCTD_AMT
10540: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_AMT
10541: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_ACCTD_AMT
10542: --
10543: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_AMT

Line 10540: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_AMT

10536: ,p_ra_ar_gt.SUM_LINE_ORIG_ACCTD_AMT
10537: --
10538: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_AMT
10539: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_ACCTD_AMT
10540: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_AMT
10541: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_ACCTD_AMT
10542: --
10543: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_AMT
10544: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_ACCTD_AMT

Line 10541: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_ACCTD_AMT

10537: --
10538: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_AMT
10539: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_ACCTD_AMT
10540: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_AMT
10541: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_ACCTD_AMT
10542: --
10543: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_AMT
10544: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_ACCTD_AMT
10545: --

Line 10543: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_AMT

10539: ,p_ra_ar_gt.SUM_LINE_FRT_ORIG_ACCTD_AMT
10540: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_AMT
10541: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_ACCTD_AMT
10542: --
10543: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_AMT
10544: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_ACCTD_AMT
10545: --
10546: ,p_ra_ar_gt.TL_ED_ALLOC_AMT
10547: ,p_ra_ar_gt.TL_ED_ALLOC_ACCTD_AMT

Line 10544: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_ACCTD_AMT

10540: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_AMT
10541: ,p_ra_ar_gt.SUM_LINE_TAX_ORIG_ACCTD_AMT
10542: --
10543: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_AMT
10544: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_ACCTD_AMT
10545: --
10546: ,p_ra_ar_gt.TL_ED_ALLOC_AMT
10547: ,p_ra_ar_gt.TL_ED_ALLOC_ACCTD_AMT
10548: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_AMT

Line 10546: ,p_ra_ar_gt.TL_ED_ALLOC_AMT

10542: --
10543: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_AMT
10544: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_ACCTD_AMT
10545: --
10546: ,p_ra_ar_gt.TL_ED_ALLOC_AMT
10547: ,p_ra_ar_gt.TL_ED_ALLOC_ACCTD_AMT
10548: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_AMT
10549: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_ACCTD_AMT
10550: --

Line 10547: ,p_ra_ar_gt.TL_ED_ALLOC_ACCTD_AMT

10543: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_AMT
10544: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_ACCTD_AMT
10545: --
10546: ,p_ra_ar_gt.TL_ED_ALLOC_AMT
10547: ,p_ra_ar_gt.TL_ED_ALLOC_ACCTD_AMT
10548: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_AMT
10549: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_ACCTD_AMT
10550: --
10551: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_AMT

Line 10548: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_AMT

10544: ,p_ra_ar_gt.SUM_LINE_CHRG_REM_ACCTD_AMT
10545: --
10546: ,p_ra_ar_gt.TL_ED_ALLOC_AMT
10547: ,p_ra_ar_gt.TL_ED_ALLOC_ACCTD_AMT
10548: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_AMT
10549: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_ACCTD_AMT
10550: --
10551: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_AMT
10552: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_ACCTD_AMT

Line 10549: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_ACCTD_AMT

10545: --
10546: ,p_ra_ar_gt.TL_ED_ALLOC_AMT
10547: ,p_ra_ar_gt.TL_ED_ALLOC_ACCTD_AMT
10548: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_AMT
10549: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_ACCTD_AMT
10550: --
10551: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_AMT
10552: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_ACCTD_AMT
10553: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_AMT

Line 10551: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_AMT

10547: ,p_ra_ar_gt.TL_ED_ALLOC_ACCTD_AMT
10548: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_AMT
10549: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_ACCTD_AMT
10550: --
10551: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_AMT
10552: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_ACCTD_AMT
10553: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_AMT
10554: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_ACCTD_AMT
10555: --

Line 10552: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_ACCTD_AMT

10548: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_AMT
10549: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_ACCTD_AMT
10550: --
10551: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_AMT
10552: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_ACCTD_AMT
10553: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_AMT
10554: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_ACCTD_AMT
10555: --
10556: ,p_ra_ar_gt.TL_UNED_ALLOC_AMT

Line 10553: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_AMT

10549: ,p_ra_ar_gt.TL_ED_CHRG_ALLOC_ACCTD_AMT
10550: --
10551: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_AMT
10552: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_ACCTD_AMT
10553: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_AMT
10554: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_ACCTD_AMT
10555: --
10556: ,p_ra_ar_gt.TL_UNED_ALLOC_AMT
10557: ,p_ra_ar_gt.TL_UNED_ALLOC_ACCTD_AMT

Line 10554: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_ACCTD_AMT

10550: --
10551: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_AMT
10552: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_ACCTD_AMT
10553: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_AMT
10554: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_ACCTD_AMT
10555: --
10556: ,p_ra_ar_gt.TL_UNED_ALLOC_AMT
10557: ,p_ra_ar_gt.TL_UNED_ALLOC_ACCTD_AMT
10558: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_AMT

Line 10556: ,p_ra_ar_gt.TL_UNED_ALLOC_AMT

10552: ,p_ra_ar_gt.TL_ED_FRT_ALLOC_ACCTD_AMT
10553: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_AMT
10554: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_ACCTD_AMT
10555: --
10556: ,p_ra_ar_gt.TL_UNED_ALLOC_AMT
10557: ,p_ra_ar_gt.TL_UNED_ALLOC_ACCTD_AMT
10558: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_AMT
10559: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_ACCTD_AMT
10560: --

Line 10557: ,p_ra_ar_gt.TL_UNED_ALLOC_ACCTD_AMT

10553: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_AMT
10554: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_ACCTD_AMT
10555: --
10556: ,p_ra_ar_gt.TL_UNED_ALLOC_AMT
10557: ,p_ra_ar_gt.TL_UNED_ALLOC_ACCTD_AMT
10558: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_AMT
10559: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_ACCTD_AMT
10560: --
10561: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_AMT

Line 10558: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_AMT

10554: ,p_ra_ar_gt.TL_ED_TAX_ALLOC_ACCTD_AMT
10555: --
10556: ,p_ra_ar_gt.TL_UNED_ALLOC_AMT
10557: ,p_ra_ar_gt.TL_UNED_ALLOC_ACCTD_AMT
10558: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_AMT
10559: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_ACCTD_AMT
10560: --
10561: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_AMT
10562: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_ACCTD_AMT

Line 10559: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_ACCTD_AMT

10555: --
10556: ,p_ra_ar_gt.TL_UNED_ALLOC_AMT
10557: ,p_ra_ar_gt.TL_UNED_ALLOC_ACCTD_AMT
10558: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_AMT
10559: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_ACCTD_AMT
10560: --
10561: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_AMT
10562: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_ACCTD_AMT
10563: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_AMT

Line 10561: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_AMT

10557: ,p_ra_ar_gt.TL_UNED_ALLOC_ACCTD_AMT
10558: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_AMT
10559: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_ACCTD_AMT
10560: --
10561: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_AMT
10562: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_ACCTD_AMT
10563: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_AMT
10564: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_ACCTD_AMT
10565: --

Line 10562: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_ACCTD_AMT

10558: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_AMT
10559: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_ACCTD_AMT
10560: --
10561: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_AMT
10562: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_ACCTD_AMT
10563: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_AMT
10564: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_ACCTD_AMT
10565: --
10566: ,p_ra_ar_gt.DIST_ED_AMT

Line 10563: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_AMT

10559: ,p_ra_ar_gt.TL_UNED_CHRG_ALLOC_ACCTD_AMT
10560: --
10561: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_AMT
10562: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_ACCTD_AMT
10563: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_AMT
10564: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_ACCTD_AMT
10565: --
10566: ,p_ra_ar_gt.DIST_ED_AMT
10567: ,p_ra_ar_gt.DIST_ED_ACCTD_AMT

Line 10564: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_ACCTD_AMT

10560: --
10561: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_AMT
10562: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_ACCTD_AMT
10563: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_AMT
10564: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_ACCTD_AMT
10565: --
10566: ,p_ra_ar_gt.DIST_ED_AMT
10567: ,p_ra_ar_gt.DIST_ED_ACCTD_AMT
10568: ,p_ra_ar_gt.DIST_UNED_AMT

Line 10566: ,p_ra_ar_gt.DIST_ED_AMT

10562: ,p_ra_ar_gt.TL_UNED_FRT_ALLOC_ACCTD_AMT
10563: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_AMT
10564: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_ACCTD_AMT
10565: --
10566: ,p_ra_ar_gt.DIST_ED_AMT
10567: ,p_ra_ar_gt.DIST_ED_ACCTD_AMT
10568: ,p_ra_ar_gt.DIST_UNED_AMT
10569: ,p_ra_ar_gt.DIST_UNED_ACCTD_AMT
10570: ,p_ra_ar_gt.gp_level

Line 10567: ,p_ra_ar_gt.DIST_ED_ACCTD_AMT

10563: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_AMT
10564: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_ACCTD_AMT
10565: --
10566: ,p_ra_ar_gt.DIST_ED_AMT
10567: ,p_ra_ar_gt.DIST_ED_ACCTD_AMT
10568: ,p_ra_ar_gt.DIST_UNED_AMT
10569: ,p_ra_ar_gt.DIST_UNED_ACCTD_AMT
10570: ,p_ra_ar_gt.gp_level
10571: ,p_ra_ar_gt.group_id

Line 10568: ,p_ra_ar_gt.DIST_UNED_AMT

10564: ,p_ra_ar_gt.TL_UNED_TAX_ALLOC_ACCTD_AMT
10565: --
10566: ,p_ra_ar_gt.DIST_ED_AMT
10567: ,p_ra_ar_gt.DIST_ED_ACCTD_AMT
10568: ,p_ra_ar_gt.DIST_UNED_AMT
10569: ,p_ra_ar_gt.DIST_UNED_ACCTD_AMT
10570: ,p_ra_ar_gt.gp_level
10571: ,p_ra_ar_gt.group_id
10572:

Line 10569: ,p_ra_ar_gt.DIST_UNED_ACCTD_AMT

10565: --
10566: ,p_ra_ar_gt.DIST_ED_AMT
10567: ,p_ra_ar_gt.DIST_ED_ACCTD_AMT
10568: ,p_ra_ar_gt.DIST_UNED_AMT
10569: ,p_ra_ar_gt.DIST_UNED_ACCTD_AMT
10570: ,p_ra_ar_gt.gp_level
10571: ,p_ra_ar_gt.group_id
10572:
10573: ,p_ra_ar_gt.source_data_key1

Line 10570: ,p_ra_ar_gt.gp_level

10566: ,p_ra_ar_gt.DIST_ED_AMT
10567: ,p_ra_ar_gt.DIST_ED_ACCTD_AMT
10568: ,p_ra_ar_gt.DIST_UNED_AMT
10569: ,p_ra_ar_gt.DIST_UNED_ACCTD_AMT
10570: ,p_ra_ar_gt.gp_level
10571: ,p_ra_ar_gt.group_id
10572:
10573: ,p_ra_ar_gt.source_data_key1
10574: ,p_ra_ar_gt.source_data_key2

Line 10571: ,p_ra_ar_gt.group_id

10567: ,p_ra_ar_gt.DIST_ED_ACCTD_AMT
10568: ,p_ra_ar_gt.DIST_UNED_AMT
10569: ,p_ra_ar_gt.DIST_UNED_ACCTD_AMT
10570: ,p_ra_ar_gt.gp_level
10571: ,p_ra_ar_gt.group_id
10572:
10573: ,p_ra_ar_gt.source_data_key1
10574: ,p_ra_ar_gt.source_data_key2
10575: ,p_ra_ar_gt.source_data_key3

Line 10573: ,p_ra_ar_gt.source_data_key1

10569: ,p_ra_ar_gt.DIST_UNED_ACCTD_AMT
10570: ,p_ra_ar_gt.gp_level
10571: ,p_ra_ar_gt.group_id
10572:
10573: ,p_ra_ar_gt.source_data_key1
10574: ,p_ra_ar_gt.source_data_key2
10575: ,p_ra_ar_gt.source_data_key3
10576: ,p_ra_ar_gt.source_data_key4
10577: ,p_ra_ar_gt.source_data_key5

Line 10574: ,p_ra_ar_gt.source_data_key2

10570: ,p_ra_ar_gt.gp_level
10571: ,p_ra_ar_gt.group_id
10572:
10573: ,p_ra_ar_gt.source_data_key1
10574: ,p_ra_ar_gt.source_data_key2
10575: ,p_ra_ar_gt.source_data_key3
10576: ,p_ra_ar_gt.source_data_key4
10577: ,p_ra_ar_gt.source_data_key5
10578:

Line 10575: ,p_ra_ar_gt.source_data_key3

10571: ,p_ra_ar_gt.group_id
10572:
10573: ,p_ra_ar_gt.source_data_key1
10574: ,p_ra_ar_gt.source_data_key2
10575: ,p_ra_ar_gt.source_data_key3
10576: ,p_ra_ar_gt.source_data_key4
10577: ,p_ra_ar_gt.source_data_key5
10578:
10579: ,p_ra_ar_gt.SET_OF_BOOKS_ID

Line 10576: ,p_ra_ar_gt.source_data_key4

10572:
10573: ,p_ra_ar_gt.source_data_key1
10574: ,p_ra_ar_gt.source_data_key2
10575: ,p_ra_ar_gt.source_data_key3
10576: ,p_ra_ar_gt.source_data_key4
10577: ,p_ra_ar_gt.source_data_key5
10578:
10579: ,p_ra_ar_gt.SET_OF_BOOKS_ID
10580: ,p_ra_ar_gt.SOB_TYPE

Line 10577: ,p_ra_ar_gt.source_data_key5

10573: ,p_ra_ar_gt.source_data_key1
10574: ,p_ra_ar_gt.source_data_key2
10575: ,p_ra_ar_gt.source_data_key3
10576: ,p_ra_ar_gt.source_data_key4
10577: ,p_ra_ar_gt.source_data_key5
10578:
10579: ,p_ra_ar_gt.SET_OF_BOOKS_ID
10580: ,p_ra_ar_gt.SOB_TYPE
10581: ,p_ra_ar_gt.activity_bucket

Line 10579: ,p_ra_ar_gt.SET_OF_BOOKS_ID

10575: ,p_ra_ar_gt.source_data_key3
10576: ,p_ra_ar_gt.source_data_key4
10577: ,p_ra_ar_gt.source_data_key5
10578:
10579: ,p_ra_ar_gt.SET_OF_BOOKS_ID
10580: ,p_ra_ar_gt.SOB_TYPE
10581: ,p_ra_ar_gt.activity_bucket
10582: ) RETURNING ROWID INTO l_base_rowid;
10583:

Line 10580: ,p_ra_ar_gt.SOB_TYPE

10576: ,p_ra_ar_gt.source_data_key4
10577: ,p_ra_ar_gt.source_data_key5
10578:
10579: ,p_ra_ar_gt.SET_OF_BOOKS_ID
10580: ,p_ra_ar_gt.SOB_TYPE
10581: ,p_ra_ar_gt.activity_bucket
10582: ) RETURNING ROWID INTO l_base_rowid;
10583:
10584: l_rows := sql%rowcount;

Line 10581: ,p_ra_ar_gt.activity_bucket

10577: ,p_ra_ar_gt.source_data_key5
10578:
10579: ,p_ra_ar_gt.SET_OF_BOOKS_ID
10580: ,p_ra_ar_gt.SOB_TYPE
10581: ,p_ra_ar_gt.activity_bucket
10582: ) RETURNING ROWID INTO l_base_rowid;
10583:
10584: l_rows := sql%rowcount;
10585: g_appln_count := g_appln_count + l_rows;

Line 10609: p_ra_ar_gt.gt_id

10605: ,source_table
10606: )
10607: VALUES
10608: (
10609: p_ra_ar_gt.gt_id
10610: ,p_ra_ar_gt.gp_level
10611: ,p_ra_ar_gt.ref_customer_trx_id
10612: ,p_ra_ar_gt.ref_customer_trx_line_id
10613: ,p_ar_base_dist_amts_gt.base_dist_amt

Line 10610: ,p_ra_ar_gt.gp_level

10606: )
10607: VALUES
10608: (
10609: p_ra_ar_gt.gt_id
10610: ,p_ra_ar_gt.gp_level
10611: ,p_ra_ar_gt.ref_customer_trx_id
10612: ,p_ra_ar_gt.ref_customer_trx_line_id
10613: ,p_ar_base_dist_amts_gt.base_dist_amt
10614: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt

Line 10611: ,p_ra_ar_gt.ref_customer_trx_id

10607: VALUES
10608: (
10609: p_ra_ar_gt.gt_id
10610: ,p_ra_ar_gt.gp_level
10611: ,p_ra_ar_gt.ref_customer_trx_id
10612: ,p_ra_ar_gt.ref_customer_trx_line_id
10613: ,p_ar_base_dist_amts_gt.base_dist_amt
10614: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt
10615: ,p_ar_base_dist_amts_gt.base_ed_dist_amt

Line 10612: ,p_ra_ar_gt.ref_customer_trx_line_id

10608: (
10609: p_ra_ar_gt.gt_id
10610: ,p_ra_ar_gt.gp_level
10611: ,p_ra_ar_gt.ref_customer_trx_id
10612: ,p_ra_ar_gt.ref_customer_trx_line_id
10613: ,p_ar_base_dist_amts_gt.base_dist_amt
10614: ,p_ar_base_dist_amts_gt.base_dist_acctd_amt
10615: ,p_ar_base_dist_amts_gt.base_ed_dist_amt
10616: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt

Line 10619: ,p_ra_ar_gt.SET_OF_BOOKS_ID

10615: ,p_ar_base_dist_amts_gt.base_ed_dist_amt
10616: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt
10617: ,p_ar_base_dist_amts_gt.base_uned_dist_amt
10618: ,p_ar_base_dist_amts_gt.base_uned_dist_acctd_amt
10619: ,p_ra_ar_gt.SET_OF_BOOKS_ID
10620: ,p_ra_ar_gt.SOB_TYPE
10621: ,p_ra_ar_gt.SOURCE_TABLE
10622: );
10623:

Line 10620: ,p_ra_ar_gt.SOB_TYPE

10616: ,p_ar_base_dist_amts_gt.base_ed_dist_acctd_amt
10617: ,p_ar_base_dist_amts_gt.base_uned_dist_amt
10618: ,p_ar_base_dist_amts_gt.base_uned_dist_acctd_amt
10619: ,p_ra_ar_gt.SET_OF_BOOKS_ID
10620: ,p_ra_ar_gt.SOB_TYPE
10621: ,p_ra_ar_gt.SOURCE_TABLE
10622: );
10623:
10624: INSERT INTO RA_AR_AMOUNTS_GT

Line 10621: ,p_ra_ar_gt.SOURCE_TABLE

10617: ,p_ar_base_dist_amts_gt.base_uned_dist_amt
10618: ,p_ar_base_dist_amts_gt.base_uned_dist_acctd_amt
10619: ,p_ra_ar_gt.SET_OF_BOOKS_ID
10620: ,p_ra_ar_gt.SOB_TYPE
10621: ,p_ra_ar_gt.SOURCE_TABLE
10622: );
10623:
10624: INSERT INTO RA_AR_AMOUNTS_GT
10625: (

Line 10724: p_ra_ar_gt.gt_id

10720: ,BASE_UNED_TAX_PRO_ACCTD_AMT
10721: )
10722: VALUES
10723: (
10724: p_ra_ar_gt.gt_id
10725: ,p_ra_ar_gt.gp_level
10726: ,l_base_rowid
10727: ,p_ra_ar_gt.ref_customer_trx_id
10728: ,p_ra_ar_gt.ref_customer_trx_line_id

Line 10725: ,p_ra_ar_gt.gp_level

10721: )
10722: VALUES
10723: (
10724: p_ra_ar_gt.gt_id
10725: ,p_ra_ar_gt.gp_level
10726: ,l_base_rowid
10727: ,p_ra_ar_gt.ref_customer_trx_id
10728: ,p_ra_ar_gt.ref_customer_trx_line_id
10729:

Line 10727: ,p_ra_ar_gt.ref_customer_trx_id

10723: (
10724: p_ra_ar_gt.gt_id
10725: ,p_ra_ar_gt.gp_level
10726: ,l_base_rowid
10727: ,p_ra_ar_gt.ref_customer_trx_id
10728: ,p_ra_ar_gt.ref_customer_trx_line_id
10729:
10730: ,p_ra_ar_amounts_gt.base_pro_amt
10731: ,p_ra_ar_amounts_gt.base_pro_acctd_amt

Line 10728: ,p_ra_ar_gt.ref_customer_trx_line_id

10724: p_ra_ar_gt.gt_id
10725: ,p_ra_ar_gt.gp_level
10726: ,l_base_rowid
10727: ,p_ra_ar_gt.ref_customer_trx_id
10728: ,p_ra_ar_gt.ref_customer_trx_line_id
10729:
10730: ,p_ra_ar_amounts_gt.base_pro_amt
10731: ,p_ra_ar_amounts_gt.base_pro_acctd_amt
10732: ,p_ra_ar_amounts_gt.BASE_CHRG_PRO_AMT

Line 10824: END insert_ra_ar_gt;

10820: l_rows := sql%rowcount;
10821: IF PG_DEBUG = 'Y' THEN
10822: localdebug(' rows inserted into AR_BASE_DIST_AMTS_GT = ' || l_rows);
10823: END IF;
10824: END insert_ra_ar_gt;
10825:
10826:
10827: PROCEDURE adjustment_detemination
10828: (p_customer_trx_id IN NUMBER,

Line 10835: SELECT /+INDEX (RA_AR_GT ra_ar_n1)/

10831: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
10832: p_adj_rec IN ar_adjustments%ROWTYPE)
10833: IS
10834: CURSOR get_sum_per_line_type IS
10835: SELECT /*+INDEX (RA_AR_GT ra_ar_n1)*/
10836: MAX(sum_line_rem_amt),
10837: MAX(sum_line_rem_acctd_amt),
10838: MAX(sum_line_orig_amt),
10839: MAX(sum_line_orig_acctd_amt),

Line 10854: FROM ra_ar_gt

10850: MAX(sum_line_tax_orig_amt),
10851: MAX(sum_line_tax_orig_acctd_amt),
10852: --
10853: line_type
10854: FROM ra_ar_gt
10855: WHERE gt_id = p_gt_id
10856: -- AND se_gt_id = g_se_gt_id
10857: AND ref_customer_trx_id = p_customer_trx_id
10858: AND gp_level = 'L' --'D'

Line 10885: l_ra_ar_gt ra_ar_gt%ROWTYPE;

10881: l_sum_line_tax_orig_amt DBMS_SQL.NUMBER_TABLE;
10882: l_sum_line_tax_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10883: --
10884: l_line_type DBMS_SQL.VARCHAR2_TABLE;
10885: l_ra_ar_gt ra_ar_gt%ROWTYPE;
10886: invoice_has_no_lines EXCEPTION;
10887: not_an_adjustment EXCEPTION;
10888: l_freight_boundary_done VARCHAR2(1) := 'N';
10889: l_line_boundary_done VARCHAR2(1) := 'N';

Line 10902: l_ra_ar_gt ra_ar_gt%ROWTYPE;

10898: p_gt_id IN VARCHAR2,
10899: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
10900: P_exchange_rate IN ra_customer_trx.exchange_rate%type)
10901: IS
10902: l_ra_ar_gt ra_ar_gt%ROWTYPE;
10903: l_ar_base_dist_amts_gt ar_base_dist_amts_gt%ROWTYPE;
10904: l_ra_ar_amounts_gt ra_ar_amounts_gt%ROWTYPE;
10905: BEGIN
10906: --Rev line boundary

Line 10914: l_ra_ar_gt.GT_ID := p_gt_id;

10910: THEN
10911: IF PG_DEBUG = 'Y' THEN
10912: localdebug(' -6 Adjustment Boundary LINE condition met');
10913: END IF;
10914: l_ra_ar_gt.GT_ID := p_gt_id;
10915: l_ra_ar_gt.AMT := p_adj_rec.line_adjusted;
10916: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10917: p_ae_sys_rec.base_currency);
10918: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';

Line 10915: l_ra_ar_gt.AMT := p_adj_rec.line_adjusted;

10911: IF PG_DEBUG = 'Y' THEN
10912: localdebug(' -6 Adjustment Boundary LINE condition met');
10913: END IF;
10914: l_ra_ar_gt.GT_ID := p_gt_id;
10915: l_ra_ar_gt.AMT := p_adj_rec.line_adjusted;
10916: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10917: p_ae_sys_rec.base_currency);
10918: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
10919: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid

Line 10916: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,

10912: localdebug(' -6 Adjustment Boundary LINE condition met');
10913: END IF;
10914: l_ra_ar_gt.GT_ID := p_gt_id;
10915: l_ra_ar_gt.AMT := p_adj_rec.line_adjusted;
10916: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10917: p_ae_sys_rec.base_currency);
10918: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
10919: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
10920: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -6;

Line 10918: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';

10914: l_ra_ar_gt.GT_ID := p_gt_id;
10915: l_ra_ar_gt.AMT := p_adj_rec.line_adjusted;
10916: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10917: p_ae_sys_rec.base_currency);
10918: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
10919: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
10920: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -6;
10921: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -6;
10922: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;

Line 10919: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid

10915: l_ra_ar_gt.AMT := p_adj_rec.line_adjusted;
10916: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10917: p_ae_sys_rec.base_currency);
10918: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
10919: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
10920: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -6;
10921: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -6;
10922: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
10923: l_ra_ar_gt.DIST_AMT := p_adj_rec.line_adjusted;

Line 10920: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -6;

10916: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10917: p_ae_sys_rec.base_currency);
10918: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
10919: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
10920: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -6;
10921: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -6;
10922: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
10923: l_ra_ar_gt.DIST_AMT := p_adj_rec.line_adjusted;
10924: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,

Line 10921: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -6;

10917: p_ae_sys_rec.base_currency);
10918: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
10919: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
10920: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -6;
10921: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -6;
10922: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
10923: l_ra_ar_gt.DIST_AMT := p_adj_rec.line_adjusted;
10924: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10925: p_ae_sys_rec.base_currency);

Line 10922: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;

10918: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
10919: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
10920: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -6;
10921: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -6;
10922: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
10923: l_ra_ar_gt.DIST_AMT := p_adj_rec.line_adjusted;
10924: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10925: p_ae_sys_rec.base_currency);
10926: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;

Line 10923: l_ra_ar_gt.DIST_AMT := p_adj_rec.line_adjusted;

10919: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
10920: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -6;
10921: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -6;
10922: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
10923: l_ra_ar_gt.DIST_AMT := p_adj_rec.line_adjusted;
10924: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10925: p_ae_sys_rec.base_currency);
10926: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
10927: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;

Line 10924: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,

10920: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -6;
10921: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -6;
10922: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
10923: l_ra_ar_gt.DIST_AMT := p_adj_rec.line_adjusted;
10924: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10925: p_ae_sys_rec.base_currency);
10926: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
10927: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
10928: l_ra_ar_gt.tl_alloc_amt := p_adj_rec.line_adjusted;

Line 10926: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;

10922: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
10923: l_ra_ar_gt.DIST_AMT := p_adj_rec.line_adjusted;
10924: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10925: p_ae_sys_rec.base_currency);
10926: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
10927: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
10928: l_ra_ar_gt.tl_alloc_amt := p_adj_rec.line_adjusted;
10929: l_ra_ar_gt.tl_alloc_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10930: p_ae_sys_rec.base_currency);

Line 10927: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;

10923: l_ra_ar_gt.DIST_AMT := p_adj_rec.line_adjusted;
10924: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10925: p_ae_sys_rec.base_currency);
10926: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
10927: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
10928: l_ra_ar_gt.tl_alloc_amt := p_adj_rec.line_adjusted;
10929: l_ra_ar_gt.tl_alloc_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10930: p_ae_sys_rec.base_currency);
10931: l_ra_ar_gt.tl_chrg_alloc_amt := 0;

Line 10928: l_ra_ar_gt.tl_alloc_amt := p_adj_rec.line_adjusted;

10924: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10925: p_ae_sys_rec.base_currency);
10926: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
10927: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
10928: l_ra_ar_gt.tl_alloc_amt := p_adj_rec.line_adjusted;
10929: l_ra_ar_gt.tl_alloc_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10930: p_ae_sys_rec.base_currency);
10931: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
10932: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;

Line 10929: l_ra_ar_gt.tl_alloc_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,

10925: p_ae_sys_rec.base_currency);
10926: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
10927: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
10928: l_ra_ar_gt.tl_alloc_amt := p_adj_rec.line_adjusted;
10929: l_ra_ar_gt.tl_alloc_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10930: p_ae_sys_rec.base_currency);
10931: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
10932: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
10933: l_ra_ar_gt.tl_frt_alloc_amt := 0;

Line 10931: l_ra_ar_gt.tl_chrg_alloc_amt := 0;

10927: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
10928: l_ra_ar_gt.tl_alloc_amt := p_adj_rec.line_adjusted;
10929: l_ra_ar_gt.tl_alloc_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10930: p_ae_sys_rec.base_currency);
10931: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
10932: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
10933: l_ra_ar_gt.tl_frt_alloc_amt := 0;
10934: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
10935: l_ra_ar_gt.tl_tax_alloc_amt := 0;

Line 10932: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;

10928: l_ra_ar_gt.tl_alloc_amt := p_adj_rec.line_adjusted;
10929: l_ra_ar_gt.tl_alloc_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10930: p_ae_sys_rec.base_currency);
10931: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
10932: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
10933: l_ra_ar_gt.tl_frt_alloc_amt := 0;
10934: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
10935: l_ra_ar_gt.tl_tax_alloc_amt := 0;
10936: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;

Line 10933: l_ra_ar_gt.tl_frt_alloc_amt := 0;

10929: l_ra_ar_gt.tl_alloc_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10930: p_ae_sys_rec.base_currency);
10931: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
10932: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
10933: l_ra_ar_gt.tl_frt_alloc_amt := 0;
10934: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
10935: l_ra_ar_gt.tl_tax_alloc_amt := 0;
10936: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
10937: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.line_adjusted;

Line 10934: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;

10930: p_ae_sys_rec.base_currency);
10931: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
10932: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
10933: l_ra_ar_gt.tl_frt_alloc_amt := 0;
10934: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
10935: l_ra_ar_gt.tl_tax_alloc_amt := 0;
10936: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
10937: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.line_adjusted;
10938: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,

Line 10935: l_ra_ar_gt.tl_tax_alloc_amt := 0;

10931: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
10932: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
10933: l_ra_ar_gt.tl_frt_alloc_amt := 0;
10934: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
10935: l_ra_ar_gt.tl_tax_alloc_amt := 0;
10936: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
10937: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.line_adjusted;
10938: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10939: p_ae_sys_rec.base_currency);

Line 10936: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;

10932: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
10933: l_ra_ar_gt.tl_frt_alloc_amt := 0;
10934: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
10935: l_ra_ar_gt.tl_tax_alloc_amt := 0;
10936: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
10937: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.line_adjusted;
10938: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10939: p_ae_sys_rec.base_currency);
10940: l_ra_ar_gt.source_type := 'LINE';

Line 10940: l_ra_ar_gt.source_type := 'LINE';

10936: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
10937: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.line_adjusted;
10938: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10939: p_ae_sys_rec.base_currency);
10940: l_ra_ar_gt.source_type := 'LINE';
10941: l_ra_ar_gt.source_table := 'ADJ';
10942: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
10943: l_ra_ar_gt.gp_level := 'D';
10944: l_ra_ar_gt.group_id := '00';

Line 10941: l_ra_ar_gt.source_table := 'ADJ';

10937: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.line_adjusted;
10938: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10939: p_ae_sys_rec.base_currency);
10940: l_ra_ar_gt.source_type := 'LINE';
10941: l_ra_ar_gt.source_table := 'ADJ';
10942: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
10943: l_ra_ar_gt.gp_level := 'D';
10944: l_ra_ar_gt.group_id := '00';
10945: --{HYUBPAGP

Line 10942: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;

10938: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.line_adjusted * P_exchange_rate,
10939: p_ae_sys_rec.base_currency);
10940: l_ra_ar_gt.source_type := 'LINE';
10941: l_ra_ar_gt.source_table := 'ADJ';
10942: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
10943: l_ra_ar_gt.gp_level := 'D';
10944: l_ra_ar_gt.group_id := '00';
10945: --{HYUBPAGP
10946: l_ra_ar_gt.source_data_key1 := '00';

Line 10943: l_ra_ar_gt.gp_level := 'D';

10939: p_ae_sys_rec.base_currency);
10940: l_ra_ar_gt.source_type := 'LINE';
10941: l_ra_ar_gt.source_table := 'ADJ';
10942: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
10943: l_ra_ar_gt.gp_level := 'D';
10944: l_ra_ar_gt.group_id := '00';
10945: --{HYUBPAGP
10946: l_ra_ar_gt.source_data_key1 := '00';
10947: l_ra_ar_gt.source_data_key2 := '00';

Line 10944: l_ra_ar_gt.group_id := '00';

10940: l_ra_ar_gt.source_type := 'LINE';
10941: l_ra_ar_gt.source_table := 'ADJ';
10942: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
10943: l_ra_ar_gt.gp_level := 'D';
10944: l_ra_ar_gt.group_id := '00';
10945: --{HYUBPAGP
10946: l_ra_ar_gt.source_data_key1 := '00';
10947: l_ra_ar_gt.source_data_key2 := '00';
10948: l_ra_ar_gt.source_data_key3 := '00';

Line 10946: l_ra_ar_gt.source_data_key1 := '00';

10942: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
10943: l_ra_ar_gt.gp_level := 'D';
10944: l_ra_ar_gt.group_id := '00';
10945: --{HYUBPAGP
10946: l_ra_ar_gt.source_data_key1 := '00';
10947: l_ra_ar_gt.source_data_key2 := '00';
10948: l_ra_ar_gt.source_data_key3 := '00';
10949: l_ra_ar_gt.source_data_key4 := '00';
10950: l_ra_ar_gt.source_data_key5 := '00';

Line 10947: l_ra_ar_gt.source_data_key2 := '00';

10943: l_ra_ar_gt.gp_level := 'D';
10944: l_ra_ar_gt.group_id := '00';
10945: --{HYUBPAGP
10946: l_ra_ar_gt.source_data_key1 := '00';
10947: l_ra_ar_gt.source_data_key2 := '00';
10948: l_ra_ar_gt.source_data_key3 := '00';
10949: l_ra_ar_gt.source_data_key4 := '00';
10950: l_ra_ar_gt.source_data_key5 := '00';
10951: --}

Line 10948: l_ra_ar_gt.source_data_key3 := '00';

10944: l_ra_ar_gt.group_id := '00';
10945: --{HYUBPAGP
10946: l_ra_ar_gt.source_data_key1 := '00';
10947: l_ra_ar_gt.source_data_key2 := '00';
10948: l_ra_ar_gt.source_data_key3 := '00';
10949: l_ra_ar_gt.source_data_key4 := '00';
10950: l_ra_ar_gt.source_data_key5 := '00';
10951: --}
10952: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;

Line 10949: l_ra_ar_gt.source_data_key4 := '00';

10945: --{HYUBPAGP
10946: l_ra_ar_gt.source_data_key1 := '00';
10947: l_ra_ar_gt.source_data_key2 := '00';
10948: l_ra_ar_gt.source_data_key3 := '00';
10949: l_ra_ar_gt.source_data_key4 := '00';
10950: l_ra_ar_gt.source_data_key5 := '00';
10951: --}
10952: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
10953: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;

Line 10950: l_ra_ar_gt.source_data_key5 := '00';

10946: l_ra_ar_gt.source_data_key1 := '00';
10947: l_ra_ar_gt.source_data_key2 := '00';
10948: l_ra_ar_gt.source_data_key3 := '00';
10949: l_ra_ar_gt.source_data_key4 := '00';
10950: l_ra_ar_gt.source_data_key5 := '00';
10951: --}
10952: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
10953: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
10954: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;

Line 10952: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;

10948: l_ra_ar_gt.source_data_key3 := '00';
10949: l_ra_ar_gt.source_data_key4 := '00';
10950: l_ra_ar_gt.source_data_key5 := '00';
10951: --}
10952: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
10953: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
10954: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
10955: l_ra_ar_gt.activity_bucket := 'ADJ';
10956: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,

Line 10953: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;

10949: l_ra_ar_gt.source_data_key4 := '00';
10950: l_ra_ar_gt.source_data_key5 := '00';
10951: --}
10952: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
10953: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
10954: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
10955: l_ra_ar_gt.activity_bucket := 'ADJ';
10956: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
10957: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,

Line 10954: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;

10950: l_ra_ar_gt.source_data_key5 := '00';
10951: --}
10952: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
10953: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
10954: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
10955: l_ra_ar_gt.activity_bucket := 'ADJ';
10956: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
10957: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
10958: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt

Line 10955: l_ra_ar_gt.activity_bucket := 'ADJ';

10951: --}
10952: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
10953: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
10954: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
10955: l_ra_ar_gt.activity_bucket := 'ADJ';
10956: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
10957: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
10958: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
10959: );

Line 10956: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,

10952: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
10953: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
10954: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
10955: l_ra_ar_gt.activity_bucket := 'ADJ';
10956: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
10957: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
10958: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
10959: );
10960: END IF;

Line 10970: l_ra_ar_gt.GT_ID := p_gt_id;

10966: THEN
10967: IF PG_DEBUG = 'Y' THEN
10968: localdebug(' -7 Adjustment Boundary CHARGES condition met');
10969: END IF;
10970: l_ra_ar_gt.GT_ID := p_gt_id;
10971: l_ra_ar_gt.AMT := p_adj_rec.receivables_charges_adjusted;
10972: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10973: p_ae_sys_rec.base_currency);
10974: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';

Line 10971: l_ra_ar_gt.AMT := p_adj_rec.receivables_charges_adjusted;

10967: IF PG_DEBUG = 'Y' THEN
10968: localdebug(' -7 Adjustment Boundary CHARGES condition met');
10969: END IF;
10970: l_ra_ar_gt.GT_ID := p_gt_id;
10971: l_ra_ar_gt.AMT := p_adj_rec.receivables_charges_adjusted;
10972: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10973: p_ae_sys_rec.base_currency);
10974: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
10975: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid

Line 10972: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,

10968: localdebug(' -7 Adjustment Boundary CHARGES condition met');
10969: END IF;
10970: l_ra_ar_gt.GT_ID := p_gt_id;
10971: l_ra_ar_gt.AMT := p_adj_rec.receivables_charges_adjusted;
10972: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10973: p_ae_sys_rec.base_currency);
10974: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
10975: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
10976: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -7;

Line 10974: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';

10970: l_ra_ar_gt.GT_ID := p_gt_id;
10971: l_ra_ar_gt.AMT := p_adj_rec.receivables_charges_adjusted;
10972: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10973: p_ae_sys_rec.base_currency);
10974: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
10975: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
10976: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -7;
10977: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -7;
10978: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;

Line 10975: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid

10971: l_ra_ar_gt.AMT := p_adj_rec.receivables_charges_adjusted;
10972: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10973: p_ae_sys_rec.base_currency);
10974: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
10975: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
10976: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -7;
10977: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -7;
10978: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
10979: l_ra_ar_gt.DIST_AMT := p_adj_rec.receivables_charges_adjusted;

Line 10976: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -7;

10972: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10973: p_ae_sys_rec.base_currency);
10974: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
10975: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
10976: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -7;
10977: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -7;
10978: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
10979: l_ra_ar_gt.DIST_AMT := p_adj_rec.receivables_charges_adjusted;
10980: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,

Line 10977: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -7;

10973: p_ae_sys_rec.base_currency);
10974: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
10975: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
10976: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -7;
10977: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -7;
10978: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
10979: l_ra_ar_gt.DIST_AMT := p_adj_rec.receivables_charges_adjusted;
10980: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10981: p_ae_sys_rec.base_currency);

Line 10978: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;

10974: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
10975: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
10976: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -7;
10977: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -7;
10978: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
10979: l_ra_ar_gt.DIST_AMT := p_adj_rec.receivables_charges_adjusted;
10980: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10981: p_ae_sys_rec.base_currency);
10982: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;

Line 10979: l_ra_ar_gt.DIST_AMT := p_adj_rec.receivables_charges_adjusted;

10975: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
10976: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -7;
10977: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -7;
10978: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
10979: l_ra_ar_gt.DIST_AMT := p_adj_rec.receivables_charges_adjusted;
10980: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10981: p_ae_sys_rec.base_currency);
10982: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
10983: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;

Line 10980: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,

10976: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -7;
10977: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -7;
10978: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
10979: l_ra_ar_gt.DIST_AMT := p_adj_rec.receivables_charges_adjusted;
10980: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10981: p_ae_sys_rec.base_currency);
10982: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
10983: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
10984: l_ra_ar_gt.tl_alloc_amt := 0;

Line 10982: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;

10978: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
10979: l_ra_ar_gt.DIST_AMT := p_adj_rec.receivables_charges_adjusted;
10980: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10981: p_ae_sys_rec.base_currency);
10982: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
10983: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
10984: l_ra_ar_gt.tl_alloc_amt := 0;
10985: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
10986: l_ra_ar_gt.tl_chrg_alloc_amt := p_adj_rec.receivables_charges_adjusted;

Line 10983: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;

10979: l_ra_ar_gt.DIST_AMT := p_adj_rec.receivables_charges_adjusted;
10980: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10981: p_ae_sys_rec.base_currency);
10982: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
10983: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
10984: l_ra_ar_gt.tl_alloc_amt := 0;
10985: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
10986: l_ra_ar_gt.tl_chrg_alloc_amt := p_adj_rec.receivables_charges_adjusted;
10987: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,

Line 10984: l_ra_ar_gt.tl_alloc_amt := 0;

10980: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10981: p_ae_sys_rec.base_currency);
10982: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
10983: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
10984: l_ra_ar_gt.tl_alloc_amt := 0;
10985: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
10986: l_ra_ar_gt.tl_chrg_alloc_amt := p_adj_rec.receivables_charges_adjusted;
10987: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10988: p_ae_sys_rec.base_currency);

Line 10985: l_ra_ar_gt.tl_alloc_acctd_amt := 0;

10981: p_ae_sys_rec.base_currency);
10982: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
10983: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
10984: l_ra_ar_gt.tl_alloc_amt := 0;
10985: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
10986: l_ra_ar_gt.tl_chrg_alloc_amt := p_adj_rec.receivables_charges_adjusted;
10987: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10988: p_ae_sys_rec.base_currency);
10989: l_ra_ar_gt.tl_frt_alloc_amt := 0;

Line 10986: l_ra_ar_gt.tl_chrg_alloc_amt := p_adj_rec.receivables_charges_adjusted;

10982: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
10983: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
10984: l_ra_ar_gt.tl_alloc_amt := 0;
10985: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
10986: l_ra_ar_gt.tl_chrg_alloc_amt := p_adj_rec.receivables_charges_adjusted;
10987: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10988: p_ae_sys_rec.base_currency);
10989: l_ra_ar_gt.tl_frt_alloc_amt := 0;
10990: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;

Line 10987: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,

10983: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
10984: l_ra_ar_gt.tl_alloc_amt := 0;
10985: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
10986: l_ra_ar_gt.tl_chrg_alloc_amt := p_adj_rec.receivables_charges_adjusted;
10987: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10988: p_ae_sys_rec.base_currency);
10989: l_ra_ar_gt.tl_frt_alloc_amt := 0;
10990: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
10991: l_ra_ar_gt.tl_tax_alloc_amt := 0;

Line 10989: l_ra_ar_gt.tl_frt_alloc_amt := 0;

10985: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
10986: l_ra_ar_gt.tl_chrg_alloc_amt := p_adj_rec.receivables_charges_adjusted;
10987: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10988: p_ae_sys_rec.base_currency);
10989: l_ra_ar_gt.tl_frt_alloc_amt := 0;
10990: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
10991: l_ra_ar_gt.tl_tax_alloc_amt := 0;
10992: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
10993: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.receivables_charges_adjusted;

Line 10990: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;

10986: l_ra_ar_gt.tl_chrg_alloc_amt := p_adj_rec.receivables_charges_adjusted;
10987: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10988: p_ae_sys_rec.base_currency);
10989: l_ra_ar_gt.tl_frt_alloc_amt := 0;
10990: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
10991: l_ra_ar_gt.tl_tax_alloc_amt := 0;
10992: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
10993: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.receivables_charges_adjusted;
10994: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,

Line 10991: l_ra_ar_gt.tl_tax_alloc_amt := 0;

10987: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10988: p_ae_sys_rec.base_currency);
10989: l_ra_ar_gt.tl_frt_alloc_amt := 0;
10990: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
10991: l_ra_ar_gt.tl_tax_alloc_amt := 0;
10992: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
10993: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.receivables_charges_adjusted;
10994: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10995: p_ae_sys_rec.base_currency);

Line 10992: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;

10988: p_ae_sys_rec.base_currency);
10989: l_ra_ar_gt.tl_frt_alloc_amt := 0;
10990: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
10991: l_ra_ar_gt.tl_tax_alloc_amt := 0;
10992: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
10993: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.receivables_charges_adjusted;
10994: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10995: p_ae_sys_rec.base_currency);
10996: l_ra_ar_gt.source_type := 'CHARGES';

Line 10996: l_ra_ar_gt.source_type := 'CHARGES';

10992: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
10993: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.receivables_charges_adjusted;
10994: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10995: p_ae_sys_rec.base_currency);
10996: l_ra_ar_gt.source_type := 'CHARGES';
10997: l_ra_ar_gt.source_table := 'ADJ';
10998: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
10999: l_ra_ar_gt.gp_level := 'D';
11000: l_ra_ar_gt.group_id := '00';

Line 10997: l_ra_ar_gt.source_table := 'ADJ';

10993: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.receivables_charges_adjusted;
10994: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10995: p_ae_sys_rec.base_currency);
10996: l_ra_ar_gt.source_type := 'CHARGES';
10997: l_ra_ar_gt.source_table := 'ADJ';
10998: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
10999: l_ra_ar_gt.gp_level := 'D';
11000: l_ra_ar_gt.group_id := '00';
11001: --{HYUBPAGP

Line 10998: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;

10994: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.receivables_charges_adjusted * P_exchange_rate,
10995: p_ae_sys_rec.base_currency);
10996: l_ra_ar_gt.source_type := 'CHARGES';
10997: l_ra_ar_gt.source_table := 'ADJ';
10998: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
10999: l_ra_ar_gt.gp_level := 'D';
11000: l_ra_ar_gt.group_id := '00';
11001: --{HYUBPAGP
11002: l_ra_ar_gt.source_data_key1 := '00';

Line 10999: l_ra_ar_gt.gp_level := 'D';

10995: p_ae_sys_rec.base_currency);
10996: l_ra_ar_gt.source_type := 'CHARGES';
10997: l_ra_ar_gt.source_table := 'ADJ';
10998: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
10999: l_ra_ar_gt.gp_level := 'D';
11000: l_ra_ar_gt.group_id := '00';
11001: --{HYUBPAGP
11002: l_ra_ar_gt.source_data_key1 := '00';
11003: l_ra_ar_gt.source_data_key2 := '00';

Line 11000: l_ra_ar_gt.group_id := '00';

10996: l_ra_ar_gt.source_type := 'CHARGES';
10997: l_ra_ar_gt.source_table := 'ADJ';
10998: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
10999: l_ra_ar_gt.gp_level := 'D';
11000: l_ra_ar_gt.group_id := '00';
11001: --{HYUBPAGP
11002: l_ra_ar_gt.source_data_key1 := '00';
11003: l_ra_ar_gt.source_data_key2 := '00';
11004: l_ra_ar_gt.source_data_key3 := '00';

Line 11002: l_ra_ar_gt.source_data_key1 := '00';

10998: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
10999: l_ra_ar_gt.gp_level := 'D';
11000: l_ra_ar_gt.group_id := '00';
11001: --{HYUBPAGP
11002: l_ra_ar_gt.source_data_key1 := '00';
11003: l_ra_ar_gt.source_data_key2 := '00';
11004: l_ra_ar_gt.source_data_key3 := '00';
11005: l_ra_ar_gt.source_data_key4 := '00';
11006: l_ra_ar_gt.source_data_key5 := '00';

Line 11003: l_ra_ar_gt.source_data_key2 := '00';

10999: l_ra_ar_gt.gp_level := 'D';
11000: l_ra_ar_gt.group_id := '00';
11001: --{HYUBPAGP
11002: l_ra_ar_gt.source_data_key1 := '00';
11003: l_ra_ar_gt.source_data_key2 := '00';
11004: l_ra_ar_gt.source_data_key3 := '00';
11005: l_ra_ar_gt.source_data_key4 := '00';
11006: l_ra_ar_gt.source_data_key5 := '00';
11007: --}

Line 11004: l_ra_ar_gt.source_data_key3 := '00';

11000: l_ra_ar_gt.group_id := '00';
11001: --{HYUBPAGP
11002: l_ra_ar_gt.source_data_key1 := '00';
11003: l_ra_ar_gt.source_data_key2 := '00';
11004: l_ra_ar_gt.source_data_key3 := '00';
11005: l_ra_ar_gt.source_data_key4 := '00';
11006: l_ra_ar_gt.source_data_key5 := '00';
11007: --}
11008: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;

Line 11005: l_ra_ar_gt.source_data_key4 := '00';

11001: --{HYUBPAGP
11002: l_ra_ar_gt.source_data_key1 := '00';
11003: l_ra_ar_gt.source_data_key2 := '00';
11004: l_ra_ar_gt.source_data_key3 := '00';
11005: l_ra_ar_gt.source_data_key4 := '00';
11006: l_ra_ar_gt.source_data_key5 := '00';
11007: --}
11008: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11009: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;

Line 11006: l_ra_ar_gt.source_data_key5 := '00';

11002: l_ra_ar_gt.source_data_key1 := '00';
11003: l_ra_ar_gt.source_data_key2 := '00';
11004: l_ra_ar_gt.source_data_key3 := '00';
11005: l_ra_ar_gt.source_data_key4 := '00';
11006: l_ra_ar_gt.source_data_key5 := '00';
11007: --}
11008: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11009: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
11010: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;

Line 11008: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;

11004: l_ra_ar_gt.source_data_key3 := '00';
11005: l_ra_ar_gt.source_data_key4 := '00';
11006: l_ra_ar_gt.source_data_key5 := '00';
11007: --}
11008: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11009: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
11010: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
11011: l_ra_ar_gt.activity_bucket := 'ADJ';
11012: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,

Line 11009: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;

11005: l_ra_ar_gt.source_data_key4 := '00';
11006: l_ra_ar_gt.source_data_key5 := '00';
11007: --}
11008: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11009: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
11010: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
11011: l_ra_ar_gt.activity_bucket := 'ADJ';
11012: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
11013: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,

Line 11010: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;

11006: l_ra_ar_gt.source_data_key5 := '00';
11007: --}
11008: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11009: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
11010: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
11011: l_ra_ar_gt.activity_bucket := 'ADJ';
11012: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
11013: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
11014: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt

Line 11011: l_ra_ar_gt.activity_bucket := 'ADJ';

11007: --}
11008: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11009: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
11010: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
11011: l_ra_ar_gt.activity_bucket := 'ADJ';
11012: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
11013: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
11014: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
11015: );

Line 11012: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,

11008: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11009: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
11010: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
11011: l_ra_ar_gt.activity_bucket := 'ADJ';
11012: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
11013: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
11014: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
11015: );
11016: END IF;

Line 11026: l_ra_ar_gt.GT_ID := p_gt_id;

11022: THEN
11023: IF PG_DEBUG = 'Y' THEN
11024: localdebug(' -9 Adjustment Boundary FREIGHT condition met');
11025: END IF;
11026: l_ra_ar_gt.GT_ID := p_gt_id;
11027: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
11028: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
11029: p_ae_sys_rec.base_currency);
11030: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';

Line 11027: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;

11023: IF PG_DEBUG = 'Y' THEN
11024: localdebug(' -9 Adjustment Boundary FREIGHT condition met');
11025: END IF;
11026: l_ra_ar_gt.GT_ID := p_gt_id;
11027: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
11028: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
11029: p_ae_sys_rec.base_currency);
11030: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
11031: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid

Line 11028: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,

11024: localdebug(' -9 Adjustment Boundary FREIGHT condition met');
11025: END IF;
11026: l_ra_ar_gt.GT_ID := p_gt_id;
11027: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
11028: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
11029: p_ae_sys_rec.base_currency);
11030: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
11031: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11032: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;

Line 11030: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';

11026: l_ra_ar_gt.GT_ID := p_gt_id;
11027: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
11028: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
11029: p_ae_sys_rec.base_currency);
11030: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
11031: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11032: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
11033: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
11034: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;

Line 11031: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid

11027: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
11028: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
11029: p_ae_sys_rec.base_currency);
11030: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
11031: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11032: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
11033: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
11034: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11035: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;

Line 11032: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;

11028: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
11029: p_ae_sys_rec.base_currency);
11030: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
11031: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11032: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
11033: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
11034: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11035: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
11036: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,

Line 11033: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;

11029: p_ae_sys_rec.base_currency);
11030: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
11031: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11032: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
11033: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
11034: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11035: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
11036: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11037: p_ae_sys_rec.base_currency);

Line 11034: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;

11030: l_ra_ar_gt.ACCOUNT_CLASS := 'REV';
11031: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11032: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
11033: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
11034: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11035: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
11036: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11037: p_ae_sys_rec.base_currency);
11038: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;

Line 11035: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;

11031: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11032: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
11033: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
11034: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11035: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
11036: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11037: p_ae_sys_rec.base_currency);
11038: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11039: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;

Line 11036: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,

11032: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
11033: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
11034: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11035: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
11036: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11037: p_ae_sys_rec.base_currency);
11038: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11039: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11040: l_ra_ar_gt.tl_chrg_alloc_amt := 0;

Line 11038: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;

11034: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11035: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
11036: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11037: p_ae_sys_rec.base_currency);
11038: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11039: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11040: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11041: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11042: l_ra_ar_gt.tl_tax_alloc_amt := 0;

Line 11039: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;

11035: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
11036: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11037: p_ae_sys_rec.base_currency);
11038: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11039: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11040: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11041: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11042: l_ra_ar_gt.tl_tax_alloc_amt := 0;
11043: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;

Line 11040: l_ra_ar_gt.tl_chrg_alloc_amt := 0;

11036: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11037: p_ae_sys_rec.base_currency);
11038: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11039: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11040: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11041: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11042: l_ra_ar_gt.tl_tax_alloc_amt := 0;
11043: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
11044: l_ra_ar_gt.tl_alloc_amt := 0;

Line 11041: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;

11037: p_ae_sys_rec.base_currency);
11038: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11039: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11040: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11041: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11042: l_ra_ar_gt.tl_tax_alloc_amt := 0;
11043: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
11044: l_ra_ar_gt.tl_alloc_amt := 0;
11045: l_ra_ar_gt.tl_alloc_acctd_amt := 0;

Line 11042: l_ra_ar_gt.tl_tax_alloc_amt := 0;

11038: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11039: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11040: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11041: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11042: l_ra_ar_gt.tl_tax_alloc_amt := 0;
11043: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
11044: l_ra_ar_gt.tl_alloc_amt := 0;
11045: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11046: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;

Line 11043: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;

11039: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11040: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11041: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11042: l_ra_ar_gt.tl_tax_alloc_amt := 0;
11043: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
11044: l_ra_ar_gt.tl_alloc_amt := 0;
11045: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11046: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
11047: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,

Line 11044: l_ra_ar_gt.tl_alloc_amt := 0;

11040: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11041: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11042: l_ra_ar_gt.tl_tax_alloc_amt := 0;
11043: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
11044: l_ra_ar_gt.tl_alloc_amt := 0;
11045: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11046: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
11047: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
11048: p_ae_sys_rec.base_currency);

Line 11045: l_ra_ar_gt.tl_alloc_acctd_amt := 0;

11041: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11042: l_ra_ar_gt.tl_tax_alloc_amt := 0;
11043: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
11044: l_ra_ar_gt.tl_alloc_amt := 0;
11045: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11046: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
11047: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
11048: p_ae_sys_rec.base_currency);
11049: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.freight_adjusted;

Line 11046: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;

11042: l_ra_ar_gt.tl_tax_alloc_amt := 0;
11043: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
11044: l_ra_ar_gt.tl_alloc_amt := 0;
11045: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11046: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
11047: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
11048: p_ae_sys_rec.base_currency);
11049: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.freight_adjusted;
11050: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,

Line 11047: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,

11043: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
11044: l_ra_ar_gt.tl_alloc_amt := 0;
11045: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11046: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
11047: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
11048: p_ae_sys_rec.base_currency);
11049: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.freight_adjusted;
11050: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
11051: p_ae_sys_rec.base_currency);

Line 11052: l_ra_ar_gt.source_type := 'FREIGHT';

11048: p_ae_sys_rec.base_currency);
11049: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.freight_adjusted;
11050: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
11051: p_ae_sys_rec.base_currency);
11052: l_ra_ar_gt.source_type := 'FREIGHT';
11053: l_ra_ar_gt.source_table := 'ADJ';
11054: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11055: l_ra_ar_gt.gp_level := 'D';
11056: l_ra_ar_gt.group_id := '00';

Line 11053: l_ra_ar_gt.source_table := 'ADJ';

11049: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.freight_adjusted;
11050: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
11051: p_ae_sys_rec.base_currency);
11052: l_ra_ar_gt.source_type := 'FREIGHT';
11053: l_ra_ar_gt.source_table := 'ADJ';
11054: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11055: l_ra_ar_gt.gp_level := 'D';
11056: l_ra_ar_gt.group_id := '00';
11057: --{HYUBPAGP

Line 11054: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;

11050: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted * P_exchange_rate,
11051: p_ae_sys_rec.base_currency);
11052: l_ra_ar_gt.source_type := 'FREIGHT';
11053: l_ra_ar_gt.source_table := 'ADJ';
11054: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11055: l_ra_ar_gt.gp_level := 'D';
11056: l_ra_ar_gt.group_id := '00';
11057: --{HYUBPAGP
11058: l_ra_ar_gt.source_data_key1 := '00';

Line 11055: l_ra_ar_gt.gp_level := 'D';

11051: p_ae_sys_rec.base_currency);
11052: l_ra_ar_gt.source_type := 'FREIGHT';
11053: l_ra_ar_gt.source_table := 'ADJ';
11054: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11055: l_ra_ar_gt.gp_level := 'D';
11056: l_ra_ar_gt.group_id := '00';
11057: --{HYUBPAGP
11058: l_ra_ar_gt.source_data_key1 := '00';
11059: l_ra_ar_gt.source_data_key2 := '00';

Line 11056: l_ra_ar_gt.group_id := '00';

11052: l_ra_ar_gt.source_type := 'FREIGHT';
11053: l_ra_ar_gt.source_table := 'ADJ';
11054: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11055: l_ra_ar_gt.gp_level := 'D';
11056: l_ra_ar_gt.group_id := '00';
11057: --{HYUBPAGP
11058: l_ra_ar_gt.source_data_key1 := '00';
11059: l_ra_ar_gt.source_data_key2 := '00';
11060: l_ra_ar_gt.source_data_key3 := '00';

Line 11058: l_ra_ar_gt.source_data_key1 := '00';

11054: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11055: l_ra_ar_gt.gp_level := 'D';
11056: l_ra_ar_gt.group_id := '00';
11057: --{HYUBPAGP
11058: l_ra_ar_gt.source_data_key1 := '00';
11059: l_ra_ar_gt.source_data_key2 := '00';
11060: l_ra_ar_gt.source_data_key3 := '00';
11061: l_ra_ar_gt.source_data_key4 := '00';
11062: l_ra_ar_gt.source_data_key5 := '00';

Line 11059: l_ra_ar_gt.source_data_key2 := '00';

11055: l_ra_ar_gt.gp_level := 'D';
11056: l_ra_ar_gt.group_id := '00';
11057: --{HYUBPAGP
11058: l_ra_ar_gt.source_data_key1 := '00';
11059: l_ra_ar_gt.source_data_key2 := '00';
11060: l_ra_ar_gt.source_data_key3 := '00';
11061: l_ra_ar_gt.source_data_key4 := '00';
11062: l_ra_ar_gt.source_data_key5 := '00';
11063: --}

Line 11060: l_ra_ar_gt.source_data_key3 := '00';

11056: l_ra_ar_gt.group_id := '00';
11057: --{HYUBPAGP
11058: l_ra_ar_gt.source_data_key1 := '00';
11059: l_ra_ar_gt.source_data_key2 := '00';
11060: l_ra_ar_gt.source_data_key3 := '00';
11061: l_ra_ar_gt.source_data_key4 := '00';
11062: l_ra_ar_gt.source_data_key5 := '00';
11063: --}
11064: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;

Line 11061: l_ra_ar_gt.source_data_key4 := '00';

11057: --{HYUBPAGP
11058: l_ra_ar_gt.source_data_key1 := '00';
11059: l_ra_ar_gt.source_data_key2 := '00';
11060: l_ra_ar_gt.source_data_key3 := '00';
11061: l_ra_ar_gt.source_data_key4 := '00';
11062: l_ra_ar_gt.source_data_key5 := '00';
11063: --}
11064: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11065: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;

Line 11062: l_ra_ar_gt.source_data_key5 := '00';

11058: l_ra_ar_gt.source_data_key1 := '00';
11059: l_ra_ar_gt.source_data_key2 := '00';
11060: l_ra_ar_gt.source_data_key3 := '00';
11061: l_ra_ar_gt.source_data_key4 := '00';
11062: l_ra_ar_gt.source_data_key5 := '00';
11063: --}
11064: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11065: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
11066: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;

Line 11064: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;

11060: l_ra_ar_gt.source_data_key3 := '00';
11061: l_ra_ar_gt.source_data_key4 := '00';
11062: l_ra_ar_gt.source_data_key5 := '00';
11063: --}
11064: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11065: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
11066: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
11067: l_ra_ar_gt.activity_bucket := 'ADJ';
11068: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,

Line 11065: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;

11061: l_ra_ar_gt.source_data_key4 := '00';
11062: l_ra_ar_gt.source_data_key5 := '00';
11063: --}
11064: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11065: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
11066: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
11067: l_ra_ar_gt.activity_bucket := 'ADJ';
11068: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
11069: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,

Line 11066: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;

11062: l_ra_ar_gt.source_data_key5 := '00';
11063: --}
11064: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11065: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
11066: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
11067: l_ra_ar_gt.activity_bucket := 'ADJ';
11068: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
11069: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
11070: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt

Line 11067: l_ra_ar_gt.activity_bucket := 'ADJ';

11063: --}
11064: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11065: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
11066: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
11067: l_ra_ar_gt.activity_bucket := 'ADJ';
11068: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
11069: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
11070: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
11071: );

Line 11068: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,

11064: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11065: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
11066: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
11067: l_ra_ar_gt.activity_bucket := 'ADJ';
11068: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
11069: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
11070: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
11071: );
11072: END IF;

Line 11085: l_ra_ar_gt ra_ar_gt%ROWTYPE;

11081: p_gt_id IN VARCHAR2,
11082: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
11083: P_exchange_rate IN ra_customer_trx.exchange_rate%type)
11084: IS
11085: l_ra_ar_gt ra_ar_gt%ROWTYPE;
11086: l_ar_base_dist_amts_gt ar_base_dist_amts_gt%ROWTYPE;
11087: l_ra_ar_amounts_gt ra_ar_amounts_gt%ROWTYPE;
11088: BEGIN
11089: IF NVL(p_adj_rec.tax_adjusted,0) <> 0 AND

Line 11096: l_ra_ar_gt.GT_ID := p_gt_id;

11092: THEN
11093: IF PG_DEBUG = 'Y' THEN
11094: localdebug(' -8 Adjustment Boundary TAX condition met');
11095: END IF;
11096: l_ra_ar_gt.GT_ID := p_gt_id;
11097: l_ra_ar_gt.AMT := p_adj_rec.tax_adjusted;
11098:
11099: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11100: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,

Line 11097: l_ra_ar_gt.AMT := p_adj_rec.tax_adjusted;

11093: IF PG_DEBUG = 'Y' THEN
11094: localdebug(' -8 Adjustment Boundary TAX condition met');
11095: END IF;
11096: l_ra_ar_gt.GT_ID := p_gt_id;
11097: l_ra_ar_gt.AMT := p_adj_rec.tax_adjusted;
11098:
11099: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11100: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11101: p_ae_sys_rec.base_currency);*/

Line 11100: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,

11096: l_ra_ar_gt.GT_ID := p_gt_id;
11097: l_ra_ar_gt.AMT := p_adj_rec.tax_adjusted;
11098:
11099: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11100: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11101: p_ae_sys_rec.base_currency);*/
11102:
11103: l_ra_ar_gt.ACCTD_AMT := p_adj_rec.acctd_amount ;
11104: l_ra_ar_gt.ACCOUNT_CLASS := 'TAX';

Line 11103: l_ra_ar_gt.ACCTD_AMT := p_adj_rec.acctd_amount ;

11099: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11100: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11101: p_ae_sys_rec.base_currency);*/
11102:
11103: l_ra_ar_gt.ACCTD_AMT := p_adj_rec.acctd_amount ;
11104: l_ra_ar_gt.ACCOUNT_CLASS := 'TAX';
11105: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11106: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -8;
11107: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -8;

Line 11104: l_ra_ar_gt.ACCOUNT_CLASS := 'TAX';

11100: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11101: p_ae_sys_rec.base_currency);*/
11102:
11103: l_ra_ar_gt.ACCTD_AMT := p_adj_rec.acctd_amount ;
11104: l_ra_ar_gt.ACCOUNT_CLASS := 'TAX';
11105: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11106: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -8;
11107: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -8;
11108: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;

Line 11105: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid

11101: p_ae_sys_rec.base_currency);*/
11102:
11103: l_ra_ar_gt.ACCTD_AMT := p_adj_rec.acctd_amount ;
11104: l_ra_ar_gt.ACCOUNT_CLASS := 'TAX';
11105: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11106: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -8;
11107: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -8;
11108: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11109: l_ra_ar_gt.DIST_AMT := p_adj_rec.tax_adjusted;

Line 11106: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -8;

11102:
11103: l_ra_ar_gt.ACCTD_AMT := p_adj_rec.acctd_amount ;
11104: l_ra_ar_gt.ACCOUNT_CLASS := 'TAX';
11105: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11106: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -8;
11107: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -8;
11108: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11109: l_ra_ar_gt.DIST_AMT := p_adj_rec.tax_adjusted;
11110:

Line 11107: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -8;

11103: l_ra_ar_gt.ACCTD_AMT := p_adj_rec.acctd_amount ;
11104: l_ra_ar_gt.ACCOUNT_CLASS := 'TAX';
11105: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11106: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -8;
11107: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -8;
11108: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11109: l_ra_ar_gt.DIST_AMT := p_adj_rec.tax_adjusted;
11110:
11111: /* anjprasa: bug 13375280 - get accounted amount directly from adj record

Line 11108: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;

11104: l_ra_ar_gt.ACCOUNT_CLASS := 'TAX';
11105: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11106: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -8;
11107: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -8;
11108: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11109: l_ra_ar_gt.DIST_AMT := p_adj_rec.tax_adjusted;
11110:
11111: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11112: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,

Line 11109: l_ra_ar_gt.DIST_AMT := p_adj_rec.tax_adjusted;

11105: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11106: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -8;
11107: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -8;
11108: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11109: l_ra_ar_gt.DIST_AMT := p_adj_rec.tax_adjusted;
11110:
11111: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11112: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11113: p_ae_sys_rec.base_currency);*/

Line 11112: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,

11108: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11109: l_ra_ar_gt.DIST_AMT := p_adj_rec.tax_adjusted;
11110:
11111: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11112: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11113: p_ae_sys_rec.base_currency);*/
11114: l_ra_ar_gt.DIST_ACCTD_AMT := p_adj_rec.acctd_amount ;
11115: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11116: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;

Line 11114: l_ra_ar_gt.DIST_ACCTD_AMT := p_adj_rec.acctd_amount ;

11110:
11111: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11112: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11113: p_ae_sys_rec.base_currency);*/
11114: l_ra_ar_gt.DIST_ACCTD_AMT := p_adj_rec.acctd_amount ;
11115: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11116: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11117: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11118: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;

Line 11115: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;

11111: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11112: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11113: p_ae_sys_rec.base_currency);*/
11114: l_ra_ar_gt.DIST_ACCTD_AMT := p_adj_rec.acctd_amount ;
11115: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11116: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11117: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11118: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11119: l_ra_ar_gt.tl_frt_alloc_amt := 0;

Line 11116: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;

11112: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11113: p_ae_sys_rec.base_currency);*/
11114: l_ra_ar_gt.DIST_ACCTD_AMT := p_adj_rec.acctd_amount ;
11115: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11116: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11117: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11118: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11119: l_ra_ar_gt.tl_frt_alloc_amt := 0;
11120: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;

Line 11117: l_ra_ar_gt.tl_chrg_alloc_amt := 0;

11113: p_ae_sys_rec.base_currency);*/
11114: l_ra_ar_gt.DIST_ACCTD_AMT := p_adj_rec.acctd_amount ;
11115: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11116: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11117: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11118: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11119: l_ra_ar_gt.tl_frt_alloc_amt := 0;
11120: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
11121: l_ra_ar_gt.tl_alloc_amt := 0;

Line 11118: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;

11114: l_ra_ar_gt.DIST_ACCTD_AMT := p_adj_rec.acctd_amount ;
11115: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11116: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11117: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11118: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11119: l_ra_ar_gt.tl_frt_alloc_amt := 0;
11120: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
11121: l_ra_ar_gt.tl_alloc_amt := 0;
11122: l_ra_ar_gt.tl_alloc_acctd_amt := 0;

Line 11119: l_ra_ar_gt.tl_frt_alloc_amt := 0;

11115: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11116: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11117: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11118: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11119: l_ra_ar_gt.tl_frt_alloc_amt := 0;
11120: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
11121: l_ra_ar_gt.tl_alloc_amt := 0;
11122: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11123: l_ra_ar_gt.tl_tax_alloc_amt := p_adj_rec.tax_adjusted;

Line 11120: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;

11116: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11117: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11118: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11119: l_ra_ar_gt.tl_frt_alloc_amt := 0;
11120: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
11121: l_ra_ar_gt.tl_alloc_amt := 0;
11122: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11123: l_ra_ar_gt.tl_tax_alloc_amt := p_adj_rec.tax_adjusted;
11124:

Line 11121: l_ra_ar_gt.tl_alloc_amt := 0;

11117: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11118: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11119: l_ra_ar_gt.tl_frt_alloc_amt := 0;
11120: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
11121: l_ra_ar_gt.tl_alloc_amt := 0;
11122: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11123: l_ra_ar_gt.tl_tax_alloc_amt := p_adj_rec.tax_adjusted;
11124:
11125: /* anjprasa: bug 13375280 - get accounted amount directly from adj record

Line 11122: l_ra_ar_gt.tl_alloc_acctd_amt := 0;

11118: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11119: l_ra_ar_gt.tl_frt_alloc_amt := 0;
11120: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
11121: l_ra_ar_gt.tl_alloc_amt := 0;
11122: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11123: l_ra_ar_gt.tl_tax_alloc_amt := p_adj_rec.tax_adjusted;
11124:
11125: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11126: l_ra_ar_gt.tl_tax_alloc_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,

Line 11123: l_ra_ar_gt.tl_tax_alloc_amt := p_adj_rec.tax_adjusted;

11119: l_ra_ar_gt.tl_frt_alloc_amt := 0;
11120: l_ra_ar_gt.tl_frt_alloc_acctd_amt := 0;
11121: l_ra_ar_gt.tl_alloc_amt := 0;
11122: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11123: l_ra_ar_gt.tl_tax_alloc_amt := p_adj_rec.tax_adjusted;
11124:
11125: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11126: l_ra_ar_gt.tl_tax_alloc_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11127: p_ae_sys_rec.base_currency);*/

Line 11126: l_ra_ar_gt.tl_tax_alloc_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,

11122: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11123: l_ra_ar_gt.tl_tax_alloc_amt := p_adj_rec.tax_adjusted;
11124:
11125: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11126: l_ra_ar_gt.tl_tax_alloc_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11127: p_ae_sys_rec.base_currency);*/
11128: l_ra_ar_gt.tl_tax_alloc_acctd_amt := p_adj_rec.acctd_amount ;
11129: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.tax_adjusted;
11130:

Line 11128: l_ra_ar_gt.tl_tax_alloc_acctd_amt := p_adj_rec.acctd_amount ;

11124:
11125: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11126: l_ra_ar_gt.tl_tax_alloc_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11127: p_ae_sys_rec.base_currency);*/
11128: l_ra_ar_gt.tl_tax_alloc_acctd_amt := p_adj_rec.acctd_amount ;
11129: l_ar_base_dist_amts_gt.base_dist_amt := p_adj_rec.tax_adjusted;
11130:
11131: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11132: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,

Line 11135: l_ra_ar_gt.source_type := 'TAX';

11131: /* anjprasa: bug 13375280 - get accounted amount directly from adj record
11132: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11133: p_ae_sys_rec.base_currency);*/
11134: l_ar_base_dist_amts_gt.base_dist_acctd_amt := p_adj_rec.acctd_amount ;
11135: l_ra_ar_gt.source_type := 'TAX';
11136: l_ra_ar_gt.source_table := 'ADJ';
11137: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11138: l_ra_ar_gt.gp_level := 'D';
11139: l_ra_ar_gt.group_id := '00';

Line 11136: l_ra_ar_gt.source_table := 'ADJ';

11132: l_ar_base_dist_amts_gt.base_dist_acctd_amt := currRound(p_adj_rec.tax_adjusted * P_exchange_rate,
11133: p_ae_sys_rec.base_currency);*/
11134: l_ar_base_dist_amts_gt.base_dist_acctd_amt := p_adj_rec.acctd_amount ;
11135: l_ra_ar_gt.source_type := 'TAX';
11136: l_ra_ar_gt.source_table := 'ADJ';
11137: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11138: l_ra_ar_gt.gp_level := 'D';
11139: l_ra_ar_gt.group_id := '00';
11140: --{HYUBPAGP

Line 11137: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;

11133: p_ae_sys_rec.base_currency);*/
11134: l_ar_base_dist_amts_gt.base_dist_acctd_amt := p_adj_rec.acctd_amount ;
11135: l_ra_ar_gt.source_type := 'TAX';
11136: l_ra_ar_gt.source_table := 'ADJ';
11137: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11138: l_ra_ar_gt.gp_level := 'D';
11139: l_ra_ar_gt.group_id := '00';
11140: --{HYUBPAGP
11141: l_ra_ar_gt.source_data_key1 := '00';

Line 11138: l_ra_ar_gt.gp_level := 'D';

11134: l_ar_base_dist_amts_gt.base_dist_acctd_amt := p_adj_rec.acctd_amount ;
11135: l_ra_ar_gt.source_type := 'TAX';
11136: l_ra_ar_gt.source_table := 'ADJ';
11137: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11138: l_ra_ar_gt.gp_level := 'D';
11139: l_ra_ar_gt.group_id := '00';
11140: --{HYUBPAGP
11141: l_ra_ar_gt.source_data_key1 := '00';
11142: l_ra_ar_gt.source_data_key2 := '00';

Line 11139: l_ra_ar_gt.group_id := '00';

11135: l_ra_ar_gt.source_type := 'TAX';
11136: l_ra_ar_gt.source_table := 'ADJ';
11137: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11138: l_ra_ar_gt.gp_level := 'D';
11139: l_ra_ar_gt.group_id := '00';
11140: --{HYUBPAGP
11141: l_ra_ar_gt.source_data_key1 := '00';
11142: l_ra_ar_gt.source_data_key2 := '00';
11143: l_ra_ar_gt.source_data_key3 := '00';

Line 11141: l_ra_ar_gt.source_data_key1 := '00';

11137: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11138: l_ra_ar_gt.gp_level := 'D';
11139: l_ra_ar_gt.group_id := '00';
11140: --{HYUBPAGP
11141: l_ra_ar_gt.source_data_key1 := '00';
11142: l_ra_ar_gt.source_data_key2 := '00';
11143: l_ra_ar_gt.source_data_key3 := '00';
11144: l_ra_ar_gt.source_data_key4 := '00';
11145: l_ra_ar_gt.source_data_key5 := '00';

Line 11142: l_ra_ar_gt.source_data_key2 := '00';

11138: l_ra_ar_gt.gp_level := 'D';
11139: l_ra_ar_gt.group_id := '00';
11140: --{HYUBPAGP
11141: l_ra_ar_gt.source_data_key1 := '00';
11142: l_ra_ar_gt.source_data_key2 := '00';
11143: l_ra_ar_gt.source_data_key3 := '00';
11144: l_ra_ar_gt.source_data_key4 := '00';
11145: l_ra_ar_gt.source_data_key5 := '00';
11146: --}

Line 11143: l_ra_ar_gt.source_data_key3 := '00';

11139: l_ra_ar_gt.group_id := '00';
11140: --{HYUBPAGP
11141: l_ra_ar_gt.source_data_key1 := '00';
11142: l_ra_ar_gt.source_data_key2 := '00';
11143: l_ra_ar_gt.source_data_key3 := '00';
11144: l_ra_ar_gt.source_data_key4 := '00';
11145: l_ra_ar_gt.source_data_key5 := '00';
11146: --}
11147: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;

Line 11144: l_ra_ar_gt.source_data_key4 := '00';

11140: --{HYUBPAGP
11141: l_ra_ar_gt.source_data_key1 := '00';
11142: l_ra_ar_gt.source_data_key2 := '00';
11143: l_ra_ar_gt.source_data_key3 := '00';
11144: l_ra_ar_gt.source_data_key4 := '00';
11145: l_ra_ar_gt.source_data_key5 := '00';
11146: --}
11147: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11148: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;

Line 11145: l_ra_ar_gt.source_data_key5 := '00';

11141: l_ra_ar_gt.source_data_key1 := '00';
11142: l_ra_ar_gt.source_data_key2 := '00';
11143: l_ra_ar_gt.source_data_key3 := '00';
11144: l_ra_ar_gt.source_data_key4 := '00';
11145: l_ra_ar_gt.source_data_key5 := '00';
11146: --}
11147: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11148: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
11149: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;

Line 11147: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;

11143: l_ra_ar_gt.source_data_key3 := '00';
11144: l_ra_ar_gt.source_data_key4 := '00';
11145: l_ra_ar_gt.source_data_key5 := '00';
11146: --}
11147: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11148: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
11149: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
11150: l_ra_ar_gt.activity_bucket := 'ADJ';
11151: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,

Line 11148: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;

11144: l_ra_ar_gt.source_data_key4 := '00';
11145: l_ra_ar_gt.source_data_key5 := '00';
11146: --}
11147: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11148: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
11149: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
11150: l_ra_ar_gt.activity_bucket := 'ADJ';
11151: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
11152: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,

Line 11149: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;

11145: l_ra_ar_gt.source_data_key5 := '00';
11146: --}
11147: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11148: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
11149: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
11150: l_ra_ar_gt.activity_bucket := 'ADJ';
11151: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
11152: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
11153: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt

Line 11150: l_ra_ar_gt.activity_bucket := 'ADJ';

11146: --}
11147: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11148: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
11149: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
11150: l_ra_ar_gt.activity_bucket := 'ADJ';
11151: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
11152: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
11153: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
11154: );

Line 11151: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,

11147: -- l_ra_ar_gt.se_gt_id := g_se_gt_id;
11148: l_ra_ar_gt.set_of_books_id := p_ae_sys_rec.set_of_books_id;
11149: l_ra_ar_gt.sob_type := p_ae_sys_rec.sob_type;
11150: l_ra_ar_gt.activity_bucket := 'ADJ';
11151: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt,
11152: p_ar_base_dist_amts_gt => l_ar_base_dist_amts_gt,
11153: p_ra_ar_amounts_gt => l_ra_ar_amounts_gt
11154: );
11155: END IF;

Line 11171: l_ra_ar_gt ra_ar_gt%ROWTYPE;

11167: p_customer_trx_id IN NUMBER,
11168: p_gt_id IN NUMBER,
11169: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
11170: IS
11171: l_ra_ar_gt ra_ar_gt%ROWTYPE;
11172: BEGIN
11173: IF NVL(p_adj_rec.freight_adjusted,0) <> 0 AND
11174: NVL(p_sum_line_frt_orig_amt,0) = 0 AND
11175: NVL(p_sum_line_frt_rem_amt,0) = 0

Line 11178: l_ra_ar_gt.GT_ID := p_gt_id;

11174: NVL(p_sum_line_frt_orig_amt,0) = 0 AND
11175: NVL(p_sum_line_frt_rem_amt,0) = 0
11176: THEN
11177: localdebug(' -9 Adjustment Boundary FREIGHT condition met');
11178: l_ra_ar_gt.GT_ID := p_gt_id;
11179: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
11180: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted,
11181: p_ae_sys_rec.base_currency);
11182: l_ra_ar_gt.ACCOUNT_CLASS := 'FREIGHT';

Line 11179: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;

11175: NVL(p_sum_line_frt_rem_amt,0) = 0
11176: THEN
11177: localdebug(' -9 Adjustment Boundary FREIGHT condition met');
11178: l_ra_ar_gt.GT_ID := p_gt_id;
11179: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
11180: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted,
11181: p_ae_sys_rec.base_currency);
11182: l_ra_ar_gt.ACCOUNT_CLASS := 'FREIGHT';
11183: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid

Line 11180: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted,

11176: THEN
11177: localdebug(' -9 Adjustment Boundary FREIGHT condition met');
11178: l_ra_ar_gt.GT_ID := p_gt_id;
11179: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
11180: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted,
11181: p_ae_sys_rec.base_currency);
11182: l_ra_ar_gt.ACCOUNT_CLASS := 'FREIGHT';
11183: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11184: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;

Line 11182: l_ra_ar_gt.ACCOUNT_CLASS := 'FREIGHT';

11178: l_ra_ar_gt.GT_ID := p_gt_id;
11179: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
11180: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted,
11181: p_ae_sys_rec.base_currency);
11182: l_ra_ar_gt.ACCOUNT_CLASS := 'FREIGHT';
11183: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11184: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
11185: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
11186: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;

Line 11183: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid

11179: l_ra_ar_gt.AMT := p_adj_rec.freight_adjusted;
11180: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted,
11181: p_ae_sys_rec.base_currency);
11182: l_ra_ar_gt.ACCOUNT_CLASS := 'FREIGHT';
11183: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11184: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
11185: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
11186: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11187: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;

Line 11184: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;

11180: l_ra_ar_gt.ACCTD_AMT := currRound(p_adj_rec.freight_adjusted,
11181: p_ae_sys_rec.base_currency);
11182: l_ra_ar_gt.ACCOUNT_CLASS := 'FREIGHT';
11183: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11184: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
11185: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
11186: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11187: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
11188: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted,

Line 11185: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;

11181: p_ae_sys_rec.base_currency);
11182: l_ra_ar_gt.ACCOUNT_CLASS := 'FREIGHT';
11183: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11184: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
11185: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
11186: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11187: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
11188: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted,
11189: p_ae_sys_rec.base_currency);

Line 11186: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;

11182: l_ra_ar_gt.ACCOUNT_CLASS := 'FREIGHT';
11183: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11184: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
11185: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
11186: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11187: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
11188: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted,
11189: p_ae_sys_rec.base_currency);
11190: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;

Line 11187: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;

11183: l_ra_ar_gt.CCID_SECONDARY := NULL; --Normally the auto accounting ccid
11184: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
11185: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
11186: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11187: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
11188: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted,
11189: p_ae_sys_rec.base_currency);
11190: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11191: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;

Line 11188: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted,

11184: l_ra_ar_gt.REF_CUST_TRX_LINE_GL_DIST_ID:= -9;
11185: l_ra_ar_gt.REF_CUSTOMER_TRX_LINE_ID := -9;
11186: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11187: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
11188: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted,
11189: p_ae_sys_rec.base_currency);
11190: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11191: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11192: l_ra_ar_gt.tl_chrg_alloc_amt := 0;

Line 11190: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;

11186: l_ra_ar_gt.REF_CUSTOMER_TRX_ID := p_customer_trx_id;
11187: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
11188: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted,
11189: p_ae_sys_rec.base_currency);
11190: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11191: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11192: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11193: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11194: l_ra_ar_gt.tl_tax_alloc_amt := 0;

Line 11191: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;

11187: l_ra_ar_gt.DIST_AMT := p_adj_rec.freight_adjusted;
11188: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted,
11189: p_ae_sys_rec.base_currency);
11190: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11191: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11192: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11193: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11194: l_ra_ar_gt.tl_tax_alloc_amt := 0;
11195: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;

Line 11192: l_ra_ar_gt.tl_chrg_alloc_amt := 0;

11188: l_ra_ar_gt.DIST_ACCTD_AMT := currRound(p_adj_rec.tax_adjusted,
11189: p_ae_sys_rec.base_currency);
11190: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11191: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11192: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11193: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11194: l_ra_ar_gt.tl_tax_alloc_amt := 0;
11195: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
11196: l_ra_ar_gt.tl_alloc_amt := 0;

Line 11193: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;

11189: p_ae_sys_rec.base_currency);
11190: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11191: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11192: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11193: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11194: l_ra_ar_gt.tl_tax_alloc_amt := 0;
11195: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
11196: l_ra_ar_gt.tl_alloc_amt := 0;
11197: l_ra_ar_gt.tl_alloc_acctd_amt := 0;

Line 11194: l_ra_ar_gt.tl_tax_alloc_amt := 0;

11190: l_ra_ar_gt.TO_CURRENCY := p_inv_currency;
11191: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11192: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11193: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11194: l_ra_ar_gt.tl_tax_alloc_amt := 0;
11195: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
11196: l_ra_ar_gt.tl_alloc_amt := 0;
11197: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11198: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;

Line 11195: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;

11191: l_ra_ar_gt.BASE_CURRENCY := p_ae_sys_rec.base_currency;
11192: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11193: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11194: l_ra_ar_gt.tl_tax_alloc_amt := 0;
11195: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
11196: l_ra_ar_gt.tl_alloc_amt := 0;
11197: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11198: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
11199: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted,

Line 11196: l_ra_ar_gt.tl_alloc_amt := 0;

11192: l_ra_ar_gt.tl_chrg_alloc_amt := 0;
11193: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11194: l_ra_ar_gt.tl_tax_alloc_amt := 0;
11195: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
11196: l_ra_ar_gt.tl_alloc_amt := 0;
11197: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11198: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
11199: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted,
11200: p_ae_sys_rec.base_currency);

Line 11197: l_ra_ar_gt.tl_alloc_acctd_amt := 0;

11193: l_ra_ar_gt.tl_chrg_alloc_acctd_amt := 0;
11194: l_ra_ar_gt.tl_tax_alloc_amt := 0;
11195: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
11196: l_ra_ar_gt.tl_alloc_amt := 0;
11197: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11198: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
11199: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted,
11200: p_ae_sys_rec.base_currency);
11201: l_ra_ar_gt.base_dist_amt := p_adj_rec.freight_adjusted;

Line 11198: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;

11194: l_ra_ar_gt.tl_tax_alloc_amt := 0;
11195: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
11196: l_ra_ar_gt.tl_alloc_amt := 0;
11197: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11198: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
11199: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted,
11200: p_ae_sys_rec.base_currency);
11201: l_ra_ar_gt.base_dist_amt := p_adj_rec.freight_adjusted;
11202: l_ra_ar_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted,

Line 11199: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted,

11195: l_ra_ar_gt.tl_tax_alloc_acctd_amt := 0;
11196: l_ra_ar_gt.tl_alloc_amt := 0;
11197: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11198: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
11199: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted,
11200: p_ae_sys_rec.base_currency);
11201: l_ra_ar_gt.base_dist_amt := p_adj_rec.freight_adjusted;
11202: l_ra_ar_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted,
11203: p_ae_sys_rec.base_currency);

Line 11201: l_ra_ar_gt.base_dist_amt := p_adj_rec.freight_adjusted;

11197: l_ra_ar_gt.tl_alloc_acctd_amt := 0;
11198: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
11199: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted,
11200: p_ae_sys_rec.base_currency);
11201: l_ra_ar_gt.base_dist_amt := p_adj_rec.freight_adjusted;
11202: l_ra_ar_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted,
11203: p_ae_sys_rec.base_currency);
11204: l_ra_ar_gt.source_type := 'FREIGHT';
11205: l_ra_ar_gt.source_table := 'ADJ';

Line 11202: l_ra_ar_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted,

11198: l_ra_ar_gt.tl_frt_alloc_amt := p_adj_rec.freight_adjusted;
11199: l_ra_ar_gt.tl_frt_alloc_acctd_amt := currRound(p_adj_rec.freight_adjusted,
11200: p_ae_sys_rec.base_currency);
11201: l_ra_ar_gt.base_dist_amt := p_adj_rec.freight_adjusted;
11202: l_ra_ar_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted,
11203: p_ae_sys_rec.base_currency);
11204: l_ra_ar_gt.source_type := 'FREIGHT';
11205: l_ra_ar_gt.source_table := 'ADJ';
11206: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;

Line 11204: l_ra_ar_gt.source_type := 'FREIGHT';

11200: p_ae_sys_rec.base_currency);
11201: l_ra_ar_gt.base_dist_amt := p_adj_rec.freight_adjusted;
11202: l_ra_ar_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted,
11203: p_ae_sys_rec.base_currency);
11204: l_ra_ar_gt.source_type := 'FREIGHT';
11205: l_ra_ar_gt.source_table := 'ADJ';
11206: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11207: l_ra_ar_gt.gp_level := 'D';
11208: l_ra_ar_gt.group_id := '00';

Line 11205: l_ra_ar_gt.source_table := 'ADJ';

11201: l_ra_ar_gt.base_dist_amt := p_adj_rec.freight_adjusted;
11202: l_ra_ar_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted,
11203: p_ae_sys_rec.base_currency);
11204: l_ra_ar_gt.source_type := 'FREIGHT';
11205: l_ra_ar_gt.source_table := 'ADJ';
11206: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11207: l_ra_ar_gt.gp_level := 'D';
11208: l_ra_ar_gt.group_id := '00';
11209: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt);

Line 11206: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;

11202: l_ra_ar_gt.base_dist_acctd_amt := currRound(p_adj_rec.freight_adjusted,
11203: p_ae_sys_rec.base_currency);
11204: l_ra_ar_gt.source_type := 'FREIGHT';
11205: l_ra_ar_gt.source_table := 'ADJ';
11206: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11207: l_ra_ar_gt.gp_level := 'D';
11208: l_ra_ar_gt.group_id := '00';
11209: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt);
11210: END IF;

Line 11207: l_ra_ar_gt.gp_level := 'D';

11203: p_ae_sys_rec.base_currency);
11204: l_ra_ar_gt.source_type := 'FREIGHT';
11205: l_ra_ar_gt.source_table := 'ADJ';
11206: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11207: l_ra_ar_gt.gp_level := 'D';
11208: l_ra_ar_gt.group_id := '00';
11209: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt);
11210: END IF;
11211: END freight_boundary;

Line 11208: l_ra_ar_gt.group_id := '00';

11204: l_ra_ar_gt.source_type := 'FREIGHT';
11205: l_ra_ar_gt.source_table := 'ADJ';
11206: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11207: l_ra_ar_gt.gp_level := 'D';
11208: l_ra_ar_gt.group_id := '00';
11209: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt);
11210: END IF;
11211: END freight_boundary;
11212: */

Line 11209: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt);

11205: l_ra_ar_gt.source_table := 'ADJ';
11206: l_ra_ar_gt.source_id := p_adj_rec.adjustment_id;
11207: l_ra_ar_gt.gp_level := 'D';
11208: l_ra_ar_gt.group_id := '00';
11209: insert_ra_ar_gt(p_ra_ar_gt => l_ra_ar_gt);
11210: END IF;
11211: END freight_boundary;
11212: */
11213: BEGIN

Line 11481: FROM RA_AR_GT b,

11477: b.FROM_CURRENCY ,
11478: -- Rowid
11479: b.rowid,
11480: b.line_type
11481: FROM RA_AR_GT b,
11482: RA_AR_AMOUNTS_GT d
11483: WHERE b.gt_id = p_gt_id
11484: AND b.ref_customer_trx_id = p_customer_trx_id
11485: AND b.gp_level = 'GPL'

Line 11757: localdebug('update ra_ar_gt trx_line_all ');

11753: x_run_uned_chrg_acctd_amt => l_run_uned_chrg_acctd_amt,
11754: x_run_uned_chrg_acctd_alloc => l_run_uned_chrg_acctd_alloc);
11755:
11756: IF PG_DEBUG = 'Y' THEN
11757: localdebug('update ra_ar_gt trx_line_all ');
11758: END IF;
11759: FORALL i IN l_tab.ROWID_ID.FIRST .. l_tab.ROWID_ID.LAST
11760: UPDATE ra_ar_gt
11761: SET

Line 11760: UPDATE ra_ar_gt

11756: IF PG_DEBUG = 'Y' THEN
11757: localdebug('update ra_ar_gt trx_line_all ');
11758: END IF;
11759: FORALL i IN l_tab.ROWID_ID.FIRST .. l_tab.ROWID_ID.LAST
11760: UPDATE ra_ar_gt
11761: SET
11762: -- ADJ and APP
11763: tl_alloc_amt = l_tab.tl_alloc_amt(i),
11764: tl_alloc_acctd_amt = l_tab.tl_alloc_acctd_amt(i),

Line 11826: INSERT INTO RA_AR_GT

11822: localdebug(' p_source_data_key5 :'||p_source_data_key5);
11823: localdebug(' p_gt_id :'||p_gt_id);
11824: END IF;
11825:
11826: INSERT INTO RA_AR_GT
11827: ( GT_ID ,
11828: BASE_CURRENCY ,
11829: TO_CURRENCY ,
11830: REF_CUSTOMER_TRX_ID ,

Line 12173: INSERT INTO RA_AR_GT

12169: localdebug(' p_customer_trx_line_id :'||p_customer_trx_line_id);
12170: localdebug(' p_gt_id :'||p_gt_id);
12171: END IF;
12172:
12173: INSERT INTO RA_AR_GT
12174: ( GT_ID ,
12175: BASE_CURRENCY ,
12176: TO_CURRENCY ,
12177: REF_CUSTOMER_TRX_ID ,

Line 14041: -- insert into ra_ar_st select * from ra_ar_gt;

14037: -- END IF;
14038:
14039: --HYU
14040: -- delete from ra_ar_st;
14041: -- insert into ra_ar_st select * from ra_ar_gt;
14042:
14043: --{HYUNLB
14044: -- final_update_inv_ctl_rem_orig(p_customer_trx => p_customer_trx);
14045: --}

Line 14088: PROCEDURE display_ra_ar_row(p_ra_ar_rec IN ra_ar_gt%ROWTYPE)

14084: RAISE;
14085: END Trx_level_direct_cash_apply;
14086:
14087:
14088: PROCEDURE display_ra_ar_row(p_ra_ar_rec IN ra_ar_gt%ROWTYPE)
14089: IS
14090: BEGIN
14091: IF PG_DEBUG = 'Y' THEN
14092: localdebug( 'display_ra_ar_row +');

Line 14326: PROCEDURE display_ra_ar_gt

14322: END IF;
14323: END;
14324:
14325:
14326: PROCEDURE display_ra_ar_gt
14327: (p_code IN VARCHAR2 DEFAULT NULL,
14328: p_gt_id IN VARCHAR2)
14329: IS
14330: CURSOR c1 IS

Line 14331: SELECT * FROM ra_ar_gt

14327: (p_code IN VARCHAR2 DEFAULT NULL,
14328: p_gt_id IN VARCHAR2)
14329: IS
14330: CURSOR c1 IS
14331: SELECT * FROM ra_ar_gt
14332: WHERE gt_id = p_gt_id;
14333:
14334: CURSOR c2 IS
14335: SELECT * FROM ra_ar_gt

Line 14335: SELECT * FROM ra_ar_gt

14331: SELECT * FROM ra_ar_gt
14332: WHERE gt_id = p_gt_id;
14333:
14334: CURSOR c2 IS
14335: SELECT * FROM ra_ar_gt
14336: WHERE gp_level = p_code
14337: AND gt_id = p_gt_id;
14338:
14339: l_record c1%ROWTYPE;

Line 14343: localdebug('arp_det_dist_pkg.display_ra_ar_gt()+');

14339: l_record c1%ROWTYPE;
14340: l_record2 c2%ROWTYPE;
14341: BEGIN
14342: IF (PG_DEBUG = 'Y') THEN
14343: localdebug('arp_det_dist_pkg.display_ra_ar_gt()+');
14344: localdebug(' p_code : '||p_code);
14345: IF p_code IS NULL THEN
14346: OPEN c1;
14347: LOOP

Line 14362: localdebug('arp_det_dist_pkg.display_ra_ar_gt()-');

14358: display_ra_ar_row(l_record2);
14359: END LOOP;
14360: CLOSE c2;
14361: END IF;
14362: localdebug('arp_det_dist_pkg.display_ra_ar_gt()-');
14363: END IF;
14364: END;
14365:
14366:

Line 17355: UPDATE RA_AR_GT SET

17351: IF PG_DEBUG = 'Y' THEN
17352: localdebug('p_gt_id:'||p_gt_id);
17353: END IF;
17354:
17355: UPDATE RA_AR_GT SET
17356: tl_alloc_amt = DECODE(account_class,'REV' ,g_line_applied,
17357: 'INVOICE' ,g_line_applied,0)
17358: , tl_alloc_acctd_amt = DECODE(account_class,'REV' ,g_acctd_line_applied,
17359: 'INVOICE' ,g_acctd_line_applied,0)

Line 17406: UPDATE RA_AR_GT SET

17402:
17403:
17404: ELSIF p_cash_mfar = 'MFAR' THEN
17405:
17406: UPDATE RA_AR_GT SET
17407: tl_alloc_amt = DECODE(account_class,'REV' ,g_line_applied,0)
17408: ,tl_alloc_acctd_amt = DECODE(account_class,'REV' ,g_acctd_line_applied,0)
17409: ,tl_chrg_alloc_amt = g_chrg_applied
17410: ,tl_chrg_alloc_acctd_amt = g_acctd_chrg_applied

Line 17449: -- insert into ra_ar select * from ra_ar_gt;

17445:
17446: END IF;
17447:
17448: -- delete from ra_ar;
17449: -- insert into ra_ar select * from ra_ar_gt;
17450:
17451:
17452: --g_se_gt_id := USERENV('SESSIONID');
17453:

Line 17730: UPDATE RA_AR_GT a SET

17726: g_uned_req := 'N';
17727: END IF;
17728:
17729:
17730: UPDATE RA_AR_GT a SET
17731: ( tl_alloc_amt ,
17732: tl_alloc_acctd_amt ,
17733: tl_chrg_alloc_amt ,
17734: tl_chrg_alloc_acctd_amt,

Line 17803: FROM ra_ar_gt b

17799: --, USERENV('SESSIONID')
17800: , p_app_rec.receivable_application_id
17801: , 'RA'
17802: , p_ae_sys_rec.base_currency
17803: FROM ra_ar_gt b
17804: WHERE a.rowid = b.rowid
17805: AND a.gt_id = p_gt_id);
17806:
17807: -- delete from ra_ar;

Line 17808: -- insert into ra_ar select * from ra_ar_gt;

17804: WHERE a.rowid = b.rowid
17805: AND a.gt_id = p_gt_id);
17806:
17807: -- delete from ra_ar;
17808: -- insert into ra_ar select * from ra_ar_gt;
17809:
17810: update_dist
17811: (p_gt_id => p_gt_id,
17812: p_customer_trx_id => l_app_rec.applied_customer_trx_id,

Line 18047: FROM ra_ar_gt a,ar_base_dist_amts_gt b

18043: b.base_dist_tax_amt tax_balance,
18044: b.base_dist_frt_amt freight_balance,
18045: b.base_dist_chrg_amt charges_balance,
18046: a.to_currency invoice_currency_code
18047: FROM ra_ar_gt a,ar_base_dist_amts_gt b
18048: WHERE a.ref_customer_trx_id = p_customer_trx_id
18049: AND b.gt_id = a.gt_id
18050: AND b.gp_level = 'D'
18051: AND a.ref_customer_trx_id = b.ref_customer_trx_id

Line 19739: FROM ra_ar_gt

19735: SUM_INT_ED_LINE_AMOUNT ,
19736: SUM_INT_ED_TAX_AMOUNT ,
19737: SUM_INT_UNED_LINE_AMOUNT ,
19738: SUM_INT_UNED_TAX_AMOUNT
19739: FROM ra_ar_gt
19740: WHERE gt_id = l_gt_id;
19741: */
19742:
19743: OPEN c(l_gt_id);