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

Line 3179: --bugfix 11907422 for 12.2 AD_DDL changes

3175: l_seq_name_prefix := 'ITEM_NUM_SEQ_';
3176: l_seq_name := l_seq_name_prefix || p_item_catalog_group_id || l_seq_name_suffix;
3177: l_dyn_sql := 'CREATE SEQUENCE '||l_seq_name||' INCREMENT BY '||p_seq_increment_by||' START WITH '||p_seq_start_num || ' NOCACHE';
3178:
3179: --bugfix 11907422 for 12.2 AD_DDL changes
3180: --EXECUTE IMMEDIATE l_dyn_sql;
3181:
3182: AD_DDL.DO_DDL(fnd_apps_schema, l_schema, AD_DDL.CREATE_SEQUENCE,l_dyn_sql, l_seq_name);
3183:

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

3178:
3179: --bugfix 11907422 for 12.2 AD_DDL changes
3180: --EXECUTE IMMEDIATE l_dyn_sql;
3181:
3182: AD_DDL.DO_DDL(fnd_apps_schema, l_schema, AD_DDL.CREATE_SEQUENCE,l_dyn_sql, l_seq_name);
3183:
3184:
3185: l_syn_name := l_syn_name_prefix || p_item_catalog_group_id || l_seq_name_suffix;
3186: l_dyn_sql := 'CREATE SYNONYM '||l_syn_name||' FOR '||l_schema ||'.'||l_seq_name;

Line 3188: --bugfix 11907422 for 12.2 AD_DDL changes

3184:
3185: l_syn_name := l_syn_name_prefix || p_item_catalog_group_id || l_seq_name_suffix;
3186: l_dyn_sql := 'CREATE SYNONYM '||l_syn_name||' FOR '||l_schema ||'.'||l_seq_name;
3187:
3188: --bugfix 11907422 for 12.2 AD_DDL changes
3189: -- EXECUTE IMMEDIATE l_dyn_sql;
3190: --comment this line since AD_DDL.DO_DDL will create synonym for us, 12392423
3191: --AD_DDL.DO_DDL(fnd_apps_schema, fnd_apps_schema, ad_ddl.create_synonym,l_dyn_sql, l_syn_name);
3192: EXCEPTION

Line 3190: --comment this line since AD_DDL.DO_DDL will create synonym for us, 12392423

3186: l_dyn_sql := 'CREATE SYNONYM '||l_syn_name||' FOR '||l_schema ||'.'||l_seq_name;
3187:
3188: --bugfix 11907422 for 12.2 AD_DDL changes
3189: -- EXECUTE IMMEDIATE l_dyn_sql;
3190: --comment this line since AD_DDL.DO_DDL will create synonym for us, 12392423
3191: --AD_DDL.DO_DDL(fnd_apps_schema, fnd_apps_schema, ad_ddl.create_synonym,l_dyn_sql, l_syn_name);
3192: EXCEPTION
3193: WHEN others THEN
3194: x_return_status := G_RET_STS_UNEXP_ERROR;

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

3187:
3188: --bugfix 11907422 for 12.2 AD_DDL changes
3189: -- EXECUTE IMMEDIATE l_dyn_sql;
3190: --comment this line since AD_DDL.DO_DDL will create synonym for us, 12392423
3191: --AD_DDL.DO_DDL(fnd_apps_schema, fnd_apps_schema, ad_ddl.create_synonym,l_dyn_sql, l_syn_name);
3192: EXCEPTION
3193: WHEN others THEN
3194: x_return_status := G_RET_STS_UNEXP_ERROR;
3195: x_msg_data := G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;

Line 3235: --bugfix 11907422 for 12.2 AD_DDL changes

3231: Raise_Application_Error (-20001, 'INV Schema could not be located.');
3232: END IF;
3233:
3234: l_dyn_sql := 'DROP SYNONYM '||p_item_catalog_seq_name;
3235: --bugfix 11907422 for 12.2 AD_DDL changes
3236: --EXECUTE IMMEDIATE l_dyn_sql;
3237:
3238: --comment this line since AD_DDL.DO_DDL will drop synonym for us, 12392423
3239: --AD_DDL.DO_DDL(fnd_apps_schema,fnd_apps_schema, ad_ddl.drop_synonym,l_dyn_sql, p_item_catalog_seq_name);

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

3234: l_dyn_sql := 'DROP SYNONYM '||p_item_catalog_seq_name;
3235: --bugfix 11907422 for 12.2 AD_DDL changes
3236: --EXECUTE IMMEDIATE l_dyn_sql;
3237:
3238: --comment this line since AD_DDL.DO_DDL will drop synonym for us, 12392423
3239: --AD_DDL.DO_DDL(fnd_apps_schema,fnd_apps_schema, ad_ddl.drop_synonym,l_dyn_sql, p_item_catalog_seq_name);
3240:
3241:
3242: -- l_dyn_sql := 'DROP SEQUENCE '||l_schema||'.'||p_item_catalog_seq_name;

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

3235: --bugfix 11907422 for 12.2 AD_DDL changes
3236: --EXECUTE IMMEDIATE l_dyn_sql;
3237:
3238: --comment this line since AD_DDL.DO_DDL will drop synonym for us, 12392423
3239: --AD_DDL.DO_DDL(fnd_apps_schema,fnd_apps_schema, ad_ddl.drop_synonym,l_dyn_sql, p_item_catalog_seq_name);
3240:
3241:
3242: -- l_dyn_sql := 'DROP SEQUENCE '||l_schema||'.'||p_item_catalog_seq_name;
3243: l_dyn_sql := 'DROP SEQUENCE '||p_item_catalog_seq_name;

Line 3244: --bugfix 11907422 for 12.2 AD_DDL changes

3240:
3241:
3242: -- l_dyn_sql := 'DROP SEQUENCE '||l_schema||'.'||p_item_catalog_seq_name;
3243: l_dyn_sql := 'DROP SEQUENCE '||p_item_catalog_seq_name;
3244: --bugfix 11907422 for 12.2 AD_DDL changes
3245: -- EXECUTE IMMEDIATE l_dyn_sql;
3246:
3247: AD_DDL.DO_DDL(fnd_apps_schema, l_schema, ad_ddl.drop_sequence,l_dyn_sql, p_item_catalog_seq_name);
3248: EXCEPTION

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

3243: l_dyn_sql := 'DROP SEQUENCE '||p_item_catalog_seq_name;
3244: --bugfix 11907422 for 12.2 AD_DDL changes
3245: -- EXECUTE IMMEDIATE l_dyn_sql;
3246:
3247: AD_DDL.DO_DDL(fnd_apps_schema, l_schema, ad_ddl.drop_sequence,l_dyn_sql, p_item_catalog_seq_name);
3248: EXCEPTION
3249: WHEN others THEN
3250: x_return_status := G_RET_STS_UNEXP_ERROR;
3251: x_msg_data := G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;

Line 6112: --bugfix 11907422 for 12.2 AD_DDL changes

6108:
6109: END IF;
6110:
6111:
6112: --bugfix 11907422 for 12.2 AD_DDL changes
6113: --EXECUTE IMMEDIATE l_final_view_sql;
6114: h_x := FND_INSTALLATION.Get_App_Info('FND', h_status, h_industry, fnd_apps_schema);
6115: --bug 12392423, hard code APPS as second parameter
6116: AD_DDL.DO_DDL(fnd_apps_schema, 'APPS',ad_ddl.create_view,l_final_view_sql, p_final_agv_name);

Line 6116: AD_DDL.DO_DDL(fnd_apps_schema, 'APPS',ad_ddl.create_view,l_final_view_sql, p_final_agv_name);

6112: --bugfix 11907422 for 12.2 AD_DDL changes
6113: --EXECUTE IMMEDIATE l_final_view_sql;
6114: h_x := FND_INSTALLATION.Get_App_Info('FND', h_status, h_industry, fnd_apps_schema);
6115: --bug 12392423, hard code APPS as second parameter
6116: AD_DDL.DO_DDL(fnd_apps_schema, 'APPS',ad_ddl.create_view,l_final_view_sql, p_final_agv_name);
6117:
6118:
6119: x_return_status := FND_API.G_RET_STS_SUCCESS;
6120: