[Home] [Help]
PACKAGE BODY: APPS.CN_PLAN_TEXTS_PKG
Source
1 PACKAGE BODY CN_PLAN_TEXTS_PKG AS
2 /* $Header: cntspxb.pls 115.3 2002/01/28 20:06:05 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 ) IS
36
37 BEGIN
38
39 INSERT INTO cn_plan_texts (
40 PLAN_TEXT_ID,
41 ROLE_ID,
42 SEQUENCE_ID,
43 QUOTA_CATEGORY_ID,
44 TEXT_TYPE,
45 TEXT,
46 TEXT2,
47 ATTRIBUTE_CATEGORY,
48 ATTRIBUTE1,
49 ATTRIBUTE2,
50 ATTRIBUTE3,
51 ATTRIBUTE4,
52 ATTRIBUTE5,
53 ATTRIBUTE6,
54 ATTRIBUTE7,
55 ATTRIBUTE8,
56 ATTRIBUTE9,
57 ATTRIBUTE10,
58 ATTRIBUTE11,
59 ATTRIBUTE12,
60 ATTRIBUTE13,
61 ATTRIBUTE14,
62 ATTRIBUTE15,
63 CREATION_DATE,
64 CREATED_BY,
65 LAST_UPDATE_DATE,
66 LAST_UPDATED_BY,
67 LAST_UPDATE_LOGIN,
68 OBJECT_VERSION_NUMBER,
69 ROLE_MODEL_ID
70 )
71 VALUES (
72 P_PLAN_TEXT_ID,
73 P_ROLE_ID,
74 P_SEQUENCE_ID,
75 P_QUOTA_CATEGORY_ID,
76 P_TEXT_TYPE,
77 P_TEXT,
78 P_TEXT2,
79 P_ATTRIBUTE_CATEGORY,
80 P_ATTRIBUTE1,
81 P_ATTRIBUTE2,
82 P_ATTRIBUTE3,
83 P_ATTRIBUTE4,
84 P_ATTRIBUTE5,
85 P_ATTRIBUTE6,
86 P_ATTRIBUTE7,
87 P_ATTRIBUTE8,
88 P_ATTRIBUTE9,
89 P_ATTRIBUTE10,
90 P_ATTRIBUTE11,
91 P_ATTRIBUTE12,
92 P_ATTRIBUTE13,
93 P_ATTRIBUTE14,
94 P_ATTRIBUTE15,
95 P_CREATION_DATE,
96 P_CREATED_BY,
97 P_LAST_UPDATE_DATE,
98 P_LAST_UPDATED_BY,
99 P_LAST_UPDATE_LOGIN,
100 P_OBJECT_VERSION_NUMBER,
101 P_ROLE_MODEL_ID
102 );
103
104 END Insert_Row;
105
106 PROCEDURE Update_Row (
107 P_PLAN_TEXT_ID IN NUMBER,
108 P_ROLE_ID IN NUMBER,
109 P_SEQUENCE_ID IN NUMBER,
110 P_QUOTA_CATEGORY_ID IN NUMBER,
111 P_TEXT_TYPE IN VARCHAR2,
112 P_TEXT IN VARCHAR2,
113 P_TEXT2 IN VARCHAR2,
114 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
115 P_ATTRIBUTE1 IN VARCHAR2,
116 P_ATTRIBUTE2 IN VARCHAR2,
117 P_ATTRIBUTE3 IN VARCHAR2,
118 P_ATTRIBUTE4 IN VARCHAR2,
119 P_ATTRIBUTE5 IN VARCHAR2,
120 P_ATTRIBUTE6 IN VARCHAR2,
121 P_ATTRIBUTE7 IN VARCHAR2,
122 P_ATTRIBUTE8 IN VARCHAR2,
123 P_ATTRIBUTE9 IN VARCHAR2,
124 P_ATTRIBUTE10 IN VARCHAR2,
125 P_ATTRIBUTE11 IN VARCHAR2,
126 P_ATTRIBUTE12 IN VARCHAR2,
127 P_ATTRIBUTE13 IN VARCHAR2,
128 P_ATTRIBUTE14 IN VARCHAR2,
129 P_ATTRIBUTE15 IN VARCHAR2,
130 P_LAST_UPDATE_DATE IN DATE,
131 P_LAST_UPDATED_BY IN NUMBER,
132 P_LAST_UPDATE_LOGIN IN NUMBER,
133 P_OBJECT_VERSION_NUMBER IN NUMBER,
134 P_ROLE_MODEL_ID IN NUMBER
135 ) IS
136
137 BEGIN
138
139 UPDATE cn_plan_texts SET
140 PLAN_TEXT_ID = P_PLAN_TEXT_ID,
141 ROLE_ID = P_ROLE_ID,
142 SEQUENCE_ID = P_SEQUENCE_ID,
143 QUOTA_CATEGORY_ID = P_QUOTA_CATEGORY_ID,
144 TEXT_TYPE = P_TEXT_TYPE,
145 TEXT = P_TEXT,
146 TEXT2 = P_TEXT2,
147 ATTRIBUTE_CATEGORY = P_ATTRIBUTE_CATEGORY,
148 ATTRIBUTE1 = P_ATTRIBUTE1,
149 ATTRIBUTE2 = P_ATTRIBUTE2,
150 ATTRIBUTE3 = P_ATTRIBUTE3,
151 ATTRIBUTE4 = P_ATTRIBUTE4,
152 ATTRIBUTE5 = P_ATTRIBUTE5,
153 ATTRIBUTE6 = P_ATTRIBUTE6,
154 ATTRIBUTE7 = P_ATTRIBUTE7,
155 ATTRIBUTE8 = P_ATTRIBUTE8,
156 ATTRIBUTE9 = P_ATTRIBUTE9,
157 ATTRIBUTE10 = P_ATTRIBUTE10,
158 ATTRIBUTE11 = P_ATTRIBUTE11,
159 ATTRIBUTE12 = P_ATTRIBUTE12,
160 ATTRIBUTE13 = P_ATTRIBUTE13,
161 ATTRIBUTE14 = P_ATTRIBUTE14,
162 ATTRIBUTE15 = P_ATTRIBUTE15,
163 LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
164 LAST_UPDATED_BY = P_LAST_UPDATED_BY,
165 LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,
166 OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER,
167 ROLE_MODEL_ID = P_ROLE_MODEL_ID
168 WHERE PLAN_TEXT_ID = P_PLAN_TEXT_ID;
169
170 END Update_Row;
171
172 PROCEDURE Delete_Row (
173 P_PLAN_TEXT_ID in NUMBER
174 ) IS
175
176 BEGIN
177
178 DELETE FROM cn_plan_texts
179 WHERE
180 PLAN_TEXT_ID = P_PLAN_TEXT_ID;
181
182 END Delete_Row;
183
184 END CN_PLAN_TEXTS_PKG;