PACKAGE: APPS.CN_SFP_FORMULA_CMN_PKG

Source

1 Package CN_SFP_FORMULA_CMN_PKG AUTHID CURRENT_USER AS
2   /*$Header: cnvfscms.pls 115.4 2002/11/21 21:13:23 hlchen ship $*/
3 
4  TYPE rates_info_rec_type IS RECORD
5     (
6      comm_rate    NUMBER,
7      minimum_amount   NUMBER,
8      maximum_amount   NUMBER
9      );
10 
11  TYPE rates_info_tbl_type IS TABLE OF rates_info_rec_type INDEX BY BINARY_INTEGER;
12 
13  TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
14 
15  PROCEDURE get_payout_for_attain
16     (
17      p_init_msg_list                 IN      VARCHAR2 := FND_API.G_FALSE    ,
18      p_validation_level              IN      NUMBER  :=
19                   FND_API.G_VALID_LEVEL_FULL,
20      p_srp_quota_cate_id IN NUMBER,
21      p_est_achievement IN NUMBER,
22      p_what_if_flag IN BOOLEAN := FALSE,
23      x_estimated_payout OUT NOCOPY NUMBER,
24      x_return_status OUT NOCOPY VARCHAR2,
25      x_msg_count  OUT NOCOPY     NUMBER,
26      x_msg_data   OUT NOCOPY     VARCHAR2
27      );
28 
29  PROCEDURE get_payout_for_pct_attain
30     (
31      p_init_msg_list                 IN      VARCHAR2 := FND_API.G_FALSE    ,
32      p_validation_level              IN      NUMBER  :=
33                                              FND_API.G_VALID_LEVEL_FULL,
34      p_srp_quota_cate_id IN NUMBER,
35      p_attain_percent IN NUMBER,
36      p_annual_quota IN NUMBER,
37      p_what_if_flag IN BOOLEAN := FALSE,
38      x_estimated_payout OUT NOCOPY NUMBER,
39      x_return_status OUT NOCOPY VARCHAR2,
40      x_msg_count  OUT NOCOPY     NUMBER,
41      x_msg_data   OUT NOCOPY     VARCHAR2
42     ) ;
43 
44   PROCEDURE get_rates
45  (
46     p_srp_quota_cate_id    NUMBER ,
47     p_split_flag		    VARCHAR2 ,
48     p_itd_flag              VARCHAR2,
49     p_amount        IN     NUMBER,
50     x_rate	 OUT NOCOPY 	NUMBER,
51     x_rate_tier_id  OUT NOCOPY     NUMBER,
52     x_tier_split    OUT NOCOPY     NUMBER
53  );
54 
55 
56 END; -- Package spec