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.

[Home] [Help]

APPS.GHR_SF52_DO_UPDATE dependencies on GHR_PA_REQUESTS

Line 6: -- Removed all cursors required to fetch noa_code, as it is already passed from ghr_pa_requests (FRONT END)

2: /* $Header: gh52doup.pkb 120.61.12010000.5 2008/10/22 12:42:51 utokachi ship $ */
3: g_effective_date date;
4: g_old_user_status per_assignment_status_types.user_status%type;
5: --
6: -- Removed all cursors required to fetch noa_code, as it is already passed from ghr_pa_requests (FRONT END)
7: --
8: -- *******************************
9: -- procedure Generic_Update_Extra_Info
10: -- *******************************

Line 16: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE

12:
13: -- This procedure call the appropriate API to update DDF extra information.
14:
15: Procedure Generic_Update_Extra_Info
16: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE
17: ,p_l_information_type IN varchar2
18: ,p_extra_info_id IN number
19: ,p_l_object_version_number IN out nocopy number
20: ,p_information1 IN varchar2 default hr_api.g_varchar2

Line 623: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE ,

619:
620: End Generic_Update_Extra_Info;
621:
622: Procedure Update_Retained_Grade
623: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE ,
624: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE) IS
625: --
626: --
627: cursor c_702_rec is

Line 665: l_ret_object_version_number ghr_pa_requests.object_version_number%type;

661: l_temp_step per_people_extra_info.pei_information9%type;
662: l_new_temp_step per_people_extra_info.pei_information9%type;
663: l_new_step_or_rate per_people_extra_info.pei_information4%type;
664: l_step_or_rate per_people_extra_info.pei_information4%type;
665: l_ret_object_version_number ghr_pa_requests.object_version_number%type;
666: l_ovn ghr_pa_requests.object_version_number%type;
667:
668:
669: CURSOR cur_temp_step

Line 666: l_ovn ghr_pa_requests.object_version_number%type;

662: l_new_temp_step per_people_extra_info.pei_information9%type;
663: l_new_step_or_rate per_people_extra_info.pei_information4%type;
664: l_step_or_rate per_people_extra_info.pei_information4%type;
665: l_ret_object_version_number ghr_pa_requests.object_version_number%type;
666: l_ovn ghr_pa_requests.object_version_number%type;
667:
668:
669: CURSOR cur_temp_step
670: IS

Line 1007: (p_pa_request_rec in ghr_pa_requests%rowtype

1003: -- Procedure Update_edu_sit -- To create/Update Education Sp. Info Type
1004: -------------------------------
1005:
1006: Procedure update_edu_sit
1007: (p_pa_request_rec in ghr_pa_requests%rowtype
1008: ) is
1009:
1010: l_proc varchar2(72) := 'Generic Sit';
1011: l_business_group_id per_people_f.business_group_id%type;

Line 1015: l_education_level ghr_pa_requests.education_level%type;

1011: l_business_group_id per_people_f.business_group_id%type;
1012: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
1013: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
1014: l_personal_analysis_id per_person_analyses.person_analysis_id%type;
1015: l_education_level ghr_pa_requests.education_level%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);

Line 1016: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;

1012: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
1013: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
1014: l_personal_analysis_id per_person_analyses.person_analysis_id%type;
1015: l_education_level ghr_pa_requests.education_level%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;

Line 1017: l_academic_discipline ghr_pa_requests.academic_discipline%type;

1013: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
1014: l_personal_analysis_id per_person_analyses.person_analysis_id%type;
1015: l_education_level ghr_pa_requests.education_level%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;

Line 1249: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE,

1245: -- Procedure call_extra_info_api
1246: -- *************************
1247: --
1248: Procedure call_extra_info_api
1249: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE,
1250: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,
1251: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1252: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,

Line 1289: l_personnel_office_id ghr_pa_requests.personnel_office_id%type; --\

