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_PROCESSING_PKG dependencies on JAI_AP_TDS_CERT_NUMS

Line 1379: cursor c_jai_ap_tds_cert_nums(pv_org_tan_num varchar2, pn_fin_year number, pv_regime_code VARCHAR2)

1375: WHERE section_type = p_section_type
1376: );/*bduvarag for Bug#5647725*/
1377:
1378:
1379: cursor c_jai_ap_tds_cert_nums(pv_org_tan_num varchar2, pn_fin_year number, pv_regime_code VARCHAR2)
1380: is
1381: select nvl(certificate_num, 0) + 1
1382: from jai_ap_tds_cert_nums
1383: where org_tan_num = pv_org_tan_num

Line 1382: from jai_ap_tds_cert_nums

1378:
1379: cursor c_jai_ap_tds_cert_nums(pv_org_tan_num varchar2, pn_fin_year number, pv_regime_code VARCHAR2)
1380: is
1381: select nvl(certificate_num, 0) + 1
1382: from jai_ap_tds_cert_nums
1383: where org_tan_num = pv_org_tan_num
1384: and fin_yr = pn_fin_year
1385: and regime_code = pv_regime_code/*CSahoo for Bug#5631784*/
1386: ;

Line 1430: ln_certificate_num jai_ap_tds_cert_nums.certificate_num%type;

1426:
1427:
1428: --r_hr_operating_units c_hr_operating_units%rowtype;
1429: r_ja_in_tds_year_info c_ja_in_tds_year_info%rowtype;
1430: ln_certificate_num jai_ap_tds_cert_nums.certificate_num%type;
1431: ln_form16_hdr_id number;
1432:
1433: ln_program_id number;
1434: ln_program_login_id number;

Line 1640: open c_jai_ap_tds_cert_nums(pv_org_tan_num, cur_rec.fin_year, lv_tds_section); /bduvarag for Bug#5647725/ /CSahoo for Bug#5631784/

1636: loop
1637:
1638: /* Get certificate number */
1639: ln_certificate_num := null;
1640: open c_jai_ap_tds_cert_nums(pv_org_tan_num, cur_rec.fin_year, lv_tds_section); /*bduvarag for Bug#5647725*/ /*CSahoo for Bug#5631784*/
1641: fetch c_jai_ap_tds_cert_nums into ln_certificate_num;
1642: close c_jai_ap_tds_cert_nums;
1643:
1644: if ln_certificate_num is null then

Line 1641: fetch c_jai_ap_tds_cert_nums into ln_certificate_num;

1637:
1638: /* Get certificate number */
1639: ln_certificate_num := null;
1640: open c_jai_ap_tds_cert_nums(pv_org_tan_num, cur_rec.fin_year, lv_tds_section); /*bduvarag for Bug#5647725*/ /*CSahoo for Bug#5631784*/
1641: fetch c_jai_ap_tds_cert_nums into ln_certificate_num;
1642: close c_jai_ap_tds_cert_nums;
1643:
1644: if ln_certificate_num is null then
1645: ln_certificate_num := 1;

Line 1642: close c_jai_ap_tds_cert_nums;

1638: /* Get certificate number */
1639: ln_certificate_num := null;
1640: open c_jai_ap_tds_cert_nums(pv_org_tan_num, cur_rec.fin_year, lv_tds_section); /*bduvarag for Bug#5647725*/ /*CSahoo for Bug#5631784*/
1641: fetch c_jai_ap_tds_cert_nums into ln_certificate_num;
1642: close c_jai_ap_tds_cert_nums;
1643:
1644: if ln_certificate_num is null then
1645: ln_certificate_num := 1;
1646: end if;

Line 1693: Fnd_File.put_line(Fnd_File.LOG, 'Created a certificate record in jai_ap_tds_cert_nums');

1689: Fnd_File.put_line(Fnd_File.LOG, ' No of Records for the Certificate : ' || to_char(sql%rowcount) );
1690: ln_certificate_count := ln_certificate_count + 1;
1691:
1692: if ln_certificate_num = 1 then
1693: Fnd_File.put_line(Fnd_File.LOG, 'Created a certificate record in jai_ap_tds_cert_nums');
1694: insert into jai_ap_tds_cert_nums
1695: (
1696: fin_yr_cert_id ,
1697: regime_code ,

Line 1694: insert into jai_ap_tds_cert_nums

1690: ln_certificate_count := ln_certificate_count + 1;
1691:
1692: if ln_certificate_num = 1 then
1693: Fnd_File.put_line(Fnd_File.LOG, 'Created a certificate record in jai_ap_tds_cert_nums');
1694: insert into jai_ap_tds_cert_nums
1695: (
1696: fin_yr_cert_id ,
1697: regime_code ,
1698: org_tan_num ,

Line 1709: jai_ap_tds_cert_nums_s.nextval, /Bgowrava for Bug#6129650/

1705: last_update_login
1706: )
1707: values
1708: (
1709: jai_ap_tds_cert_nums_s.nextval, /*Bgowrava for Bug#6129650*/
1710: lv_tds_section ,/*bduvarag for Bug#5647725*/ /*CSahoo for BUG#5631784*/
1711: pv_org_tan_num ,
1712: cur_rec.fin_year ,
1713: 1 ,

Line 1723: Fnd_File.put_line(Fnd_File.LOG, 'Updated certificate number in jai_ap_tds_cert_nums');

1719: );
1720:
1721: else
1722:
1723: Fnd_File.put_line(Fnd_File.LOG, 'Updated certificate number in jai_ap_tds_cert_nums');
1724: update jai_ap_tds_cert_nums
1725: set certificate_num = ln_certificate_num
1726: where org_tan_num = pv_org_tan_num
1727: and fin_yr = cur_rec.fin_year

Line 1724: update jai_ap_tds_cert_nums

1720:
1721: else
1722:
1723: Fnd_File.put_line(Fnd_File.LOG, 'Updated certificate number in jai_ap_tds_cert_nums');
1724: update jai_ap_tds_cert_nums
1725: set certificate_num = ln_certificate_num
1726: where org_tan_num = pv_org_tan_num
1727: and fin_yr = cur_rec.fin_year
1728: and regime_code = lv_tds_section/*bduvarag for Bug#5647725*/ /*CSahoo for BUG#5631784*/