PACKAGE: APPS.QPR_USER_PLAN_INIT_PVT

Source

1 PACKAGE QPR_USER_PLAN_INIT_PVT AS
2 /* $Header: QPRPUSRS.pls 120.0 2007/10/11 13:12:00 agbennet noship $ */
3 /*
4  * This package holds the procedures to be
5  * called when initializing the user-plan assignment
6  */
7 
8 /*
9  * This procedure would create all the initial data
10  * delegating work as necessary
11  */
12 
13 PROCEDURE Initialize
14 ( 	p_api_version           IN	     NUMBER  ,
15   	p_init_msg_list		IN	     VARCHAR2,
16 	p_commit	    	IN  	     VARCHAR2,
17         p_validation_level	IN  	     NUMBER	,
18         p_user_id               IN           NUMBER  ,
19         p_plan_id               IN           NUMBER  ,
20         p_event_id              IN           NUMBER  ,
21 	x_return_status		OUT  NOCOPY  VARCHAR2,
22 	x_msg_count		OUT  NOCOPY  NUMBER  ,
23 	x_msg_data		OUT  NOCOPY  VARCHAR2
24 );
25 
26 Procedure Validate_params
27 (
28         p_event_id              IN           NUMBER,
29         p_user_id               IN           NUMBER,
30         p_plan_id               IN           NUMBER,
31         x_return_status         OUT  NOCOPY  VARCHAR2
32 );
33 
34 Procedure Initialize_reports
35 (
36         p_user_id               IN           NUMBER,
37         p_plan_id               IN           NUMBER,
38         x_return_status         OUT  NOCOPY  VARCHAR2
39 );
40 
41 Procedure Reset_report_flags
42 (
43         p_user_id               IN            NUMBER,
44         p_plan_id               IN            NUMBER,
45         x_return_status         OUT  NOCOPY   VARCHAR2
46 );
47 
48 exc_invalid_input EXCEPTION;
49 exc_severe_error EXCEPTION;
50 
51 G_INITIALIZE_REPORTS VARCHAR2(1) := '1';
52 G_MAINTAIN_DATAMART VARCHAR2(1) := '2';
53 G_REPORT_REFRESH_FLAG VARCHAR2(1) := 'R';
54 G_YES                 VARCHAR2(1) := 'Y';
55 G_NO                 VARCHAR2(1) := 'N';
56 G_FOLDER_NAME       VARCHAR2(15) := 'oracle/apps/qpr';
57 
58 END QPR_USER_PLAN_INIT_PVT;
59