1 PACKAGE CSI_CTR_USAGE_FORECAST_PKG AUTHID CURRENT_USER as
2 /* $Header: csitcufs.pls 120.0 2005/06/10 14:16:49 rktow noship $*/
3
4 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_CTR_USAGE_FORECAST_PKG';
5 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitcufs.pls';
6
7 PROCEDURE Insert_Row(
8 px_INSTANCE_FORECAST_ID IN OUT NOCOPY NUMBER
9 ,p_COUNTER_ID NUMBER
10 ,p_USAGE_RATE NUMBER
11 ,p_USE_PAST_READING NUMBER
12 ,p_ACTIVE_START_DATE DATE
13 ,p_ACTIVE_END_DATE DATE
14 ,p_OBJECT_VERSION_NUMBER NUMBER
15 ,p_LAST_UPDATE_DATE DATE
16 ,p_LAST_UPDATED_BY NUMBER
17 ,p_CREATION_DATE DATE
18 ,p_CREATED_BY NUMBER
19 ,p_LAST_UPDATE_LOGIN NUMBER
20 );
21
22 PROCEDURE Update_Row(
23 p_INSTANCE_FORECAST_ID NUMBER
24 ,p_COUNTER_ID NUMBER
25 ,p_USAGE_RATE NUMBER
26 ,p_USE_PAST_READING NUMBER
27 ,p_ACTIVE_START_DATE DATE
28 ,p_ACTIVE_END_DATE DATE
29 ,p_OBJECT_VERSION_NUMBER NUMBER
30 ,p_LAST_UPDATE_DATE DATE
31 ,p_LAST_UPDATED_BY NUMBER
32 ,p_CREATION_DATE DATE
33 ,p_CREATED_BY NUMBER
34 ,p_LAST_UPDATE_LOGIN NUMBER
35 );
36
37 PROCEDURE Lock_Row(
38 p_INSTANCE_FORECAST_ID NUMBER
39 ,p_COUNTER_ID NUMBER
40 ,p_USAGE_RATE NUMBER
41 ,p_USE_PAST_READING NUMBER
42 ,p_ACTIVE_START_DATE DATE
43 ,p_ACTIVE_END_DATE DATE
44 ,p_OBJECT_VERSION_NUMBER NUMBER
45 ,p_LAST_UPDATE_DATE DATE
46 ,p_LAST_UPDATED_BY NUMBER
47 ,p_CREATION_DATE DATE
48 ,p_CREATED_BY NUMBER
49 ,p_LAST_UPDATE_LOGIN NUMBER
50 );
51
52 PROCEDURE Delete_Row(
53 p_INSTANCE_FORECAST_ID NUMBER
54 );
55
56 End CSI_CTR_USAGE_FORECAST_PKG;