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

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 8: SELECT 1 INTO l_check FROM PER_CHANGE_PAY_ANALYTICS WHERE NVL(JOB_ID,-1) = -2 AND NVL(PAY_BASIS_ID,-1) = -2;

4: RETURN Number
5: IS
6: l_check number;
7: BEGIN
8: SELECT 1 INTO l_check FROM PER_CHANGE_PAY_ANALYTICS WHERE NVL(JOB_ID,-1) = -2 AND NVL(PAY_BASIS_ID,-1) = -2;
9: return l_check;
10: exception
11: when no_data_found then l_check := 0;
12: return l_check;

Line 19: INSERT INTO PER_CHANGE_PAY_ANALYTICS (JOB_ID,PAY_BASIS_ID) VALUES (-2,-2);

15: procedure insert_refresh_jobs
16: IS
17: pragma autonomous_transaction;
18: BEGIN
19: INSERT INTO PER_CHANGE_PAY_ANALYTICS (JOB_ID,PAY_BASIS_ID) VALUES (-2,-2);
20: commit;
21: END insert_refresh_jobs;
22:
23:

Line 28: delete from PER_CHANGE_PAY_ANALYTICS WHERE NVL(JOB_ID,-1) = -2 AND NVL(PAY_BASIS_ID,-1) = -2;

24: procedure delete_refresh_jobs
25: IS
26: pragma autonomous_transaction;
27: BEGIN
28: delete from PER_CHANGE_PAY_ANALYTICS WHERE NVL(JOB_ID,-1) = -2 AND NVL(PAY_BASIS_ID,-1) = -2;
29: commit;
30: END delete_refresh_jobs;
31:
32: procedure PER_CHANGE_PAY_ANALYTICS_PROC(ERRBUF OUT NOCOPY varchar2,

Line 32: procedure PER_CHANGE_PAY_ANALYTICS_PROC(ERRBUF OUT NOCOPY varchar2,

28: delete from PER_CHANGE_PAY_ANALYTICS WHERE NVL(JOB_ID,-1) = -2 AND NVL(PAY_BASIS_ID,-1) = -2;
29: commit;
30: END delete_refresh_jobs;
31:
32: procedure PER_CHANGE_PAY_ANALYTICS_PROC(ERRBUF OUT NOCOPY varchar2,
33: RETCODE OUT NOCOPY number
34: )
35: IS
36: CURSOR ASSIGNMENTSID IS

Line 51: TYPE CP_Analytics_Bulk_Collect IS TABLE OF PER_CHANGE_PAY_ANALYTICS%ROWTYPE;

47: l_check_var NUMBER;
48: table_name_var VARCHAR2(300);
49: PAYCHANGE sys_refcursor;
50:
51: TYPE CP_Analytics_Bulk_Collect IS TABLE OF PER_CHANGE_PAY_ANALYTICS%ROWTYPE;
52: PSA CP_Analytics_Bulk_Collect;
53:
54: BEGIN
55:

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 71: where synonym_name = 'PER_CHANGE_PAY_ANALYTICS'

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'
72: and ev.owner(+) = s.table_owner
73: and ev.view_name(+) = s.table_name;
74:
75: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||trim(table_name_var);

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 243: INSERT INTO PER_CHANGE_PAY_ANALYTICS VALUES PSA(i);

239:
240: FETCH PAYCHANGE BULK COLLECT INTO PSA LIMIT 2000;
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;

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 264: FND_STATS.GATHER_TABLE_STATS('HR','PER_CHANGE_PAY_ANALYTICS');

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:
268: EXCEPTION WHEN OTHERS THEN

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 275: END PER_CHANGE_PAY_ANALYTICS_PROC;

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)
278: IS
279: BEGIN

Line 289: END PER_CHANGE_PAY_ANALYTICS_PKG;

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