[Home] [Help]
10: -- ----------------------------------------------------------------------------
11: -- {Start Of Comments}
12: --
13: -- Description:
14: -- Verify that the value in PA_REQUEST_ID is in the GHR_PA_REQUESTS table.
15: --
16: -- Pre Conditions:
17: --
18: --
44: l_dummy varchar2(1);
45: --
46: cursor c_valid_req is
47: select 'x'
48: from ghr_pa_requests
49: where pa_request_id = p_pa_request_id;
50: --
51: Begin
52: hr_utility.set_location('Entering:'||l_proc, 1);
60: p_argument_value => p_pa_request_id
61: );
62: hr_utility.set_location(l_proc, 2);
63: --
64: -- Check that the pa_request_id is in the ghr_pa_requests table.
65: --
66: open c_valid_req;
67: fetch c_valid_req into l_dummy;
68: if c_valid_req%notfound then
553: (p_rec in ghr_rei_shd.g_rec_type
554: ) is
555:
556: l_proc varchar2(72) := g_package||'chk_ddf_for_866';
557: l_first_noa_code ghr_pa_requests.first_noa_code%type;
558: l_effective_date date;
559:
560: Cursor c_date_end is
561: Select pei_information2
563: Where person_extra_info_id = p_rec.rei_information3;
564:
565: Cursor c_find_noa_code is
566: Select first_noa_code,effective_date
567: From ghr_pa_requests
568: Where pa_request_id = p_rec.pa_request_id;
569:
570: Begin
571:
625: (p_rec in ghr_rei_shd.g_rec_type
626: ) is
627:
628: l_proc varchar2(72) := g_package||'chk_ddf_for_temp_promo';
629: l_first_noa_code ghr_pa_requests.first_noa_code%type;
630: l_effective_date date;
631: l_person_id ghr_pa_requests.person_id%type;
632:
633:
627:
628: l_proc varchar2(72) := g_package||'chk_ddf_for_temp_promo';
629: l_first_noa_code ghr_pa_requests.first_noa_code%type;
630: l_effective_date date;
631: l_person_id ghr_pa_requests.person_id%type;
632:
633:
634: Cursor c_find_noa_code is
635: Select first_noa_code,effective_date,person_id
632:
633:
634: Cursor c_find_noa_code is
635: Select first_noa_code,effective_date,person_id
636: From ghr_pa_requests
637: Where pa_request_id = p_rec.pa_request_id;
638:
639: l_retained_grade ghr_pay_calc.retained_grade_rec_type;
640: Begin
680: l_bus_group_id per_people_f.business_group_id%type;
681:
682: -- Bug#5729582 (i)added local variable l_effective_date
683: -- (ii) Modified the cursors c_get_perpos_ids,c_per_bus_group_id,c_pos_bus_group_id
684: l_effective_date ghr_pa_requests.effective_date%type;
685:
686: cursor c_get_perpos_ids is
687: select par.person_id,nvl(par.from_position_id,par.to_position_id) position_id,
688: par.effective_date
685:
686: cursor c_get_perpos_ids is
687: select par.person_id,nvl(par.from_position_id,par.to_position_id) position_id,
688: par.effective_date
689: from ghr_pa_requests par
690: where pa_request_id = p_rec.pa_request_id;
691: cursor c_per_bus_group_id(p_person_id in per_people_f.person_id%TYPE) is
692: select ppf.business_group_id
693: from per_people_f ppf
811: ghr_rei_flex_ddf.ddf(p_rec) ;
812: */
813: -- Business group Id has to be populated for the server side DDF Validation
814: -- Get the Business Group Id as follows
815: -- Get the person_id/position_id from ghr_pa_requests using pa_request_id
816: -- With person_id/position_id get the business group id form per_peope_f/per_positions
817: -- Set the business group_id using fnd_profile.put
818: -- If there is no person_id or position_id in ghr_pa_requests do not validate using dflex -- ??
819:
814: -- Get the Business Group Id as follows
815: -- Get the person_id/position_id from ghr_pa_requests using pa_request_id
816: -- With person_id/position_id get the business group id form per_peope_f/per_positions
817: -- Set the business group_id using fnd_profile.put
818: -- If there is no person_id or position_id in ghr_pa_requests do not validate using dflex -- ??
819:
820: --Getting Business Group Id
821: if l_person_id is not null then
822: for c_per_bus_rec in c_per_bus_group_id(l_person_id)
922: l_bus_group_id per_people_f.business_group_id%type;
923:
924: -- Bug#5729582 (i)added local variable l_effective_date
925: -- (ii) Modified the cursors c_get_perpos_ids,c_per_bus_group_id,c_pos_bus_group_id
926: l_effective_date ghr_pa_requests.effective_date%type;
927:
928: cursor c_get_perpos_ids is
929: select par.person_id,nvl(par.from_position_id,par.to_position_id) position_id,
930: par.effective_date
927:
928: cursor c_get_perpos_ids is
929: select par.person_id,nvl(par.from_position_id,par.to_position_id) position_id,
930: par.effective_date
931: from ghr_pa_requests par
932: where pa_request_id = p_rec.pa_request_id;
933: cursor c_per_bus_group_id(p_person_id in per_people_f.person_id%TYPE) is
934: select ppf.business_group_id
935: from per_people_f ppf
1041: ghr_rei_flex_ddf.ddf(p_rec) ;
1042: */
1043: -- Business group Id has to be populated for the server side DDF Validation
1044: -- Get the Business Group Id as follows
1045: -- Get the person_id/position_id from ghr_pa_requests using pa_request_id
1046: -- With person_id/position_id get the business group id form per_peope_f/per_positions
1047: -- Set the business group_id using fnd_profile.put
1048: -- If there is no person_id or position_id in ghr_pa_requests do not validate using dflex -- ??
1049:
1044: -- Get the Business Group Id as follows
1045: -- Get the person_id/position_id from ghr_pa_requests using pa_request_id
1046: -- With person_id/position_id get the business group id form per_peope_f/per_positions
1047: -- Set the business group_id using fnd_profile.put
1048: -- If there is no person_id or position_id in ghr_pa_requests do not validate using dflex -- ??
1049:
1050: --Getting Business Group Id
1051: if l_person_id is not null then
1052: for c_per_bus_rec in c_per_bus_group_id(l_person_id)