46: hr_utility.set_location('Entering:'|| l_proc, 10);
47: --
48: -- Ensure that all the mandatory parameter are not null
49: --
50: hr_api.mandatory_arg_error
51: (p_api_name => l_proc
52: ,p_argument => 'compl_appeal_id'
53: ,p_argument_value => p_compl_appeal_id
54: );
69: close csr_sec_grp;
70: --
71: -- Set the security_group_id in CLIENT_INFO
72: --
73: hr_api.set_security_group_id
74: (p_security_group_id => l_security_group_id
75: );
76: --
77: hr_utility.set_location(' Leaving:'|| l_proc, 20);
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error
117: (p_api_name => l_proc
118: ,p_argument => 'compl_appeal_id'
119: ,p_argument_value => p_compl_appeal_id
120: );
118: ,p_argument => 'compl_appeal_id'
119: ,p_argument_value => p_compl_appeal_id
120: );
121: --
122: if ( nvl(ghr_cca_bus.g_compl_appeal_id, hr_api.g_number)
123: = p_compl_appeal_id) then
124: --
125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global
212: -- not been updated.
213: --
214: EXCEPTION
215: WHEN l_error THEN
216: hr_api.argument_changed_error
217: (p_api_name => l_proc
218: ,p_argument => l_argument);
219: WHEN OTHERS THEN
220: RAISE;
241: hr_utility.set_location('Entering: '|| l_proc, 10);
242:
243: -- Check Mandatory Parameters are set
244:
245: hr_api.mandatory_arg_error
246: (p_api_name => l_proc,
247: p_argument => 'effective date',
248: p_argument_value => p_effective_date
249: );
261: p_object_version_number => p_object_version_number);
262:
263: IF (l_api_updating
264: AND
265: ((nvl(ghr_cca_shd.g_old_rec.appealed_to,hr_api.g_varchar2)
266: <> nvl(p_appealed_to,hr_api.g_varchar2))))
267: OR
268: NOT l_api_updating THEN
269:
262:
263: IF (l_api_updating
264: AND
265: ((nvl(ghr_cca_shd.g_old_rec.appealed_to,hr_api.g_varchar2)
266: <> nvl(p_appealed_to,hr_api.g_varchar2))))
267: OR
268: NOT l_api_updating THEN
269:
270: --
276: --
277:
278: IF p_appealed_to is NOT NULL THEN
279:
280: IF hr_api.not_exists_in_hr_lookups
281: (p_effective_date => p_effective_date,
282: p_lookup_type => 'GHR_US_APPEAL_TO',
283: p_lookup_code => p_appealed_to
284: ) THEN
321: hr_utility.set_location('Entering: '|| l_proc, 10);
322:
323: -- Check Mandatory Parameters are set
324:
325: hr_api.mandatory_arg_error
326: (p_api_name => l_proc,
327: p_argument => 'effective date',
328: p_argument_value => p_effective_date
329: );
341: p_object_version_number => p_object_version_number);
342:
343: IF (l_api_updating
344: AND
345: ((nvl(ghr_cca_shd.g_old_rec.reason_for_appeal,hr_api.g_varchar2)
346: <> nvl(p_reason_for_appeal,hr_api.g_varchar2))))
347: OR
348: NOT l_api_updating THEN
349:
342:
343: IF (l_api_updating
344: AND
345: ((nvl(ghr_cca_shd.g_old_rec.reason_for_appeal,hr_api.g_varchar2)
346: <> nvl(p_reason_for_appeal,hr_api.g_varchar2))))
347: OR
348: NOT l_api_updating THEN
349:
350: --
356: --
357:
358: IF p_reason_for_appeal is NOT NULL THEN
359:
360: IF hr_api.not_exists_in_hr_lookups
361: (p_effective_date => p_effective_date,
362: p_lookup_type => 'GHR_US_APPEAL_REASON',
363: p_lookup_code => p_reason_for_appeal
364: ) THEN
406: hr_utility.set_location('Entering: '|| l_proc, 10);
407:
408: -- Check Mandatory Parameters are set
409:
410: hr_api.mandatory_arg_error
411: (p_api_name => l_proc,
412: p_argument => 'effective date',
413: p_argument_value => p_effective_date
414: );
426: p_object_version_number => p_object_version_number);
427:
428: IF (l_api_updating
429: AND
430: ((nvl(ghr_cca_shd.g_old_rec.decision,hr_api.g_varchar2)
431: <> nvl(p_decision,hr_api.g_varchar2))))
432: OR
433: NOT l_api_updating THEN
434:
427:
428: IF (l_api_updating
429: AND
430: ((nvl(ghr_cca_shd.g_old_rec.decision,hr_api.g_varchar2)
431: <> nvl(p_decision,hr_api.g_varchar2))))
432: OR
433: NOT l_api_updating THEN
434:
435: --
451: ELSIF p_appealed_to = l_mspb then
452: l_lookup_type := 'GHR_US_MSPB_DECISION';
453: END IF;
454:
455: IF hr_api.not_exists_in_hr_lookups
456: (p_effective_date => p_effective_date,
457: p_lookup_type => l_lookup_type,
458: p_lookup_code => p_decision
459: ) THEN
496: hr_utility.set_location('Entering: '|| l_proc, 10);
497:
498: -- Check Mandatory Parameters are set
499:
500: hr_api.mandatory_arg_error
501: (p_api_name => l_proc,
502: p_argument => 'effective date',
503: p_argument_value => p_effective_date
504: );
516: p_object_version_number => p_object_version_number);
517:
518: IF (l_api_updating
519: AND
520: ((nvl(ghr_cca_shd.g_old_rec.rfr_requested_by,hr_api.g_varchar2)
521: <> nvl(p_rfr_requested_by,hr_api.g_varchar2))))
522: OR
523: NOT l_api_updating THEN
524:
517:
518: IF (l_api_updating
519: AND
520: ((nvl(ghr_cca_shd.g_old_rec.rfr_requested_by,hr_api.g_varchar2)
521: <> nvl(p_rfr_requested_by,hr_api.g_varchar2))))
522: OR
523: NOT l_api_updating THEN
524:
525: --
531: --
532:
533: IF p_rfr_requested_by is NOT NULL THEN
534:
535: IF hr_api.not_exists_in_hr_lookups
536: (p_effective_date => p_effective_date,
537: p_lookup_type => 'GHR_US_REQUESTOR',
538: p_lookup_code => p_rfr_requested_by
539: ) THEN
576: hr_utility.set_location('Entering: '|| l_proc, 10);
577:
578: -- Check Mandatory Parameters are set
579:
580: hr_api.mandatory_arg_error
581: (p_api_name => l_proc,
582: p_argument => 'effective date',
583: p_argument_value => p_effective_date
584: );
596: p_object_version_number => p_object_version_number);
597:
598: IF (l_api_updating
599: AND
600: ((nvl(ghr_cca_shd.g_old_rec.rfr_decision,hr_api.g_varchar2)
601: <> nvl(p_rfr_decision,hr_api.g_varchar2))))
602: OR
603: NOT l_api_updating THEN
604:
597:
598: IF (l_api_updating
599: AND
600: ((nvl(ghr_cca_shd.g_old_rec.rfr_decision,hr_api.g_varchar2)
601: <> nvl(p_rfr_decision,hr_api.g_varchar2))))
602: OR
603: NOT l_api_updating THEN
604:
605: --
611: --
612:
613: IF p_rfr_decision is NOT NULL THEN
614:
615: IF hr_api.not_exists_in_hr_lookups
616: (p_effective_date => p_effective_date,
617: p_lookup_type => 'GHR_US_OFO_RFR_DECISION',
618: p_lookup_code => p_rfr_decision
619: ) THEN