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