DBA Data[Home] [Help]

APPS.GHR_SF52_DO_UPDATE dependencies on GHR_HISTORY_API

Line 676: l_session ghr_history_api.g_session_var_type;

672: FROM ghr_pa_request_extra_info
673: WHERE pa_request_id = p_pa_request_rec.pa_request_id
674: AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
675:
676: l_session ghr_history_api.g_session_var_type;
677: l_proc varchar2(70) := 'Update_Retained_Grade';
678: l_per_retained_grade GHR_API.Per_retained_grade_TYPE;
679: -- Bug#4698321 Added pei_information1 to the cursor.
680: Cursor c_retained_grade_ovn is

Line 698: ghr_history_api.get_g_session_var(l_session); -- Bug 3021003

694: l_effective_date Date;
695: BEGIN
696: hr_utility.set_location('Entering '||l_proc,5);
697: l_per_retained_grade := P_Per_retained_grade;
698: ghr_history_api.get_g_session_var(l_session); -- Bug 3021003
699: hr_utility.set_location('Effective Date '||p_pa_request_rec.effective_date,1);
700: IF p_pa_request_rec.first_noa_code = '702' THEN
701: --702 Processing
702: hr_utility.set_location('702 RG Processing '||l_proc,10);

Line 780: ghr_history_api.get_g_session_var(l_session);

776: l_new_loc_percent := retained_grade_ovn.pei_information7;
777: l_new_pay_basis := retained_grade_ovn.pei_information8;
778: exit;
779: END LOOP;
780: ghr_history_api.get_g_session_var(l_session);
781: hr_utility.set_location('Inside 866 processing ',2);
782: IF l_session.noa_id_correct is null then
783: -- End date the existing RG record
784: hr_person_extra_info_api.update_person_extra_info

Line 1020: l_session ghr_history_api.g_session_var_type;

1016: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
1017: l_academic_discipline ghr_pa_requests.academic_discipline%type;
1018: l_object_version_number number(9);
1019: l_multiple varchar2(1);
1020: l_session ghr_history_api.g_session_var_type;
1021: l_special_info ghr_api.special_information_type;
1022:
1023:
1024:

Line 1163: ghr_history_api.get_g_session_var(l_session);

1159: l_multiple := multiple_occur.multiple_occurrences_flag;
1160: end loop;
1161: */
1162:
1163: ghr_history_api.get_g_session_var(l_session);
1164: If l_session.noa_id_correct is null then
1165: l_personal_analysis_id := Null;
1166: for special_info in c_special_info loop
1167: hr_utility.set_location(l_proc,40);

Line 2993: l_session ghr_history_api.g_session_var_type;

2989: l_v_end_date date;
2990: l_county_name per_addresses.region_1%type;
2991: l_count_rec number;
2992:
2993: l_session ghr_history_api.g_session_var_type;
2994:
2995: -- POSITION ABOLISH out parameters
2996: l_val_grd_chg_wng boolean;
2997: l_pos_definition_id number;

Line 3690: ghr_history_api.get_g_session_var(l_session);

3686: end if;
3687:
3688:
3689:
3690: ghr_history_api.get_g_session_var(l_session);
3691: hr_utility.set_location('NOA ID CORRECT : ' || l_session.noa_id_correct,1);
3692:
3693: If l_noa_family_code = 'APP' then
3694: hr_utility.set_location(l_proc,15);

Line 4051: ghr_history_api.get_g_session_var(l_session);

4047: --Note : It looks like if the person_type_id is not passed in, then it defaults to the system_person_type of 'EMP' anyway .
4048: -- and therefore not passing it in.
4049: p_pa_request_rec.employee_assignment_id := l_assignment_id;
4050: -- Bug# 1235958: Update of l_assignment_id for history records.
4051: ghr_history_api.get_g_session_var(l_session);
4052: l_session.assignment_id := l_assignment_id;
4053: ghr_history_api.set_g_session_var(l_session);
4054:
4055:

Line 4053: ghr_history_api.set_g_session_var(l_session);

4049: p_pa_request_rec.employee_assignment_id := l_assignment_id;
4050: -- Bug# 1235958: Update of l_assignment_id for history records.
4051: ghr_history_api.get_g_session_var(l_session);
4052: l_session.assignment_id := l_assignment_id;
4053: ghr_history_api.set_g_session_var(l_session);
4054:
4055:
4056: -- fetch assignment Business_group, Object_version_number and Normal Hours
4057:

Line 4775: l_session ghr_history_api.g_session_var_type;

