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

Line 18: l_p_locality_area_code ghr_mass_salaries.locality_pay_area_code%type;

14: p_mass_salary_id in number,
15: p_action in varchar2) is
16:
17: p_mass_salary varchar2(32);
18: l_p_locality_area_code ghr_mass_salaries.locality_pay_area_code%type;
19:
20: --
21: -- Main Cursor which fetches from per_assignments_f and per_people_f
22: --

Line 75: FROM ghr_mass_salaries

71: executive_order_number, executive_order_date, ROWID, PA_REQUEST_ID,
72: ORGANIZATION_ID, DUTY_STATION_ID, PERSONNEL_OFFICE_ID,
73: AGENCY_CODE_SUBELEMENT, OPM_ISSUANCE_NUMBER, OPM_ISSUANCE_DATE,
74: locality_pay_area_code
75: FROM ghr_mass_salaries
76: WHERE MASS_SALARY_ID = p_msl_id
77: ---and process_type = <>
78: for update of user_table_id nowait;
79:

Line 163: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;

159:
160: l_mass_salary_id number;
161: l_user_table_id number;
162: l_submit_flag varchar2(2);
163: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
164: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
165: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
166: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
167: l_pa_request_id number;

Line 164: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;

160: l_mass_salary_id number;
161: l_user_table_id number;
162: l_submit_flag varchar2(2);
163: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
164: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
165: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
166: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
167: l_pa_request_id number;
168: l_rowid varchar2(30);

Line 165: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;

161: l_user_table_id number;
162: l_submit_flag varchar2(2);
163: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
164: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
165: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
166: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
167: l_pa_request_id number;
168: l_rowid varchar2(30);
169:

Line 166: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;

162: l_submit_flag varchar2(2);
163: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
164: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
165: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
166: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
167: l_pa_request_id number;
168: l_rowid varchar2(30);
169:
170: l_p_ORGANIZATION_ID number;

Line 1036: update ghr_mass_salaries

1032:
1033: IF (l_recs_failed = 0) then
1034: IF upper(p_action) = 'CREATE' THEN
1035: begin
1036: update ghr_mass_salaries
1037: set submit_flag = 'P'
1038: where rowid = l_rowid;
1039: EXCEPTION
1040: when others then

Line 1056: update ghr_mass_salaries

1052: --if (l_recs_failed <> 0) then
1053: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
1054: p_retcode := 2;
1055: IF upper(p_action) = 'CREATE' THEN
1056: update ghr_mass_salaries
1057: set submit_flag = 'E'
1058: where rowid = l_rowid;
1059: END IF;
1060: end if;

Line 1083: update ghr_mass_salaries

1079:
1080: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
1081: p_retcode := 2;
1082: IF upper(p_action) = 'CREATE' THEN
1083: update ghr_mass_salaries
1084: set submit_flag = 'E'
1085: where rowid = l_rowid;
1086: commit;
1087: END IF;

Line 1195: -- Cursor to select from GHR_MASS_SALARIES - Where criteria is stored

1191: 'TERMINATE APPOINTMENT', /* 126 */
1192: 'SEPARATED'); /* 132 */
1193:
1194: --
1195: -- Cursor to select from GHR_MASS_SALARIES - Where criteria is stored
1196: -- Before executing this package
1197: -- from ghr_mass_salary_criteria
1198:
1199: cursor ghr_msl (p_msl_id number) is

Line 1205: from ghr_mass_salaries

1201: executive_order_number, executive_order_date, ROWID, PA_REQUEST_ID,
1202: ORGANIZATION_ID, DUTY_STATION_ID, PERSONNEL_OFFICE_ID,
1203: AGENCY_CODE_SUBELEMENT, OPM_ISSUANCE_NUMBER, OPM_ISSUANCE_DATE, PROCESS_TYPE,
1204: locality_pay_area_code
1205: from ghr_mass_salaries
1206: where MASS_SALARY_ID = p_msl_id
1207: for update of user_table_id nowait;
1208:
1209: ---Fetch Noa_family_code ---800 (CHG_DATA_ELEMENT) , 894 (GHR_SAL_PAY_ADJ)

Line 1340: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;

1336:
1337: l_mass_salary_id number;
1338: l_user_table_id number;
1339: l_submit_flag varchar2(2);
1340: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
1341: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
1342: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
1343: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
1344: l_pa_request_id number;

Line 1341: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;

1337: l_mass_salary_id number;
1338: l_user_table_id number;
1339: l_submit_flag varchar2(2);
1340: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
1341: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
1342: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
1343: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
1344: l_pa_request_id number;
1345: l_rowid varchar2(30);

Line 1342: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;

1338: l_user_table_id number;
1339: l_submit_flag varchar2(2);
1340: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
1341: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
1342: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
1343: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
1344: l_pa_request_id number;
1345: l_rowid varchar2(30);
1346:

Line 1343: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;

1339: l_submit_flag varchar2(2);
1340: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
1341: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
1342: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
1343: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
1344: l_pa_request_id number;
1345: l_rowid varchar2(30);
1346:
1347: l_p_ORGANIZATION_ID number;

Line 1372: l_p_locality_area_code ghr_mass_salaries.locality_pay_area_code%type;

1368:
1369: l_remark_code1 varchar2(30);
1370: l_remark_code2 varchar2(30);
1371: l_p_AGENCY_CODE_SUBELEMENT varchar2(30);
1372: l_p_locality_area_code ghr_mass_salaries.locality_pay_area_code%type;
1373:
1374: ----Pay cap variables
1375: l_entitled_other_pay NUMBER;
1376: l_capped_other_pay NUMBER;

Line 2627: update ghr_mass_salaries

2623:
2624: if (l_recs_failed = 0) then
2625: IF upper(p_action) = 'CREATE' THEN
2626: begin
2627: update ghr_mass_salaries
2628: set submit_flag = 'P'
2629: where rowid = l_rowid;
2630: EXCEPTION
2631: when others then

Line 2641: update ghr_mass_salaries

2637: ELSE
2638: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
2639: p_retcode := 2;
2640: IF upper(p_action) = 'CREATE' THEN
2641: update ghr_mass_salaries
2642: set submit_flag = 'E'
2643: where rowid = l_rowid;
2644: END IF;
2645: end if;

Line 2665: update ghr_mass_salaries

2661:
2662: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
2663: p_retcode := 2;
2664: IF upper(p_action) = 'CREATE' THEN
2665: update ghr_mass_salaries
2666: set submit_flag = 'E'
2667: where rowid = l_rowid;
2668: commit;
2669: END IF;