eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SRP_PLAN_ASSIGNS_PKG dependencies on CN_SRP_PLAN_ASSIGNS

Line 1: PACKAGE BODY CN_SRP_PLAN_ASSIGNS_PKG AS

1: PACKAGE BODY CN_SRP_PLAN_ASSIGNS_PKG AS
2: -- $Header: cnsrplab.pls 120.0 2005/06/06 17:57:37 appldev noship $
3: --
4: -- Package Name
5: -- CN_SRP_PLAN_ASSIGNS_PKG

Line 5: -- CN_SRP_PLAN_ASSIGNS_PKG

1: PACKAGE BODY CN_SRP_PLAN_ASSIGNS_PKG AS
2: -- $Header: cnsrplab.pls 120.0 2005/06/06 17:57:37 appldev noship $
3: --
4: -- Package Name
5: -- CN_SRP_PLAN_ASSIGNS_PKG
6: -- Purpose
7: -- Table Handler for CN_SRP_PLAN_ASSIGNS
8: -- FORM CNSRMT
9: -- BLOCK SRP_PLAN_ASSIGNS

Line 7: -- Table Handler for CN_SRP_PLAN_ASSIGNS

3: --
4: -- Package Name
5: -- CN_SRP_PLAN_ASSIGNS_PKG
6: -- Purpose
7: -- Table Handler for CN_SRP_PLAN_ASSIGNS
8: -- FORM CNSRMT
9: -- BLOCK SRP_PLAN_ASSIGNS
10: --
11: -- History

Line 27: SELECT cn_srp_plan_assigns_s.nextval

23: -- Get the Sequence Number to Create a new Srp Plan Assign.
24: -- -------------------------------------------------------------------------+
25: PROCEDURE Get_UID( X_srp_plan_assign_id IN OUT NOCOPY NUMBER) IS
26: BEGIN
27: SELECT cn_srp_plan_assigns_s.nextval
28: INTO x_srp_plan_assign_id
29: FROM dual;
30: END Get_UID;
31:

Line 126: INSERT INTO CN_SRP_PLAN_ASSIGNS

122: SELECT org_id INTO l_org_id
123: FROM cn_comp_plans_all
124: WHERE comp_plan_id = x_comp_plan_id;
125:
126: INSERT INTO CN_SRP_PLAN_ASSIGNS
127: (SRP_PLAN_ASSIGN_ID,
128: SRP_ROLE_ID,
129: ROLE_PLAN_ID,
130: SALESREP_ID,

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 192: -- insert all child records -- called in API:CN_SRP_PLAN_ASSIGNS_PVT

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
194:
195: END INSERT_ROW;
196:

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 335: l_srp_role_id CN_SRP_PLAN_ASSIGNS.srp_role_id%TYPE;

331: X_LAST_UPDATED_BY IN NUMBER,
332: X_LAST_UPDATE_LOGIN IN NUMBER
333: ) IS
334:
335: l_srp_role_id CN_SRP_PLAN_ASSIGNS.srp_role_id%TYPE;
336: l_role_plan_id CN_SRP_PLAN_ASSIGNS.role_plan_id%TYPE;
337: l_salesrep_id CN_SRP_PLAN_ASSIGNS.salesrep_id%TYPE;
338: l_role_id CN_SRP_PLAN_ASSIGNS.role_id%TYPE;
339: l_comp_plan_id CN_SRP_PLAN_ASSIGNS.comp_plan_id%TYPE;

Line 336: l_role_plan_id CN_SRP_PLAN_ASSIGNS.role_plan_id%TYPE;

332: X_LAST_UPDATE_LOGIN IN NUMBER
333: ) IS
334:
335: l_srp_role_id CN_SRP_PLAN_ASSIGNS.srp_role_id%TYPE;
336: l_role_plan_id CN_SRP_PLAN_ASSIGNS.role_plan_id%TYPE;
337: l_salesrep_id CN_SRP_PLAN_ASSIGNS.salesrep_id%TYPE;
338: l_role_id CN_SRP_PLAN_ASSIGNS.role_id%TYPE;
339: l_comp_plan_id CN_SRP_PLAN_ASSIGNS.comp_plan_id%TYPE;
340: l_start_date CN_SRP_PLAN_ASSIGNS.start_date%TYPE;

