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.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_AP_TDS_THGRP_AUDITS

Line 2632: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;

2628:
2629:
2630: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
2631:
2632: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;
2633: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
2634: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
2635: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
2636: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;

Line 2633: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;

2629:
2630: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
2631:
2632: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;
2633: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
2634: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
2635: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
2636: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
2637: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;

Line 2634: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;

2630: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
2631:
2632: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;
2633: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
2634: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
2635: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
2636: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
2637: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
2638: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;

Line 2635: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;

2631:
2632: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;
2633: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
2634: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
2635: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
2636: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
2637: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
2638: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
2639: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;

Line 2636: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;

2632: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;
2633: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
2634: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
2635: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
2636: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
2637: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
2638: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
2639: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
2640:

Line 2637: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;

2633: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
2634: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
2635: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
2636: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
2637: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
2638: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
2639: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
2640:
2641: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;

Line 2638: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;

2634: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
2635: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
2636: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
2637: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
2638: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
2639: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
2640:
2641: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
2642: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;

Line 2639: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;

2635: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
2636: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
2637: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
2638: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
2639: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
2640:
2641: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
2642: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
2643: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;

Line 2641: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;

2637: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
2638: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
2639: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
2640:
2641: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
2642: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
2643: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
2644: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
2645: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;

Line 2642: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;

2638: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
2639: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
2640:
2641: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
2642: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
2643: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
2644: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
2645: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
2646: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;

Line 2643: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;

2639: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
2640:
2641: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
2642: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
2643: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
2644: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
2645: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
2646: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
2647: ln_new_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;

Line 2644: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;

2640:
2641: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
2642: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
2643: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
2644: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
2645: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
2646: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
2647: ln_new_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
2648: ln_effective_threshold_amount number;

Line 2645: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;

2641: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
2642: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
2643: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
2644: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
2645: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
2646: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
2647: ln_new_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
2648: ln_effective_threshold_amount number;
2649: ln_effective_tax_paid number;

Line 2646: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;

2642: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
2643: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
2644: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
2645: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
2646: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
2647: ln_new_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
2648: ln_effective_threshold_amount number;
2649: ln_effective_tax_paid number;
2650:

Line 2647: ln_new_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;

2643: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
2644: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
2645: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
2646: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
2647: ln_new_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
2648: ln_effective_threshold_amount number;
2649: ln_effective_tax_paid number;
2650:
2651: -- bug 5722028. Added by csahoo

Line 2840: insert into jai_ap_tds_thgrp_audits

2836: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
2837:
2838: /* Insert into the audite table */
2839: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
2840: insert into jai_ap_tds_thgrp_audits
2841: (
2842: threshold_grp_audit_id ,
2843: threshold_grp_id ,
2844: old_invoice_amount ,

Line 2878: jai_ap_tds_thgrp_audits_s.nextval ,

2874: last_update_login
2875: )
2876: values
2877: (
2878: jai_ap_tds_thgrp_audits_s.nextval ,
2879: ln_threshold_grp_id ,
2880: ln_old_invoice_amount ,
2881: ln_old_invoice_cancel_amount ,
2882: ln_old_invoice_apply_amount ,

Line 3502: ln_threshold_grp_audit_id jai_ap_tds_thgrp_audits.threshold_grp_audit_id%TYPE;

3498: lv_tds_event jai_ap_tds_thhold_trxs.tds_event%TYPE;
3499: lv_tds_invoice_num ap_invoices_all.invoice_num%type;
3500: lv_tds_cm_num ap_invoices_all.invoice_num%type;
3501: ln_threshold_trx_id jai_ap_tds_thhold_trxs.threshold_trx_id%TYPE;
3502: ln_threshold_grp_audit_id jai_ap_tds_thgrp_audits.threshold_grp_audit_id%TYPE;
3503: ln_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
3504:
3505: CURSOR get_thhold_transn (cp_threshold_grp_id IN NUMBER )
3506: IS