DBA Data[Home] [Help]

APPS.PAY_DK_PR_ORG dependencies on HR_DK_UTILITY

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

806: l_tot_org_ytd := 0;
807: p_xml := p_xml ||'';
808: p_xml := p_xml ||'';
809: p_xml:=p_xml || '' || csr_rec.report_period || '';
810: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.org_name) || '';
811: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.payroll_name) || '';
812: p_xml:= p_xml || '';
813: END IF;
814: END IF;

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

807: p_xml := p_xml ||'';
808: p_xml := p_xml ||'';
809: p_xml:=p_xml || '' || csr_rec.report_period || '';
810: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.org_name) || '';
811: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.payroll_name) || '';
812: p_xml:= p_xml || '';
813: END IF;
814: END IF;
815:

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

815:
816: IF (csr_pr_org%ROWCOUNT = 1) THEN
817: p_xml := p_xml ||'';
818: p_xml:=p_xml || '' || csr_rec.report_period || '';
819: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.org_name) || '';
820: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.payroll_name) || '';
821: p_xml:= p_xml || '';
822: END IF;
823:

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

816: IF (csr_pr_org%ROWCOUNT = 1) THEN
817: p_xml := p_xml ||'';
818: p_xml:=p_xml || '' || csr_rec.report_period || '';
819: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.org_name) || '';
820: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.payroll_name) || '';
821: p_xml:= p_xml || '';
822: END IF;
823:
824: IF( l_ele_type_id <> csr_rec.ele_type_id AND csr_rec.payroll_id = l_payroll_id) THEN

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

831: p_xml:= p_xml || '';
832: p_xml:= p_xml || '';
833: end IF;
834: p_xml:= p_xml || '';
835: p_xml:=p_xml || '' || hr_dk_utility.REPLACE_SPECIAL_CHARS(csr_rec.ele_name) || '';
836: p_xml:=p_xml || '' || csr_rec.date_earned || '';
837: p_xml:=p_xml || '' || NVL(csr_rec.costed_code,' ') || '';
838: p_xml:=p_xml || '' || NVL(TRIM(TO_CHAR(ROUND(csr_rec.pay_value,2),'999G999G990D99')),' ')|| '';
839: p_xml:=p_xml || '' || NVL(TRIM(TO_CHAR(ROUND(csr_rec.balance_amount,2),'999G999G990D99')),' ') || '';