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_MASS_SEL_NOA dependencies on GHR_MASS_SALARIES

Line 11: l_noa_code ghr_mass_salaries.noa_code%type;

7: l_noaerrbuf varchar2(2000) DEFAULT NULL;
8: l_mcanerrbuf varchar2(2000) DEFAULT NULL;
9: cur_business_group_id per_business_groups.business_group_id%type;
10: g_effective_date date;
11: l_noa_code ghr_mass_salaries.noa_code%type;
12: l_nte_date ghr_mass_salaries.nte_date%type;
13: l_target_barg_unit_status ghr_mass_salaries.target_bargaining_unit_status%type;
14: l_target_flsa_category ghr_mass_salaries.target_flsa_category%type;
15: l_target_occ_code ghr_mass_salaries.target_occ_code%type;

Line 12: l_nte_date ghr_mass_salaries.nte_date%type;

8: l_mcanerrbuf varchar2(2000) DEFAULT NULL;
9: cur_business_group_id per_business_groups.business_group_id%type;
10: g_effective_date date;
11: l_noa_code ghr_mass_salaries.noa_code%type;
12: l_nte_date ghr_mass_salaries.nte_date%type;
13: l_target_barg_unit_status ghr_mass_salaries.target_bargaining_unit_status%type;
14: l_target_flsa_category ghr_mass_salaries.target_flsa_category%type;
15: l_target_occ_code ghr_mass_salaries.target_occ_code%type;
16: l_target_job_id ghr_mass_salaries.target_job_id%type;

Line 13: l_target_barg_unit_status ghr_mass_salaries.target_bargaining_unit_status%type;

9: cur_business_group_id per_business_groups.business_group_id%type;
10: g_effective_date date;
11: l_noa_code ghr_mass_salaries.noa_code%type;
12: l_nte_date ghr_mass_salaries.nte_date%type;
13: l_target_barg_unit_status ghr_mass_salaries.target_bargaining_unit_status%type;
14: l_target_flsa_category ghr_mass_salaries.target_flsa_category%type;
15: l_target_occ_code ghr_mass_salaries.target_occ_code%type;
16: l_target_job_id ghr_mass_salaries.target_job_id%type;
17: l_target_agency_code_subelmt ghr_mass_salaries.target_agency_code_subelement%type;

Line 14: l_target_flsa_category ghr_mass_salaries.target_flsa_category%type;

10: g_effective_date date;
11: l_noa_code ghr_mass_salaries.noa_code%type;
12: l_nte_date ghr_mass_salaries.nte_date%type;
13: l_target_barg_unit_status ghr_mass_salaries.target_bargaining_unit_status%type;
14: l_target_flsa_category ghr_mass_salaries.target_flsa_category%type;
15: l_target_occ_code ghr_mass_salaries.target_occ_code%type;
16: l_target_job_id ghr_mass_salaries.target_job_id%type;
17: l_target_agency_code_subelmt ghr_mass_salaries.target_agency_code_subelement%type;
18: l_target_duty_station_id ghr_mass_salaries.target_duty_station_id%type;

Line 15: l_target_occ_code ghr_mass_salaries.target_occ_code%type;

11: l_noa_code ghr_mass_salaries.noa_code%type;
12: l_nte_date ghr_mass_salaries.nte_date%type;
13: l_target_barg_unit_status ghr_mass_salaries.target_bargaining_unit_status%type;
14: l_target_flsa_category ghr_mass_salaries.target_flsa_category%type;
15: l_target_occ_code ghr_mass_salaries.target_occ_code%type;
16: l_target_job_id ghr_mass_salaries.target_job_id%type;
17: l_target_agency_code_subelmt ghr_mass_salaries.target_agency_code_subelement%type;
18: l_target_duty_station_id ghr_mass_salaries.target_duty_station_id%type;
19: l_target_duty_station_code ghr_mass_salaries.target_duty_station_code%type;

Line 16: l_target_job_id ghr_mass_salaries.target_job_id%type;

12: l_nte_date ghr_mass_salaries.nte_date%type;
13: l_target_barg_unit_status ghr_mass_salaries.target_bargaining_unit_status%type;
14: l_target_flsa_category ghr_mass_salaries.target_flsa_category%type;
15: l_target_occ_code ghr_mass_salaries.target_occ_code%type;
16: l_target_job_id ghr_mass_salaries.target_job_id%type;
17: l_target_agency_code_subelmt ghr_mass_salaries.target_agency_code_subelement%type;
18: l_target_duty_station_id ghr_mass_salaries.target_duty_station_id%type;
19: l_target_duty_station_code ghr_mass_salaries.target_duty_station_code%type;
20: l_p_personnel_office_id ghr_pa_requests.personnel_office_id%type;

