124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125: p_commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: p_section_id IN NUMBER,
128: p_inventory_item_ids IN JTF_NUMBER_TABLE,
129: p_organization_ids IN JTF_NUMBER_TABLE,
130: p_start_date_actives IN JTF_DATE_TABLE,
131: p_end_date_actives IN JTF_DATE_TABLE,
132: p_sort_orders IN JTF_NUMBER_TABLE,
125: p_commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: p_section_id IN NUMBER,
128: p_inventory_item_ids IN JTF_NUMBER_TABLE,
129: p_organization_ids IN JTF_NUMBER_TABLE,
130: p_start_date_actives IN JTF_DATE_TABLE,
131: p_end_date_actives IN JTF_DATE_TABLE,
132: p_sort_orders IN JTF_NUMBER_TABLE,
133: p_association_reason_codes IN JTF_VARCHAR2_TABLE_300,
128: p_inventory_item_ids IN JTF_NUMBER_TABLE,
129: p_organization_ids IN JTF_NUMBER_TABLE,
130: p_start_date_actives IN JTF_DATE_TABLE,
131: p_end_date_actives IN JTF_DATE_TABLE,
132: p_sort_orders IN JTF_NUMBER_TABLE,
133: p_association_reason_codes IN JTF_VARCHAR2_TABLE_300,
134: x_section_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
135: x_duplicate_association_status OUT NOCOPY VARCHAR2,
136: x_return_status OUT NOCOPY VARCHAR2,
130: p_start_date_actives IN JTF_DATE_TABLE,
131: p_end_date_actives IN JTF_DATE_TABLE,
132: p_sort_orders IN JTF_NUMBER_TABLE,
133: p_association_reason_codes IN JTF_VARCHAR2_TABLE_300,
134: x_section_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
135: x_duplicate_association_status OUT NOCOPY VARCHAR2,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_inventory_item_id IN NUMBER,
148: p_organization_id IN NUMBER,
149: p_section_ids IN JTF_NUMBER_TABLE,
150: p_start_date_actives IN JTF_DATE_TABLE,
151: p_end_date_actives IN JTF_DATE_TABLE,
152: p_sort_orders IN JTF_NUMBER_TABLE,
153: p_association_reason_codes IN JTF_VARCHAR2_TABLE_300,
148: p_organization_id IN NUMBER,
149: p_section_ids IN JTF_NUMBER_TABLE,
150: p_start_date_actives IN JTF_DATE_TABLE,
151: p_end_date_actives IN JTF_DATE_TABLE,
152: p_sort_orders IN JTF_NUMBER_TABLE,
153: p_association_reason_codes IN JTF_VARCHAR2_TABLE_300,
154: x_section_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
155: x_duplicate_association_status OUT NOCOPY VARCHAR2,
156: x_return_status OUT NOCOPY VARCHAR2,
150: p_start_date_actives IN JTF_DATE_TABLE,
151: p_end_date_actives IN JTF_DATE_TABLE,
152: p_sort_orders IN JTF_NUMBER_TABLE,
153: p_association_reason_codes IN JTF_VARCHAR2_TABLE_300,
154: x_section_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
155: x_duplicate_association_status OUT NOCOPY VARCHAR2,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: p_section_ids IN JTF_NUMBER_TABLE,
168: p_inventory_item_ids IN JTF_NUMBER_TABLE,
169: p_organization_ids IN JTF_NUMBER_TABLE,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: p_section_ids IN JTF_NUMBER_TABLE,
168: p_inventory_item_ids IN JTF_NUMBER_TABLE,
169: p_organization_ids IN JTF_NUMBER_TABLE,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: p_section_ids IN JTF_NUMBER_TABLE,
168: p_inventory_item_ids IN JTF_NUMBER_TABLE,
169: p_organization_ids IN JTF_NUMBER_TABLE,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2
173: );
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_commit IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: p_section_item_ids IN JTF_NUMBER_TABLE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2
185: );
190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: p_section_id IN NUMBER,
194: p_mini_site_ids IN JTF_NUMBER_TABLE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2
198: );
236: p_commit IN VARCHAR2 := FND_API.G_FALSE,
237: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
238: p_inventory_item_id IN NUMBER,
239: p_organization_id IN NUMBER,
240: p_mini_site_ids IN JTF_NUMBER_TABLE,
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,
243: x_msg_data OUT NOCOPY VARCHAR2
244: );
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
253: p_object_version_numbers IN JTF_NUMBER_TABLE,
254: p_start_date_actives IN JTF_DATE_TABLE,
255: p_end_date_actives IN JTF_DATE_TABLE,
256: p_sort_orders IN JTF_NUMBER_TABLE,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
253: p_object_version_numbers IN JTF_NUMBER_TABLE,
254: p_start_date_actives IN JTF_DATE_TABLE,
255: p_end_date_actives IN JTF_DATE_TABLE,
256: p_sort_orders IN JTF_NUMBER_TABLE,
257: p_delete_flags IN JTF_VARCHAR2_TABLE_300,
252: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
253: p_object_version_numbers IN JTF_NUMBER_TABLE,
254: p_start_date_actives IN JTF_DATE_TABLE,
255: p_end_date_actives IN JTF_DATE_TABLE,
256: p_sort_orders IN JTF_NUMBER_TABLE,
257: p_delete_flags IN JTF_VARCHAR2_TABLE_300,
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2
338: p_commit IN VARCHAR2 := FND_API.G_FALSE,
339: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
340: p_section_id IN NUMBER,
341: p_layout_id IN NUMBER,
342: p_layout_comp_id IN JTF_NUMBER_TABLE,
343: p_layout_temp_id IN JTF_NUMBER_TABLE,
344: p_object_versions IN JTF_NUMBER_TABLE,
345: p_actionflags IN JTF_VARCHAR2_TABLE_100,
346: p_cascading_flag IN NUMBER := 0,
339: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
340: p_section_id IN NUMBER,
341: p_layout_id IN NUMBER,
342: p_layout_comp_id IN JTF_NUMBER_TABLE,
343: p_layout_temp_id IN JTF_NUMBER_TABLE,
344: p_object_versions IN JTF_NUMBER_TABLE,
345: p_actionflags IN JTF_VARCHAR2_TABLE_100,
346: p_cascading_flag IN NUMBER := 0,
347: x_return_status OUT NOCOPY VARCHAR2,
340: p_section_id IN NUMBER,
341: p_layout_id IN NUMBER,
342: p_layout_comp_id IN JTF_NUMBER_TABLE,
343: p_layout_temp_id IN JTF_NUMBER_TABLE,
344: p_object_versions IN JTF_NUMBER_TABLE,
345: p_actionflags IN JTF_VARCHAR2_TABLE_100,
346: p_cascading_flag IN NUMBER := 0,
347: x_return_status OUT NOCOPY VARCHAR2,
348: x_msg_count OUT NOCOPY NUMBER,
346: p_cascading_flag IN NUMBER := 0,
347: x_return_status OUT NOCOPY VARCHAR2,
348: x_msg_count OUT NOCOPY NUMBER,
349: x_msg_data OUT NOCOPY VARCHAR2,
350: x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,
351: x_layout_comp_ids OUT NOCOPY JTF_NUMBER_TABLE
352: );
353:
354: PROCEDURE Update_Section_Dlv_Ctx
347: x_return_status OUT NOCOPY VARCHAR2,
348: x_msg_count OUT NOCOPY NUMBER,
349: x_msg_data OUT NOCOPY VARCHAR2,
350: x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,
351: x_layout_comp_ids OUT NOCOPY JTF_NUMBER_TABLE
352: );
353:
354: PROCEDURE Update_Section_Dlv_Ctx
355: (p_api_version IN NUMBER,
382: p_target_section_id IN NUMBER,
383: x_return_status OUT NOCOPY VARCHAR2,
384: x_msg_count OUT NOCOPY NUMBER,
385: x_msg_data OUT NOCOPY VARCHAR2,
386: x_section_ids IN OUT NOCOPY JTF_NUMBER_TABLE,
387: x_layout_comp_ids IN OUT NOCOPY JTF_NUMBER_TABLE);
388:
389:
390: PROCEDURE Batch_Cascade_Sec_Layout_Map (
383: x_return_status OUT NOCOPY VARCHAR2,
384: x_msg_count OUT NOCOPY NUMBER,
385: x_msg_data OUT NOCOPY VARCHAR2,
386: x_section_ids IN OUT NOCOPY JTF_NUMBER_TABLE,
387: x_layout_comp_ids IN OUT NOCOPY JTF_NUMBER_TABLE);
388:
389:
390: PROCEDURE Batch_Cascade_Sec_Layout_Map (
391: errbuf OUT NOCOPY VARCHAR2,