DBA Data[Home] [Help]

APPS.IBE_M_IBC_INT_PVT dependencies on JTF_VARCHAR2_TABLE_300

Line 334: l_assoc_objects JTF_VARCHAR2_TABLE_300;

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';
337:
338: l_i NUMBER;

Line 335: l_assoc_objects1 JTF_VARCHAR2_TABLE_300;

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';
337:
338: l_i NUMBER;
339: l_old_item_id NUMBER;

Line 447: l_assoc_objects := JTF_VARCHAR2_TABLE_300();

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);
446: l_assoc_type_codes(1) := g_association_type_code;
447: l_assoc_objects := JTF_VARCHAR2_TABLE_300();
448: l_assoc_objects.extend(1);
449: l_assoc_objects(1) := TO_CHAR(p_media_object_id);
450: l_assoc_objects1 := JTF_VARCHAR2_TABLE_300();
451: l_assoc_objects1.extend(1);

Line 450: l_assoc_objects1 := JTF_VARCHAR2_TABLE_300();

446: l_assoc_type_codes(1) := g_association_type_code;
447: l_assoc_objects := JTF_VARCHAR2_TABLE_300();
448: l_assoc_objects.extend(1);
449: l_assoc_objects(1) := TO_CHAR(p_media_object_id);
450: l_assoc_objects1 := JTF_VARCHAR2_TABLE_300();
451: l_assoc_objects1.extend(1);
452: l_assoc_objects1(1) := NULL;
453: IF (l_debug = 'Y') THEN
454: IBE_UTIL.debug('l_old_item_ids(1) is NULL');

Line 489: l_assoc_objects := JTF_VARCHAR2_TABLE_300();

485: IF (l_debug = 'Y') THEN
486: IBE_UTIL.debug('p_media_object_id IS NULL, move all for content item');
487: END IF;
488: --
489: l_assoc_objects := JTF_VARCHAR2_TABLE_300();
490: l_assoc_objects.extend(1);
491: l_assoc_objects(1) := NULL;
492: l_assoc_objects1 := JTF_VARCHAR2_TABLE_300();
493: l_assoc_objects1.extend(1);

Line 492: l_assoc_objects1 := JTF_VARCHAR2_TABLE_300();

488: --
489: l_assoc_objects := JTF_VARCHAR2_TABLE_300();
490: l_assoc_objects.extend(1);
491: l_assoc_objects(1) := NULL;
492: l_assoc_objects1 := JTF_VARCHAR2_TABLE_300();
493: l_assoc_objects1.extend(1);
494: l_assoc_objects1(1) := NULL;
495: l_move_flag := 'Y';
496: ELSE

Line 500: l_assoc_objects := JTF_VARCHAR2_TABLE_300();

496: ELSE
497: IF (l_debug = 'Y') THEN
498: IBE_UTIL.debug('p_media_object_id is NOT NULL, move specific for content item');
499: END IF;
500: l_assoc_objects := JTF_VARCHAR2_TABLE_300();
501: l_assoc_objects.extend(1);
502: l_assoc_objects(1) := TO_CHAR(p_media_object_id);
503: IF (l_debug = 'Y') THEN
504: IBE_UTIL.debug('l_assoc_objects(1) = '||l_assoc_objects(1));

Line 506: l_assoc_objects1 := JTF_VARCHAR2_TABLE_300();

502: l_assoc_objects(1) := TO_CHAR(p_media_object_id);
503: IF (l_debug = 'Y') THEN
504: IBE_UTIL.debug('l_assoc_objects(1) = '||l_assoc_objects(1));
505: END IF;
506: l_assoc_objects1 := JTF_VARCHAR2_TABLE_300();
507: l_assoc_objects1.extend(1);
508: l_assoc_objects1(1) := NULL;
509: l_move_flag := 'Y';
510: END IF;