PACKAGE: APPS.BIS_INDICATOR_REGION_PVT

Source

1 package BIS_INDICATOR_REGION_PVT AUTHID CURRENT_USER AS
2 /* $Header: BISVREGS.pls 115.19 2003/01/30 09:11:26 sugopal noship $ */
3 
4 TYPE User_Label_Rec_Type IS RECORD(
5   Ind_Selection_ID             NUMBER ,
6   Plug_ID                      NUMBER ,
7   User_ID                      NUMBER ,
8   Label                        VARCHAR2(30) );
9 
10 TYPE User_Label_Tbl_Type IS TABLE OF User_Label_Rec_Type
11   INDEX BY BINARY_INTEGER;
12 
13 e_InvalidEventException EXCEPTION;
14 
15 Procedure Create_User_Ind_Selection(
16         p_api_version           IN NUMBER,
17         p_Indicator_Region_Rec
18           IN BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type,
19         x_return_status	        OUT NOCOPY VARCHAR2,
20         x_error_Tbl             OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type);
21 
22 
23 Procedure Retrieve_User_Ind_Selections(
24         p_api_version           IN NUMBER,
25         p_user_id               IN NUMBER ,
26         p_user_name             IN VARCHAR2 ,
27         p_plug_id               IN NUMBER ,
28         p_all_info              IN VARCHAR2 Default FND_API.G_TRUE,
29         x_Indicator_Region_Tbl
30           OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,
31         x_return_status	        OUT NOCOPY VARCHAR2,
32         x_error_Tbl             OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type);
33 
34 
35 Procedure Retrieve_User_Ind_Selections(
36         p_api_version           IN NUMBER,
37         p_all_info              IN VARCHAR2 Default FND_API.G_TRUE,
38         p_Target_level_id       IN NUMBER,
39         x_Indicator_Region_Tbl
40           OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,
41         x_return_status	        OUT NOCOPY VARCHAR2,
42         x_error_Tbl             OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type);
43 
44 
45 Procedure Update_User_Ind_Selection(
46         p_api_version           IN NUMBER,
47         p_user_id               IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
48         p_user_name             IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
49         p_plug_id               IN NUMBER ,
50         p_Indicator_Region_Rec
51           IN BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type,
52         x_return_status	        OUT NOCOPY VARCHAR2,
53         x_error_Tbl             OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type);
54 
55 
56 Procedure Delete_User_Ind_Selections(
57         p_api_version           IN NUMBER,
58         p_user_id               IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
59         p_user_name             IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
60         p_plug_id               IN NUMBER,
61         x_return_status	        OUT NOCOPY VARCHAR2,
62         x_error_Tbl             OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type);
63 
64 Procedure Retrieve_User_Labels(
65         p_user_id             IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM,
66         p_user_name           IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR,
67         p_plug_id             IN NUMBER,
68         x_label_tbl           OUT NOCOPY BIS_INDICATOR_REGION_PVT.User_Label_Tbl_Type,
69         x_return_status	      OUT NOCOPY VARCHAR2);
70 
71 Procedure Validate_User_Ind_Selection(
72       p_api_version           IN NUMBER,
73       p_event                 IN VARCHAR2,
74       p_user_id               IN NUMBER,
75       p_Indicator_Region_Rec
76         IN BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type,
77       x_return_status	      OUT NOCOPY VARCHAR2);
78 
79 Procedure Validate_Required_Fields(
80         p_event                IN VARCHAR2,
81         p_user_id              IN NUMBER,
82         p_Indicator_Region_Rec
83           IN BIS_Indicator_Region_PUB.Indicator_Region_Rec_Type,
84         x_return_status        OUT NOCOPY VARCHAR2);
85 
86 
87 END BIS_INDICATOR_REGION_PVT;