1 PACKAGE CN_PLAN_TEXTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: cntspxs.pls 115.3 2002/01/28 20:06:07 pkm ship $ */
3
4 PROCEDURE Insert_Row (
5 P_PLAN_TEXT_ID IN NUMBER,
6 P_ROLE_ID IN NUMBER,
7 P_SEQUENCE_ID IN NUMBER,
8 P_QUOTA_CATEGORY_ID IN NUMBER,
9 P_TEXT_TYPE IN VARCHAR2,
10 P_TEXT IN VARCHAR2,
11 P_TEXT2 IN VARCHAR2,
12 P_ATTRIBUTE_CATEGORY IN VARCHAR2 := NULL,
13 P_ATTRIBUTE1 IN VARCHAR2 := NULL,
14 P_ATTRIBUTE2 IN VARCHAR2 := NULL,
15 P_ATTRIBUTE3 IN VARCHAR2 := NULL,
16 P_ATTRIBUTE4 IN VARCHAR2 := NULL,
17 P_ATTRIBUTE5 IN VARCHAR2 := NULL,
18 P_ATTRIBUTE6 IN VARCHAR2 := NULL,
19 P_ATTRIBUTE7 IN VARCHAR2 := NULL,
20 P_ATTRIBUTE8 IN VARCHAR2 := NULL,
21 P_ATTRIBUTE9 IN VARCHAR2 := NULL,
22 P_ATTRIBUTE10 IN VARCHAR2 := NULL,
23 P_ATTRIBUTE11 IN VARCHAR2 := NULL,
24 P_ATTRIBUTE12 IN VARCHAR2 := NULL,
25 P_ATTRIBUTE13 IN VARCHAR2 := NULL,
26 P_ATTRIBUTE14 IN VARCHAR2 := NULL,
27 P_ATTRIBUTE15 IN VARCHAR2 := NULL,
28 P_CREATION_DATE IN DATE,
29 P_CREATED_BY IN NUMBER,
30 P_LAST_UPDATE_DATE IN DATE,
31 P_LAST_UPDATED_BY IN NUMBER,
32 P_LAST_UPDATE_LOGIN IN NUMBER,
33 P_OBJECT_VERSION_NUMBER IN NUMBER,
34 P_ROLE_MODEL_ID IN NUMBER
35 );
36
37 PROCEDURE Update_Row (
38 P_PLAN_TEXT_ID IN NUMBER,
39 P_ROLE_ID IN NUMBER,
40 P_SEQUENCE_ID IN NUMBER,
41 P_QUOTA_CATEGORY_ID IN NUMBER,
42 P_TEXT_TYPE IN VARCHAR2,
43 P_TEXT IN VARCHAR2,
44 P_TEXT2 IN VARCHAR2,
45 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
46 P_ATTRIBUTE1 IN VARCHAR2,
47 P_ATTRIBUTE2 IN VARCHAR2,
48 P_ATTRIBUTE3 IN VARCHAR2,
49 P_ATTRIBUTE4 IN VARCHAR2,
50 P_ATTRIBUTE5 IN VARCHAR2,
51 P_ATTRIBUTE6 IN VARCHAR2,
52 P_ATTRIBUTE7 IN VARCHAR2,
53 P_ATTRIBUTE8 IN VARCHAR2,
54 P_ATTRIBUTE9 IN VARCHAR2,
55 P_ATTRIBUTE10 IN VARCHAR2,
56 P_ATTRIBUTE11 IN VARCHAR2,
57 P_ATTRIBUTE12 IN VARCHAR2,
58 P_ATTRIBUTE13 IN VARCHAR2,
59 P_ATTRIBUTE14 IN VARCHAR2,
60 P_ATTRIBUTE15 IN VARCHAR2,
61 P_LAST_UPDATE_DATE IN DATE,
62 P_LAST_UPDATED_BY IN NUMBER,
63 P_LAST_UPDATE_LOGIN IN NUMBER,
64 P_OBJECT_VERSION_NUMBER IN NUMBER,
65 P_ROLE_MODEL_ID IN NUMBER
66 );
67
68 PROCEDURE Delete_Row (
69 P_PLAN_TEXT_ID IN NUMBER
70 );
71
72 END CN_PLAN_TEXTS_PKG;