46:
47: PROCEDURE update_row
48: (
49: p_section_id IN NUMBER,
50: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
51: p_access_name IN VARCHAR2,
52: p_start_date_active IN DATE,
53: p_end_date_active IN DATE,
54: p_section_type_code IN VARCHAR2,
94: PROCEDURE load_row
95: (
96: p_owner IN VARCHAR2,
97: p_section_id IN NUMBER,
98: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
99: p_access_name IN VARCHAR2,
100: p_start_date_active IN DATE,
101: p_end_date_active IN DATE,
102: p_section_type_code IN VARCHAR2,
142:
143: PROCEDURE Create_Section
144: (
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_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_start_date_active IN DATE,
143: PROCEDURE Create_Section
144: (
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_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_start_date_active IN DATE,
151: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
144: (
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_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_start_date_active IN DATE,
151: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
152: p_section_type_code IN VARCHAR2,
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_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_start_date_active IN DATE,
151: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
152: p_section_type_code IN VARCHAR2,
153: p_status_code IN VARCHAR2,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_start_date_active IN DATE,
151: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
152: p_section_type_code IN VARCHAR2,
153: p_status_code IN VARCHAR2,
154: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_start_date_active IN DATE,
151: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
152: p_section_type_code IN VARCHAR2,
153: p_status_code IN VARCHAR2,
154: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
156: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
152: p_section_type_code IN VARCHAR2,
153: p_status_code IN VARCHAR2,
154: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
156: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_display_name IN VARCHAR2,
152: p_section_type_code IN VARCHAR2,
153: p_status_code IN VARCHAR2,
154: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
156: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_display_name IN VARCHAR2,
160: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_status_code IN VARCHAR2,
154: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
156: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_display_name IN VARCHAR2,
160: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
154: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
156: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_display_name IN VARCHAR2,
160: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_display_name IN VARCHAR2,
160: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_display_name IN VARCHAR2,
160: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_display_name IN VARCHAR2,
160: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_display_name IN VARCHAR2,
160: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: x_section_id OUT NUMBER,
172: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: x_section_id OUT NUMBER,
180: x_return_status OUT VARCHAR2,
173: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
174: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: x_section_id OUT NUMBER,
180: x_return_status OUT VARCHAR2,
181: x_msg_count OUT NUMBER,
174: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
175: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: x_section_id OUT NUMBER,
180: x_return_status OUT VARCHAR2,
181: x_msg_count OUT NUMBER,
182: x_msg_data OUT VARCHAR2
184:
185: PROCEDURE Update_Section
186: (
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE,
190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
192: p_object_version_number IN NUMBER,
185: PROCEDURE Update_Section
186: (
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE,
190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
192: p_object_version_number IN NUMBER,
193: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: (
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE,
190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
192: p_object_version_number IN NUMBER,
193: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE,
190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
192: p_object_version_number IN NUMBER,
193: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
195: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE,
190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
192: p_object_version_number IN NUMBER,
193: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
195: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
196: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
192: p_object_version_number IN NUMBER,
193: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
195: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
196: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
191: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
192: p_object_version_number IN NUMBER,
193: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
195: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
196: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
192: p_object_version_number IN NUMBER,
193: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
195: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
196: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
195: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
196: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
195: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
196: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
196: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
211: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
212: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: x_return_status OUT VARCHAR2,
216: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: x_return_status OUT VARCHAR2,
224: x_msg_count OUT NUMBER,
217: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: x_return_status OUT VARCHAR2,
224: x_msg_count OUT NUMBER,
225: x_msg_data OUT VARCHAR2
218: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: x_return_status OUT VARCHAR2,
224: x_msg_count OUT NUMBER,
225: x_msg_data OUT VARCHAR2
226: );
227:
228: PROCEDURE Delete_Section
229: (
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232: p_commit IN VARCHAR2 := FND_API.G_FALSE,
233: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
234: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
235: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: PROCEDURE Delete_Section
229: (
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232: p_commit IN VARCHAR2 := FND_API.G_FALSE,
233: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
234: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
235: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: x_return_status OUT VARCHAR2,
229: (
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232: p_commit IN VARCHAR2 := FND_API.G_FALSE,
233: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
234: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
235: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: x_return_status OUT VARCHAR2,
237: x_msg_count OUT NUMBER,
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232: p_commit IN VARCHAR2 := FND_API.G_FALSE,
233: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
234: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
235: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: x_return_status OUT VARCHAR2,
237: x_msg_count OUT NUMBER,
238: x_msg_data OUT VARCHAR2
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232: p_commit IN VARCHAR2 := FND_API.G_FALSE,
233: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
234: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
235: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: x_return_status OUT VARCHAR2,
237: x_msg_count OUT NUMBER,
238: x_msg_data OUT VARCHAR2
239: );
240:
241: PROCEDURE Update_Dsp_Context_To_Null
242: (
243: p_api_version IN NUMBER,
244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245: p_commit IN VARCHAR2 := FND_API.G_FALSE,
246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
247: p_display_context_id IN NUMBER,
248: x_return_status OUT VARCHAR2,
241: PROCEDURE Update_Dsp_Context_To_Null
242: (
243: p_api_version IN NUMBER,
244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245: p_commit IN VARCHAR2 := FND_API.G_FALSE,
246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
247: p_display_context_id IN NUMBER,
248: x_return_status OUT VARCHAR2,
249: x_msg_count OUT NUMBER,
242: (
243: p_api_version IN NUMBER,
244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245: p_commit IN VARCHAR2 := FND_API.G_FALSE,
246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
247: p_display_context_id IN NUMBER,
248: x_return_status OUT VARCHAR2,
249: x_msg_count OUT NUMBER,
250: x_msg_data OUT VARCHAR2
252:
253: PROCEDURE Update_Deliverable_To_Null
254: (
255: p_api_version IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257: p_commit IN VARCHAR2 := FND_API.G_FALSE,
258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
259: p_deliverable_id IN NUMBER,
260: x_return_status OUT VARCHAR2,
253: PROCEDURE Update_Deliverable_To_Null
254: (
255: p_api_version IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257: p_commit IN VARCHAR2 := FND_API.G_FALSE,
258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
259: p_deliverable_id IN NUMBER,
260: x_return_status OUT VARCHAR2,
261: x_msg_count OUT NUMBER,
254: (
255: p_api_version IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257: p_commit IN VARCHAR2 := FND_API.G_FALSE,
258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
259: p_deliverable_id IN NUMBER,
260: x_return_status OUT VARCHAR2,
261: x_msg_count OUT NUMBER,
262: x_msg_data OUT VARCHAR2