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.EGO_ODI_PUB dependencies on DBMS_SQL

Line 1861: l_lang_code_tab dbms_sql.varchar2_table;

1857: p_lang_search_str IN VARCHAR2,
1858: p_web_service_name VARCHAR2 DEFAULT NULL)
1859: IS
1860:
1861: l_lang_code_tab dbms_sql.varchar2_table;
1862: l_lang_name_tab dbms_sql.varchar2_table;
1863:
1864: l_langcode_xpath VARCHAR2(200):=p_lang_search_str||'/LanguageCode';
1865: l_langname_xpath VARCHAR2(200):=p_lang_search_str||'/LanguageName';

Line 1862: l_lang_name_tab dbms_sql.varchar2_table;

1858: p_web_service_name VARCHAR2 DEFAULT NULL)
1859: IS
1860:
1861: l_lang_code_tab dbms_sql.varchar2_table;
1862: l_lang_name_tab dbms_sql.varchar2_table;
1863:
1864: l_langcode_xpath VARCHAR2(200):=p_lang_search_str||'/LanguageCode';
1865: l_langname_xpath VARCHAR2(200):=p_lang_search_str||'/LanguageName';
1866: l_codes_provided VARCHAR(3):='Y';

Line 2029: l_uda_attr_id_tab dbms_sql.varchar2_table;

2025:
2026: x_ag_name VARCHAR2(100);
2027: l_valid_ag BOOLEAN;
2028:
2029: l_uda_attr_id_tab dbms_sql.varchar2_table;
2030: l_uda_attr_name_tab dbms_sql.varchar2_table;
2031: l_uda_id_xpath VARCHAR2(1000):=p_uda_search_str || '/' || p_ag_id_node_tag;
2032: l_uda_name_xpath VARCHAR2(1000):=p_uda_search_str || '/' || p_ag_name_node_tag;
2033:

Line 2030: l_uda_attr_name_tab dbms_sql.varchar2_table;

2026: x_ag_name VARCHAR2(100);
2027: l_valid_ag BOOLEAN;
2028:
2029: l_uda_attr_id_tab dbms_sql.varchar2_table;
2030: l_uda_attr_name_tab dbms_sql.varchar2_table;
2031: l_uda_id_xpath VARCHAR2(1000):=p_uda_search_str || '/' || p_ag_id_node_tag;
2032: l_uda_name_xpath VARCHAR2(1000):=p_uda_search_str || '/' || p_ag_name_node_tag;
2033:
2034:

Line 2870: l_item_id_tab dbms_sql.varchar2_table;

2866: l_is_item_id_valid BOOLEAN := TRUE; --tells if organization name has to be validated
2867: l_is_valid BOOLEAN := TRUE;
2868:
2869: --tables for LIST mode
2870: l_item_id_tab dbms_sql.varchar2_table;
2871: l_org_id_tab dbms_sql.varchar2_table;
2872: l_rev_id_tab dbms_sql.varchar2_table;
2873: l_root_node_id_tab dbms_sql.varchar2_table;
2874: l_item_segment1_tab dbms_sql.varchar2_table;

Line 2871: l_org_id_tab dbms_sql.varchar2_table;

2867: l_is_valid BOOLEAN := TRUE;
2868:
2869: --tables for LIST mode
2870: l_item_id_tab dbms_sql.varchar2_table;
2871: l_org_id_tab dbms_sql.varchar2_table;
2872: l_rev_id_tab dbms_sql.varchar2_table;
2873: l_root_node_id_tab dbms_sql.varchar2_table;
2874: l_item_segment1_tab dbms_sql.varchar2_table;
2875: l_item_segment2_tab dbms_sql.varchar2_table;

Line 2872: l_rev_id_tab dbms_sql.varchar2_table;

2868:
2869: --tables for LIST mode
2870: l_item_id_tab dbms_sql.varchar2_table;
2871: l_org_id_tab dbms_sql.varchar2_table;
2872: l_rev_id_tab dbms_sql.varchar2_table;
2873: l_root_node_id_tab dbms_sql.varchar2_table;
2874: l_item_segment1_tab dbms_sql.varchar2_table;
2875: l_item_segment2_tab dbms_sql.varchar2_table;
2876: l_item_segment3_tab dbms_sql.varchar2_table;

