65:
66: --===================================================================
67: TYPE venue_rates_rec_type IS RECORD
68: (
69: rate_id NUMBER := FND_API.G_MISS_NUM,
70: last_update_date DATE := FND_API.G_MISS_DATE,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: creation_date DATE := FND_API.G_MISS_DATE,
73: created_by NUMBER := FND_API.G_MISS_NUM,
66: --===================================================================
67: TYPE venue_rates_rec_type IS RECORD
68: (
69: rate_id NUMBER := FND_API.G_MISS_NUM,
70: last_update_date DATE := FND_API.G_MISS_DATE,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: creation_date DATE := FND_API.G_MISS_DATE,
73: created_by NUMBER := FND_API.G_MISS_NUM,
74: last_update_login NUMBER := FND_API.G_MISS_NUM,
67: TYPE venue_rates_rec_type IS RECORD
68: (
69: rate_id NUMBER := FND_API.G_MISS_NUM,
70: last_update_date DATE := FND_API.G_MISS_DATE,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: creation_date DATE := FND_API.G_MISS_DATE,
73: created_by NUMBER := FND_API.G_MISS_NUM,
74: last_update_login NUMBER := FND_API.G_MISS_NUM,
75: object_version_number NUMBER := FND_API.G_MISS_NUM,
68: (
69: rate_id NUMBER := FND_API.G_MISS_NUM,
70: last_update_date DATE := FND_API.G_MISS_DATE,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: creation_date DATE := FND_API.G_MISS_DATE,
73: created_by NUMBER := FND_API.G_MISS_NUM,
74: last_update_login NUMBER := FND_API.G_MISS_NUM,
75: object_version_number NUMBER := FND_API.G_MISS_NUM,
76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: rate_id NUMBER := FND_API.G_MISS_NUM,
70: last_update_date DATE := FND_API.G_MISS_DATE,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: creation_date DATE := FND_API.G_MISS_DATE,
73: created_by NUMBER := FND_API.G_MISS_NUM,
74: last_update_login NUMBER := FND_API.G_MISS_NUM,
75: object_version_number NUMBER := FND_API.G_MISS_NUM,
76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: venue_id NUMBER := FND_API.G_MISS_NUM,
70: last_update_date DATE := FND_API.G_MISS_DATE,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: creation_date DATE := FND_API.G_MISS_DATE,
73: created_by NUMBER := FND_API.G_MISS_NUM,
74: last_update_login NUMBER := FND_API.G_MISS_NUM,
75: object_version_number NUMBER := FND_API.G_MISS_NUM,
76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: venue_id NUMBER := FND_API.G_MISS_NUM,
78: metric_id NUMBER := FND_API.G_MISS_NUM,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: creation_date DATE := FND_API.G_MISS_DATE,
73: created_by NUMBER := FND_API.G_MISS_NUM,
74: last_update_login NUMBER := FND_API.G_MISS_NUM,
75: object_version_number NUMBER := FND_API.G_MISS_NUM,
76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: venue_id NUMBER := FND_API.G_MISS_NUM,
78: metric_id NUMBER := FND_API.G_MISS_NUM,
79: transactional_value NUMBER := FND_API.G_MISS_NUM,
72: creation_date DATE := FND_API.G_MISS_DATE,
73: created_by NUMBER := FND_API.G_MISS_NUM,
74: last_update_login NUMBER := FND_API.G_MISS_NUM,
75: object_version_number NUMBER := FND_API.G_MISS_NUM,
76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: venue_id NUMBER := FND_API.G_MISS_NUM,
78: metric_id NUMBER := FND_API.G_MISS_NUM,
79: transactional_value NUMBER := FND_API.G_MISS_NUM,
80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
73: created_by NUMBER := FND_API.G_MISS_NUM,
74: last_update_login NUMBER := FND_API.G_MISS_NUM,
75: object_version_number NUMBER := FND_API.G_MISS_NUM,
76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: venue_id NUMBER := FND_API.G_MISS_NUM,
78: metric_id NUMBER := FND_API.G_MISS_NUM,
79: transactional_value NUMBER := FND_API.G_MISS_NUM,
80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
81: functional_value NUMBER := FND_API.G_MISS_NUM,
74: last_update_login NUMBER := FND_API.G_MISS_NUM,
75: object_version_number NUMBER := FND_API.G_MISS_NUM,
76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: venue_id NUMBER := FND_API.G_MISS_NUM,
78: metric_id NUMBER := FND_API.G_MISS_NUM,
79: transactional_value NUMBER := FND_API.G_MISS_NUM,
80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
81: functional_value NUMBER := FND_API.G_MISS_NUM,
82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
75: object_version_number NUMBER := FND_API.G_MISS_NUM,
76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: venue_id NUMBER := FND_API.G_MISS_NUM,
78: metric_id NUMBER := FND_API.G_MISS_NUM,
79: transactional_value NUMBER := FND_API.G_MISS_NUM,
80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
81: functional_value NUMBER := FND_API.G_MISS_NUM,
82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
83: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: venue_id NUMBER := FND_API.G_MISS_NUM,
78: metric_id NUMBER := FND_API.G_MISS_NUM,
79: transactional_value NUMBER := FND_API.G_MISS_NUM,
80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
81: functional_value NUMBER := FND_API.G_MISS_NUM,
82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
83: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: venue_id NUMBER := FND_API.G_MISS_NUM,
78: metric_id NUMBER := FND_API.G_MISS_NUM,
79: transactional_value NUMBER := FND_API.G_MISS_NUM,
80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
81: functional_value NUMBER := FND_API.G_MISS_NUM,
82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
83: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: metric_id NUMBER := FND_API.G_MISS_NUM,
79: transactional_value NUMBER := FND_API.G_MISS_NUM,
80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
81: functional_value NUMBER := FND_API.G_MISS_NUM,
82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
83: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: transactional_value NUMBER := FND_API.G_MISS_NUM,
80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
81: functional_value NUMBER := FND_API.G_MISS_NUM,
82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
83: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
81: functional_value NUMBER := FND_API.G_MISS_NUM,
82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
83: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: functional_value NUMBER := FND_API.G_MISS_NUM,
82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
83: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
83: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
94: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
102: );
95: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
102: );
103:
96: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
102: );
103:
104: g_miss_venue_rates_rec venue_rates_rec_type;
97: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
102: );
103:
104: g_miss_venue_rates_rec venue_rates_rec_type;
105: TYPE venue_rates_tbl_type IS TABLE OF venue_rates_rec_type INDEX BY BINARY_INTEGER;
123: -- Parameters
124: --
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_venue_rates_rec IN venue_rates_rec_type Required
130: --
131: -- OUT
124: --
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_venue_rates_rec IN venue_rates_rec_type Required
130: --
131: -- OUT
132: -- x_return_status OUT VARCHAR2
141: --
142:
143: PROCEDURE Create_Venue_Rates(
144: p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147:
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
142:
143: PROCEDURE Create_Venue_Rates(
144: p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147:
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
165: -- Parameters
166: --
167: -- IN
168: -- p_api_version_number IN NUMBER Required
169: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
170: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
171: -- p_venue_rates_rec IN venue_rates_rec_type Required
172: --
173: -- OUT
166: --
167: -- IN
168: -- p_api_version_number IN NUMBER Required
169: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
170: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
171: -- p_venue_rates_rec IN venue_rates_rec_type Required
172: --
173: -- OUT
174: -- x_return_status OUT VARCHAR2
183: --
184:
185: PROCEDURE Update_Venue_Rates(
186: p_api_version_number IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: p_commit IN VARCHAR2 := FND_API.G_FALSE,
189:
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
184:
185: PROCEDURE Update_Venue_Rates(
186: p_api_version_number IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: p_commit IN VARCHAR2 := FND_API.G_FALSE,
189:
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
207: -- Parameters
208: --
209: -- IN
210: -- p_api_version_number IN NUMBER Required
211: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
212: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
213: -- p_RATE_ID IN NUMBER
214: -- p_object_version_number IN NUMBER Optional Default = NULL
215: --
208: --
209: -- IN
210: -- p_api_version_number IN NUMBER Required
211: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
212: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
213: -- p_RATE_ID IN NUMBER
214: -- p_object_version_number IN NUMBER Optional Default = NULL
215: --
216: -- OUT
226: --
227:
228: PROCEDURE Delete_Venue_Rates(
229: p_api_version_number IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: p_commit IN VARCHAR2 := FND_API.G_FALSE,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
227:
228: PROCEDURE Delete_Venue_Rates(
229: p_api_version_number IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: p_commit IN VARCHAR2 := FND_API.G_FALSE,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_rate_id IN NUMBER,
248: -- Parameters
249: --
250: -- IN
251: -- p_api_version_number IN NUMBER Required
252: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
253: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
254: -- p_venue_rates_rec IN venue_rates_rec_type Required
255: --
256: -- OUT
249: --
250: -- IN
251: -- p_api_version_number IN NUMBER Required
252: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
253: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
254: -- p_venue_rates_rec IN venue_rates_rec_type Required
255: --
256: -- OUT
257: -- x_return_status OUT VARCHAR2
266: --
267:
268: PROCEDURE Lock_Venue_Rates(
269: p_api_version_number IN NUMBER,
270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
271: x_return_status OUT NOCOPY VARCHAR2,
272: x_msg_count OUT NOCOPY NUMBER,
273: x_msg_data OUT NOCOPY VARCHAR2,
274: