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_DO_UPDATE dependencies on GHR_HISTORY_API

Line 100: l_session ghr_history_api.g_session_var_type;

96: l_information30 varchar2(150);
97: --
98:
99: --Bug # 9646565
100: l_session ghr_history_api.g_session_var_type;
101:
102: -- Cursor to select the primary key of the respective Extra info tables for the specific
103: -- entity Id and the InformationType
104:

Line 134: ghr_history_api.get_g_session_var(l_session);

130:
131: l_extra_info_id := NULL;
132:
133: --Bug # 9646565
134: ghr_history_api.get_g_session_var(l_session);
135:
136: If upper(substr(P_l_Information_Type,8,3)) = 'ASG' then
137: l_index := 'aei';
138: l_id := P_Pa_request_rec.Employee_Assignment_id;

Line 691: l_session ghr_history_api.g_session_var_type;

687: FROM ghr_pa_request_extra_info
688: WHERE pa_request_id = p_pa_request_rec.pa_request_id
689: AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
690:
691: l_session ghr_history_api.g_session_var_type;
692: l_proc varchar2(70) := 'Update_Retained_Grade';
693: l_per_retained_grade GHR_API.Per_retained_grade_TYPE;
694: -- Bug#4698321 Added pei_information1 to the cursor.
695: Cursor c_retained_grade_ovn is

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

709: l_effective_date Date;
710: BEGIN
711: hr_utility.set_location('Entering '||l_proc,5);
712: l_per_retained_grade := P_Per_retained_grade;
713: ghr_history_api.get_g_session_var(l_session); -- Bug 3021003
714: hr_utility.set_location('Effective Date '||p_pa_request_rec.effective_date,1);
715: IF p_pa_request_rec.first_noa_code = '702' THEN
716: --702 Processing
717: hr_utility.set_location('702 RG Processing '||l_proc,10);

Line 795: ghr_history_api.get_g_session_var(l_session);

791: l_new_loc_percent := retained_grade_ovn.pei_information7;
792: l_new_pay_basis := retained_grade_ovn.pei_information8;
793: exit;
794: END LOOP;
795: ghr_history_api.get_g_session_var(l_session);
796: hr_utility.set_location('Inside 866 processing ',2);
797: IF l_session.noa_id_correct is null then
798: -- End date the existing RG record
799: hr_person_extra_info_api.update_person_extra_info

Line 1035: l_session ghr_history_api.g_session_var_type;

1031: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
1032: l_academic_discipline ghr_pa_requests.academic_discipline%type;
1033: l_object_version_number number(9);
1034: l_multiple varchar2(1);
1035: l_session ghr_history_api.g_session_var_type;
1036: l_special_info ghr_api.special_information_type;
1037:
1038:
1039:

Line 1178: ghr_history_api.get_g_session_var(l_session);

1174: l_multiple := multiple_occur.multiple_occurrences_flag;
1175: end loop;
1176: */
1177:
1178: ghr_history_api.get_g_session_var(l_session);
1179: If l_session.noa_id_correct is null then
1180: l_personal_analysis_id := Null;
1181: for special_info in c_special_info loop
1182: hr_utility.set_location(l_proc,40);

Line 3197: l_session ghr_history_api.g_session_var_type;

3193: l_v_end_date date;
3194: l_county_name per_addresses.region_1%type;
3195: l_count_rec number;
3196:
3197: l_session ghr_history_api.g_session_var_type;
3198:
3199: -- POSITION ABOLISH out parameters
3200: l_val_grd_chg_wng boolean;
3201: l_pos_definition_id number;

Line 3899: --GHR_HISTORY_API.get_session_date(l_curr_sess_date);

3895: p_table_name => 'HR_ALL_POSITIONS_F'
3896: );
3897:
3898: --Bug# 6127620
3899: --GHR_HISTORY_API.get_session_date(l_curr_sess_date);
3900: -- ghr_session.set_fnd_session_date(p_pa_request_rec.effective_date);
3901: --Bug# 6127620
3902:
3903:

Line 3919: ghr_history_api.get_g_session_var(l_session);

3915: end if;
3916:
3917:
3918:
3919: ghr_history_api.get_g_session_var(l_session);
3920: hr_utility.set_location('NOA ID CORRECT : ' || l_session.noa_id_correct,1);
3921:
3922: If l_noa_family_code = 'APP' then
3923: hr_utility.set_location(l_proc,15);

Line 4279: ghr_history_api.get_g_session_var(l_session);

4275: --Note : It looks like if the person_type_id is not passed in, then it defaults to the system_person_type of 'EMP' anyway .
4276: -- and therefore not passing it in.
4277: p_pa_request_rec.employee_assignment_id := l_assignment_id;
4278: -- Bug# 1235958: Update of l_assignment_id for history records.
4279: ghr_history_api.get_g_session_var(l_session);
4280: l_session.assignment_id := l_assignment_id;
4281: ghr_history_api.set_g_session_var(l_session);
4282:
4283:

Line 4281: ghr_history_api.set_g_session_var(l_session);

4277: p_pa_request_rec.employee_assignment_id := l_assignment_id;
4278: -- Bug# 1235958: Update of l_assignment_id for history records.
4279: ghr_history_api.get_g_session_var(l_session);
4280: l_session.assignment_id := l_assignment_id;
4281: ghr_history_api.set_g_session_var(l_session);
4282:
4283:
4284: -- fetch assignment Business_group, Object_version_number and Normal Hours
4285:

Line 5034: l_session ghr_history_api.g_session_var_type;

5030: l_cur_step_or_rate per_people_extra_info.pei_information4%type;
5031: l_new_temp_step per_people_extra_info.pei_information9%type;
5032: l_ret_object_version_number ghr_pa_requests.object_version_number%type;
5033: l_effective_date date;
5034: l_session ghr_history_api.g_session_var_type;
5035: l_value varchar2(30);
5036: l_multiple_error_flag boolean;
5037: l_entitled_other_pay number;
5038:

Line 5300: ghr_history_api.get_g_session_var(l_session);

5296: l_wgi_exists := FALSE;-- Bug 4031919
5297:
5298: --Pradeep start of Bug 3306515
5299: -- Get the session variables.
5300: ghr_history_api.get_g_session_var(l_session);
5301: --Pradeep end of Bug 3306515
5302:
5303: --
5304: -- Processing Basic pay

Line 6497: ghr_history_api.get_g_session_var(l_session);

6493:
6494:
6495: IF NOT(ghr_pay_calc.g_fwfa_pay_calc_flag) AND
6496: NOT(ghr_pay_calc.g_gl_upd_flag) THEN
6497: ghr_history_api.get_g_session_var(l_session);
6498: IF p_pa_request_rec.first_noa_code = '894' and
6499: ghr_process_sf52.g_prd IS NOT NULL AND
6500: l_session.noa_id_correct IS NULL THEN
6501: IF ghr_process_sf52.g_prd in ('A','B','E','F','U','V') THEN

Line 6532: ghr_history_api.get_g_session_var(l_session);

6528: end if;
6529: end loop;
6530: If p_pa_request_rec.first_noa_code in ('867','892','893','894') then
6531: hr_utility.set_location('procesing 867,892,893,894',1);
6532: ghr_history_api.get_g_session_var(l_session);
6533: If l_session.noa_id_correct is null then
6534: hr_utility.set_location('procesing 867,892,893,894 not a corr',1);
6535: ----Bug 6193571 start
6536: if p_pa_request_rec.first_noa_code = '894'

Line 6662: ghr_history_api.get_g_session_var(l_session);

6658: l_new_loc_percent := retained_grade_ovn.pei_information7;
6659: l_new_pay_basis := retained_grade_ovn.pei_information8;
6660: exit;
6661: END LOOP;
6662: ghr_history_api.get_g_session_var(l_session);
6663: hr_utility.set_location('Inside 703 processing ',2);
6664: IF l_session.noa_id_correct is null then
6665: -- End date the existing RG record
6666: hr_person_extra_info_api.update_person_extra_info

Line 6734: ghr_history_api.get_g_session_var(l_session);

6730: l_new_temp_step := retained_grade_ovn.pei_information9;
6731: exit;
6732: END LOOP;
6733: hr_utility.set_location('Inside 740 processing ',2);
6734: ghr_history_api.get_g_session_var(l_session);
6735: IF l_new_temp_step IS NOT NULL and l_session.noa_id_correct IS NULL THEN
6736: -- End date the existing RG record
6737: hr_person_extra_info_api.update_person_extra_info
6738: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,

Line 7144: l_session ghr_history_api.g_session_var_type;

7140:
7141: l_installment_ctr NUMBER(10);
7142: l_payment_type VARCHAR2(150);
7143: l_noa_code VARCHAR2(150);
7144: l_session ghr_history_api.g_session_var_type;
7145:
7146: BEGIN
7147: hr_utility.set_location('Entering process_incentive_elements'||p_pa_request_id,0);
7148: l_installment_ctr := 0;

Line 7149: ghr_history_api.get_g_session_var(l_session);

7145:
7146: BEGIN
7147: hr_utility.set_location('Entering process_incentive_elements'||p_pa_request_id,0);
7148: l_installment_ctr := 0;
7149: ghr_history_api.get_g_session_var(l_session);
7150: IF l_session.noa_id_correct IS NOT NULL and
7151: p_payment_option = 'H' and
7152: (p_first_noa_code = '825' OR p_second_noa_code ='825') THEN
7153: Upd_sep_incn_elements(p_pa_request_id

Line 8518: l_session ghr_history_api.g_session_var_type;

8514: is
8515:
8516: l_proc varchar2(72) := 'Generic Update SIT';
8517: l_object_version_number per_people_f.object_version_number%type;
8518: l_session ghr_history_api.g_session_var_type;
8519: l_multiple varchar2(1);
8520: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
8521: l_person_analysis_id per_person_analyses.person_analysis_id%type;
8522: l_business_group_id per_people_f.business_group_id%type;