4771: l_cur_step_or_rate per_people_extra_info.pei_information4%type;
4772: l_new_temp_step per_people_extra_info.pei_information9%type;
4773: l_ret_object_version_number ghr_pa_requests.object_version_number%type;
4774: l_effective_date date;
4775: l_session ghr_history_api.g_session_var_type;
4776: l_value varchar2(30);
4777: l_multiple_error_flag boolean;
4778: l_entitled_other_pay number;
4779:

Line 5041: ghr_history_api.get_g_session_var(l_session);

5037: l_wgi_exists := FALSE;-- Bug 4031919
5038:
5039: --Pradeep start of Bug 3306515
5040: -- Get the session variables.
5041: ghr_history_api.get_g_session_var(l_session);
5042: --Pradeep end of Bug 3306515
5043:
5044: --
5045: -- Processing Basic pay

Line 6226: ghr_history_api.get_g_session_var(l_session);

6222:
6223:
6224: IF NOT(ghr_pay_calc.g_fwfa_pay_calc_flag) AND
6225: NOT(ghr_pay_calc.g_gl_upd_flag) THEN
6226: ghr_history_api.get_g_session_var(l_session);
6227: IF p_pa_request_rec.first_noa_code = '894' and
6228: ghr_process_sf52.g_prd IS NOT NULL AND
6229: l_session.noa_id_correct IS NULL THEN
6230: IF ghr_process_sf52.g_prd in ('A','B','E','F','U','V') THEN

Line 6261: ghr_history_api.get_g_session_var(l_session);

6257: end if;
6258: end loop;
6259: If p_pa_request_rec.first_noa_code in ('867','892','893','894') then
6260: hr_utility.set_location('procesing 867,892,893,894',1);
6261: ghr_history_api.get_g_session_var(l_session);
6262: If l_session.noa_id_correct is null then
6263: hr_utility.set_location('procesing 867,892,893,894 not a corr',1);
6264: ----Bug 6193571 start
6265: if p_pa_request_rec.first_noa_code = '894'

Line 6391: ghr_history_api.get_g_session_var(l_session);

6387: l_new_loc_percent := retained_grade_ovn.pei_information7;
6388: l_new_pay_basis := retained_grade_ovn.pei_information8;
6389: exit;
6390: END LOOP;
6391: ghr_history_api.get_g_session_var(l_session);
6392: hr_utility.set_location('Inside 703 processing ',2);
6393: IF l_session.noa_id_correct is null then
6394: -- End date the existing RG record
6395: hr_person_extra_info_api.update_person_extra_info

Line 6463: ghr_history_api.get_g_session_var(l_session);

6459: l_new_temp_step := retained_grade_ovn.pei_information9;
6460: exit;
6461: END LOOP;
6462: hr_utility.set_location('Inside 740 processing ',2);
6463: ghr_history_api.get_g_session_var(l_session);
6464: IF l_new_temp_step IS NOT NULL and l_session.noa_id_correct IS NULL THEN
6465: -- End date the existing RG record
6466: hr_person_extra_info_api.update_person_extra_info
6467: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,

Line 6868: l_session ghr_history_api.g_session_var_type;

6864:
6865: l_installment_ctr NUMBER(10);
6866: l_payment_type VARCHAR2(150);
6867: l_noa_code VARCHAR2(150);
6868: l_session ghr_history_api.g_session_var_type;
6869:
6870: BEGIN
6871: hr_utility.set_location('Entering process_incentive_elements'||p_pa_request_id,0);
6872: l_installment_ctr := 0;

Line 6873: ghr_history_api.get_g_session_var(l_session);

6869:
6870: BEGIN
6871: hr_utility.set_location('Entering process_incentive_elements'||p_pa_request_id,0);
6872: l_installment_ctr := 0;
6873: ghr_history_api.get_g_session_var(l_session);
6874: IF l_session.noa_id_correct IS NOT NULL and
6875: p_payment_option = 'H' and
6876: (p_first_noa_code = '825' OR p_second_noa_code ='825') THEN
6877: Upd_sep_incn_elements(p_pa_request_id

Line 8215: l_session ghr_history_api.g_session_var_type;

8211: is
8212:
8213: l_proc varchar2(72) := 'Generic Update SIT';
8214: l_object_version_number per_people_f.object_version_number%type;
8215: l_session ghr_history_api.g_session_var_type;
8216: l_multiple varchar2(1);
8217: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
8218: l_person_analysis_id per_person_analyses.person_analysis_id%type;
8219: l_business_group_id per_people_f.business_group_id%type;