DBA Data[Home] [Help]

APPS.PAY_DK_PR_ASG dependencies on HR_DK_UTILITY

Line 903: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.report_period) || '';

899: l_tot_asg_ytd := 0;
900: p_xml:= p_xml || '';
901: END IF;
902: p_xml:= p_xml || '';
903: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.report_period) || '';
904: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.emp_numn) || '';
905: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.ename) || '';
906: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.asg_num) || '';
907: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.job_title) || '';

Line 904: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.emp_numn) || '';

900: p_xml:= p_xml || '';
901: END IF;
902: p_xml:= p_xml || '';
903: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.report_period) || '';
904: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.emp_numn) || '';
905: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.ename) || '';
906: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.asg_num) || '';
907: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.job_title) || '';
908: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.org_name) || '';

Line 905: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.ename) || '';

901: END IF;
902: p_xml:= p_xml || '';
903: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.report_period) || '';
904: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.emp_numn) || '';
905: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.ename) || '';
906: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.asg_num) || '';
907: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.job_title) || '';
908: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.org_name) || '';
909: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.payroll_name) || '';

Line 906: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.asg_num) || '';

902: p_xml:= p_xml || '';
903: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.report_period) || '';
904: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.emp_numn) || '';
905: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.ename) || '';
906: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.asg_num) || '';
907: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.job_title) || '';
908: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.org_name) || '';
909: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.payroll_name) || '';
910: END IF;

Line 907: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.job_title) || '';

903: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.report_period) || '';
904: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.emp_numn) || '';
905: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.ename) || '';
906: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.asg_num) || '';
907: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.job_title) || '';
908: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.org_name) || '';
909: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.payroll_name) || '';
910: END IF;
911:

Line 908: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.org_name) || '';

904: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.emp_numn) || '';
905: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.ename) || '';
906: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.asg_num) || '';
907: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.job_title) || '';
908: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.org_name) || '';
909: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.payroll_name) || '';
910: END IF;
911:
912: IF (csr_asg%ROWCOUNT =1 OR asg_rec.asg_id <> l_asg_id) THEN

Line 909: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.payroll_name) || '';

905: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.ename) || '';
906: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.asg_num) || '';
907: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.job_title) || '';
908: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.org_name) || '';
909: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.payroll_name) || '';
910: END IF;
911:
912: IF (csr_asg%ROWCOUNT =1 OR asg_rec.asg_id <> l_asg_id) THEN
913: p_xml:= p_xml || '';

Line 926: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.ele_name) || '';

922: p_xml:= p_xml || '';
923: p_xml:= p_xml || '';
924: END IF;
925: p_xml:= p_xml || '';
926: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.ele_name) || '';
927: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.date_earned) || '';
928: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(NVL(asg_rec.costed_code,' ')) || '';
929: p_xml:=p_xml || '' || NVL(TRIM(TO_CHAR(ROUND(asg_rec.pay_value,2),'999G999G990D99')),' ')|| '';
930: p_xml:=p_xml || '' || NVL(TRIM(TO_CHAR(ROUND(asg_rec.balance_amount,2),'999G999G990D99')),' ') || '';

Line 927: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.date_earned) || '';

923: p_xml:= p_xml || '';
924: END IF;
925: p_xml:= p_xml || '';
926: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.ele_name) || '';
927: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.date_earned) || '';
928: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(NVL(asg_rec.costed_code,' ')) || '';
929: p_xml:=p_xml || '' || NVL(TRIM(TO_CHAR(ROUND(asg_rec.pay_value,2),'999G999G990D99')),' ')|| '';
930: p_xml:=p_xml || '' || NVL(TRIM(TO_CHAR(ROUND(asg_rec.balance_amount,2),'999G999G990D99')),' ') || '';
931: /*Bug fix - 4961779*/

Line 928: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(NVL(asg_rec.costed_code,' ')) || '';

924: END IF;
925: p_xml:= p_xml || '';
926: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.ele_name) || '';
927: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.date_earned) || '';
928: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(NVL(asg_rec.costed_code,' ')) || '';
929: p_xml:=p_xml || '' || NVL(TRIM(TO_CHAR(ROUND(asg_rec.pay_value,2),'999G999G990D99')),' ')|| '';
930: p_xml:=p_xml || '' || NVL(TRIM(TO_CHAR(ROUND(asg_rec.balance_amount,2),'999G999G990D99')),' ') || '';
931: /*Bug fix - 4961779*/
932: /*IF (l_prev_date_earned = asg_rec.date_earned OR l_prev_date_earned = '-999') THEN