1 package BEN_CWB_CD_SUMMARY_PKG AUTHID CURRENT_USER as
2 /* $Header: bencwbsum.pkh 120.0.12020000.2 2012/12/06 11:08:26 sgnanama noship $ */
3 Conc_Prog_Id NUMBER;
4 procedure BEN_CWB_CD_SUMMARY_PROC (ERRBUF OUT NOCOPY varchar2,
5 RETCODE OUT NOCOPY number,
6 P_GROUP_PL_ID IN NUMBER DEFAULT NULL,
7 P_LF_EVT_OCRD_DT IN VARCHAR2 DEFAULT NULL,
8 P_PURGE IN VARCHAR2 DEFAULT NULL
9 );
10 -- procedure to log the messages to fnd_file or hr_utility
11 procedure MESSAGE_LOG_PROC (MESSAGE IN Varchar2,STAGE IN NUMBER);
12 -- Function to check whether the BEN_CWB_COMPDETAILS table is currently getting populated
13 Function check_refresh_jobs return number;
14 --Procedure to insert the marker row into BEN_CWB_COMPDETAILS while the table is
15 -- getting populated
16 procedure insert_refresh_jobs;
17 --Procedure to delete the marker row from BEN_CWB_COMPDETAILS when the table is
18 --populated
19 procedure delete_refresh_jobs;
20 end BEN_CWB_CD_SUMMARY_PKG;