DBA Data[Home] [Help]

APPS.PQH_PA_WHATIF_PROCESS dependencies on BEN_WHATIF_ELIG

Line 1712: ben_whatif_elig.WATIF_ALL_ASSIGNMENTS_F_API(

1708: END IF; --if else ladder
1709: END LOOP;
1710: /*IF C1.api_name= 'PER_ALL_ASSIGNMENTS_F' THEN
1711: --
1712: ben_whatif_elig.WATIF_ALL_ASSIGNMENTS_F_API(
1713: p_person_id => p_person_id
1714: ,p_PAY_BASIS_ID => l_PAY_BASIS_ID
1715: ,p_LABOUR_UNION_MEMBER_FLAG => l_LABOUR_UNION_MEMBER_FLAG
1716: ,p_JOB_ID => l_JOB_ID

Line 1768: ben_whatif_elig.WATIF_ABSENCE_ATTENDANCES_API(

1764: ,p_effective_date => p_effective_date
1765: );*/
1766: IF C1.api_name= 'PER_ABSENCE_ATTENDANCES' THEN
1767: --
1768: ben_whatif_elig.WATIF_ABSENCE_ATTENDANCES_API(
1769: p_person_id => p_person_id
1770: ,p_ABSENCE_ATTENDANCE_TYPE_ID => l_ABSENCE_ATTENDANCE_TYPE_ID
1771: ,p_ABS_ATTENDANCE_REASON_ID => l_ABS_ATTENDANCE_REASON_ID
1772: ,p_DATE_END => l_DATE_END

Line 1781: ben_whatif_elig.WATIF_ADDRESSES_API(

1777: --
1778: ELSIF C1.api_name= 'PER_ADDRESSES' THEN
1779: --
1780:
1781: ben_whatif_elig.WATIF_ADDRESSES_API(
1782: p_person_id => p_person_id
1783: ,p_POSTAL_CODE => l_POSTAL_CODE
1784: ,p_PRIMARY_FLAG => l_PRIMARY_FLAG
1785: ,p_REGION_2 => l_region_2

Line 1795: ben_whatif_elig.WATIF_ALL_ASSIGNMENTS_F_API(

1791:
1792: --
1793: ELSIF C1.api_name= 'PER_ALL_ASSIGNMENTS_F' THEN
1794: --
1795: ben_whatif_elig.WATIF_ALL_ASSIGNMENTS_F_API(
1796: p_person_id => p_person_id
1797: ,p_PAY_BASIS_ID => l_PAY_BASIS_ID
1798: ,p_LABOUR_UNION_MEMBER_FLAG => l_LABOUR_UNION_MEMBER_FLAG
1799: ,p_JOB_ID => l_JOB_ID

Line 1852: ben_whatif_elig.WATIF_ALL_PEOPLE_F_API(

1848: );
1849: --
1850: ELSIF C1.api_name= 'PER_ALL_PEOPLE_F' THEN
1851: --
1852: ben_whatif_elig.WATIF_ALL_PEOPLE_F_API(
1853: p_person_id => p_person_id
1854: ,p_STUDENT_STATUS => l_STUDENT_STATUS
1855: ,p_DATE_OF_DEATH => l_DATE_OF_DEATH
1856: ,p_DATE_OF_BIRTH => l_DATE_OF_BIRTH

Line 1903: ben_whatif_elig.WATIF_CONTACT_RELATIONSHIP_API(

1899: ,p_effective_date => p_effective_date
1900: );
1901: --
1902: ELSIF C1.api_name= 'PER_CONTACT_RELATIONSHIPS' THEN
1903: ben_whatif_elig.WATIF_CONTACT_RELATIONSHIP_API(
1904: p_person_id => p_person_id
1905: ,p_contact_person_id => l_contact_person_id
1906: ,p_DATE_END => l_DATE_END1
1907: ,p_DATE_START => nvl(l_DATE_START1,p_effective_date)

Line 1927: ben_whatif_elig.WATIF_PERIODS_OF_SERVICE_API(

1923: if l_ACTUAL_TERMINATION_DATE is not null then
1924: p_lf_evt_ocrd_dt := l_ACTUAL_TERMINATION_DATE;
1925: end if;
1926: --
1927: ben_whatif_elig.WATIF_PERIODS_OF_SERVICE_API(
1928: p_person_id =>p_person_id
1929: ,p_per_object_version_number => null
1930: ,p_DATE_START => l_DATE_START2
1931: ,p_LEAVING_REASON => l_LEAVING_REASON

Line 1961: ben_whatif_elig.WATIF_PERSON_TYPE_USAGES_F_API(

1957: );
1958: --
1959: ELSIF C1.api_name='PER_PERSON_TYPE_USAGES_F' THEN
1960: --
1961: ben_whatif_elig.WATIF_PERSON_TYPE_USAGES_F_API(
1962: p_person_id => p_person_id
1963: ,p_PERSON_TYPE_ID => l_PERSON_TYPE_ID
1964: ,p_business_group_id => p_business_group_id
1965: ,p_effective_date => p_effective_date

Line 1970: ben_whatif_elig.WATIF_PER_BNFTS_BAL_F_API(

1966: );
1967: --
1968: ELSIF C1.api_name= 'BEN_PER_BNFTS_BAL_F' then
1969: --
1970: ben_whatif_elig.WATIF_PER_BNFTS_BAL_F_API(
1971: p_person_id => p_person_id
1972: ,p_business_group_id => p_business_group_id
1973: ,p_effective_date => p_effective_date
1974: ,p_BNFTS_BAL_ID => l_BNFTS_BAL_ID

Line 1982: ben_whatif_elig.WATIF_CRT_ORDR_API(

1978: );
1979: --
1980: ELSIF C1.api_name= 'BEN_CRT_ORDR' THEN
1981: --
1982: ben_whatif_elig.WATIF_CRT_ORDR_API(
1983: p_person_id => p_person_id
1984: ,p_pl_id => l_pl_id
1985: ,p_business_group_id => p_business_group_id
1986: ,p_effective_date => p_effective_date

Line 1994: ben_whatif_elig.WATIF_PER_ASG_BUDG_VAL_F_API(

1990: );
1991: --
1992: ELSIF C1.api_name='PER_ASSIG_BUDGET_VALUES_F' THEN
1993: --
1994: ben_whatif_elig.WATIF_PER_ASG_BUDG_VAL_F_API(
1995: p_person_id => p_person_id
1996: ,p_ASSIGNMENT_BUDGET_VALUE_ID => l_ASSIGNMENT_BUDGET_VALUE_ID
1997: ,p_VALUE => l_value
1998: ,p_business_group_id => p_business_group_id

Line 2003: ben_whatif_elig.WATIF_PER_QUALIFICATIONS_API(

1999: ,p_effective_date => p_effective_date
2000: );
2001: ELSIF C1.api_name= 'PER_QUALIFICATIONS' THEN
2002:
2003: ben_whatif_elig.WATIF_PER_QUALIFICATIONS_API(
2004: p_person_id => p_person_id
2005: ,p_qualification_type_id => l_qual_type_id
2006: ,p_title => l_qual_title
2007: ,p_start_date => nvl(l_qual_start_date, p_effective_date)

Line 2034: ben_whatif_elig.WATIF_PER_COMPETENCE_API(

2030: ,p_effective_date => p_effective_date
2031: );
2032: ELSIF C1.api_name='PER_COMPETENCE_ELEMENTS' THEN
2033:
2034: ben_whatif_elig.WATIF_PER_COMPETENCE_API(
2035: p_person_id => p_person_id
2036: ,p_competence_id => l_comp_id
2037: ,p_proficiency_level_id => l_prof_lvl_id
2038: ,p_effective_date_from => nvl(l_comp_eff_date_from, p_effective_date)

Line 2065: ben_whatif_elig.WATIF_PER_PERFORMANCE_API(

2061: ,p_effective_date => p_effective_date
2062: );
2063: ELSIF C1.api_name= 'PER_PERFORMANCE_REVIEWS' THEN
2064:
2065: ben_whatif_elig.WATIF_PER_PERFORMANCE_API(
2066: p_person_id => p_person_id
2067: ,p_performance_rating => l_perf_rating
2068: ,p_event_id => l_event_id
2069: ,p_review_date => l_review_date

Line 2108: ben_whatif_elig.WATIF_PAY_PROPOSAL_API(

2104: fnd_message.set_name('PER','HR_52401_PYP_NO_PROPOSED_AMT');
2105: fnd_message.raise_error;
2106:
2107: end if;
2108: ben_whatif_elig.WATIF_PAY_PROPOSAL_API(
2109: p_person_id => p_person_id
2110: ,p_approved => nvl(l_approved , 'N')
2111: ,p_change_date => nvl(l_change_date,p_effective_date) --6282219
2112: ,p_event_id => null

Line 2152: ben_whatif_elig.watif_temporal_lf_evt_API(

2148: FOR l_rec IN c_ler(p_typ_cd =>'DRVDAGE') LOOP
2149: l_agf_ler_id := l_rec.ler_id;
2150: END LOOP;
2151: p_lf_evt_ocrd_dt := l_lf_evt_ocrd_dt;
2152: ben_whatif_elig.watif_temporal_lf_evt_API(
2153: p_person_id => p_person_id
2154: ,p_ler_ID => l_agf_ler_ID
2155: ,p_temporal_lf_evt => 'AGE'
2156: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 2166: ben_whatif_elig.watif_temporal_lf_evt_API(

2162: FOR l_rec IN c_ler(p_typ_cd =>'DRVDLOS') LOOP
2163: l_los_ler_ID := l_rec.ler_id;
2164: END LOOP;
2165: p_lf_evt_ocrd_dt := l_lf_evt_ocrd_dt;
2166: ben_whatif_elig.watif_temporal_lf_evt_API(
2167: p_person_id => p_person_id
2168: ,p_ler_ID => l_los_ler_ID
2169: ,p_temporal_lf_evt => 'LOS'
2170: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 2182: ben_whatif_elig.watif_temporal_lf_evt_API(

2178: END LOOP;
2179: l_lf_evt_ocrd_dt := trunc(p_min_dt(l_lf_evt_ocrd_dt, l_lf_evt_ocrd_dt1)
2180: + abs((l_lf_evt_ocrd_dt - l_lf_evt_ocrd_dt1)/2));
2181: p_lf_evt_ocrd_dt := l_lf_evt_ocrd_dt;
2182: ben_whatif_elig.watif_temporal_lf_evt_API(
2183: p_person_id => p_person_id
2184: ,p_ler_ID => l_cal_ler_ID
2185: ,p_temporal_lf_evt => 'CAL'
2186: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt

Line 2196: ben_whatif_elig.watif_temporal_lf_evt_API(

2192: FOR l_rec IN c_ler(p_typ_cd =>'DRVDCMP') LOOP
2193: l_cmp_ler_ID := l_rec.ler_id;
2194: END LOOP;
2195:
2196: ben_whatif_elig.watif_temporal_lf_evt_API(
2197: p_person_id => p_person_id
2198: ,p_ler_ID => l_cmp_ler_ID
2199: ,p_temporal_lf_evt => 'CMP'
2200: ,p_lf_evt_ocrd_dt => p_effective_date

Line 2212: ben_whatif_elig.watif_temporal_lf_evt_API(

2208: ELSIF C1.api_name = 'DRVDHRW' then
2209: FOR l_rec IN c_ler(p_typ_cd =>'DRVDHRW') LOOP
2210: l_hrw_ler_ID := l_rec.ler_id;
2211: END LOOP;
2212: ben_whatif_elig.watif_temporal_lf_evt_API(
2213: p_person_id => p_person_id
2214: ,p_ler_ID => l_hrw_ler_ID
2215: ,p_temporal_lf_evt => 'HRW'
2216: ,p_lf_evt_ocrd_dt => p_effective_date

Line 2227: ben_whatif_elig.watif_temporal_lf_evt_API(

2223: ELSIF C1.api_name = 'DRVDTPF' then
2224: FOR l_rec IN c_ler(p_typ_cd =>'DRVDTPF') LOOP
2225: l_tpf_ler_ID:= l_rec.ler_id;
2226: END LOOP;
2227: ben_whatif_elig.watif_temporal_lf_evt_API(
2228: p_person_id => p_person_id
2229: ,p_ler_ID => l_tpf_ler_ID
2230: ,p_temporal_lf_evt => 'TPF'
2231: ,p_lf_evt_ocrd_dt => p_effective_date