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_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.83.12020000.13 2013/01/16 06:53:40 vmididho 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 638: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE ,

634:
635: End Generic_Update_Extra_Info;
636:
637: Procedure Update_Retained_Grade
638: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE ,
639: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE) IS
640: --
641: --
642: cursor c_702_rec is

Line 680: l_ret_object_version_number ghr_pa_requests.object_version_number%type;

676: l_temp_step per_people_extra_info.pei_information9%type;
677: l_new_temp_step per_people_extra_info.pei_information9%type;
678: l_new_step_or_rate per_people_extra_info.pei_information4%type;
679: l_step_or_rate per_people_extra_info.pei_information4%type;
680: l_ret_object_version_number ghr_pa_requests.object_version_number%type;
681: l_ovn ghr_pa_requests.object_version_number%type;
682:
683:
684: CURSOR cur_temp_step

Line 681: l_ovn ghr_pa_requests.object_version_number%type;

677: l_new_temp_step per_people_extra_info.pei_information9%type;
678: l_new_step_or_rate per_people_extra_info.pei_information4%type;
679: l_step_or_rate per_people_extra_info.pei_information4%type;
680: l_ret_object_version_number ghr_pa_requests.object_version_number%type;
681: l_ovn ghr_pa_requests.object_version_number%type;
682:
683:
684: CURSOR cur_temp_step
685: IS

Line 1022: (p_pa_request_rec in ghr_pa_requests%rowtype

1018: -- Procedure Update_edu_sit -- To create/Update Education Sp. Info Type
1019: -------------------------------
1020:
1021: Procedure update_edu_sit
1022: (p_pa_request_rec in ghr_pa_requests%rowtype
1023: ) is
1024:
1025: l_proc varchar2(72) := 'Generic Sit';
1026: l_business_group_id per_people_f.business_group_id%type;

Line 1030: l_education_level ghr_pa_requests.education_level%type;

1026: l_business_group_id per_people_f.business_group_id%type;
1027: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
1028: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
1029: l_personal_analysis_id per_person_analyses.person_analysis_id%type;
1030: l_education_level ghr_pa_requests.education_level%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);

Line 1031: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;

1027: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
1028: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
1029: l_personal_analysis_id per_person_analyses.person_analysis_id%type;
1030: l_education_level ghr_pa_requests.education_level%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;

Line 1032: l_academic_discipline ghr_pa_requests.academic_discipline%type;

1028: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
1029: l_personal_analysis_id per_person_analyses.person_analysis_id%type;
1030: l_education_level ghr_pa_requests.education_level%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;

Line 1264: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE,

1260: -- Procedure call_extra_info_api
1261: -- *************************
1262: --
1263: Procedure call_extra_info_api
1264: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE,
1265: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,
1266: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1267: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1268: p_asg_detail_info in OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508

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

1301: l_form_field_name varchar2(50);
1302: l_posn_title_pm varchar2(50);
1303: l_WS_pm varchar2(50);
1304: l_DS_pm varchar2(50);
1305: l_personnel_office_id ghr_pa_requests.personnel_office_id%type; --\
1306: l_org_structure_id per_position_extra_info.poei_information5%type; -------bug#2623692
1307: l_Organ_Component per_position_extra_info.poei_information5%type; --/
1308: -- JH Get To Position Title PM for Noa Code being updated. Bug 773851
1309: Cursor get_to_posn_title_pm is

Line 1344: from ghr_pa_requests

1340: ----------------------------------- cursor to handle changes to LAC codes for Correction to Apptmt action 1274541
1341: Cursor c_Corr_LAC_Codes(p_pa_request_id number) is
1342: select second_action_la_code1,second_action_la_code2,first_noa_code,second_noa_code,
1343: second_action_la_desc1,second_action_la_desc2 --Bug# 4941984(AFHR2)
1344: from ghr_pa_requests
1345: where pa_request_id=p_pa_request_id and first_noa_code='002';
1346:
1347:
1348: Cursor fam_code(p_second_noa_id number) is