Line 17: l_target_agency_code_subelmt ghr_mass_salaries.target_agency_code_subelement%type;

13: l_target_barg_unit_status ghr_mass_salaries.target_bargaining_unit_status%type;
14: l_target_flsa_category ghr_mass_salaries.target_flsa_category%type;
15: l_target_occ_code ghr_mass_salaries.target_occ_code%type;
16: l_target_job_id ghr_mass_salaries.target_job_id%type;
17: l_target_agency_code_subelmt ghr_mass_salaries.target_agency_code_subelement%type;
18: l_target_duty_station_id ghr_mass_salaries.target_duty_station_id%type;
19: l_target_duty_station_code ghr_mass_salaries.target_duty_station_code%type;
20: l_p_personnel_office_id ghr_pa_requests.personnel_office_id%type;
21: l_target_functional_class ghr_mass_salaries.target_functional_class%type;--Bug# 14410401

Line 18: l_target_duty_station_id ghr_mass_salaries.target_duty_station_id%type;

14: l_target_flsa_category ghr_mass_salaries.target_flsa_category%type;
15: l_target_occ_code ghr_mass_salaries.target_occ_code%type;
16: l_target_job_id ghr_mass_salaries.target_job_id%type;
17: l_target_agency_code_subelmt ghr_mass_salaries.target_agency_code_subelement%type;
18: l_target_duty_station_id ghr_mass_salaries.target_duty_station_id%type;
19: l_target_duty_station_code ghr_mass_salaries.target_duty_station_code%type;
20: l_p_personnel_office_id ghr_pa_requests.personnel_office_id%type;
21: l_target_functional_class ghr_mass_salaries.target_functional_class%type;--Bug# 14410401
22: -- Begin Bug# 14751973

Line 19: l_target_duty_station_code ghr_mass_salaries.target_duty_station_code%type;

15: l_target_occ_code ghr_mass_salaries.target_occ_code%type;
16: l_target_job_id ghr_mass_salaries.target_job_id%type;
17: l_target_agency_code_subelmt ghr_mass_salaries.target_agency_code_subelement%type;
18: l_target_duty_station_id ghr_mass_salaries.target_duty_station_id%type;
19: l_target_duty_station_code ghr_mass_salaries.target_duty_station_code%type;
20: l_p_personnel_office_id ghr_pa_requests.personnel_office_id%type;
21: l_target_functional_class ghr_mass_salaries.target_functional_class%type;--Bug# 14410401
22: -- Begin Bug# 14751973
23: l_target_duty_station_desc varchar2(150);

Line 21: l_target_functional_class ghr_mass_salaries.target_functional_class%type;--Bug# 14410401

17: l_target_agency_code_subelmt ghr_mass_salaries.target_agency_code_subelement%type;
18: l_target_duty_station_id ghr_mass_salaries.target_duty_station_id%type;
19: l_target_duty_station_code ghr_mass_salaries.target_duty_station_code%type;
20: l_p_personnel_office_id ghr_pa_requests.personnel_office_id%type;
21: l_target_functional_class ghr_mass_salaries.target_functional_class%type;--Bug# 14410401
22: -- Begin Bug# 14751973
23: l_target_duty_station_desc varchar2(150);
24: l_old_barg_unit_status ghr_mass_salaries.target_bargaining_unit_status%type;
25: l_old_flsa_category ghr_mass_salaries.target_flsa_category%type;

Line 24: l_old_barg_unit_status ghr_mass_salaries.target_bargaining_unit_status%type;

20: l_p_personnel_office_id ghr_pa_requests.personnel_office_id%type;
21: l_target_functional_class ghr_mass_salaries.target_functional_class%type;--Bug# 14410401
22: -- Begin Bug# 14751973
23: l_target_duty_station_desc varchar2(150);
24: l_old_barg_unit_status ghr_mass_salaries.target_bargaining_unit_status%type;
25: l_old_flsa_category ghr_mass_salaries.target_flsa_category%type;
26: l_old_occ_code ghr_mass_salaries.target_occ_code%type;
27: l_old_functional_class ghr_mass_salaries.target_functional_class%type;
28: l_dummy varchar2(80);

Line 25: l_old_flsa_category ghr_mass_salaries.target_flsa_category%type;

21: l_target_functional_class ghr_mass_salaries.target_functional_class%type;--Bug# 14410401
22: -- Begin Bug# 14751973
23: l_target_duty_station_desc varchar2(150);
24: l_old_barg_unit_status ghr_mass_salaries.target_bargaining_unit_status%type;
25: l_old_flsa_category ghr_mass_salaries.target_flsa_category%type;
26: l_old_occ_code ghr_mass_salaries.target_occ_code%type;
27: l_old_functional_class ghr_mass_salaries.target_functional_class%type;
28: l_dummy varchar2(80);
29: g_mcal_flag BOOLEAN DEFAULT FALSE;

