PACKAGE: APPS.CN_SRP_QUOTA_ASSIGNS_PKG

Source

1 PACKAGE cn_srp_quota_assigns_pkg AUTHID CURRENT_USER as
2 -- $Header: cnsrplbs.pls 115.5 2002/01/23 05:39:49 hlchen ship $
3 --
4 -- Package Body Name
5 --   CNSRPL_quota_assign_PKG
6 -- Purpose
7 --   Form	- CNSRPL
8 --   Block	- quota_assign
9 -- History
10 --   01/26/94		Tony Lower		Created
11 --   06/02/99           Kumar Sivasankaran      Modified
12 
13 PROCEDURE insert_record(
14                         x_srp_plan_assign_id           NUMBER
15 			,x_quota_id                    NUMBER);
16 
17 PROCEDURE lock_record(
18 		       x_srp_quota_assign_id           NUMBER
19                        ,x_target                       NUMBER
20 		       ,x_customized_flag	       VARCHAR2
21 		       ,x_period_target_dist_rule_code VARCHAR2
22 		       ,x_payment_amount	       NUMBER
23                        ,x_performance_goal             NUMBER
24 		       ,x_period_target_unit_code      VARCHAR2);
25 
26 PROCEDURE update_srp_quota(
27 			   x_quota_id		        NUMBER
28 			   ,x_target                    NUMBER
29 			   ,x_payment_amount	        NUMBER
30 			   ,x_performance_goal          NUMBER
31 			   ,x_rate_schedule_id	        NUMBER
32 			   ,x_rate_schedule_id_old      NUMBER
33 			   ,x_disc_rate_schedule_id     NUMBER
34 			   ,x_disc_rate_schedule_id_old NUMBER
35 			   ,x_payment_type_code		VARCHAR2
36 			   ,x_payment_type_code_old	VARCHAR2
37 			   ,x_quota_type_code		VARCHAR2
38 			   ,x_quota_type_code_old	VARCHAR2
39 			   ,x_period_type_code	        VARCHAR2
40 			   ,x_calc_formula_id           NUMBER := NULL
41 			   ,x_calc_formula_id_old       NUMBER := NULL);
42 
43 PROCEDURE update_record(
44 			 x_srp_quota_assign_id           NUMBER
45 			 ,x_target                       NUMBER
46 			 ,x_target_old                   NUMBER
47 			 ,x_start_period_id		 NUMBER
48 			 ,x_salesrep_id			 NUMBER
49 			 ,x_Customized_Flag              VARCHAR2
50 			 ,x_Customized_Flag_old          VARCHAR2
51 			 ,x_quota_id			 NUMBER
52 			 ,x_rate_schedule_id		 NUMBER
53 			 ,x_period_target_dist_rule_code VARCHAR2
54 			 ,x_attributes_changed		 VARCHAR2
55 			 ,x_distribute_target_flag	 VARCHAR2
56 			 ,x_payment_amount		 NUMBER
57 			 ,x_payment_amount_old		 NUMBER
58 			 ,x_performance_goal             NUMBER
59 			 ,x_performance_goal_old         NUMBER
60 			 ,x_quota_type_code	         VARCHAR2
61 			 ,x_period_target_unit_code	 VARCHAR2
62 			 ,x_last_update_date		 DATE
63 			 ,x_last_updated_by		 NUMBER
64 			 ,x_last_update_login		 NUMBER);
65 
66 PROCEDURE Delete_Record(
67 			 x_srp_plan_assign_id  		 NUMBER
68 			 ,x_quota_id	       		 NUMBER);
69 
70 
71   END cn_srp_quota_assigns_pkg;