DBA Data[Home] [Help]

APPS.PAY_DK_PR_LE dependencies on HR_DK_UTILITY

Line 852: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.leg_emp_name) || '';

848: p_xml := p_xml ||'';
849: p_xml := p_xml ||'';
850: p_xml := p_xml ||'';
851: p_xml:=p_xml || '' || csr_rec.report_period || '';
852: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.leg_emp_name) || '';
853: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.payroll_name) || '';
854: p_xml:= p_xml || '';
855: END IF;
856: END IF;

Line 853: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.payroll_name) || '';

849: p_xml := p_xml ||'';
850: p_xml := p_xml ||'';
851: p_xml:=p_xml || '' || csr_rec.report_period || '';
852: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.leg_emp_name) || '';
853: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.payroll_name) || '';
854: p_xml:= p_xml || '';
855: END IF;
856: END IF;
857: IF (csr_rec.leg_emp_id <> l_leg_emp_id AND csr_rec.payroll_id = l_payroll_id) THEN

Line 880: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.leg_emp_name) || '';

876: p_xml:= p_xml || '';
877: p_xml:= p_xml || '';
878: p_xml := p_xml ||'';
879: p_xml:=p_xml || '' || csr_rec.report_period || '';
880: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.leg_emp_name) || '';
881: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.payroll_name) || '';
882: p_xml:= p_xml || '';
883: END IF;
884: END IF;

Line 881: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.payroll_name) || '';

877: p_xml:= p_xml || '';
878: p_xml := p_xml ||'';
879: p_xml:=p_xml || '' || csr_rec.report_period || '';
880: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.leg_emp_name) || '';
881: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.payroll_name) || '';
882: p_xml:= p_xml || '';
883: END IF;
884: END IF;
885:

Line 904: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.leg_emp_name) || '';

900: l_tot_org_ele_ytd := 0;
901: p_xml := p_xml ||'';
902: p_xml := p_xml ||'';
903: p_xml:=p_xml || '' || csr_rec.report_period || '';
904: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.leg_emp_name) || '';
905: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.payroll_name) || '';
906: p_xml:= p_xml || '';
907: END IF;
908: END IF;

Line 905: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.payroll_name) || '';

901: p_xml := p_xml ||'';
902: p_xml := p_xml ||'';
903: p_xml:=p_xml || '' || csr_rec.report_period || '';
904: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.leg_emp_name) || '';
905: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.payroll_name) || '';
906: p_xml:= p_xml || '';
907: END IF;
908: END IF;
909:

Line 915: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.leg_emp_name) || '';

911: p_xml := p_xml ||'';
912: p_xml:= p_xml || '';
913: p_xml := p_xml ||'';
914: p_xml:=p_xml || '' || csr_rec.report_period || '';
915: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.leg_emp_name) || '';
916: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.payroll_name) || '';
917: p_xml:= p_xml || '';
918: END IF;
919:

Line 916: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.payroll_name) || '';

912: p_xml:= p_xml || '';
913: p_xml := p_xml ||'';
914: p_xml:=p_xml || '' || csr_rec.report_period || '';
915: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.leg_emp_name) || '';
916: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.payroll_name) || '';
917: p_xml:= p_xml || '';
918: END IF;
919:
920: IF( l_ele_type_id <> csr_rec.ele_type_id

Line 934: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.ele_name) || '';

930: p_xml:= p_xml || '';
931: p_xml:= p_xml || '';
932: END IF;
933: p_xml:= p_xml || '';
934: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.ele_name) || '';
935: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.org_name) || '';
936: p_xml:=p_xml || '' || csr_rec.date_earned || '';
937: /*Bug fix - 4961779*/
938: /*Bug fix-4961408 As seperate cursor csr_pr_ele_ytd has been written this code is no more required*/

Line 935: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.org_name) || '';

931: p_xml:= p_xml || '';
932: END IF;
933: p_xml:= p_xml || '';
934: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.ele_name) || '';
935: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.org_name) || '';
936: p_xml:=p_xml || '' || csr_rec.date_earned || '';
937: /*Bug fix - 4961779*/
938: /*Bug fix-4961408 As seperate cursor csr_pr_ele_ytd has been written this code is no more required*/
939: /*IF (l_prev_date_earned = csr_rec.date_earned OR l_prev_date_earned = '-999') THEN