Line 26: l_old_occ_code ghr_mass_salaries.target_occ_code%type;

22: -- Begin Bug# 14751973
23: l_target_duty_station_desc varchar2(150);
24: l_old_barg_unit_status ghr_mass_salaries.target_bargaining_unit_status%type;
25: l_old_flsa_category ghr_mass_salaries.target_flsa_category%type;
26: l_old_occ_code ghr_mass_salaries.target_occ_code%type;
27: l_old_functional_class ghr_mass_salaries.target_functional_class%type;
28: l_dummy varchar2(80);
29: g_mcal_flag BOOLEAN DEFAULT FALSE;
30: p_can_noa_code ghr_mass_salaries.noa_code%type;

Line 27: l_old_functional_class ghr_mass_salaries.target_functional_class%type;

23: l_target_duty_station_desc varchar2(150);
24: l_old_barg_unit_status ghr_mass_salaries.target_bargaining_unit_status%type;
25: l_old_flsa_category ghr_mass_salaries.target_flsa_category%type;
26: l_old_occ_code ghr_mass_salaries.target_occ_code%type;
27: l_old_functional_class ghr_mass_salaries.target_functional_class%type;
28: l_dummy varchar2(80);
29: g_mcal_flag BOOLEAN DEFAULT FALSE;
30: p_can_noa_code ghr_mass_salaries.noa_code%type;
31: -- End Bug# 14751973

Line 30: p_can_noa_code ghr_mass_salaries.noa_code%type;