Line 1361: ghr_pa_requests par,

1357: --
1358: Cursor Cur_Par_Asg(p_ssn VARCHAR2) is
1359: select par.first_noa_code
1360: from
1361: ghr_pa_requests par,
1362: per_Assignments_f asg
1363: where asg.assignment_id=par.employee_assignment_id
1364: and par.employee_national_identifier=p_ssn
1365: and noa_family_code not in

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

1368: Order by effective_date asc;
1369:
1370: -- 2839332 Madhuri
1371: -- 3263014 Sundar Datatype of the parameters have been changed to table.column_name%type
1372: /*Cursor Cur_NTE_dates(p_ssn ghr_pa_requests.employee_national_identifier%type, p_noa_code ghr_pa_requests.first_noa_code%type) is
1373: select first_noa_information1 NTE_Dates
1374: from ghr_pa_requests
1375: where first_noa_code=p_noa_code
1376: and noa_family_code not in

Line 1374: from ghr_pa_requests

1370: -- 2839332 Madhuri
1371: -- 3263014 Sundar Datatype of the parameters have been changed to table.column_name%type
1372: /*Cursor Cur_NTE_dates(p_ssn ghr_pa_requests.employee_national_identifier%type, p_noa_code ghr_pa_requests.first_noa_code%type) is
1373: select first_noa_information1 NTE_Dates
1374: from ghr_pa_requests
1375: where first_noa_code=p_noa_code
1376: and noa_family_code not in
1377: ('NON_PAY_DUTY_STATUS','RETURN_TO_DUTY','CANCEL','CORRECT')
1378: and employee_national_identifier=p_ssn;

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

1378: and employee_national_identifier=p_ssn;
1379: */
1380: -- Sundar Bug 3390876
1381: -- Get the effective date of Non-Pay duty status
1382: CURSOR cur_eff_date_non_pay(c_person_id ghr_pa_requests.person_id%type,c_eff_date ghr_pa_requests.effective_date%type)
1383: IS
1384: SELECT
1385: MAX(par.effective_date) eff_date
1386: FROM

Line 1387: ghr_pa_requests par

1383: IS
1384: SELECT
1385: MAX(par.effective_date) eff_date
1386: FROM
1387: ghr_pa_requests par
1388: WHERE
1389: par.person_id= c_person_id AND
1390: par.noa_family_code = 'NON_PAY_DUTY_STATUS' AND
1391: par.pa_notification_id IS NOT NULL AND

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

1391: par.pa_notification_id IS NOT NULL AND
1392: NVL(par.first_noa_cancel_or_correct,'NULL') <> 'CANCEL' AND
1393: par.effective_date < c_eff_date;
1394:
1395: CURSOR cur_nte_date_aft_np(c_person_id ghr_pa_requests.person_id%type,
1396: c_eff_date ghr_pa_requests.effective_date%type, c_rtd_date ghr_pa_requests.effective_date%type)
1397: IS
1398: SELECT
1399: par.first_noa_information1 nte_date

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

1392: NVL(par.first_noa_cancel_or_correct,'NULL') <> 'CANCEL' AND
1393: par.effective_date < c_eff_date;
1394:
1395: CURSOR cur_nte_date_aft_np(c_person_id ghr_pa_requests.person_id%type,
1396: c_eff_date ghr_pa_requests.effective_date%type, c_rtd_date ghr_pa_requests.effective_date%type)
1397: IS
1398: SELECT
1399: par.first_noa_information1 nte_date
1400: FROM

Line 1401: ghr_pa_requests par

1397: IS
1398: SELECT
1399: par.first_noa_information1 nte_date
1400: FROM
1401: ghr_pa_requests par
1402: WHERE
1403: par.person_id= c_person_id AND
1404: par.effective_date BETWEEN c_eff_date AND c_rtd_date AND
1405: par.pa_notification_id IS NOT NULL AND

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

1405: par.pa_notification_id IS NOT NULL AND
1406: NVL(par.first_noa_cancel_or_correct, 'NULL') <> 'CANCEL' AND
1407: par.first_noa_code IN ('508','515','517','522','548','549','553','554','571','590','750','760','761','762','765','769','770');
1408:
1409: /*CURSOR Cur_NTE_date_bef_np(c_person_id ghr_pa_requests.person_id%type,c_eff_date ghr_pa_requests.effective_date%type)
1410: IS
1411: SELECT
1412: first_noa_information1 NTE_Dates
1413: FROM

Line 1414: ghr_pa_requests par,

1410: IS
1411: SELECT
1412: first_noa_information1 NTE_Dates
1413: FROM
1414: ghr_pa_requests par,
1415: per_Assignments_f asg
1416: WHERE
1417: asg.assignment_id= par.employee_assignment_id AND
1418: asg.effective_start_date = par.effective_date AND

Line 1438: target_poi ghr_pa_requests.personnel_office_id%type;

1434: FROM ghr_pa_request_extra_info
1435: WHERE pa_request_id=p_par_id
1436: AND information_type='GHR_US_PAR_REALIGNMENT';
1437:
1438: target_poi ghr_pa_requests.personnel_office_id%type;
1439: -- for bug 3191704
1440:
1441: --l_NTE_Dates per_assignment_extra_info.aei_information4%TYPE;
1442: ---------------------------------------------------------- added 2 cursors for 1274541

Line 1444: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;

1440:
1441: --l_NTE_Dates per_assignment_extra_info.aei_information4%TYPE;
1442: ---------------------------------------------------------- added 2 cursors for 1274541
1443: --Begin Bug 5919705
1444: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
1445: l_pay_plan ghr_pa_requests.to_pay_plan%type;
1446:
1447: CURSOR cur_grd1 IS
1448: SELECT gdf.segment1 pay_plan,

Line 1445: l_pay_plan ghr_pa_requests.to_pay_plan%type;

1441: --l_NTE_Dates per_assignment_extra_info.aei_information4%TYPE;
1442: ---------------------------------------------------------- added 2 cursors for 1274541
1443: --Begin Bug 5919705
1444: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
1445: l_pay_plan ghr_pa_requests.to_pay_plan%type;
1446:
1447: CURSOR cur_grd1 IS
1448: SELECT gdf.segment1 pay_plan,
1449: gdf.segment2 grade_or_level

Line 1465: l_first_noa_code ghr_pa_requests.first_noa_code%type;

1461: and gdf.segment1 = l_pay_plan
1462: and gdf.segment2 = l_grade_or_level
1463: and grd.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
1464: --End Bug 5919705
1465: l_first_noa_code ghr_pa_requests.first_noa_code%type;
1466: l_second_noa_code ghr_pa_requests.second_noa_code%type;
1467: l_fam_code ghr_pa_requests.noa_family_code%type;
1468:
1469: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;

Line 1466: l_second_noa_code ghr_pa_requests.second_noa_code%type;

1462: and gdf.segment2 = l_grade_or_level
1463: and grd.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
1464: --End Bug 5919705
1465: l_first_noa_code ghr_pa_requests.first_noa_code%type;
1466: l_second_noa_code ghr_pa_requests.second_noa_code%type;
1467: l_fam_code ghr_pa_requests.noa_family_code%type;
1468:
1469: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
1470: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;

Line 1467: l_fam_code ghr_pa_requests.noa_family_code%type;

1463: and grd.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
1464: --End Bug 5919705
1465: l_first_noa_code ghr_pa_requests.first_noa_code%type;
1466: l_second_noa_code ghr_pa_requests.second_noa_code%type;
1467: l_fam_code ghr_pa_requests.noa_family_code%type;
1468:
1469: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
1470: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
1471: --Bug# 4941984(AFHR2)

Line 1478: cursor c_scd_tsp(c_person_id ghr_pa_requests.person_id%type,eff_date ghr_pa_requests.effective_date%type) is

1474: --Bug# 4941984(AFHR2)
1475: --Begin Bug# 12557463, commented below cursor
1476: --bug# 12596901,12994100
1477: /*l_scd_tsp per_people_extra_info.pei_information6%type;
1478: cursor c_scd_tsp(c_person_id ghr_pa_requests.person_id%type,eff_date ghr_pa_requests.effective_date%type) is
1479: select information12
1480: from ghr_pa_history
1481: where person_id = c_person_id
1482: and information5 = 'GHR_US_PER_SCD_INFORMATION'

Line 1521: l_agency_code_transfer_to ghr_pa_requests.agency_code%type;

1517: l_Loc_Info GHR_API.Loc_Info_TYPE;
1518: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;
1519: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;
1520: ---for bug 3267632
1521: l_agency_code_transfer_to ghr_pa_requests.agency_code%type;
1522: --
1523: -- Bug 3390876
1524: l_np_eff_date ghr_pa_requests.effective_date%type;
1525: l_asg_ei_data per_assignment_extra_info%rowtype;

Line 1524: l_np_eff_date ghr_pa_requests.effective_date%type;

1520: ---for bug 3267632
1521: l_agency_code_transfer_to ghr_pa_requests.agency_code%type;
1522: --
1523: -- Bug 3390876
1524: l_np_eff_date ghr_pa_requests.effective_date%type;
1525: l_asg_ei_data per_assignment_extra_info%rowtype;
1526: Begin
1527: --
1528: hr_utility.set_location('Entering ' ||l_proc,5);

Line 2501: p_pa_request_id in ghr_pa_requests.pa_request_id%type, --Bug# 8724192

2497: Procedure get_asg_status_type
2498: (p_noa_code in ghr_nature_of_actions.code%type,
2499: p_business_group_id in per_people_f.business_group_id%type,
2500: p_assignment_id in number,
2501: p_pa_request_id in ghr_pa_requests.pa_request_id%type, --Bug# 8724192
2502: p_status_type_id out nocopy per_assignment_status_types.assignment_status_type_id%type,
2503: p_activate_flag out nocopy varchar2,
2504: p_suspend_flag out nocopy varchar2,
2505: p_terminate_flag out nocopy varchar2

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

3038: -- procedure Process_Family
3039: -- ***********************
3040: --
3041: procedure Process_Family
3042: (P_PA_REQUEST_REC IN OUT NOCOPY GHR_PA_REQUESTS%ROWTYPE,
3043: P_AGENCY_CODE IN varchar2 ) is
3044:
3045: l_noa_code ghr_nature_of_actions.code%type;
3046: --

Line 3047: l_pa_request_rec ghr_pa_requests%rowtype;

3043: P_AGENCY_CODE IN varchar2 ) is
3044:
3045: l_noa_code ghr_nature_of_actions.code%type;
3046: --
3047: l_pa_request_rec ghr_pa_requests%rowtype;
3048: l_proc varchar2(70) := 'Process_family';
3049: l_hr_person_api_update varchar2(1) := 'N';
3050: l_hr_applicant_api_hire varchar2(1) := 'N';
3051: l_employee_api_update_criteria varchar2(1) := 'N';

Line 3141: l_date1 ghr_pa_requests.effective_date%type;

3137: l_asg_object_version_number per_assignments_f.object_version_number%type;
3138: l_add_object_version_number per_addresses.object_version_number%type;
3139: l_person_id per_people_f.person_id%type;
3140: l_person_type_id per_people_f.person_type_id%type;
3141: l_date1 ghr_pa_requests.effective_date%type;
3142: l_address_id per_addresses.address_id%type;
3143: l_person_type per_person_types.system_person_type%type;
3144: --l_sec_assignmemt_id per_assignments_f.assignment_id%type;
3145: --l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type;

Line 3361: FROM ghr_pa_requests

3357: AND pah.information1 = p_address_id
3358: AND pah.pa_request_id IN
3359: (
3360: SELECT pa_request_id
3361: FROM ghr_pa_requests
3362: CONNECT BY prior pa_request_id = altered_pa_request_id
3363: START WITH pa_request_id = p_pa_request_id
3364: );
3365: --

Line 3560: FROM ghr_pa_Requests

3556: CURSOR RTD_asg_status( p_asg_id NUMBER,
3557: p_eff_date DATE )
3558: IS
3559: SELECT effective_date
3560: FROM ghr_pa_Requests
3561: WHERE effective_date <= p_eff_Date
3562: and person_id = p_pa_request_rec.person_id
3563: --and employee_assignment_id = p_Asg_id
3564: -- for performance reasons

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

3684: l_rpa_remark_code ghr_remarks.code%TYPE;
3685: l_rpa_remark_id ghr_remarks.remark_id%TYPE;
3686:
3687: --bug 4542437
3688: l_position_id ghr_pa_requests.from_position_id%TYPE :=NULL;
3689: l_job_id per_all_assignments_f.job_id%TYPE :=NULL;
3690: l_org_id per_all_assignments_f.organization_id%TYPE :=NULL;
3691: l_grade_id per_position_extra_info.poei_information3%TYPE :=NULL;
3692: l_pos_ei_data per_position_extra_info%ROWTYPE;

Line 5001: (p_pa_request_rec in ghr_pa_requests%rowtype

4997: -- procedure Process_Salary_Info
4998: -- ********************************
4999: --
5000: Procedure Process_salary_Info
5001: (p_pa_request_rec in ghr_pa_requests%rowtype
5002: ,p_wgi in out nocopy ghr_api.within_grade_increase_type
5003: ,p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type
5004: ,p_capped_other_pay in number default null
5005: ) is

Line 5032: l_ret_object_version_number ghr_pa_requests.object_version_number%type;

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

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

5222: WHERE pa_request_id = p_pa_request_rec.pa_request_id
5223: AND information_type = 'GHR_US_PAR_SALARY_CHG';
5224: --
5225: -- Bug 3953455 Cursor to fetch the To step for both normal and correction actions.
5226: CURSOR cur_get_step(c_pa_request_id ghr_pa_requests.pa_request_id%type)
5227: IS
5228: SELECT par_orig.from_step_or_rate step1, par_corr.from_step_or_rate step2
5229: FROM ghr_pa_requests par_orig , ghr_pa_requests par_corr
5230: where par_orig.pa_request_id = par_corr.altered_pa_request_id

Line 5229: FROM ghr_pa_requests par_orig , ghr_pa_requests par_corr

5225: -- Bug 3953455 Cursor to fetch the To step for both normal and correction actions.
5226: CURSOR cur_get_step(c_pa_request_id ghr_pa_requests.pa_request_id%type)
5227: IS
5228: SELECT par_orig.from_step_or_rate step1, par_corr.from_step_or_rate step2
5229: FROM ghr_pa_requests par_orig , ghr_pa_requests par_corr
5230: where par_orig.pa_request_id = par_corr.altered_pa_request_id
5231: and par_corr.pa_request_id = c_pa_request_id;
5232:
5233: l_orig_pa_from_step ghr_pa_requests.to_step_or_rate%type;

Line 5233: l_orig_pa_from_step ghr_pa_requests.to_step_or_rate%type;

5229: FROM ghr_pa_requests par_orig , ghr_pa_requests par_corr
5230: where par_orig.pa_request_id = par_corr.altered_pa_request_id
5231: and par_corr.pa_request_id = c_pa_request_id;
5232:
5233: l_orig_pa_from_step ghr_pa_requests.to_step_or_rate%type;
5234: l_corr_pa_from_step ghr_pa_requests.to_step_or_rate%type;
5235: l_call_wgi_dates BOOLEAN;
5236:
5237: -- End Bug 3953455

Line 5234: l_corr_pa_from_step ghr_pa_requests.to_step_or_rate%type;

5230: where par_orig.pa_request_id = par_corr.altered_pa_request_id
5231: and par_corr.pa_request_id = c_pa_request_id;
5232:
5233: l_orig_pa_from_step ghr_pa_requests.to_step_or_rate%type;
5234: l_corr_pa_from_step ghr_pa_requests.to_step_or_rate%type;
5235: l_call_wgi_dates BOOLEAN;
5236:
5237: -- End Bug 3953455
5238:

Line 5242: l_to_pay_plan ghr_pa_requests.to_pay_plan%type;

5238:
5239: -- -- Bug 4031919 Cursor to check if pay plan is eligible for WGI or not.
5240: l_is_wgi_eligible BOOLEAN;
5241: l_wgi_cleared BOOLEAN;
5242: l_to_pay_plan ghr_pa_requests.to_pay_plan%type;
5243: l_wgi_exists BOOLEAN;
5244: l_wgi_new_name VARCHAR2(250);
5245:
5246: CURSOR c_wgi_pay_plan(c_pay_plan ghr_pa_requests.to_pay_plan%TYPE) IS

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

5242: l_to_pay_plan ghr_pa_requests.to_pay_plan%type;
5243: l_wgi_exists BOOLEAN;
5244: l_wgi_new_name VARCHAR2(250);
5245:
5246: CURSOR c_wgi_pay_plan(c_pay_plan ghr_pa_requests.to_pay_plan%TYPE) IS
5247: SELECT 1
5248: FROM ghr_pay_plans gpp
5249: WHERE gpp.pay_plan = c_pay_plan
5250: AND gpp.wgi_enabled_flag = 'Y';

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

5248: FROM ghr_pay_plans gpp
5249: WHERE gpp.pay_plan = c_pay_plan
5250: AND gpp.wgi_enabled_flag = 'Y';
5251:
5252: CURSOR c_get_pay_plan(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
5253: SELECT to_pay_plan
5254: FROM ghr_pa_requests par
5255: WHERE par.pa_request_id = c_pa_request_id;
5256:

Line 5254: FROM ghr_pa_requests par

5250: AND gpp.wgi_enabled_flag = 'Y';
5251:
5252: CURSOR c_get_pay_plan(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
5253: SELECT to_pay_plan
5254: FROM ghr_pa_requests par
5255: WHERE par.pa_request_id = c_pa_request_id;
5256:
5257: -----GPPA Update46 Start.
5258: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)

Line 5279: l_retention_allow_percentage ghr_pa_requests.to_retention_allow_percentage%type;

5275: AND pet.element_name = c_element_name
5276: AND pee.assignment_id = c_assignment_id;
5277:
5278: --Pradeep start of Bug 3306515
5279: l_retention_allow_percentage ghr_pa_requests.to_retention_allow_percentage%type;
5280: l_retention_allowance ghr_pa_requests.to_retention_allowance%type;
5281: l_multi_error_flag boolean;
5282: --Pradeep end of Bug 3306515
5283:

Line 5280: l_retention_allowance ghr_pa_requests.to_retention_allowance%type;

5276: AND pee.assignment_id = c_assignment_id;
5277:
5278: --Pradeep start of Bug 3306515
5279: l_retention_allow_percentage ghr_pa_requests.to_retention_allow_percentage%type;
5280: l_retention_allowance ghr_pa_requests.to_retention_allowance%type;
5281: l_multi_error_flag boolean;
5282: --Pradeep end of Bug 3306515
5283:
5284: Begin

Line 6781: (p_pa_request_rec in ghr_pa_requests%rowtype

6777: -- procedure Process_Non_Salary_Info
6778: -- ********************************
6779: --
6780: Procedure Process_non_salary_Info
6781: (p_pa_request_rec in ghr_pa_requests%rowtype
6782: ,p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type
6783: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type
6784: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6785: --Pradeep

Line 6845: l_total_salary ghr_pa_requests.to_total_salary%TYPE;

6841: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6842: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
6843: l_student_loan_repay ghr_api.student_loan_repay_type;
6844: -- Bug#4486823 RRR Changes
6845: l_total_salary ghr_pa_requests.to_total_salary%TYPE;
6846: --
6847:
6848: --Bug # 13571004
6849: l_tsp_roth ghr_api.tsp_roth_type;

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

6948: p_pa_remark_id => l_pa_remark_id,
6949: p_object_version_number => l_object_version_nbr);
6950: END create_incentive_remark;
6951:
6952: PROCEDURE Upd_sep_incn_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
6953: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
6954: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6955: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6956: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE

Line 6953: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE

6949: p_object_version_number => l_object_version_nbr);
6950: END create_incentive_remark;
6951:
6952: PROCEDURE Upd_sep_incn_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
6953: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
6954: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6955: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6956: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
6957: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE) IS

Line 6954: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE

6950: END create_incentive_remark;
6951:
6952: PROCEDURE Upd_sep_incn_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
6953: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
6954: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6955: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6956: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
6957: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE) IS
6958:

Line 6955: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE

6951:
6952: PROCEDURE Upd_sep_incn_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
6953: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
6954: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6955: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6956: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
6957: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE) IS
6958:
6959: Cursor c_inc_catg_details(l_pa_request_id NUMBER) IS

Line 6956: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE

6952: PROCEDURE Upd_sep_incn_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
6953: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
6954: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6955: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6956: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
6957: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE) IS
6958:
6959: Cursor c_inc_catg_details(l_pa_request_id NUMBER) IS
6960: SELECT pa_incentive_category_amount amount,

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

6953: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
6954: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
6955: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
6956: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
6957: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE) IS
6958:
6959: Cursor c_inc_catg_details(l_pa_request_id NUMBER) IS
6960: SELECT pa_incentive_category_amount amount,
6961: pa_incentive_category_pmnt_dt payment_date

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

7118:
7119: -- Bug#4486823 RRR Changes
7120: -- This procedure processes the elements for Incentive Family.
7121: -- Depending on the user entry, the related elements will be processed.
7122: PROCEDURE process_incentive_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
7123: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
7124: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
7125: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
7126: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE

Line 7123: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE

7119: -- Bug#4486823 RRR Changes
7120: -- This procedure processes the elements for Incentive Family.
7121: -- Depending on the user entry, the related elements will be processed.
7122: PROCEDURE process_incentive_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
7123: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
7124: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
7125: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
7126: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
7127: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE

Line 7124: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE

7120: -- This procedure processes the elements for Incentive Family.
7121: -- Depending on the user entry, the related elements will be processed.
7122: PROCEDURE process_incentive_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
7123: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
7124: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
7125: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
7126: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
7127: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE
7128: ,p_total_amount IN ghr_pa_requests.to_total_salary%TYPE

Line 7125: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE

7121: -- Depending on the user entry, the related elements will be processed.
7122: PROCEDURE process_incentive_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
7123: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
7124: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
7125: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
7126: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
7127: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE
7128: ,p_total_amount IN ghr_pa_requests.to_total_salary%TYPE
7129: ) IS

Line 7126: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE

7122: PROCEDURE process_incentive_elements(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
7123: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
7124: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
7125: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
7126: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
7127: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE
7128: ,p_total_amount IN ghr_pa_requests.to_total_salary%TYPE
7129: ) IS
7130:

Line 7127: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE

7123: ,p_assignment_id IN ghr_pa_requests.employee_assignment_id%TYPE
7124: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
7125: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
7126: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
7127: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE
7128: ,p_total_amount IN ghr_pa_requests.to_total_salary%TYPE
7129: ) IS
7130:
7131: Cursor c_inc_catg_details(l_pa_request_id NUMBER) IS

Line 7128: ,p_total_amount IN ghr_pa_requests.to_total_salary%TYPE

7124: ,p_effective_date IN ghr_pa_requests.effective_date%TYPE
7125: ,p_payment_option IN ghr_pa_requests.pa_incentive_payment_option%TYPE
7126: ,p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE
7127: ,p_second_noa_code IN ghr_pa_requests.second_noa_code%TYPE
7128: ,p_total_amount IN ghr_pa_requests.to_total_salary%TYPE
7129: ) IS
7130:
7131: Cursor c_inc_catg_details(l_pa_request_id NUMBER) IS
7132: SELECT pa_incentive_category,

Line 8147: (p_pa_request_rec in ghr_pa_requests%rowtype,

8143: --
8144: --
8145: --
8146: Procedure get_wgi_dates
8147: (p_pa_request_rec in ghr_pa_requests%rowtype,
8148: p_wgi_due_date in out nocopy date,
8149: p_wgi_pay_date out nocopy date,
8150: p_retained_grade_rec out nocopy ghr_pay_calc.retained_grade_rec_type,
8151: p_dlei in date

Line 8159: l_from_step ghr_pa_requests.to_step_or_rate%type;

8155: l_proc varchar2(72) := 'get_wgi_dates';
8156: l_initial_wgi_due_date date;
8157: l_payroll_id pay_payrolls_f.payroll_id%type;
8158: l_eq_pay_plan ghr_pay_plans.pay_plan%type;
8159: l_from_step ghr_pa_requests.to_step_or_rate%type;
8160: l_wgi_due_Date varchar2(60);
8161: l_wgi_pay_date date;
8162: l_wait_period ghr_pay_plan_waiting_periods.waiting_period%type;
8163: l_pay_plan ghr_pay_plans.pay_plan%type;

Line 8164: l_step_or_rate ghr_pa_requests.to_step_or_rate%type;

8160: l_wgi_due_Date varchar2(60);
8161: l_wgi_pay_date date;
8162: l_wait_period ghr_pay_plan_waiting_periods.waiting_period%type;
8163: l_pay_plan ghr_pay_plans.pay_plan%type;
8164: l_step_or_rate ghr_pa_requests.to_step_or_rate%type;
8165: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
8166: l_maximum_step ghr_pa_requests.to_step_or_rate%type;
8167: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
8168: l_user_table_id pay_user_tables.user_table_id%TYPE;

Line 8166: l_maximum_step ghr_pa_requests.to_step_or_rate%type;

8162: l_wait_period ghr_pay_plan_waiting_periods.waiting_period%type;
8163: l_pay_plan ghr_pay_plans.pay_plan%type;
8164: l_step_or_rate ghr_pa_requests.to_step_or_rate%type;
8165: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
8166: l_maximum_step ghr_pa_requests.to_step_or_rate%type;
8167: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
8168: l_user_table_id pay_user_tables.user_table_id%TYPE;
8169:
8170: l_lei_date varchar2(60); -- Bug 3709414

Line 8167: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;

8163: l_pay_plan ghr_pay_plans.pay_plan%type;
8164: l_step_or_rate ghr_pa_requests.to_step_or_rate%type;
8165: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
8166: l_maximum_step ghr_pa_requests.to_step_or_rate%type;
8167: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
8168: l_user_table_id pay_user_tables.user_table_id%TYPE;
8169:
8170: l_lei_date varchar2(60); -- Bug 3709414
8171:

Line 8510: (p_pa_request_rec in ghr_pa_requests%rowtype,

8506:
8507: End get_wgi_dates;
8508: --
8509: Procedure generic_update_sit
8510: (p_pa_request_rec in ghr_pa_requests%rowtype,
8511: p_special_information_type in fnd_id_flex_structures_tl.id_flex_structure_name%type,
8512: p_segment_rec in ghr_api.special_information_type
8513: )
8514: is