1285: l_form_field_name varchar2(50);
1286: l_posn_title_pm varchar2(50);
1287: l_WS_pm varchar2(50);
1288: l_DS_pm varchar2(50);
1289: l_personnel_office_id ghr_pa_requests.personnel_office_id%type; --\
1290: l_org_structure_id per_position_extra_info.poei_information5%type; -------bug#2623692
1291: l_Organ_Component per_position_extra_info.poei_information5%type; --/
1292: -- JH Get To Position Title PM for Noa Code being updated. Bug 773851
1293: Cursor get_to_posn_title_pm is

Line 1328: from ghr_pa_requests

1324: ----------------------------------- cursor to handle changes to LAC codes for Correction to Apptmt action 1274541
1325: Cursor c_Corr_LAC_Codes(p_pa_request_id number) is
1326: select second_action_la_code1,second_action_la_code2,first_noa_code,second_noa_code,
1327: second_action_la_desc1,second_action_la_desc2 --Bug# 4941984(AFHR2)
1328: from ghr_pa_requests
1329: where pa_request_id=p_pa_request_id and first_noa_code='002';
1330:
1331:
1332: Cursor fam_code(p_second_noa_id number) is

Line 1345: ghr_pa_requests par,

1341: --
1342: Cursor Cur_Par_Asg(p_ssn VARCHAR2) is
1343: select par.first_noa_code
1344: from
1345: ghr_pa_requests par,
1346: per_Assignments_f asg
1347: where asg.assignment_id=par.employee_assignment_id
1348: and par.employee_national_identifier=p_ssn
1349: and noa_family_code not in

Line 1356: /*Cursor Cur_NTE_dates(p_ssn ghr_pa_requests.employee_national_identifier%type, p_noa_code ghr_pa_requests.first_noa_code%type) is

1352: Order by effective_date asc;
1353:
1354: -- 2839332 Madhuri
1355: -- 3263014 Sundar Datatype of the parameters have been changed to table.column_name%type
1356: /*Cursor Cur_NTE_dates(p_ssn ghr_pa_requests.employee_national_identifier%type, p_noa_code ghr_pa_requests.first_noa_code%type) is
1357: select first_noa_information1 NTE_Dates
1358: from ghr_pa_requests
1359: where first_noa_code=p_noa_code
1360: and noa_family_code not in

Line 1358: from ghr_pa_requests

1354: -- 2839332 Madhuri
1355: -- 3263014 Sundar Datatype of the parameters have been changed to table.column_name%type
1356: /*Cursor Cur_NTE_dates(p_ssn ghr_pa_requests.employee_national_identifier%type, p_noa_code ghr_pa_requests.first_noa_code%type) is
1357: select first_noa_information1 NTE_Dates
1358: from ghr_pa_requests
1359: where first_noa_code=p_noa_code
1360: and noa_family_code not in
1361: ('NON_PAY_DUTY_STATUS','RETURN_TO_DUTY','CANCEL','CORRECT')
1362: and employee_national_identifier=p_ssn;

Line 1366: CURSOR cur_eff_date_non_pay(c_person_id ghr_pa_requests.person_id%type,c_eff_date ghr_pa_requests.effective_date%type)

1362: and employee_national_identifier=p_ssn;
1363: */
1364: -- Sundar Bug 3390876
1365: -- Get the effective date of Non-Pay duty status
1366: CURSOR cur_eff_date_non_pay(c_person_id ghr_pa_requests.person_id%type,c_eff_date ghr_pa_requests.effective_date%type)
1367: IS
1368: SELECT
1369: MAX(par.effective_date) eff_date
1370: FROM

Line 1371: ghr_pa_requests par

1367: IS
1368: SELECT
1369: MAX(par.effective_date) eff_date
1370: FROM
1371: ghr_pa_requests par
1372: WHERE
1373: par.person_id= c_person_id AND
1374: par.noa_family_code = 'NON_PAY_DUTY_STATUS' AND
1375: par.pa_notification_id IS NOT NULL AND

