165: ln_program_id := fnd_global.conc_program_id ;
166: ln_program_login_id := fnd_global.conc_login_id ;
167: ln_program_application_id := fnd_global.prog_appl_id ;
168: ln_request_id := fnd_global.conc_request_id ;
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);
166: ln_program_login_id := fnd_global.conc_login_id ;
167: ln_program_application_id := fnd_global.prog_appl_id ;
168: ln_request_id := fnd_global.conc_request_id ;
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;