[Home] [Help]
169: ld_from_date := fnd_date.canonical_to_date(pd_rgm_from_date);
170: ld_to_date := fnd_date.canonical_to_date(pd_rgm_to_date) ;
171: ln_certificate_count := 0 ;
172:
173: OPEN cur_regime_id(jai_constants.tcs_regime);
174: FETCH cur_regime_id INTO ln_regime_id;
175: CLOSE cur_regime_id;
176:
177: /* Group for TCS Certificates */
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
216: AND jrr.source_document_date BETWEEN ld_from_date and ld_to_date
217: AND jrr.certificate_id IS NULL
218: AND jrs.tax_authority_id = cur_rec.tax_authority_id
219: AND jrs.tax_authority_site_id = cur_rec.tax_authority_site_id
220: AND jrr.party_type = jai_constants.party_type_customer
221: AND jrr.party_id = cur_rec.party_id
222: AND jrr.party_site_id = cur_rec.party_site_id
223: AND jrr.org_tan_no = cur_rec.org_tan_no
224: AND jrr.fin_year = cur_rec.fin_year
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 ,
259: ln_user_id ,
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;
275: end if;
276:
277: /* insert into JAI_RGM_CERTIFICATES */
278: Fnd_File.put_line(Fnd_File.LOG, 'Inserting record in JAI_RGM_CERTIFICATES with certificate_id : ' || to_char(ln_certificate_id));
306: LAST_UPDATE_LOGIN )
307: VALUES( ln_certificate_id ,
308: ln_certificate_num ,
309: trunc(sysdate) ,
310: jai_constants.party_type_customer ,
311: cur_rec.party_id ,
312: cur_rec.party_site_id ,
313: ln_regime_id,
314: cur_rec.tax_authority_id ,