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_THHOLD_SLABS

Line 450: Fix: Uncommented the use of cursor c_get_threshold in cursor for loop c_for_each_tds_section. Also assigned null to r_jai_ap_tds_thhold_slabs before opening cursor c_jai_ap_tds_thhold_slabs

446: Fix: Commented the condition of p_match_status_flag before checking for Holds in procedure status_update_chk_validate
447:
448: 65. 12-Mar-2013 mmurtuza for bug 16435622
449: Description: INDIA - TDS PAYMENT REVIEW DOES NOT RESTRICT THE DATA BASED ON SECTION CODE
450: Fix: Uncommented the use of cursor c_get_threshold in cursor for loop c_for_each_tds_section. Also assigned null to r_jai_ap_tds_thhold_slabs before opening cursor c_jai_ap_tds_thhold_slabs
451:
452: ---------------------------------------------------------------------------- */
453: /*Added Procedure below for Xiao for Bug#7154864*/
454: /*Added pn_section_type parameter to get_prepay_invoice_amt - Bug 11070443*/

Line 897: cursor c_jai_ap_tds_thhold_slabs

893: from jai_ap_tds_thhold_grps
894: where threshold_grp_id = p_threshold_grp_id;
895:
896:
897: cursor c_jai_ap_tds_thhold_slabs
898: ( p_threshold_hdr_id number, p_threshold_type varchar2, p_amount number) is
899: select threshold_slab_id, threshold_type_id, from_amount, to_amount
900: from jai_ap_tds_thhold_slabs
901: where threshold_hdr_id = p_threshold_hdr_id

Line 900: from jai_ap_tds_thhold_slabs

896:
897: cursor c_jai_ap_tds_thhold_slabs
898: ( p_threshold_hdr_id number, p_threshold_type varchar2, p_amount number) is
899: select threshold_slab_id, threshold_type_id, from_amount, to_amount
900: from jai_ap_tds_thhold_slabs
901: where threshold_hdr_id = p_threshold_hdr_id
902: and threshold_type_id in
903: ( select threshold_type_id
904: from jai_ap_tds_thhold_types

Line 1023: from jai_ap_tds_thhold_slabs jatts,

1019: select jatts.from_amount from_amount,
1020: jatts.tax_rate tax_rate,
1021: jattt.tax_id tax_id,
1022: (jitc.tax_rate-(nvl(jitc.surcharge_rate,0) + nvl(jitc.cess_rate,0) + nvl(jitc.sh_cess_rate,0))) tax_rate_orig
1023: from jai_ap_tds_thhold_slabs jatts,
1024: jai_ap_tds_thhold_taxes jattt,
1025: jai_cmn_taxes_all jitc
1026: where jatts.threshold_slab_id = jattt.threshold_slab_id
1027: and jattt.tax_id = jitc.tax_id

Line 1114: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%rowtype;

1110: ln_tax_amount number;
1111: ln_threshold_grp_id number;
1112: lv_vendor_type_lookup_code po_vendors.vendor_type_lookup_code%type;
1113: ln_threshold_hdr_id number;
1114: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%rowtype;
1115: ln_total_invoice_amount number;
1116: ln_threshold_slab_id_before number;
1117: ln_threshold_slab_id_after number;
1118: ln_threshold_slab_id_single number;

Line 1485: r_jai_ap_tds_thhold_slabs := null; /Added by mmurtuza for bug 16435622/

1481:
1482: /* Get the threshold position before this invoice impact */
1483: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */
1484:
1485: r_jai_ap_tds_thhold_slabs := null; /*Added by mmurtuza for bug 16435622*/
1486:
1487: open c_jai_ap_tds_thhold_slabs(ln_threshold_hdr_id , 'CUMULATIVE' , ln_total_invoice_amount);
1488: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;
1489: close c_jai_ap_tds_thhold_slabs;

Line 1487: open c_jai_ap_tds_thhold_slabs(ln_threshold_hdr_id , 'CUMULATIVE' , ln_total_invoice_amount);

1483: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */
1484:
1485: r_jai_ap_tds_thhold_slabs := null; /*Added by mmurtuza for bug 16435622*/
1486:
1487: open c_jai_ap_tds_thhold_slabs(ln_threshold_hdr_id , 'CUMULATIVE' , ln_total_invoice_amount);
1488: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;
1489: close c_jai_ap_tds_thhold_slabs;
1490:
1491: ln_threshold_slab_id_before := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);

Line 1488: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;

1484:
1485: r_jai_ap_tds_thhold_slabs := null; /*Added by mmurtuza for bug 16435622*/
1486:
1487: open c_jai_ap_tds_thhold_slabs(ln_threshold_hdr_id , 'CUMULATIVE' , ln_total_invoice_amount);
1488: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;
1489: close c_jai_ap_tds_thhold_slabs;
1490:
1491: ln_threshold_slab_id_before := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);
1492:

