eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBC_CITEM_RUNTIME_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 666: x_label_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,

662: PROCEDURE Bulk_Load (
663: p_init_msg_list IN VARCHAR2,
664: x_clobs OUT NOCOPY JTF_CLOB_TABLE,
665: x_content_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
666: x_label_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
667: x_lang_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
668: x_return_status OUT NOCOPY VARCHAR2,
669: x_msg_count OUT NOCOPY NUMBER,
670: x_msg_data OUT NOCOPY VARCHAR2

Line 667: x_lang_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,

663: p_init_msg_list IN VARCHAR2,
664: x_clobs OUT NOCOPY JTF_CLOB_TABLE,
665: x_content_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
666: x_label_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
667: x_lang_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
668: x_return_status OUT NOCOPY VARCHAR2,
669: x_msg_count OUT NOCOPY NUMBER,
670: x_msg_data OUT NOCOPY VARCHAR2
671: ) AS

Line 674: l_labels JTF_VARCHAR2_TABLE_100;

670: x_msg_data OUT NOCOPY VARCHAR2
671: ) AS
672: l_citem_ids JTF_NUMBER_TABLE;
673: l_citem_ver_ids JTF_NUMBER_TABLE;
674: l_labels JTF_VARCHAR2_TABLE_100;
675: --
676: l_final_citem_ids JTF_NUMBER_TABLE;
677: l_final_labels JTF_VARCHAR2_TABLE_100;
678: l_final_lang_codes JTF_VARCHAR2_TABLE_100;

Line 677: l_final_labels JTF_VARCHAR2_TABLE_100;

673: l_citem_ver_ids JTF_NUMBER_TABLE;
674: l_labels JTF_VARCHAR2_TABLE_100;
675: --
676: l_final_citem_ids JTF_NUMBER_TABLE;
677: l_final_labels JTF_VARCHAR2_TABLE_100;
678: l_final_lang_codes JTF_VARCHAR2_TABLE_100;
679: --
680: l_count NUMBER := 1;
681: l_final_count NUMBER := 1;

Line 678: l_final_lang_codes JTF_VARCHAR2_TABLE_100;

674: l_labels JTF_VARCHAR2_TABLE_100;
675: --
676: l_final_citem_ids JTF_NUMBER_TABLE;
677: l_final_labels JTF_VARCHAR2_TABLE_100;
678: l_final_lang_codes JTF_VARCHAR2_TABLE_100;
679: --
680: l_count NUMBER := 1;
681: l_final_count NUMBER := 1;
682: l_citem_version_id NUMBER;

Line 707: l_final_labels := JTF_VARCHAR2_TABLE_100();

703: ,x_label_codes => l_labels
704: );
705:
706: l_final_citem_ids := JTF_NUMBER_TABLE();
707: l_final_labels := JTF_VARCHAR2_TABLE_100();
708: l_final_lang_codes := JTF_VARCHAR2_TABLE_100();
709:
710:
711: -- Find out what translated languages each version has

Line 708: l_final_lang_codes := JTF_VARCHAR2_TABLE_100();

704: );
705:
706: l_final_citem_ids := JTF_NUMBER_TABLE();
707: l_final_labels := JTF_VARCHAR2_TABLE_100();
708: l_final_lang_codes := JTF_VARCHAR2_TABLE_100();
709:
710:
711: -- Find out what translated languages each version has
712: WHILE (l_count <= l_citem_ver_ids.COUNT) LOOP

Line 762: p_label_codes IN JTF_VARCHAR2_TABLE_100,

758:
759: PROCEDURE Load_Translated_Content_Items (
760: p_init_msg_list IN VARCHAR2,
761: p_content_item_ids IN JTF_NUMBER_TABLE,
762: p_label_codes IN JTF_VARCHAR2_TABLE_100,
763: p_lang_codes IN JTF_VARCHAR2_TABLE_100,
764: p_validate_dates IN VARCHAR2,
765: x_clobs OUT NOCOPY JTF_CLOB_TABLE,
766: x_content_item_ids OUT NOCOPY JTF_NUMBER_TABLE,

Line 763: p_lang_codes IN JTF_VARCHAR2_TABLE_100,

759: PROCEDURE Load_Translated_Content_Items (
760: p_init_msg_list IN VARCHAR2,
761: p_content_item_ids IN JTF_NUMBER_TABLE,
762: p_label_codes IN JTF_VARCHAR2_TABLE_100,
763: p_lang_codes IN JTF_VARCHAR2_TABLE_100,
764: p_validate_dates IN VARCHAR2,
765: x_clobs OUT NOCOPY JTF_CLOB_TABLE,
766: x_content_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
767: x_label_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,

Line 767: x_label_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,

763: p_lang_codes IN JTF_VARCHAR2_TABLE_100,
764: p_validate_dates IN VARCHAR2,
765: x_clobs OUT NOCOPY JTF_CLOB_TABLE,
766: x_content_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
767: x_label_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
768: x_lang_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
769: x_return_status OUT NOCOPY VARCHAR2,
770: x_msg_count OUT NOCOPY NUMBER,
771: x_msg_data OUT NOCOPY VARCHAR2

Line 768: x_lang_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,

764: p_validate_dates IN VARCHAR2,
765: x_clobs OUT NOCOPY JTF_CLOB_TABLE,
766: x_content_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
767: x_label_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
768: x_lang_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
769: x_return_status OUT NOCOPY VARCHAR2,
770: x_msg_count OUT NOCOPY NUMBER,
771: x_msg_data OUT NOCOPY VARCHAR2
772: ) AS

Line 790: x_label_codes := JTF_VARCHAR2_TABLE_100();

786:
787: --******************* Real Logic Start *********************
788: x_clobs := JTF_CLOB_TABLE();
789: x_content_item_ids := JTF_NUMBER_TABLE();
790: x_label_codes := JTF_VARCHAR2_TABLE_100();
791: x_lang_codes := JTF_VARCHAR2_TABLE_100();
792:
793: WHILE (l_citem_id_count <= p_content_item_ids.COUNT) LOOP
794: ------------------------------------------------------

Line 791: x_lang_codes := JTF_VARCHAR2_TABLE_100();

787: --******************* Real Logic Start *********************
788: x_clobs := JTF_CLOB_TABLE();
789: x_content_item_ids := JTF_NUMBER_TABLE();
790: x_label_codes := JTF_VARCHAR2_TABLE_100();
791: x_lang_codes := JTF_VARCHAR2_TABLE_100();
792:
793: WHILE (l_citem_id_count <= p_content_item_ids.COUNT) LOOP
794: ------------------------------------------------------
795: DBMS_LOB.CREATETEMPORARY(l_tmp_clob, TRUE);