Line 1379: CURSOR cur_nte_date_aft_np(c_person_id ghr_pa_requests.person_id%type,

1375: par.pa_notification_id IS NOT NULL AND
1376: NVL(par.first_noa_cancel_or_correct,'NULL') <> 'CANCEL' AND
1377: par.effective_date < c_eff_date;
1378:
1379: CURSOR cur_nte_date_aft_np(c_person_id ghr_pa_requests.person_id%type,
1380: c_eff_date ghr_pa_requests.effective_date%type, c_rtd_date ghr_pa_requests.effective_date%type)
1381: IS
1382: SELECT
1383: par.first_noa_information1 nte_date

Line 1380: c_eff_date ghr_pa_requests.effective_date%type, c_rtd_date ghr_pa_requests.effective_date%type)

1376: NVL(par.first_noa_cancel_or_correct,'NULL') <> 'CANCEL' AND
1377: par.effective_date < c_eff_date;
1378:
1379: CURSOR cur_nte_date_aft_np(c_person_id ghr_pa_requests.person_id%type,
1380: c_eff_date ghr_pa_requests.effective_date%type, c_rtd_date ghr_pa_requests.effective_date%type)
1381: IS
1382: SELECT
1383: par.first_noa_information1 nte_date
1384: FROM

Line 1385: ghr_pa_requests par

1381: IS
1382: SELECT
1383: par.first_noa_information1 nte_date
1384: FROM
1385: ghr_pa_requests par
1386: WHERE
1387: par.person_id= c_person_id AND
1388: par.effective_date BETWEEN c_eff_date AND c_rtd_date AND
1389: par.pa_notification_id IS NOT NULL AND