Line 337: l_salesrep_id CN_SRP_PLAN_ASSIGNS.salesrep_id%TYPE;

333: ) IS
334:
335: l_srp_role_id CN_SRP_PLAN_ASSIGNS.srp_role_id%TYPE;
336: l_role_plan_id CN_SRP_PLAN_ASSIGNS.role_plan_id%TYPE;
337: l_salesrep_id CN_SRP_PLAN_ASSIGNS.salesrep_id%TYPE;
338: l_role_id CN_SRP_PLAN_ASSIGNS.role_id%TYPE;
339: l_comp_plan_id CN_SRP_PLAN_ASSIGNS.comp_plan_id%TYPE;
340: l_start_date CN_SRP_PLAN_ASSIGNS.start_date%TYPE;
341: l_end_date CN_SRP_PLAN_ASSIGNS.end_date%TYPE;

Line 338: l_role_id CN_SRP_PLAN_ASSIGNS.role_id%TYPE;

334:
335: l_srp_role_id CN_SRP_PLAN_ASSIGNS.srp_role_id%TYPE;
336: l_role_plan_id CN_SRP_PLAN_ASSIGNS.role_plan_id%TYPE;
337: l_salesrep_id CN_SRP_PLAN_ASSIGNS.salesrep_id%TYPE;
338: l_role_id CN_SRP_PLAN_ASSIGNS.role_id%TYPE;
339: l_comp_plan_id CN_SRP_PLAN_ASSIGNS.comp_plan_id%TYPE;
340: l_start_date CN_SRP_PLAN_ASSIGNS.start_date%TYPE;
341: l_end_date CN_SRP_PLAN_ASSIGNS.end_date%TYPE;
342: l_attribute_category CN_SRP_PLAN_ASSIGNS.attribute_category%TYPE;

Line 339: l_comp_plan_id CN_SRP_PLAN_ASSIGNS.comp_plan_id%TYPE;

335: l_srp_role_id CN_SRP_PLAN_ASSIGNS.srp_role_id%TYPE;
336: l_role_plan_id CN_SRP_PLAN_ASSIGNS.role_plan_id%TYPE;
337: l_salesrep_id CN_SRP_PLAN_ASSIGNS.salesrep_id%TYPE;
338: l_role_id CN_SRP_PLAN_ASSIGNS.role_id%TYPE;
339: l_comp_plan_id CN_SRP_PLAN_ASSIGNS.comp_plan_id%TYPE;
340: l_start_date CN_SRP_PLAN_ASSIGNS.start_date%TYPE;
341: l_end_date CN_SRP_PLAN_ASSIGNS.end_date%TYPE;
342: l_attribute_category CN_SRP_PLAN_ASSIGNS.attribute_category%TYPE;
343: l_attribute1 CN_SRP_PLAN_ASSIGNS.attribute1%TYPE;

Line 340: l_start_date CN_SRP_PLAN_ASSIGNS.start_date%TYPE;

336: l_role_plan_id CN_SRP_PLAN_ASSIGNS.role_plan_id%TYPE;
337: l_salesrep_id CN_SRP_PLAN_ASSIGNS.salesrep_id%TYPE;
338: l_role_id CN_SRP_PLAN_ASSIGNS.role_id%TYPE;
339: l_comp_plan_id CN_SRP_PLAN_ASSIGNS.comp_plan_id%TYPE;
340: l_start_date CN_SRP_PLAN_ASSIGNS.start_date%TYPE;
341: l_end_date CN_SRP_PLAN_ASSIGNS.end_date%TYPE;
342: l_attribute_category CN_SRP_PLAN_ASSIGNS.attribute_category%TYPE;
343: l_attribute1 CN_SRP_PLAN_ASSIGNS.attribute1%TYPE;
344: l_attribute2 CN_SRP_PLAN_ASSIGNS.attribute2%TYPE;

Line 341: l_end_date CN_SRP_PLAN_ASSIGNS.end_date%TYPE;

