APPS.CN_COMP_PLANS_PKG dependencies on CN_COMP_PLANS

Line 1: PACKAGE BODY CN_COMP_PLANS_PKG as

1: PACKAGE BODY CN_COMP_PLANS_PKG as
2: /* $Header: cnpliplb.pls 120.6 2006/04/28 01:36:37 kjayapau ship $ */
3: /*
4: Date Name Description
5: -------------------------------------------------------------------------+-+

Line 44: FROM cn_comp_plans

40: BEGIN
41:
42: SELECT name
43: INTO g_plan_name
44: FROM cn_comp_plans
45: WHERE comp_plan_id = x_comp_plan_id;
46:
47: return g_plan_name;
48: exception

Line 227: cn_comp_plans cp

223: ,lc.lookup_code
224: INTO X_Status
225: ,X_status_code
226: FROM cn_lookups lc,
227: cn_comp_plans cp
228: WHERE cp.status_code = lc.lookup_code
229: AND lc.lookup_type = 'PLAN_OBJECT_STATUS'
230: AND cp.comp_plan_id = x_comp_plan_id
231: ;

Line 251: SELECT cn_comp_plans_s.nextval

247: -------------------------------------------------------------------------++
248: PROCEDURE Get_Uid ( X_Comp_Plan_Id IN OUT NOCOPY NUMBER ) IS
249: BEGIN
250: IF X_Comp_Plan_Id IS NULL OR X_Comp_Plan_Id = CN_API.G_MISS_ID OR X_Comp_Plan_Id = FND_API.G_MISS_NUM THEN
251: SELECT cn_comp_plans_s.nextval
252: INTO x_comp_plan_id
253: FROM sys.dual;
254: END IF;
255: END Get_uid;

Line 269: -- o The user tries to 'complete' the plan by the cn_comp_plans_pkg.

265: -- Changing the date range on a plan does not impact the srp plan assigns
266: -- and therefore no need to maintain the srp period records
267: --
268: -- Called when
269: -- o The user tries to 'complete' the plan by the cn_comp_plans_pkg.
270: -- end_record
271: -- o After update of rate table
272: -- o After update of quota
273: -------------------------------------------------------------------------+

Line 322: UPDATE cn_comp_plans

318: END IF ;*/
319: IF x_comp_plan_id IS NOT NULL THEN
320:
321: -- Called after comp plan update
322: UPDATE cn_comp_plans
323: SET status_code = x_status_code
324: WHERE comp_plan_id = x_comp_plan_id
325: ;
326:

Line 330: UPDATE cn_comp_plans

326:
327: ELSIF x_quota_id IS NOT NULL THEN
328:
329: -- called after quota, quota rule or trx factor update
330: UPDATE cn_comp_plans
331: SET status_code = x_status_code
332: WHERE comp_plan_id IN (SELECT qa.comp_plan_id
333: FROM cn_quota_assigns qa
334: WHERE qa.quota_id = x_quota_id)

Line 369: UPDATE cn_comp_plans

365:
366: ELSIF x_rate_schedule_id IS NOT NULL THEN
367:
368: -- Called after rate table update
369: UPDATE cn_comp_plans
370: SET status_code = x_status_code
371: WHERE comp_plan_id IN (SELECT qa.comp_plan_id
372: FROM cn_quota_assigns qa,
373: cn_quotas_v q,

Line 455: CN_COMP_PLANS

451:
452: Get_UID( X_Comp_Plan_Id );
453:
454: INSERT INTO
455: CN_COMP_PLANS
456: (
457: Comp_Plan_Id ,
458: Name ,
459: Last_Update_Date ,

Line 573: UPDATE cn_comp_plans

569: -- check_unique( x_comp_plan_id,x_Name);
570: -- check_period_range( x_comp_plan_id
571: -- ,x_start_period_id
572: -- ,x_end_period_id);
573: UPDATE cn_comp_plans
574: SET
575: Comp_Plan_Id = X_Comp_Plan_Id ,
576: Name = X_Name ,
577: Last_Update_Date = X_Last_Update_Date ,

Line 648: SELECT * FROM CN_COMP_PLANS

644: x_attribute14 VARCHAR2 ,
645: x_attribute15 VARCHAR2 ) IS
646:
647: CURSOR C IS
648: SELECT * FROM CN_COMP_PLANS
649: WHERE comp_plan_id = X_Comp_Plan_id
650: FOR UPDATE OF COMP_PLAN_ID NOWAIT;
651: Recinfo C%ROWTYPE;
652:

Line 701: select 1 into l_exists FROM cn_comp_plans

697: IF not l_okay then
698: RAISE FND_API.G_EXC_ERROR ;
699: end if;
700:
701: select 1 into l_exists FROM cn_comp_plans
702: WHERE comp_plan_id = x_comp_plan_id;
703:
704: IF SQL%FOUND THEN
705: -- Delete all quota assignments that belong to the plan

Line 717: DELETE FROM cn_comp_plans

713: x_quota_id_old => null,
714: x_org_id => NULL);-- not used
715: END IF;
716:
717: DELETE FROM cn_comp_plans
718: WHERE comp_plan_id = x_comp_plan_id;
719:
720: END Delete_Record;
721: -------------------------------------------------------------------------+

Line 739: FROM cn_comp_plans

735:
736: BEGIN
737: SELECT count(1)
738: INTO X_dummy
739: FROM cn_comp_plans
740: WHERE name = X_Name
741: AND (X_Comp_Plan_Id IS NULL
742: OR X_Comp_Plan_Id <> comp_plan_id);
743:

Line 1030: END CN_COMP_PLANS_PKG;

1026: x_quota_status_code := null;
1027:
1028: END End_Record;
1029:
1030: END CN_COMP_PLANS_PKG;