Line 1393: /*CURSOR Cur_NTE_date_bef_np(c_person_id ghr_pa_requests.person_id%type,c_eff_date ghr_pa_requests.effective_date%type)

1389: par.pa_notification_id IS NOT NULL AND
1390: NVL(par.first_noa_cancel_or_correct, 'NULL') <> 'CANCEL' AND
1391: par.first_noa_code IN ('508','515','517','522','548','549','553','554','571','590','750','760','761','762','765','769','770');
1392:
1393: /*CURSOR Cur_NTE_date_bef_np(c_person_id ghr_pa_requests.person_id%type,c_eff_date ghr_pa_requests.effective_date%type)
1394: IS
1395: SELECT
1396: first_noa_information1 NTE_Dates
1397: FROM

Line 1398: ghr_pa_requests par,

1394: IS
1395: SELECT
1396: first_noa_information1 NTE_Dates
1397: FROM
1398: ghr_pa_requests par,
1399: per_Assignments_f asg
1400: WHERE
1401: asg.assignment_id= par.employee_assignment_id AND
1402: asg.effective_start_date = par.effective_date AND

Line 1422: target_poi ghr_pa_requests.personnel_office_id%type;

1418: FROM ghr_pa_request_extra_info
1419: WHERE pa_request_id=p_par_id
1420: AND information_type='GHR_US_PAR_REALIGNMENT';
1421:
1422: target_poi ghr_pa_requests.personnel_office_id%type;
1423: -- for bug 3191704
1424:
1425: --l_NTE_Dates per_assignment_extra_info.aei_information4%TYPE;
1426: ---------------------------------------------------------- added 2 cursors for 1274541

Line 1428: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;

1424:
1425: --l_NTE_Dates per_assignment_extra_info.aei_information4%TYPE;
1426: ---------------------------------------------------------- added 2 cursors for 1274541
1427: --Begin Bug 5919705
1428: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
1429: l_pay_plan ghr_pa_requests.to_pay_plan%type;
1430:
1431: CURSOR cur_grd1 IS
1432: SELECT gdf.segment1 pay_plan,

Line 1429: l_pay_plan ghr_pa_requests.to_pay_plan%type;

1425: --l_NTE_Dates per_assignment_extra_info.aei_information4%TYPE;
1426: ---------------------------------------------------------- added 2 cursors for 1274541
1427: --Begin Bug 5919705
1428: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
1429: l_pay_plan ghr_pa_requests.to_pay_plan%type;
1430:
1431: CURSOR cur_grd1 IS
1432: SELECT gdf.segment1 pay_plan,
1433: gdf.segment2 grade_or_level

Line 1449: l_first_noa_code ghr_pa_requests.first_noa_code%type;

1445: and gdf.segment1 = l_pay_plan
1446: and gdf.segment2 = l_grade_or_level
1447: and grd.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
1448: --End Bug 5919705
1449: l_first_noa_code ghr_pa_requests.first_noa_code%type;
1450: l_second_noa_code ghr_pa_requests.second_noa_code%type;
1451: l_fam_code ghr_pa_requests.noa_family_code%type;
1452:
1453: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;

Line 1450: l_second_noa_code ghr_pa_requests.second_noa_code%type;

1446: and gdf.segment2 = l_grade_or_level
1447: and grd.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
1448: --End Bug 5919705
1449: l_first_noa_code ghr_pa_requests.first_noa_code%type;
1450: l_second_noa_code ghr_pa_requests.second_noa_code%type;
1451: l_fam_code ghr_pa_requests.noa_family_code%type;
1452:
1453: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
1454: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;

Line 1451: l_fam_code ghr_pa_requests.noa_family_code%type;

1447: and grd.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
1448: --End Bug 5919705
1449: l_first_noa_code ghr_pa_requests.first_noa_code%type;
1450: l_second_noa_code ghr_pa_requests.second_noa_code%type;
1451: l_fam_code ghr_pa_requests.noa_family_code%type;
1452:
1453: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
1454: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
1455: --Bug# 4941984(AFHR2)

Line 1490: l_agency_code_transfer_to ghr_pa_requests.agency_code%type;

1486: l_Loc_Info GHR_API.Loc_Info_TYPE;
1487: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;
1488: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;
1489: ---for bug 3267632
1490: l_agency_code_transfer_to ghr_pa_requests.agency_code%type;
1491: --
1492: -- Bug 3390876
1493: l_np_eff_date ghr_pa_requests.effective_date%type;
1494: l_asg_ei_data per_assignment_extra_info%rowtype;

Line 1493: l_np_eff_date ghr_pa_requests.effective_date%type;

1489: ---for bug 3267632
1490: l_agency_code_transfer_to ghr_pa_requests.agency_code%type;
1491: --
1492: -- Bug 3390876
1493: l_np_eff_date ghr_pa_requests.effective_date%type;
1494: l_asg_ei_data per_assignment_extra_info%rowtype;
1495: Begin
1496: --
1497: hr_utility.set_location('Entering ' ||l_proc,5);

Line 2838: (P_PA_REQUEST_REC IN OUT NOCOPY GHR_PA_REQUESTS%ROWTYPE,

2834: -- procedure Process_Family
2835: -- ***********************
2836: --
2837: procedure Process_Family
2838: (P_PA_REQUEST_REC IN OUT NOCOPY GHR_PA_REQUESTS%ROWTYPE,
2839: P_AGENCY_CODE IN varchar2 ) is
2840:
2841: l_noa_code ghr_nature_of_actions.code%type;
2842: --

Line 2843: l_pa_request_rec ghr_pa_requests%rowtype;

2839: P_AGENCY_CODE IN varchar2 ) is
2840:
2841: l_noa_code ghr_nature_of_actions.code%type;
2842: --
2843: l_pa_request_rec ghr_pa_requests%rowtype;
2844: l_proc varchar2(70) := 'Process_family';
2845: l_hr_person_api_update varchar2(1) := 'N';
2846: l_hr_applicant_api_hire varchar2(1) := 'N';
2847: l_employee_api_update_criteria varchar2(1) := 'N';

Line 2937: l_date1 ghr_pa_requests.effective_date%type;

2933: l_asg_object_version_number per_assignments_f.object_version_number%type;
2934: l_add_object_version_number per_addresses.object_version_number%type;
2935: l_person_id per_people_f.person_id%type;
2936: l_person_type_id per_people_f.person_type_id%type;
2937: l_date1 ghr_pa_requests.effective_date%type;
2938: l_address_id per_addresses.address_id%type;
2939: l_person_type per_person_types.system_person_type%type;
2940: --l_sec_assignmemt_id per_assignments_f.assignment_id%type;
2941: --l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type;

Line 3157: FROM ghr_pa_requests

3153: AND pah.information1 = p_address_id
3154: AND pah.pa_request_id IN
3155: (
3156: SELECT pa_request_id
3157: FROM ghr_pa_requests
3158: CONNECT BY prior pa_request_id = altered_pa_request_id
3159: START WITH pa_request_id = p_pa_request_id
3160: );
3161: --

Line 3343: FROM ghr_pa_Requests

3339: CURSOR RTD_asg_status( p_asg_id NUMBER,
3340: p_eff_date DATE )
3341: IS
3342: SELECT effective_date
3343: FROM ghr_pa_Requests
3344: WHERE effective_date <= p_eff_Date
3345: and person_id = p_pa_request_rec.person_id
3346: --and employee_assignment_id = p_Asg_id
3347: -- for performance reasons

Line 3471: l_position_id ghr_pa_requests.from_position_id%TYPE :=NULL;

3467: l_rpa_remark_code ghr_remarks.code%TYPE;
3468: l_rpa_remark_id ghr_remarks.remark_id%TYPE;
3469:
3470: --bug 4542437
3471: l_position_id ghr_pa_requests.from_position_id%TYPE :=NULL;
3472: l_job_id per_all_assignments_f.job_id%TYPE :=NULL;
3473: l_org_id per_all_assignments_f.organization_id%TYPE :=NULL;
3474: l_grade_id per_position_extra_info.poei_information3%TYPE :=NULL;
3475: l_pos_ei_data per_position_extra_info%ROWTYPE;

Line 4742: (p_pa_request_rec in ghr_pa_requests%rowtype

4738: -- procedure Process_Salary_Info
4739: -- ********************************
4740: --
4741: Procedure Process_salary_Info
4742: (p_pa_request_rec in ghr_pa_requests%rowtype
4743: ,p_wgi in out nocopy ghr_api.within_grade_increase_type
4744: ,p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type
4745: ,p_capped_other_pay in number default null
4746: ) is

Line 4773: l_ret_object_version_number ghr_pa_requests.object_version_number%type;

4769: l_new_pay_basis per_people_extra_info.pei_information3%type;
4770: l_new_step_or_rate per_people_extra_info.pei_information4%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;

Line 4967: CURSOR cur_get_step(c_pa_request_id ghr_pa_requests.pa_request_id%type)

4963: WHERE pa_request_id = p_pa_request_rec.pa_request_id
4964: AND information_type = 'GHR_US_PAR_SALARY_CHG';
4965: --
4966: -- Bug 3953455 Cursor to fetch the To step for both normal and correction actions.
4967: CURSOR cur_get_step(c_pa_request_id ghr_pa_requests.pa_request_id%type)
4968: IS
4969: SELECT par_orig.from_step_or_rate step1, par_corr.from_step_or_rate step2
4970: FROM ghr_pa_requests par_orig , ghr_pa_requests par_corr
4971: where par_orig.pa_request_id = par_corr.altered_pa_request_id

Line 4970: FROM ghr_pa_requests par_orig , ghr_pa_requests par_corr

4966: -- Bug 3953455 Cursor to fetch the To step for both normal and correction actions.
4967: CURSOR cur_get_step(c_pa_request_id ghr_pa_requests.pa_request_id%type)
4968: IS
4969: SELECT par_orig.from_step_or_rate step1, par_corr.from_step_or_rate step2
4970: FROM ghr_pa_requests par_orig , ghr_pa_requests par_corr
4971: where par_orig.pa_request_id = par_corr.altered_pa_request_id
4972: and par_corr.pa_request_id = c_pa_request_id;
4973:
4974: l_orig_pa_from_step ghr_pa_requests.to_step_or_rate%type;

Line 4974: l_orig_pa_from_step ghr_pa_requests.to_step_or_rate%type;

4970: FROM ghr_pa_requests par_orig , ghr_pa_requests par_corr
4971: where par_orig.pa_request_id = par_corr.altered_pa_request_id
4972: and par_corr.pa_request_id = c_pa_request_id;
4973:
4974: l_orig_pa_from_step ghr_pa_requests.to_step_or_rate%type;
4975: l_corr_pa_from_step ghr_pa_requests.to_step_or_rate%type;
4976: l_call_wgi_dates BOOLEAN;
4977:
4978: -- End Bug 3953455

Line 4975: l_corr_pa_from_step ghr_pa_requests.to_step_or_rate%type;

4971: where par_orig.pa_request_id = par_corr.altered_pa_request_id
4972: and par_corr.pa_request_id = c_pa_request_id;
4973:
4974: l_orig_pa_from_step ghr_pa_requests.to_step_or_rate%type;
4975: l_corr_pa_from_step ghr_pa_requests.to_step_or_rate%type;
4976: l_call_wgi_dates BOOLEAN;
4977:
4978: -- End Bug 3953455
4979:

Line 4983: l_to_pay_plan ghr_pa_requests.to_pay_plan%type;

4979:
4980: -- -- Bug 4031919 Cursor to check if pay plan is eligible for WGI or not.
4981: l_is_wgi_eligible BOOLEAN;
4982: l_wgi_cleared BOOLEAN;
4983: l_to_pay_plan ghr_pa_requests.to_pay_plan%type;
4984: l_wgi_exists BOOLEAN;
4985: l_wgi_new_name VARCHAR2(250);
4986:
4987: CURSOR c_wgi_pay_plan(c_pay_plan ghr_pa_requests.to_pay_plan%TYPE) IS

Line 4987: CURSOR c_wgi_pay_plan(c_pay_plan ghr_pa_requests.to_pay_plan%TYPE) IS

4983: l_to_pay_plan ghr_pa_requests.to_pay_plan%type;
4984: l_wgi_exists BOOLEAN;
4985: l_wgi_new_name VARCHAR2(250);
4986:
4987: CURSOR c_wgi_pay_plan(c_pay_plan ghr_pa_requests.to_pay_plan%TYPE) IS
4988: SELECT 1
4989: FROM ghr_pay_plans gpp
4990: WHERE gpp.pay_plan = c_pay_plan
4991: AND gpp.wgi_enabled_flag = 'Y';

Line 4993: CURSOR c_get_pay_plan(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS

4989: FROM ghr_pay_plans gpp
4990: WHERE gpp.pay_plan = c_pay_plan
4991: AND gpp.wgi_enabled_flag = 'Y';
4992:
4993: CURSOR c_get_pay_plan(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
4994: SELECT to_pay_plan
4995: FROM ghr_pa_requests par
4996: WHERE par.pa_request_id = c_pa_request_id;
4997:

Line 4995: FROM ghr_pa_requests par

4991: AND gpp.wgi_enabled_flag = 'Y';
4992:
4993: CURSOR c_get_pay_plan(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
4994: SELECT to_pay_plan
4995: FROM ghr_pa_requests par
4996: WHERE par.pa_request_id = c_pa_request_id;
4997:
4998: -----GPPA Update46 Start.
4999: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)

Line 5020: l_retention_allow_percentage ghr_pa_requests.to_retention_allow_percentage%type;

5016: AND pet.element_name = c_element_name
5017: AND pee.assignment_id = c_assignment_id;
5018:
5019: --Pradeep start of Bug 3306515
5020: l_retention_allow_percentage ghr_pa_requests.to_retention_allow_percentage%type;
5021: l_retention_allowance ghr_pa_requests.to_retention_allowance%type;
5022: l_multi_error_flag boolean;
5023: --Pradeep end of Bug 3306515
5024:

Line 5021: l_retention_allowance ghr_pa_requests.to_retention_allowance%type;

5017: AND pee.assignment_id = c_assignment_id;
5018:
5019: --Pradeep start of Bug 3306515
5020: l_retention_allow_percentage ghr_pa_requests.to_retention_allow_percentage%type;
5021: l_retention_allowance ghr_pa_requests.to_retention_allowance%type;
5022: l_multi_error_flag boolean;
5023: --Pradeep end of Bug 3306515
5024:
5025: Begin

Line 6510: (p_pa_request_rec in ghr_pa_requests%rowtype

6506: -- procedure Process_Non_Salary_Info
6507: -- ********************************
6508: --
6509: Procedure Process_non_salary_Info
6510: (p_pa_request_rec in ghr_pa_requests%rowtype
6511: ,p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type
6512: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type
6513: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6514: --Pradeep

Line 6572: l_total_salary ghr_pa_requests.to_total_salary%TYPE;

6568: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6569: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
6570: l_student_loan_repay ghr_api.student_loan_repay_type;
6571: -- Bug#4486823 RRR Changes
6572: l_total_salary ghr_pa_requests.to_total_salary%TYPE;
6573: --
6574: PROCEDURE Create_incentive_Remark(p_pa_request_id IN NUMBER,
6575: p_effective_date IN DATE,
6576: p_category IN VARCHAR2,

Line 6676: PROCEDURE Upd_sep_incn_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE

6672: p_pa_remark_id => l_pa_remark_id,
6673: p_object_version_number => l_object_version_nbr);
6674: END create_incentive_remark;
6675:
6676: PROCEDURE Upd_sep_incn_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
6677: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
6678: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6679: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6680: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE

Line 6677: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE

6673: p_object_version_number => l_object_version_nbr);
6674: END create_incentive_remark;
6675:
6676: PROCEDURE Upd_sep_incn_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
6677: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
6678: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6679: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6680: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
6681: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE) IS

Line 6678: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE

6674: END create_incentive_remark;
6675:
6676: PROCEDURE Upd_sep_incn_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
6677: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
6678: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6679: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6680: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
6681: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE) IS
6682:

Line 6679: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE

6675:
6676: PROCEDURE Upd_sep_incn_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
6677: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
6678: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6679: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6680: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
6681: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE) IS
6682:
6683: Cursor c_inc_catg_details(l_pa_request_id NUMBER) IS

Line 6680: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE

6676: PROCEDURE Upd_sep_incn_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
6677: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
6678: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6679: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6680: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
6681: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE) IS
6682:
6683: Cursor c_inc_catg_details(l_pa_request_id NUMBER) IS
6684: SELECT pa_incentive_category_amount amount,

Line 6681: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE) IS

6677: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
6678: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6679: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6680: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
6681: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE) IS
6682:
6683: Cursor c_inc_catg_details(l_pa_request_id NUMBER) IS
6684: SELECT pa_incentive_category_amount amount,
6685: pa_incentive_category_pmnt_dt payment_date

Line 6846: PROCEDURE process_incentive_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE

6842:
6843: -- Bug#4486823 RRR Changes
6844: -- This procedure processes the elements for Incentive Family.
6845: -- Depending on the user entry, the related elements will be processed.
6846: PROCEDURE process_incentive_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
6847: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
6848: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6849: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6850: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE

Line 6847: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE

6843: -- Bug#4486823 RRR Changes
6844: -- This procedure processes the elements for Incentive Family.
6845: -- Depending on the user entry, the related elements will be processed.
6846: PROCEDURE process_incentive_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
6847: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
6848: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6849: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6850: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
6851: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE

Line 6848: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE

6844: -- This procedure processes the elements for Incentive Family.
6845: -- Depending on the user entry, the related elements will be processed.
6846: PROCEDURE process_incentive_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
6847: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
6848: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6849: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6850: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
6851: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE
6852: ,p_total_amount IN ghr_pa_requests.to_total_salary%TYPE

Line 6849: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE

6845: -- Depending on the user entry, the related elements will be processed.
6846: PROCEDURE process_incentive_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
6847: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
6848: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6849: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6850: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
6851: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE
6852: ,p_total_amount IN ghr_pa_requests.to_total_salary%TYPE
6853: ) IS

Line 6850: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE

6846: PROCEDURE process_incentive_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
6847: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
6848: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6849: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6850: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
6851: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE
6852: ,p_total_amount IN ghr_pa_requests.to_total_salary%TYPE
6853: ) IS
6854:

Line 6851: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE

6847: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
6848: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6849: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6850: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
6851: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE
6852: ,p_total_amount IN ghr_pa_requests.to_total_salary%TYPE
6853: ) IS
6854:
6855: Cursor c_inc_catg_details(l_pa_request_id NUMBER) IS

Line 6852: ,p_total_amount IN ghr_pa_requests.to_total_salary%TYPE

6848: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6849: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6850: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
6851: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE
6852: ,p_total_amount IN ghr_pa_requests.to_total_salary%TYPE
6853: ) IS
6854:
6855: Cursor c_inc_catg_details(l_pa_request_id NUMBER) IS
6856: SELECT pa_incentive_category,

Line 7844: (p_pa_request_rec in ghr_pa_requests%rowtype,

7840: --
7841: --
7842: --
7843: Procedure get_wgi_dates
7844: (p_pa_request_rec in ghr_pa_requests%rowtype,
7845: p_wgi_due_date in out nocopy date,
7846: p_wgi_pay_date out nocopy date,
7847: p_retained_grade_rec out nocopy ghr_pay_calc.retained_grade_rec_type,
7848: p_dlei in date

Line 7856: l_from_step ghr_pa_requests.to_step_or_rate%type;

7852: l_proc varchar2(72) := 'get_wgi_dates';
7853: l_initial_wgi_due_date date;
7854: l_payroll_id pay_payrolls_f.payroll_id%type;
7855: l_eq_pay_plan ghr_pay_plans.pay_plan%type;
7856: l_from_step ghr_pa_requests.to_step_or_rate%type;
7857: l_wgi_due_Date varchar2(60);
7858: l_wgi_pay_date date;
7859: l_wait_period ghr_pay_plan_waiting_periods.waiting_period%type;
7860: l_pay_plan ghr_pay_plans.pay_plan%type;

Line 7861: l_step_or_rate ghr_pa_requests.to_step_or_rate%type;

7857: l_wgi_due_Date varchar2(60);
7858: l_wgi_pay_date date;
7859: l_wait_period ghr_pay_plan_waiting_periods.waiting_period%type;
7860: l_pay_plan ghr_pay_plans.pay_plan%type;
7861: l_step_or_rate ghr_pa_requests.to_step_or_rate%type;
7862: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
7863: l_maximum_step ghr_pa_requests.to_step_or_rate%type;
7864: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
7865: l_user_table_id pay_user_tables.user_table_id%TYPE;

Line 7863: l_maximum_step ghr_pa_requests.to_step_or_rate%type;

7859: l_wait_period ghr_pay_plan_waiting_periods.waiting_period%type;
7860: l_pay_plan ghr_pay_plans.pay_plan%type;
7861: l_step_or_rate ghr_pa_requests.to_step_or_rate%type;
7862: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
7863: l_maximum_step ghr_pa_requests.to_step_or_rate%type;
7864: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
7865: l_user_table_id pay_user_tables.user_table_id%TYPE;
7866:
7867: l_lei_date varchar2(60); -- Bug 3709414

Line 7864: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;

7860: l_pay_plan ghr_pay_plans.pay_plan%type;
7861: l_step_or_rate ghr_pa_requests.to_step_or_rate%type;
7862: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
7863: l_maximum_step ghr_pa_requests.to_step_or_rate%type;
7864: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
7865: l_user_table_id pay_user_tables.user_table_id%TYPE;
7866:
7867: l_lei_date varchar2(60); -- Bug 3709414
7868:

Line 8207: (p_pa_request_rec in ghr_pa_requests%rowtype,

8203:
8204: End get_wgi_dates;
8205: --
8206: Procedure generic_update_sit
8207: (p_pa_request_rec in ghr_pa_requests%rowtype,
8208: p_special_information_type in fnd_id_flex_structures_tl.id_flex_structure_name%type,
8209: p_segment_rec in ghr_api.special_information_type
8210: )
8211: is