30: -- Pre-reqs : None.
31: -- Parameters :
32: -- IN : p_api_version IN NUMBER Required
33: -- p_init_msg_list IN VARCHAR2 Optional
34: -- Default = FND_API.G_FALSE
35: -- p_commit IN VARCHAR2 Optional
36: -- Default = FND_API.G_FALSE
37: -- p_validation_level IN NUMBER Optional
38: -- Default = FND_API.G_VALID_LEVEL_FULL
32: -- IN : p_api_version IN NUMBER Required
33: -- p_init_msg_list IN VARCHAR2 Optional
34: -- Default = FND_API.G_FALSE
35: -- p_commit IN VARCHAR2 Optional
36: -- Default = FND_API.G_FALSE
37: -- p_validation_level IN NUMBER Optional
38: -- Default = FND_API.G_VALID_LEVEL_FULL
39: -- p_quota_rule IN quota_rule_rec_type
40: -- OUT : x_return_status OUT VARCHAR2(1)
34: -- Default = FND_API.G_FALSE
35: -- p_commit IN VARCHAR2 Optional
36: -- Default = FND_API.G_FALSE
37: -- p_validation_level IN NUMBER Optional
38: -- Default = FND_API.G_VALID_LEVEL_FULL
39: -- p_quota_rule IN quota_rule_rec_type
40: -- OUT : x_return_status OUT VARCHAR2(1)
41: -- x_msg_count OUT NUMBER
42: -- x_msg_data OUT VARCHAR2(2000)
45: --
46: -- End of comments
47: PROCEDURE validate_quota_rule (
48: p_api_version IN NUMBER,
49: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
50: p_commit IN VARCHAR2 := fnd_api.g_false,
51: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
52: p_action IN VARCHAR2,
53: p_quota_rule IN OUT NOCOPY quota_rule_rec_type,
46: -- End of comments
47: PROCEDURE validate_quota_rule (
48: p_api_version IN NUMBER,
49: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
50: p_commit IN VARCHAR2 := fnd_api.g_false,
51: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
52: p_action IN VARCHAR2,
53: p_quota_rule IN OUT NOCOPY quota_rule_rec_type,
54: p_old_quota_rule IN quota_rule_rec_type := g_quota_rule_rec,
47: PROCEDURE validate_quota_rule (
48: p_api_version IN NUMBER,
49: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
50: p_commit IN VARCHAR2 := fnd_api.g_false,
51: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
52: p_action IN VARCHAR2,
53: p_quota_rule IN OUT NOCOPY quota_rule_rec_type,
54: p_old_quota_rule IN quota_rule_rec_type := g_quota_rule_rec,
55: x_return_status OUT NOCOPY VARCHAR2,
64: -- Pre-reqs : None.
65: -- Parameters :
66: -- IN : p_api_version IN NUMBER Required
67: -- p_init_msg_list IN VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_commit IN VARCHAR2 Optional
70: -- Default = FND_API.G_FALSE
71: -- p_validation_level IN NUMBER Optional
72: -- Default = FND_API.G_VALID_LEVEL_FULL
66: -- IN : p_api_version IN NUMBER Required
67: -- p_init_msg_list IN VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_commit IN VARCHAR2 Optional
70: -- Default = FND_API.G_FALSE
71: -- p_validation_level IN NUMBER Optional
72: -- Default = FND_API.G_VALID_LEVEL_FULL
73: -- p_quota_rule IN quota_rule_rec_type
74: -- OUT : x_return_status OUT VARCHAR2(1)
68: -- Default = FND_API.G_FALSE
69: -- p_commit IN VARCHAR2 Optional
70: -- Default = FND_API.G_FALSE
71: -- p_validation_level IN NUMBER Optional
72: -- Default = FND_API.G_VALID_LEVEL_FULL
73: -- p_quota_rule IN quota_rule_rec_type
74: -- OUT : x_return_status OUT VARCHAR2(1)
75: -- x_msg_count OUT NUMBER
76: -- x_msg_data OUT VARCHAR2(2000)
80: --
81: -- End of comments
82: PROCEDURE create_quota_rule (
83: p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
85: p_commit IN VARCHAR2 := fnd_api.g_false,
86: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
87: p_quota_rule IN OUT NOCOPY quota_rule_rec_type,
88: x_return_status OUT NOCOPY VARCHAR2,
81: -- End of comments
82: PROCEDURE create_quota_rule (
83: p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
85: p_commit IN VARCHAR2 := fnd_api.g_false,
86: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
87: p_quota_rule IN OUT NOCOPY quota_rule_rec_type,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
82: PROCEDURE create_quota_rule (
83: p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
85: p_commit IN VARCHAR2 := fnd_api.g_false,
86: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
87: p_quota_rule IN OUT NOCOPY quota_rule_rec_type,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
90: x_msg_data OUT NOCOPY VARCHAR2
97: -- Pre-reqs : None.
98: -- Parameters :
99: -- IN : p_api_version IN NUMBER Required
100: -- p_init_msg_list IN VARCHAR2 Optional
101: -- Default = FND_API.G_FALSE
102: -- p_commit IN VARCHAR2 Optional
103: -- Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional
105: -- Default = FND_API.G_VALID_LEVEL_FULL
99: -- IN : p_api_version IN NUMBER Required
100: -- p_init_msg_list IN VARCHAR2 Optional
101: -- Default = FND_API.G_FALSE
102: -- p_commit IN VARCHAR2 Optional
103: -- Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional
105: -- Default = FND_API.G_VALID_LEVEL_FULL
106: -- p_revenue_class_rec_tbl IN quota_rule_rec_type
107: -- OUT : x_return_status OUT VARCHAR2(1)
101: -- Default = FND_API.G_FALSE
102: -- p_commit IN VARCHAR2 Optional
103: -- Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional
105: -- Default = FND_API.G_VALID_LEVEL_FULL
106: -- p_revenue_class_rec_tbl IN quota_rule_rec_type
107: -- OUT : x_return_status OUT VARCHAR2(1)
108: -- x_msg_count OUT NUMBER
109: -- x_msg_data OUT VARCHAR2(2000)
114: -- End of comments
115:
116: PROCEDURE create_quota_rules (
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_name IN VARCHAR2,
122: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
115:
116: PROCEDURE create_quota_rules (
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_name IN VARCHAR2,
122: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
123: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl,
116: PROCEDURE create_quota_rules (
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_name IN VARCHAR2,
122: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
123: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl,
124: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
135: -- Pre-reqs : None.
136: -- Parameters :
137: -- IN : p_api_version IN NUMBER Required
138: -- p_init_msg_list IN VARCHAR2 Optional
139: -- Default = FND_API.G_FALSE
140: -- p_commit IN VARCHAR2 Optional
141: -- Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional
143: -- Default = FND_API.G_VALID_LEVEL_FULL
137: -- IN : p_api_version IN NUMBER Required
138: -- p_init_msg_list IN VARCHAR2 Optional
139: -- Default = FND_API.G_FALSE
140: -- p_commit IN VARCHAR2 Optional
141: -- Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional
143: -- Default = FND_API.G_VALID_LEVEL_FULL
144: -- p_quota_rule IN quota_rule_rec_type
145: -- OUT : x_return_status OUT VARCHAR2(1)
139: -- Default = FND_API.G_FALSE
140: -- p_commit IN VARCHAR2 Optional
141: -- Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional
143: -- Default = FND_API.G_VALID_LEVEL_FULL
144: -- p_quota_rule IN quota_rule_rec_type
145: -- OUT : x_return_status OUT VARCHAR2(1)
146: -- x_msg_count OUT NUMBER
147: -- x_msg_data OUT VARCHAR2(2000)
150: --
151: -- End of comments
152: PROCEDURE update_quota_rule (
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
155: p_commit IN VARCHAR2 := fnd_api.g_false,
156: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
157: p_quota_rule IN OUT NOCOPY quota_rule_rec_type,
158: x_return_status OUT NOCOPY VARCHAR2,
151: -- End of comments
152: PROCEDURE update_quota_rule (
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
155: p_commit IN VARCHAR2 := fnd_api.g_false,
156: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
157: p_quota_rule IN OUT NOCOPY quota_rule_rec_type,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
152: PROCEDURE update_quota_rule (
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
155: p_commit IN VARCHAR2 := fnd_api.g_false,
156: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
157: p_quota_rule IN OUT NOCOPY quota_rule_rec_type,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2
167: -- Pre-reqs : None.
168: -- Parameters :
169: -- IN : p_api_version IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional
171: -- Default = FND_API.G_FALSE
172: -- p_commit IN VARCHAR2 Optional
173: -- Default = FND_API.G_FALSE
174: -- p_validation_level IN NUMBER Optional
175: -- Default = FND_API.G_VALID_LEVEL_FULL
169: -- IN : p_api_version IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional
171: -- Default = FND_API.G_FALSE
172: -- p_commit IN VARCHAR2 Optional
173: -- Default = FND_API.G_FALSE
174: -- p_validation_level IN NUMBER Optional
175: -- Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_quota_rule IN quota_rule_rec_type
177: -- OUT : x_return_status OUT VARCHAR2(1)
171: -- Default = FND_API.G_FALSE
172: -- p_commit IN VARCHAR2 Optional
173: -- Default = FND_API.G_FALSE
174: -- p_validation_level IN NUMBER Optional
175: -- Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_quota_rule IN quota_rule_rec_type
177: -- OUT : x_return_status OUT VARCHAR2(1)
178: -- x_msg_count OUT NUMBER
179: -- x_msg_data OUT VARCHAR2(2000)
182: --
183: -- End of comments
184: PROCEDURE update_quota_rules (
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
187: p_commit IN VARCHAR2 := fnd_api.g_false,
188: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
189: p_quota_name IN VARCHAR2,
190: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
183: -- End of comments
184: PROCEDURE update_quota_rules (
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
187: p_commit IN VARCHAR2 := fnd_api.g_false,
188: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
189: p_quota_name IN VARCHAR2,
190: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
191: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
184: PROCEDURE update_quota_rules (
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
187: p_commit IN VARCHAR2 := fnd_api.g_false,
188: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
189: p_quota_name IN VARCHAR2,
190: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
191: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
192: x_loading_status OUT NOCOPY VARCHAR2,
202: -- Pre-reqs : None.
203: -- Parameters :
204: -- IN : p_api_version IN NUMBER Required
205: -- p_init_msg_list IN VARCHAR2 Optional
206: -- Default = FND_API.G_FALSE
207: -- p_commit IN VARCHAR2 Optional
208: -- Default = FND_API.G_FALSE
209: -- p_validation_level IN NUMBER Optional
210: -- Default = FND_API.G_VALID_LEVEL_FULL
204: -- IN : p_api_version IN NUMBER Required
205: -- p_init_msg_list IN VARCHAR2 Optional
206: -- Default = FND_API.G_FALSE
207: -- p_commit IN VARCHAR2 Optional
208: -- Default = FND_API.G_FALSE
209: -- p_validation_level IN NUMBER Optional
210: -- Default = FND_API.G_VALID_LEVEL_FULL
211: -- p_quota_rule IN quota_rule_rec_type
212: -- OUT : x_return_status OUT VARCHAR2(1)
206: -- Default = FND_API.G_FALSE
207: -- p_commit IN VARCHAR2 Optional
208: -- Default = FND_API.G_FALSE
209: -- p_validation_level IN NUMBER Optional
210: -- Default = FND_API.G_VALID_LEVEL_FULL
211: -- p_quota_rule IN quota_rule_rec_type
212: -- OUT : x_return_status OUT VARCHAR2(1)
213: -- x_msg_count OUT NUMBER
214: -- x_msg_data OUT VARCHAR2(2000)
217: --
218: -- End of comments
219: PROCEDURE delete_quota_rule (
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
222: p_commit IN VARCHAR2 := fnd_api.g_false,
223: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
224: p_quota_rule IN OUT NOCOPY quota_rule_rec_type,
225: x_return_status OUT NOCOPY VARCHAR2,
218: -- End of comments
219: PROCEDURE delete_quota_rule (
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
222: p_commit IN VARCHAR2 := fnd_api.g_false,
223: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
224: p_quota_rule IN OUT NOCOPY quota_rule_rec_type,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
219: PROCEDURE delete_quota_rule (
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
222: p_commit IN VARCHAR2 := fnd_api.g_false,
223: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
224: p_quota_rule IN OUT NOCOPY quota_rule_rec_type,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2
234: -- Pre-reqs : None.
235: -- Parameters :
236: -- IN : p_api_version IN NUMBER Required
237: -- p_init_msg_list IN VARCHAR2 Optional
238: -- Default = FND_API.G_FALSE
239: -- p_commit IN VARCHAR2 Optional
240: -- Default = FND_API.G_FALSE
241: -- p_validation_level IN NUMBER Optional
242: -- Default = FND_API.G_VALID_LEVEL_FULL
236: -- IN : p_api_version IN NUMBER Required
237: -- p_init_msg_list IN VARCHAR2 Optional
238: -- Default = FND_API.G_FALSE
239: -- p_commit IN VARCHAR2 Optional
240: -- Default = FND_API.G_FALSE
241: -- p_validation_level IN NUMBER Optional
242: -- Default = FND_API.G_VALID_LEVEL_FULL
243: -- p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type
244: -- OUT : x_return_status OUT VARCHAR2(1)
238: -- Default = FND_API.G_FALSE
239: -- p_commit IN VARCHAR2 Optional
240: -- Default = FND_API.G_FALSE
241: -- p_validation_level IN NUMBER Optional
242: -- Default = FND_API.G_VALID_LEVEL_FULL
243: -- p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type
244: -- OUT : x_return_status OUT VARCHAR2(1)
245: -- x_msg_count OUT NUMBER
246: -- x_msg_data OUT VARCHAR2(2000)
249: --
250: -- End of comments
251: PROCEDURE delete_quota_rules (
252: p_api_version IN NUMBER,
253: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
254: p_commit IN VARCHAR2 := fnd_api.g_false,
255: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
256: p_quota_name IN VARCHAR2,
257: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
250: -- End of comments
251: PROCEDURE delete_quota_rules (
252: p_api_version IN NUMBER,
253: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
254: p_commit IN VARCHAR2 := fnd_api.g_false,
255: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
256: p_quota_name IN VARCHAR2,
257: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
258: x_return_status OUT NOCOPY VARCHAR2,
251: PROCEDURE delete_quota_rules (
252: p_api_version IN NUMBER,
253: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
254: p_commit IN VARCHAR2 := fnd_api.g_false,
255: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
256: p_quota_name IN VARCHAR2,
257: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,