PACKAGE: APPS.CN_SRP_RULE_UPLIFTS_PKG

Source

1 PACKAGE cn_srp_rule_uplifts_pkg as
2 /* $Header: cnsrprus.pls 120.0 2005/06/06 17:45:17 appldev noship $ */
3 
4 /*
5 Date      Name          Description
6 ----------------------------------------------------------------------------+
7 
8 Name
9 
10 Purpose
11 
12 Notes
13 
14 
15 */
16 
17    PROCEDURE insert_record
18   (
19    p_srp_plan_assign_id      NUMBER
20   ,p_quota_id                NUMBER
21   ,p_quota_rule_id           NUMBER
22    ,p_quota_rule_uplift_id   NUMBER := NULL
23    ) ;
24 
25   -- Procedure Name
26   -- Update_record
27   -- Purpose
28   -- Upate  the Quota Rule Uplift from from
29   -- Notes
30   --    +
31 
32   PROCEDURE update_record(
33 			  p_srp_rule_uplift_id           NUMBER
34                           ,p_payment_factor              NUMBER
35 			  ,p_quota_factor                NUMBER
36 			  ,p_last_update_date		 DATE
37 			  ,p_last_updated_by		 NUMBER
38 			  ,p_last_update_login		 NUMBER) ;
39 
40   -- Procedure Name
41   --  Delete_record
42   -- Purpose
43   -- Delete will be called from different place
44   -- 1. Delete the srp_rule_uplift directly.
45   -- 2. delete the srp_quota_rules
46   -- 3. delete the srp_quota_assigns
47   -- 4. delete the quota_assigns
48   -- 5. delete the quota_rule_uplifts
49   -- 6. delete the quota_rules
50   -- 7. delete the quotas.
51 
52   -- Notes
53   --   +
54 
55     PROCEDURE Delete_record
56   (
57    p_srp_plan_assign_id       NUMBER
58    ,p_quota_id                NUMBER
59    ,p_quota_rule_id           NUMBER
60    ,p_quota_rule_uplift_id    NUMBER := NULL
61    ) ;
62 
63   PROCEDURE update_record (p_quota_rule_uplift_id  NUMBER
64 			  ,p_quota_factor   NUMBER
65                           ,p_payment_factor NUMBER) ;
66 
67 END cn_srp_rule_uplifts_pkg;