APPS.GHR_PROC_FUT_MT dependencies on HR_API

Line 212: IF (NVL(l_person_id,hr_api.g_number) = l_c_futr_actions.person_id AND

208: END IF;
209: IF NVL(l_result,'NOT EXISTS') = 'NOT EXISTS' THEN
210: -- If there is another record for the same person on same effective date, skip that record.
211: -- Bug 4127797 TAR 4256507.995
212: IF (NVL(l_person_id,hr_api.g_number) = l_c_futr_actions.person_id AND
213: NVL(l_effective_date,hr_api.g_eot) = l_c_futr_actions.effective_date) THEN
214: NULL;
215: ELSE
216: IF l_batch_counter >= l_batch_size AND NVL(l_person_id,hr_api.g_number) <> l_c_futr_actions.person_id THEN

Line 213: NVL(l_effective_date,hr_api.g_eot) = l_c_futr_actions.effective_date) THEN

209: IF NVL(l_result,'NOT EXISTS') = 'NOT EXISTS' THEN
210: -- If there is another record for the same person on same effective date, skip that record.
211: -- Bug 4127797 TAR 4256507.995
212: IF (NVL(l_person_id,hr_api.g_number) = l_c_futr_actions.person_id AND
213: NVL(l_effective_date,hr_api.g_eot) = l_c_futr_actions.effective_date) THEN
214: NULL;
215: ELSE
216: IF l_batch_counter >= l_batch_size AND NVL(l_person_id,hr_api.g_number) <> l_c_futr_actions.person_id THEN
217: l_batch_no := l_batch_no + 1;

Line 216: IF l_batch_counter >= l_batch_size AND NVL(l_person_id,hr_api.g_number) <> l_c_futr_actions.person_id THEN

212: IF (NVL(l_person_id,hr_api.g_number) = l_c_futr_actions.person_id AND
213: NVL(l_effective_date,hr_api.g_eot) = l_c_futr_actions.effective_date) THEN
214: NULL;
215: ELSE
216: IF l_batch_counter >= l_batch_size AND NVL(l_person_id,hr_api.g_number) <> l_c_futr_actions.person_id THEN
217: l_batch_no := l_batch_no + 1;
218: l_batch_counter := 0;
219: END IF;
220: --Bug#3726290 Add the separation Business Rule here.

Line 315: IF (NVL(l_person_id,hr_api.g_number) = l_c_futr_actions.person_id AND

311: END IF;
312: IF NVL(l_result,'NOT EXISTS') = 'NOT EXISTS' THEN
313: -- If there is another record for the same person on same effective date, skip that record.
314: -- Bug 4127797 TAR 4256507.995
315: IF (NVL(l_person_id,hr_api.g_number) = l_c_futr_actions.person_id AND
316: NVL(l_effective_date,hr_api.g_eot) = l_c_futr_actions.effective_date) THEN
317: NULL;
318: ELSE
319: IF l_batch_counter >= l_batch_size AND NVL(l_person_id,hr_api.g_number) <> l_c_futr_actions.person_id THEN

Line 316: NVL(l_effective_date,hr_api.g_eot) = l_c_futr_actions.effective_date) THEN

312: IF NVL(l_result,'NOT EXISTS') = 'NOT EXISTS' THEN
313: -- If there is another record for the same person on same effective date, skip that record.
314: -- Bug 4127797 TAR 4256507.995
315: IF (NVL(l_person_id,hr_api.g_number) = l_c_futr_actions.person_id AND
316: NVL(l_effective_date,hr_api.g_eot) = l_c_futr_actions.effective_date) THEN
317: NULL;
318: ELSE
319: IF l_batch_counter >= l_batch_size AND NVL(l_person_id,hr_api.g_number) <> l_c_futr_actions.person_id THEN
320: l_batch_no := l_batch_no + 1;

Line 319: IF l_batch_counter >= l_batch_size AND NVL(l_person_id,hr_api.g_number) <> l_c_futr_actions.person_id THEN

315: IF (NVL(l_person_id,hr_api.g_number) = l_c_futr_actions.person_id AND
316: NVL(l_effective_date,hr_api.g_eot) = l_c_futr_actions.effective_date) THEN
317: NULL;
318: ELSE
319: IF l_batch_counter >= l_batch_size AND NVL(l_person_id,hr_api.g_number) <> l_c_futr_actions.person_id THEN
320: l_batch_no := l_batch_no + 1;
321: l_batch_counter := 0;
322: END IF;
323: -- Insert values into the table

Line 913: ghr_api.call_workflow(

909: ' has errors.' || l_new_line ||
910: 'Error : ' || p_error || l_new_line ||
911: 'Errored while routing it to the approver''s Inbox ';
912:
913: ghr_api.call_workflow(
914: p_pa_request_id => p_sf52.pa_request_id,
915: p_action_taken => 'CONTINUE',
916: p_error => p_error);
917: hr_utility.set_location( 'Leaving : ' || l_proc, 20);