27: -- Pre-reqs : None.
28: -- Parameters :
29: -- IN : p_api_version IN NUMBER Required
30: -- p_init_msg_list IN VARCHAR2 Optional
31: -- Default = FND_API.G_FALSE
32: -- p_commit IN VARCHAR2 Optional
33: -- Default = FND_API.G_FALSE
34: -- p_validation_level IN NUMBER Optional
35: -- Default = FND_API.G_VALID_LEVEL_FULL
29: -- IN : p_api_version IN NUMBER Required
30: -- p_init_msg_list IN VARCHAR2 Optional
31: -- Default = FND_API.G_FALSE
32: -- p_commit IN VARCHAR2 Optional
33: -- Default = FND_API.G_FALSE
34: -- p_validation_level IN NUMBER Optional
35: -- Default = FND_API.G_VALID_LEVEL_FULL
36: -- p_trx_factor IN trx_factor_rec_type
37: -- OUT : x_return_status OUT VARCHAR2(1)
31: -- Default = FND_API.G_FALSE
32: -- p_commit IN VARCHAR2 Optional
33: -- Default = FND_API.G_FALSE
34: -- p_validation_level IN NUMBER Optional
35: -- Default = FND_API.G_VALID_LEVEL_FULL
36: -- p_trx_factor IN trx_factor_rec_type
37: -- OUT : x_return_status OUT VARCHAR2(1)
38: -- x_msg_count OUT NUMBER
39: -- x_msg_data OUT VARCHAR2(2000)
43: --
44: -- End of comments
45: PROCEDURE validate_trx_factor (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
48: p_commit IN VARCHAR2 := fnd_api.g_false,
49: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
50: p_action IN VARCHAR2,
51: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
44: -- End of comments
45: PROCEDURE validate_trx_factor (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
48: p_commit IN VARCHAR2 := fnd_api.g_false,
49: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
50: p_action IN VARCHAR2,
51: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
52: p_old_trx_factor IN trx_factor_rec_type := g_miss_trx_factor_rec,
45: PROCEDURE validate_trx_factor (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
48: p_commit IN VARCHAR2 := fnd_api.g_false,
49: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
50: p_action IN VARCHAR2,
51: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
52: p_old_trx_factor IN trx_factor_rec_type := g_miss_trx_factor_rec,
53: x_return_status OUT NOCOPY VARCHAR2,
62: -- Pre-reqs : None.
63: -- Parameters :
64: -- IN : p_api_version IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- p_commit IN VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_validation_level IN NUMBER Optional
70: -- Default = FND_API.G_VALID_LEVEL_FULL
64: -- IN : p_api_version IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- p_commit IN VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_validation_level IN NUMBER Optional
70: -- Default = FND_API.G_VALID_LEVEL_FULL
71: -- p_trx_factor IN trx_factor_rec_type
72: -- OUT : x_return_status OUT VARCHAR2(1)
66: -- Default = FND_API.G_FALSE
67: -- p_commit IN VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_validation_level IN NUMBER Optional
70: -- Default = FND_API.G_VALID_LEVEL_FULL
71: -- p_trx_factor IN trx_factor_rec_type
72: -- OUT : x_return_status OUT VARCHAR2(1)
73: -- x_msg_count OUT NUMBER
74: -- x_msg_data OUT VARCHAR2(2000)
78: --
79: -- End of comments
80: PROCEDURE create_trx_factor (
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
83: p_commit IN VARCHAR2 := fnd_api.g_false,
84: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
85: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
86: x_return_status OUT NOCOPY VARCHAR2,
79: -- End of comments
80: PROCEDURE create_trx_factor (
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
83: p_commit IN VARCHAR2 := fnd_api.g_false,
84: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
85: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
80: PROCEDURE create_trx_factor (
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
83: p_commit IN VARCHAR2 := fnd_api.g_false,
84: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
85: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2
95: -- Pre-reqs : None.
96: -- Parameters :
97: -- IN : p_api_version IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Optional
99: -- Default = FND_API.G_FALSE
100: -- p_commit IN VARCHAR2 Optional
101: -- Default = FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Optional
103: -- Default = FND_API.G_VALID_LEVEL_FULL
97: -- IN : p_api_version IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Optional
99: -- Default = FND_API.G_FALSE
100: -- p_commit IN VARCHAR2 Optional
101: -- Default = FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Optional
103: -- Default = FND_API.G_VALID_LEVEL_FULL
104: -- p_trx_factor IN trx_factor_rec_type
105: -- OUT : x_return_status OUT VARCHAR2(1)
99: -- Default = FND_API.G_FALSE
100: -- p_commit IN VARCHAR2 Optional
101: -- Default = FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Optional
103: -- Default = FND_API.G_VALID_LEVEL_FULL
104: -- p_trx_factor IN trx_factor_rec_type
105: -- OUT : x_return_status OUT VARCHAR2(1)
106: -- x_msg_count OUT NUMBER
107: -- x_msg_data OUT VARCHAR2(2000)
110: --
111: -- End of comments
112: PROCEDURE update_trx_factor (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
115: p_commit IN VARCHAR2 := fnd_api.g_false,
116: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
117: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
118: x_return_status OUT NOCOPY VARCHAR2,
111: -- End of comments
112: PROCEDURE update_trx_factor (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
115: p_commit IN VARCHAR2 := fnd_api.g_false,
116: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
117: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
112: PROCEDURE update_trx_factor (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
115: p_commit IN VARCHAR2 := fnd_api.g_false,
116: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
117: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2
127: -- Pre-reqs : None.
128: -- Parameters :
129: -- IN : p_api_version IN NUMBER Required
130: -- p_init_msg_list IN VARCHAR2 Optional
131: -- Default = FND_API.G_FALSE
132: -- p_commit IN VARCHAR2 Optional
133: -- Default = FND_API.G_FALSE
134: -- p_validation_level IN NUMBER Optional
135: -- Default = FND_API.G_VALID_LEVEL_FULL
129: -- IN : p_api_version IN NUMBER Required
130: -- p_init_msg_list IN VARCHAR2 Optional
131: -- Default = FND_API.G_FALSE
132: -- p_commit IN VARCHAR2 Optional
133: -- Default = FND_API.G_FALSE
134: -- p_validation_level IN NUMBER Optional
135: -- Default = FND_API.G_VALID_LEVEL_FULL
136: -- p_trx_factor IN trx_factor_rec_type
137: -- OUT : x_return_status OUT VARCHAR2(1)
131: -- Default = FND_API.G_FALSE
132: -- p_commit IN VARCHAR2 Optional
133: -- Default = FND_API.G_FALSE
134: -- p_validation_level IN NUMBER Optional
135: -- Default = FND_API.G_VALID_LEVEL_FULL
136: -- p_trx_factor IN trx_factor_rec_type
137: -- OUT : x_return_status OUT VARCHAR2(1)
138: -- x_msg_count OUT NUMBER
139: -- x_msg_data OUT VARCHAR2(2000)
142: --
143: -- End of comments
144: PROCEDURE delete_trx_factor (
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
147: p_commit IN VARCHAR2 := fnd_api.g_false,
148: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
149: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
150: x_return_status OUT NOCOPY VARCHAR2,
143: -- End of comments
144: PROCEDURE delete_trx_factor (
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
147: p_commit IN VARCHAR2 := fnd_api.g_false,
148: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
149: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
144: PROCEDURE delete_trx_factor (
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
147: p_commit IN VARCHAR2 := fnd_api.g_false,
148: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
149: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2
159: -- Pre-reqs : None.
160: -- Parameters :
161: -- IN : p_api_version IN NUMBER Required
162: -- p_init_msg_list IN VARCHAR2 Optional
163: -- Default = FND_API.G_FALSE
164: -- p_commit IN VARCHAR2 Optional
165: -- Default = FND_API.G_FALSE
166: -- p_validation_level IN NUMBER Optional
167: -- Default = FND_API.G_VALID_LEVEL_FULL
161: -- IN : p_api_version IN NUMBER Required
162: -- p_init_msg_list IN VARCHAR2 Optional
163: -- Default = FND_API.G_FALSE
164: -- p_commit IN VARCHAR2 Optional
165: -- Default = FND_API.G_FALSE
166: -- p_validation_level IN NUMBER Optional
167: -- Default = FND_API.G_VALID_LEVEL_FULL
168: -- p_quota_rule_id IN NUMBER
169: -- OUT : x_return_status OUT VARCHAR2(1)
163: -- Default = FND_API.G_FALSE
164: -- p_commit IN VARCHAR2 Optional
165: -- Default = FND_API.G_FALSE
166: -- p_validation_level IN NUMBER Optional
167: -- Default = FND_API.G_VALID_LEVEL_FULL
168: -- p_quota_rule_id IN NUMBER
169: -- OUT : x_return_status OUT VARCHAR2(1)
170: -- x_msg_count OUT NUMBER
171: -- x_msg_data OUT VARCHAR2(2000)
175: --
176: -- End of comments
177: PROCEDURE get_trx_factor (
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
180: p_commit IN VARCHAR2 := fnd_api.g_false,
181: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
182: p_quota_rule_id IN NUMBER,
183: x_trx_factor OUT NOCOPY trx_factor_tbl_type,
176: -- End of comments
177: PROCEDURE get_trx_factor (
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
180: p_commit IN VARCHAR2 := fnd_api.g_false,
181: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
182: p_quota_rule_id IN NUMBER,
183: x_trx_factor OUT NOCOPY trx_factor_tbl_type,
184: x_return_status OUT NOCOPY VARCHAR2,
177: PROCEDURE get_trx_factor (
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
180: p_commit IN VARCHAR2 := fnd_api.g_false,
181: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
182: p_quota_rule_id IN NUMBER,
183: x_trx_factor OUT NOCOPY trx_factor_tbl_type,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
193: -- Pre-reqs : None.
194: -- Parameters :
195: -- IN : p_api_version IN NUMBER Required
196: -- p_init_msg_list IN VARCHAR2 Optional
197: -- Default = FND_API.G_FALSE
198: -- p_commit IN VARCHAR2 Optional
199: -- Default = FND_API.G_FALSE
200: -- p_validation_level IN NUMBER Optional
201: -- Default = FND_API.G_VALID_LEVEL_FULL
195: -- IN : p_api_version IN NUMBER Required
196: -- p_init_msg_list IN VARCHAR2 Optional
197: -- Default = FND_API.G_FALSE
198: -- p_commit IN VARCHAR2 Optional
199: -- Default = FND_API.G_FALSE
200: -- p_validation_level IN NUMBER Optional
201: -- Default = FND_API.G_VALID_LEVEL_FULL
202: -- p_trx_factor IN trx_factor_rec_type
203: -- OUT : x_return_status OUT VARCHAR2(1)
197: -- Default = FND_API.G_FALSE
198: -- p_commit IN VARCHAR2 Optional
199: -- Default = FND_API.G_FALSE
200: -- p_validation_level IN NUMBER Optional
201: -- Default = FND_API.G_VALID_LEVEL_FULL
202: -- p_trx_factor IN trx_factor_rec_type
203: -- OUT : x_return_status OUT VARCHAR2(1)
204: -- x_msg_count OUT NUMBER
205: -- x_msg_data OUT VARCHAR2(2000)
209: --
210: -- End of comments
211: PROCEDURE update_trx_factors (
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
214: p_commit IN VARCHAR2 := fnd_api.g_false,
215: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
216: p_org_id IN NUMBER,
217: p_quota_name IN VARCHAR2,
210: -- End of comments
211: PROCEDURE update_trx_factors (
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
214: p_commit IN VARCHAR2 := fnd_api.g_false,
215: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
216: p_org_id IN NUMBER,
217: p_quota_name IN VARCHAR2,
218: p_revenue_class_name IN VARCHAR2 := NULL,
211: PROCEDURE update_trx_factors (
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
214: p_commit IN VARCHAR2 := fnd_api.g_false,
215: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
216: p_org_id IN NUMBER,
217: p_quota_name IN VARCHAR2,
218: p_revenue_class_name IN VARCHAR2 := NULL,
219: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,