26: l_old_occ_code ghr_mass_salaries.target_occ_code%type;
27: l_old_functional_class ghr_mass_salaries.target_functional_class%type;
28: l_dummy varchar2(80);
29: g_mcal_flag BOOLEAN DEFAULT FALSE;
30: p_can_noa_code ghr_mass_salaries.noa_code%type;
31: -- End Bug# 14751973
32:
33: PROCEDURE pr
34: (msg IN varchar2

Line 1524: l_p_locality_area_code ghr_mass_salaries.locality_pay_area_code%TYPE;

1520: l_duty_station_id number;
1521: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
1522: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
1523: l_effective_date date;
1524: l_p_locality_area_code ghr_mass_salaries.locality_pay_area_code%TYPE;
1525: l_personnel_office_id varchar2(300);
1526: l_org_structure_id varchar2(300);
1527: l_sub_element_code varchar2(300);
1528: l_old_basic_pay number;

Line 1565: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;

1561: l_calculated boolean;
1562: l_mass_salary_id number;
1563: l_user_table_id number;
1564: l_submit_flag varchar2(2);
1565: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
1566: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
1567: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
1568: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
1569: l_pa_request_id number;

Line 1566: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;

1562: l_mass_salary_id number;
1563: l_user_table_id number;
1564: l_submit_flag varchar2(2);
1565: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
1566: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
1567: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
1568: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
1569: l_pa_request_id number;
1570: l_rowid varchar2(30);

Line 1567: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;

1563: l_user_table_id number;
1564: l_submit_flag varchar2(2);
1565: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
1566: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
1567: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
1568: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
1569: l_pa_request_id number;
1570: l_rowid varchar2(30);
1571: l_p_organization_id number;

Line 1568: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;

1564: l_submit_flag varchar2(2);
1565: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
1566: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
1567: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
1568: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
1569: l_pa_request_id number;
1570: l_rowid varchar2(30);
1571: l_p_organization_id number;
1572: l_p_duty_station_id number;

Line 1971: FROM ghr_mass_salaries

1967: ,target_functional_class
1968: ,bargaining_unit_status
1969: ,flsa_category
1970: ,job_id
1971: FROM ghr_mass_salaries
1972: WHERE mass_salary_id = p_msnoa_id
1973: FOR UPDATE OF user_table_id NOWAIT;
1974:
1975: CURSOR get_noa_fam IS

Line 2042: l_vac_duty_station_code ghr_mass_salaries.target_duty_station_code%type;

2038: l_vac_barg_unit_status per_position_extra_info.poei_information8%TYPE;
2039: l_vac_duty_location_id ghr_pa_requests.duty_station_location_id%TYPE;
2040: l_vac_functional_class per_position_extra_info.poei_information11%TYPE;
2041: -- Begin Bug# 14751973
2042: l_vac_duty_station_code ghr_mass_salaries.target_duty_station_code%type;
2043: l_vac_duty_station_desc varchar2(150);
2044: l_vac_occ_code ghr_mass_salaries.target_occ_code%type;
2045: -- End Bug# 14751973
2046: BEGIN

Line 2044: l_vac_occ_code ghr_mass_salaries.target_occ_code%type;

2040: l_vac_functional_class per_position_extra_info.poei_information11%TYPE;
2041: -- Begin Bug# 14751973
2042: l_vac_duty_station_code ghr_mass_salaries.target_duty_station_code%type;
2043: l_vac_duty_station_desc varchar2(150);
2044: l_vac_occ_code ghr_mass_salaries.target_occ_code%type;
2045: -- End Bug# 14751973
2046: BEGIN
2047: SAVEPOINT execute_noa_vacent;
2048: l_sel_flg := NULL;

Line 2435: UPDATE ghr_mass_salaries

2431:
2432: p_retcode := 2;
2433:
2434: IF upper (p_action) = 'CREATE' THEN
2435: UPDATE ghr_mass_salaries
2436: SET submit_flag = 'E'
2437: WHERE rowid = l_rowid;
2438:
2439: COMMIT;

Line 3136: UPDATE ghr_mass_salaries

3132: p_errbuf := 'Error in '|| l_proc|| ' Details in GHR_PROCESS_LOG';
3133: p_retcode := 2;
3134:
3135: IF upper (p_action) = 'CREATE' THEN
3136: UPDATE ghr_mass_salaries
3137: SET submit_flag = 'E'
3138: WHERE rowid = l_rowid;
3139:
3140: COMMIT;

Line 4283: UPDATE ghr_mass_salaries

4279:
4280: IF (l_recs_failed = 0) THEN
4281: IF upper (p_action) = 'CREATE' THEN
4282: BEGIN
4283: UPDATE ghr_mass_salaries
4284: SET submit_flag = 'P'
4285: WHERE rowid = l_rowid;
4286: EXCEPTION
4287: WHEN others THEN

Line 4301: UPDATE ghr_mass_salaries

4297:
4298: p_retcode := 2;
4299:
4300: IF upper (p_action) = 'CREATE' THEN
4301: UPDATE ghr_mass_salaries
4302: SET submit_flag = 'E'
4303: WHERE rowid = l_rowid;
4304: END IF;
4305: END IF;

Line 4333: UPDATE ghr_mass_salaries

4329: p_errbuf := 'Error in '|| l_proc|| ' Details in GHR_PROCESS_LOG';
4330: p_retcode := 2;
4331:
4332: IF upper (p_action) = 'CREATE' THEN
4333: UPDATE ghr_mass_salaries
4334: SET submit_flag = 'E'
4335: WHERE rowid = l_rowid;
4336:
4337: COMMIT;

Line 4401: FROM ghr_mass_salaries

4397: , mass_salary_id
4398: , submit_flag
4399: , rowid
4400: , pa_request_id
4401: FROM ghr_mass_salaries
4402: WHERE mass_salary_id = p_mcan_id
4403: FOR UPDATE OF user_table_id NOWAIT;
4404:
4405: CURSOR cur_can_records

Line 4855: UPDATE ghr_mass_salaries

4851: || ' Details in GHR_PROCESS_LOG';
4852: p_retcode := 2;
4853:
4854: IF upper (p_action) = 'CREATE' THEN
4855: UPDATE ghr_mass_salaries
4856: SET submit_flag = 'E'
4857: WHERE rowid = l_rowid;
4858:
4859: COMMIT;

Line 4924: UPDATE ghr_mass_salaries

4920: || ' Details in GHR_PROCESS_LOG';
4921: p_retcode := 2;
4922:
4923: IF upper (p_action) = 'CREATE' THEN
4924: UPDATE ghr_mass_salaries
4925: SET submit_flag = 'E'
4926: WHERE rowid = l_rowid;
4927:
4928: COMMIT;

Line 5016: UPDATE ghr_mass_salaries

5012:
5013: IF (l_recs_failed = 0) THEN
5014: IF upper (p_action) = 'CREATE' THEN
5015: BEGIN
5016: UPDATE ghr_mass_salaries
5017: SET submit_flag = 'P'
5018: WHERE rowid = l_rowid;
5019: EXCEPTION
5020: WHEN others THEN

Line 5037: UPDATE ghr_mass_salaries

5033:
5034: p_retcode := 2;
5035:
5036: IF upper (p_action) = 'CREATE' THEN
5037: UPDATE ghr_mass_salaries
5038: SET submit_flag = 'E'
5039: WHERE rowid = l_rowid;
5040: END IF;
5041: END IF;

Line 5080: UPDATE ghr_mass_salaries

5076:
5077: p_retcode := 2;
5078:
5079: IF upper (p_action) = 'CREATE' THEN
5080: UPDATE ghr_mass_salaries
5081: SET submit_flag = 'E'
5082: WHERE rowid = l_rowid;
5083:
5084: COMMIT;