APPS.CN_QUOTA_ASSIGNS_PKG dependencies on CN_COMP_PLANS

Line 63: l_name cn_comp_plans.name%TYPE;

59: ,X_Quota_Assign_Id IN OUT NOCOPY NUMBER
60: ,X_Quota_Sequence NUMBER
61: ,X_ORG_ID NUMBER) IS
62:
63: l_name cn_comp_plans.name%TYPE;
64: l_start_date DATE;
65: l_end_date DATE;
66: l_null_date CONSTANT DATE := to_date('31-12-3000','DD-MM-YYYY');
67: l_loading_status varchar2(30);

Line 94: cn_comp_plans_pkg.set_status( x_comp_plan_id => x_comp_plan_id

90: -- status is not updated even though the quota in/upd cannot be made.
91:
92: cn_quota_assigns_pkg.check_exists(x_quota_id);
93:
94: cn_comp_plans_pkg.set_status( x_comp_plan_id => x_comp_plan_id
95: ,x_quota_id => null
96: ,x_rate_schedule_id => null
97: ,x_status_code => 'INCOMPLETE'
98: ,x_event => 'CHANGE_COMP_PLAN');

Line 175: FROM cn_comp_plans

171: BEGIN
172:
173: SELECT name, start_date, end_date
174: INTO l_name, l_start_date, l_end_date
175: FROM cn_comp_plans
176: WHERE comp_plan_id = x_comp_plan_id;
177: EXCEPTION
178: WHEN no_data_found THEN
179: l_name := NULL;

Line 231: cn_comp_plans_pkg.set_status(

227: IF (x_quota_id <> x_quota_id_old ) THEN
228:
229: cn_quota_assigns_pkg.check_exists(x_quota_id);
230:
231: cn_comp_plans_pkg.set_status(
232: x_comp_plan_id => x_comp_plan_id
233: ,x_quota_id => null
234: ,x_rate_schedule_id => null
235: ,x_status_code => 'INCOMPLETE'

Line 320: l_name cn_comp_plans.name%TYPE;

316: PROCEDURE Delete_Record( X_Quota_Assign_Id NUMBER
317: ,X_Comp_Plan_Id NUMBER
318: ,x_quota_id NUMBER) IS
319:
320: l_name cn_comp_plans.name%TYPE;
321: l_start_date DATE;
322: l_end_date DATE;
323: l_quota_id NUMBER;
324: l_org_id NUMBER;

Line 343: cn_comp_plans_pkg.set_status( x_comp_plan_id => x_comp_plan_id

339: close get_quota_id_for_mark;
340:
341: end if;
342:
343: cn_comp_plans_pkg.set_status( x_comp_plan_id => x_comp_plan_id
344: ,x_quota_id => null
345: ,x_rate_schedule_id => null
346: ,x_status_code => 'INCOMPLETE'
347: ,x_event => 'CHANGE_COMP_PLAN');

Line 368: FROM cn_comp_plans

364: BEGIN
365:
366: SELECT name, start_date, end_date
367: INTO l_name, l_start_date, l_end_date
368: FROM cn_comp_plans
369: WHERE comp_plan_id = x_comp_plan_id;
370: EXCEPTION
371: WHEN no_data_found THEN
372: l_name := NULL;

Line 375: select org_id into l_org_id from cn_comp_plans

371: WHEN no_data_found THEN
372: l_name := NULL;
373: END ;
374:
375: select org_id into l_org_id from cn_comp_plans
376: where comp_plan_id = x_comp_plan_id;
377:
378: cn_mark_events_pkg.mark_event_comp_plan
379: ( p_event_name => 'CHANGE_COMP_PLAN'