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.

[Home] [Help]

APPS.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_AP_TDS_THGRP_AUDITS

Line 2790: FROM jai_ap_tds_thgrp_audits jatta

2786: and jatit.tax_amount <> 0
2787: /*Bug 11880998 - Skip Invoices that are canceled without validation
2788: Such Invoices do not update Threshold Audits*/
2789: and NOT EXISTS (SELECT 1
2790: FROM jai_ap_tds_thgrp_audits jatta
2791: WHERE jatit.invoice_id = jatta.invoice_id
2792: AND (jatta.trx_invoice_amount = 0 OR jatta.trx_invoice_cancel_amount = 0)
2793: AND EXISTS (SELECT 1
2794: FROM ap_invoices_all aia

Line 2925: FROM jai_ap_tds_thgrp_audits

2921: /*Start-Bug 9562876*/
2922: CURSOR c_thhold_rollback_occurred(cp_threshold_grp_id NUMBER, cp_new_thhold_slab NUMBER)
2923: IS
2924: SELECT 1
2925: FROM jai_ap_tds_thgrp_audits
2926: WHERE threshold_grp_id = cp_threshold_grp_id
2927: AND tds_Event like 'THRESHOLD ROLLBACK%'
2928: AND new_threshold_slab_id = cp_new_thhold_slab;
2929:

Line 2935: from jai_ap_tds_thgrp_audits

2931: IS
2932: select ((tax_amount/tax_rate)*100) taxable_amount, tax_amount
2933: from jai_Ap_tds_thhold_trxs
2934: where invoice_id = (select invoice_id
2935: from jai_ap_tds_thgrp_audits
2936: where threshold_grp_audit_id = (select max(threshold_grp_audit_id)
2937: from jai_Ap_tds_thgrp_Audits
2938: where tds_event like 'THRESHOLD ROLLBACK%'
2939: and new_threshold_slab_id = cp_new_thhold_slab

Line 2937: from jai_Ap_tds_thgrp_Audits

2933: from jai_Ap_tds_thhold_trxs
2934: where invoice_id = (select invoice_id
2935: from jai_ap_tds_thgrp_audits
2936: where threshold_grp_audit_id = (select max(threshold_grp_audit_id)
2937: from jai_Ap_tds_thgrp_Audits
2938: where tds_event like 'THRESHOLD ROLLBACK%'
2939: and new_threshold_slab_id = cp_new_thhold_slab
2940: and threshold_grp_id = cp_threshold_grp_id)
2941: )

Line 3834: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;

3830:
3831:
3832: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
3833:
3834: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;
3835: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
3836: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
3837: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
3838: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;

Line 3835: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;

3831:
3832: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
3833:
3834: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;
3835: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
3836: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
3837: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
3838: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
3839: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;

Line 3836: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;

3832: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
3833:
3834: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;
3835: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
3836: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
3837: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
3838: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
3839: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
3840: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;

Line 3837: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;

3833:
3834: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;
3835: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
3836: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
3837: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
3838: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
3839: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
3840: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
3841: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;

Line 3838: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;

3834: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;
3835: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
3836: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
3837: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
3838: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
3839: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
3840: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
3841: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
3842:

Line 3839: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;

3835: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
3836: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
3837: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
3838: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
3839: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
3840: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
3841: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
3842:
3843: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;

Line 3840: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;

3836: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
3837: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
3838: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
3839: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
3840: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
3841: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
3842:
3843: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
3844: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;

Line 3841: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;

3837: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
3838: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
3839: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
3840: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
3841: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
3842:
3843: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
3844: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
3845: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;

Line 3843: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;

3839: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
3840: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
3841: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
3842:
3843: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
3844: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
3845: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
3846: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
3847: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;

Line 3844: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;

3840: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
3841: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
3842:
3843: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
3844: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
3845: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
3846: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
3847: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
3848: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;

Line 3845: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;

3841: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
3842:
3843: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
3844: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
3845: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
3846: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
3847: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
3848: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
3849: ln_new_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;

Line 3846: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;

3842:
3843: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
3844: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
3845: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
3846: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
3847: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
3848: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
3849: ln_new_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
3850: ln_effective_threshold_amount number;

Line 3847: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;

3843: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
3844: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
3845: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
3846: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
3847: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
3848: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
3849: ln_new_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
3850: ln_effective_threshold_amount number;
3851: ln_effective_tax_paid number;

Line 3848: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;

3844: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
3845: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
3846: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
3847: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
3848: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
3849: ln_new_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
3850: ln_effective_threshold_amount number;
3851: ln_effective_tax_paid number;
3852:

Line 3849: ln_new_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;

3845: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
3846: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
3847: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
3848: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
3849: ln_new_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
3850: ln_effective_threshold_amount number;
3851: ln_effective_tax_paid number;
3852:
3853: /*Bug 5751783. Added following variables.*/

Line 3854: ln_calc_old_tax_paid jai_ap_tds_thgrp_audits.calc_old_tax_paid%type;

3850: ln_effective_threshold_amount number;
3851: ln_effective_tax_paid number;
3852:
3853: /*Bug 5751783. Added following variables.*/
3854: ln_calc_old_tax_paid jai_ap_tds_thgrp_audits.calc_old_tax_paid%type;
3855: ln_calc_trx_tax_paid jai_ap_tds_thgrp_audits.calc_trx_tax_paid%type;
3856: ln_calc_new_tax_paid jai_ap_tds_thgrp_audits.calc_new_tax_paid%type;
3857:
3858: -- bug 5722028. Added by csahoo

Line 3855: ln_calc_trx_tax_paid jai_ap_tds_thgrp_audits.calc_trx_tax_paid%type;

3851: ln_effective_tax_paid number;
3852:
3853: /*Bug 5751783. Added following variables.*/
3854: ln_calc_old_tax_paid jai_ap_tds_thgrp_audits.calc_old_tax_paid%type;
3855: ln_calc_trx_tax_paid jai_ap_tds_thgrp_audits.calc_trx_tax_paid%type;
3856: ln_calc_new_tax_paid jai_ap_tds_thgrp_audits.calc_new_tax_paid%type;
3857:
3858: -- bug 5722028. Added by csahoo
3859: ln_tmp_tds_amt number;

Line 3856: ln_calc_new_tax_paid jai_ap_tds_thgrp_audits.calc_new_tax_paid%type;

3852:
3853: /*Bug 5751783. Added following variables.*/
3854: ln_calc_old_tax_paid jai_ap_tds_thgrp_audits.calc_old_tax_paid%type;
3855: ln_calc_trx_tax_paid jai_ap_tds_thgrp_audits.calc_trx_tax_paid%type;
3856: ln_calc_new_tax_paid jai_ap_tds_thgrp_audits.calc_new_tax_paid%type;
3857:
3858: -- bug 5722028. Added by csahoo
3859: ln_tmp_tds_amt number;
3860: ln_tmp_tds_change number;

Line 4056: insert into jai_ap_tds_thgrp_audits

4052: ln_calc_new_tax_paid := r_jai_ap_tds_thhold_grps.total_calc_tax_paid;
4053:
4054: /* Insert into the audite table */
4055: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
4056: insert into jai_ap_tds_thgrp_audits
4057: (
4058: threshold_grp_audit_id ,
4059: threshold_grp_id ,
4060: old_invoice_amount ,

Line 4098: jai_ap_tds_thgrp_audits_s.nextval ,

4094: calc_new_tax_paid
4095: )
4096: values
4097: (
4098: jai_ap_tds_thgrp_audits_s.nextval ,
4099: ln_threshold_grp_id ,
4100: ln_old_invoice_amount ,
4101: ln_old_invoice_cancel_amount ,
4102: ln_old_invoice_apply_amount ,

Line 4747: ln_threshold_grp_audit_id jai_ap_tds_thgrp_audits.threshold_grp_audit_id%TYPE;

4743: lv_tds_event jai_ap_tds_thhold_trxs.tds_event%TYPE;
4744: lv_tds_invoice_num ap_invoices_all.invoice_num%type;
4745: lv_tds_cm_num ap_invoices_all.invoice_num%type;
4746: ln_threshold_trx_id jai_ap_tds_thhold_trxs.threshold_trx_id%TYPE;
4747: ln_threshold_grp_audit_id jai_ap_tds_thgrp_audits.threshold_grp_audit_id%TYPE;
4748: ln_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
4749:
4750: /* Bug 5751783.
4751: * Get the sum of invoice amount for which TDS is not calculated