DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_QH_POPULATE

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

1795: hr_utility.set_location(l_proc,775);
1796: --
1797: if asg_rec.recruiter_id is not null then
1798: out_rec.recruiter
1799: :=per_qh_populate.get_full_name(asg_rec.recruiter_id,p_effective_date);
1800: end if;
1801: out_rec.recruiter_id :=asg_rec.recruiter_id;
1802: --
1803: hr_utility.set_location(l_proc,776);

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

1802: --
1803: hr_utility.set_location(l_proc,776);
1804: --
1805: if asg_rec.grade_id is not null then
1806: out_rec.grade:=per_qh_populate.get_grade(asg_rec.grade_id);
1807: end if;
1808: out_rec.grade_id :=asg_rec.grade_id;
1809: --
1810: hr_utility.set_location(l_proc,777);

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

1810: hr_utility.set_location(l_proc,777);
1811: --
1812: if asg_rec.grade_ladder_pgm_id is not null then
1813: out_rec.grade_ladder
1814: := per_qh_populate.get_grade_ladder(asg_rec.grade_ladder_pgm_id
1815: ,p_effective_date);
1816: end if;
1817: out_rec.grade_ladder_pgm_id := asg_rec.grade_ladder_pgm_id;
1818: --

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

1819: hr_utility.set_location(l_proc,778);
1820: --
1821: if asg_rec.position_id is not null then
1822: out_rec.position
1823: :=per_qh_populate.get_position(asg_rec.position_id,p_effective_date);
1824: end if;
1825: out_rec.position_id :=asg_rec.position_id;
1826: --
1827: hr_utility.set_location(l_proc,779);

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

1826: --
1827: hr_utility.set_location(l_proc,779);
1828: --
1829: if asg_rec.job_id is not null then
1830: out_rec.job:=per_qh_populate.get_job(asg_rec.job_id);
1831: end if;
1832: out_rec.job_id :=asg_rec.job_id;
1833: --
1834: hr_utility.set_location(l_proc,780);

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

1841: hr_utility.set_location(l_proc,782);
1842: --
1843: if asg_rec.payroll_id is not null then
1844: out_rec.payroll:=
1845: per_qh_populate.get_payroll(asg_rec.payroll_id,p_effective_date);
1846: end if;
1847: out_rec.payroll_id :=asg_rec.payroll_id;
1848: --
1849: hr_utility.set_location(l_proc,785);

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

1848: --
1849: hr_utility.set_location(l_proc,785);
1850: --
1851: if asg_rec.location_id is not null then
1852: out_rec.location:=per_qh_populate.get_location(asg_rec.location_id);
1853: out_rec.location_address:=hr_general.hr_lookup_locations(asg_rec.location_id);
1854: end if;
1855: out_rec.location_id :=asg_rec.location_id;
1856: --

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

1857: hr_utility.set_location(l_proc,790);
1858: --
1859: if asg_rec.person_referred_by_id is not null then
1860: out_rec.person_referred_by:=
1861: per_qh_populate.get_full_name(asg_rec.person_referred_by_id,p_effective_date);
1862: end if;
1863: out_rec.person_referred_by_id :=asg_rec.person_referred_by_id;
1864: --
1865: hr_utility.set_location(l_proc,800);

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

1865: hr_utility.set_location(l_proc,800);
1866: --
1867: if asg_rec.supervisor_id is not null then
1868: out_rec.supervisor:=
1869: per_qh_populate.get_full_name(asg_rec.supervisor_id,p_effective_date);
1870: end if;
1871: out_rec.supervisor_id :=asg_rec.supervisor_id;
1872: --
1873: hr_utility.set_location(l_proc,805);

Line 1877: per_qh_populate.get_supervisor_assgn_number(

1873: hr_utility.set_location(l_proc,805);
1874: --
1875: if asg_rec.supervisor_assignment_id is not null then
1876: out_rec.supervisor_assignment_number :=
1877: per_qh_populate.get_supervisor_assgn_number(
1878: asg_rec.supervisor_assignment_id,asg_rec.business_group_id);
1879: end if;
1880: out_rec.supervisor_assignment_id := asg_rec.supervisor_assignment_id;
1881: --

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

1891: hr_utility.set_location(l_proc,820);
1892: --
1893: if asg_rec.source_organization_id is not null then
1894: out_rec.source_organization
1895: :=per_qh_populate.get_organization(asg_rec.source_organization_id);
1896: end if;
1897: out_rec.source_organization_id :=asg_rec.source_organization_id;
1898: --
1899: hr_utility.set_location(l_proc,830);

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

1898: --
1899: hr_utility.set_location(l_proc,830);
1900: --
1901: out_rec.organization
1902: :=per_qh_populate.get_organization(asg_rec.organization_id);
1903: out_rec.organization_id :=asg_rec.organization_id;
1904: --
1905: hr_utility.set_location(l_proc,840);
1906: --

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

2263: hr_utility.set_location(l_proc,970);
2264: --
2265: if asg_rec.establishment_id is not null then
2266: out_rec.establishment
2267: :=per_qh_populate.get_organization(asg_rec.establishment_id);
2268: end if;
2269: out_rec.establishment_id :=asg_rec.establishment_id;
2270: --
2271: hr_utility.set_location(l_proc,980);