APPS.CN_ATTAIN_SCHEDULE_PVT dependencies on CN_ATTAIN_SCHEDULES

Line 85: FROM cn_attain_schedules

81: -- same role quota category is not allowed to be
82: -- assigned twice
83: SELECT count(1)
84: INTO l_temp_count
85: FROM cn_attain_schedules
86: WHERE name = p_attain_schedule.name
87: ;
88:
89: IF l_temp_count > 0 THEN

Line 101: CN_ATTAIN_SCHEDULES_PKG.INSERT_ROW

97: select cn_role_quota_formulas_s.nextval
98: into l_attain_schedule_id
99: from dual;
100:
101: CN_ATTAIN_SCHEDULES_PKG.INSERT_ROW
102: (
103: X_ROWID => G_ROWID,
104: X_ATTAIN_SCHEDULE_ID => l_attain_schedule_id,
105: X_NAME => p_attain_schedule.NAME,

Line 216: FROM cn_attain_schedules

212: l_temp_count NUMBER;
213:
214: CURSOR l_old_attain_schedule_cr IS
215: SELECT *
216: FROM cn_attain_schedules
217: WHERE attain_schedule_id = p_attain_schedule.attain_schedule_id;
218:
219: l_old_attain_schedule l_old_attain_schedule_cr%ROWTYPE;
220: BEGIN

Line 256: FROM cn_attain_schedules

252: -- same role quota category is not allowed to be
253: -- assigned twice
254: SELECT count(1)
255: INTO l_temp_count
256: FROM cn_attain_schedules
257: WHERE name = p_attain_schedule.name
258: AND attain_schedule_id <> p_attain_schedule.attain_schedule_id;
259:
260: IF l_temp_count > 0 THEN

Line 280: CN_ATTAIN_SCHEDULES_PKG.UPDATE_ROW

276: fnd_msg_pub.add;
277: raise fnd_api.g_exc_error;
278: END IF;
279:
280: CN_ATTAIN_SCHEDULES_PKG.UPDATE_ROW
281: (
282: X_ATTAIN_SCHEDULE_ID => p_attain_schedule.ATTAIN_SCHEDULE_ID,
283: X_NAME => p_attain_schedule.NAME,
284: X_ATTRIBUTE_CATEGORY => p_attain_schedule.ATTRIBUTE_CATEGORY,

Line 428: CN_ATTAIN_SCHEDULES_PKG.DELETE_ROW(

424: RAISE FND_API.G_EXC_ERROR ;
425: END IF;
426:
427:
428: CN_ATTAIN_SCHEDULES_PKG.DELETE_ROW(
429: X_ATTAIN_SCHEDULE_ID => p_attain_schedule.ATTAIN_SCHEDULE_ID);
430:
431: FOR l_attain_tier IN l_attain_tier_cr LOOP
432:

Line 532: FROM cn_attain_schedules

528: l_counter NUMBER;
529:
530: CURSOR l_attain_schedule_cr IS
531: SELECT *
532: FROM cn_attain_schedules
533: ORDER BY name
534: ;
535:
536: l_attain_schedule l_attain_schedule_cr%ROWTYPE;