Line 1489: close c_jai_ap_tds_thhold_slabs;

1485: r_jai_ap_tds_thhold_slabs := null; /*Added by mmurtuza for bug 16435622*/
1486:
1487: open c_jai_ap_tds_thhold_slabs(ln_threshold_hdr_id , 'CUMULATIVE' , ln_total_invoice_amount);
1488: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;
1489: close c_jai_ap_tds_thhold_slabs;
1490:
1491: ln_threshold_slab_id_before := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);
1492:
1493: fnd_file.put_line(FND_FILE.LOG, '15. Threshold slab id before '||

Line 1491: ln_threshold_slab_id_before := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);

1487: open c_jai_ap_tds_thhold_slabs(ln_threshold_hdr_id , 'CUMULATIVE' , ln_total_invoice_amount);
1488: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;
1489: close c_jai_ap_tds_thhold_slabs;
1490:
1491: ln_threshold_slab_id_before := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);
1492:
1493: fnd_file.put_line(FND_FILE.LOG, '15. Threshold slab id before '||
1494: ln_threshold_slab_id_before);
1495:

Line 1499: r_jai_ap_tds_thhold_slabs := null;

1495:
1496: /* Get the threshold position after this invoice impact */
1497: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */
1498: /* FP Bug 6345725 - Removed the assignments for p_codepath without ja_in_general_pkg*/
1499: r_jai_ap_tds_thhold_slabs := null;
1500: open c_jai_ap_tds_thhold_slabs
1501: (ln_threshold_hdr_id , 'CUMULATIVE' , ln_total_invoice_amount + cur_rec_section.invoice_amount);
1502: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;
1503: close c_jai_ap_tds_thhold_slabs;

Line 1500: open c_jai_ap_tds_thhold_slabs

1496: /* Get the threshold position after this invoice impact */
1497: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */
1498: /* FP Bug 6345725 - Removed the assignments for p_codepath without ja_in_general_pkg*/
1499: r_jai_ap_tds_thhold_slabs := null;
1500: open c_jai_ap_tds_thhold_slabs
1501: (ln_threshold_hdr_id , 'CUMULATIVE' , ln_total_invoice_amount + cur_rec_section.invoice_amount);
1502: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;
1503: close c_jai_ap_tds_thhold_slabs;
1504:

Line 1502: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;

1498: /* FP Bug 6345725 - Removed the assignments for p_codepath without ja_in_general_pkg*/
1499: r_jai_ap_tds_thhold_slabs := null;
1500: open c_jai_ap_tds_thhold_slabs
1501: (ln_threshold_hdr_id , 'CUMULATIVE' , ln_total_invoice_amount + cur_rec_section.invoice_amount);
1502: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;
1503: close c_jai_ap_tds_thhold_slabs;
1504:
1505: ln_threshold_slab_id_after := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);
1506:

Line 1503: close c_jai_ap_tds_thhold_slabs;

1499: r_jai_ap_tds_thhold_slabs := null;
1500: open c_jai_ap_tds_thhold_slabs
1501: (ln_threshold_hdr_id , 'CUMULATIVE' , ln_total_invoice_amount + cur_rec_section.invoice_amount);
1502: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;
1503: close c_jai_ap_tds_thhold_slabs;
1504:
1505: ln_threshold_slab_id_after := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);
1506:
1507: /*start addition for FP bug 6345725 - check for active slabs. if there are no active*/

Line 1505: ln_threshold_slab_id_after := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);

1501: (ln_threshold_hdr_id , 'CUMULATIVE' , ln_total_invoice_amount + cur_rec_section.invoice_amount);
1502: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;
1503: close c_jai_ap_tds_thhold_slabs;
1504:
1505: ln_threshold_slab_id_after := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);
1506:
1507: /*start addition for FP bug 6345725 - check for active slabs. if there are no active*/
1508: /*slabs throw an error message*/
1509: /*ln_check_slab_exists := NULL;

Line 1540: r_jai_ap_tds_thhold_slabs := null;

1536:
1537: /* Check for Single Invoice threshold if cumulative has not been reached */
1538: if lv_generate_all_invoices = 'N' then
1539: /* Cumulative threshold not reached */
1540: r_jai_ap_tds_thhold_slabs := null;
1541: open c_jai_ap_tds_thhold_slabs(ln_threshold_hdr_id , 'SINGLE' , cur_rec_section.invoice_amount);
1542: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;
1543: close c_jai_ap_tds_thhold_slabs;
1544: ln_threshold_slab_id_single := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);

Line 1541: open c_jai_ap_tds_thhold_slabs(ln_threshold_hdr_id , 'SINGLE' , cur_rec_section.invoice_amount);

1537: /* Check for Single Invoice threshold if cumulative has not been reached */
1538: if lv_generate_all_invoices = 'N' then
1539: /* Cumulative threshold not reached */
1540: r_jai_ap_tds_thhold_slabs := null;
1541: open c_jai_ap_tds_thhold_slabs(ln_threshold_hdr_id , 'SINGLE' , cur_rec_section.invoice_amount);
1542: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;
1543: close c_jai_ap_tds_thhold_slabs;
1544: ln_threshold_slab_id_single := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);
1545: end if;

Line 1542: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;

1538: if lv_generate_all_invoices = 'N' then
1539: /* Cumulative threshold not reached */
1540: r_jai_ap_tds_thhold_slabs := null;
1541: open c_jai_ap_tds_thhold_slabs(ln_threshold_hdr_id , 'SINGLE' , cur_rec_section.invoice_amount);
1542: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;
1543: close c_jai_ap_tds_thhold_slabs;
1544: ln_threshold_slab_id_single := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);
1545: end if;
1546:

Line 1543: close c_jai_ap_tds_thhold_slabs;

1539: /* Cumulative threshold not reached */
1540: r_jai_ap_tds_thhold_slabs := null;
1541: open c_jai_ap_tds_thhold_slabs(ln_threshold_hdr_id , 'SINGLE' , cur_rec_section.invoice_amount);
1542: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;
1543: close c_jai_ap_tds_thhold_slabs;
1544: ln_threshold_slab_id_single := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);
1545: end if;
1546:
1547: /* Loop and generate invoices */

Line 1544: ln_threshold_slab_id_single := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);

1540: r_jai_ap_tds_thhold_slabs := null;
1541: open c_jai_ap_tds_thhold_slabs(ln_threshold_hdr_id , 'SINGLE' , cur_rec_section.invoice_amount);
1542: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;
1543: close c_jai_ap_tds_thhold_slabs;
1544: ln_threshold_slab_id_single := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);
1545: end if;
1546:
1547: /* Loop and generate invoices */
1548:

Line 2975: ln_threshold_slab_id_before jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;

2971: r_jai_no_tds_trx_amt c_jai_no_tds_trx_amt%rowtype;
2972: r_sur_already_calc number;
2973: /*END, bgowrava for Bug#8254510*/
2974: /* START, by Bgowrava for Bug#8459564 */
2975: ln_threshold_slab_id_before jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
2976: ln_threshold_slab_id_temp VARCHAR2 (1000);
2977: ln_threshold_slab_id_after jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
2978: ln_taxable_amount jai_ap_tds_thhold_trxs.taxable_amount%TYPE;
2979: ln_pp_tds_not_deducted NUMBER ;

Line 2977: ln_threshold_slab_id_after jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;

2973: /*END, bgowrava for Bug#8254510*/
2974: /* START, by Bgowrava for Bug#8459564 */
2975: ln_threshold_slab_id_before jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
2976: ln_threshold_slab_id_temp VARCHAR2 (1000);
2977: ln_threshold_slab_id_after jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
2978: ln_taxable_amount jai_ap_tds_thhold_trxs.taxable_amount%TYPE;
2979: ln_pp_tds_not_deducted NUMBER ;
2980: ln_thhold_trxn_roll NUMBER ;
2981: /* END, by Bgowrava for Bug#8459564 */

