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 77: FROM ghr_mass_salaries

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

Line 165: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;

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

Line 166: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;

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

Line 167: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;

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

Line 168: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;

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

Line 1056: update ghr_mass_salaries

1052:
1053: IF (l_recs_failed = 0) then
1054: IF upper(p_action) = 'CREATE' THEN
1055: begin
1056: update ghr_mass_salaries
1057: set submit_flag = 'P'
1058: where rowid = l_rowid;
1059: EXCEPTION
1060: when others then

Line 1076: update ghr_mass_salaries

1072: --if (l_recs_failed <> 0) then
1073: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
1074: p_retcode := 2;
1075: IF upper(p_action) = 'CREATE' THEN
1076: update ghr_mass_salaries
1077: set submit_flag = 'E'
1078: where rowid = l_rowid;
1079: END IF;
1080: end if;

Line 1103: update ghr_mass_salaries

1099:
1100: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
1101: p_retcode := 2;
1102: IF upper(p_action) = 'CREATE' THEN
1103: update ghr_mass_salaries
1104: set submit_flag = 'E'
1105: where rowid = l_rowid;
1106: commit;
1107: END IF;

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

1215: 'TERMINATE APPOINTMENT', /* 126 */
1216: 'SEPARATED'); /* 132 */
1217:
1218: --
1219: -- Cursor to select from GHR_MASS_SALARIES - Where criteria is stored
1220: -- Before executing this package
1221: -- from ghr_mass_salary_criteria
1222:
1223: cursor ghr_msl (p_msl_id number) is

Line 1229: from ghr_mass_salaries

1225: executive_order_number, executive_order_date, ROWID, PA_REQUEST_ID,
1226: ORGANIZATION_ID, DUTY_STATION_ID, PERSONNEL_OFFICE_ID,
1227: AGENCY_CODE_SUBELEMENT, OPM_ISSUANCE_NUMBER, OPM_ISSUANCE_DATE, PROCESS_TYPE,
1228: locality_pay_area_code
1229: from ghr_mass_salaries
1230: where MASS_SALARY_ID = p_msl_id
1231: for update of user_table_id nowait;
1232:
1233: ---Fetch Noa_family_code ---800 (CHG_DATA_ELEMENT) , 894 (GHR_SAL_PAY_ADJ)

Line 1366: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;

1362:
1363: l_mass_salary_id number;
1364: l_user_table_id number;
1365: l_submit_flag varchar2(2);
1366: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
1367: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
1368: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
1369: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
1370: l_pa_request_id number;

Line 1367: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;

1363: l_mass_salary_id number;
1364: l_user_table_id number;
1365: l_submit_flag varchar2(2);
1366: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
1367: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
1368: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
1369: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
1370: l_pa_request_id number;
1371: l_rowid varchar2(30);

Line 1368: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;

1364: l_user_table_id number;
1365: l_submit_flag varchar2(2);
1366: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
1367: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
1368: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
1369: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
1370: l_pa_request_id number;
1371: l_rowid varchar2(30);
1372:

Line 1369: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;

1365: l_submit_flag varchar2(2);
1366: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
1367: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
1368: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
1369: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
1370: l_pa_request_id number;
1371: l_rowid varchar2(30);
1372:
1373: l_p_ORGANIZATION_ID number;

Line 1398: l_p_locality_area_code ghr_mass_salaries.locality_pay_area_code%type;

1394:
1395: l_remark_code1 varchar2(30);
1396: l_remark_code2 varchar2(30);
1397: l_p_AGENCY_CODE_SUBELEMENT varchar2(30);
1398: l_p_locality_area_code ghr_mass_salaries.locality_pay_area_code%type;
1399:
1400: ----Pay cap variables
1401: l_entitled_other_pay NUMBER;
1402: l_capped_other_pay NUMBER;

Line 2669: update ghr_mass_salaries

2665:
2666: if (l_recs_failed = 0) then
2667: IF upper(p_action) = 'CREATE' THEN
2668: begin
2669: update ghr_mass_salaries
2670: set submit_flag = 'P'
2671: where rowid = l_rowid;
2672: EXCEPTION
2673: when others then

Line 2683: update ghr_mass_salaries

2679: ELSE
2680: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
2681: p_retcode := 2;
2682: IF upper(p_action) = 'CREATE' THEN
2683: update ghr_mass_salaries
2684: set submit_flag = 'E'
2685: where rowid = l_rowid;
2686: END IF;
2687: end if;

Line 2707: update ghr_mass_salaries

2703:
2704: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
2705: p_retcode := 2;
2706: IF upper(p_action) = 'CREATE' THEN
2707: update ghr_mass_salaries
2708: set submit_flag = 'E'
2709: where rowid = l_rowid;
2710: commit;
2711: END IF;