APPS.CN_SRP_PLAN_ASSIGNS_PKG dependencies on CN_SRP_PLAN_ASSIGNS_ALL

Line 189: SELECT 1 INTO l_dummy FROM CN_SRP_PLAN_ASSIGNS_ALL

185: X_LAST_UPDATE_DATE,
186: X_LAST_UPDATED_BY,
187: X_LAST_UPDATE_LOGIN
188: );
189: SELECT 1 INTO l_dummy FROM CN_SRP_PLAN_ASSIGNS_ALL
190: WHERE SRP_PLAN_ASSIGN_ID = X_SRP_PLAN_ASSIGN_ID;
191:
192: -- insert all child records -- called in API:CN_SRP_PLAN_ASSIGNS_PVT
193: -- cn_srp_quota_assigns_pkg.insert_record

Line 232: SELECT * FROM CN_SRP_PLAN_ASSIGNS_ALL

228: X_ATTRIBUTE14 IN VARCHAR2,
229: X_ATTRIBUTE15 IN VARCHAR2
230: ) IS
231: CURSOR c IS
232: SELECT * FROM CN_SRP_PLAN_ASSIGNS_ALL
233: WHERE SRP_PLAN_ASSIGN_ID = X_SRP_PLAN_ASSIGN_ID
234: FOR UPDATE OF SRP_PLAN_ASSIGN_ID nowait;
235: tlinfo C%ROWTYPE;
236: BEGIN

Line 362: SELECT * FROM CN_SRP_PLAN_ASSIGNS_ALL

358:
359: l_next_start_date cn_acc_period_statuses_v.end_date%TYPE;
360:
361: CURSOR c IS
362: SELECT * FROM CN_SRP_PLAN_ASSIGNS_ALL
363: WHERE SRP_PLAN_ASSIGN_ID = X_SRP_PLAN_ASSIGN_ID
364: FOR UPDATE OF SRP_PLAN_ASSIGN_ID nowait;
365: oldrow C%ROWTYPE;
366:

Line 472: UPDATE CN_SRP_PLAN_ASSIGNS_ALL SET

468: l_attribute14,
469: l_attribute15
470: FROM dual;
471:
472: UPDATE CN_SRP_PLAN_ASSIGNS_ALL SET
473: SRP_PLAN_ASSIGN_ID = x_srp_plan_assign_id ,
474: SRP_ROLE_ID = l_srp_role_id ,
475: ROLE_PLAN_ID = l_role_plan_id ,
476: SALESREP_ID = l_salesrep_id ,

Line 654: DELETE FROM CN_SRP_PLAN_ASSIGNS_ALL

650:
651: -- delete child rec is called in API:CN_SRP_PLAN_ASSIGNS_PVT
652: -- cn_srp_quota_assigns_pkg.delete_record
653:
654: DELETE FROM CN_SRP_PLAN_ASSIGNS_ALL
655: WHERE SRP_PLAN_ASSIGN_ID = X_SRP_PLAN_ASSIGN_ID;
656:
657: IF (SQL%NOTFOUND) THEN
658: RAISE NO_DATA_FOUND;