[Home] [Help]
PACKAGE: APPS.BIS_APPLICATION_MEASURE_PVT
Source
1 PACKAGE BIS_Application_Measure_PVT AS
2 /* $Header: BISVAPMS.pls 120.0 2005/06/01 17:32:43 appldev noship $ */
3 --
4 /*
5 REM +=======================================================================+
6 REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
7 REM | All rights reserved. |
8 REM +=======================================================================+
9 REM | FILENAME |
10 REM | BISPMSES.pls |
11 REM | |
12 REM | DESCRIPTION |
13 REM | Public API for creating and managing Performance Measurements
14 REM |
15 REM | NOTES |
16 REM | |
17 REM | HISTORY |
18 REM | 28-NOV-98 irchen Creation
19 REM | 20-JAN-2003 rchandra fixed gscc warnings for Incorrect beginning
20 REM | and ending of the file
21 REM | 26-JUN-2003 rchandra added dataset_id to Application_Measure_Rec_Type|
22 REM | record for bug 3004651 |
23 REM | 29-SEP-2004 ankgoel Added WHO columns in Rec for Bug#3891748 |
24 REM | 01-JUN-2005 akoduri Modified for Bug #4397786 |
25 REM +=======================================================================+
26 */
27 --
28 -- Data Types: Records
29 --
30 TYPE Application_Measure_Rec_Type IS RECORD (
31 Application_ID NUMBER ,
32 Application_Short_Name VARCHAR2(30) ,
33 Application_Name VARCHAR2(80) ,
34 Measure_ID NUMBER ,
35 Measure_Short_Name VARCHAR2(30) ,
36 Measure_Name VARCHAR2(100) ,
37 Owning_Application VARCHAR2(1) ,
38 Dataset_ID bis_indicators.dataset_id%TYPE
39 -- ankgoel: bug#3891748
40 , Created_By BIS_APPLICATION_MEASURES.CREATED_BY%TYPE
41 , Creation_Date BIS_APPLICATION_MEASURES.CREATION_DATE%TYPE
42 , Last_Updated_By BIS_APPLICATION_MEASURES.LAST_UPDATED_BY%TYPE
43 , Last_Update_Date BIS_APPLICATION_MEASURES.LAST_UPDATE_DATE%TYPE
44 , Last_Update_Login BIS_APPLICATION_MEASURES.LAST_UPDATE_LOGIN%TYPE
45 );
46
47 -- Data Types: Tables
48
49 TYPE Application_Measure_Tbl_Type is TABLE of Application_Measure_Rec_Type
50 INDEX BY BINARY_INTEGER;
51
52 -- Global Missing Composite Types
53
54 G_MISS_MEAS_SECURITY_REC Application_Measure_Rec_Type;
55 G_MISS_MEAS_SECURITY_TBL Application_Measure_Tbl_Type;
56
57 -- PROCEDUREs
58
59 --
60 -- creates one Measure, with the dimensions sequenced in the order
61 --
62 PROCEDURE Create_Application_Measure
63 ( p_api_version IN NUMBER
64 , p_commit IN VARCHAR2 := FND_API.G_FALSE
65 , p_Application_Measure_Rec IN
66 BIS_Application_Measure_PVT.Application_Measure_Rec_Type
67 , x_return_status OUT NOCOPY VARCHAR2
68 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
69 );
70 --
71 -- creates one Measure for the given owner,
72 --
73 PROCEDURE Create_Application_Measure
74 ( p_api_version IN NUMBER
75 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
76 , p_Application_Measure_Rec IN
77 BIS_Application_Measure_PVT.Application_Measure_Rec_Type
78 , p_owner IN VARCHAR2
79 , x_return_status OUT NOCOPY VARCHAR2
80 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
81 );
82 --
83 --
84 PROCEDURE Retrieve_Application_Measures
85 ( p_api_version IN NUMBER
86 , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
87 , p_all_info IN VARCHAR2
88 , x_Application_Measure_tbl OUT NOCOPY
89 BIS_Application_Measure_PVT.Application_Measure_Tbl_Type
90 , x_return_status OUT NOCOPY VARCHAR2
91 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
92 );
93 --
94 --
95 PROCEDURE Update_Application_Measure
96 ( p_api_version IN NUMBER
97 , p_commit IN VARCHAR2 := FND_API.G_FALSE
98 , p_Application_Measure_Rec IN
99 BIS_Application_Measure_PVT.Application_Measure_Rec_Type
100 , x_return_status OUT NOCOPY VARCHAR2
101 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
102 );
103 --
104 --
105 PROCEDURE Update_Application_Measure
106 ( p_api_version IN NUMBER
107 , p_commit IN VARCHAR2 := FND_API.G_FALSE
108 , p_Measure_Short_Name IN BIS_INDICATORS.SHORT_NAME%TYPE
109 , p_Application_Id IN BIS_APPLICATION_MEASURES.APPLICATION_ID%TYPE
110 , x_return_status OUT NOCOPY VARCHAR2
111 , x_msg_count OUT NOCOPY NUMBER
112 , x_msg_data OUT NOCOPY VARCHAR2
113 );
114 --
115 --
116 PROCEDURE Update_Application_Measure
117 ( p_api_version IN NUMBER
118 , p_commit IN VARCHAR2 := FND_API.G_FALSE
119 , p_Application_Measure_Rec IN
120 BIS_Application_Measure_PVT.Application_Measure_Rec_Type
121 , p_owner IN VARCHAR2
122 , x_return_status OUT NOCOPY VARCHAR2
123 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
124 );
125 --
126 --
127 PROCEDURE Delete_Application_Measure
128 ( p_api_version IN NUMBER
129 , p_commit IN VARCHAR2 := FND_API.G_FALSE
130 , p_Application_Measure_Rec IN
131 BIS_Application_Measure_PVT.Application_Measure_Rec_Type
132 , x_return_status OUT NOCOPY VARCHAR2
133 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
134 );
135 --
136 -- Validates measure
137 PROCEDURE Validate_Application_Measure
138 ( p_api_version IN NUMBER
139 ,p_Application_Measure_Rec IN
140 BIS_Application_Measure_PVT.Application_Measure_Rec_Type
141 , x_return_status OUT NOCOPY VARCHAR2
142 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
143 );
144 --
145 --
146 -- Value - ID conversion
147 PROCEDURE Value_ID_Conversion
148 ( p_api_version IN NUMBER
149 , p_Application_Measure_Rec IN
150 BIS_Application_Measure_PVT.Application_Measure_Rec_Type
151 , x_Application_Measure_Rec IN OUT NOCOPY
152 BIS_Application_Measure_PVT.Application_Measure_Rec_Type
153 , x_return_status OUT NOCOPY VARCHAR2
154 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
155 );
156 --
157 PROCEDURE Retrieve_Last_Update_Date
158 ( p_api_version IN NUMBER
159 , p_Application_Measure_Rec IN
160 BIS_Application_Measure_PVT.Application_Measure_Rec_Type
161 , x_last_update_date OUT NOCOPY DATE
162 , x_return_status OUT NOCOPY VARCHAR2
163 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
164 );
165 --
166 PROCEDURE Lock_Record
167 ( p_api_version IN NUMBER
168 , p_Application_Measure_Rec IN
169 BIS_Application_Measure_PVT.Application_Measure_Rec_Type
170 , p_timestamp IN VARCHAR := NULL
171 , x_return_status OUT NOCOPY VARCHAR2
172 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
173 );
174 --
175 END BIS_Application_Measure_PVT;