APPS.CN_MODEL_RESOURCES_PKG dependencies on CN_MODEL_RESOURCES

Line 1: PACKAGE BODY cn_model_resources_pkg AS

1: PACKAGE BODY cn_model_resources_pkg AS
2: /*$Header: cntmlrsb.pls 115.2 2002/01/28 20:04:51 pkm ship $*/
3:
4: PROCEDURE insert_row
5: (P_MODEL_RESOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,

Line 32: INSERT INTO cn_model_resources(

28: MD DATE := FND_API.G_MISS_DATE;
29:
30: BEGIN
31:
32: INSERT INTO cn_model_resources(
33: model_resource_id,
34: resource_id,
35: name,
36: srp_id,

Line 61: decode(p_model_resource_id, mn, cn_model_resources_s.nextval,

57: CREATION_DATE,
58: CREATED_BY
59: )
60: SELECT
61: decode(p_model_resource_id, mn, cn_model_resources_s.nextval,
62: p_model_resource_id),
63: p_resource_id,
64: p_name,
65: p_srp_id,

Line 120: FROM cn_model_resources

116: IS
117:
118: CURSOR l_old_csr IS
119: SELECT *
120: FROM cn_model_resources
121: WHERE model_resource_id = p_model_resource_id;
122:
123: l_old_rec l_old_csr%ROWTYPE;
124:

Line 149: UPDATE cn_model_resources SET

145: fnd_msg_pub.add;
146: raise fnd_api.g_exc_error;
147: END IF;
148:
149: UPDATE cn_model_resources SET
150: (resource_id,
151: name,
152: srp_id,
153: attribute_category,

Line 209: DELETE FROM cn_model_resources

205:
206: PROCEDURE Delete_Row
207: (P_MODEL_RESOURCE_ID IN NUMBER) IS
208: BEGIN
209: DELETE FROM cn_model_resources
210: WHERE model_resource_id = p_model_resource_id;
211:
212: END Delete_Row;
213:

Line 214: END cn_model_resources_pkg;

210: WHERE model_resource_id = p_model_resource_id;
211:
212: END Delete_Row;
213:
214: END cn_model_resources_pkg;