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 dependencies on HR_API

Line 779: ,NVL(final_process_date, hr_api.g_eot)

775: -- period of service.
776: --
777: CURSOR csr_get_term_dates IS
778: SELECT actual_termination_date
779: ,NVL(final_process_date, hr_api.g_eot)
780: FROM per_periods_of_service
781: WHERE period_of_service_id = p_period_of_service_id
782: UNION
783: SELECT pdp.actual_termination_date

Line 784: ,NVL(pdp.final_process_date, hr_api.g_eot)

780: FROM per_periods_of_service
781: WHERE period_of_service_id = p_period_of_service_id
782: UNION
783: SELECT pdp.actual_termination_date
784: ,NVL(pdp.final_process_date, hr_api.g_eot)
785: FROM per_periods_of_placement pdp
786: WHERE pdp.person_id = l_person_id
787: AND pdp.date_start = l_pdp_date_start;
788:

Line 2196: SELECT NVL(actual_termination_date, hr_api.g_eot)

2192: -- Get the termination dates for the period of placement and
2193: -- period of service.
2194: --
2195: CURSOR csr_get_term_dates IS
2196: SELECT NVL(actual_termination_date, hr_api.g_eot)
2197: ,NVL(final_process_date, hr_api.g_eot)
2198: FROM per_periods_of_service
2199: WHERE period_of_service_id = p_period_of_service_id
2200: UNION

Line 2197: ,NVL(final_process_date, hr_api.g_eot)

2193: -- period of service.
2194: --
2195: CURSOR csr_get_term_dates IS
2196: SELECT NVL(actual_termination_date, hr_api.g_eot)
2197: ,NVL(final_process_date, hr_api.g_eot)
2198: FROM per_periods_of_service
2199: WHERE period_of_service_id = p_period_of_service_id
2200: UNION
2201: SELECT NVL(pdp.actual_termination_date, hr_api.g_eot)

Line 2201: SELECT NVL(pdp.actual_termination_date, hr_api.g_eot)

2197: ,NVL(final_process_date, hr_api.g_eot)
2198: FROM per_periods_of_service
2199: WHERE period_of_service_id = p_period_of_service_id
2200: UNION
2201: SELECT NVL(pdp.actual_termination_date, hr_api.g_eot)
2202: ,NVL(pdp.final_process_date, hr_api.g_eot)
2203: FROM per_periods_of_placement pdp
2204: WHERE pdp.person_id = l_person_id
2205: AND pdp.date_start = l_pdp_date_start;

Line 2202: ,NVL(pdp.final_process_date, hr_api.g_eot)

2198: FROM per_periods_of_service
2199: WHERE period_of_service_id = p_period_of_service_id
2200: UNION
2201: SELECT NVL(pdp.actual_termination_date, hr_api.g_eot)
2202: ,NVL(pdp.final_process_date, hr_api.g_eot)
2203: FROM per_periods_of_placement pdp
2204: WHERE pdp.person_id = l_person_id
2205: AND pdp.date_start = l_pdp_date_start;
2206:

Line 3091: p_datetrack_mode <> hr_api.g_update_override then -- Bug 3335915

3087: --
3088: -- Calling proces = 'POST_UPDATE' then a min step has to be created for the new grade scale
3089: --
3090: if p_calling_proc = 'POST_UPDATE' and
3091: p_datetrack_mode <> hr_api.g_update_override then -- Bug 3335915
3092:
3093: --
3094: -- get the placement_id and object_version_number for
3095: -- the current record as of the effective date

Line 3402: AND ABV.EFFECTIVE_END_DATE <> hr_api.g_eot;--Added as a part of fix for bug#11078262

3398:
3399: DELETE FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV
3400: WHERE ABV.ASSIGNMENT_ID = p_assignment_id
3401: AND ABV.EFFECTIVE_START_DATE > p_end_date
3402: AND ABV.EFFECTIVE_END_DATE <> hr_api.g_eot;--Added as a part of fix for bug#11078262
3403: --
3404: hr_utility.set_location(' No of rows deleted '||sql%rowcount,48);
3405: hr_utility.set_location('hr_assignment.del_ref_int_delete',49);
3406:

Line 3423: and EFFECTIVE_END_DATE <> hr_api.g_eot; -- Added the condition as a part of bug#9669561.

3419: , LAST_UPDATE_DATE = sysdate
3420: WHERE ASSIGNMENT_ID = p_assignment_id
3421: AND p_end_date
3422: BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
3423: and EFFECTIVE_END_DATE <> hr_api.g_eot; -- Added the condition as a part of bug#9669561.
3424:
3425: -- Bug 13809858
3426: -- hr_utility.set_location('No of rows updated '||sql%rowcount,51);
3427:

Line 4043: ,p_datetrack_mode => hr_api.g_delete

4039: --
4040: hr_rate_values_api.delete_rate_value
4041: (p_validate => FALSE
4042: ,p_grade_rule_id => crec_current_asg_rates.grade_rule_id
4043: ,p_datetrack_mode => hr_api.g_delete
4044: ,p_effective_date => p_new_end_date
4045: ,p_object_version_number => crec_current_asg_rates.object_version_number
4046: ,p_effective_start_date => l_effective_start_date
4047: ,p_effective_end_date => l_effective_end_date);

Line 4062: ,p_datetrack_mode => hr_api.g_zap

4058: --
4059: hr_rate_values_api.delete_rate_value
4060: (p_validate => FALSE
4061: ,p_grade_rule_id => crec_future_asg_rates.grade_rule_id
4062: ,p_datetrack_mode => hr_api.g_zap
4063: ,p_effective_date => crec_future_asg_rates.effective_start_date
4064: ,p_object_version_number => crec_future_asg_rates.object_version_number
4065: ,p_effective_start_date => l_effective_start_date
4066: ,p_effective_end_date => l_effective_end_date);

Line 4514: p.date_start AND NVL(p.final_process_date, hr_api.g_eot)

4510: SELECT p.date_start date_start, p.period_of_service_id
4511: FROM per_periods_of_service p
4512: WHERE p.person_id = to_number(p_person_id)
4513: AND fnd_date.canonical_to_date(p_new_date) BETWEEN
4514: p.date_start AND NVL(p.final_process_date, hr_api.g_eot)
4515: UNION
4516: SELECT pdp.date_start date_start, pdp.period_of_placement_id
4517: FROM per_periods_of_placement pdp
4518: WHERE pdp.person_id = to_number(p_person_id)

Line 4520: pdp.date_start AND NVL(pdp.final_process_date, hr_api.g_eot)

4516: SELECT pdp.date_start date_start, pdp.period_of_placement_id
4517: FROM per_periods_of_placement pdp
4518: WHERE pdp.person_id = to_number(p_person_id)
4519: AND fnd_date.canonical_to_date(p_new_date) BETWEEN
4520: pdp.date_start AND NVL(pdp.final_process_date, hr_api.g_eot)
4521: ORDER BY date_start DESC;
4522:
4523: BEGIN
4524: