eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ASSIGNMENT_INTERNAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 2079: l_work_at_home per_all_assignments_f.work_at_home%TYPE; --FIX FOR BUG 9162187

2075: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
2076: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
2077: l_proc varchar2(72) := g_package||'create_emp_asg';
2078: l_labour_union_member_flag per_assignments_f.labour_union_member_flag%TYPE;
2079: l_work_at_home per_all_assignments_f.work_at_home%TYPE; --FIX FOR BUG 9162187
2080: --
2081: begin
2082: hr_utility.set_location('Entering:'|| l_proc, 1);
2083: --

Line 2928: (p_assignment_id in per_all_assignments_f.assignment_id%Type

2924: -- |-------------------------< CHECK_VALID_PLACEMENT >------------------------|
2925: -- ----------------------------------------------------------------------------
2926: --
2927: procedure chk_valid_placement_id
2928: (p_assignment_id in per_all_assignments_f.assignment_id%Type
2929: ,p_placement_id in per_spinal_point_placements_f.placement_id%Type
2930: ,p_validation_start_date in date) is
2931: --
2932: -- Local variables

Line 2977: (p_assignment_id in per_all_assignments_f.assignment_id%Type

2973: -- |-----------------------------< CLEANUP_SPP >------------------------------|
2974: -- ----------------------------------------------------------------------------
2975: --
2976: procedure cleanup_spp
2977: (p_assignment_id in per_all_assignments_f.assignment_id%Type
2978: ,p_datetrack_mode in varchar2
2979: ,p_validation_start_date in date
2980: ,p_del_end_future_spp in out nocopy boolean) is
2981: --

Line 2991: from per_all_assignments_f paa

2987: cursor csr_asg_details is
2988: select paa.effective_start_date,
2989: paa.effective_end_date,
2990: paa.grade_id
2991: from per_all_assignments_f paa
2992: where paa.assignment_id = p_assignment_id
2993: and paa.effective_end_date >= p_validation_start_date - 1
2994: order by paa.effective_start_date;
2995: -- Cursor to retrive the spp records for the assignment record for with

Line 3161: (p_assignment_id in per_all_assignments_f.assignment_id%Type

3157: -- |------------------------< DELETE_NEXT_CHANGE_SPP >-------------------------|
3158: -- ----------------------------------------------------------------------------
3159: --
3160: procedure delete_next_change_spp
3161: (p_assignment_id in per_all_assignments_f.assignment_id%Type
3162: ,p_placement_id in per_spinal_point_placements_f.placement_id%Type
3163: ,p_grade_id in per_grade_spines_f.grade_id%Type
3164: ,p_datetrack_mode in varchar2
3165: ,p_validation_start_date in date

Line 3335: (p_assignment_id in per_all_assignments_f.assignment_id%Type

3331: -- |--------------------------< FUTURE_CHANGE_SPP >---------------------------|
3332: -- ----------------------------------------------------------------------------
3333: --
3334: procedure future_change_spp
3335: (p_assignment_id in per_all_assignments_f.assignment_id%Type
3336: ,p_placement_id in per_spinal_point_placements_f.placement_id%Type
3337: ,p_datetrack_mode in varchar2
3338: ,p_validation_start_date in date
3339: ,p_del_end_future_spp out nocopy boolean) is

Line 3430: (p_assignment_id in per_all_assignments_f.assignment_id%Type

3426: -- |-------------------------< UPDATE_OVERRIDE_SPP >--------------------------|
3427: -- ----------------------------------------------------------------------------
3428: --
3429: procedure update_override_spp
3430: (p_assignment_id in per_all_assignments_f.assignment_id%Type
3431: ,p_placement_id in per_spinal_point_placements_f.placement_id%Type
3432: ,p_datetrack_mode in varchar2
3433: ,p_validation_start_date in date
3434: ,p_validation_end_date in date

Line 3461: from per_all_assignments_f paa

3457: -- We need to get the previous assignment record to check whether any
3458: -- Grade changes is happend in this DT UPDATE_OVERRIDE
3459: cursor csr_asg_details is
3460: select paa.grade_id
3461: from per_all_assignments_f paa
3462: where paa.assignment_id = p_assignment_id
3463: and p_validation_start_date - 1 between paa.effective_start_date
3464: and paa.effective_end_date
3465: order by paa.effective_start_date;

Line 3722: (p_assignment_id in per_all_assignments_f.assignment_id%Type

3718: -- |--------------------------< CLOSE_SPP_RECORDS >---------------------------|
3719: -- ----------------------------------------------------------------------------
3720: --
3721: procedure close_spp_records
3722: (p_assignment_id in per_all_assignments_f.assignment_id%Type
3723: ,p_placement_id in per_spinal_point_placements_f.placement_id%Type
3724: ,p_datetrack_mode in varchar2
3725: ,p_validation_start_date in date
3726: ,p_object_version_number in number

Line 4094: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

4090: -- |----------------------< DELETE_FUTURE_SPP_RECORDS >-----------------------|
4091: -- ----------------------------------------------------------------------------
4092: --
4093: PROCEDURE delete_future_spp_records
4094: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
4095: ,p_datetrack_mode IN VARCHAR2
4096: ,p_placement_id IN per_spinal_point_placements_f.placement_id%TYPE
4097: ,p_object_version_number IN per_spinal_point_placements_f.object_version_number%TYPE
4098: ,p_effective_date IN DATE) IS

Line 5162: l_work_at_home per_all_assignments_f.work_at_home%TYPE; --FIX FOR BUG 9246917

5158: l_other_manager_warning boolean;
5159: l_hourly_salaried_warning boolean;
5160: l_proc varchar2(72) := g_package||'create_apl_asg';
5161: l_labour_union_member_flag per_assignments_f.labour_union_member_flag%TYPE;
5162: l_work_at_home per_all_assignments_f.work_at_home%TYPE; --FIX FOR BUG 9246917
5163: begin
5164: --
5165: hr_utility.set_location(l_proc, 10);
5166: -- fix for bug 4550165 starts here.

Line 5858: From per_all_assignments_f

5854: ,p_effective_end_date out nocopy date
5855: ) is
5856: Cursor csr_vacancy_id is
5857: Select vacancy_id
5858: From per_all_assignments_f
5859: Where assignment_id = p_assignment_id
5860: And p_effective_date between effective_start_date and effective_end_date;
5861:
5862: --

Line 5919: where person_id in (select person_id from per_all_assignments_f where assignment_id= p_assignment_id

5915:
5916: cursor c_person_enthn is
5917: select person_id,business_group_id,per_information1
5918: from per_all_people_f
5919: where person_id in (select person_id from per_all_assignments_f where assignment_id= p_assignment_id
5920: and p_effective_date between effective_start_date and effective_end_date)
5921: and p_effective_date between effective_start_date and effective_end_date;
5922:
5923:

Line 5927: where person_id in (select person_id from per_all_assignments_f

5923:
5924: cursor csr_is_emp is
5925: select 1 from
5926: per_periods_of_service
5927: where person_id in (select person_id from per_all_assignments_f
5928: where assignment_id= p_assignment_id
5929: and p_effective_date between effective_start_date and effective_end_date);
5930:
5931:

Line 6126: (p_assignment_id in per_all_assignments_f.assignment_id%Type

6122: -- |----------------------< irc_delete_assgt_checks >--------------------------|
6123: -- ----------------------------------------------------------------------------
6124: --
6125: procedure irc_delete_assgt_checks
6126: (p_assignment_id in per_all_assignments_f.assignment_id%Type
6127: ,p_datetrack_mode in varchar2
6128: ,p_validation_start_date in date )
6129: is
6130: --

Line 6199: (p_assignment_id in per_all_assignments_f.assignment_id%Type

6195: -- ----------------------------------------------------------------------------
6196: -- |----------------------< ben_delete_assgt_checks >--------------------------|
6197: -- ----------------------------------------------------------------------------
6198: procedure ben_delete_assgt_checks
6199: (p_assignment_id in per_all_assignments_f.assignment_id%Type
6200: ,p_datetrack_mode in varchar2
6201: ,p_life_events_exists out NOCOPY boolean)
6202: is
6203: --

Line 6321: select rowid from per_all_assignments_f

6317: where step_id = per_asg_shd.g_old_rec.special_ceiling_step_id
6318: and p_effective_date between effective_start_date and effective_end_date;
6319: --
6320: cursor csr_ass_row_id is
6321: select rowid from per_all_assignments_f
6322: where assignment_id = p_rec.assignment_id
6323: and p_effective_date between effective_start_date and effective_end_date;
6324: --
6325: cursor csr_ass_loc_code is

Line 6776: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

6772: IS
6773: l_business_group_id pqp_configuration_values.business_group_id%TYPE;
6774: l_legislation_code pqp_configuration_values.legislation_code%TYPE;
6775: l_abv_uom pqp_configuration_values.pcv_information1%TYPE;
6776: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
6777: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
6778: l_assignment_type varchar2(30);
6779:
6780: l_error_message fnd_new_messages.message_text%TYPE;

Line 6777: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

6773: l_business_group_id pqp_configuration_values.business_group_id%TYPE;
6774: l_legislation_code pqp_configuration_values.legislation_code%TYPE;
6775: l_abv_uom pqp_configuration_values.pcv_information1%TYPE;
6776: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
6777: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
6778: l_assignment_type varchar2(30);
6779:
6780: l_error_message fnd_new_messages.message_text%TYPE;
6781: g_debug boolean := true;

Line 6848: from per_all_assignments_f

6844: CURSOR get_ass_typ_bus_grp_id(p_assignment_id IN NUMBER,
6845: p_effective_date in Date)
6846: IS
6847: select assignment_type, business_group_id
6848: from per_all_assignments_f
6849: where assignment_id = p_assignment_id
6850: and p_effective_date between effective_start_date and effective_end_date ;
6851:
6852: