DBA Data[Home] [Help]

APPS.IBC_CITEM_RUNTIME_PVT dependencies on JTF_NUMBER_TABLE

Line 665: x_content_item_ids OUT NOCOPY JTF_NUMBER_TABLE,

661:
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,

Line 672: l_citem_ids JTF_NUMBER_TABLE;

668: x_return_status OUT NOCOPY VARCHAR2,
669: x_msg_count OUT NOCOPY NUMBER,
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;

Line 673: l_citem_ver_ids JTF_NUMBER_TABLE;

669: x_msg_count OUT NOCOPY NUMBER,
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;

Line 676: l_final_citem_ids JTF_NUMBER_TABLE;

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;
679: --
680: l_count NUMBER := 1;

Line 706: l_final_citem_ids := JTF_NUMBER_TABLE();

702: ,x_citem_version_ids => l_citem_ver_ids
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:

Line 761: p_content_item_ids IN JTF_NUMBER_TABLE,

757:
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,

Line 766: x_content_item_ids OUT NOCOPY 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,
768: x_lang_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
769: x_return_status OUT NOCOPY VARCHAR2,
770: x_msg_count OUT NOCOPY NUMBER,

Line 789: x_content_item_ids := JTF_NUMBER_TABLE();

785: x_return_status := FND_API.G_RET_STS_SUCCESS;
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

Line 953: x_content_item_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,

949: p_associated_object_val2 IN VARCHAR2,
950: p_associated_object_val3 IN VARCHAR2,
951: p_associated_object_val4 IN VARCHAR2,
952: p_associated_object_val5 IN VARCHAR2,
953: x_content_item_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,
954: x_return_status OUT NOCOPY VARCHAR2,
955: x_msg_count OUT NOCOPY NUMBER,
956: x_msg_data OUT NOCOPY VARCHAR2
957: ) AS

Line 980: x_content_item_id_tbl := JTF_NUMBER_TABLE();

976: x_return_status := FND_API.G_RET_STS_SUCCESS;
977:
978: --******************* Real Logic Start *********************
979:
980: x_content_item_id_tbl := JTF_NUMBER_TABLE();
981:
982: FOR citem_id_rec IN Get_Citems_By_Assoc LOOP
983: x_content_item_id_tbl.EXTEND();
984: x_content_item_id_tbl(l_citem_count) := citem_id_rec.content_item_id;