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_SALADMIN_ANALYTICS_PKG dependencies on PER_SALADMIN_ANALYTICS

Line 1: PACKAGE BODY PER_SALADMIN_ANALYTICS_PKG as

1: PACKAGE BODY PER_SALADMIN_ANALYTICS_PKG as
2: /* $Header: pesalanl.pkb 120.3 2012/01/04 11:27:06 bmaheshw noship $ */
3: Function check_refresh_jobs
4: RETURN Number
5: IS

Line 8: SELECT 1 INTO l_check FROM PER_SALADMIN_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_SALADMIN_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_SALADMIN_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_SALADMIN_ANALYTICS (JOB_ID,PAY_BASIS_ID) VALUES (-2,-2);
20: commit;
21: END insert_refresh_jobs;
22:
23:

Line 28: delete from PER_SALADMIN_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_SALADMIN_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_SALADMIN_ANALYTICS_PROC(ERRBUF OUT NOCOPY varchar2,

Line 32: procedure PER_SALADMIN_ANALYTICS_PROC(ERRBUF OUT NOCOPY varchar2,

28: delete from PER_SALADMIN_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_SALADMIN_ANALYTICS_PROC(ERRBUF OUT NOCOPY varchar2,
33: RETCODE OUT NOCOPY number
34: )
35: IS
36: TYPE Sal_Analytics_Bulk_Collect IS TABLE OF PER_SALADMIN_ANALYTICS%ROWTYPE;

Line 36: TYPE Sal_Analytics_Bulk_Collect IS TABLE OF PER_SALADMIN_ANALYTICS%ROWTYPE;

32: procedure PER_SALADMIN_ANALYTICS_PROC(ERRBUF OUT NOCOPY varchar2,
33: RETCODE OUT NOCOPY number
34: )
35: IS
36: TYPE Sal_Analytics_Bulk_Collect IS TABLE OF PER_SALADMIN_ANALYTICS%ROWTYPE;
37: l_check_var NUMBER;
38: table_name_var VARCHAR2(300);
39: PSA Sal_Analytics_Bulk_Collect;
40: CURSOR SALANALYTICS IS SELECT /*+ LEADING(SAL.DAY) */ SAL.EFFECTIVE_START_DATE EFFECTIVE_START_DATE ,CASE WHEN SAL.EFFECTIVE_START_DATE = TRUNC(SYSDATE) THEN HR_GENERAL.END_OF_TIME ELSE SAL.EFFECTIVE_END_DATE END EFFECTIVE_END_DATE

Line 88: l_check_var := PER_SALADMIN_ANALYTICS_PKG.check_refresh_jobs;

84: GROUP BY SAL.EFFECTIVE_START_DATE ,SAL.EFFECTIVE_END_DATE ,SAL.JOB_ID ,SAL.COUNTRY ,SAL.PAY_BASIS_ID ,SAL.CURRENCY_CODE;
85:
86: BEGIN
87:
88: l_check_var := PER_SALADMIN_ANALYTICS_PKG.check_refresh_jobs;
89:
90: if fnd_global.conc_request_id = -1 and l_check_var = 1 then
91: fnd_message.set_name('PER', 'PER_SAL_ANALYTICS_REFRESH_RUNG');
92: fnd_message.raise_error;

Line 100: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('ENTERING PER_SALADMIN_ANALYTICS_PROC',10);

96:
97:
98: SELECT FND_GLOBAL.CONC_REQUEST_ID INTO Conc_Prog_Id FROM DUAL;
99:
100: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('ENTERING PER_SALADMIN_ANALYTICS_PROC',10);
101:
102: select s.table_owner||'.'||nvl(ev.table_name, s.table_name) table_name into table_name_var
103: from user_synonyms s, dba_editioning_views ev
104: where synonym_name = 'PER_SALADMIN_ANALYTICS'

Line 104: where synonym_name = 'PER_SALADMIN_ANALYTICS'

100: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('ENTERING PER_SALADMIN_ANALYTICS_PROC',10);
101:
102: select s.table_owner||'.'||nvl(ev.table_name, s.table_name) table_name into table_name_var
103: from user_synonyms s, dba_editioning_views ev
104: where synonym_name = 'PER_SALADMIN_ANALYTICS'
105: and ev.owner(+) = s.table_owner
106: and ev.view_name(+) = s.table_name;
107:
108: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||trim(table_name_var);

Line 110: PER_SALADMIN_ANALYTICS_PKG.insert_refresh_jobs;

106: and ev.view_name(+) = s.table_name;
107:
108: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||trim(table_name_var);
109:
110: PER_SALADMIN_ANALYTICS_PKG.insert_refresh_jobs;
111:
112: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('TRUNCATED TABLE PER_SALADMIN_ANALYTICS TABLE',20);
113:
114: OPEN SALANALYTICS;

Line 112: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('TRUNCATED TABLE PER_SALADMIN_ANALYTICS TABLE',20);

108: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||trim(table_name_var);
109:
110: PER_SALADMIN_ANALYTICS_PKG.insert_refresh_jobs;
111:
112: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('TRUNCATED TABLE PER_SALADMIN_ANALYTICS TABLE',20);
113:
114: OPEN SALANALYTICS;
115:
116: LOOP

Line 121: INSERT INTO PER_SALADMIN_ANALYTICS VALUES PSA(i);

117:
118: FETCH SALANALYTICS BULK COLLECT INTO PSA LIMIT 2000;
119:
120: FORALL i IN 1..PSA.COUNT
121: INSERT INTO PER_SALADMIN_ANALYTICS VALUES PSA(i);
122: --INSERT INTO SALANALYTICS (EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,JOB_IDCOUNTRY,PAY_BASIS_ID,TOTAL_HEADCOUNT,MED_ANL_SLRY,ANL_SLRY_CURRENCY,COMPARATIO,RANGE_POSITION,QUARTILE)
123: -- VALUES(PSA.EFFECTIVE_START_DATE,PSA.EFFECTIVE_END_DATE,PSA.JOB_IDCOUNTRY,PSA.PAY_BASIS_ID,PSA.TOTAL_HEADCOUNT,PSA.MED_ANL_SLRY,PSA.ANL_SLRY_CURRENCY,PSA.COMPARATIO,PSA.RANGE_POSITION,PSA.QUARTILE);
124: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('INSERTED '||SQL%ROWCOUNT|| ' Rows in to PER_SALADMIN_ANALYTICS TABLE',50);
125: EXIT WHEN SALANALYTICS%NOTFOUND;

Line 124: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('INSERTED '||SQL%ROWCOUNT|| ' Rows in to PER_SALADMIN_ANALYTICS TABLE',50);

120: FORALL i IN 1..PSA.COUNT
121: INSERT INTO PER_SALADMIN_ANALYTICS VALUES PSA(i);
122: --INSERT INTO SALANALYTICS (EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,JOB_IDCOUNTRY,PAY_BASIS_ID,TOTAL_HEADCOUNT,MED_ANL_SLRY,ANL_SLRY_CURRENCY,COMPARATIO,RANGE_POSITION,QUARTILE)
123: -- VALUES(PSA.EFFECTIVE_START_DATE,PSA.EFFECTIVE_END_DATE,PSA.JOB_IDCOUNTRY,PSA.PAY_BASIS_ID,PSA.TOTAL_HEADCOUNT,PSA.MED_ANL_SLRY,PSA.ANL_SLRY_CURRENCY,PSA.COMPARATIO,PSA.RANGE_POSITION,PSA.QUARTILE);
124: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('INSERTED '||SQL%ROWCOUNT|| ' Rows in to PER_SALADMIN_ANALYTICS TABLE',50);
125: EXIT WHEN SALANALYTICS%NOTFOUND;
126: COMMIT;
127: END LOOP;
128: COMMIT;

Line 131: PER_SALADMIN_ANALYTICS_PKG.delete_refresh_jobs;

127: END LOOP;
128: COMMIT;
129: CLOSE SALANALYTICS;
130:
131: PER_SALADMIN_ANALYTICS_PKG.delete_refresh_jobs;
132:
133: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('GATHERING STATISTICS FOR PER_SALADMIN_ANALYTICS',80);
134: FND_STATS.GATHER_TABLE_STATS('HR','PER_SALADMIN_ANALYTICS');
135: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('LEAVING PER_SALADMIN_ANALYTICS_PROC',100);

Line 133: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('GATHERING STATISTICS FOR PER_SALADMIN_ANALYTICS',80);

129: CLOSE SALANALYTICS;
130:
131: PER_SALADMIN_ANALYTICS_PKG.delete_refresh_jobs;
132:
133: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('GATHERING STATISTICS FOR PER_SALADMIN_ANALYTICS',80);
134: FND_STATS.GATHER_TABLE_STATS('HR','PER_SALADMIN_ANALYTICS');
135: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('LEAVING PER_SALADMIN_ANALYTICS_PROC',100);
136: EXCEPTION WHEN OTHERS THEN
137: errbuf := errbuf||SQLERRM;

Line 134: FND_STATS.GATHER_TABLE_STATS('HR','PER_SALADMIN_ANALYTICS');

130:
131: PER_SALADMIN_ANALYTICS_PKG.delete_refresh_jobs;
132:
133: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('GATHERING STATISTICS FOR PER_SALADMIN_ANALYTICS',80);
134: FND_STATS.GATHER_TABLE_STATS('HR','PER_SALADMIN_ANALYTICS');
135: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('LEAVING PER_SALADMIN_ANALYTICS_PROC',100);
136: EXCEPTION WHEN OTHERS THEN
137: errbuf := errbuf||SQLERRM;
138: retcode := '1';

Line 135: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('LEAVING PER_SALADMIN_ANALYTICS_PROC',100);

131: PER_SALADMIN_ANALYTICS_PKG.delete_refresh_jobs;
132:
133: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('GATHERING STATISTICS FOR PER_SALADMIN_ANALYTICS',80);
134: FND_STATS.GATHER_TABLE_STATS('HR','PER_SALADMIN_ANALYTICS');
135: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('LEAVING PER_SALADMIN_ANALYTICS_PROC',100);
136: EXCEPTION WHEN OTHERS THEN
137: errbuf := errbuf||SQLERRM;
138: retcode := '1';
139: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('Error in PER_SALADMIN_ANALYTICS_PROC: '||SQLCODE,0);

Line 139: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('Error in PER_SALADMIN_ANALYTICS_PROC: '||SQLCODE,0);

135: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('LEAVING PER_SALADMIN_ANALYTICS_PROC',100);
136: EXCEPTION WHEN OTHERS THEN
137: errbuf := errbuf||SQLERRM;
138: retcode := '1';
139: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('Error in PER_SALADMIN_ANALYTICS_PROC: '||SQLCODE,0);
140: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC(1,0);
141: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('Error Msg: '||substr(SQLERRM,1,700),0);
142:
143:

Line 140: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC(1,0);

136: EXCEPTION WHEN OTHERS THEN
137: errbuf := errbuf||SQLERRM;
138: retcode := '1';
139: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('Error in PER_SALADMIN_ANALYTICS_PROC: '||SQLCODE,0);
140: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC(1,0);
141: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('Error Msg: '||substr(SQLERRM,1,700),0);
142:
143:
144: END PER_SALADMIN_ANALYTICS_PROC;

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

137: errbuf := errbuf||SQLERRM;
138: retcode := '1';
139: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('Error in PER_SALADMIN_ANALYTICS_PROC: '||SQLCODE,0);
140: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC(1,0);
141: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('Error Msg: '||substr(SQLERRM,1,700),0);
142:
143:
144: END PER_SALADMIN_ANALYTICS_PROC;
145:

Line 144: END PER_SALADMIN_ANALYTICS_PROC;

140: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC(1,0);
141: PER_SALADMIN_ANALYTICS_PKG.MESSAGE_LOG_PROC('Error Msg: '||substr(SQLERRM,1,700),0);
142:
143:
144: END PER_SALADMIN_ANALYTICS_PROC;
145:
146: PROCEDURE MESSAGE_LOG_PROC(MESSAGE IN VARCHAR2,STAGE NUMBER)
147: IS
148: BEGIN

Line 157: END PER_SALADMIN_ANALYTICS_PKG;

153: END IF;
154:
155: END MESSAGE_LOG_PROC;
156:
157: END PER_SALADMIN_ANALYTICS_PKG;
158: