DBA Data[Home] [Help]

APPS.PER_SALADMIN_ANALYTICS_PKG dependencies on PER_SALADMIN_ANALYTICS_PKG

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 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 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 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 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 157: END PER_SALADMIN_ANALYTICS_PKG;

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