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_CANCELLATION_PKG dependencies on JAI_AP_TDS_THHOLD_SLABS

Line 230: CURSOR c_jai_ap_tds_thhold_slabs( p_threshold_hdr_id NUMBER,

226: SELECT *
227: FROM jai_ap_tds_thhold_grps
228: WHERE threshold_grp_id = p_threshold_grp_id;
229:
230: CURSOR c_jai_ap_tds_thhold_slabs( p_threshold_hdr_id NUMBER,
231: p_threshold_type VARCHAR2,
232: p_amount NUMBER)
233: IS
234: SELECT threshold_slab_id, threshold_type_id, from_amount, to_amount, tax_rate

Line 235: FROM jai_ap_tds_thhold_slabs

231: p_threshold_type VARCHAR2,
232: p_amount NUMBER)
233: IS
234: SELECT threshold_slab_id, threshold_type_id, from_amount, to_amount, tax_rate
235: FROM jai_ap_tds_thhold_slabs
236: WHERE threshold_hdr_id = p_threshold_hdr_id
237: AND threshold_type_id in
238: ( SELECT threshold_type_id
239: FROM jai_ap_tds_thhold_types

Line 251: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%ROWTYPE;

247:
248: r_get_threshold_grp_dtl c_get_threshold_grp_dtl%ROWTYPE;
249: ln_effective_invoice_amt NUMBER;
250: ln_effective_inv_amt_after NUMBER;
251: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%ROWTYPE;
252: ln_threshold_slab_id_after jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
253: ln_threshold_slab_id_before jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
254: ln_taxable_amt number := 0;
255: -------------------------------------------------------------------------------

Line 252: ln_threshold_slab_id_after jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;

248: r_get_threshold_grp_dtl c_get_threshold_grp_dtl%ROWTYPE;
249: ln_effective_invoice_amt NUMBER;
250: ln_effective_inv_amt_after NUMBER;
251: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%ROWTYPE;
252: ln_threshold_slab_id_after jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
253: ln_threshold_slab_id_before jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
254: ln_taxable_amt number := 0;
255: -------------------------------------------------------------------------------
256: -- Added by Jia for FP Bug#7312295, End

Line 253: ln_threshold_slab_id_before jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;

249: ln_effective_invoice_amt NUMBER;
250: ln_effective_inv_amt_after NUMBER;
251: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%ROWTYPE;
252: ln_threshold_slab_id_after jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
253: ln_threshold_slab_id_before jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
254: ln_taxable_amt number := 0;
255: -------------------------------------------------------------------------------
256: -- Added by Jia for FP Bug#7312295, End
257:

Line 301: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;

297: ln_threshold_grp_audit_id number;
298: lv_new_transaction varchar2(1);
299: lv_token varchar2(4000);
300: --Added by Sanjikum the below 5 variables for bug#5131075(4718907)
301: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
302: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
303: ln_after_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
304: lv_after_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
305: ln_temp_threshold_hdr_id jai_ap_tds_thhold_hdrs.threshold_hdr_id%TYPE;

Line 303: ln_after_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;

299: lv_token varchar2(4000);
300: --Added by Sanjikum the below 5 variables for bug#5131075(4718907)
301: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
302: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
303: ln_after_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
304: lv_after_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
305: ln_temp_threshold_hdr_id jai_ap_tds_thhold_hdrs.threshold_hdr_id%TYPE;
306: ld_ret_accounting_date DATE ; -- bug#5131075(5193852). Added by Lakshmi Gopalsami
307:

Line 395: OPEN c_jai_ap_tds_thhold_slabs( cur_rec.threshold_hdr_id

391: lv_threshold_type := 'CUMULATIVE';
392: ln_effective_inv_amt_after := ln_effective_invoice_amt - cur_rec.taxable_amount;
393:
394: --check if the current amount falls in the cumulative threshold
395: OPEN c_jai_ap_tds_thhold_slabs( cur_rec.threshold_hdr_id
396: , lv_threshold_type
397: , ln_effective_inv_amt_after);
398: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;
399: CLOSE c_jai_ap_tds_thhold_slabs;

Line 398: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;

394: --check if the current amount falls in the cumulative threshold
395: OPEN c_jai_ap_tds_thhold_slabs( cur_rec.threshold_hdr_id
396: , lv_threshold_type
397: , ln_effective_inv_amt_after);
398: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;
399: CLOSE c_jai_ap_tds_thhold_slabs;
400:
401: IF r_jai_ap_tds_thhold_slabs.threshold_slab_id IS NULL
402: THEN

Line 399: CLOSE c_jai_ap_tds_thhold_slabs;

395: OPEN c_jai_ap_tds_thhold_slabs( cur_rec.threshold_hdr_id
396: , lv_threshold_type
397: , ln_effective_inv_amt_after);
398: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;
399: CLOSE c_jai_ap_tds_thhold_slabs;
400:
401: IF r_jai_ap_tds_thhold_slabs.threshold_slab_id IS NULL
402: THEN
403: lv_threshold_type := 'SINGLE';

Line 401: IF r_jai_ap_tds_thhold_slabs.threshold_slab_id IS NULL

397: , ln_effective_inv_amt_after);
398: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;
399: CLOSE c_jai_ap_tds_thhold_slabs;
400:
401: IF r_jai_ap_tds_thhold_slabs.threshold_slab_id IS NULL
402: THEN
403: lv_threshold_type := 'SINGLE';
404: --check if the current amount falls in the single threshold
405: OPEN c_jai_ap_tds_thhold_slabs( cur_rec.threshold_hdr_id

Line 405: OPEN c_jai_ap_tds_thhold_slabs( cur_rec.threshold_hdr_id

401: IF r_jai_ap_tds_thhold_slabs.threshold_slab_id IS NULL
402: THEN
403: lv_threshold_type := 'SINGLE';
404: --check if the current amount falls in the single threshold
405: OPEN c_jai_ap_tds_thhold_slabs( cur_rec.threshold_hdr_id
406: , lv_threshold_type
407: , 99999999999999);
408: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;
409: CLOSE c_jai_ap_tds_thhold_slabs;

Line 408: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;

404: --check if the current amount falls in the single threshold
405: OPEN c_jai_ap_tds_thhold_slabs( cur_rec.threshold_hdr_id
406: , lv_threshold_type
407: , 99999999999999);
408: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;
409: CLOSE c_jai_ap_tds_thhold_slabs;
410: END IF;
411:
412: ln_threshold_slab_id_after := r_jai_ap_tds_thhold_slabs.threshold_slab_id;

Line 409: CLOSE c_jai_ap_tds_thhold_slabs;

405: OPEN c_jai_ap_tds_thhold_slabs( cur_rec.threshold_hdr_id
406: , lv_threshold_type
407: , 99999999999999);
408: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;
409: CLOSE c_jai_ap_tds_thhold_slabs;
410: END IF;
411:
412: ln_threshold_slab_id_after := r_jai_ap_tds_thhold_slabs.threshold_slab_id;
413: END IF; -- IF cur_rec.tds_event = 'INVOICE VALIDATE'

Line 412: ln_threshold_slab_id_after := r_jai_ap_tds_thhold_slabs.threshold_slab_id;

408: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;
409: CLOSE c_jai_ap_tds_thhold_slabs;
410: END IF;
411:
412: ln_threshold_slab_id_after := r_jai_ap_tds_thhold_slabs.threshold_slab_id;
413: END IF; -- IF cur_rec.tds_event = 'INVOICE VALIDATE'
414:
415: IF (cur_rec.tds_event = 'INVOICE VALIDATE')
416: OR