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 170: -- Cursor to select from GHR_MASS_SALARIES - Where criteria is stored

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

Line 180: from ghr_mass_salaries

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

Line 278: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;

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

Line 279: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;

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

Line 280: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;

276: l_user_table_id number;
277: l_submit_flag varchar2(2);
278: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
279: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
280: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
281: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
282: l_pa_request_id number;
283: l_rowid varchar2(30);
284:

Line 281: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;

277: l_submit_flag varchar2(2);
278: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
279: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
280: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
281: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
282: l_pa_request_id number;
283: l_rowid varchar2(30);
284:
285: l_p_ORGANIZATION_ID number;

Line 356: l_process_type ghr_mass_salaries.process_type%TYPE;

352:
353: rec_pp_prd pp_prd;
354: l_index NUMBER:=1;
355: l_cnt NUMBER;
356: l_process_type ghr_mass_salaries.process_type%TYPE;
357: --
358: --
359: -- Local procedure msl_process
360: --

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

1326: hr_utility.raise_error;
1327: --
1328: when others then
1329: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
1330: -- raise_application_error(-20111,'Error while selecting from Ghr Mass Salaries');
1331: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
1332: raise msl_error;
1333: END;
1334: --Bug#5063304 Moved this cursor from execute_msl to this place.

Line 1650: UPDATE ghr_mass_salaries

1646: l_recs_failed := l_recs_failed + g_rg_recs_failed;
1647: IF (l_recs_failed = 0) THEN
1648: IF UPPER(p_action) = 'CREATE' THEN
1649: BEGIN
1650: UPDATE ghr_mass_salaries
1651: SET submit_flag = 'P'
1652: WHERE rowid = l_rowid;
1653: EXCEPTION
1654: WHEN others THEN

Line 1664: UPDATE ghr_mass_salaries

1660: ELSE
1661: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
1662: p_retcode := 2;
1663: IF upper(p_action) = 'CREATE' THEN
1664: UPDATE ghr_mass_salaries
1665: SET submit_flag = 'E'
1666: WHERE rowid = l_rowid;
1667: END IF;
1668: END IF;

Line 1692: UPDATE ghr_mass_salaries

1688:
1689: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
1690: p_retcode := 2;
1691: IF upper(p_action) = 'CREATE' THEN
1692: UPDATE ghr_mass_salaries
1693: SET submit_flag = 'E'
1694: WHERE rowid = l_rowid;
1695: COMMIT;
1696: END IF;

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

5071: 'TERMINATE APPOINTMENT', /* 126 */
5072: 'SEPARATED'); /* 132 */
5073:
5074: --
5075: -- Cursor to select from GHR_MASS_SALARIES - Where criteria is stored
5076: -- Before executing this package
5077: -- from ghr_mass_salary_criteria
5078:
5079: cursor ghr_msl (p_msl_id number) is

Line 5084: from ghr_mass_salaries

5080: select name, effective_date, mass_salary_id, user_table_id, submit_flag,
5081: executive_order_number, executive_order_date, ROWID, PA_REQUEST_ID,
5082: ORGANIZATION_ID, DUTY_STATION_ID, PERSONNEL_OFFICE_ID,
5083: AGENCY_CODE_SUBELEMENT, OPM_ISSUANCE_NUMBER, OPM_ISSUANCE_DATE, PROCESS_TYPE
5084: from ghr_mass_salaries
5085: where MASS_SALARY_ID = p_msl_id
5086: for update of user_table_id nowait;
5087:
5088: -- VSM [family name was hardcoded previously to SALARY_CHG. Fetching it from DB now]

Line 5173: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;

5169:
5170: l_mass_salary_id number;
5171: l_user_table_id number;
5172: l_submit_flag varchar2(2);
5173: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
5174: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
5175: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
5176: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
5177: l_pa_request_id number;

Line 5174: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;

5170: l_mass_salary_id number;
5171: l_user_table_id number;
5172: l_submit_flag varchar2(2);
5173: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
5174: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
5175: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
5176: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
5177: l_pa_request_id number;
5178: l_rowid varchar2(30);

Line 5175: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;

5171: l_user_table_id number;
5172: l_submit_flag varchar2(2);
5173: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
5174: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
5175: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
5176: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
5177: l_pa_request_id number;
5178: l_rowid varchar2(30);
5179:

Line 5176: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;

5172: l_submit_flag varchar2(2);
5173: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
5174: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
5175: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
5176: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
5177: l_pa_request_id number;
5178: l_rowid varchar2(30);
5179:
5180: l_p_ORGANIZATION_ID number;

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

6335: hr_utility.raise_error;
6336: --
6337: when others then
6338: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
6339: -- raise_application_error(-20111,'Error while selecting from Ghr Mass Salaries');
6340: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
6341: raise msl_error;
6342: END;
6343:

Line 6631: update ghr_mass_salaries

6627: */
6628: if (l_recs_failed = 0) then
6629: IF upper(p_action) = 'CREATE' THEN
6630: begin
6631: update ghr_mass_salaries
6632: set submit_flag = 'P'
6633: where rowid = l_rowid;
6634: EXCEPTION
6635: when others then

Line 6651: update ghr_mass_salaries

6647: --if (l_recs_failed <> 0) then
6648: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
6649: p_retcode := 2;
6650: IF upper(p_action) = 'CREATE' THEN
6651: update ghr_mass_salaries
6652: set submit_flag = 'E'
6653: where rowid = l_rowid;
6654: END IF;
6655: end if;

Line 6678: update ghr_mass_salaries

6674:
6675: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
6676: p_retcode := 2;
6677: IF upper(p_action) = 'CREATE' THEN
6678: update ghr_mass_salaries
6679: set submit_flag = 'E'
6680: where rowid = l_rowid;
6681: commit;
6682: END IF;

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

7207: 'TERMINATE APPOINTMENT', /* 126 */
7208: 'SEPARATED'); /* 132 */
7209:
7210: --
7211: -- Cursor to select from GHR_MASS_SALARIES - Where criteria is stored
7212: -- Before executing this package
7213: -- from ghr_mass_salary_criteria
7214:
7215: cursor ghr_msl (p_msl_id number) is

Line 7220: from ghr_mass_salaries

7216: select name, effective_date, mass_salary_id, user_table_id, submit_flag,
7217: executive_order_number, executive_order_date, ROWID, PA_REQUEST_ID,
7218: ORGANIZATION_ID, DUTY_STATION_ID, PERSONNEL_OFFICE_ID,
7219: AGENCY_CODE_SUBELEMENT, OPM_ISSUANCE_NUMBER, OPM_ISSUANCE_DATE, PROCESS_TYPE
7220: from ghr_mass_salaries
7221: where MASS_SALARY_ID = p_msl_id
7222: for update of user_table_id nowait;
7223:
7224: -- VSM [family name was hardcoded previously to SALARY_CHG. Fetching it from DB now]

Line 7314: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;

7310: l_mass_salary_id number;
7311: l_user_table_id number;
7312: l_submit_flag varchar2(2);
7313:
7314: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
7315: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
7316: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
7317: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
7318: l_pa_request_id number;

Line 7315: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;

7311: l_user_table_id number;
7312: l_submit_flag varchar2(2);
7313:
7314: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
7315: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
7316: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
7317: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
7318: l_pa_request_id number;
7319: l_rowid varchar2(30);

Line 7316: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;

7312: l_submit_flag varchar2(2);
7313:
7314: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
7315: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
7316: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
7317: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
7318: l_pa_request_id number;
7319: l_rowid varchar2(30);
7320:

Line 7317: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;

7313:
7314: l_executive_order_number ghr_mass_salaries.executive_order_number%TYPE;
7315: l_executive_order_date ghr_mass_salaries.executive_order_date%TYPE;
7316: l_opm_issuance_number ghr_mass_salaries.opm_issuance_number%TYPE;
7317: l_opm_issuance_date ghr_mass_salaries.opm_issuance_date%TYPE;
7318: l_pa_request_id number;
7319: l_rowid varchar2(30);
7320:
7321: l_p_ORGANIZATION_ID number;

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

8351: hr_utility.raise_error;
8352: --
8353: when others then
8354: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
8355: -- raise_application_error(-20111,'Error while selecting from Ghr Mass Salaries');
8356: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
8357: raise msl_error;
8358: END;
8359:

Line 8666: update ghr_mass_salaries

8662: */
8663: if (l_recs_failed = 0) then
8664: IF upper(p_action) = 'CREATE' THEN
8665: begin
8666: update ghr_mass_salaries
8667: set submit_flag = 'P'
8668: where rowid = l_rowid;
8669: EXCEPTION
8670: when others then

Line 8686: update ghr_mass_salaries

8682: --if (l_recs_failed <> 0) then
8683: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
8684: p_retcode := 2;
8685: IF upper(p_action) = 'CREATE' THEN
8686: update ghr_mass_salaries
8687: set submit_flag = 'E'
8688: where rowid = l_rowid;
8689: END IF;
8690: end if;

Line 8713: update ghr_mass_salaries

8709:
8710: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
8711: p_retcode := 2;
8712: IF upper(p_action) = 'CREATE' THEN
8713: update ghr_mass_salaries
8714: set submit_flag = 'E'
8715: where rowid = l_rowid;
8716: commit;
8717: END IF;