Line 4589: CURSOR c_jai_ap_tds_thhold_slabs( p_threshold_hdr_id NUMBER,

4585: AND pan_no = p_pan_num
4586: AND section_type = p_section_type
4587: AND section_code = p_section_code;
4588:
4589: CURSOR c_jai_ap_tds_thhold_slabs( p_threshold_hdr_id NUMBER,
4590: p_threshold_type VARCHAR2,
4591: p_amount NUMBER)
4592: IS
4593: SELECT threshold_slab_id, threshold_type_id, from_amount, to_amount, tax_rate

Line 4594: FROM jai_ap_tds_thhold_slabs

4590: p_threshold_type VARCHAR2,
4591: p_amount NUMBER)
4592: IS
4593: SELECT threshold_slab_id, threshold_type_id, from_amount, to_amount, tax_rate
4594: FROM jai_ap_tds_thhold_slabs
4595: WHERE threshold_hdr_id = p_threshold_hdr_id
4596: AND threshold_type_id in
4597: ( SELECT threshold_type_id
4598: FROM jai_ap_tds_thhold_types

Line 4609: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%ROWTYPE;

4605: ORDER BY from_amount asc;
4606:
4607: r_get_threshold_grp_dtl c_get_threshold_grp_dtl%ROWTYPE;
4608: ln_effective_invoice_amt NUMBER;
4609: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%ROWTYPE;
4610: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
4611:
4612: BEGIN
4613: IF p_threshold_grp_id IS NULL THEN

Line 4641: OPEN c_jai_ap_tds_thhold_slabs(p_threshold_hdr_id,

4637:
4638: lv_threshold_type := 'CUMULATIVE';
4639:
4640: --check if the current amount falls in the cumulative threshold
4641: OPEN c_jai_ap_tds_thhold_slabs(p_threshold_hdr_id,
4642: lv_threshold_type,
4643: ln_effective_invoice_amt);
4644: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;
4645: CLOSE c_jai_ap_tds_thhold_slabs;

Line 4644: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;

4640: --check if the current amount falls in the cumulative threshold
4641: OPEN c_jai_ap_tds_thhold_slabs(p_threshold_hdr_id,
4642: lv_threshold_type,
4643: ln_effective_invoice_amt);
4644: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;
4645: CLOSE c_jai_ap_tds_thhold_slabs;
4646:
4647: IF r_jai_ap_tds_thhold_slabs.threshold_slab_id IS NULL THEN
4648:

Line 4645: CLOSE c_jai_ap_tds_thhold_slabs;

4641: OPEN c_jai_ap_tds_thhold_slabs(p_threshold_hdr_id,
4642: lv_threshold_type,
4643: ln_effective_invoice_amt);
4644: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;
4645: CLOSE c_jai_ap_tds_thhold_slabs;
4646:
4647: IF r_jai_ap_tds_thhold_slabs.threshold_slab_id IS NULL THEN
4648:
4649: lv_threshold_type := 'SINGLE';

Line 4647: IF r_jai_ap_tds_thhold_slabs.threshold_slab_id IS NULL THEN

4643: ln_effective_invoice_amt);
4644: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;
4645: CLOSE c_jai_ap_tds_thhold_slabs;
4646:
4647: IF r_jai_ap_tds_thhold_slabs.threshold_slab_id IS NULL THEN
4648:
4649: lv_threshold_type := 'SINGLE';
4650:
4651: --check if the current amount falls in the single threshold

Line 4652: OPEN c_jai_ap_tds_thhold_slabs(p_threshold_hdr_id,

4648:
4649: lv_threshold_type := 'SINGLE';
4650:
4651: --check if the current amount falls in the single threshold
4652: OPEN c_jai_ap_tds_thhold_slabs(p_threshold_hdr_id,
4653: lv_threshold_type,
4654: 99999999999999);
4655: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;
4656: CLOSE c_jai_ap_tds_thhold_slabs;

Line 4655: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;

4651: --check if the current amount falls in the single threshold
4652: OPEN c_jai_ap_tds_thhold_slabs(p_threshold_hdr_id,
4653: lv_threshold_type,
4654: 99999999999999);
4655: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;
4656: CLOSE c_jai_ap_tds_thhold_slabs;
4657: END IF;
4658:
4659: p_threshold_slab_id := r_jai_ap_tds_thhold_slabs.threshold_slab_id;

Line 4656: CLOSE c_jai_ap_tds_thhold_slabs;

4652: OPEN c_jai_ap_tds_thhold_slabs(p_threshold_hdr_id,
4653: lv_threshold_type,
4654: 99999999999999);
4655: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;
4656: CLOSE c_jai_ap_tds_thhold_slabs;
4657: END IF;
4658:
4659: p_threshold_slab_id := r_jai_ap_tds_thhold_slabs.threshold_slab_id;
4660: p_threshold_type := lv_threshold_type;

Line 4659: p_threshold_slab_id := r_jai_ap_tds_thhold_slabs.threshold_slab_id;

4655: FETCH c_jai_ap_tds_thhold_slabs INTO r_jai_ap_tds_thhold_slabs;
4656: CLOSE c_jai_ap_tds_thhold_slabs;
4657: END IF;
4658:
4659: p_threshold_slab_id := r_jai_ap_tds_thhold_slabs.threshold_slab_id;
4660: p_threshold_type := lv_threshold_type;
4661:
4662: EXCEPTION
4663: WHEN OTHERS THEN

Line 4694: jai_ap_tds_thhold_slabs b

4690: SELECT b.tax_rate,
4691: b.from_amount,
4692: a.tax_id
4693: FROM jai_ap_tds_thhold_taxes a,
4694: jai_ap_tds_thhold_slabs b
4695: WHERE a.threshold_slab_id = b.threshold_slab_id
4696: AND a.operating_unit_id = p_org_id
4697: AND b.threshold_slab_id = p_threshold_slab_id;
4698: