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

Line 23: JAINTCSC concurrent. A new column regime_code is added to table jai_ap_tds_cert_nums

19: S.No Date Author and Details
20: -------------------------------------------------------------------------------
21: 1 30-JAN-2007 bgowrava for forward porting bug#5631784 (4742259).
22: Created this package for generating TCS Certificates. This is called from
23: JAINTCSC concurrent. A new column regime_code is added to table jai_ap_tds_cert_nums
24: to store the regime_code. This will allow us to use the table for both TDS and
25: TCS. A migration script is prepared to populate the regime_code as TDS for all
26: existing records. Changes in package jai_ap_tds_processing_pkg are made accordingly.
27:

Line 35: Solution - Insert Statement is changed jai_ap_tds_cert_nums , Column FIN_YR_CERT_ID

31: 3. 22-06-2007 sacsethi for bug 6144923 File version - 120.2
32:
33: Problem - R12RUP03-ST1:REPORT NOT AVAILABLE-INDIA - GENERATE TCS CERTIFICATES
34:
35: Solution - Insert Statement is changed jai_ap_tds_cert_nums , Column FIN_YR_CERT_ID
36: is added According to R12 standard.
37:
38: 4. 14-JUL-2009 vkaranam for bug#8679068 120.3.12000000.2
39: Issue:

Line 124: CURSOR c_jai_ap_tds_cert_nums(pv_org_tan_num VARCHAR2,

120: jrs.tax_authority_id,
121: jrs.tax_authority_site_id,
122: jrr.item_classification;
123:
124: CURSOR c_jai_ap_tds_cert_nums(pv_org_tan_num VARCHAR2,
125: pn_fin_year NUMBER ,
126: pv_regime_code VARCHAR2)
127: IS
128: SELECT nvl(certificate_num, 0) + 1

Line 129: FROM jai_ap_tds_cert_nums

125: pn_fin_year NUMBER ,
126: pv_regime_code VARCHAR2)
127: IS
128: SELECT nvl(certificate_num, 0) + 1
129: FROM jai_ap_tds_cert_nums
130: WHERE org_tan_num = pv_org_tan_num
131: AND fin_yr = pn_fin_year
132: AND REGIME_CODE = pv_regime_code;
133:

Line 143: ln_certificate_num jai_ap_tds_cert_nums.certificate_num%type;

139: SELECT regime_id
140: FROM JAI_RGM_DEFINITIONS
141: WHERE regime_code = cp_regime_code;
142:
143: ln_certificate_num jai_ap_tds_cert_nums.certificate_num%type;
144: ln_certificate_id number;
145: ln_regime_id NUMBER;
146:
147: ln_program_id number;

Line 196: OPEN c_jai_ap_tds_cert_nums(pv_org_tan_num, cur_rec.fin_year,jai_constants.tcs_regime);

192: loop
193:
194: /* Get certificate number */
195: ln_certificate_num := null;
196: OPEN c_jai_ap_tds_cert_nums(pv_org_tan_num, cur_rec.fin_year,jai_constants.tcs_regime);
197: FETCH c_jai_ap_tds_cert_nums into ln_certificate_num;
198: CLOSE c_jai_ap_tds_cert_nums;
199:
200: IF ln_certificate_num IS NULL THEN

Line 197: FETCH c_jai_ap_tds_cert_nums into ln_certificate_num;

193:
194: /* Get certificate number */
195: ln_certificate_num := null;
196: OPEN c_jai_ap_tds_cert_nums(pv_org_tan_num, cur_rec.fin_year,jai_constants.tcs_regime);
197: FETCH c_jai_ap_tds_cert_nums into ln_certificate_num;
198: CLOSE c_jai_ap_tds_cert_nums;
199:
200: IF ln_certificate_num IS NULL THEN
201: ln_certificate_num := 1;

Line 198: CLOSE c_jai_ap_tds_cert_nums;

194: /* Get certificate number */
195: ln_certificate_num := null;
196: OPEN c_jai_ap_tds_cert_nums(pv_org_tan_num, cur_rec.fin_year,jai_constants.tcs_regime);
197: FETCH c_jai_ap_tds_cert_nums into ln_certificate_num;
198: CLOSE c_jai_ap_tds_cert_nums;
199:
200: IF ln_certificate_num IS NULL THEN
201: ln_certificate_num := 1;
202: END IF;

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

234: Fnd_File.put_line(Fnd_File.LOG, ' No of Records for the Certificate : ' || to_char(sql%rowcount) );
235: ln_certificate_count := ln_certificate_count + 1;
236:
237: if ln_certificate_num = 1 then
238: Fnd_File.put_line(Fnd_File.LOG, 'Created a certificate record in jai_ap_tds_cert_nums');
239: insert into jai_ap_tds_cert_nums
240: (
241: FIN_YR_CERT_ID , -- Date 22/06/2007 by sacsethi for bug 6144923
242: regime_code ,

Line 239: insert into jai_ap_tds_cert_nums

235: ln_certificate_count := ln_certificate_count + 1;
236:
237: if ln_certificate_num = 1 then
238: Fnd_File.put_line(Fnd_File.LOG, 'Created a certificate record in jai_ap_tds_cert_nums');
239: insert into jai_ap_tds_cert_nums
240: (
241: FIN_YR_CERT_ID , -- Date 22/06/2007 by sacsethi for bug 6144923
242: regime_code ,
243: org_tan_num ,

Line 254: JAI_AP_TDS_CERT_NUMS_S.NEXTVAL , -- Date 22/06/2007 by sacsethi for bug 6144923

250: last_update_login
251: )
252: values
253: (
254: JAI_AP_TDS_CERT_NUMS_S.NEXTVAL , -- Date 22/06/2007 by sacsethi for bug 6144923
255: jai_constants.tcs_regime,
256: pv_org_tan_num ,
257: cur_rec.fin_year ,
258: 1 ,

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

265:
266: else
267:
268:
269: Fnd_File.put_line(Fnd_File.LOG, 'Updated certificate number in jai_ap_tds_cert_nums');
270: update jai_ap_tds_cert_nums
271: set certificate_num = ln_certificate_num
272: where org_tan_num = pv_org_tan_num
273: and fin_yr = cur_rec.fin_year

Line 270: update jai_ap_tds_cert_nums

266: else
267:
268:
269: Fnd_File.put_line(Fnd_File.LOG, 'Updated certificate number in jai_ap_tds_cert_nums');
270: update jai_ap_tds_cert_nums
271: set certificate_num = ln_certificate_num
272: where org_tan_num = pv_org_tan_num
273: and fin_yr = cur_rec.fin_year
274: and regime_code = jai_constants.tcs_regime;