Line 2873: l_root_node_id_tab dbms_sql.varchar2_table;

2869: --tables for LIST mode
2870: l_item_id_tab dbms_sql.varchar2_table;
2871: l_org_id_tab dbms_sql.varchar2_table;
2872: l_rev_id_tab dbms_sql.varchar2_table;
2873: l_root_node_id_tab dbms_sql.varchar2_table;
2874: l_item_segment1_tab dbms_sql.varchar2_table;
2875: l_item_segment2_tab dbms_sql.varchar2_table;
2876: l_item_segment3_tab dbms_sql.varchar2_table;
2877: l_item_segment4_tab dbms_sql.varchar2_table;

Line 2874: l_item_segment1_tab dbms_sql.varchar2_table;

2870: l_item_id_tab dbms_sql.varchar2_table;
2871: l_org_id_tab dbms_sql.varchar2_table;
2872: l_rev_id_tab dbms_sql.varchar2_table;
2873: l_root_node_id_tab dbms_sql.varchar2_table;
2874: l_item_segment1_tab dbms_sql.varchar2_table;
2875: l_item_segment2_tab dbms_sql.varchar2_table;
2876: l_item_segment3_tab dbms_sql.varchar2_table;
2877: l_item_segment4_tab dbms_sql.varchar2_table;
2878: l_item_segment5_tab dbms_sql.varchar2_table;

Line 2875: l_item_segment2_tab dbms_sql.varchar2_table;

2871: l_org_id_tab dbms_sql.varchar2_table;
2872: l_rev_id_tab dbms_sql.varchar2_table;
2873: l_root_node_id_tab dbms_sql.varchar2_table;
2874: l_item_segment1_tab dbms_sql.varchar2_table;
2875: l_item_segment2_tab dbms_sql.varchar2_table;
2876: l_item_segment3_tab dbms_sql.varchar2_table;
2877: l_item_segment4_tab dbms_sql.varchar2_table;
2878: l_item_segment5_tab dbms_sql.varchar2_table;
2879: l_item_segment6_tab dbms_sql.varchar2_table;

Line 2876: l_item_segment3_tab dbms_sql.varchar2_table;

2872: l_rev_id_tab dbms_sql.varchar2_table;
2873: l_root_node_id_tab dbms_sql.varchar2_table;
2874: l_item_segment1_tab dbms_sql.varchar2_table;
2875: l_item_segment2_tab dbms_sql.varchar2_table;
2876: l_item_segment3_tab dbms_sql.varchar2_table;
2877: l_item_segment4_tab dbms_sql.varchar2_table;
2878: l_item_segment5_tab dbms_sql.varchar2_table;
2879: l_item_segment6_tab dbms_sql.varchar2_table;
2880: l_item_segment7_tab dbms_sql.varchar2_table;

Line 2877: l_item_segment4_tab dbms_sql.varchar2_table;

2873: l_root_node_id_tab dbms_sql.varchar2_table;
2874: l_item_segment1_tab dbms_sql.varchar2_table;
2875: l_item_segment2_tab dbms_sql.varchar2_table;
2876: l_item_segment3_tab dbms_sql.varchar2_table;
2877: l_item_segment4_tab dbms_sql.varchar2_table;
2878: l_item_segment5_tab dbms_sql.varchar2_table;
2879: l_item_segment6_tab dbms_sql.varchar2_table;
2880: l_item_segment7_tab dbms_sql.varchar2_table;
2881: l_item_segment8_tab dbms_sql.varchar2_table;

Line 2878: l_item_segment5_tab dbms_sql.varchar2_table;

2874: l_item_segment1_tab dbms_sql.varchar2_table;
2875: l_item_segment2_tab dbms_sql.varchar2_table;
2876: l_item_segment3_tab dbms_sql.varchar2_table;
2877: l_item_segment4_tab dbms_sql.varchar2_table;
2878: l_item_segment5_tab dbms_sql.varchar2_table;
2879: l_item_segment6_tab dbms_sql.varchar2_table;
2880: l_item_segment7_tab dbms_sql.varchar2_table;
2881: l_item_segment8_tab dbms_sql.varchar2_table;
2882: l_item_segment9_tab dbms_sql.varchar2_table;

