139:
140: /* Get the statis fnd values for populating into the table */
141: Fnd_File.put_line(Fnd_File.LOG, '** Start of procedure jai_ap_tcs_processing_pkg.generate_tcs_certificates **');
142:
143: ln_user_id := fnd_global.user_id ;
144: ln_last_update_login := fnd_global.login_id ;
145: ln_program_id := fnd_global.conc_program_id ;
146: ln_program_login_id := fnd_global.conc_login_id ;
147: ln_program_application_id := fnd_global.prog_appl_id ;
140: /* Get the statis fnd values for populating into the table */
141: Fnd_File.put_line(Fnd_File.LOG, '** Start of procedure jai_ap_tcs_processing_pkg.generate_tcs_certificates **');
142:
143: ln_user_id := fnd_global.user_id ;
144: ln_last_update_login := fnd_global.login_id ;
145: ln_program_id := fnd_global.conc_program_id ;
146: ln_program_login_id := fnd_global.conc_login_id ;
147: ln_program_application_id := fnd_global.prog_appl_id ;
148: ln_request_id := fnd_global.conc_request_id ;
141: Fnd_File.put_line(Fnd_File.LOG, '** Start of procedure jai_ap_tcs_processing_pkg.generate_tcs_certificates **');
142:
143: ln_user_id := fnd_global.user_id ;
144: ln_last_update_login := fnd_global.login_id ;
145: ln_program_id := fnd_global.conc_program_id ;
146: ln_program_login_id := fnd_global.conc_login_id ;
147: ln_program_application_id := fnd_global.prog_appl_id ;
148: ln_request_id := fnd_global.conc_request_id ;
149: ld_from_date := fnd_date.canonical_to_date(pd_rgm_from_date);
142:
143: ln_user_id := fnd_global.user_id ;
144: ln_last_update_login := fnd_global.login_id ;
145: ln_program_id := fnd_global.conc_program_id ;
146: ln_program_login_id := fnd_global.conc_login_id ;
147: ln_program_application_id := fnd_global.prog_appl_id ;
148: ln_request_id := fnd_global.conc_request_id ;
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) ;
143: ln_user_id := fnd_global.user_id ;
144: ln_last_update_login := fnd_global.login_id ;
145: ln_program_id := fnd_global.conc_program_id ;
146: ln_program_login_id := fnd_global.conc_login_id ;
147: ln_program_application_id := fnd_global.prog_appl_id ;
148: ln_request_id := fnd_global.conc_request_id ;
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 ;
144: ln_last_update_login := fnd_global.login_id ;
145: ln_program_id := fnd_global.conc_program_id ;
146: ln_program_login_id := fnd_global.conc_login_id ;
147: ln_program_application_id := fnd_global.prog_appl_id ;
148: ln_request_id := fnd_global.conc_request_id ;
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: