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_SF52_VALIDN_PKG dependencies on GHR_PA_REQUESTS

Line 20: (p_requested_by_person_id in ghr_pa_requests.requested_by_person_id%type

16: -- ---------------------------------------------------------------------------
17: --
18:
19: procedure chk_requested_by_title
20: (p_requested_by_person_id in ghr_pa_requests.requested_by_person_id%type
21: ,p_requested_by_title in ghr_pa_requests.requested_by_title%type
22: ,p_effective_date in date
23: )
24: is

Line 21: ,p_requested_by_title in ghr_pa_requests.requested_by_title%type

17: --
18:
19: procedure chk_requested_by_title
20: (p_requested_by_person_id in ghr_pa_requests.requested_by_person_id%type
21: ,p_requested_by_title in ghr_pa_requests.requested_by_title%type
22: ,p_effective_date in date
23: )
24: is
25:

Line 26: l_title ghr_pa_requests.requested_by_title%type;

22: ,p_effective_date in date
23: )
24: is
25:
26: l_title ghr_pa_requests.requested_by_title%type;
27: l_proc varchar2(72) := g_package ||'chk_requested_by_title' ;
28:
29: begin
30: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 54: (p_authorized_by_person_id in ghr_pa_requests.authorized_by_person_id%type

50: -- ---------------------------------------------------------------------------
51: --
52:
53: procedure chk_authorized_by_title
54: (p_authorized_by_person_id in ghr_pa_requests.authorized_by_person_id%type
55: ,p_authorized_by_title in ghr_pa_requests.authorized_by_title%type
56: ,p_effective_date in date
57: )
58: is

Line 55: ,p_authorized_by_title in ghr_pa_requests.authorized_by_title%type

51: --
52:
53: procedure chk_authorized_by_title
54: (p_authorized_by_person_id in ghr_pa_requests.authorized_by_person_id%type
55: ,p_authorized_by_title in ghr_pa_requests.authorized_by_title%type
56: ,p_effective_date in date
57: )
58: is
59:

Line 60: l_title ghr_pa_requests.authorized_by_title%type;

56: ,p_effective_date in date
57: )
58: is
59:
60: l_title ghr_pa_requests.authorized_by_title%type;
61: l_proc varchar2(72) := g_package ||'chk_authorized_by_title' ;
62:
63: begin
64: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 89: (p_pa_request_rec in ghr_pa_requests%rowtype

85: -- ---------------------------------------------------------------------------
86: --
87:
88: Procedure prelim_req_chk_for_update_hr
89: (p_pa_request_rec in ghr_pa_requests%rowtype
90: ) is
91:
92: l_proc varchar2(72) := g_package || 'primary_reqd_chk_for_update_hr';
93: l_notification_id ghr_pa_requests.pa_notification_id%type;

Line 93: l_notification_id ghr_pa_requests.pa_notification_id%type;

89: (p_pa_request_rec in ghr_pa_requests%rowtype
90: ) is
91:
92: l_proc varchar2(72) := g_package || 'primary_reqd_chk_for_update_hr';
93: l_notification_id ghr_pa_requests.pa_notification_id%type;
94: l_person_type per_person_types.system_person_type%type;
95: l_session ghr_history_api.g_session_var_type;
96:
97: l_new_line VARCHAR2(1) := substr('

Line 103: from ghr_pa_requests par

99: l_null_list VARCHAR2(120) ; -- Bug 1844515 Anil
100:
101: Cursor c_sf50 is
102: select pa_notification_id
103: from ghr_pa_requests par
104: where par.pa_request_id = p_pa_request_rec.pa_request_id;
105:
106: Cursor c_per_type is
107: Select ppt.system_person_type

Line 227: ,p_to_position_title in ghr_pa_requests.to_position_title%type

223: --
224:
225: procedure chk_position_title_seq_desc
226: (p_to_position_id in per_positions.position_id%type
227: ,p_to_position_title in ghr_pa_requests.to_position_title%type
228: ,p_to_position_number in ghr_pa_requests.to_position_number%type
229: ,p_to_position_seq_no in ghr_pa_requests.to_position_seq_no%type
230: ,p_effective_date in date default sysdate
231: )

Line 228: ,p_to_position_number in ghr_pa_requests.to_position_number%type

224:
225: procedure chk_position_title_seq_desc
226: (p_to_position_id in per_positions.position_id%type
227: ,p_to_position_title in ghr_pa_requests.to_position_title%type
228: ,p_to_position_number in ghr_pa_requests.to_position_number%type
229: ,p_to_position_seq_no in ghr_pa_requests.to_position_seq_no%type
230: ,p_effective_date in date default sysdate
231: )
232: is

Line 229: ,p_to_position_seq_no in ghr_pa_requests.to_position_seq_no%type

225: procedure chk_position_title_seq_desc
226: (p_to_position_id in per_positions.position_id%type
227: ,p_to_position_title in ghr_pa_requests.to_position_title%type
228: ,p_to_position_number in ghr_pa_requests.to_position_number%type
229: ,p_to_position_seq_no in ghr_pa_requests.to_position_seq_no%type
230: ,p_effective_date in date default sysdate
231: )
232: is
233: l_bgp_id per_positions.business_group_id%type;

Line 234: l_title ghr_pa_requests.to_position_title%type;

230: ,p_effective_date in date default sysdate
231: )
232: is
233: l_bgp_id per_positions.business_group_id%type;
234: l_title ghr_pa_requests.to_position_title%type;
235: l_desc_no varchar2(150);
236: l_seq_no number;
237: l_proc varchar2(72) := g_package ||'chk_position_title_seq_desc' ;
238:

Line 298: (p_award_uom in ghr_pa_requests.award_uom%TYPE

294: -- |-----------------------------< chk_award_uom>---------------------------|
295: -- ---------------------------------------------------------------------------
296:
297: procedure chk_award_uom
298: (p_award_uom in ghr_pa_requests.award_uom%TYPE
299: ,p_effective_date in date) is
300:
301: l_not_exists boolean ;
302: l_proc varchar2(72) := g_package ||'chk_award_uom';

Line 334: (p_appropriation_code1 in ghr_pa_requests.appropriation_code1%TYPE

330: -- |-----------------------------< chk_appropriation_code1>---------------------------|
331: -- ---------------------------------------------------------------------------
332:
333: procedure chk_appropriation_code1
334: (p_appropriation_code1 in ghr_pa_requests.appropriation_code1%TYPE
335: ,p_effective_date in date) is
336:
337: l_not_exists boolean ;
338: l_proc varchar2(72) := g_package ||'chk_appropriation_code1';

Line 370: (p_appropriation_code2 in ghr_pa_requests.appropriation_code2%TYPE

366: -- |-----------------------------< chk_appropriation_code2>---------------------------|
367: -- ---------------------------------------------------------------------------
368:
369: procedure chk_appropriation_code2
370: (p_appropriation_code2 in ghr_pa_requests.appropriation_code2%TYPE
371: ,p_effective_date in date) is
372:
373: l_not_exists boolean ;
374: l_proc varchar2(72) := g_package ||'chk_appropriation_code2';

Line 407: (p_annuitant_indicator in ghr_pa_requests.annuitant_indicator%TYPE

403: -- |-----------------------------< chk_annuitant_indicator>---------------------------|
404: -- ---------------------------------------------------------------------------
405:
406: procedure chk_annuitant_indicator
407: (p_annuitant_indicator in ghr_pa_requests.annuitant_indicator%TYPE
408: ,p_effective_date in date) is
409:
410: l_not_exists boolean ;
411: l_proc varchar2(72) := g_package ||'chk_annuitant_indicator';

Line 443: (p_bargaining_unit_status in ghr_pa_requests.bargaining_unit_status%TYPE

439: -- |-----------------------------< chk_bargaining_unit_status>---------------------------|
440: -- ---------------------------------------------------------------------------
441:
442: procedure chk_bargaining_unit_status
443: (p_bargaining_unit_status in ghr_pa_requests.bargaining_unit_status%TYPE
444: ,p_effective_date in date) is
445:
446: l_not_exists boolean;
447: l_proc varchar2(72) := g_package ||'chk_bargaining_unit_status';

Line 479: (p_supervisory_status in ghr_pa_requests.supervisory_status%TYPE

475: -- |-----------------------------< chk_supervisory_status>---------------------------|
476: -- ---------------------------------------------------------------------------
477:
478: procedure chk_supervisory_status
479: (p_supervisory_status in ghr_pa_requests.supervisory_status%TYPE
480: ,p_effective_date in date) is
481:
482: l_not_exists boolean;
483: l_proc varchar2(72) := g_package ||'chk_supervisory_status';

Line 513: (p_functional_class in ghr_pa_requests.functional_class%TYPE

509: -- |-----------------------------< chk_functional_class>---------------------------|
510: -- ---------------------------------------------------------------------------
511:
512: procedure chk_functional_class
513: (p_functional_class in ghr_pa_requests.functional_class%TYPE
514: ,p_effective_date in date) is
515:
516: l_not_exists boolean ;
517: l_proc varchar2(72) := g_package ||'chk_functional_class';

Line 547: (p_position_occupied in ghr_pa_requests.position_occupied%TYPE

543: -- |-----------------------------< chk_position_occupied>---------------------------|
544: -- ---------------------------------------------------------------------------
545:
546: procedure chk_position_occupied
547: (p_position_occupied in ghr_pa_requests.position_occupied%TYPE
548: ,p_effective_date in date) is
549:
550: l_not_exists boolean ;
551: l_proc varchar2(72) := g_package ||'chk_position_occupied';

Line 581: (p_fegli in ghr_pa_requests.fegli%TYPE

577: -- |-----------------------------< chk_fegli>---------------------------|
578: -- ---------------------------------------------------------------------------
579:
580: procedure chk_fegli
581: (p_fegli in ghr_pa_requests.fegli%TYPE
582: ,p_effective_date in date) is
583:
584: l_not_exists boolean ;
585: l_proc varchar2(72) := g_package ||'chk_fegli';

Line 618: (p_retirement_plan in ghr_pa_requests.retirement_plan%TYPE

614:
615:
616:
617: procedure chk_retirement_plan
618: (p_retirement_plan in ghr_pa_requests.retirement_plan%TYPE
619: ,p_effective_date in date
620: ) is
621:
622: l_not_exists boolean;

Line 654: (p_tenure in ghr_pa_requests.tenure%TYPE

650: -- |-----------------------------< chk_tenure>---------------------------|
651: -- ---------------------------------------------------------------------------
652:
653: procedure chk_tenure
654: (p_tenure in ghr_pa_requests.tenure%TYPE
655: ,p_effective_date in date) is
656:
657: l_not_exists boolean;
658: l_proc varchar2(72) := g_package ||'chk_tenure';

Line 690: (p_pay_rate_determinant in ghr_pa_requests.pay_rate_determinant%TYPE

686: -- |-----------------------------< chk_pay_rate_determinant>---------------------------|
687: -- ---------------------------------------------------------------------------
688:
689: procedure chk_pay_rate_determinant
690: (p_pay_rate_determinant in ghr_pa_requests.pay_rate_determinant%TYPE
691: ,p_effective_date in date
692: ) is
693:
694: l_not_exists boolean ;

Line 726: (p_pay_basis in ghr_pa_requests.to_pay_basis%TYPE

722: -- |-----------------------------< chk_pay_basis>---------------------------|
723: -- ---------------------------------------------------------------------------
724:
725: procedure chk_pay_basis
726: (p_pay_basis in ghr_pa_requests.to_pay_basis%TYPE
727: ,p_effective_date in date
728: ) is
729:
730: l_not_exists boolean ;

Line 764: (p_pay_plan in ghr_pa_requests.to_pay_plan%TYPE

760: -- Note : This procedure is no longer reqd. as the col. from and to pay_plans
761: -- are foreign keys to the ghr_pay_plan table
762:
763: procedure chk_pay_plan
764: (p_pay_plan in ghr_pa_requests.to_pay_plan%TYPE
765: ,p_effective_date in date
766: ) is
767:
768: l_not_exists boolean ;

Line 800: (p_grade_or_level in ghr_pa_requests.to_grade_or_level%TYPE

796: -- |-----------------------------< chk_grade_or_level>---------------------------|
797: -- ---------------------------------------------------------------------------
798:
799: procedure chk_grade_or_level
800: (p_grade_or_level in ghr_pa_requests.to_grade_or_level%TYPE
801: ,p_effective_date in date
802: ) is
803:
804: l_not_exists boolean ;

Line 836: (p_to_occ_code in ghr_pa_requests.to_occ_code%TYPE

832: -- |-----------------------------< chk_to_occ_code>---------------------------|
833: -- ---------------------------------------------------------------------------
834:
835: procedure chk_to_occ_code
836: (p_to_occ_code in ghr_pa_requests.to_occ_code%TYPE
837: ,p_effective_date in date
838: ) is
839:
840: l_not_exists boolean ;

Line 872: (p_step_or_rate in ghr_pa_requests.to_step_or_rate%TYPE

868: -- |-----------------------------< chk_step_or_rate>---------------------------|
869: -- ---------------------------------------------------------------------------
870:
871: procedure chk_step_or_rate
872: (p_step_or_rate in ghr_pa_requests.to_step_or_rate%TYPE
873: ,p_effective_date in date
874: ) is
875:
876: l_not_exists boolean ;

Line 908: (p_citizenship in ghr_pa_requests.citizenship%TYPE

904: -- |-----------------------------< chk_citizenship>---------------------------|
905: -- ---------------------------------------------------------------------------
906:
907: procedure chk_citizenship
908: (p_citizenship in ghr_pa_requests.citizenship%TYPE
909: ,p_effective_date in date
910: ) is
911:
912: l_not_exists boolean ;

Line 945: (p_veterans_status in ghr_pa_requests.veterans_status%TYPE

941: -- |-----------------------------< chk_vet_status>---------------------------|
942: -- ---------------------------------------------------------------------------
943:
944: procedure chk_vet_status
945: (p_veterans_status in ghr_pa_requests.veterans_status%TYPE
946: ,p_effective_date in date
947: ) is
948:
949: l_not_exists boolean ;

Line 981: (p_veterans_preference in ghr_pa_requests.veterans_preference%TYPE

977: -- |-----------------------------< chk_vet_pref>---------------------------|
978: -- ---------------------------------------------------------------------------
979:
980: procedure chk_vet_pref
981: (p_veterans_preference in ghr_pa_requests.veterans_preference%TYPE
982: ,p_effective_date in date
983: ) is
984:
985: l_not_exists boolean ;

Line 1017: (p_work_schedule in ghr_pa_requests.work_schedule%TYPE

1013: -- |-----------------------------< chk_work_schedule>---------------------------|
1014: -- ---------------------------------------------------------------------------
1015:
1016: procedure chk_work_schedule
1017: (p_work_schedule in ghr_pa_requests.work_schedule%TYPE
1018: ,p_effective_date in date
1019: ) is
1020:
1021: l_not_exists boolean ;

Line 1053: (p_academic_discipline in ghr_pa_requests.academic_discipline%TYPE

1049: -- |-----------------------------< chk_academic_discipline>---------------------------|
1050: -- ---------------------------------------------------------------------------
1051:
1052: procedure chk_academic_discipline
1053: (p_academic_discipline in ghr_pa_requests.academic_discipline%TYPE
1054: ,p_effective_date in date
1055: ) is
1056:
1057: l_not_exists boolean ;

Line 1089: (p_education_level in ghr_pa_requests.education_level%TYPE

1085: -- |-----------------------------< chk_education_level>---------------------------|
1086: -- ---------------------------------------------------------------------------
1087:
1088: procedure chk_education_level
1089: (p_education_level in ghr_pa_requests.education_level%TYPE
1090: ,p_effective_date in date
1091: ) is
1092:
1093: l_not_exists boolean ;

Line 1125: (p_year_degree_attained in ghr_pa_requests.year_degree_attained%TYPE

1121: -- |-----------------------------< chk_year_degree_attained>---------------------------|
1122: -- ---------------------------------------------------------------------------
1123:
1124: procedure chk_year_degree_attained
1125: (p_year_degree_attained in ghr_pa_requests.year_degree_attained%TYPE
1126: ) is
1127:
1128: begin
1129: If p_year_degree_attained > to_number(to_char(sysdate,'yyyy')) then

Line 1140: (p_rec in ghr_pa_requests%ROWTYPE

1136: -- ---------------------------------------------------------------------------
1137: -- |-----------------------------< perform_validation>---------------------------|
1138: -- ---------------------------------------------------------------------------
1139: procedure perform_validn
1140: (p_rec in ghr_pa_requests%ROWTYPE
1141: ) is
1142:
1143: begin
1144: