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

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

162: 'TERMINATE APPOINTMENT', /* 126 */
163: 'SEPARATED'); /* 132 */
164:
165: --
166: -- Cursor to select from GHR_MASS_SALARIES - Where criteria is stored
167: -- Before executing this package
168: -- from ghr_mass_salary_criteria
169: --
170:

Line 176: from ghr_mass_salaries

172: select name, effective_date, mass_salary_id, user_table_id, submit_flag,
173: executive_order_number, executive_order_date, ROWID, PA_REQUEST_ID,
174: ORGANIZATION_ID, DUTY_STATION_ID, PERSONNEL_OFFICE_ID,
175: AGENCY_CODE_SUBELEMENT, OPM_ISSUANCE_NUMBER, OPM_ISSUANCE_DATE, PROCESS_TYPE
176: from ghr_mass_salaries
177: where MASS_SALARY_ID = p_msl_id
178: for update of user_table_id nowait;
179:
180: -- VSM [family name was hardcoded previously to SALARY_CHG. Fetching it from DB now]

Line 274: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;

270:
271: l_mass_salary_id number;
272: l_user_table_id number;
273: l_submit_flag varchar2(2);
274: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
275: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
276: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
277: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
278: l_pa_request_id number;

Line 275: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;

271: l_mass_salary_id number;
272: l_user_table_id number;
273: l_submit_flag varchar2(2);
274: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
275: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
276: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
277: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
278: l_pa_request_id number;
279: l_rowid varchar2(30);

Line 276: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;

272: l_user_table_id number;
273: l_submit_flag varchar2(2);
274: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
275: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
276: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
277: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
278: l_pa_request_id number;
279: l_rowid varchar2(30);
280:

Line 277: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;

273: l_submit_flag varchar2(2);
274: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
275: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
276: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
277: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
278: l_pa_request_id number;
279: l_rowid varchar2(30);
280:
281: l_p_ORGANIZATION_ID number;

Line 352: l_process_type ghr_mass_salaries.process_type%TYPE;

348:
349: rec_pp_prd pp_prd;
350: l_index NUMBER:=1;
351: l_cnt NUMBER;
352: l_process_type ghr_mass_salaries.process_type%TYPE;
353: --
354: --
355: -- Local procedure msl_process
356: --

Line 1314: -- raise_application_error(-20111,'Error while selecting from Ghr Mass Salaries');

1310: hr_utility.raise_error;
1311: --
1312: when others then
1313: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
1314: -- raise_application_error(-20111,'Error while selecting from Ghr Mass Salaries');
1315: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
1316: raise msl_error;
1317: END;
1318: --Bug#5063304 Moved this cursor from execute_msl to this place.

Line 1626: UPDATE ghr_mass_salaries

1622: l_recs_failed := l_recs_failed + g_rg_recs_failed;
1623: IF (l_recs_failed = 0) THEN
1624: IF UPPER(p_action) = 'CREATE' THEN
1625: BEGIN
1626: UPDATE ghr_mass_salaries
1627: SET submit_flag = 'P'
1628: WHERE rowid = l_rowid;
1629: EXCEPTION
1630: WHEN others THEN

Line 1640: UPDATE ghr_mass_salaries

1636: ELSE
1637: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
1638: p_retcode := 2;
1639: IF upper(p_action) = 'CREATE' THEN
1640: UPDATE ghr_mass_salaries
1641: SET submit_flag = 'E'
1642: WHERE rowid = l_rowid;
1643: END IF;
1644: END IF;

Line 1668: UPDATE ghr_mass_salaries

1664:
1665: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
1666: p_retcode := 2;
1667: IF upper(p_action) = 'CREATE' THEN
1668: UPDATE ghr_mass_salaries
1669: SET submit_flag = 'E'
1670: WHERE rowid = l_rowid;
1671: COMMIT;
1672: END IF;

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

5009: 'TERMINATE APPOINTMENT', /* 126 */
5010: 'SEPARATED'); /* 132 */
5011:
5012: --
5013: -- Cursor to select from GHR_MASS_SALARIES - Where criteria is stored
5014: -- Before executing this package
5015: -- from ghr_mass_salary_criteria
5016:
5017: cursor ghr_msl (p_msl_id number) is

Line 5022: from ghr_mass_salaries

5018: select name, effective_date, mass_salary_id, user_table_id, submit_flag,
5019: executive_order_number, executive_order_date, ROWID, PA_REQUEST_ID,
5020: ORGANIZATION_ID, DUTY_STATION_ID, PERSONNEL_OFFICE_ID,
5021: AGENCY_CODE_SUBELEMENT, OPM_ISSUANCE_NUMBER, OPM_ISSUANCE_DATE, PROCESS_TYPE
5022: from ghr_mass_salaries
5023: where MASS_SALARY_ID = p_msl_id
5024: for update of user_table_id nowait;
5025:
5026: -- VSM [family name was hardcoded previously to SALARY_CHG. Fetching it from DB now]

Line 5111: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;

5107:
5108: l_mass_salary_id number;
5109: l_user_table_id number;
5110: l_submit_flag varchar2(2);
5111: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
5112: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
5113: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
5114: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
5115: l_pa_request_id number;

Line 5112: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;

5108: l_mass_salary_id number;
5109: l_user_table_id number;
5110: l_submit_flag varchar2(2);
5111: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
5112: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
5113: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
5114: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
5115: l_pa_request_id number;
5116: l_rowid varchar2(30);

Line 5113: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;

5109: l_user_table_id number;
5110: l_submit_flag varchar2(2);
5111: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
5112: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
5113: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
5114: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
5115: l_pa_request_id number;
5116: l_rowid varchar2(30);
5117:

Line 5114: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;

5110: l_submit_flag varchar2(2);
5111: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
5112: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
5113: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
5114: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
5115: l_pa_request_id number;
5116: l_rowid varchar2(30);
5117:
5118: l_p_ORGANIZATION_ID number;

Line 6207: -- raise_application_error(-20111,'Error while selecting from Ghr Mass Salaries');

6203: hr_utility.raise_error;
6204: --
6205: when others then
6206: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
6207: -- raise_application_error(-20111,'Error while selecting from Ghr Mass Salaries');
6208: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
6209: raise msl_error;
6210: END;
6211:

Line 6491: update ghr_mass_salaries

6487: */
6488: if (l_recs_failed = 0) then
6489: IF upper(p_action) = 'CREATE' THEN
6490: begin
6491: update ghr_mass_salaries
6492: set submit_flag = 'P'
6493: where rowid = l_rowid;
6494: EXCEPTION
6495: when others then

Line 6511: update ghr_mass_salaries

6507: --if (l_recs_failed <> 0) then
6508: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
6509: p_retcode := 2;
6510: IF upper(p_action) = 'CREATE' THEN
6511: update ghr_mass_salaries
6512: set submit_flag = 'E'
6513: where rowid = l_rowid;
6514: END IF;
6515: end if;

Line 6538: update ghr_mass_salaries

6534:
6535: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
6536: p_retcode := 2;
6537: IF upper(p_action) = 'CREATE' THEN
6538: update ghr_mass_salaries
6539: set submit_flag = 'E'
6540: where rowid = l_rowid;
6541: commit;
6542: END IF;

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

7061: 'TERMINATE APPOINTMENT', /* 126 */
7062: 'SEPARATED'); /* 132 */
7063:
7064: --
7065: -- Cursor to select from GHR_MASS_SALARIES - Where criteria is stored
7066: -- Before executing this package
7067: -- from ghr_mass_salary_criteria
7068:
7069: cursor ghr_msl (p_msl_id number) is

Line 7074: from ghr_mass_salaries

7070: select name, effective_date, mass_salary_id, user_table_id, submit_flag,
7071: executive_order_number, executive_order_date, ROWID, PA_REQUEST_ID,
7072: ORGANIZATION_ID, DUTY_STATION_ID, PERSONNEL_OFFICE_ID,
7073: AGENCY_CODE_SUBELEMENT, OPM_ISSUANCE_NUMBER, OPM_ISSUANCE_DATE, PROCESS_TYPE
7074: from ghr_mass_salaries
7075: where MASS_SALARY_ID = p_msl_id
7076: for update of user_table_id nowait;
7077:
7078: -- VSM [family name was hardcoded previously to SALARY_CHG. Fetching it from DB now]

Line 7168: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;

7164: l_mass_salary_id number;
7165: l_user_table_id number;
7166: l_submit_flag varchar2(2);
7167:
7168: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
7169: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
7170: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
7171: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
7172: l_pa_request_id number;

Line 7169: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;

7165: l_user_table_id number;
7166: l_submit_flag varchar2(2);
7167:
7168: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
7169: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
7170: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
7171: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
7172: l_pa_request_id number;
7173: l_rowid varchar2(30);

Line 7170: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;

7166: l_submit_flag varchar2(2);
7167:
7168: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
7169: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
7170: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
7171: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
7172: l_pa_request_id number;
7173: l_rowid varchar2(30);
7174:

Line 7171: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;

7167:
7168: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
7169: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
7170: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
7171: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
7172: l_pa_request_id number;
7173: l_rowid varchar2(30);
7174:
7175: l_p_ORGANIZATION_ID number;

Line 8199: -- raise_application_error(-20111,'Error while selecting from Ghr Mass Salaries');

8195: hr_utility.raise_error;
8196: --
8197: when others then
8198: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
8199: -- raise_application_error(-20111,'Error while selecting from Ghr Mass Salaries');
8200: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
8201: raise msl_error;
8202: END;
8203:

Line 8502: update ghr_mass_salaries

8498: */
8499: if (l_recs_failed = 0) then
8500: IF upper(p_action) = 'CREATE' THEN
8501: begin
8502: update ghr_mass_salaries
8503: set submit_flag = 'P'
8504: where rowid = l_rowid;
8505: EXCEPTION
8506: when others then

Line 8522: update ghr_mass_salaries

8518: --if (l_recs_failed <> 0) then
8519: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
8520: p_retcode := 2;
8521: IF upper(p_action) = 'CREATE' THEN
8522: update ghr_mass_salaries
8523: set submit_flag = 'E'
8524: where rowid = l_rowid;
8525: END IF;
8526: end if;

Line 8549: update ghr_mass_salaries

8545:
8546: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
8547: p_retcode := 2;
8548: IF upper(p_action) = 'CREATE' THEN
8549: update ghr_mass_salaries
8550: set submit_flag = 'E'
8551: where rowid = l_rowid;
8552: commit;
8553: END IF;