APPS.GHR_PROC_FUT_MT dependencies on HR_API

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

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

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

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

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

218: IF (NVL(l_person_id,hr_api.g_number) = l_c_futr_actions.person_id AND
219: NVL(l_effective_date,hr_api.g_eot) = l_c_futr_actions.effective_date) THEN
220: NULL;
221: ELSE
222: IF l_batch_counter >= l_batch_size AND NVL(l_person_id,hr_api.g_number) <> l_c_futr_actions.person_id THEN
223: l_batch_no := l_batch_no + 1;
224: l_batch_counter := 0;
225: END IF;
226: --Bug#3726290 Add the separation Business Rule here.

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

323: END IF;
324: IF NVL(l_result,'NOT EXISTS') = 'NOT EXISTS' THEN
325: -- If there is another record for the same person on same effective date, skip that record.
326: -- Bug 4127797 TAR 4256507.995
327: IF (NVL(l_person_id,hr_api.g_number) = l_c_futr_actions.person_id AND
328: NVL(l_effective_date,hr_api.g_eot) = l_c_futr_actions.effective_date) THEN
329: NULL;
330: ELSE
331: IF l_batch_counter >= l_batch_size AND NVL(l_person_id,hr_api.g_number) <> l_c_futr_actions.person_id THEN

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

324: IF NVL(l_result,'NOT EXISTS') = 'NOT EXISTS' THEN
325: -- If there is another record for the same person on same effective date, skip that record.
326: -- Bug 4127797 TAR 4256507.995
327: IF (NVL(l_person_id,hr_api.g_number) = l_c_futr_actions.person_id AND
328: NVL(l_effective_date,hr_api.g_eot) = l_c_futr_actions.effective_date) THEN
329: NULL;
330: ELSE
331: IF l_batch_counter >= l_batch_size AND NVL(l_person_id,hr_api.g_number) <> l_c_futr_actions.person_id THEN
332: l_batch_no := l_batch_no + 1;

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

327: IF (NVL(l_person_id,hr_api.g_number) = l_c_futr_actions.person_id AND
328: NVL(l_effective_date,hr_api.g_eot) = l_c_futr_actions.effective_date) THEN
329: NULL;
330: ELSE
331: IF l_batch_counter >= l_batch_size AND NVL(l_person_id,hr_api.g_number) <> l_c_futr_actions.person_id THEN
332: l_batch_no := l_batch_no + 1;
333: l_batch_counter := 0;
334: END IF;
335: -- Insert values into the table

Line 942: ghr_api.call_workflow(

938: ' has errors.' || l_new_line ||
939: 'Error : ' || p_error || l_new_line ||
940: 'Errored while routing it to the approver''s Inbox ';
941:
942: ghr_api.call_workflow(
943: p_pa_request_id => p_sf52.pa_request_id,
944: p_action_taken => 'CONTINUE',
945: p_error => p_error);
946: hr_utility.set_location( 'Leaving : ' || l_proc, 20);