APPS.BEN_ASSIGNMENT_INTERNAL dependencies on HR_API

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

541: select ctr.contact_person_id, ctr.contact_type
542: from per_contact_relationships ctr
543: where ctr.person_id = c_person_id
544: and c_eff_date
545: between nvl(ctr.date_start,hr_api.g_sot) and nvl(ctr.date_end,hr_api.g_eot)
546: and ctr.contact_type = c_contact_type
547: order by ctr.sequence_number;
548: --
549: cursor c_getdpntperdets

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

562: and pet.system_person_type = 'DPNT'
563: and c_eff_date between ptu.effective_start_date and ptu.effective_end_date)
564: and ctr.person_id = c_person_id
565: and ctr.personal_flag = 'Y'
566: and c_eff_date between nvl(ctr.date_start,hr_api.g_sot) and nvl(ctr.date_end,hr_api.g_eot)
567: order by ctr.contact_person_id;
568: --
569: cursor c_get_all_contacts
570: (c_person_id in number

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

577: where ctr.person_id = c_person_id
578: and ctr.contact_person_id = nvl(c_contact_person_id, ctr.contact_person_id)
579: and ctr.personal_flag = 'Y'
580: and c_eff_date
581: between nvl(ctr.date_start,hr_api.g_sot) and nvl(ctr.date_end,hr_api.g_eot)
582: order by ctr.sequence_number;
583: --
584: cursor c_get_contacts
585: (c_person_id in number

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

630: , per_shared_types ps
631: where hp.position_id = c_position_id
632: and c_eff_date
633: between hp.date_effective
634: and nvl(hp.date_end, hr_api.g_eot)
635: and ps.shared_type_id = hp.availability_status_id
636: and ps.system_type_cd = 'ACTIVE' ;
637: --
638: cursor c_getempprasgdets

Line 776: hr_api.mandatory_arg_error

772: hr_utility.set_location('Entering:'|| l_proc, 10);
773: --
774: -- Check mandatory arguments
775: --
776: hr_api.mandatory_arg_error
777: (p_api_name => l_proc,
778: p_argument => 'person_id',
779: p_argument_value => p_person_id
780: );

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

990: --
991: -- No leaving reason set and termination leaving reasons
992: --
993: elsif p_pds_atd is not null
994: and nvl(p_pds_leaving_reason,hr_api.g_varchar2) not in('D')
995: then
996: hr_utility.set_location(l_proc, 90);
997: --
998: -- Terminating an employee with leaving reason not deceased

Line 2110: l_datetrack_mode := hr_api.g_update_override;

2106: p_update_change_insert => l_update_change_insert);
2107: --
2108: if l_update_override then
2109: --
2110: l_datetrack_mode := hr_api.g_update_override;
2111: --
2112: elsif l_update then
2113: --
2114: l_datetrack_mode := hr_api.g_update;

Line 2114: l_datetrack_mode := hr_api.g_update;

2110: l_datetrack_mode := hr_api.g_update_override;
2111: --
2112: elsif l_update then
2113: --
2114: l_datetrack_mode := hr_api.g_update;
2115: --
2116: else
2117: --
2118: l_datetrack_mode := hr_api.g_correction;

Line 2118: l_datetrack_mode := hr_api.g_correction;

2114: l_datetrack_mode := hr_api.g_update;
2115: --
2116: else
2117: --
2118: l_datetrack_mode := hr_api.g_correction;
2119: --
2120: end if;
2121: --
2122: -- Update the current benefit assignment.

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

2326: and asg.person_id = c_person_id
2327: and asg.primary_flag = 'Y'
2328: and asg.assignment_type = 'E'
2329: and pyp.approved = 'Y'
2330: and nvl(pyp.change_date,hr_api.g_sot) <= c_eff_date
2331: order by pyp.change_date desc;
2332: --
2333: begin
2334: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2340: hr_api.mandatory_arg_error

2336: hr_utility.set_location('p_effective_date '||p_effective_date, 300);
2337: --
2338: -- Check mandatory arguments
2339: --
2340: hr_api.mandatory_arg_error
2341: (p_api_name => l_proc,
2342: p_argument => 'p_person_id',
2343: p_argument_value => p_person_id
2344: );

Line 2346: hr_api.mandatory_arg_error

2342: p_argument => 'p_person_id',
2343: p_argument_value => p_person_id
2344: );
2345: --
2346: hr_api.mandatory_arg_error
2347: (p_api_name => l_proc,
2348: p_argument => 'p_effective_date',
2349: p_argument_value => p_effective_date
2350: );