DBA Data[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on EGO_IMPORT_CNT_TABLE

Line 12488: RETURN SYSTEM.EGO_IMPORT_CNT_TABLE

12484: ( p_set_process_id NUMBER,
12485: p_organization_id NUMBER ,
12486: p_organization_code VARCHAR2
12487: )
12488: RETURN SYSTEM.EGO_IMPORT_CNT_TABLE
12489: IS
12490: CURSOR cr_item ( p_set_process_id NUMBER, p_organization_id NUMBER , p_organization_code VARCHAR2) IS
12491: SELECT
12492: COUNT(1) CNT ,

Line 12910: l_return_table SYSTEM.EGO_IMPORT_CNT_TABLE;

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);
12914:

Line 12916: l_return_table := SYSTEM.EGO_IMPORT_CNT_TABLE();

12912: l_meaning TABLE_MEANING_TYPE;
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

Line 13122: l_return_table := SYSTEM.EGO_IMPORT_CNT_TABLE();

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;
13126: RETURN l_return_table;