Line 2879: l_item_segment6_tab dbms_sql.varchar2_table;

2875: l_item_segment2_tab dbms_sql.varchar2_table;
2876: l_item_segment3_tab dbms_sql.varchar2_table;
2877: l_item_segment4_tab dbms_sql.varchar2_table;
2878: l_item_segment5_tab dbms_sql.varchar2_table;
2879: l_item_segment6_tab dbms_sql.varchar2_table;
2880: l_item_segment7_tab dbms_sql.varchar2_table;
2881: l_item_segment8_tab dbms_sql.varchar2_table;
2882: l_item_segment9_tab dbms_sql.varchar2_table;
2883: l_item_segment10_tab dbms_sql.varchar2_table;

Line 2880: l_item_segment7_tab dbms_sql.varchar2_table;

2876: l_item_segment3_tab dbms_sql.varchar2_table;
2877: l_item_segment4_tab dbms_sql.varchar2_table;
2878: l_item_segment5_tab dbms_sql.varchar2_table;
2879: l_item_segment6_tab dbms_sql.varchar2_table;
2880: l_item_segment7_tab dbms_sql.varchar2_table;
2881: l_item_segment8_tab dbms_sql.varchar2_table;
2882: l_item_segment9_tab dbms_sql.varchar2_table;
2883: l_item_segment10_tab dbms_sql.varchar2_table;
2884: l_item_segment11_tab dbms_sql.varchar2_table;

Line 2881: l_item_segment8_tab dbms_sql.varchar2_table;

2877: l_item_segment4_tab dbms_sql.varchar2_table;
2878: l_item_segment5_tab dbms_sql.varchar2_table;
2879: l_item_segment6_tab dbms_sql.varchar2_table;
2880: l_item_segment7_tab dbms_sql.varchar2_table;
2881: l_item_segment8_tab dbms_sql.varchar2_table;
2882: l_item_segment9_tab dbms_sql.varchar2_table;
2883: l_item_segment10_tab dbms_sql.varchar2_table;
2884: l_item_segment11_tab dbms_sql.varchar2_table;
2885: l_item_segment12_tab dbms_sql.varchar2_table;

Line 2882: l_item_segment9_tab dbms_sql.varchar2_table;

2878: l_item_segment5_tab dbms_sql.varchar2_table;
2879: l_item_segment6_tab dbms_sql.varchar2_table;
2880: l_item_segment7_tab dbms_sql.varchar2_table;
2881: l_item_segment8_tab dbms_sql.varchar2_table;
2882: l_item_segment9_tab dbms_sql.varchar2_table;
2883: l_item_segment10_tab dbms_sql.varchar2_table;
2884: l_item_segment11_tab dbms_sql.varchar2_table;
2885: l_item_segment12_tab dbms_sql.varchar2_table;
2886: l_item_segment13_tab dbms_sql.varchar2_table;

Line 2883: l_item_segment10_tab dbms_sql.varchar2_table;

2879: l_item_segment6_tab dbms_sql.varchar2_table;
2880: l_item_segment7_tab dbms_sql.varchar2_table;
2881: l_item_segment8_tab dbms_sql.varchar2_table;
2882: l_item_segment9_tab dbms_sql.varchar2_table;
2883: l_item_segment10_tab dbms_sql.varchar2_table;
2884: l_item_segment11_tab dbms_sql.varchar2_table;
2885: l_item_segment12_tab dbms_sql.varchar2_table;
2886: l_item_segment13_tab dbms_sql.varchar2_table;
2887: l_item_segment14_tab dbms_sql.varchar2_table;

Line 2884: l_item_segment11_tab dbms_sql.varchar2_table;

2880: l_item_segment7_tab dbms_sql.varchar2_table;
2881: l_item_segment8_tab dbms_sql.varchar2_table;
2882: l_item_segment9_tab dbms_sql.varchar2_table;
2883: l_item_segment10_tab dbms_sql.varchar2_table;
2884: l_item_segment11_tab dbms_sql.varchar2_table;
2885: l_item_segment12_tab dbms_sql.varchar2_table;
2886: l_item_segment13_tab dbms_sql.varchar2_table;
2887: l_item_segment14_tab dbms_sql.varchar2_table;
2888: l_item_segment15_tab dbms_sql.varchar2_table;

Line 2885: l_item_segment12_tab dbms_sql.varchar2_table;

2881: l_item_segment8_tab dbms_sql.varchar2_table;
2882: l_item_segment9_tab dbms_sql.varchar2_table;
2883: l_item_segment10_tab dbms_sql.varchar2_table;
2884: l_item_segment11_tab dbms_sql.varchar2_table;
2885: l_item_segment12_tab dbms_sql.varchar2_table;
2886: l_item_segment13_tab dbms_sql.varchar2_table;
2887: l_item_segment14_tab dbms_sql.varchar2_table;
2888: l_item_segment15_tab dbms_sql.varchar2_table;
2889: l_item_segment16_tab dbms_sql.varchar2_table;

Line 2886: l_item_segment13_tab dbms_sql.varchar2_table;

2882: l_item_segment9_tab dbms_sql.varchar2_table;
2883: l_item_segment10_tab dbms_sql.varchar2_table;
2884: l_item_segment11_tab dbms_sql.varchar2_table;
2885: l_item_segment12_tab dbms_sql.varchar2_table;
2886: l_item_segment13_tab dbms_sql.varchar2_table;
2887: l_item_segment14_tab dbms_sql.varchar2_table;
2888: l_item_segment15_tab dbms_sql.varchar2_table;
2889: l_item_segment16_tab dbms_sql.varchar2_table;
2890: l_item_segment17_tab dbms_sql.varchar2_table;

Line 2887: l_item_segment14_tab dbms_sql.varchar2_table;

2883: l_item_segment10_tab dbms_sql.varchar2_table;
2884: l_item_segment11_tab dbms_sql.varchar2_table;
2885: l_item_segment12_tab dbms_sql.varchar2_table;
2886: l_item_segment13_tab dbms_sql.varchar2_table;
2887: l_item_segment14_tab dbms_sql.varchar2_table;
2888: l_item_segment15_tab dbms_sql.varchar2_table;
2889: l_item_segment16_tab dbms_sql.varchar2_table;
2890: l_item_segment17_tab dbms_sql.varchar2_table;
2891: l_item_segment18_tab dbms_sql.varchar2_table;

Line 2888: l_item_segment15_tab dbms_sql.varchar2_table;

2884: l_item_segment11_tab dbms_sql.varchar2_table;
2885: l_item_segment12_tab dbms_sql.varchar2_table;
2886: l_item_segment13_tab dbms_sql.varchar2_table;
2887: l_item_segment14_tab dbms_sql.varchar2_table;
2888: l_item_segment15_tab dbms_sql.varchar2_table;
2889: l_item_segment16_tab dbms_sql.varchar2_table;
2890: l_item_segment17_tab dbms_sql.varchar2_table;
2891: l_item_segment18_tab dbms_sql.varchar2_table;
2892: l_item_segment19_tab dbms_sql.varchar2_table;

Line 2889: l_item_segment16_tab dbms_sql.varchar2_table;

2885: l_item_segment12_tab dbms_sql.varchar2_table;
2886: l_item_segment13_tab dbms_sql.varchar2_table;
2887: l_item_segment14_tab dbms_sql.varchar2_table;
2888: l_item_segment15_tab dbms_sql.varchar2_table;
2889: l_item_segment16_tab dbms_sql.varchar2_table;
2890: l_item_segment17_tab dbms_sql.varchar2_table;
2891: l_item_segment18_tab dbms_sql.varchar2_table;
2892: l_item_segment19_tab dbms_sql.varchar2_table;
2893: l_item_segment20_tab dbms_sql.varchar2_table;

Line 2890: l_item_segment17_tab dbms_sql.varchar2_table;

2886: l_item_segment13_tab dbms_sql.varchar2_table;
2887: l_item_segment14_tab dbms_sql.varchar2_table;
2888: l_item_segment15_tab dbms_sql.varchar2_table;
2889: l_item_segment16_tab dbms_sql.varchar2_table;
2890: l_item_segment17_tab dbms_sql.varchar2_table;
2891: l_item_segment18_tab dbms_sql.varchar2_table;
2892: l_item_segment19_tab dbms_sql.varchar2_table;
2893: l_item_segment20_tab dbms_sql.varchar2_table;
2894: l_org_name_tab dbms_sql.varchar2_table;

Line 2891: l_item_segment18_tab dbms_sql.varchar2_table;

2887: l_item_segment14_tab dbms_sql.varchar2_table;
2888: l_item_segment15_tab dbms_sql.varchar2_table;
2889: l_item_segment16_tab dbms_sql.varchar2_table;
2890: l_item_segment17_tab dbms_sql.varchar2_table;
2891: l_item_segment18_tab dbms_sql.varchar2_table;
2892: l_item_segment19_tab dbms_sql.varchar2_table;
2893: l_item_segment20_tab dbms_sql.varchar2_table;
2894: l_org_name_tab dbms_sql.varchar2_table;
2895: l_rev_name_tab dbms_sql.varchar2_table;

Line 2892: l_item_segment19_tab dbms_sql.varchar2_table;

2888: l_item_segment15_tab dbms_sql.varchar2_table;
2889: l_item_segment16_tab dbms_sql.varchar2_table;
2890: l_item_segment17_tab dbms_sql.varchar2_table;
2891: l_item_segment18_tab dbms_sql.varchar2_table;
2892: l_item_segment19_tab dbms_sql.varchar2_table;
2893: l_item_segment20_tab dbms_sql.varchar2_table;
2894: l_org_name_tab dbms_sql.varchar2_table;
2895: l_rev_name_tab dbms_sql.varchar2_table;
2896: l_structure_name_tab dbms_sql.varchar2_table;

Line 2893: l_item_segment20_tab dbms_sql.varchar2_table;

2889: l_item_segment16_tab dbms_sql.varchar2_table;
2890: l_item_segment17_tab dbms_sql.varchar2_table;
2891: l_item_segment18_tab dbms_sql.varchar2_table;
2892: l_item_segment19_tab dbms_sql.varchar2_table;
2893: l_item_segment20_tab dbms_sql.varchar2_table;
2894: l_org_name_tab dbms_sql.varchar2_table;
2895: l_rev_name_tab dbms_sql.varchar2_table;
2896: l_structure_name_tab dbms_sql.varchar2_table;
2897: l_explosion_date_tab dbms_sql.varchar2_table;

Line 2894: l_org_name_tab dbms_sql.varchar2_table;

2890: l_item_segment17_tab dbms_sql.varchar2_table;
2891: l_item_segment18_tab dbms_sql.varchar2_table;
2892: l_item_segment19_tab dbms_sql.varchar2_table;
2893: l_item_segment20_tab dbms_sql.varchar2_table;
2894: l_org_name_tab dbms_sql.varchar2_table;
2895: l_rev_name_tab dbms_sql.varchar2_table;
2896: l_structure_name_tab dbms_sql.varchar2_table;
2897: l_explosion_date_tab dbms_sql.varchar2_table;
2898: l_count NUMBER;

Line 2895: l_rev_name_tab dbms_sql.varchar2_table;

2891: l_item_segment18_tab dbms_sql.varchar2_table;
2892: l_item_segment19_tab dbms_sql.varchar2_table;
2893: l_item_segment20_tab dbms_sql.varchar2_table;
2894: l_org_name_tab dbms_sql.varchar2_table;
2895: l_rev_name_tab dbms_sql.varchar2_table;
2896: l_structure_name_tab dbms_sql.varchar2_table;
2897: l_explosion_date_tab dbms_sql.varchar2_table;
2898: l_count NUMBER;
2899: l_item_index NUMBER;

Line 2896: l_structure_name_tab dbms_sql.varchar2_table;

2892: l_item_segment19_tab dbms_sql.varchar2_table;
2893: l_item_segment20_tab dbms_sql.varchar2_table;
2894: l_org_name_tab dbms_sql.varchar2_table;
2895: l_rev_name_tab dbms_sql.varchar2_table;
2896: l_structure_name_tab dbms_sql.varchar2_table;
2897: l_explosion_date_tab dbms_sql.varchar2_table;
2898: l_count NUMBER;
2899: l_item_index NUMBER;
2900:

Line 2897: l_explosion_date_tab dbms_sql.varchar2_table;

2893: l_item_segment20_tab dbms_sql.varchar2_table;
2894: l_org_name_tab dbms_sql.varchar2_table;
2895: l_rev_name_tab dbms_sql.varchar2_table;
2896: l_structure_name_tab dbms_sql.varchar2_table;
2897: l_explosion_date_tab dbms_sql.varchar2_table;
2898: l_count NUMBER;
2899: l_item_index NUMBER;
2900:
2901: --variables to read comma separated string

Line 5204: l_level_stack dbms_sql.number_table;

5200: l_output_xml XmlType;
5201: l_cr VARCHAR2(10) := fnd_global.local_chr(10);
5202: l_qm VARCHAR2(1) := '?'; -- Question mark in a string may be interpreted by ODI
5203:
5204: l_level_stack dbms_sql.number_table;
5205: l_tags_stack dbms_sql.varchar2_table;
5206: l_previous_level NUMBER := -1;
5207: l_previous_entity_type VARCHAR2(100);
5208: l_previous_seqid NUMBER := -1;

Line 5205: l_tags_stack dbms_sql.varchar2_table;

5201: l_cr VARCHAR2(10) := fnd_global.local_chr(10);
5202: l_qm VARCHAR2(1) := '?'; -- Question mark in a string may be interpreted by ODI
5203:
5204: l_level_stack dbms_sql.number_table;
5205: l_tags_stack dbms_sql.varchar2_table;
5206: l_previous_level NUMBER := -1;
5207: l_previous_entity_type VARCHAR2(100);
5208: l_previous_seqid NUMBER := -1;
5209: l_return_payload VARCHAR2(10) :='TRUE';

Line 5967: l_lang_code_tab dbms_sql.varchar2_table;

5963: p_parent_hier IN VARCHAR2,
5964: p_child_hier IN VARCHAR2)
5965: IS
5966:
5967: l_lang_code_tab dbms_sql.varchar2_table;
5968: l_UserDefAttrGrps VARCHAR2(10);
5969: l_iccvers_config VARCHAR2(10);
5970: l_transattrs_config VARCHAR2(10);
5971: l_structure_config VARCHAR2(10);

Line 6118: l_icc_id_tab dbms_sql.VARCHAR2_table; --Netsed table of varchar2 to store ICC_Id's

6114: p_odi_session_id IN NUMBER )
6115:
6116: IS
6117:
6118: l_icc_id_tab dbms_sql.VARCHAR2_table; --Netsed table of varchar2 to store ICC_Id's
6119: l_icc_ver_tab dbms_sql.NUMBER_table; --Netsed table of varchar2 to store ICC Version
6120: l_count NUMBER;
6121:
6122: --Bug 8767131

Line 6119: l_icc_ver_tab dbms_sql.NUMBER_table; --Netsed table of varchar2 to store ICC Version

6115:
6116: IS
6117:
6118: l_icc_id_tab dbms_sql.VARCHAR2_table; --Netsed table of varchar2 to store ICC_Id's
6119: l_icc_ver_tab dbms_sql.NUMBER_table; --Netsed table of varchar2 to store ICC Version
6120: l_count NUMBER;
6121:
6122: --Bug 8767131
6123: l_dup_icc_id_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC_Id's

Line 6123: l_dup_icc_id_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC_Id's

6119: l_icc_ver_tab dbms_sql.NUMBER_table; --Netsed table of varchar2 to store ICC Version
6120: l_count NUMBER;
6121:
6122: --Bug 8767131
6123: l_dup_icc_id_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC_Id's
6124: l_dup_icc_ver_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC Version
6125: l_unique_icc_count NUMBER:=1;
6126: l_is_duplicate BOOLEAN :=FALSE;
6127: l_ref1_value VARCHAR2(200):=NULL;

Line 6124: l_dup_icc_ver_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC Version

6120: l_count NUMBER;
6121:
6122: --Bug 8767131
6123: l_dup_icc_id_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC_Id's
6124: l_dup_icc_ver_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC Version
6125: l_unique_icc_count NUMBER:=1;
6126: l_is_duplicate BOOLEAN :=FALSE;
6127: l_ref1_value VARCHAR2(200):=NULL;
6128: --Bug 8767131

Line 6284: l_icc_parent_pub_tab dbms_sql.VARCHAR2_table;

6280: x_msg_count NUMBER;
6281: x_msg_data VARCHAR2(500);
6282: l_batch_id NUMBER;
6283: l_mode VARCHAR2(30);
6284: l_icc_parent_pub_tab dbms_sql.VARCHAR2_table;
6285: l_icc_child_pub_tab dbms_sql.VARCHAR2_table;
6286: l_batch_search_str VARCHAR2(100):='/ICCQueryParam/BatchId';
6287: l_search_str VARCHAR2(100):='/ICCQueryParam/ICCPubEntityObject';
6288: l_access_priv BOOLEAN :=TRUE;

Line 6285: l_icc_child_pub_tab dbms_sql.VARCHAR2_table;

6281: x_msg_data VARCHAR2(500);
6282: l_batch_id NUMBER;
6283: l_mode VARCHAR2(30);
6284: l_icc_parent_pub_tab dbms_sql.VARCHAR2_table;
6285: l_icc_child_pub_tab dbms_sql.VARCHAR2_table;
6286: l_batch_search_str VARCHAR2(100):='/ICCQueryParam/BatchId';
6287: l_search_str VARCHAR2(100):='/ICCQueryParam/ICCPubEntityObject';
6288: l_access_priv BOOLEAN :=TRUE;
6289: --l_valid_bat_entity BOOLEAN :=TRUE;

Line 6550: l_vs_id_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC_Id's

6546: p_odi_session_id IN NUMBER )
6547:
6548: IS
6549:
6550: l_vs_id_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC_Id's
6551: l_vs_ver_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC Version
6552: l_count NUMBER;
6553:
6554: --Bug 8767131

Line 6551: l_vs_ver_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC Version

6547:
6548: IS
6549:
6550: l_vs_id_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC_Id's
6551: l_vs_ver_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC Version
6552: l_count NUMBER;
6553:
6554: --Bug 8767131
6555: l_dup_vs_id_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC_Id's

Line 6555: l_dup_vs_id_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC_Id's

6551: l_vs_ver_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC Version
6552: l_count NUMBER;
6553:
6554: --Bug 8767131
6555: l_dup_vs_id_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC_Id's
6556: l_dup_vs_ver_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC Version
6557: l_unique_val_count NUMBER:=1;
6558: l_is_duplicate BOOLEAN :=FALSE;
6559: l_ref1_value VARCHAR2(200):=NULL;

Line 6556: l_dup_vs_ver_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC Version

6552: l_count NUMBER;
6553:
6554: --Bug 8767131
6555: l_dup_vs_id_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC_Id's
6556: l_dup_vs_ver_tab dbms_sql.Number_Table; --Netsed table of varchar2 to store ICC Version
6557: l_unique_val_count NUMBER:=1;
6558: l_is_duplicate BOOLEAN :=FALSE;
6559: l_ref1_value VARCHAR2(200):=NULL;
6560: --Bug 8767131

Line 6570: l_icc_parent_pub_tab dbms_sql.VARCHAR2_table;

6566: x_msg_count NUMBER;
6567: x_msg_data VARCHAR2(500);
6568: l_batch_id NUMBER;
6569: l_mode VARCHAR2(30);
6570: l_icc_parent_pub_tab dbms_sql.VARCHAR2_table;
6571: l_icc_child_pub_tab dbms_sql.VARCHAR2_table;
6572: l_batch_search_str VARCHAR2(100):='/ValuesetQueryParam/BatchId';
6573: l_search_str VARCHAR2(100):='/ValuesetQueryParam';
6574: l_access_priv BOOLEAN :=TRUE;

Line 6571: l_icc_child_pub_tab dbms_sql.VARCHAR2_table;

6567: x_msg_data VARCHAR2(500);
6568: l_batch_id NUMBER;
6569: l_mode VARCHAR2(30);
6570: l_icc_parent_pub_tab dbms_sql.VARCHAR2_table;
6571: l_icc_child_pub_tab dbms_sql.VARCHAR2_table;
6572: l_batch_search_str VARCHAR2(100):='/ValuesetQueryParam/BatchId';
6573: l_search_str VARCHAR2(100):='/ValuesetQueryParam';
6574: l_access_priv BOOLEAN :=TRUE;
6575: -- l_valid_bat_entity BOOLEAN :=TRUE;