1 PACKAGE cn_quota_rule_uplift_pvt AS
2 /*$Header: cnvrluts.pls 120.2 2005/08/05 00:34:14 fmburu ship $*/
3
4 -- quota rule uplift
5 TYPE quota_rule_uplift_rec_type IS RECORD (
6 org_id NUMBER := NULL,
7 quota_rule_uplift_id NUMBER := NULL,
8 quota_rule_id NUMBER := NULL,
9 start_date DATE := NULL,
10 end_date DATE := NULL,
11 payment_factor NUMBER := NULL,
12 quota_factor NUMBER := NULL,
13 object_version_number cn_quota_rule_uplifts.object_version_number%TYPE := NULL,
14 rev_class_name cn_quota_rules.NAME%TYPE := NULL,
15 rev_class_name_old cn_quota_rules.NAME%TYPE := NULL,
16 start_date_old cn_quota_rule_uplifts.start_date%TYPE := NULL,
17 end_date_old cn_quota_rule_uplifts.end_date%TYPE := NULL
18 );
19
20
21 TYPE quota_rule_uplift_tbl_type IS TABLE OF quota_rule_uplift_rec_type
22 INDEX BY BINARY_INTEGER;
23
24 -- Global variable that represent missing values.
25 g_miss_quota_uplift_rec quota_rule_uplift_rec_type;
26 g_miss_quota_uplift_rec_tb quota_rule_uplift_tbl_type;
27
28 -- Start of comments
29 -- API name : Delete_Quota_Rule_Uplift
30 -- Type : Private.
31 -- Function :
32 -- Pre-reqs : None.
33 -- Parameters :
34 -- IN : p_api_version IN NUMBER Required
35 -- p_init_msg_list IN VARCHAR2 Optional
36 -- Default = FND_API.G_FALSE
37 -- p_commit IN VARCHAR2 Optional
38 -- Default = FND_API.G_FALSE
39 -- p_validation_level IN NUMBER Optional
40 -- Default = FND_API.G_VALID_LEVEL_FULL
41 -- p_quota_rule_uplift IN quota_rule_uplift_rec_type
42 -- OUT : x_return_status OUT VARCHAR2(1)
43 -- x_msg_count OUT NUMBER
44 -- x_msg_data OUT VARCHAR2(2000)
45 -- Version : Current version 1.0
46 -- Notes : Note text
47 --
48 -- End of comments
49 PROCEDURE validate_uplift (
50 p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
52 p_commit IN VARCHAR2 := fnd_api.g_false,
53 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
54 p_action IN VARCHAR2,
55 p_quota_rule_uplift IN OUT NOCOPY quota_rule_uplift_rec_type,
56 p_old_quota_rule_uplift IN quota_rule_uplift_rec_type := g_miss_quota_uplift_rec,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2
60 );
61
62 -- Start of comments
63 -- API name : Create_Quota_Rule_Uplift
64 -- Type : Private.
65 -- Function :
66 -- Pre-reqs : None.
67 -- Parameters :
68 -- IN : p_api_version IN NUMBER Required
69 -- p_init_msg_list IN VARCHAR2 Optional
70 -- Default = FND_API.G_FALSE
71 -- p_commit IN VARCHAR2 Optional
72 -- Default = FND_API.G_FALSE
73 -- p_validation_level IN NUMBER Optional
74 -- Default = FND_API.G_VALID_LEVEL_FULL
75 -- p_quota_rule_uplift IN quota_rule_uplift_rec_type
76 -- OUT : x_return_status OUT VARCHAR2(1)
77 -- x_msg_count OUT NUMBER
78 -- x_msg_data OUT VARCHAR2(2000)
79 -- x_quota_rule_uplift_id OUT NUMBER
80 -- Version : Current version 1.0
81 -- Notes : Note text
82 --
83 -- End of comments
84 PROCEDURE create_uplift (
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
87 p_commit IN VARCHAR2 := fnd_api.g_false,
88 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
89 p_quota_rule_uplift IN OUT NOCOPY quota_rule_uplift_rec_type,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2
93 );
94
95 -- Start of comments
96 -- API name : Update_Quota_Rule_Uplift
97 -- Type : Private.
98 -- Function :
99 -- Pre-reqs : None.
100 -- Parameters :
101 -- IN : p_api_version IN NUMBER Required
102 -- p_init_msg_list IN VARCHAR2 Optional
103 -- Default = FND_API.G_FALSE
104 -- p_commit IN VARCHAR2 Optional
105 -- Default = FND_API.G_FALSE
106 -- p_validation_level IN NUMBER Optional
107 -- Default = FND_API.G_VALID_LEVEL_FULL
108 -- p_quota_rule_uplift IN quota_rule_uplift_rec_type
109 -- OUT : x_return_status OUT VARCHAR2(1)
110 -- x_msg_count OUT NUMBER
111 -- x_msg_data OUT VARCHAR2(2000)
112 -- Version : Current version 1.0
113 -- Notes : Note text
114 --
115 -- End of comments
116 PROCEDURE update_uplift (
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
119 p_commit IN VARCHAR2 := fnd_api.g_false,
120 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
121 p_quota_rule_uplift IN OUT NOCOPY quota_rule_uplift_rec_type,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2
125 );
126
127 -- Start of comments
128 -- API name : Delete_Quota_Rule_Uplift
129 -- Type : Private.
130 -- Function :
131 -- Pre-reqs : None.
132 -- Parameters :
133 -- IN : p_api_version IN NUMBER Required
134 -- p_init_msg_list IN VARCHAR2 Optional
135 -- Default = FND_API.G_FALSE
136 -- p_commit IN VARCHAR2 Optional
137 -- Default = FND_API.G_FALSE
138 -- p_validation_level IN NUMBER Optional
139 -- Default = FND_API.G_VALID_LEVEL_FULL
140 -- p_quota_rule_uplift IN quota_rule_uplift_rec_type
141 -- OUT : x_return_status OUT VARCHAR2(1)
142 -- x_msg_count OUT NUMBER
143 -- x_msg_data OUT VARCHAR2(2000)
144 -- Version : Current version 1.0
145 -- Notes : Note text
146 --
147 -- End of comments
148 PROCEDURE delete_uplift (
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
151 p_commit IN VARCHAR2 := fnd_api.g_false,
152 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
153 p_quota_rule_uplift IN OUT NOCOPY quota_rule_uplift_rec_type,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2
157 );
158
159 END cn_quota_rule_uplift_pvt;