1 package PER_SALADMIN_ANALYTICS_PKG AUTHID CURRENT_USER as
2 /* $Header: pesalanl.pkh 120.1 2012/01/04 07:44:53 bmaheshw noship $ */
3 Conc_Prog_Id NUMBER;
4 -- procedure to replace the MV HR_MBS_WRKFC_JCX_MV to a table PER_SALADMIN_ANALYTICS for 12.2 rel
5 procedure PER_SALADMIN_ANALYTICS_PROC (ERRBUF OUT NOCOPY varchar2,
6 RETCODE OUT NOCOPY number
7 );
8 -- procedure to log the messages to fnd_file or hr_utility
9 procedure MESSAGE_LOG_PROC (MESSAGE IN Varchar2,STAGE IN NUMBER);
10 -- Function to check whether the PER_SALADMIN_ANALYTICS table is currently getting populated
11 Function check_refresh_jobs return number;
12 --Procedure to insert the marker row into PER_SALADMIN_ANALYTICS while the table is
13 -- getting populated
14 procedure insert_refresh_jobs;
15 --Procedure to delete the marker row from PER_SALADMIN_ANALYTICS when the table is
16 --populated
17 procedure delete_refresh_jobs;
18 end PER_SALADMIN_ANALYTICS_PKG;