DBA Data[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on EGO_IMPORT_CNT_TABLE

Line 12368: RETURN SYSTEM.EGO_IMPORT_CNT_TABLE

12364: ( p_set_process_id NUMBER,
12365: p_organization_id NUMBER ,
12366: p_organization_code VARCHAR2
12367: )
12368: RETURN SYSTEM.EGO_IMPORT_CNT_TABLE
12369: IS
12370: CURSOR cr_item ( p_set_process_id NUMBER, p_organization_id NUMBER , p_organization_code VARCHAR2) IS
12371: SELECT
12372: COUNT(1) CNT ,

Line 12790: l_return_table SYSTEM.EGO_IMPORT_CNT_TABLE;

12786: TYPE TABLE_MEANING_TYPE IS TABLE OF VARCHAR2(80) INDEX BY VARCHAR2(30);
12787:
12788:
12789: l_row_type SYSTEM.EGO_IMPORT_CNT_REC;
12790: l_return_table SYSTEM.EGO_IMPORT_CNT_TABLE;
12791: l_tag TABLE_TAG_TYPE;
12792: l_meaning TABLE_MEANING_TYPE;
12793: l_import_xref_only VARCHAR2(1);
12794:

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

12792: l_meaning TABLE_MEANING_TYPE;
12793: l_import_xref_only VARCHAR2(1);
12794:
12795: BEGIN
12796: l_return_table := SYSTEM.EGO_IMPORT_CNT_TABLE();
12797: l_row_type := SYSTEM.EGO_IMPORT_CNT_REC('',0,0,0,0,0);
12798:
12799: -- Bug: 5262421, if IMPORT_XREF_ONLY is 'Y', then we will show 0 as after import count for AML
12800: BEGIN

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

12998: RETURN l_return_table ;
12999: EXCEPTION
13000: WHEN OTHERS THEN
13001: l_row_type := SYSTEM.EGO_IMPORT_CNT_REC('',0,0,0,0,0);
13002: l_return_table := SYSTEM.EGO_IMPORT_CNT_TABLE();
13003: l_row_type.MEANING := SQLERRM;
13004: l_return_table.EXTEND();
13005: l_return_table(l_return_table.LAST) := l_row_type;
13006: RETURN l_return_table;