59: hr_utility.set_location('Entering: '|| l_proc, 10);
60:
61: -- Check Mandatory Parameters are set
62:
63: hr_api.mandatory_arg_error
64: (p_api_name => l_proc,
65: p_argument => 'effective date',
66: p_argument_value => p_effective_date
67: );
79: p_object_version_number => p_object_version_number);
80:
81: IF (l_api_updating
82: AND
83: ((nvl(ghr_pdi_shd.g_old_rec.category,hr_api.g_varchar2)
84: <> nvl(p_category,hr_api.g_varchar2))))
85: OR
86: NOT l_api_updating THEN
87:
80:
81: IF (l_api_updating
82: AND
83: ((nvl(ghr_pdi_shd.g_old_rec.category,hr_api.g_varchar2)
84: <> nvl(p_category,hr_api.g_varchar2))))
85: OR
86: NOT l_api_updating THEN
87:
88: --
129: hr_utility.set_location('Entering: '|| l_proc, 10);
130:
131: -- Check Mandatory Parameters are set
132:
133: hr_api.mandatory_arg_error
134: (p_api_name => l_proc,
135: p_argument => 'effective date',
136: p_argument_value => p_effective_date
137: );
149: p_object_version_number => p_object_version_number);
150:
151: IF (l_api_updating
152: AND
153: ((nvl(ghr_pdi_shd.g_old_rec.flsa,hr_api.g_varchar2)
154: <> nvl(p_flsa,hr_api.g_varchar2))))
155: OR
156: NOT l_api_updating THEN
157:
150:
151: IF (l_api_updating
152: AND
153: ((nvl(ghr_pdi_shd.g_old_rec.flsa,hr_api.g_varchar2)
154: <> nvl(p_flsa,hr_api.g_varchar2))))
155: OR
156: NOT l_api_updating THEN
157:
158: --
164: --
165:
166: IF p_flsa is NOT NULL THEN
167:
168: IF hr_api.not_exists_in_hr_lookups
169: (p_effective_date => p_effective_date,
170: p_lookup_type => 'GHR_US_FLSA_CATEGORY',
171: p_lookup_code => p_flsa
172: ) THEN
205: hr_utility.set_location('Entering: '|| l_proc, 10);
206:
207: -- Check Mandatory Parameters are set
208:
209: hr_api.mandatory_arg_error
210:
211: (p_api_name => l_proc,
212: p_argument => 'effective date',
213: p_argument_value => p_effective_date
226: p_object_version_number => p_object_version_number);
227:
228: IF (l_api_updating
229: AND
230: ((nvl(ghr_pdi_shd.g_old_rec.financial_statement,hr_api.g_varchar2)
231: <> nvl(p_financial_statement,hr_api.g_varchar2))))
232: OR
233: NOT l_api_updating THEN
234: --
227:
228: IF (l_api_updating
229: AND
230: ((nvl(ghr_pdi_shd.g_old_rec.financial_statement,hr_api.g_varchar2)
231: <> nvl(p_financial_statement,hr_api.g_varchar2))))
232: OR
233: NOT l_api_updating THEN
234: --
235: hr_utility.set_location(l_proc,20);
240: --
241:
242: IF p_financial_statement is NOT NULL THEN
243:
244: IF hr_api.not_exists_in_hr_lookups
245: (p_effective_date => p_effective_date,
246: p_lookup_type => 'GHR_US_FINANCIAL_STATEMENT',
247: p_lookup_code => p_financial_statement
248: ) THEN
284: hr_utility.set_location('Entering: '|| l_proc, 10);
285:
286: -- Check Mandatory Parameters are set
287:
288: hr_api.mandatory_arg_error
289: (p_api_name => l_proc,
290: p_argument => 'effective date',
291: p_argument_value => p_effective_date
292: );
304: p_object_version_number => p_object_version_number);
305:
306: IF (l_api_updating
307: AND
308: ((nvl(ghr_pdi_shd.g_old_rec.subject_to_ia_action,hr_api.g_varchar2)
309: <> nvl(p_sub_to_ia_action,hr_api.g_varchar2))))
310: OR
311: NOT l_api_updating THEN
312: --
305:
306: IF (l_api_updating
307: AND
308: ((nvl(ghr_pdi_shd.g_old_rec.subject_to_ia_action,hr_api.g_varchar2)
309: <> nvl(p_sub_to_ia_action,hr_api.g_varchar2))))
310: OR
311: NOT l_api_updating THEN
312: --
313: hr_utility.set_location(l_proc,20);
318: --
319:
320: IF p_sub_to_ia_action is NOT NULL THEN
321:
322: IF hr_api.not_exists_in_hr_lookups
323: (p_effective_date => p_effective_date,
324: p_lookup_type => 'YES_NO',
325: p_lookup_code => p_sub_to_ia_action
326: ) THEN
362: hr_utility.set_location('Entering: '|| l_proc, 10);
363:
364: -- Check Mandatory Parameters are set
365:
366: hr_api.mandatory_arg_error
367: (p_api_name => l_proc,
368: p_argument => 'effective date',
369: p_argument_value => p_effective_date
370: );
382: p_object_version_number => p_object_version_number);
383:
384: IF (l_api_updating
385: AND
386: ((nvl(ghr_pdi_shd.g_old_rec.position_status,hr_api.g_number)
387: <> nvl(p_position_status,hr_api.g_number))))
388: OR
389: NOT l_api_updating THEN
390:
383:
384: IF (l_api_updating
385: AND
386: ((nvl(ghr_pdi_shd.g_old_rec.position_status,hr_api.g_number)
387: <> nvl(p_position_status,hr_api.g_number))))
388: OR
389: NOT l_api_updating THEN
390:
391: --
397: --
398:
399: IF p_position_status is NOT NULL THEN
400:
401: IF hr_api.not_exists_in_hr_lookups
402: (p_effective_date => p_effective_date,
403: p_lookup_type => 'GHR_US_POSITION_OCCUPIED',
404: p_lookup_code => p_position_status
405: ) THEN
441: hr_utility.set_location('Entering: '|| l_proc, 10);
442:
443: -- Check Mandatory Parameters are set
444:
445: hr_api.mandatory_arg_error
446: (p_api_name => l_proc,
447: p_argument => 'effective date',
448: p_argument_value => p_effective_date
449: );
461: p_object_version_number => p_object_version_number);
462:
463: IF (l_api_updating
464: AND
465: ((nvl(ghr_pdi_shd.g_old_rec.position_is,hr_api.g_varchar2)
466: <> nvl(p_position_is,hr_api.g_varchar2))))
467: OR
468: NOT l_api_updating THEN
469:
462:
463: IF (l_api_updating
464: AND
465: ((nvl(ghr_pdi_shd.g_old_rec.position_is,hr_api.g_varchar2)
466: <> nvl(p_position_is,hr_api.g_varchar2))))
467: OR
468: NOT l_api_updating THEN
469:
470: --
476: --
477:
478: IF p_position_is is NOT NULL THEN
479:
480: IF hr_api.not_exists_in_hr_lookups
481: (p_effective_date => p_effective_date,
482: p_lookup_type => 'GHR_US_SUPERVISORY_STATUS',
483: p_lookup_code => p_position_is
484: ) THEN
519: hr_utility.set_location('Entering: '|| l_proc, 10);
520:
521: -- Check Mandatory Parameters are set
522:
523: hr_api.mandatory_arg_error
524: (p_api_name => l_proc,
525: p_argument => 'effective date',
526: p_argument_value => p_effective_date
527: );
539: p_object_version_number => p_object_version_number);
540:
541: IF (l_api_updating
542: AND
543: ((nvl(ghr_pdi_shd.g_old_rec.position_sensitivity,hr_api.g_varchar2)
544: <> nvl(p_position_sensitivity,hr_api.g_varchar2))))
545: OR
546: NOT l_api_updating THEN
547:
540:
541: IF (l_api_updating
542: AND
543: ((nvl(ghr_pdi_shd.g_old_rec.position_sensitivity,hr_api.g_varchar2)
544: <> nvl(p_position_sensitivity,hr_api.g_varchar2))))
545: OR
546: NOT l_api_updating THEN
547:
548: --
554: --
555:
556: IF p_position_sensitivity is NOT NULL THEN
557:
558: IF hr_api.not_exists_in_hr_lookups
559: (p_effective_date => p_effective_date,
560: p_lookup_type => 'GHR_US_POSN_SENSITIVITY',
561: p_lookup_code => p_position_sensitivity
562: ) THEN
597: hr_utility.set_location('Entering: '|| l_proc, 10);
598:
599: -- Check Mandatory Parameters are set
600:
601: hr_api.mandatory_arg_error
602: (p_api_name => l_proc,
603: p_argument => 'effective date',
604: p_argument_value => p_effective_date
605: );
617: p_object_version_number => p_object_version_number);
618:
619: IF (l_api_updating
620: AND
621: ((nvl(ghr_pdi_shd.g_old_rec.competitive_level,hr_api.g_varchar2)
622: <> nvl(p_competitive_level,hr_api.g_varchar2))))
623: OR
624: NOT l_api_updating THEN
625:
618:
619: IF (l_api_updating
620: AND
621: ((nvl(ghr_pdi_shd.g_old_rec.competitive_level,hr_api.g_varchar2)
622: <> nvl(p_competitive_level,hr_api.g_varchar2))))
623: OR
624: NOT l_api_updating THEN
625:
626:
632: --
633:
634: -- IF p_competitive_level is NOT NULL THEN
635: --
636: -- IF hr_api.not_exists_in_hr_lookups
637: -- (p_effective_date => p_effective_date,
638: -- p_lookup_type => 'GHR_US_COMP_LEVEL',
639: -- p_lookup_code => p_competitive_level
640: -- ) THEN
676: hr_utility.set_location('Entering: '|| l_proc, 10);
677:
678: -- Check Mandatory Parameters are set
679:
680: hr_api.mandatory_arg_error
681: (p_api_name => l_proc,
682: p_argument => 'effective date',
683: p_argument_value => p_effective_date
684: );
696: p_object_version_number => p_object_version_number);
697:
698: IF (l_api_updating
699: AND
700: ((nvl(ghr_pdi_shd.g_old_rec.career_ladder,hr_api.g_varchar2)
701: <> nvl(p_career_ladder,hr_api.g_varchar2))))
702: OR
703: NOT l_api_updating THEN
704:
697:
698: IF (l_api_updating
699: AND
700: ((nvl(ghr_pdi_shd.g_old_rec.career_ladder,hr_api.g_varchar2)
701: <> nvl(p_career_ladder,hr_api.g_varchar2))))
702: OR
703: NOT l_api_updating THEN
704:
705: --
711: --
712:
713: IF p_career_ladder is NOT NULL THEN
714:
715: IF hr_api.not_exists_in_hr_lookups
716: (p_effective_date => p_effective_date,
717: p_lookup_type => 'YES_NO',
718: p_lookup_code => p_career_ladder
719: ) THEN
802: /*
803:
804: -- To be changed in the screens to base it on the user role.
805:
806: IF NVL(p_rec.date_to, hr_api.g_date)
807: <> NVL(ghr_pdi_shd.g_old_rec.date_to,hr_api.g_date)
808: THEN
809:
810: l_argument := 'date_to';
803:
804: -- To be changed in the screens to base it on the user role.
805:
806: IF NVL(p_rec.date_to, hr_api.g_date)
807: <> NVL(ghr_pdi_shd.g_old_rec.date_to,hr_api.g_date)
808: THEN
809:
810: l_argument := 'date_to';
811: RAISE l_error;
812: END IF;
813:
814: */
815:
816: IF NVL(p_rec.opm_cert_num, hr_api.g_number)
817: <> NVL(ghr_pdi_shd.g_old_rec.opm_cert_num,hr_api.g_number)
818: THEN
819:
820: l_argument := 'opm_cert_num';
813:
814: */
815:
816: IF NVL(p_rec.opm_cert_num, hr_api.g_number)
817: <> NVL(ghr_pdi_shd.g_old_rec.opm_cert_num,hr_api.g_number)
818: THEN
819:
820: l_argument := 'opm_cert_num';
821: RAISE l_error;
828: EXCEPTION
829:
830: WHEN l_error THEN
831:
832: hr_api.argument_changed_error
833:
834: (p_api_name => l_proc,
835: p_argument => l_argument);
836: