APPS.CN_PLAN_TEXTS_PVT dependencies on CN_PLAN_TEXTS

Line 1: PACKAGE BODY CN_PLAN_TEXTS_PVT AS

1: PACKAGE BODY CN_PLAN_TEXTS_PVT AS
2: /* $Header: cnvsptb.pls 115.16 2002/11/21 21:18:53 hlchen ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='CN_PLAN_TEXTS_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):='CN_PLAN_TEXTS_PVT';

1: PACKAGE BODY CN_PLAN_TEXTS_PVT AS
2: /* $Header: cnvsptb.pls 115.16 2002/11/21 21:18:53 hlchen ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='CN_PLAN_TEXTS_PVT';
5:
6:
7:
8:

Line 119: FROM cn_plan_texts

115: -- same plan text is not allowed to be
116: -- assigned twice
117: SELECT count(1)
118: INTO l_temp_count
119: FROM cn_plan_texts
120: WHERE role_id = p_plan_text.role_id
121: AND nvl(role_model_id, -1) = nvl(p_plan_text.role_model_id, -1)
122: AND text_type = p_plan_text.text_type
123: AND ( quota_category_id is NULL OR

Line 139: SELECT cn_plan_texts_s.NEXTVAL INTO l_plan_text_id FROM DUAL;

135: END IF;
136: RAISE FND_API.G_EXC_ERROR ;
137: END IF;
138:
139: SELECT cn_plan_texts_s.NEXTVAL INTO l_plan_text_id FROM DUAL;
140:
141: CN_PLAN_TEXTS_PKG.Insert_Row
142: (
143: P_PLAN_TEXT_ID => l_plan_text_id,

Line 141: CN_PLAN_TEXTS_PKG.Insert_Row

137: END IF;
138:
139: SELECT cn_plan_texts_s.NEXTVAL INTO l_plan_text_id FROM DUAL;
140:
141: CN_PLAN_TEXTS_PKG.Insert_Row
142: (
143: P_PLAN_TEXT_ID => l_plan_text_id,
144: P_ROLE_ID => p_plan_text.role_id,
145: P_SEQUENCE_ID => p_plan_text.sequence_id,

Line 260: FROM cn_plan_texts

256: attribute12,
257: attribute13,
258: attribute14,
259: attribute15
260: FROM cn_plan_texts
261: WHERE plan_text_id = P_PLAN_TEXT_ID;
262:
263: l_plan_text l_cr%ROWTYPE;
264: l_temp_count NUMBER;

Line 317: FROM cn_plan_texts

313: -- same plan text is not allowed to be
314: -- assigned twice
315: SELECT count(1)
316: INTO l_temp_count
317: FROM cn_plan_texts
318: WHERE role_id = p_plan_text.role_id
319: AND nvl(role_model_id, -1) = nvl(p_plan_text.role_model_id, -1)
320: AND text_type = p_plan_text.text_type
321: AND ( quota_category_id is NULL OR

Line 351: CN_PLAN_TEXTS_PKG.Update_Row

347: fnd_msg_pub.add;
348: raise fnd_api.g_exc_error;
349: END IF;
350:
351: CN_PLAN_TEXTS_PKG.Update_Row
352: (
353: P_PLAN_TEXT_ID => p_plan_text.plan_text_id,
354: P_ROLE_ID => p_plan_text.role_id,
355: P_SEQUENCE_ID => p_plan_text.sequence_id,

Line 482: CN_PLAN_TEXTS_PKG.Delete_Row(p_plan_text.plan_text_id);

478: -- Initialize API return status to success
479: x_return_status := FND_API.G_RET_STS_SUCCESS;
480: -- API body
481:
482: CN_PLAN_TEXTS_PKG.Delete_Row(p_plan_text.plan_text_id);
483:
484: -- End of API body.
485: -- Standard check of p_commit.
486: IF FND_API.To_Boolean( p_commit ) THEN

Line 589: FROM cn_plan_texts

585: text_type,
586: text,
587: text2,
588: object_version_number
589: FROM cn_plan_texts
590: WHERE role_id = c_role_id
591: AND nvl(role_model_id, -1) = nvl(c_role_model_id, -1)
592: ORDER BY sequence_id;
593:

Line 1312: FROM cn_plan_texts

1308: i_text_type IN VARCHAR2)
1309: IS
1310: SELECT text,
1311: NVL(text2, ' ') text2
1312: FROM cn_plan_texts
1313: WHERE role_id = i_role_id
1314: AND NVL(role_model_id, 0) = NVL(p_role_model_id, 0)
1315: AND quota_category_id = i_quota_category_id
1316: AND text_type = i_text_type

Line 1323: FROM cn_plan_texts

1319: CURSOR plan_level_text_cur (i_role_id IN NUMBER, i_text_type IN VARCHAR2)
1320: IS
1321: SELECT NVL(text, ' ') text,
1322: NVL(text2, ' ') text2
1323: FROM cn_plan_texts
1324: WHERE role_id = i_role_id
1325: AND NVL(role_model_id, 0) = NVL(p_role_model_id, 0)
1326: AND text_type = i_text_type
1327: ORDER BY sequence_id

Line 1371: END CN_PLAN_TEXTS_PVT;

1367: RETURN NULL;
1368: END Get_Text;
1369:
1370:
1371: END CN_PLAN_TEXTS_PVT;