174: l_payroll_action_id :=p_payroll_action_id;
175:
176: END IF;
177:
178: hr_utility.set_location('Entered Procedure GETDATA',10);
179:
180: FOR rg_cwcr_header_rpt IN csr_cwcr_header_rpt( l_payroll_action_id)
181: LOOP
182:
431: l_counter := l_counter + 1;
432:
433: END LOOP;
434:
435: hr_utility.set_location('After populating pl/sql table',30);
436:
437:
438: WritetoCLOB (p_xml );
439:
459: l_IANA_charset VARCHAR2 (50);
460:
461: BEGIN
462: l_IANA_charset :=hr_se_utility.get_IANA_charset ;
463: hr_utility.set_location('Entering WritetoCLOB ',70);
464: l_str1 := '
465: l_str2 := '<';
466: l_str3 := '>';
467: l_str4 := '';
539: END IF;
540:
541: p_xfdf_clob := l_xfdf_string;
542:
543: hr_utility.set_location('Leaving WritetoCLOB ',40);
544:
545: EXCEPTION
546: WHEN OTHERS then
547: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
543: hr_utility.set_location('Leaving WritetoCLOB ',40);
544:
545: EXCEPTION
546: WHEN OTHERS then
547: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
548: HR_UTILITY.RAISE_ERROR;
549: END WritetoCLOB;
550: -------------------------------------------------------------------------------------------------------------------------
551:
544:
545: EXCEPTION
546: WHEN OTHERS then
547: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
548: HR_UTILITY.RAISE_ERROR;
549: END WritetoCLOB;
550: -------------------------------------------------------------------------------------------------------------------------
551:
552: END PAY_SE_CWCR;