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: Future Dependencies For the release Of this Object:-
39: (Please add a row in the section below only if your bug introduces a dependency due to spec change/ A new call to a object/

Line 104: CURSOR c_jai_ap_tds_cert_nums(pv_org_tan_num VARCHAR2,

100: jrr.party_site_id,
101: jrs.tax_authority_id,
102: jrs.tax_authority_site_id;
103:
104: CURSOR c_jai_ap_tds_cert_nums(pv_org_tan_num VARCHAR2,
105: pn_fin_year NUMBER ,
106: pv_regime_code VARCHAR2)
107: IS
108: SELECT nvl(certificate_num, 0) + 1

Line 109: FROM jai_ap_tds_cert_nums

105: pn_fin_year NUMBER ,
106: pv_regime_code VARCHAR2)
107: IS
108: SELECT nvl(certificate_num, 0) + 1
109: FROM jai_ap_tds_cert_nums
110: WHERE org_tan_num = pv_org_tan_num
111: AND fin_yr = pn_fin_year
112: AND REGIME_CODE = pv_regime_code;
113:

Line 123: ln_certificate_num jai_ap_tds_cert_nums.certificate_num%type;

119: SELECT regime_id
120: FROM JAI_RGM_DEFINITIONS
121: WHERE regime_code = cp_regime_code;
122:
123: ln_certificate_num jai_ap_tds_cert_nums.certificate_num%type;
124: ln_certificate_id number;
125: ln_regime_id NUMBER;
126:
127: ln_program_id number;

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

172: loop
173:
174: /* Get certificate number */
175: ln_certificate_num := null;
176: OPEN c_jai_ap_tds_cert_nums(pv_org_tan_num, cur_rec.fin_year,jai_constants.tcs_regime);
177: FETCH c_jai_ap_tds_cert_nums into ln_certificate_num;
178: CLOSE c_jai_ap_tds_cert_nums;
179:
180: IF ln_certificate_num IS NULL THEN

Line 177: FETCH c_jai_ap_tds_cert_nums into ln_certificate_num;

173:
174: /* Get certificate number */
175: ln_certificate_num := null;
176: OPEN c_jai_ap_tds_cert_nums(pv_org_tan_num, cur_rec.fin_year,jai_constants.tcs_regime);
177: FETCH c_jai_ap_tds_cert_nums into ln_certificate_num;
178: CLOSE c_jai_ap_tds_cert_nums;
179:
180: IF ln_certificate_num IS NULL THEN
181: ln_certificate_num := 1;

Line 178: CLOSE c_jai_ap_tds_cert_nums;

174: /* Get certificate number */
175: ln_certificate_num := null;
176: OPEN c_jai_ap_tds_cert_nums(pv_org_tan_num, cur_rec.fin_year,jai_constants.tcs_regime);
177: FETCH c_jai_ap_tds_cert_nums into ln_certificate_num;
178: CLOSE c_jai_ap_tds_cert_nums;
179:
180: IF ln_certificate_num IS NULL THEN
181: ln_certificate_num := 1;
182: END IF;

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

212: Fnd_File.put_line(Fnd_File.LOG, ' No of Records for the Certificate : ' || to_char(sql%rowcount) );
213: ln_certificate_count := ln_certificate_count + 1;
214:
215: if ln_certificate_num = 1 then
216: Fnd_File.put_line(Fnd_File.LOG, 'Created a certificate record in jai_ap_tds_cert_nums');
217: insert into jai_ap_tds_cert_nums
218: (
219: FIN_YR_CERT_ID , -- Date 22/06/2007 by sacsethi for bug 6144923
220: regime_code ,

Line 217: insert into jai_ap_tds_cert_nums

213: ln_certificate_count := ln_certificate_count + 1;
214:
215: if ln_certificate_num = 1 then
216: Fnd_File.put_line(Fnd_File.LOG, 'Created a certificate record in jai_ap_tds_cert_nums');
217: insert into jai_ap_tds_cert_nums
218: (
219: FIN_YR_CERT_ID , -- Date 22/06/2007 by sacsethi for bug 6144923
220: regime_code ,
221: org_tan_num ,

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

228: last_update_login
229: )
230: values
231: (
232: JAI_AP_TDS_CERT_NUMS_S.NEXTVAL , -- Date 22/06/2007 by sacsethi for bug 6144923
233: jai_constants.tcs_regime,
234: pv_org_tan_num ,
235: cur_rec.fin_year ,
236: 1 ,

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

243:
244: else
245:
246:
247: Fnd_File.put_line(Fnd_File.LOG, 'Updated certificate number in jai_ap_tds_cert_nums');
248: update jai_ap_tds_cert_nums
249: set certificate_num = ln_certificate_num
250: where org_tan_num = pv_org_tan_num
251: and fin_yr = cur_rec.fin_year

Line 248: update jai_ap_tds_cert_nums

244: else
245:
246:
247: Fnd_File.put_line(Fnd_File.LOG, 'Updated certificate number in jai_ap_tds_cert_nums');
248: update jai_ap_tds_cert_nums
249: set certificate_num = ln_certificate_num
250: where org_tan_num = pv_org_tan_num
251: and fin_yr = cur_rec.fin_year
252: and regime_code = jai_constants.tcs_regime;