APPS.JAI_AP_TCS_PROCESSING_PKG dependencies on JAI_RGM_CERTIFICATES

Line 115: SELECT jai_rgm_certificates_s.nextval

111: AND fin_yr = pn_fin_year
112: AND REGIME_CODE = pv_regime_code;
113:
114: CURSOR c_get_certificate_id is
115: SELECT jai_rgm_certificates_s.nextval
116: FROM dual;
117:
118: CURSOR cur_regime_id(cp_regime_code VARCHAR2) IS
119: SELECT regime_id

Line 255: /* insert into JAI_RGM_CERTIFICATES */

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));
257:
258: INSERT INTO
259: jai_rgm_certificates( CERTIFICATE_ID ,

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

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));
257:
258: INSERT INTO
259: jai_rgm_certificates( CERTIFICATE_ID ,
260: CERTIFICATE_NUM ,

Line 259: jai_rgm_certificates( CERTIFICATE_ID ,

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));
257:
258: INSERT INTO
259: jai_rgm_certificates( CERTIFICATE_ID ,
260: CERTIFICATE_NUM ,
261: CERTIFICATE_DATE ,
262: PARTY_TYPE ,
263: PARTY_ID ,