[Home] [Help]
12905: TYPE TABLE_TAG_TYPE IS TABLE OF VARCHAR2(150) INDEX BY VARCHAR2(30);
12906: TYPE TABLE_MEANING_TYPE IS TABLE OF VARCHAR2(80) INDEX BY VARCHAR2(30);
12907:
12908:
12909: l_row_type SYSTEM.EGO_IMPORT_CNT_REC;
12910: l_return_table SYSTEM.EGO_IMPORT_CNT_TABLE;
12911: l_tag TABLE_TAG_TYPE;
12912: l_meaning TABLE_MEANING_TYPE;
12913: l_import_xref_only VARCHAR2(1);
12913: l_import_xref_only VARCHAR2(1);
12914:
12915: BEGIN
12916: l_return_table := SYSTEM.EGO_IMPORT_CNT_TABLE();
12917: l_row_type := SYSTEM.EGO_IMPORT_CNT_REC('',0,0,0,0,0);
12918:
12919: -- Bug: 5262421, if IMPORT_XREF_ONLY is 'Y', then we will show 0 as after import count for AML
12920: BEGIN
12921: SELECT NVL(opt.IMPORT_XREF_ONLY, 'N') INTO l_import_xref_only
13117:
13118: RETURN l_return_table ;
13119: EXCEPTION
13120: WHEN OTHERS THEN
13121: l_row_type := SYSTEM.EGO_IMPORT_CNT_REC('',0,0,0,0,0);
13122: l_return_table := SYSTEM.EGO_IMPORT_CNT_TABLE();
13123: l_row_type.MEANING := SQLERRM;
13124: l_return_table.EXTEND();
13125: l_return_table(l_return_table.LAST) := l_row_type;