APPS.CN_SRP_QUOTA_ASSIGNS_PKG dependencies on CN_SRP_QUOTA_ASSIGNS_S

Line 227: c_srp_plan_assign_id cn_srp_quota_assigns.srp_plan_assign_id%TYPE) IS

223: l_login_id NUMBER(15);
224: l_valid NUMBER;
225:
226: CURSOR l_srp_quota_assign_csr (c_quota_id cn_quotas.quota_id%TYPE,
227: c_srp_plan_assign_id cn_srp_quota_assigns.srp_plan_assign_id%TYPE) IS
228: SELECT srp_quota_assign_id
229: FROM cn_srp_quota_assigns_all
230: WHERE srp_plan_assign_id = c_srp_plan_assign_id
231: AND quota_id = c_quota_id;

Line 235: CURSOR l_srp_quota_assign_csr2 (c_srp_plan_assign_id cn_srp_quota_assigns.srp_plan_assign_id%TYPE) IS

231: AND quota_id = c_quota_id;
232:
233: l_srp_quota_assign_c l_srp_quota_assign_csr%ROWTYPE;
234:
235: CURSOR l_srp_quota_assign_csr2 (c_srp_plan_assign_id cn_srp_quota_assigns.srp_plan_assign_id%TYPE) IS
236: SELECT srp_quota_assign_id, quota_id
237: FROM cn_srp_quota_assigns_all
238: WHERE srp_plan_assign_id = c_srp_plan_assign_id;
239:

Line 299: cn_srp_quota_assigns_s.nextval

295: ,last_updated_by
296: ,last_update_login
297: ,org_id)
298: SELECT
299: cn_srp_quota_assigns_s.nextval
300: ,x_srp_plan_assign_id
301: ,q.quota_id
302: ,q.target
303: ,cn_system_parameters.value('CN_CUSTOM_FLAG', org_id)

Line 380: cn_srp_quota_assigns_s.nextval

376: ,last_updated_by
377: ,last_update_login
378: ,org_id)
379: SELECT
380: cn_srp_quota_assigns_s.nextval
381: ,pa.srp_plan_assign_id
382: ,q.quota_id
383: ,q.target
384: ,cn_system_parameters.value('CN_CUSTOM_FLAG', q.org_id)

Line 590: l_srp_plan_assign_id cn_srp_quota_assigns.srp_plan_assign_id%TYPE;

586:
587: l_srp_rollover_quota srp_rollover_quota_curs%ROWTYPE;
588:
589: l_count NUMBER := 0;
590: l_srp_plan_assign_id cn_srp_quota_assigns.srp_plan_assign_id%TYPE;
591: l_quota_id cn_srp_quota_assigns.quota_id%TYPE;
592:
593:
594: BEGIN

Line 902: CURSOR l_srp_rollover_quota_csr (c_srp_quota_assign_id cn_srp_quota_assigns.srp_quota_assign_id%TYPE) IS

898: AND quota_id = x_quota_id;
899:
900: recinfo srp_quota_curs%ROWTYPE;
901:
902: CURSOR l_srp_rollover_quota_csr (c_srp_quota_assign_id cn_srp_quota_assigns.srp_quota_assign_id%TYPE) IS
903: SELECT *
904: FROM cn_srp_rollover_quotas_all
905: WHERE srp_quota_assign_id = c_srp_quota_assign_id;
906: