25: program => 'LOCCHNREP');
26:
27: select userenv('sessionid')
28: into l_session_id
29: from dual;
30:
31: IF(l_rep_req_id = 0) THEN
32: hr_utility.trace(' Error While Location change Report' );
33: hr_utility.raise_error;
192: hr_utility.trace('Entering :' || l_proc_name);
193:
194: select userenv('sessionid')
195: into l_session_id
196: from dual;
197:
198: INSERT
199: INTO pay_us_rpt_totals
200: (