1 PACKAGE JTF_TERR_CNR_GROUPS_PKG AUTHID CURRENT_USER AS
2 /* $Header: jtfvtcgs.pls 120.0 2005/06/02 18:22:39 appldev ship $ */
3
4 -- 01/23/01 Amit Patel - Created package specs for JTF_TERR_CNR_GROUPS_PKG
5
6 PROCEDURE Insert_Row(
7 x_Rowid IN OUT NOCOPY VARCHAR2,
8 x_CNR_GROUP_ID IN OUT NOCOPY NUMBER,
9 x_LAST_UPDATED_BY IN NUMBER,
10 x_LAST_UPDATE_DATE IN DATE,
11 x_CREATED_BY IN NUMBER,
12 x_CREATION_DATE IN DATE,
13 x_LAST_UPDATE_LOGIN IN NUMBER,
14 x_NAME IN VARCHAR2,
15 x_DESCRIPTION IN VARCHAR2,
16 x_ATTRIBUTE_CATEGORY IN VARCHAR2,
17 x_ATTRIBUTE1 IN VARCHAR2,
18 x_ATTRIBUTE2 IN VARCHAR2,
19 x_ATTRIBUTE3 IN VARCHAR2,
20 x_ATTRIBUTE4 IN VARCHAR2,
21 x_ATTRIBUTE5 IN VARCHAR2,
22 x_ATTRIBUTE6 IN VARCHAR2,
23 x_ATTRIBUTE7 IN VARCHAR2,
24 x_ATTRIBUTE8 IN VARCHAR2,
25 x_ATTRIBUTE9 IN VARCHAR2,
26 x_ATTRIBUTE10 IN VARCHAR2,
27 x_ATTRIBUTE11 IN VARCHAR2,
28 x_ATTRIBUTE12 IN VARCHAR2,
29 x_ATTRIBUTE13 IN VARCHAR2,
30 x_ATTRIBUTE14 IN VARCHAR2,
31 x_ATTRIBUTE15 IN VARCHAR2
32 );
33
34
35 PROCEDURE Delete_Row(
36 x_CNR_GROUP_ID IN NUMBER
37 );
38
39
40 PROCEDURE Update_Row(
41 x_Rowid IN OUT NOCOPY VARCHAR2,
42 x_CNR_GROUP_ID IN OUT NOCOPY NUMBER,
43 x_LAST_UPDATED_BY IN NUMBER,
44 x_LAST_UPDATE_DATE IN DATE,
45 x_CREATED_BY IN NUMBER,
46 x_CREATION_DATE IN DATE,
47 x_LAST_UPDATE_LOGIN IN NUMBER,
48 x_NAME IN VARCHAR2,
49 x_DESCRIPTION IN VARCHAR2,
50 x_ATTRIBUTE_CATEGORY IN VARCHAR2,
51 x_ATTRIBUTE1 IN VARCHAR2,
52 x_ATTRIBUTE2 IN VARCHAR2,
53 x_ATTRIBUTE3 IN VARCHAR2,
54 x_ATTRIBUTE4 IN VARCHAR2,
55 x_ATTRIBUTE5 IN VARCHAR2,
56 x_ATTRIBUTE6 IN VARCHAR2,
57 x_ATTRIBUTE7 IN VARCHAR2,
58 x_ATTRIBUTE8 IN VARCHAR2,
59 x_ATTRIBUTE9 IN VARCHAR2,
60 x_ATTRIBUTE10 IN VARCHAR2,
61 x_ATTRIBUTE11 IN VARCHAR2,
62 x_ATTRIBUTE12 IN VARCHAR2,
63 x_ATTRIBUTE13 IN VARCHAR2,
64 x_ATTRIBUTE14 IN VARCHAR2,
65 x_ATTRIBUTE15 IN VARCHAR2
66 );
67
68
69
70 PROCEDURE Lock_Row(
71 x_Rowid IN OUT NOCOPY VARCHAR2,
72 x_CNR_GROUP_ID IN OUT NOCOPY NUMBER,
73 x_LAST_UPDATED_BY IN NUMBER,
74 x_LAST_UPDATE_DATE IN DATE,
75 x_CREATED_BY IN NUMBER,
76 x_CREATION_DATE IN DATE,
77 x_LAST_UPDATE_LOGIN IN NUMBER,
78 x_NAME IN VARCHAR2,
79 x_DESCRIPTION IN VARCHAR2,
80 x_ATTRIBUTE_CATEGORY IN VARCHAR2,
81 x_ATTRIBUTE1 IN VARCHAR2,
82 x_ATTRIBUTE2 IN VARCHAR2,
83 x_ATTRIBUTE3 IN VARCHAR2,
84 x_ATTRIBUTE4 IN VARCHAR2,
85 x_ATTRIBUTE5 IN VARCHAR2,
86 x_ATTRIBUTE6 IN VARCHAR2,
87 x_ATTRIBUTE7 IN VARCHAR2,
88 x_ATTRIBUTE8 IN VARCHAR2,
89 x_ATTRIBUTE9 IN VARCHAR2,
90 x_ATTRIBUTE10 IN VARCHAR2,
91 x_ATTRIBUTE11 IN VARCHAR2,
92 x_ATTRIBUTE12 IN VARCHAR2,
93 x_ATTRIBUTE13 IN VARCHAR2,
94 x_ATTRIBUTE14 IN VARCHAR2,
95 x_ATTRIBUTE15 IN VARCHAR2
96 );
97
98 END JTF_TERR_CNR_GROUPS_PKG;