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.GHR_PAR_BUS dependencies on GHR_PA_REQUESTS

Line 43: (p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE

39: -- Internal Table Handler Use Only.
40: --
41: -- ---------------------------------------------------------------------------
42: procedure chk_nature_of_action_id
43: (p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
44: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
45: ,p_noa_family_code in ghr_pa_requests.noa_family_code%TYPE
46: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
47: ,p_effective_date in date

Line 44: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE

40: --
41: -- ---------------------------------------------------------------------------
42: procedure chk_nature_of_action_id
43: (p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
44: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
45: ,p_noa_family_code in ghr_pa_requests.noa_family_code%TYPE
46: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
47: ,p_effective_date in date
48: )is

Line 45: ,p_noa_family_code in ghr_pa_requests.noa_family_code%TYPE

41: -- ---------------------------------------------------------------------------
42: procedure chk_nature_of_action_id
43: (p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
44: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
45: ,p_noa_family_code in ghr_pa_requests.noa_family_code%TYPE
46: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
47: ,p_effective_date in date
48: )is
49: --

Line 46: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE

42: procedure chk_nature_of_action_id
43: (p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
44: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
45: ,p_noa_family_code in ghr_pa_requests.noa_family_code%TYPE
46: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
47: ,p_effective_date in date
48: )is
49: --
50: l_proc varchar2(72) := g_package ||'chk_nature_of_action_id';

Line 124: (p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE

120:
121: -- To check that the second nature of action is valid for the specific first_nature_of_action_id
122:
123: procedure chk_second_nature_of_action_id
124: (p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
125: ,p_second_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
126: , p_first_noa_code in ghr_pa_requests.first_noa_code%type
127: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
128: -- ,p_noa_family_code in ghr_pa_requests.noa_family_code%TYPE

Line 125: ,p_second_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE

121: -- To check that the second nature of action is valid for the specific first_nature_of_action_id
122:
123: procedure chk_second_nature_of_action_id
124: (p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
125: ,p_second_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
126: , p_first_noa_code in ghr_pa_requests.first_noa_code%type
127: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
128: -- ,p_noa_family_code in ghr_pa_requests.noa_family_code%TYPE
129: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE

Line 126: , p_first_noa_code in ghr_pa_requests.first_noa_code%type

122:
123: procedure chk_second_nature_of_action_id
124: (p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
125: ,p_second_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
126: , p_first_noa_code in ghr_pa_requests.first_noa_code%type
127: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
128: -- ,p_noa_family_code in ghr_pa_requests.noa_family_code%TYPE
129: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
130: ,p_effective_date in date

Line 127: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE

123: procedure chk_second_nature_of_action_id
124: (p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
125: ,p_second_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
126: , p_first_noa_code in ghr_pa_requests.first_noa_code%type
127: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
128: -- ,p_noa_family_code in ghr_pa_requests.noa_family_code%TYPE
129: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
130: ,p_effective_date in date
131: )is

Line 128: -- ,p_noa_family_code in ghr_pa_requests.noa_family_code%TYPE

124: (p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
125: ,p_second_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
126: , p_first_noa_code in ghr_pa_requests.first_noa_code%type
127: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
128: -- ,p_noa_family_code in ghr_pa_requests.noa_family_code%TYPE
129: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
130: ,p_effective_date in date
131: )is
132: --

Line 129: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE

125: ,p_second_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
126: , p_first_noa_code in ghr_pa_requests.first_noa_code%type
127: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
128: -- ,p_noa_family_code in ghr_pa_requests.noa_family_code%TYPE
129: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
130: ,p_effective_date in date
131: )is
132: --
133: l_proc varchar2(72) := g_package ||'chk_second_nature_of_action_id';

Line 232: (p_val_person_id in ghr_pa_requests.requested_by_person_id%TYPE

228: -- Internal Table Handler Use Only.
229: --
230: -- ---------------------------------------------------------------------------
231: function chk_valid_person_id
232: (p_val_person_id in ghr_pa_requests.requested_by_person_id%TYPE
233: ,p_effective_date in date
234: ) return char is
235: --
236: l_proc varchar2(72) := g_package ||'chk_valid_person_id';

Line 314: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE

310: --
311: -- ---------------------------------------------------------------------------
312:
313: procedure chk_additional_info_person_id
314: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
315: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
316: ,p_additional_info_person_id in ghr_pa_requests.additional_info_person_id%TYPE
317: ,p_effective_date in date) is
318:

Line 315: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE

311: -- ---------------------------------------------------------------------------
312:
313: procedure chk_additional_info_person_id
314: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
315: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
316: ,p_additional_info_person_id in ghr_pa_requests.additional_info_person_id%TYPE
317: ,p_effective_date in date) is
318:
319: l_exists varchar2(15);

Line 316: ,p_additional_info_person_id in ghr_pa_requests.additional_info_person_id%TYPE

312:
313: procedure chk_additional_info_person_id
314: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
315: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
316: ,p_additional_info_person_id in ghr_pa_requests.additional_info_person_id%TYPE
317: ,p_effective_date in date) is
318:
319: l_exists varchar2(15);
320: l_proc varchar2(72) := g_package ||'chk_additional_info_person_id';

Line 402: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE

398: --
399: -- ---------------------------------------------------------------------------
400:
401: procedure chk_requested_by_person_id
402: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
403: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
404: ,p_requested_by_person_id in ghr_pa_requests.requested_by_person_id%TYPE
405: ,p_effective_date in date) is
406:

Line 403: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE

399: -- ---------------------------------------------------------------------------
400:
401: procedure chk_requested_by_person_id
402: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
403: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
404: ,p_requested_by_person_id in ghr_pa_requests.requested_by_person_id%TYPE
405: ,p_effective_date in date) is
406:
407: l_exists varchar2(15);

Line 404: ,p_requested_by_person_id in ghr_pa_requests.requested_by_person_id%TYPE

400:
401: procedure chk_requested_by_person_id
402: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
403: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
404: ,p_requested_by_person_id in ghr_pa_requests.requested_by_person_id%TYPE
405: ,p_effective_date in date) is
406:
407: l_exists varchar2(15);
408: l_proc varchar2(72) := g_package ||'chk_requested_by_person_id';

Line 489: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE

485: --
486: -- ---------------------------------------------------------------------------
487:
488: procedure chk_person_id
489: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
490: ,p_noa_family_code in ghr_pa_requests.noa_family_code%TYPE
491: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
492: ,p_person_id in ghr_pa_requests.person_id%TYPE
493: ,p_first_noa_cancel_or_correct in ghr_pa_requests.first_noa_cancel_or_correct%TYPE

Line 490: ,p_noa_family_code in ghr_pa_requests.noa_family_code%TYPE

486: -- ---------------------------------------------------------------------------
487:
488: procedure chk_person_id
489: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
490: ,p_noa_family_code in ghr_pa_requests.noa_family_code%TYPE
491: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
492: ,p_person_id in ghr_pa_requests.person_id%TYPE
493: ,p_first_noa_cancel_or_correct in ghr_pa_requests.first_noa_cancel_or_correct%TYPE
494: ,p_effective_date in date) is

Line 491: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE

487:
488: procedure chk_person_id
489: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
490: ,p_noa_family_code in ghr_pa_requests.noa_family_code%TYPE
491: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
492: ,p_person_id in ghr_pa_requests.person_id%TYPE
493: ,p_first_noa_cancel_or_correct in ghr_pa_requests.first_noa_cancel_or_correct%TYPE
494: ,p_effective_date in date) is
495:

Line 492: ,p_person_id in ghr_pa_requests.person_id%TYPE

488: procedure chk_person_id
489: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
490: ,p_noa_family_code in ghr_pa_requests.noa_family_code%TYPE
491: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
492: ,p_person_id in ghr_pa_requests.person_id%TYPE
493: ,p_first_noa_cancel_or_correct in ghr_pa_requests.first_noa_cancel_or_correct%TYPE
494: ,p_effective_date in date) is
495:
496: l_exists varchar2(15);

Line 493: ,p_first_noa_cancel_or_correct in ghr_pa_requests.first_noa_cancel_or_correct%TYPE

489: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
490: ,p_noa_family_code in ghr_pa_requests.noa_family_code%TYPE
491: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
492: ,p_person_id in ghr_pa_requests.person_id%TYPE
493: ,p_first_noa_cancel_or_correct in ghr_pa_requests.first_noa_cancel_or_correct%TYPE
494: ,p_effective_date in date) is
495:
496: l_exists varchar2(15);
497: l_proc varchar2(72) := g_package ||'chk_person_id';

Line 589: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE

585: --
586: -- ---------------------------------------------------------------------------
587:
588: procedure chk_authorized_by_person_id
589: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
590: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
591: ,p_authorized_by_person_id in ghr_pa_requests.authorized_by_person_id%TYPE
592: ,p_effective_date in date) is
593:

Line 590: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE

586: -- ---------------------------------------------------------------------------
587:
588: procedure chk_authorized_by_person_id
589: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
590: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
591: ,p_authorized_by_person_id in ghr_pa_requests.authorized_by_person_id%TYPE
592: ,p_effective_date in date) is
593:
594: l_exists varchar2(15);

Line 591: ,p_authorized_by_person_id in ghr_pa_requests.authorized_by_person_id%TYPE

587:
588: procedure chk_authorized_by_person_id
589: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
590: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
591: ,p_authorized_by_person_id in ghr_pa_requests.authorized_by_person_id%TYPE
592: ,p_effective_date in date) is
593:
594: l_exists varchar2(15);
595: l_proc varchar2(72) := g_package ||'chk_authorized_by_person_id';

Line 673: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE

669: -- Internal Table Handler Use Only.
670: --
671:
672: procedure chk_employee_assignment_id
673: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
674: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
675: ,p_employee_assignment_id in ghr_pa_requests.employee_assignment_id%TYPE
676: ,p_effective_date in date
677: ) is

Line 674: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE

670: --
671:
672: procedure chk_employee_assignment_id
673: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
674: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
675: ,p_employee_assignment_id in ghr_pa_requests.employee_assignment_id%TYPE
676: ,p_effective_date in date
677: ) is
678: --

Line 675: ,p_employee_assignment_id in ghr_pa_requests.employee_assignment_id%TYPE

671:
672: procedure chk_employee_assignment_id
673: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
674: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
675: ,p_employee_assignment_id in ghr_pa_requests.employee_assignment_id%TYPE
676: ,p_effective_date in date
677: ) is
678: --
679: l_proc varchar2(72) := g_package||'chk_employee_assignment_id';

Line 689: FROM ghr_pa_requests par

685: l_ed_date date;
686: --
687: cursor cur_par_noa_code is
688: SELECT first_noa_code,noa_family_code
689: FROM ghr_pa_requests par
690: WHERE par.pa_request_id = p_pa_request_id;
691:
692: cursor cur_asg_id is
693: SELECT person_id

Line 821: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE

817: -- Internal Table Handler Use Only.
818: --
819:
820: procedure chk_from_position_id
821: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
822: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
823: ,p_employee_assignment_id in ghr_pa_requests.employee_assignment_id%TYPE
824: ,p_from_position_id in ghr_pa_requests.from_position_id%type
825: ,p_effective_date in date

Line 822: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE

818: --
819:
820: procedure chk_from_position_id
821: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
822: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
823: ,p_employee_assignment_id in ghr_pa_requests.employee_assignment_id%TYPE
824: ,p_from_position_id in ghr_pa_requests.from_position_id%type
825: ,p_effective_date in date
826: ) is

Line 823: ,p_employee_assignment_id in ghr_pa_requests.employee_assignment_id%TYPE

819:
820: procedure chk_from_position_id
821: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
822: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
823: ,p_employee_assignment_id in ghr_pa_requests.employee_assignment_id%TYPE
824: ,p_from_position_id in ghr_pa_requests.from_position_id%type
825: ,p_effective_date in date
826: ) is
827: --

Line 824: ,p_from_position_id in ghr_pa_requests.from_position_id%type

820: procedure chk_from_position_id
821: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
822: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
823: ,p_employee_assignment_id in ghr_pa_requests.employee_assignment_id%TYPE
824: ,p_from_position_id in ghr_pa_requests.from_position_id%type
825: ,p_effective_date in date
826: ) is
827: --
828: l_proc varchar2(72) := g_package||'chk_from_position_id';

Line 889: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE

885: -- |---------------------------< chk_first_action_la_code1>----------------------------|
886: -- ----------------------------------------------------------------------------
887: --
888: procedure chk_first_action_la_code1
889: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
890: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
891: ,p_first_action_la_code1 in ghr_pa_requests.first_action_la_code1%TYPE
892: ,p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
893: ,p_effective_date in date

Line 890: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE

886: -- ----------------------------------------------------------------------------
887: --
888: procedure chk_first_action_la_code1
889: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
890: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
891: ,p_first_action_la_code1 in ghr_pa_requests.first_action_la_code1%TYPE
892: ,p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
893: ,p_effective_date in date
894: )is

Line 891: ,p_first_action_la_code1 in ghr_pa_requests.first_action_la_code1%TYPE

887: --
888: procedure chk_first_action_la_code1
889: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
890: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
891: ,p_first_action_la_code1 in ghr_pa_requests.first_action_la_code1%TYPE
892: ,p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
893: ,p_effective_date in date
894: )is
895: --

Line 892: ,p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE

888: procedure chk_first_action_la_code1
889: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
890: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
891: ,p_first_action_la_code1 in ghr_pa_requests.first_action_la_code1%TYPE
892: ,p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
893: ,p_effective_date in date
894: )is
895: --
896: l_proc varchar2(72) := g_package||'chk_first_action_la_code1';

Line 967: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE

963: -- |---------------------------< chk_first_action_la_code2>----------------------------|
964: -- ----------------------------------------------------------------------------
965: --
966: procedure chk_first_action_la_code2
967: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
968: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
969: ,p_first_action_la_code2 in ghr_pa_requests.first_action_la_code2%TYPE
970: ,p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
971: ,p_effective_date in date

Line 968: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE

964: -- ----------------------------------------------------------------------------
965: --
966: procedure chk_first_action_la_code2
967: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
968: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
969: ,p_first_action_la_code2 in ghr_pa_requests.first_action_la_code2%TYPE
970: ,p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
971: ,p_effective_date in date
972: )is

Line 969: ,p_first_action_la_code2 in ghr_pa_requests.first_action_la_code2%TYPE

965: --
966: procedure chk_first_action_la_code2
967: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
968: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
969: ,p_first_action_la_code2 in ghr_pa_requests.first_action_la_code2%TYPE
970: ,p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
971: ,p_effective_date in date
972: )is
973: --

Line 970: ,p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE

966: procedure chk_first_action_la_code2
967: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
968: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
969: ,p_first_action_la_code2 in ghr_pa_requests.first_action_la_code2%TYPE
970: ,p_first_nature_of_action_id in ghr_pa_requests.first_noa_id%TYPE
971: ,p_effective_date in date
972: )is
973: --
974: l_proc varchar2(72) := g_package||'chk_first_action_la_code2';

Line 1068: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE

1064: -- Internal Table Handler Use Only.
1065: --
1066:
1067: procedure chk_duty_station_id
1068: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
1069: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
1070: ,p_duty_station_id in ghr_pa_requests.duty_station_id%TYPE
1071: ,p_effective_date in date
1072: ) is

Line 1069: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE

1065: --
1066:
1067: procedure chk_duty_station_id
1068: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
1069: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
1070: ,p_duty_station_id in ghr_pa_requests.duty_station_id%TYPE
1071: ,p_effective_date in date
1072: ) is
1073: --

Line 1070: ,p_duty_station_id in ghr_pa_requests.duty_station_id%TYPE

1066:
1067: procedure chk_duty_station_id
1068: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
1069: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
1070: ,p_duty_station_id in ghr_pa_requests.duty_station_id%TYPE
1071: ,p_effective_date in date
1072: ) is
1073: --
1074: l_proc varchar2(72) := g_package||'chk_duty_station_id';

Line 1144: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE

1140: -- |---------------------------< chk_second_action_la_code1>----------------------------|
1141: -- ----------------------------------------------------------------------------
1142: --
1143: procedure chk_second_action_la_code1
1144: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
1145: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
1146: ,p_second_action_la_code1 in ghr_pa_requests.second_action_la_code1%TYPE
1147: ,p_second_nature_of_action_id in ghr_pa_requests.second_noa_id%TYPE
1148: ,p_effective_date in date

Line 1145: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE

1141: -- ----------------------------------------------------------------------------
1142: --
1143: procedure chk_second_action_la_code1
1144: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
1145: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
1146: ,p_second_action_la_code1 in ghr_pa_requests.second_action_la_code1%TYPE
1147: ,p_second_nature_of_action_id in ghr_pa_requests.second_noa_id%TYPE
1148: ,p_effective_date in date
1149: )is

Line 1146: ,p_second_action_la_code1 in ghr_pa_requests.second_action_la_code1%TYPE

1142: --
1143: procedure chk_second_action_la_code1
1144: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
1145: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
1146: ,p_second_action_la_code1 in ghr_pa_requests.second_action_la_code1%TYPE
1147: ,p_second_nature_of_action_id in ghr_pa_requests.second_noa_id%TYPE
1148: ,p_effective_date in date
1149: )is
1150: --

Line 1147: ,p_second_nature_of_action_id in ghr_pa_requests.second_noa_id%TYPE

1143: procedure chk_second_action_la_code1
1144: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
1145: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
1146: ,p_second_action_la_code1 in ghr_pa_requests.second_action_la_code1%TYPE
1147: ,p_second_nature_of_action_id in ghr_pa_requests.second_noa_id%TYPE
1148: ,p_effective_date in date
1149: )is
1150: --
1151: l_proc varchar2(72) := g_package||'chk_second_action_la_code1';

Line 1221: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE

1217: -- |---------------------------< chk_second_action_la_code2>----------------------------|
1218: -- ----------------------------------------------------------------------------
1219: --
1220: procedure chk_second_action_la_code2
1221: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
1222: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
1223: ,p_second_action_la_code2 in ghr_pa_requests.second_action_la_code2%TYPE
1224: ,p_second_nature_of_action_id in ghr_pa_requests.second_noa_id%TYPE
1225: ,p_effective_date in date

Line 1222: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE

1218: -- ----------------------------------------------------------------------------
1219: --
1220: procedure chk_second_action_la_code2
1221: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
1222: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
1223: ,p_second_action_la_code2 in ghr_pa_requests.second_action_la_code2%TYPE
1224: ,p_second_nature_of_action_id in ghr_pa_requests.second_noa_id%TYPE
1225: ,p_effective_date in date
1226: )is

Line 1223: ,p_second_action_la_code2 in ghr_pa_requests.second_action_la_code2%TYPE

1219: --
1220: procedure chk_second_action_la_code2
1221: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
1222: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
1223: ,p_second_action_la_code2 in ghr_pa_requests.second_action_la_code2%TYPE
1224: ,p_second_nature_of_action_id in ghr_pa_requests.second_noa_id%TYPE
1225: ,p_effective_date in date
1226: )is
1227: --

Line 1224: ,p_second_nature_of_action_id in ghr_pa_requests.second_noa_id%TYPE

1220: procedure chk_second_action_la_code2
1221: (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
1222: ,p_object_version_number in ghr_pa_requests.object_version_number%TYPE
1223: ,p_second_action_la_code2 in ghr_pa_requests.second_action_la_code2%TYPE
1224: ,p_second_nature_of_action_id in ghr_pa_requests.second_noa_id%TYPE
1225: ,p_effective_date in date
1226: )is
1227: --
1228: l_proc varchar2(72) := g_package||'chk_second_action_la_code2';

Line 1450: ,p_descflex_name => 'GHR_PA_REQUESTS'

1446: -- Call hr_dflex_utility.ins_or_upd_descflex_attribs procedure to validate Descritive Flex Fields
1447:
1448: hr_dflex_utility.ins_or_upd_descflex_attribs
1449: (p_appl_short_name => 'GHR'
1450: ,p_descflex_name => 'GHR_PA_REQUESTS'
1451: ,p_attribute_category => p_rec.attribute_category
1452: ,p_attribute1_name => 'ATTRIBUTE1'
1453: ,p_attribute1_value => p_rec.ATTRIBUTE1
1454: ,p_attribute2_name => 'ATTRIBUTE2'

Line 1649: ,p_descflex_name => 'GHR_PA_REQUESTS'

1645: -- Call hr_dflex_utility.ins_or_upd_descflex_attribs procedure to validate Descritive Flex Fields
1646:
1647: hr_dflex_utility.ins_or_upd_descflex_attribs
1648: (p_appl_short_name => 'GHR'
1649: ,p_descflex_name => 'GHR_PA_REQUESTS'
1650: ,p_attribute_category => p_rec.attribute_category
1651: ,p_attribute1_name => 'ATTRIBUTE1'
1652: ,p_attribute1_value => p_rec.ATTRIBUTE1
1653: ,p_attribute2_name => 'ATTRIBUTE2'

Line 1743: Procedure convert_defaults(p_rec in out nocopy ghr_pa_requests%rowtype) is

1739: -- Internal Row Handler Use Only.
1740: --
1741: -- {End Of Comments}
1742: -- ----------------------------------------------------------------------------
1743: Procedure convert_defaults(p_rec in out nocopy ghr_pa_requests%rowtype) is
1744: --
1745: l_proc varchar2(72) := g_package||'convert_defaults';
1746: --
1747: Begin