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,
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,
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,
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;
180: PLAN_TEXT_ID = P_PLAN_TEXT_ID;
181:
182: END Delete_Row;
183:
184: END CN_PLAN_TEXTS_PKG;