105: l_payroll_action_id :=p_payroll_action_id;
106:
107: END IF;
108:
109: hr_utility.set_location('Entered Procedure GETDATA',10);
110:
111:
112: OPEN csr_tetr_footer_rpt( l_payroll_action_id);
113: FETCH csr_tetr_footer_rpt INTO rg_tetr_footer_rpt;
250: l_counter := l_counter + 1;
251:
252: END LOOP;
253:
254: hr_utility.set_location('After populating pl/sql table',30);
255:
256:
257: WritetoCLOB (p_xml );
258:
278: l_IANA_charset VARCHAR2 (50);
279:
280: BEGIN
281: l_IANA_charset :=hr_se_utility.get_IANA_charset ;
282: hr_utility.set_location('Entering WritetoCLOB ',70);
283: l_str1 := '
284: l_str2 := '<';
285: l_str3 := '>';
286: l_str4 := '';
355: END IF;
356:
357: p_xfdf_clob := l_xfdf_string;
358:
359: hr_utility.set_location('Leaving WritetoCLOB ',40);
360:
361: EXCEPTION
362: WHEN OTHERS then
363: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
359: hr_utility.set_location('Leaving WritetoCLOB ',40);
360:
361: EXCEPTION
362: WHEN OTHERS then
363: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
364: HR_UTILITY.RAISE_ERROR;
365: END WritetoCLOB;
366: -------------------------------------------------------------------------------------------------------------------------
367:
360:
361: EXCEPTION
362: WHEN OTHERS then
363: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
364: HR_UTILITY.RAISE_ERROR;
365: END WritetoCLOB;
366: -------------------------------------------------------------------------------------------------------------------------
367:
368: END PAY_SE_TETR;