APPS.IBE_M_IBC_INT_PVT dependencies on JTF_NUMBER_TABLE

Line 179: p_content_item_id_tbl IN JTF_NUMBER_TABLE,

175: PROCEDURE Batch_Update_Labels(
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2,
178: p_commit IN VARCHAR2,
179: p_content_item_id_tbl IN JTF_NUMBER_TABLE,
180: p_version_number_tbl IN JTF_NUMBER_TABLE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2)

Line 180: p_version_number_tbl IN JTF_NUMBER_TABLE,

176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2,
178: p_commit IN VARCHAR2,
179: p_content_item_id_tbl IN JTF_NUMBER_TABLE,
180: p_version_number_tbl IN JTF_NUMBER_TABLE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2)
184: IS

Line 331: l_old_item_ids JTF_NUMBER_TABLE;

327: l_return_status VARCHAR2(1);
328: l_msg_count NUMBER;
329: l_msg_data VARCHAR2(2000);
330:
331: l_old_item_ids JTF_NUMBER_TABLE;
332: l_new_item_ids JTF_NUMBER_TABLE;
333: l_assoc_type_codes JTF_VARCHAR2_TABLE_100;
334: l_assoc_objects JTF_VARCHAR2_TABLE_300;
335: l_assoc_objects1 JTF_VARCHAR2_TABLE_300;

Line 332: l_new_item_ids JTF_NUMBER_TABLE;

328: l_msg_count NUMBER;
329: l_msg_data VARCHAR2(2000);
330:
331: l_old_item_ids JTF_NUMBER_TABLE;
332: l_new_item_ids JTF_NUMBER_TABLE;
333: l_assoc_type_codes JTF_VARCHAR2_TABLE_100;
334: l_assoc_objects JTF_VARCHAR2_TABLE_300;
335: l_assoc_objects1 JTF_VARCHAR2_TABLE_300;
336: l_move_flag VARCHAR2(1) := 'N';

Line 438: l_old_item_ids := JTF_NUMBER_TABLE();

434: IBE_UTIL.debug('p_media_object_id IS NULL, RAISE ERROR');
435: END IF;
436: raise FND_API.G_EXC_ERROR;
437: END IF;
438: l_old_item_ids := JTF_NUMBER_TABLE();
439: l_old_item_ids.extend(1);
440: l_old_item_ids(1) := NULL;
441: l_new_item_ids := JTF_NUMBER_TABLE();
442: l_new_item_ids.extend(1);

Line 441: l_new_item_ids := JTF_NUMBER_TABLE();

437: END IF;
438: l_old_item_ids := JTF_NUMBER_TABLE();
439: l_old_item_ids.extend(1);
440: l_old_item_ids(1) := NULL;
441: l_new_item_ids := JTF_NUMBER_TABLE();
442: l_new_item_ids.extend(1);
443: l_new_item_ids(1) := p_new_content_item_id;
444: l_assoc_type_codes := JTF_VARCHAR2_TABLE_100();
445: l_assoc_type_codes.extend(1);

Line 470: l_old_item_ids := JTF_NUMBER_TABLE();

466: IF (p_old_content_item_id <> p_new_content_item_id) THEN
467: IF (l_debug = 'Y') THEN
468: IBE_UTIL.debug('Need to move the label');
469: END IF;
470: l_old_item_ids := JTF_NUMBER_TABLE();
471: l_old_item_ids.extend(1);
472: l_old_item_ids(1) := p_old_content_item_id;
473: l_new_item_ids := JTF_NUMBER_TABLE();
474: l_new_item_ids.extend(1);

Line 473: l_new_item_ids := JTF_NUMBER_TABLE();

469: END IF;
470: l_old_item_ids := JTF_NUMBER_TABLE();
471: l_old_item_ids.extend(1);
472: l_old_item_ids(1) := p_old_content_item_id;
473: l_new_item_ids := JTF_NUMBER_TABLE();
474: l_new_item_ids.extend(1);
475: l_new_item_ids(1) := p_new_content_item_id;
476: l_assoc_type_codes := JTF_VARCHAR2_TABLE_100();
477: l_assoc_type_codes.extend(1);