APPS.EGO_PUB_WS_UTIL dependencies on DBMS_SQL

Line 1046: l_system_code_tab dbms_sql.varchar2_table;

1042: p_web_service_name VARCHAR2 DEFAULT NULL)
1043: IS
1044:
1045: l_mode VARCHAR2(10);
1046: l_system_code_tab dbms_sql.varchar2_table;
1047: l_system_name_tab dbms_sql.varchar2_table;
1048:
1049: l_systemcode_xpath VARCHAR2(200):=p_system_search_str||'/SystemCode';
1050: l_systemname_xpath VARCHAR2(200):=p_system_search_str||'/SystemName';

Line 1047: l_system_name_tab dbms_sql.varchar2_table;

1043: IS
1044:
1045: l_mode VARCHAR2(10);
1046: l_system_code_tab dbms_sql.varchar2_table;
1047: l_system_name_tab dbms_sql.varchar2_table;
1048:
1049: l_systemcode_xpath VARCHAR2(200):=p_system_search_str||'/SystemCode';
1050: l_systemname_xpath VARCHAR2(200):=p_system_search_str||'/SystemName';
1051: l_codes_provided VARCHAR(3):='Y';

Line 1431: l_lang_code_tab dbms_sql.varchar2_table;

1427: p_lang_search_str IN VARCHAR2,
1428: p_web_service_name IN VARCHAR2 DEFAULT NULL)
1429: IS
1430:
1431: l_lang_code_tab dbms_sql.varchar2_table;
1432: l_lang_name_tab dbms_sql.varchar2_table;
1433:
1434: l_langcode_xpath VARCHAR2(200):=p_lang_search_str||'/LanguageCode';
1435: l_langname_xpath VARCHAR2(200):=p_lang_search_str||'/LanguageName';

Line 1432: l_lang_name_tab dbms_sql.varchar2_table;

1428: p_web_service_name IN VARCHAR2 DEFAULT NULL)
1429: IS
1430:
1431: l_lang_code_tab dbms_sql.varchar2_table;
1432: l_lang_name_tab dbms_sql.varchar2_table;
1433:
1434: l_langcode_xpath VARCHAR2(200):=p_lang_search_str||'/LanguageCode';
1435: l_langname_xpath VARCHAR2(200):=p_lang_search_str||'/LanguageName';
1436: l_codes_provided VARCHAR(3):='Y';

Line 2371: l_level_stack dbms_sql.number_table;

2367: l_output_xml XmlType;
2368: l_cr VARCHAR2(10) := fnd_global.local_chr(10);
2369: l_qm VARCHAR2(1) := '?'; -- Question mark in a string may be interpreted by ODI
2370:
2371: l_level_stack dbms_sql.number_table;
2372: l_tags_stack dbms_sql.varchar2_table;
2373: l_previous_level NUMBER := -1;
2374: l_previous_entity_type VARCHAR2(100);
2375: l_previous_seqid NUMBER := -1;

Line 2372: l_tags_stack dbms_sql.varchar2_table;

2368: l_cr VARCHAR2(10) := fnd_global.local_chr(10);
2369: l_qm VARCHAR2(1) := '?'; -- Question mark in a string may be interpreted by ODI
2370:
2371: l_level_stack dbms_sql.number_table;
2372: l_tags_stack dbms_sql.varchar2_table;
2373: l_previous_level NUMBER := -1;
2374: l_previous_entity_type VARCHAR2(100);
2375: l_previous_seqid NUMBER := -1;
2376: l_return_payload VARCHAR2(10) :='TRUE';