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.PER_CHANGE_PAY_ANALYTICS_PKG dependencies on PER_CHANGE_PAY_ANALYTICS_PKG

Line 1: PACKAGE BODY PER_CHANGE_PAY_ANALYTICS_PKG as

1: PACKAGE BODY PER_CHANGE_PAY_ANALYTICS_PKG as
2: /* $Header: pechpanl.pkb 120.2.12020000.2 2013/03/20 20:04:12 bmaheshw ship $ */
3: Function check_refresh_jobs
4: RETURN Number
5: IS

Line 58: l_check_var := PER_CHANGE_PAY_ANALYTICS_PKG.check_refresh_jobs;

54: BEGIN
55:
56: SELECT FND_GLOBAL.CONC_REQUEST_ID INTO Conc_Prog_Id FROM DUAL;
57:
58: l_check_var := PER_CHANGE_PAY_ANALYTICS_PKG.check_refresh_jobs;
59:
60: if Conc_Prog_Id = -1 and l_check_var = 1 then
61: fnd_message.set_name('PER', 'PER_SAL_ANALYTICS_REFRESH_RUNG');
62: fnd_message.raise_error;

Line 67: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('ENTERING PER_CHANGE_PAY_ANALYTICS_PROC',10);

63: end if;
64:
65:
66:
67: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('ENTERING PER_CHANGE_PAY_ANALYTICS_PROC',10);
68:
69: select s.table_owner||'.'||nvl(ev.table_name, s.table_name) into table_name_var
70: from user_synonyms s, dba_editioning_views ev
71: where synonym_name = 'PER_CHANGE_PAY_ANALYTICS'

Line 77: PER_CHANGE_PAY_ANALYTICS_PKG.insert_refresh_jobs;

73: and ev.view_name(+) = s.table_name;
74:
75: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||trim(table_name_var);
76:
77: PER_CHANGE_PAY_ANALYTICS_PKG.insert_refresh_jobs;
78:
79: OPEN ASSIGNMENTSID;
80:
81:

Line 89: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('Looping for Assignment ID '||EMP_ASSIGNMENT_ID,20);

85:
86:
87: EXIT WHEN ASSIGNMENTSID%NOTFOUND;
88:
89: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('Looping for Assignment ID '||EMP_ASSIGNMENT_ID,20);
90:
91: OPEN PAYCHANGE FOR SELECT
92: sal.effective_start_date effective_start_date,
93: CASE WHEN sal.effective_start_date = TRUNC(sysdate) THEN hr_general.end_of_time

Line 245: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('INSERTED '||SQL%ROWCOUNT|| ' Rows in to PER_CHANGE_PAY_ANALYTICS TABLE',50);

241:
242: FORALL i IN 1..PSA.COUNT
243: INSERT INTO PER_CHANGE_PAY_ANALYTICS VALUES PSA(i);
244:
245: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('INSERTED '||SQL%ROWCOUNT|| ' Rows in to PER_CHANGE_PAY_ANALYTICS TABLE',50);
246: EXIT WHEN PAYCHANGE%NOTFOUND;
247: COMMIT;
248: END LOOP;
249: COMMIT;

Line 262: PER_CHANGE_PAY_ANALYTICS_PKG.delete_refresh_jobs;

258:
259: COMMIT;
260: CLOSE ASSIGNMENTSID;
261:
262: PER_CHANGE_PAY_ANALYTICS_PKG.delete_refresh_jobs;
263: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('GATHERING STATISTICS FOR PER_CHANGE_PAY_ANALYTICS',80);
264: FND_STATS.GATHER_TABLE_STATS('HR','PER_CHANGE_PAY_ANALYTICS');
265: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('LEAVING PER_CHANGE_PAY_ANALYTICS_PROC',100);
266:

Line 263: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('GATHERING STATISTICS FOR PER_CHANGE_PAY_ANALYTICS',80);

259: COMMIT;
260: CLOSE ASSIGNMENTSID;
261:
262: PER_CHANGE_PAY_ANALYTICS_PKG.delete_refresh_jobs;
263: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('GATHERING STATISTICS FOR PER_CHANGE_PAY_ANALYTICS',80);
264: FND_STATS.GATHER_TABLE_STATS('HR','PER_CHANGE_PAY_ANALYTICS');
265: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('LEAVING PER_CHANGE_PAY_ANALYTICS_PROC',100);
266:
267:

Line 265: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('LEAVING PER_CHANGE_PAY_ANALYTICS_PROC',100);

261:
262: PER_CHANGE_PAY_ANALYTICS_PKG.delete_refresh_jobs;
263: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('GATHERING STATISTICS FOR PER_CHANGE_PAY_ANALYTICS',80);
264: FND_STATS.GATHER_TABLE_STATS('HR','PER_CHANGE_PAY_ANALYTICS');
265: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('LEAVING PER_CHANGE_PAY_ANALYTICS_PROC',100);
266:
267:
268: EXCEPTION WHEN OTHERS THEN
269: errbuf := errbuf||SQLERRM;

Line 271: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('Error in PER_CHANGE_PAY_ANALYTICS_PROC: '||SQLCODE,0);

267:
268: EXCEPTION WHEN OTHERS THEN
269: errbuf := errbuf||SQLERRM;
270: retcode := '1';
271: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('Error in PER_CHANGE_PAY_ANALYTICS_PROC: '||SQLCODE,0);
272: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC(1,0);
273: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('Error Msg: '||substr(SQLERRM,1,700),0);
274:
275: END PER_CHANGE_PAY_ANALYTICS_PROC;

Line 272: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC(1,0);

268: EXCEPTION WHEN OTHERS THEN
269: errbuf := errbuf||SQLERRM;
270: retcode := '1';
271: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('Error in PER_CHANGE_PAY_ANALYTICS_PROC: '||SQLCODE,0);
272: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC(1,0);
273: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('Error Msg: '||substr(SQLERRM,1,700),0);
274:
275: END PER_CHANGE_PAY_ANALYTICS_PROC;
276:

Line 273: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('Error Msg: '||substr(SQLERRM,1,700),0);

269: errbuf := errbuf||SQLERRM;
270: retcode := '1';
271: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('Error in PER_CHANGE_PAY_ANALYTICS_PROC: '||SQLCODE,0);
272: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC(1,0);
273: PER_CHANGE_PAY_ANALYTICS_PKG.MESSAGE_LOG_PROC('Error Msg: '||substr(SQLERRM,1,700),0);
274:
275: END PER_CHANGE_PAY_ANALYTICS_PROC;
276:
277: PROCEDURE MESSAGE_LOG_PROC(MESSAGE IN VARCHAR2,STAGE NUMBER)

Line 289: END PER_CHANGE_PAY_ANALYTICS_PKG;

285:
286: END MESSAGE_LOG_PROC;
287:
288:
289: END PER_CHANGE_PAY_ANALYTICS_PKG;