1 PACKAGE CSI_COUNTER_READING_LOCK_PKG AUTHID CURRENT_USER as
2 /* $Header: csitcrls.pls 120.1 2006/02/06 13:02:39 epajaril noship $*/
3
4 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_COUNTER_READING_LOCK_PKG';
5 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitcrls.pls';
6
7 PROCEDURE Insert_Row(
8 px_READING_LOCK_ID IN OUT NOCOPY NUMBER
9 ,p_COUNTER_ID NUMBER
10 ,p_READING_LOCK_DATE DATE
11 ,p_OBJECT_VERSION_NUMBER NUMBER
12 ,p_LAST_UPDATE_DATE DATE
13 ,p_LAST_UPDATED_BY NUMBER
14 ,p_CREATION_DATE DATE
15 ,p_CREATED_BY NUMBER
16 ,p_LAST_UPDATE_LOGIN NUMBER
17 ,p_SOURCE_GROUP_REF_ID NUMBER
18 ,p_SOURCE_GROUP_REF VARCHAR2
19 ,p_SOURCE_HEADER_REF_ID NUMBER
20 ,p_SOURCE_HEADER_REF VARCHAR2
21 ,p_SOURCE_LINE_REF_ID NUMBER
22 ,p_SOURCE_LINE_REF VARCHAR2
23 ,p_SOURCE_DIST_REF_ID1 NUMBER
24 ,p_SOURCE_DIST_REF_ID2 NUMBER
25 );
26
27 PROCEDURE Update_Row(
28 p_READING_LOCK_ID NUMBER
29 ,p_COUNTER_ID NUMBER
30 ,p_READING_LOCK_DATE DATE
31 ,p_OBJECT_VERSION_NUMBER NUMBER
32 ,p_LAST_UPDATE_DATE DATE
33 ,p_LAST_UPDATED_BY NUMBER
34 ,p_CREATION_DATE DATE
35 ,p_CREATED_BY NUMBER
36 ,p_LAST_UPDATE_LOGIN NUMBER
37 ,p_SOURCE_GROUP_REF_ID NUMBER
38 ,p_SOURCE_GROUP_REF VARCHAR2
39 ,p_SOURCE_HEADER_REF_ID NUMBER
40 ,p_SOURCE_HEADER_REF VARCHAR2
41 ,p_SOURCE_LINE_REF_ID NUMBER
42 ,p_SOURCE_LINE_REF VARCHAR2
43 ,p_SOURCE_DIST_REF_ID1 NUMBER
44 ,p_SOURCE_DIST_REF_ID2 NUMBER
45 );
46
47 PROCEDURE Lock_Row(
48 p_READING_LOCK_ID NUMBER
49 ,p_COUNTER_ID NUMBER
50 ,p_READING_LOCK_DATE DATE
51 ,p_OBJECT_VERSION_NUMBER NUMBER
52 ,p_LAST_UPDATE_DATE DATE
53 ,p_LAST_UPDATED_BY NUMBER
54 ,p_CREATION_DATE DATE
55 ,p_CREATED_BY NUMBER
56 ,p_LAST_UPDATE_LOGIN NUMBER
57 ,p_SOURCE_GROUP_REF_ID NUMBER
58 ,p_SOURCE_GROUP_REF VARCHAR2
59 ,p_SOURCE_HEADER_REF_ID NUMBER
60 ,p_SOURCE_HEADER_REF VARCHAR2
61 ,p_SOURCE_LINE_REF_ID NUMBER
62 ,p_SOURCE_LINE_REF VARCHAR2
63 ,p_SOURCE_DIST_REF_ID1 NUMBER
64 ,p_SOURCE_DIST_REF_ID2 NUMBER
65 );
66
67 PROCEDURE Delete_Row(
68 p_READING_LOCK_ID NUMBER
69 );
70
71 End CSI_COUNTER_READING_LOCK_PKG;