PACKAGE: APPS.IEX_UWQ_POP_SUM_TBL_PVT

Source

1 PACKAGE IEX_UWQ_POP_SUM_TBL_PVT as
2 /* $Header: iexvuwps.pls 120.0.12010000.2 2008/08/06 09:05:31 schekuri ship $ */
3 
4 
5 /*-------------------------------------------------------------------------*
6  |                             PUBLIC CONSTANTS
7  *-------------------------------------------------------------------------*/
8 
9 /*-------------------------------------------------------------------------*
10  |                             PUBLIC DATATYPES
11  *-------------------------------------------------------------------------*/
12 
13 /*-------------------------------------------------------------------------*
14  |                             PUBLIC VARIABLES
15  *-------------------------------------------------------------------------*/
16 
17 /*-------------------------------------------------------------------------*
18  |                             PUBLIC ROUTINES
19  *-------------------------------------------------------------------------*/
20 
21 PROCEDURE populate_uwq_sum_concur(
22                     x_errbuf            OUT nocopy VARCHAR2,
23                     x_retcode           OUT nocopy VARCHAR2,
24                     FROM_DATE           IN  VARCHAR2);
25 
26 PROCEDURE Insert_Summary(
27                     x_errbuf            OUT nocopy VARCHAR2,
28                     x_retcode           OUT nocopy VARCHAR2,
29                     FROM_DATE           IN  VARCHAR2,
30 		    P_MODE              IN  VARCHAR2 DEFAULT 'CP');
31 PROCEDURE refresh_summary_incr(
32                     x_errbuf            OUT nocopy VARCHAR2,
33                     x_retcode           OUT nocopy VARCHAR2,
34                     FROM_DATE           IN  VARCHAR2,
35  	            P_MODE              IN  VARCHAR2 DEFAULT 'CP');
36 locked_by_another_session   EXCEPTION ;
37 PRAGMA EXCEPTION_INIT(locked_by_another_session,-54) ;
38 deadlock_detected EXCEPTION;
39 PRAGMA EXCEPTION_INIT(deadlock_detected, -60);
40 END;