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_ICC_BULKLOAD_PVT dependencies on AD_DDL

Line 2418: --bugfix 11907422 for 12.2 AD_DDL changes

2414: l_ret_seq_name := 'ITEM_NUM_SEQ_'|| p_icc_id || l_seq_name_suffix;
2415: l_seq_name := l_seq_name_prefix || p_icc_id || l_seq_name_suffix;
2416: l_dyn_sql := 'CREATE SEQUENCE '||l_seq_name||' INCREMENT BY '||p_seq_increment_by||' START WITH '||p_seq_start_num || ' NOCACHE';
2417:
2418: --bugfix 11907422 for 12.2 AD_DDL changes
2419: --EXECUTE IMMEDIATE l_dyn_sql;
2420:
2421: AD_DDL.DO_DDL(fnd_apps_schema, l_schema, AD_DDL.CREATE_SEQUENCE,l_dyn_sql, l_seq_name);
2422:

Line 2421: AD_DDL.DO_DDL(fnd_apps_schema, l_schema, AD_DDL.CREATE_SEQUENCE,l_dyn_sql, l_seq_name);

2417:
2418: --bugfix 11907422 for 12.2 AD_DDL changes
2419: --EXECUTE IMMEDIATE l_dyn_sql;
2420:
2421: AD_DDL.DO_DDL(fnd_apps_schema, l_schema, AD_DDL.CREATE_SEQUENCE,l_dyn_sql, l_seq_name);
2422:
2423: l_syn_name := l_syn_name_prefix || p_icc_id || l_seq_name_suffix;
2424: l_dyn_sql := 'CREATE SYNONYM '||l_syn_name||' FOR '||l_seq_name;
2425:

Line 2426: --bugfix 11907422 for 12.2 AD_DDL changes

2422:
2423: l_syn_name := l_syn_name_prefix || p_icc_id || l_seq_name_suffix;
2424: l_dyn_sql := 'CREATE SYNONYM '||l_syn_name||' FOR '||l_seq_name;
2425:
2426: --bugfix 11907422 for 12.2 AD_DDL changes
2427: --EXECUTE IMMEDIATE l_dyn_sql;
2428:
2429: --comment this line since AD_DDL.DO_DDL will create synonym for us
2430:

Line 2429: --comment this line since AD_DDL.DO_DDL will create synonym for us

2425:
2426: --bugfix 11907422 for 12.2 AD_DDL changes
2427: --EXECUTE IMMEDIATE l_dyn_sql;
2428:
2429: --comment this line since AD_DDL.DO_DDL will create synonym for us
2430:
2431: --AD_DDL.DO_DDL(fnd_apps_schema, fnd_apps_schema, ad_ddl.create_synonym,l_dyn_sql, l_syn_name);
2432:
2433:

Line 2431: --AD_DDL.DO_DDL(fnd_apps_schema, fnd_apps_schema, ad_ddl.create_synonym,l_dyn_sql, l_syn_name);

2427: --EXECUTE IMMEDIATE l_dyn_sql;
2428:
2429: --comment this line since AD_DDL.DO_DDL will create synonym for us
2430:
2431: --AD_DDL.DO_DDL(fnd_apps_schema, fnd_apps_schema, ad_ddl.create_synonym,l_dyn_sql, l_syn_name);
2432:
2433:
2434: x_seq_name := l_ret_seq_name;
2435: EXCEPTION

Line 2485: --bugfix 11907422 for 12.2 AD_DDL changes

2481: END IF;
2482:
2483: l_dyn_sql := 'DROP SYNONYM '||p_item_catalog_seq_name;
2484:
2485: --bugfix 11907422 for 12.2 AD_DDL changes
2486: -- EXECUTE IMMEDIATE l_dyn_sql;
2487: --comment this line since AD_DDL.DO_DDL will drop synonym for us,
2488: --AD_DDL.DO_DDL(fnd_apps_schema,fnd_apps_schema, ad_ddl.drop_synonym,l_dyn_sql, p_item_catalog_seq_name);
2489:

Line 2487: --comment this line since AD_DDL.DO_DDL will drop synonym for us,

2483: l_dyn_sql := 'DROP SYNONYM '||p_item_catalog_seq_name;
2484:
2485: --bugfix 11907422 for 12.2 AD_DDL changes
2486: -- EXECUTE IMMEDIATE l_dyn_sql;
2487: --comment this line since AD_DDL.DO_DDL will drop synonym for us,
2488: --AD_DDL.DO_DDL(fnd_apps_schema,fnd_apps_schema, ad_ddl.drop_synonym,l_dyn_sql, p_item_catalog_seq_name);
2489:
2490: --l_dyn_sql := 'DROP SEQUENCE '||l_schema||'.'||p_item_catalog_seq_name;
2491: l_dyn_sql := 'DROP SEQUENCE '||p_item_catalog_seq_name;

Line 2488: --AD_DDL.DO_DDL(fnd_apps_schema,fnd_apps_schema, ad_ddl.drop_synonym,l_dyn_sql, p_item_catalog_seq_name);

2484:
2485: --bugfix 11907422 for 12.2 AD_DDL changes
2486: -- EXECUTE IMMEDIATE l_dyn_sql;
2487: --comment this line since AD_DDL.DO_DDL will drop synonym for us,
2488: --AD_DDL.DO_DDL(fnd_apps_schema,fnd_apps_schema, ad_ddl.drop_synonym,l_dyn_sql, p_item_catalog_seq_name);
2489:
2490: --l_dyn_sql := 'DROP SEQUENCE '||l_schema||'.'||p_item_catalog_seq_name;
2491: l_dyn_sql := 'DROP SEQUENCE '||p_item_catalog_seq_name;
2492: --bugfix 11907422 for 12.2 AD_DDL changes

Line 2492: --bugfix 11907422 for 12.2 AD_DDL changes

2488: --AD_DDL.DO_DDL(fnd_apps_schema,fnd_apps_schema, ad_ddl.drop_synonym,l_dyn_sql, p_item_catalog_seq_name);
2489:
2490: --l_dyn_sql := 'DROP SEQUENCE '||l_schema||'.'||p_item_catalog_seq_name;
2491: l_dyn_sql := 'DROP SEQUENCE '||p_item_catalog_seq_name;
2492: --bugfix 11907422 for 12.2 AD_DDL changes
2493: --EXECUTE IMMEDIATE l_dyn_sql;
2494:
2495: AD_DDL.DO_DDL(fnd_apps_schema,l_schema, ad_ddl.drop_sequence,l_dyn_sql, p_item_catalog_seq_name);
2496: EXCEPTION

Line 2495: AD_DDL.DO_DDL(fnd_apps_schema,l_schema, ad_ddl.drop_sequence,l_dyn_sql, p_item_catalog_seq_name);

2491: l_dyn_sql := 'DROP SEQUENCE '||p_item_catalog_seq_name;
2492: --bugfix 11907422 for 12.2 AD_DDL changes
2493: --EXECUTE IMMEDIATE l_dyn_sql;
2494:
2495: AD_DDL.DO_DDL(fnd_apps_schema,l_schema, ad_ddl.drop_sequence,l_dyn_sql, p_item_catalog_seq_name);
2496: EXCEPTION
2497: WHEN others THEN
2498: x_return_status := G_RET_STS_UNEXP_ERROR;
2499: x_return_msg := G_PKG_NAME||'.'||l_proc_name||' '||SQLERRM;