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_QUOTA_ASSIGNS_PKG dependencies on CN_SRP_QUOTA_ASSIGNS

Line 1: PACKAGE BODY cn_srp_quota_assigns_pkg as

1: PACKAGE BODY cn_srp_quota_assigns_pkg as
2: -- $Header: cnsrplbb.pls 120.2 2005/09/06 17:40:01 mblum noship $
3:
4: /****************************************************************************
5: Package Body Name

Line 6: cn_srp_quota_assigns_pkg

2: -- $Header: cnsrplbb.pls 120.2 2005/09/06 17:40:01 mblum noship $
3:
4: /****************************************************************************
5: Package Body Name
6: cn_srp_quota_assigns_pkg
7:
8: Purpose
9:
10: History

Line 78: FROM cn_srp_quota_assigns_all csqa

74: INTO l_return
75: FROM
76: (
77: SELECT 'X'
78: FROM cn_srp_quota_assigns_all csqa
79: , cn_quotas_all cq
80: WHERE csqa.srp_quota_assign_id = x_srp_quota_assign_id
81: AND cq.quota_id = x_quota_id
82: AND (

Line 113: FROM cn_srp_quota_assigns_all csqa

109: INTO l_return
110: FROM
111: (
112: SELECT 'X'
113: FROM cn_srp_quota_assigns_all csqa
114: , cn_quota_rules_all cqr
115: , cn_srp_quota_rules_all csqr
116: , cn_quota_rule_uplifts_all cqru
117: , cn_srp_rule_uplifts_all csru

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 229: FROM cn_srp_quota_assigns_all

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;
232:
233: l_srp_quota_assign_c l_srp_quota_assign_csr%ROWTYPE;

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 237: FROM cn_srp_quota_assigns_all

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:
240: l_srp_quota_assign_c2 l_srp_quota_assign_csr2%ROWTYPE;
241:

Line 280: INSERT INTO cn_srp_quota_assigns_all

276:
277: -- inserting a new cn_quota_assign
278: -- called once for each srp_plan_assignment using the comp_plan_id
279:
280: INSERT INTO cn_srp_quota_assigns_all
281: (
282: srp_quota_assign_id
283: ,srp_plan_assign_id
284: ,quota_id

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 361: INSERT INTO cn_srp_quota_assigns_all

357: ELSIF (x_srp_plan_assign_id IS NOT NULL AND x_quota_id IS NULL) THEN
358:
359: -- called from after insert of srp plan assignment
360: -- this is also how plan assign period changes are done
361: INSERT INTO cn_srp_quota_assigns_all
362: (
363: srp_quota_assign_id
364: ,srp_plan_assign_id
365: ,quota_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 499: FROM cn_srp_quota_assigns_all

495: ,x_period_target_unit_code VARCHAR2) IS
496:
497: CURSOR C IS
498: SELECT *
499: FROM cn_srp_quota_assigns_all
500: WHERE srp_quota_assign_id = x_srp_quota_assign_id
501: FOR UPDATE OF srp_quota_assign_id NOWAIT;
502: Recinfo C%ROWTYPE;
503:

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 591: l_quota_id cn_srp_quota_assigns.quota_id%TYPE;

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
595: IF x_srp_quota_assign_id IS NOT NULL THEN

Line 598: UPDATE cn_srp_quota_assigns_all

594: BEGIN
595: IF x_srp_quota_assign_id IS NOT NULL THEN
596:
597: -- Called from srp plan assignment form
598: UPDATE cn_srp_quota_assigns_all
599: SET
600: -- Should be an optional column as it can be null for
601: -- quota types 'revenue' and 'draw'. But it is mandatory and
602: -- this nvl protects against a null value coming back from the

Line 626: FROM cn_srp_quota_assigns_all

622:
623: -- get plan assign ID
624: SELECT srp_plan_assign_id, quota_id
625: INTO l_srp_plan_assign_id, l_quota_id
626: FROM cn_srp_quota_assigns_all
627: WHERE srp_quota_assign_id = x_srp_quota_assign_id;
628:
629: IF IS_CUSTOMIZED(x_srp_quota_assign_id,x_quota_id) > 0 THEN
630: -- rollback all the changes

Line 635: update cn_srp_quota_assigns_all

631:
632: -- revert changes on srp_quota_assign
633: -- to do this, simply delete records so calc will use default rate
634:
635: update cn_srp_quota_assigns_all
636: set (target,
637: payment_amount,
638: performance_goal) =
639: (select target,

Line 735: FROM cn_srp_quota_assigns_all

731: x_customized_flag_old = 'N' THEN
732: -- create srp rate assigns
733: SELECT srp_plan_assign_id, quota_id
734: INTO l_srp_plan_assign_id, l_quota_id
735: FROM cn_srp_quota_assigns_all
736: WHERE srp_quota_assign_id = x_srp_quota_assign_id;
737:
738: cn_srp_rate_assigns_pkg.insert_record
739: (x_srp_plan_assign_id => l_srp_plan_assign_id

Line 796: UPDATE cn_srp_quota_assigns_all

792:
793: -- update the srp quota assigns.
794: -- Payment type code is obsolete, still the below stmt works.
795: -- Modified , removed to check the quota type and payment type
796: UPDATE cn_srp_quota_assigns_all
797: SET target = decode(customized_flag ,'N',x_target ,target)
798: ,payment_amount = decode(customized_flag,'N',x_payment_amount
799: ,payment_amount)
800: ,performance_goal = Decode( customized_flag, 'N', x_performance_goal,

Line 890: FROM CN_SRP_QUOTA_ASSIGNS_ALL

886:
887: CURSOR srp_quota_curs IS
888: Select srp_quota_assign_id
889: , quota_id
890: FROM CN_SRP_QUOTA_ASSIGNS_ALL
891: WHERE srp_plan_assign_id = x_srp_plan_assign_id ;
892:
893: CURSOR srp_quota_curs_quota IS
894: Select srp_quota_assign_id

Line 896: FROM CN_SRP_QUOTA_ASSIGNS_ALL

892:
893: CURSOR srp_quota_curs_quota IS
894: Select srp_quota_assign_id
895: , quota_id
896: FROM CN_SRP_QUOTA_ASSIGNS_ALL
897: WHERE srp_plan_assign_id = x_srp_plan_assign_id
898: AND quota_id = x_quota_id;
899:
900: recinfo srp_quota_curs%ROWTYPE;

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:

Line 945: -- delete from cn_srp_quota_assigns

941: END LOOP;
942: END LOOP;
943: close srp_quota_curs;
944:
945: -- delete from cn_srp_quota_assigns
946: -- where srp_plan_assign_id = x_srp_plan_assign_id ;
947:
948: ELSIF x_srp_plan_assign_id IS NOT NULL AND x_quota_id IS NOT NULL THEN
949:

Line 1005: DELETE FROM cn_srp_quota_assigns_all

1001: ,x_rate_schedule_id => null
1002: ,x_rate_tier_id => null);
1003: END IF;
1004:
1005: DELETE FROM cn_srp_quota_assigns_all
1006: WHERE Srp_plan_assign_id = x_srp_plan_assign_id
1007: AND quota_id = nvl(x_quota_id, quota_id);
1008: END delete_record;
1009:

Line 1010: END CN_SRP_Quota_Assigns_PKG;

1006: WHERE Srp_plan_assign_id = x_srp_plan_assign_id
1007: AND quota_id = nvl(x_quota_id, quota_id);
1008: END delete_record;
1009:
1010: END CN_SRP_Quota_Assigns_PKG;