DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_QH_POPULATE

Line 1765: :=per_qh_populate.get_full_name(asg_rec.recruiter_id,p_effective_date);

1761: hr_utility.set_location(l_proc,775);
1762: --
1763: if asg_rec.recruiter_id is not null then
1764: out_rec.recruiter
1765: :=per_qh_populate.get_full_name(asg_rec.recruiter_id,p_effective_date);
1766: end if;
1767: out_rec.recruiter_id :=asg_rec.recruiter_id;
1768: --
1769: hr_utility.set_location(l_proc,776);

Line 1772: out_rec.grade:=per_qh_populate.get_grade(asg_rec.grade_id);

1768: --
1769: hr_utility.set_location(l_proc,776);
1770: --
1771: if asg_rec.grade_id is not null then
1772: out_rec.grade:=per_qh_populate.get_grade(asg_rec.grade_id);
1773: end if;
1774: out_rec.grade_id :=asg_rec.grade_id;
1775: --
1776: hr_utility.set_location(l_proc,777);

Line 1780: := per_qh_populate.get_grade_ladder(asg_rec.grade_ladder_pgm_id

1776: hr_utility.set_location(l_proc,777);
1777: --
1778: if asg_rec.grade_ladder_pgm_id is not null then
1779: out_rec.grade_ladder
1780: := per_qh_populate.get_grade_ladder(asg_rec.grade_ladder_pgm_id
1781: ,p_effective_date);
1782: end if;
1783: out_rec.grade_ladder_pgm_id := asg_rec.grade_ladder_pgm_id;
1784: --

Line 1789: :=per_qh_populate.get_position(asg_rec.position_id,p_effective_date);

1785: hr_utility.set_location(l_proc,778);
1786: --
1787: if asg_rec.position_id is not null then
1788: out_rec.position
1789: :=per_qh_populate.get_position(asg_rec.position_id,p_effective_date);
1790: end if;
1791: out_rec.position_id :=asg_rec.position_id;
1792: --
1793: hr_utility.set_location(l_proc,779);

Line 1796: out_rec.job:=per_qh_populate.get_job(asg_rec.job_id);

1792: --
1793: hr_utility.set_location(l_proc,779);
1794: --
1795: if asg_rec.job_id is not null then
1796: out_rec.job:=per_qh_populate.get_job(asg_rec.job_id);
1797: end if;
1798: out_rec.job_id :=asg_rec.job_id;
1799: --
1800: hr_utility.set_location(l_proc,780);

Line 1811: per_qh_populate.get_payroll(asg_rec.payroll_id,p_effective_date);

1807: hr_utility.set_location(l_proc,782);
1808: --
1809: if asg_rec.payroll_id is not null then
1810: out_rec.payroll:=
1811: per_qh_populate.get_payroll(asg_rec.payroll_id,p_effective_date);
1812: end if;
1813: out_rec.payroll_id :=asg_rec.payroll_id;
1814: --
1815: hr_utility.set_location(l_proc,785);

Line 1818: out_rec.location:=per_qh_populate.get_location(asg_rec.location_id);

1814: --
1815: hr_utility.set_location(l_proc,785);
1816: --
1817: if asg_rec.location_id is not null then
1818: out_rec.location:=per_qh_populate.get_location(asg_rec.location_id);
1819: out_rec.location_address:=hr_general.hr_lookup_locations(asg_rec.location_id);
1820: end if;
1821: out_rec.location_id :=asg_rec.location_id;
1822: --

Line 1827: per_qh_populate.get_full_name(asg_rec.person_referred_by_id,p_effective_date);

1823: hr_utility.set_location(l_proc,790);
1824: --
1825: if asg_rec.person_referred_by_id is not null then
1826: out_rec.person_referred_by:=
1827: per_qh_populate.get_full_name(asg_rec.person_referred_by_id,p_effective_date);
1828: end if;
1829: out_rec.person_referred_by_id :=asg_rec.person_referred_by_id;
1830: --
1831: hr_utility.set_location(l_proc,800);

Line 1835: per_qh_populate.get_full_name(asg_rec.supervisor_id,p_effective_date);

1831: hr_utility.set_location(l_proc,800);
1832: --
1833: if asg_rec.supervisor_id is not null then
1834: out_rec.supervisor:=
1835: per_qh_populate.get_full_name(asg_rec.supervisor_id,p_effective_date);
1836: end if;
1837: out_rec.supervisor_id :=asg_rec.supervisor_id;
1838: --
1839: hr_utility.set_location(l_proc,805);

Line 1843: per_qh_populate.get_supervisor_assgn_number(

1839: hr_utility.set_location(l_proc,805);
1840: --
1841: if asg_rec.supervisor_assignment_id is not null then
1842: out_rec.supervisor_assignment_number :=
1843: per_qh_populate.get_supervisor_assgn_number(
1844: asg_rec.supervisor_assignment_id,asg_rec.business_group_id);
1845: end if;
1846: out_rec.supervisor_assignment_id := asg_rec.supervisor_assignment_id;
1847: --

Line 1861: :=per_qh_populate.get_organization(asg_rec.source_organization_id);

1857: hr_utility.set_location(l_proc,820);
1858: --
1859: if asg_rec.source_organization_id is not null then
1860: out_rec.source_organization
1861: :=per_qh_populate.get_organization(asg_rec.source_organization_id);
1862: end if;
1863: out_rec.source_organization_id :=asg_rec.source_organization_id;
1864: --
1865: hr_utility.set_location(l_proc,830);

Line 1868: :=per_qh_populate.get_organization(asg_rec.organization_id);

1864: --
1865: hr_utility.set_location(l_proc,830);
1866: --
1867: out_rec.organization
1868: :=per_qh_populate.get_organization(asg_rec.organization_id);
1869: out_rec.organization_id :=asg_rec.organization_id;
1870: --
1871: hr_utility.set_location(l_proc,840);
1872: --

Line 2233: :=per_qh_populate.get_organization(asg_rec.establishment_id);

2229: hr_utility.set_location(l_proc,970);
2230: --
2231: if asg_rec.establishment_id is not null then
2232: out_rec.establishment
2233: :=per_qh_populate.get_organization(asg_rec.establishment_id);
2234: end if;
2235: out_rec.establishment_id :=asg_rec.establishment_id;
2236: --
2237: hr_utility.set_location(l_proc,980);