337: l_salesrep_id CN_SRP_PLAN_ASSIGNS.salesrep_id%TYPE;
338: l_role_id CN_SRP_PLAN_ASSIGNS.role_id%TYPE;
339: l_comp_plan_id CN_SRP_PLAN_ASSIGNS.comp_plan_id%TYPE;
340: l_start_date CN_SRP_PLAN_ASSIGNS.start_date%TYPE;
341: l_end_date CN_SRP_PLAN_ASSIGNS.end_date%TYPE;
342: l_attribute_category CN_SRP_PLAN_ASSIGNS.attribute_category%TYPE;
343: l_attribute1 CN_SRP_PLAN_ASSIGNS.attribute1%TYPE;
344: l_attribute2 CN_SRP_PLAN_ASSIGNS.attribute2%TYPE;
345: l_attribute3 CN_SRP_PLAN_ASSIGNS.attribute3%TYPE;

Line 342: l_attribute_category CN_SRP_PLAN_ASSIGNS.attribute_category%TYPE;

338: l_role_id CN_SRP_PLAN_ASSIGNS.role_id%TYPE;
339: l_comp_plan_id CN_SRP_PLAN_ASSIGNS.comp_plan_id%TYPE;
340: l_start_date CN_SRP_PLAN_ASSIGNS.start_date%TYPE;
341: l_end_date CN_SRP_PLAN_ASSIGNS.end_date%TYPE;
342: l_attribute_category CN_SRP_PLAN_ASSIGNS.attribute_category%TYPE;
343: l_attribute1 CN_SRP_PLAN_ASSIGNS.attribute1%TYPE;
344: l_attribute2 CN_SRP_PLAN_ASSIGNS.attribute2%TYPE;
345: l_attribute3 CN_SRP_PLAN_ASSIGNS.attribute3%TYPE;
346: l_attribute4 CN_SRP_PLAN_ASSIGNS.attribute4%TYPE;

Line 343: l_attribute1 CN_SRP_PLAN_ASSIGNS.attribute1%TYPE;

339: l_comp_plan_id CN_SRP_PLAN_ASSIGNS.comp_plan_id%TYPE;
340: l_start_date CN_SRP_PLAN_ASSIGNS.start_date%TYPE;
341: l_end_date CN_SRP_PLAN_ASSIGNS.end_date%TYPE;
342: l_attribute_category CN_SRP_PLAN_ASSIGNS.attribute_category%TYPE;
343: l_attribute1 CN_SRP_PLAN_ASSIGNS.attribute1%TYPE;
344: l_attribute2 CN_SRP_PLAN_ASSIGNS.attribute2%TYPE;
345: l_attribute3 CN_SRP_PLAN_ASSIGNS.attribute3%TYPE;
346: l_attribute4 CN_SRP_PLAN_ASSIGNS.attribute4%TYPE;
347: l_attribute5 CN_SRP_PLAN_ASSIGNS.attribute5%TYPE;

Line 344: l_attribute2 CN_SRP_PLAN_ASSIGNS.attribute2%TYPE;

340: l_start_date CN_SRP_PLAN_ASSIGNS.start_date%TYPE;
341: l_end_date CN_SRP_PLAN_ASSIGNS.end_date%TYPE;
342: l_attribute_category CN_SRP_PLAN_ASSIGNS.attribute_category%TYPE;
343: l_attribute1 CN_SRP_PLAN_ASSIGNS.attribute1%TYPE;
344: l_attribute2 CN_SRP_PLAN_ASSIGNS.attribute2%TYPE;
345: l_attribute3 CN_SRP_PLAN_ASSIGNS.attribute3%TYPE;
346: l_attribute4 CN_SRP_PLAN_ASSIGNS.attribute4%TYPE;
347: l_attribute5 CN_SRP_PLAN_ASSIGNS.attribute5%TYPE;
348: l_attribute6 CN_SRP_PLAN_ASSIGNS.attribute6%TYPE;

Line 345: l_attribute3 CN_SRP_PLAN_ASSIGNS.attribute3%TYPE;

341: l_end_date CN_SRP_PLAN_ASSIGNS.end_date%TYPE;
342: l_attribute_category CN_SRP_PLAN_ASSIGNS.attribute_category%TYPE;
343: l_attribute1 CN_SRP_PLAN_ASSIGNS.attribute1%TYPE;
344: l_attribute2 CN_SRP_PLAN_ASSIGNS.attribute2%TYPE;
345: l_attribute3 CN_SRP_PLAN_ASSIGNS.attribute3%TYPE;
346: l_attribute4 CN_SRP_PLAN_ASSIGNS.attribute4%TYPE;
347: l_attribute5 CN_SRP_PLAN_ASSIGNS.attribute5%TYPE;
348: l_attribute6 CN_SRP_PLAN_ASSIGNS.attribute6%TYPE;
349: l_attribute7 CN_SRP_PLAN_ASSIGNS.attribute7%TYPE;

Line 346: l_attribute4 CN_SRP_PLAN_ASSIGNS.attribute4%TYPE;

342: l_attribute_category CN_SRP_PLAN_ASSIGNS.attribute_category%TYPE;
343: l_attribute1 CN_SRP_PLAN_ASSIGNS.attribute1%TYPE;
344: l_attribute2 CN_SRP_PLAN_ASSIGNS.attribute2%TYPE;
345: l_attribute3 CN_SRP_PLAN_ASSIGNS.attribute3%TYPE;
346: l_attribute4 CN_SRP_PLAN_ASSIGNS.attribute4%TYPE;
347: l_attribute5 CN_SRP_PLAN_ASSIGNS.attribute5%TYPE;
348: l_attribute6 CN_SRP_PLAN_ASSIGNS.attribute6%TYPE;
349: l_attribute7 CN_SRP_PLAN_ASSIGNS.attribute7%TYPE;
350: l_attribute8 CN_SRP_PLAN_ASSIGNS.attribute8%TYPE;

Line 347: l_attribute5 CN_SRP_PLAN_ASSIGNS.attribute5%TYPE;

343: l_attribute1 CN_SRP_PLAN_ASSIGNS.attribute1%TYPE;
344: l_attribute2 CN_SRP_PLAN_ASSIGNS.attribute2%TYPE;
345: l_attribute3 CN_SRP_PLAN_ASSIGNS.attribute3%TYPE;
346: l_attribute4 CN_SRP_PLAN_ASSIGNS.attribute4%TYPE;
347: l_attribute5 CN_SRP_PLAN_ASSIGNS.attribute5%TYPE;
348: l_attribute6 CN_SRP_PLAN_ASSIGNS.attribute6%TYPE;
349: l_attribute7 CN_SRP_PLAN_ASSIGNS.attribute7%TYPE;
350: l_attribute8 CN_SRP_PLAN_ASSIGNS.attribute8%TYPE;
351: l_attribute9 CN_SRP_PLAN_ASSIGNS.attribute9%TYPE;

Line 348: l_attribute6 CN_SRP_PLAN_ASSIGNS.attribute6%TYPE;

344: l_attribute2 CN_SRP_PLAN_ASSIGNS.attribute2%TYPE;
345: l_attribute3 CN_SRP_PLAN_ASSIGNS.attribute3%TYPE;
346: l_attribute4 CN_SRP_PLAN_ASSIGNS.attribute4%TYPE;
347: l_attribute5 CN_SRP_PLAN_ASSIGNS.attribute5%TYPE;
348: l_attribute6 CN_SRP_PLAN_ASSIGNS.attribute6%TYPE;
349: l_attribute7 CN_SRP_PLAN_ASSIGNS.attribute7%TYPE;
350: l_attribute8 CN_SRP_PLAN_ASSIGNS.attribute8%TYPE;
351: l_attribute9 CN_SRP_PLAN_ASSIGNS.attribute9%TYPE;
352: l_attribute10 CN_SRP_PLAN_ASSIGNS.attribute10%TYPE;

Line 349: l_attribute7 CN_SRP_PLAN_ASSIGNS.attribute7%TYPE;

345: l_attribute3 CN_SRP_PLAN_ASSIGNS.attribute3%TYPE;
346: l_attribute4 CN_SRP_PLAN_ASSIGNS.attribute4%TYPE;
347: l_attribute5 CN_SRP_PLAN_ASSIGNS.attribute5%TYPE;
348: l_attribute6 CN_SRP_PLAN_ASSIGNS.attribute6%TYPE;
349: l_attribute7 CN_SRP_PLAN_ASSIGNS.attribute7%TYPE;
350: l_attribute8 CN_SRP_PLAN_ASSIGNS.attribute8%TYPE;
351: l_attribute9 CN_SRP_PLAN_ASSIGNS.attribute9%TYPE;
352: l_attribute10 CN_SRP_PLAN_ASSIGNS.attribute10%TYPE;
353: l_attribute11 CN_SRP_PLAN_ASSIGNS.attribute11%TYPE;

Line 350: l_attribute8 CN_SRP_PLAN_ASSIGNS.attribute8%TYPE;

346: l_attribute4 CN_SRP_PLAN_ASSIGNS.attribute4%TYPE;
347: l_attribute5 CN_SRP_PLAN_ASSIGNS.attribute5%TYPE;
348: l_attribute6 CN_SRP_PLAN_ASSIGNS.attribute6%TYPE;
349: l_attribute7 CN_SRP_PLAN_ASSIGNS.attribute7%TYPE;
350: l_attribute8 CN_SRP_PLAN_ASSIGNS.attribute8%TYPE;
351: l_attribute9 CN_SRP_PLAN_ASSIGNS.attribute9%TYPE;
352: l_attribute10 CN_SRP_PLAN_ASSIGNS.attribute10%TYPE;
353: l_attribute11 CN_SRP_PLAN_ASSIGNS.attribute11%TYPE;
354: l_attribute12 CN_SRP_PLAN_ASSIGNS.attribute12%TYPE;

Line 351: l_attribute9 CN_SRP_PLAN_ASSIGNS.attribute9%TYPE;

347: l_attribute5 CN_SRP_PLAN_ASSIGNS.attribute5%TYPE;
348: l_attribute6 CN_SRP_PLAN_ASSIGNS.attribute6%TYPE;
349: l_attribute7 CN_SRP_PLAN_ASSIGNS.attribute7%TYPE;
350: l_attribute8 CN_SRP_PLAN_ASSIGNS.attribute8%TYPE;
351: l_attribute9 CN_SRP_PLAN_ASSIGNS.attribute9%TYPE;
352: l_attribute10 CN_SRP_PLAN_ASSIGNS.attribute10%TYPE;
353: l_attribute11 CN_SRP_PLAN_ASSIGNS.attribute11%TYPE;
354: l_attribute12 CN_SRP_PLAN_ASSIGNS.attribute12%TYPE;
355: l_attribute13 CN_SRP_PLAN_ASSIGNS.attribute13%TYPE;

Line 352: l_attribute10 CN_SRP_PLAN_ASSIGNS.attribute10%TYPE;

348: l_attribute6 CN_SRP_PLAN_ASSIGNS.attribute6%TYPE;
349: l_attribute7 CN_SRP_PLAN_ASSIGNS.attribute7%TYPE;
350: l_attribute8 CN_SRP_PLAN_ASSIGNS.attribute8%TYPE;
351: l_attribute9 CN_SRP_PLAN_ASSIGNS.attribute9%TYPE;
352: l_attribute10 CN_SRP_PLAN_ASSIGNS.attribute10%TYPE;
353: l_attribute11 CN_SRP_PLAN_ASSIGNS.attribute11%TYPE;
354: l_attribute12 CN_SRP_PLAN_ASSIGNS.attribute12%TYPE;
355: l_attribute13 CN_SRP_PLAN_ASSIGNS.attribute13%TYPE;
356: l_attribute14 CN_SRP_PLAN_ASSIGNS.attribute14%TYPE;

Line 353: l_attribute11 CN_SRP_PLAN_ASSIGNS.attribute11%TYPE;

349: l_attribute7 CN_SRP_PLAN_ASSIGNS.attribute7%TYPE;
350: l_attribute8 CN_SRP_PLAN_ASSIGNS.attribute8%TYPE;
351: l_attribute9 CN_SRP_PLAN_ASSIGNS.attribute9%TYPE;
352: l_attribute10 CN_SRP_PLAN_ASSIGNS.attribute10%TYPE;
353: l_attribute11 CN_SRP_PLAN_ASSIGNS.attribute11%TYPE;
354: l_attribute12 CN_SRP_PLAN_ASSIGNS.attribute12%TYPE;
355: l_attribute13 CN_SRP_PLAN_ASSIGNS.attribute13%TYPE;
356: l_attribute14 CN_SRP_PLAN_ASSIGNS.attribute14%TYPE;
357: l_attribute15 CN_SRP_PLAN_ASSIGNS.attribute15%TYPE;

