APPS.CN_PLAN_TEXTS_PKG dependencies on CN_PLAN_TEXTS

Line 1: PACKAGE BODY CN_PLAN_TEXTS_PKG AS

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,

Line 39: INSERT INTO cn_plan_texts (

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,

Line 139: UPDATE cn_plan_texts SET

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,

Line 178: DELETE FROM cn_plan_texts

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;

Line 184: END CN_PLAN_TEXTS_PKG;

180: PLAN_TEXT_ID = P_PLAN_TEXT_ID;
181:
182: END Delete_Row;
183:
184: END CN_PLAN_TEXTS_PKG;