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 2795: (p_assignment_id in per_all_assignments_f.assignment_id%Type

2791: -- |-------------------------< CHECK_VALID_PLACEMENT >------------------------|
2792: -- ----------------------------------------------------------------------------
2793: --
2794: procedure chk_valid_placement_id
2795: (p_assignment_id in per_all_assignments_f.assignment_id%Type
2796: ,p_placement_id in per_spinal_point_placements_f.placement_id%Type
2797: ,p_validation_start_date in date) is
2798: --
2799: -- Local variables

Line 2844: (p_assignment_id in per_all_assignments_f.assignment_id%Type

2840: -- |-----------------------------< CLEANUP_SPP >------------------------------|
2841: -- ----------------------------------------------------------------------------
2842: --
2843: procedure cleanup_spp
2844: (p_assignment_id in per_all_assignments_f.assignment_id%Type
2845: ,p_datetrack_mode in varchar2
2846: ,p_validation_start_date in date
2847: ,p_del_end_future_spp in out nocopy boolean) is
2848: --

Line 2858: from per_all_assignments_f paa

2854: cursor csr_asg_details is
2855: select paa.effective_start_date,
2856: paa.effective_end_date,
2857: paa.grade_id
2858: from per_all_assignments_f paa
2859: where paa.assignment_id = p_assignment_id
2860: and paa.effective_end_date >= p_validation_start_date - 1
2861: order by paa.effective_start_date;
2862: -- Cursor to retrive the spp records for the assignment record for with

Line 3028: (p_assignment_id in per_all_assignments_f.assignment_id%Type

3024: -- |------------------------< DELETE_NEXT_CHANGE_SPP >-------------------------|
3025: -- ----------------------------------------------------------------------------
3026: --
3027: procedure delete_next_change_spp
3028: (p_assignment_id in per_all_assignments_f.assignment_id%Type
3029: ,p_placement_id in per_spinal_point_placements_f.placement_id%Type
3030: ,p_grade_id in per_grade_spines_f.grade_id%Type
3031: ,p_datetrack_mode in varchar2
3032: ,p_validation_start_date in date

Line 3202: (p_assignment_id in per_all_assignments_f.assignment_id%Type

3198: -- |--------------------------< FUTURE_CHANGE_SPP >---------------------------|
3199: -- ----------------------------------------------------------------------------
3200: --
3201: procedure future_change_spp
3202: (p_assignment_id in per_all_assignments_f.assignment_id%Type
3203: ,p_placement_id in per_spinal_point_placements_f.placement_id%Type
3204: ,p_datetrack_mode in varchar2
3205: ,p_validation_start_date in date
3206: ,p_del_end_future_spp out nocopy boolean) is

Line 3297: (p_assignment_id in per_all_assignments_f.assignment_id%Type

3293: -- |-------------------------< UPDATE_OVERRIDE_SPP >--------------------------|
3294: -- ----------------------------------------------------------------------------
3295: --
3296: procedure update_override_spp
3297: (p_assignment_id in per_all_assignments_f.assignment_id%Type
3298: ,p_placement_id in per_spinal_point_placements_f.placement_id%Type
3299: ,p_datetrack_mode in varchar2
3300: ,p_validation_start_date in date
3301: ,p_validation_end_date in date

Line 3328: from per_all_assignments_f paa

3324: -- We need to get the previous assignment record to check whether any
3325: -- Grade changes is happend in this DT UPDATE_OVERRIDE
3326: cursor csr_asg_details is
3327: select paa.grade_id
3328: from per_all_assignments_f paa
3329: where paa.assignment_id = p_assignment_id
3330: and p_validation_start_date - 1 between paa.effective_start_date
3331: and paa.effective_end_date
3332: order by paa.effective_start_date;

Line 3589: (p_assignment_id in per_all_assignments_f.assignment_id%Type

3585: -- |--------------------------< CLOSE_SPP_RECORDS >---------------------------|
3586: -- ----------------------------------------------------------------------------
3587: --
3588: procedure close_spp_records
3589: (p_assignment_id in per_all_assignments_f.assignment_id%Type
3590: ,p_placement_id in per_spinal_point_placements_f.placement_id%Type
3591: ,p_datetrack_mode in varchar2
3592: ,p_validation_start_date in date
3593: ,p_object_version_number in number

Line 3961: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

3957: -- |----------------------< DELETE_FUTURE_SPP_RECORDS >-----------------------|
3958: -- ----------------------------------------------------------------------------
3959: --
3960: PROCEDURE delete_future_spp_records
3961: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3962: ,p_datetrack_mode IN VARCHAR2
3963: ,p_placement_id IN per_spinal_point_placements_f.placement_id%TYPE
3964: ,p_object_version_number IN per_spinal_point_placements_f.object_version_number%TYPE
3965: ,p_effective_date IN DATE) IS

Line 5723: From per_all_assignments_f

5719: ,p_effective_end_date out nocopy date
5720: ) is
5721: Cursor csr_vacancy_id is
5722: Select vacancy_id
5723: From per_all_assignments_f
5724: Where assignment_id = p_assignment_id
5725: And p_effective_date between effective_start_date and effective_end_date;
5726:
5727: --

Line 5915: (p_assignment_id in per_all_assignments_f.assignment_id%Type

5911: -- |----------------------< irc_delete_assgt_checks >--------------------------|
5912: -- ----------------------------------------------------------------------------
5913: --
5914: procedure irc_delete_assgt_checks
5915: (p_assignment_id in per_all_assignments_f.assignment_id%Type
5916: ,p_datetrack_mode in varchar2
5917: ,p_validation_start_date in date )
5918: is
5919: --

Line 5988: (p_assignment_id in per_all_assignments_f.assignment_id%Type

5984: -- ----------------------------------------------------------------------------
5985: -- |----------------------< ben_delete_assgt_checks >--------------------------|
5986: -- ----------------------------------------------------------------------------
5987: procedure ben_delete_assgt_checks
5988: (p_assignment_id in per_all_assignments_f.assignment_id%Type
5989: ,p_datetrack_mode in varchar2
5990: ,p_life_events_exists out NOCOPY boolean)
5991: is
5992: --

Line 6107: select rowid from per_all_assignments_f

6103: where step_id = per_asg_shd.g_old_rec.special_ceiling_step_id
6104: and p_effective_date between effective_start_date and effective_end_date;
6105: --
6106: cursor csr_ass_row_id is
6107: select rowid from per_all_assignments_f
6108: where assignment_id = p_rec.assignment_id
6109: and p_effective_date between effective_start_date and effective_end_date;
6110: --
6111: cursor csr_ass_loc_code is