DBA Data[Home] [Help]

APPS.IBC_STYLESHEETS_GRP dependencies on JTF_VARCHAR2_TABLE_100

Line 570: x_stylesheet_lang_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,

566: p_content_item_id IN NUMBER,
567: p_stylesheets_label_code IN VARCHAR2 DEFAULT NULL,
568: x_stylesheet_item_clobs OUT NOCOPY JTF_CLOB_TABLE,
569: x_stylesheet_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
570: x_stylesheet_lang_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
571: x_return_status OUT NOCOPY VARCHAR2,
572: x_msg_count OUT NOCOPY NUMBER,
573: x_msg_data OUT NOCOPY VARCHAR2
574: ) AS

Line 580: l_in_labels JTF_VARCHAR2_TABLE_100;

576: l_api_name CONSTANT VARCHAR2(40) := 'Get_StyleSheet_Items';
577: l_api_version CONSTANT NUMBER := 1.0;
578: --
579: l_in_citem_ids JTF_NUMBER_TABLE;
580: l_in_labels JTF_VARCHAR2_TABLE_100;
581: l_in_lang_codes JTF_VARCHAR2_TABLE_100;
582: --
583: l_out_labels JTF_VARCHAR2_TABLE_100;
584: --

Line 581: l_in_lang_codes JTF_VARCHAR2_TABLE_100;

577: l_api_version CONSTANT NUMBER := 1.0;
578: --
579: l_in_citem_ids JTF_NUMBER_TABLE;
580: l_in_labels JTF_VARCHAR2_TABLE_100;
581: l_in_lang_codes JTF_VARCHAR2_TABLE_100;
582: --
583: l_out_labels JTF_VARCHAR2_TABLE_100;
584: --
585: CURSOR Get_StyleSheet_Ids IS

Line 583: l_out_labels JTF_VARCHAR2_TABLE_100;

579: l_in_citem_ids JTF_NUMBER_TABLE;
580: l_in_labels JTF_VARCHAR2_TABLE_100;
581: l_in_lang_codes JTF_VARCHAR2_TABLE_100;
582: --
583: l_out_labels JTF_VARCHAR2_TABLE_100;
584: --
585: CURSOR Get_StyleSheet_Ids IS
586: select s.CONTENT_ITEM_ID, p_stylesheets_label_code as LABEL,
587: userenv('LANG') as LANG