159:
160: /* Get the statis fnd values for populating into the table */
161: Fnd_File.put_line(Fnd_File.LOG, '** Start of procedure jai_ap_tcs_processing_pkg.generate_tcs_certificates **');
162:
163: ln_user_id := fnd_global.user_id ;
164: ln_last_update_login := fnd_global.login_id ;
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 ;
160: /* Get the statis fnd values for populating into the table */
161: Fnd_File.put_line(Fnd_File.LOG, '** Start of procedure jai_ap_tcs_processing_pkg.generate_tcs_certificates **');
162:
163: ln_user_id := fnd_global.user_id ;
164: ln_last_update_login := fnd_global.login_id ;
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 ;
161: Fnd_File.put_line(Fnd_File.LOG, '** Start of procedure jai_ap_tcs_processing_pkg.generate_tcs_certificates **');
162:
163: ln_user_id := fnd_global.user_id ;
164: ln_last_update_login := fnd_global.login_id ;
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);
162:
163: ln_user_id := fnd_global.user_id ;
164: ln_last_update_login := fnd_global.login_id ;
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) ;
163: ln_user_id := fnd_global.user_id ;
164: ln_last_update_login := fnd_global.login_id ;
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 ;
164: ln_last_update_login := fnd_global.login_id ;
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: