1 PACKAGE cn_srp_rate_assigns_pkg AUTHID CURRENT_USER as
2 -- $Header: cnsrplcs.pls 115.7 2002/01/23 05:39:56 hlchen ship $
3 --
4 -- Package Body Name
5 --
6 -- Purpose
7 -- Form - cnsrmt cnpldf
8 -- Block - rate_assign
9 -- History
10 -- 26-JAN-94 Tony Lower Created
11 -- 10-FEB-94 P Cook Table handler conversion and unit test
12 -- 10-JUN-99 S Kumar Modified the Table handler for the New reqmts
13
14 PROCEDURE Insert_Record(
15 X_Srp_Plan_Assign_Id NUMBER
16 ,X_Srp_Quota_Assign_Id NUMBER
17 ,X_Srp_Rate_Assign_Id NUMBER
18 ,X_quota_id NUMBER
19 ,X_rate_schedule_id NUMBER
20 ,x_rt_quota_asgn_id NUMBER := null
21 ,X_Rate_Tier_Id NUMBER
22 ,X_Commission_Rate NUMBER
23 ,x_commission_amount NUMBER
24 ,x_disc_rate_table_flag VARCHAR2
25 ,x_rate_sequence NUMBER := null
26 );
27
28 PROCEDURE Lock_Record(
29 X_Srp_Plan_Assign_Id NUMBER
30 ,X_Srp_Quota_Assign_Id NUMBER
31 ,X_Srp_Rate_Assign_Id NUMBER
32 ,X_Rate_Tier_Id NUMBER
33 ,X_Commission_Rate NUMBER
34 ,x_commission_amount NUMBER);
35
36 PROCEDURE Update_Record(
37 X_Srp_Plan_Assign_Id NUMBER
38 ,X_Srp_Quota_Assign_Id NUMBER
39 ,X_Srp_Rate_Assign_Id NUMBER
40 ,X_Rate_Tier_Id NUMBER
41 ,X_Commission_Rate NUMBER
42 ,X_Commission_Rate_old NUMBER
43 ,x_start_period_id NUMBER
44 ,x_salesrep_id NUMBER
45 ,x_commission_amount NUMBER
46 ,x_commission_amount_old NUMBER
47 ,x_last_update_date DATE
48 ,x_last_updated_by NUMBER
49 ,x_last_update_login NUMBER);
50
51 PROCEDURE Delete_record(
52 x_srp_plan_assign_id NUMBER
53 ,x_srp_rate_assign_id NUMBER
54 ,x_quota_id NUMBER
55 ,x_rate_schedule_id NUMBER
56 ,x_rt_quota_asgn_id NUMBER := null
57 ,x_rate_tier_id NUMBER);
58
59 PROCEDURE synch_rate(
60 x_srp_plan_assign_id NUMBER
61 ,x_srp_quota_assign_id NUMBER
62 ,x_rate_schedule_id NUMBER
63 ,x_rate_tier_id NUMBER
64 ,x_commission_rate NUMBER
65 ,x_salesrep_id NUMBER
66 ,x_start_period_id NUMBER
67 ,x_commission_amount NUMBER);
68
69
70 END cn_srp_rate_assigns_pkg;