49:
50: PROCEDURE update_row
51: (
52: p_section_id IN NUMBER,
53: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
54: p_access_name IN VARCHAR2,
55: p_start_date_active IN DATE,
56: p_end_date_active IN DATE,
57: p_section_type_code IN VARCHAR2,
97: PROCEDURE load_row
98: (
99: p_owner IN VARCHAR2,
100: p_section_id IN NUMBER,
101: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
102: p_access_name IN VARCHAR2,
103: p_start_date_active IN DATE,
104: p_end_date_active IN DATE,
105: p_section_type_code IN VARCHAR2,
149:
150: PROCEDURE Create_Section
151: (
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_start_date_active IN DATE,
150: PROCEDURE Create_Section
151: (
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_start_date_active IN DATE,
158: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
151: (
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_start_date_active IN DATE,
158: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
159: p_section_type_code IN VARCHAR2,
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_start_date_active IN DATE,
158: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
159: p_section_type_code IN VARCHAR2,
160: p_status_code IN VARCHAR2,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_start_date_active IN DATE,
158: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
159: p_section_type_code IN VARCHAR2,
160: p_status_code IN VARCHAR2,
161: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
157: p_start_date_active IN DATE,
158: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
159: p_section_type_code IN VARCHAR2,
160: p_status_code IN VARCHAR2,
161: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
163: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
159: p_section_type_code IN VARCHAR2,
160: p_status_code IN VARCHAR2,
161: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
163: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_display_name IN VARCHAR2,
159: p_section_type_code IN VARCHAR2,
160: p_status_code IN VARCHAR2,
161: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
163: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_display_name IN VARCHAR2,
167: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_status_code IN VARCHAR2,
161: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
163: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_display_name IN VARCHAR2,
167: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
163: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_display_name IN VARCHAR2,
167: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_display_name IN VARCHAR2,
167: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_display_name IN VARCHAR2,
167: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_display_name IN VARCHAR2,
167: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_display_name IN VARCHAR2,
167: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: x_section_id OUT NOCOPY NUMBER,
179: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: x_section_id OUT NOCOPY NUMBER,
187: x_return_status OUT NOCOPY VARCHAR2,
180: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: x_section_id OUT NOCOPY NUMBER,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
181: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: x_section_id OUT NOCOPY NUMBER,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2
191:
192: PROCEDURE Update_Section
193: (
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_object_version_number IN NUMBER,
192: PROCEDURE Update_Section
193: (
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_object_version_number IN NUMBER,
200: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: (
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_object_version_number IN NUMBER,
200: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_object_version_number IN NUMBER,
200: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
202: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_object_version_number IN NUMBER,
200: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
202: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
203: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_object_version_number IN NUMBER,
200: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
202: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
203: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_object_version_number IN NUMBER,
200: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
202: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
203: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
206: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_object_version_number IN NUMBER,
200: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
202: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
203: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
206: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
207: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
202: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
203: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
206: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
207: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
202: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
203: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
206: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
207: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
203: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
206: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
207: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
206: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
207: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
206: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
207: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
206: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
207: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
207: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: x_return_status OUT NOCOPY VARCHAR2,
223: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
224: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2
225: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2
233: );
234:
235: PROCEDURE Delete_Section
236: (
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
242: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: PROCEDURE Delete_Section
236: (
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
242: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: x_return_status OUT NOCOPY VARCHAR2,
236: (
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
242: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
242: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
245: x_msg_data OUT NOCOPY VARCHAR2
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
242: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
245: x_msg_data OUT NOCOPY VARCHAR2
246: );
247:
248: PROCEDURE Update_Dsp_Context_To_Null
249: (
250: p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_commit IN VARCHAR2 := FND_API.G_FALSE,
253: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254: p_display_context_id IN NUMBER,
255: x_return_status OUT NOCOPY VARCHAR2,
248: PROCEDURE Update_Dsp_Context_To_Null
249: (
250: p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_commit IN VARCHAR2 := FND_API.G_FALSE,
253: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254: p_display_context_id IN NUMBER,
255: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,
249: (
250: p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_commit IN VARCHAR2 := FND_API.G_FALSE,
253: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254: p_display_context_id IN NUMBER,
255: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,
257: x_msg_data OUT NOCOPY VARCHAR2
259:
260: PROCEDURE Update_Deliverable_To_Null
261: (
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
264: p_commit IN VARCHAR2 := FND_API.G_FALSE,
265: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
266: p_deliverable_id IN NUMBER,
267: x_return_status OUT NOCOPY VARCHAR2,
260: PROCEDURE Update_Deliverable_To_Null
261: (
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
264: p_commit IN VARCHAR2 := FND_API.G_FALSE,
265: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
266: p_deliverable_id IN NUMBER,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,
261: (
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
264: p_commit IN VARCHAR2 := FND_API.G_FALSE,
265: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
266: p_deliverable_id IN NUMBER,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,
269: x_msg_data OUT NOCOPY VARCHAR2
275: P_DESCRIPTION IN VARCHAR2,
276: P_LONG_DESCRIPTION IN VARCHAR2,
277: P_KEYWORDS IN VARCHAR2,
278: P_OWNER IN VARCHAR2,
279: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
280: P_ACCESS_NAME IN VARCHAR2,
281: P_START_DATE_ACTIVE IN VARCHAR2,--IN DATE,
282: P_END_DATE_ACTIVE IN VARCHAR2,-- IN DATE,
283: P_SECTION_TYPE_CODE IN VARCHAR2,