APPS.BEN_ASSIGNMENT_INTERNAL dependencies on HR_API

Line 339: between nvl(ctr.date_start,hr_api.g_sot) and nvl(ctr.date_end,hr_api.g_eot)

335: select ctr.contact_person_id, ctr.contact_type
336: from per_contact_relationships ctr
337: where ctr.person_id = c_person_id
338: and c_eff_date
339: between nvl(ctr.date_start,hr_api.g_sot) and nvl(ctr.date_end,hr_api.g_eot)
340: and ctr.contact_type = c_contact_type
341: order by ctr.sequence_number;
342: --
343: cursor c_getdpntperdets

Line 360: and c_eff_date between nvl(ctr.date_start,hr_api.g_sot) and nvl(ctr.date_end,hr_api.g_eot)

356: and pet.system_person_type = 'DPNT'
357: and c_eff_date between ptu.effective_start_date and ptu.effective_end_date)
358: and ctr.person_id = c_person_id
359: and ctr.personal_flag = 'Y'
360: and c_eff_date between nvl(ctr.date_start,hr_api.g_sot) and nvl(ctr.date_end,hr_api.g_eot)
361: order by ctr.contact_person_id;
362: --
363: cursor c_get_all_contacts
364: (c_person_id in number

Line 375: between nvl(ctr.date_start,hr_api.g_sot) and nvl(ctr.date_end,hr_api.g_eot)

371: where ctr.person_id = c_person_id
372: and ctr.contact_person_id = nvl(c_contact_person_id, ctr.contact_person_id)
373: and ctr.personal_flag = 'Y'
374: and c_eff_date
375: between nvl(ctr.date_start,hr_api.g_sot) and nvl(ctr.date_end,hr_api.g_eot)
376: order by ctr.sequence_number;
377: --
378: cursor c_get_contacts
379: (c_person_id in number

Line 428: and nvl(hp.date_end, hr_api.g_eot)

424: , per_shared_types ps
425: where hp.position_id = c_position_id
426: and c_eff_date
427: between hp.date_effective
428: and nvl(hp.date_end, hr_api.g_eot)
429: and ps.shared_type_id = hp.availability_status_id
430: and ps.system_type_cd = 'ACTIVE' ;
431: --
432: cursor c_getempprasgdets

Line 735: hr_api.mandatory_arg_error

731: hr_utility.set_location('Entering:'|| l_proc, 10);
732: --
733: -- Check mandatory arguments
734: --
735: hr_api.mandatory_arg_error
736: (p_api_name => l_proc,
737: p_argument => 'person_id',
738: p_argument_value => p_person_id
739: );

Line 951: and nvl(p_pds_leaving_reason,hr_api.g_varchar2) not in('D')

947: --
948: -- No leaving reason set and termination leaving reasons
949: --
950: elsif p_pds_atd is not null
951: and nvl(p_pds_leaving_reason,hr_api.g_varchar2) not in('D')
952: then
953: hr_utility.set_location(l_proc, 90);
954: --
955: -- Terminating an employee with leaving reason not deceased

Line 1998: l_datetrack_mode := hr_api.g_update_override;

1994: p_update_change_insert => l_update_change_insert);
1995: --
1996: if l_update_override then
1997: --
1998: l_datetrack_mode := hr_api.g_update_override;
1999: --
2000: elsif l_update then
2001: --
2002: l_datetrack_mode := hr_api.g_update;

Line 2002: l_datetrack_mode := hr_api.g_update;

1998: l_datetrack_mode := hr_api.g_update_override;
1999: --
2000: elsif l_update then
2001: --
2002: l_datetrack_mode := hr_api.g_update;
2003: --
2004: else
2005: --
2006: l_datetrack_mode := hr_api.g_correction;

Line 2006: l_datetrack_mode := hr_api.g_correction;

2002: l_datetrack_mode := hr_api.g_update;
2003: --
2004: else
2005: --
2006: l_datetrack_mode := hr_api.g_correction;
2007: --
2008: end if;
2009: --
2010: -- Update the current benefit assignment.

Line 2218: and nvl(pyp.change_date,hr_api.g_sot) <= c_eff_date

2214: and asg.person_id = c_person_id
2215: and asg.primary_flag = 'Y'
2216: and asg.assignment_type = 'E'
2217: and pyp.approved = 'Y'
2218: and nvl(pyp.change_date,hr_api.g_sot) <= c_eff_date
2219: order by pyp.change_date desc;
2220: --
2221: begin
2222: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2228: hr_api.mandatory_arg_error

2224: hr_utility.set_location('p_effective_date '||p_effective_date, 300);
2225: --
2226: -- Check mandatory arguments
2227: --
2228: hr_api.mandatory_arg_error
2229: (p_api_name => l_proc,
2230: p_argument => 'p_person_id',
2231: p_argument_value => p_person_id
2232: );

Line 2234: hr_api.mandatory_arg_error

2230: p_argument => 'p_person_id',
2231: p_argument_value => p_person_id
2232: );
2233: --
2234: hr_api.mandatory_arg_error
2235: (p_api_name => l_proc,
2236: p_argument => 'p_effective_date',
2237: p_argument_value => p_effective_date
2238: );