APPS.JAI_AP_TCS_PROCESSING_PKG dependencies on JAI_RGM_CERTIFICATES

Line 135: SELECT jai_rgm_certificates_s.nextval

131: AND fin_yr = pn_fin_year
132: AND REGIME_CODE = pv_regime_code;
133:
134: CURSOR c_get_certificate_id is
135: SELECT jai_rgm_certificates_s.nextval
136: FROM dual;
137:
138: CURSOR cur_regime_id(cp_regime_code VARCHAR2) IS
139: SELECT regime_id

Line 277: /* insert into JAI_RGM_CERTIFICATES */

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));
279:
280: INSERT INTO
281: jai_rgm_certificates( CERTIFICATE_ID ,

Line 278: Fnd_File.put_line(Fnd_File.LOG, 'Inserting record in JAI_RGM_CERTIFICATES with certificate_id : ' || to_char(ln_certificate_id));

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));
279:
280: INSERT INTO
281: jai_rgm_certificates( CERTIFICATE_ID ,
282: CERTIFICATE_NUM ,

Line 281: jai_rgm_certificates( CERTIFICATE_ID ,

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));
279:
280: INSERT INTO
281: jai_rgm_certificates( CERTIFICATE_ID ,
282: CERTIFICATE_NUM ,
283: CERTIFICATE_DATE ,
284: PARTY_TYPE ,
285: PARTY_ID ,