APPS.JAI_AR_VALIDATE_DATA_PKG dependencies on JAI_AR_TRX_LINES

Line 654: CURSOR cur_il_tax_amount(cp_customer_trx_id JAI_AR_TRX_LINES.customer_trx_id%TYPE)

650: (account_class <> 'REC')
651: )
652: AND account_class = NVL(cp_account_class, account_class);
653:
654: CURSOR cur_il_tax_amount(cp_customer_trx_id JAI_AR_TRX_LINES.customer_trx_id%TYPE)
655: IS
656: SELECT rctl.customer_trx_id,
657: jrcttl.customer_trx_line_id,
658: jrcttl.tax_amount

Line 660: JAI_AR_TRX_LINES jrctl,

656: SELECT rctl.customer_trx_id,
657: jrcttl.customer_trx_line_id,
658: jrcttl.tax_amount
659: FROM JAI_AR_TRX_TAX_LINES jrcttl,
660: JAI_AR_TRX_LINES jrctl,
661: ra_customer_trx_lines_all rctl
662: WHERE jrcttl.link_to_cust_trx_line_id = jrctl.customer_trx_line_id
663: AND jrcttl.customer_Trx_line_id = rctl.customer_trx_line_id
664: AND nvl(jrcttl.tax_amount,0) <> nvl(rctl.extended_amount,0)

Line 669: CURSOR cur_cust_trx_gl_dist_tax (cp_customer_trx_id JAI_AR_TRX_LINES.customer_trx_id%TYPE)

665: AND rctl.customer_trx_id = jrctl.customer_trx_id
666: AND jrctl.customer_trx_id = cp_customer_trx_id
667: AND rctl.line_type IN ('TAX','FREIGHT');
668:
669: CURSOR cur_cust_trx_gl_dist_tax (cp_customer_trx_id JAI_AR_TRX_LINES.customer_trx_id%TYPE)
670: IS
671: SELECT gl_dist.customer_trx_id,
672: jrcttl.customer_trx_line_id,
673: jrcttl.tax_amount ,

Line 676: JAI_AR_TRX_LINES jrctl,

672: jrcttl.customer_trx_line_id,
673: jrcttl.tax_amount ,
674: jrcttl.func_tax_amount
675: FROM JAI_AR_TRX_TAX_LINES jrcttl,
676: JAI_AR_TRX_LINES jrctl,
677: ra_cust_trx_line_gl_dist_all gl_dist
678: WHERE jrcttl.link_to_cust_trx_line_id = jrctl.customer_trx_line_id
679: AND jrcttl.customer_Trx_line_id = gl_dist.customer_trx_line_id
680: AND (ROUND(nvl(jrcttl.tax_amount,0)) <> ROUND(nvl(gl_dist.amount,0))

Line 690: CURSOR cur_chk_gl_dist_rctl (cp_customer_trx_id JAI_AR_TRX_LINES.customer_trx_id%TYPE)

686: AND gl_dist.account_class IN ('TAX','FREIGHT');
687:
688:
689:
690: CURSOR cur_chk_gl_dist_rctl (cp_customer_trx_id JAI_AR_TRX_LINES.customer_trx_id%TYPE)
691: IS
692: SELECT
693: gl_dist.customer_trx_line_id ,
694: gl_dist.amount amount

Line 775: FROM JAI_AR_TRX_LINES jrctl,

771: CURSOR cur_sync_il_line_tax (cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
772: IS
773: SELECT jrctl.customer_trx_line_id,
774: nvl(sum(jrcttl.tax_amount),0) tax_amount
775: FROM JAI_AR_TRX_LINES jrctl,
776: JAI_AR_TRX_TAX_LINES jrcttl
777: WHERE jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id
778: AND jrctl.customer_trx_id = cp_customer_trx_id
779: GROUP BY jrctl.customer_trx_line_id

Line 781: FROM JAI_AR_TRX_LINES a

777: WHERE jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id
778: AND jrctl.customer_trx_id = cp_customer_trx_id
779: GROUP BY jrctl.customer_trx_line_id
780: HAVING ROUND(nvl(sum(jrcttl.tax_amount),0)) <>( SELECT ROUND(NVL(tax_amount,0))
781: FROM JAI_AR_TRX_LINES a
782: WHERE a.customer_trx_line_id = jrctl.customer_trx_line_id);
783:
784: CURSOR cur_sync_il_hdr_tax (cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
785: IS

Line 788: FROM JAI_AR_TRX_LINES jrctl,

784: CURSOR cur_sync_il_hdr_tax (cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
785: IS
786: SELECT jtrx.customer_trx_id ,
787: NVL(SUM(jrctl.tax_amount),0) tax_amount
788: FROM JAI_AR_TRX_LINES jrctl,
789: JAI_AR_TRXS jtrx
790: WHERE jrctl.customer_trx_id = cp_customer_trx_id
791: AND jrctl.customer_trx_id = jtrx.customer_trx_id
792: GROUP BY jtrx.customer_trx_id

Line 2262: UPDATE JAI_AR_TRX_LINES

2258:
2259: ln_error_cnt := 1;
2260:
2261:
2262: UPDATE JAI_AR_TRX_LINES
2263: SET tax_amount = rec_cur_sync_il_line_tax.tax_amount ,
2264: total_amount = line_amount + rec_cur_sync_il_line_tax.tax_amount,
2265: last_update_date = sysdate,
2266: last_updated_by = gn_bug_no

Line 2270: 'UPDATE JAI_AR_TRX_LINES

2266: last_updated_by = gn_bug_no
2267: WHERE customer_trx_line_id = rec_cur_sync_il_line_tax.customer_trx_line_id;
2268:
2269: lv_sql_statement := fnd_global.local_chr(10)||
2270: 'UPDATE JAI_AR_TRX_LINES
2271: SET tax_amount = '||rec_cur_sync_il_line_tax.tax_amount||' ,
2272: total_amount = line_amount + '||rec_cur_sync_il_line_tax.tax_amount||',
2273: last_update_date = sysdate,
2274: last_updated_by = '||gn_bug_no||'