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 1363: cursor c_jai_ap_tds_cert_nums(pv_org_tan_num varchar2, pn_fin_year number, pv_regime_code VARCHAR2)

1359: WHERE section_type = p_section_type
1360: );/*bduvarag for Bug#5647725*/
1361:
1362:
1363: cursor c_jai_ap_tds_cert_nums(pv_org_tan_num varchar2, pn_fin_year number, pv_regime_code VARCHAR2)
1364: is
1365: select nvl(certificate_num, 0) + 1
1366: from jai_ap_tds_cert_nums
1367: where org_tan_num = pv_org_tan_num

Line 1366: from jai_ap_tds_cert_nums

1362:
1363: cursor c_jai_ap_tds_cert_nums(pv_org_tan_num varchar2, pn_fin_year number, pv_regime_code VARCHAR2)
1364: is
1365: select nvl(certificate_num, 0) + 1
1366: from jai_ap_tds_cert_nums
1367: where org_tan_num = pv_org_tan_num
1368: and fin_yr = pn_fin_year
1369: and regime_code = pv_regime_code/*CSahoo for Bug#5631784*/
1370: ;

Line 1402: ln_certificate_num jai_ap_tds_cert_nums.certificate_num%type;

1398:
1399:
1400: --r_hr_operating_units c_hr_operating_units%rowtype;
1401: r_ja_in_tds_year_info c_ja_in_tds_year_info%rowtype;
1402: ln_certificate_num jai_ap_tds_cert_nums.certificate_num%type;
1403: ln_form16_hdr_id number;
1404:
1405: ln_program_id number;
1406: ln_program_login_id number;

Line 1583: 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/

1579: loop
1580:
1581: /* Get certificate number */
1582: ln_certificate_num := null;
1583: 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*/
1584: fetch c_jai_ap_tds_cert_nums into ln_certificate_num;
1585: close c_jai_ap_tds_cert_nums;
1586:
1587: if ln_certificate_num is null then

Line 1584: fetch c_jai_ap_tds_cert_nums into ln_certificate_num;

1580:
1581: /* Get certificate number */
1582: ln_certificate_num := null;
1583: 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*/
1584: fetch c_jai_ap_tds_cert_nums into ln_certificate_num;
1585: close c_jai_ap_tds_cert_nums;
1586:
1587: if ln_certificate_num is null then
1588: ln_certificate_num := 1;

Line 1585: close c_jai_ap_tds_cert_nums;

1581: /* Get certificate number */
1582: ln_certificate_num := null;
1583: 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*/
1584: fetch c_jai_ap_tds_cert_nums into ln_certificate_num;
1585: close c_jai_ap_tds_cert_nums;
1586:
1587: if ln_certificate_num is null then
1588: ln_certificate_num := 1;
1589: end if;

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

1624: Fnd_File.put_line(Fnd_File.LOG, ' No of Records for the Certificate : ' || to_char(sql%rowcount) );
1625: ln_certificate_count := ln_certificate_count + 1;
1626:
1627: if ln_certificate_num = 1 then
1628: Fnd_File.put_line(Fnd_File.LOG, 'Created a certificate record in jai_ap_tds_cert_nums');
1629: insert into jai_ap_tds_cert_nums
1630: (
1631: fin_yr_cert_id ,
1632: regime_code ,

Line 1629: insert into jai_ap_tds_cert_nums

1625: ln_certificate_count := ln_certificate_count + 1;
1626:
1627: if ln_certificate_num = 1 then
1628: Fnd_File.put_line(Fnd_File.LOG, 'Created a certificate record in jai_ap_tds_cert_nums');
1629: insert into jai_ap_tds_cert_nums
1630: (
1631: fin_yr_cert_id ,
1632: regime_code ,
1633: org_tan_num ,

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

1640: last_update_login
1641: )
1642: values
1643: (
1644: jai_ap_tds_cert_nums_s.nextval, /*Bgowrava for Bug#6129650*/
1645: lv_tds_section ,/*bduvarag for Bug#5647725*/ /*CSahoo for BUG#5631784*/
1646: pv_org_tan_num ,
1647: cur_rec.fin_year ,
1648: 1 ,

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

1654: );
1655:
1656: else
1657:
1658: Fnd_File.put_line(Fnd_File.LOG, 'Updated certificate number in jai_ap_tds_cert_nums');
1659: update jai_ap_tds_cert_nums
1660: set certificate_num = ln_certificate_num
1661: where org_tan_num = pv_org_tan_num
1662: and fin_yr = cur_rec.fin_year

Line 1659: update jai_ap_tds_cert_nums

1655:
1656: else
1657:
1658: Fnd_File.put_line(Fnd_File.LOG, 'Updated certificate number in jai_ap_tds_cert_nums');
1659: update jai_ap_tds_cert_nums
1660: set certificate_num = ln_certificate_num
1661: where org_tan_num = pv_org_tan_num
1662: and fin_yr = cur_rec.fin_year
1663: and regime_code = lv_tds_section/*bduvarag for Bug#5647725*/ /*CSahoo for BUG#5631784*/