Line 354: l_attribute12 CN_SRP_PLAN_ASSIGNS.attribute12%TYPE;

350: l_attribute8 CN_SRP_PLAN_ASSIGNS.attribute8%TYPE;
351: l_attribute9 CN_SRP_PLAN_ASSIGNS.attribute9%TYPE;
352: l_attribute10 CN_SRP_PLAN_ASSIGNS.attribute10%TYPE;
353: l_attribute11 CN_SRP_PLAN_ASSIGNS.attribute11%TYPE;
354: l_attribute12 CN_SRP_PLAN_ASSIGNS.attribute12%TYPE;
355: l_attribute13 CN_SRP_PLAN_ASSIGNS.attribute13%TYPE;
356: l_attribute14 CN_SRP_PLAN_ASSIGNS.attribute14%TYPE;
357: l_attribute15 CN_SRP_PLAN_ASSIGNS.attribute15%TYPE;
358:

Line 355: l_attribute13 CN_SRP_PLAN_ASSIGNS.attribute13%TYPE;

351: l_attribute9 CN_SRP_PLAN_ASSIGNS.attribute9%TYPE;
352: l_attribute10 CN_SRP_PLAN_ASSIGNS.attribute10%TYPE;
353: l_attribute11 CN_SRP_PLAN_ASSIGNS.attribute11%TYPE;
354: l_attribute12 CN_SRP_PLAN_ASSIGNS.attribute12%TYPE;
355: l_attribute13 CN_SRP_PLAN_ASSIGNS.attribute13%TYPE;
356: l_attribute14 CN_SRP_PLAN_ASSIGNS.attribute14%TYPE;
357: l_attribute15 CN_SRP_PLAN_ASSIGNS.attribute15%TYPE;
358:
359: l_next_start_date cn_acc_period_statuses_v.end_date%TYPE;

Line 356: l_attribute14 CN_SRP_PLAN_ASSIGNS.attribute14%TYPE;

352: l_attribute10 CN_SRP_PLAN_ASSIGNS.attribute10%TYPE;
353: l_attribute11 CN_SRP_PLAN_ASSIGNS.attribute11%TYPE;
354: l_attribute12 CN_SRP_PLAN_ASSIGNS.attribute12%TYPE;
355: l_attribute13 CN_SRP_PLAN_ASSIGNS.attribute13%TYPE;
356: l_attribute14 CN_SRP_PLAN_ASSIGNS.attribute14%TYPE;
357: l_attribute15 CN_SRP_PLAN_ASSIGNS.attribute15%TYPE;
358:
359: l_next_start_date cn_acc_period_statuses_v.end_date%TYPE;
360:

Line 357: l_attribute15 CN_SRP_PLAN_ASSIGNS.attribute15%TYPE;

353: l_attribute11 CN_SRP_PLAN_ASSIGNS.attribute11%TYPE;
354: l_attribute12 CN_SRP_PLAN_ASSIGNS.attribute12%TYPE;
355: l_attribute13 CN_SRP_PLAN_ASSIGNS.attribute13%TYPE;
356: l_attribute14 CN_SRP_PLAN_ASSIGNS.attribute14%TYPE;
357: l_attribute15 CN_SRP_PLAN_ASSIGNS.attribute15%TYPE;
358:
359: l_next_start_date cn_acc_period_statuses_v.end_date%TYPE;
360:
361: CURSOR c IS

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 651: -- delete child rec is called in API:CN_SRP_PLAN_ASSIGNS_PVT

647: -- -------------------------------------------------------------------------+
648: PROCEDURE DELETE_ROW (X_SRP_PLAN_ASSIGN_ID IN NUMBER) IS
649: BEGIN
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;

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;

Line 663: END CN_SRP_PLAN_ASSIGNS_PKG;

659: END IF;
660:
661: END DELETE_ROW;
662:
663: END CN_SRP_PLAN_ASSIGNS_PKG;