APPS.JAI_AP_TCS_PROCESSING_PKG dependencies on JAI_CONSTANTS

Line 153: OPEN cur_regime_id(jai_constants.tcs_regime);

149: ld_from_date := fnd_date.canonical_to_date(pd_rgm_from_date);
150: ld_to_date := fnd_date.canonical_to_date(pd_rgm_to_date) ;
151: ln_certificate_count := 0 ;
152:
153: OPEN cur_regime_id(jai_constants.tcs_regime);
154: FETCH cur_regime_id INTO ln_regime_id;
155: CLOSE cur_regime_id;
156:
157: /* Group for TCS Certificates */

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 200: AND jrr.party_type = jai_constants.party_type_customer

196: AND jrr.source_document_date BETWEEN ld_from_date and ld_to_date
197: AND jrr.certificate_id IS NULL
198: AND jrs.tax_authority_id = cur_rec.tax_authority_id
199: AND jrs.tax_authority_site_id = cur_rec.tax_authority_site_id
200: AND jrr.party_type = jai_constants.party_type_customer
201: AND jrr.party_id = cur_rec.party_id
202: AND jrr.party_site_id = cur_rec.party_site_id
203: AND jrr.org_tan_no = cur_rec.org_tan_no
204: AND jrr.fin_year = cur_rec.fin_year

Line 233: jai_constants.tcs_regime,

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 ,
237: ln_user_id ,

Line 252: and regime_code = jai_constants.tcs_regime;

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;
253: end if;
254:
255: /* insert into JAI_RGM_CERTIFICATES */
256: Fnd_File.put_line(Fnd_File.LOG, 'Inserting record in JAI_RGM_CERTIFICATES with certificate_id : ' || to_char(ln_certificate_id));

Line 288: jai_constants.party_type_customer ,

284: LAST_UPDATE_LOGIN )
285: VALUES( ln_certificate_id ,
286: ln_certificate_num ,
287: trunc(sysdate) ,
288: jai_constants.party_type_customer ,
289: cur_rec.party_id ,
290: cur_rec.party_site_id ,
291: ln_regime_id,
292: cur_rec.tax_authority_id ,