DBA Data[Home] [Help]

APPS.IBE_DSP_HIERARCHY_SETUP_PVT dependencies on JTF_NUMBER_TABLE

Line 128: p_inventory_item_ids IN JTF_NUMBER_TABLE,

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,

Line 129: p_organization_ids 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,

Line 132: p_sort_orders IN JTF_NUMBER_TABLE,

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,

Line 134: x_section_item_ids OUT NOCOPY 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,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2

Line 149: p_section_ids IN JTF_NUMBER_TABLE,

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,

Line 152: p_sort_orders IN JTF_NUMBER_TABLE,

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,

Line 154: x_section_item_ids OUT NOCOPY 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,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2

Line 167: p_section_ids IN JTF_NUMBER_TABLE,

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,

Line 168: p_inventory_item_ids IN JTF_NUMBER_TABLE,

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

Line 169: p_organization_ids IN JTF_NUMBER_TABLE,

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: );

Line 181: p_section_item_ids IN JTF_NUMBER_TABLE,

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: );

Line 194: p_mini_site_ids IN JTF_NUMBER_TABLE,

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: );

Line 240: p_mini_site_ids IN JTF_NUMBER_TABLE,

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: );

Line 252: p_msite_section_section_ids IN JTF_NUMBER_TABLE,

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,

Line 253: p_object_version_numbers 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,

Line 256: p_sort_orders IN JTF_NUMBER_TABLE,

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

Line 342: p_layout_comp_id IN JTF_NUMBER_TABLE,

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,

Line 343: p_layout_temp_id IN JTF_NUMBER_TABLE,

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,

Line 344: p_object_versions IN JTF_NUMBER_TABLE,

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,

Line 350: x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,

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

Line 351: x_layout_comp_ids OUT NOCOPY JTF_NUMBER_TABLE

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,

Line 386: x_section_ids IN OUT NOCOPY JTF_NUMBER_TABLE,

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 (

Line 387: x_layout_comp_ids IN OUT NOCOPY JTF_NUMBER_TABLE);

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,