APPS.CN_ATTAIN_TIER_PVT dependencies on CN_ATTAIN_TIERS

Line 88: FROM cn_attain_tiers

84: -- same role quota category is not allowed to be
85: -- assigned twice
86: SELECT count(1)
87: INTO l_temp_count
88: FROM cn_attain_tiers
89: WHERE attain_schedule_id = p_attain_tier.attain_schedule_id
90: AND percent = p_attain_tier.percent
91: ;
92:

Line 113: CN_ATTAIN_TIERS_PKG.INSERT_ROW

109: select cn_role_quota_formulas_s.nextval
110: into l_attain_tier_id
111: from dual;
112:
113: CN_ATTAIN_TIERS_PKG.INSERT_ROW
114: (
115: X_ROWID => G_ROWID,
116: X_ATTAIN_TIER_ID => l_attain_tier_id,
117: X_ATTAIN_SCHEDULE_ID => p_attain_tier.ATTAIN_SCHEDULE_ID,

Line 229: FROM cn_attain_tiers

225: l_temp_count NUMBER;
226:
227: CURSOR l_old_attain_tier_cr IS
228: SELECT *
229: FROM cn_attain_tiers
230: WHERE attain_tier_id = p_attain_tier.attain_tier_id;
231:
232: l_old_attain_tier l_old_attain_tier_cr%ROWTYPE;
233: BEGIN

Line 270: FROM cn_attain_tiers

266: -- same role quota category is not allowed to be
267: -- assigned twice
268: SELECT count(1)
269: INTO l_temp_count
270: FROM cn_attain_tiers
271: WHERE attain_schedule_id = p_attain_tier.attain_schedule_id
272: AND percent = p_attain_tier.percent
273: AND attain_tier_id <> p_attain_tier.attain_tier_id;
274:

Line 303: CN_ATTAIN_TIERS_PKG.UPDATE_ROW

299: fnd_msg_pub.add;
300: raise fnd_api.g_exc_error;
301: END IF;
302:
303: CN_ATTAIN_TIERS_PKG.UPDATE_ROW
304: (
305: X_ATTAIN_TIER_ID => p_attain_tier.ATTAIN_TIER_ID,
306: X_ATTAIN_SCHEDULE_ID => p_attain_tier.ATTAIN_SCHEDULE_ID,
307: X_PERCENT => p_attain_tier.PERCENT,

Line 425: CN_ATTAIN_TIERS_PKG.DELETE_ROW(

421: -- Initialize API return status to success
422: x_return_status := FND_API.G_RET_STS_SUCCESS;
423: -- API body
424:
425: CN_ATTAIN_TIERS_PKG.DELETE_ROW(
426: X_ATTAIN_TIER_ID => p_attain_tier.ATTAIN_TIER_ID);
427:
428: -- End of API body.
429: -- Standard check of p_commit.

Line 510: FROM cn_attain_tiers

506: l_counter NUMBER;
507:
508: CURSOR l_attain_tier_cr IS
509: SELECT *
510: FROM cn_attain_tiers
511: WHERE attain_schedule_id = p_attain_schedule_id
512: ORDER BY percent
513: ;
514: