APPS.CN_ROLE_MODELS_PKG dependencies on CN_ROLE_MODELS

Line 1: PACKAGE BODY cn_role_models_pkg AS

1: PACKAGE BODY cn_role_models_pkg AS
2: /*$Header: cntrlmlb.pls 115.3 2002/01/28 20:05:31 pkm ship $*/
3:
4: PROCEDURE insert_row
5: (P_ROLE_MODEL_ID IN NUMBER := FND_API.G_MISS_NUM,

Line 48: INSERT INTO cn_role_models(

44: MD DATE := FND_API.G_MISS_DATE;
45:
46: BEGIN
47:
48: INSERT INTO cn_role_models(
49: role_model_id,
50: role_id,
51: name,
52: description,

Line 93: decode(p_role_model_id, mn, cn_role_models_s.nextval,

89: CREATION_DATE,
90: CREATED_BY
91: )
92: SELECT
93: decode(p_role_model_id, mn, cn_role_models_s.nextval,
94: p_role_model_id),
95: p_role_id,
96: p_name,
97: decode(p_description, mc, null, p_description),

Line 184: FROM cn_role_models

180: IS
181:
182: CURSOR l_old_csr IS
183: SELECT *
184: FROM cn_role_models
185: WHERE role_model_id = p_role_model_id;
186:
187: l_old_rec l_old_csr%ROWTYPE;
188:

Line 213: UPDATE cn_role_models SET

209: fnd_msg_pub.add;
210: raise fnd_api.g_exc_error;
211: END IF;
212:
213: UPDATE cn_role_models SET
214: (role_id,
215: name,
216: description,
217: seq,

Line 313: DELETE FROM cn_role_models

309:
310: PROCEDURE Delete_Row
311: (P_ROLE_MODEL_ID IN NUMBER) IS
312: BEGIN
313: DELETE FROM cn_role_models
314: WHERE role_model_id = p_role_model_id;
315:
316: END Delete_Row;
317:

Line 318: END cn_role_models_pkg;

314: WHERE role_model_id = p_role_model_id;
315:
316: END Delete_Row;
317:
318: END cn_role_models_pkg;