APPS.PER_INC_BUS dependencies on PER_ALL_PEOPLE_F

Line 585: -- it exists in per_all_people_f on the effective_date.

581: --
582: -- Desciption :
583: --
584: -- Validate that on insert PERSON_ID is not null and that
585: -- it exists in per_all_people_f on the effective_date.
586: --
587: --
588: -- Pre-conditions :
589: --

Line 1782: -- person_reported_by exists in per_all_people_f on the report_date.

1778: --
1779: -- Desciption :
1780: --
1781: -- Validate that report_date does not pre-date incident_date and that
1782: -- person_reported_by exists in per_all_people_f on the report_date.
1783: -- Error if incident date and report date are the same
1784: -- and report time is earlier than incident time.
1785: --
1786: -- Pre-conditions :

Line 1818: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

1814: ,p_incident_time in per_work_incidents.incident_time%TYPE
1815: ,p_person_reported_by in per_work_incidents.person_reported_by%TYPE
1816: ,p_report_date in per_work_incidents.report_date%TYPE
1817: ,p_report_time in per_work_incidents.report_time%TYPE
1818: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1819: ,p_object_version_number in per_work_incidents.object_version_number%TYPE
1820: ) is
1821: --
1822: cursor c_person is

Line 1824: from per_all_people_f paf

1820: ) is
1821: --
1822: cursor c_person is
1823: select null
1824: from per_all_people_f paf
1825: where paf.person_id = p_person_reported_by
1826: and paf.business_group_id = p_business_group_id
1827: and nvl(p_report_date, paf.effective_start_date)
1828: between paf.effective_start_date and paf.effective_end_date;

Line 1972: -- NOTIFIED_HSREP_ID exists in PER_ALL_PEOPLE_F.PERSON_ID on the NOTIFIED_HSREP_DATE

1968: --
1969: -- Desciption :
1970: --
1971: -- Validate that NOTIFIED_HSREP_DATE does not pre-date INCIDENT_DATE and that
1972: -- NOTIFIED_HSREP_ID exists in PER_ALL_PEOPLE_F.PERSON_ID on the NOTIFIED_HSREP_DATE
1973: -- and business group of the person with the incident.
1974: -- Ensure the NOTIFIED_HSREP_DATE is null if NOTIFIED_HSREP_ID is null.
1975: --
1976: -- Pre-conditions :

Line 2002: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

1998: (p_incident_id in per_work_incidents.incident_id%TYPE
1999: ,p_incident_date in per_work_incidents.incident_date%TYPE
2000: ,p_notified_hsrep_id in per_work_incidents.notified_hsrep_id%TYPE
2001: ,p_notified_hsrep_date in per_work_incidents.notified_hsrep_date%TYPE
2002: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2003: ,p_object_version_number in per_work_incidents.object_version_number%TYPE
2004: ) is
2005: --
2006: cursor c_person is

Line 2008: from per_all_people_f paf

2004: ) is
2005: --
2006: cursor c_person is
2007: select null
2008: from per_all_people_f paf
2009: where paf.person_id = p_notified_hsrep_id
2010: and paf.business_group_id = p_business_group_id
2011: and nvl(p_notified_hsrep_date, paf.effective_start_date)
2012: between paf.effective_start_date and paf.effective_end_date;

Line 2080: -- Validate that NOTIFIED_HSREP_ID exists in PER_ALL_PEOPLE_F.PERSON_ID for

2076: -- Description :
2077: -- Validate that NOTIFIED_REP_ORG_ID is valid external organization for the
2078: -- org_class 'REPBODY' and business group on the NOTIFIED_HSREP_DATE.
2079: --
2080: -- Validate that NOTIFIED_HSREP_ID exists in PER_ALL_PEOPLE_F.PERSON_ID for
2081: -- the business_group on the NOTIFIED_HSREP_DATE. The NOTIFIED_HSREP_ID
2082: -- should have the role of representative body, for the NOTIFIED_REP_ORG_ID
2083: -- representative body on the NOTIFIED_HSREP_DATE.
2084: --

Line 2117: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

2113: ,p_incident_date in per_work_incidents.incident_date%TYPE
2114: ,p_notified_rep_org_id in per_work_incidents.notified_rep_org_id%TYPE
2115: ,p_notified_rep_id in per_work_incidents.notified_rep_id%TYPE
2116: ,p_notified_rep_date in per_work_incidents.notified_rep_date%TYPE
2117: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2118: ,p_object_version_number in per_work_incidents.object_version_number%TYPE
2119: ) is
2120: --
2121: -- get valid organizations with class of rep body.

Line 2142: from per_all_people_f paf, per_roles rol

2138: -- on the report date.
2139: --
2140: cursor c_person is
2141: select null
2142: from per_all_people_f paf, per_roles rol
2143: where paf.person_id = p_notified_rep_id
2144: and paf.business_group_id = p_business_group_id
2145: and paf.person_id = rol.person_id
2146: and rol.organization_id = p_notified_rep_org_id

Line 2671: from per_all_people_f

2667: ) is
2668: --
2669: cursor csr_bg is
2670: select business_group_id
2671: from per_all_people_f
2672: where person_id = p_rec.person_id;
2673: --
2674: l_proc varchar2(72) := g_package||'insert_validate';
2675: l_bg_id per_all_people_f.business_group_id%TYPE;

Line 2675: l_bg_id per_all_people_f.business_group_id%TYPE;

2671: from per_all_people_f
2672: where person_id = p_rec.person_id;
2673: --
2674: l_proc varchar2(72) := g_package||'insert_validate';
2675: l_bg_id per_all_people_f.business_group_id%TYPE;
2676: --
2677: Begin
2678: hr_utility.set_location('Entering:'||l_proc, 5);
2679: --

Line 2887: from per_all_people_f

2883: ) is
2884: --
2885: cursor csr_bg is
2886: select business_group_id
2887: from per_all_people_f
2888: where person_id = p_rec.person_id;
2889: --
2890: l_bg_id per_all_people_f.business_group_id%TYPE;
2891: l_proc varchar2(72) := g_package||'update_validate';

Line 2890: l_bg_id per_all_people_f.business_group_id%TYPE;

2886: select business_group_id
2887: from per_all_people_f
2888: where person_id = p_rec.person_id;
2889: --
2890: l_bg_id per_all_people_f.business_group_id%TYPE;
2891: l_proc varchar2(72) := g_package||'update_validate';
2892: --
2893: Begin
2894: hr_utility.set_location('Entering:'||l_proc, 5);