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

Line 299: --new function created to use ad_ddl

295: RETURN l_sqlerrm;
296:
297: END Execute_DDL_And_Return_Err;
298:
299: --new function created to use ad_ddl
300: ----bugfix 11907422 for 12.2 AD_DDL changes
301: FUNCTION Execute_AD_DDL_And_Return_Err (
302: p_ddl_sql IN VARCHAR2,
303: p_object_owner IN VARCHAR2,

Line 300: ----bugfix 11907422 for 12.2 AD_DDL changes

296:
297: END Execute_DDL_And_Return_Err;
298:
299: --new function created to use ad_ddl
300: ----bugfix 11907422 for 12.2 AD_DDL changes
301: FUNCTION Execute_AD_DDL_And_Return_Err (
302: p_ddl_sql IN VARCHAR2,
303: p_object_owner IN VARCHAR2,
304: p_object_name IN VARCHAR2,

Line 301: FUNCTION Execute_AD_DDL_And_Return_Err (

297: END Execute_DDL_And_Return_Err;
298:
299: --new function created to use ad_ddl
300: ----bugfix 11907422 for 12.2 AD_DDL changes
301: FUNCTION Execute_AD_DDL_And_Return_Err (
302: p_ddl_sql IN VARCHAR2,
303: p_object_owner IN VARCHAR2,
304: p_object_name IN VARCHAR2,
305: p_ad_ddl_cmd IN VARCHAR2

Line 305: p_ad_ddl_cmd IN VARCHAR2

301: FUNCTION Execute_AD_DDL_And_Return_Err (
302: p_ddl_sql IN VARCHAR2,
303: p_object_owner IN VARCHAR2,
304: p_object_name IN VARCHAR2,
305: p_ad_ddl_cmd IN VARCHAR2
306: )
307: RETURN VARCHAR2
308: IS
309:

Line 324: AD_DDL.DO_DDL(fnd_apps_schema, p_object_owner, p_ad_ddl_cmd,p_ddl_sql,p_object_name);

320:
321:
322: h_x := FND_INSTALLATION.Get_App_Info('FND', h_status, h_industry, fnd_apps_schema);
323:
324: AD_DDL.DO_DDL(fnd_apps_schema, p_object_owner, p_ad_ddl_cmd,p_ddl_sql,p_object_name);
325: RETURN NULL;
326:
327: EXCEPTION
328: WHEN OTHERS THEN

Line 329: l_sqlerrm := SQLERRM||AD_DDL.ERROR_BUF;

325: RETURN NULL;
326:
327: EXCEPTION
328: WHEN OTHERS THEN
329: l_sqlerrm := SQLERRM||AD_DDL.ERROR_BUF;
330: RETURN l_sqlerrm;
331:
332: END Execute_AD_DDL_And_Return_Err;
333:

Line 332: END Execute_AD_DDL_And_Return_Err;

328: WHEN OTHERS THEN
329: l_sqlerrm := SQLERRM||AD_DDL.ERROR_BUF;
330: RETURN l_sqlerrm;
331:
332: END Execute_AD_DDL_And_Return_Err;
333:
334: ---------------------------------------------------------------------
335: -- Requirement: bug: 3542670
336: --

Line 1439: --bugfix 11907422 for 12.2 AD_DDL changes

1435: END IF;
1436:
1437: l_dynamic_sql := l_dynamic_sql||p_column||') LOCAL COMPUTE STATISTICS';
1438:
1439: --bugfix 11907422 for 12.2 AD_DDL changes
1440: --EXECUTE IMMEDIATE l_dynamic_sql;
1441: h_sql := l_dynamic_sql;
1442: h_x := FND_INSTALLATION.Get_App_Info('FND', h_status, h_industry, fnd_apps_schema);
1443: AD_DDL.DO_DDL(fnd_apps_schema, l_table_owner, AD_DDL.CREATE_INDEX, h_sql, l_index_name);

Line 1443: AD_DDL.DO_DDL(fnd_apps_schema, l_table_owner, AD_DDL.CREATE_INDEX, h_sql, l_index_name);

1439: --bugfix 11907422 for 12.2 AD_DDL changes
1440: --EXECUTE IMMEDIATE l_dynamic_sql;
1441: h_sql := l_dynamic_sql;
1442: h_x := FND_INSTALLATION.Get_App_Info('FND', h_status, h_industry, fnd_apps_schema);
1443: AD_DDL.DO_DDL(fnd_apps_schema, l_table_owner, AD_DDL.CREATE_INDEX, h_sql, l_index_name);
1444:
1445:
1446: END IF;-- IF(p_is_column_indexed IS NULL OR p_is_column_indexed <> 'Y')
1447:

Line 1462: --bugfix 11907422 for 12.2 AD_DDL changes

1458: END IF;
1459:
1460: l_chg_dynamic_sql := l_chg_dynamic_sql||p_column||') LOCAL COMPUTE STATISTICS';
1461:
1462: --bugfix 11907422 for 12.2 AD_DDL changes
1463: --EXECUTE IMMEDIATE l_chg_dynamic_sql;
1464: h_sql := l_chg_dynamic_sql;
1465: h_x := FND_INSTALLATION.Get_App_Info('FND', h_status, h_industry, fnd_apps_schema);
1466: AD_DDL.DO_DDL(fnd_apps_schema, l_table_owner, AD_DDL.CREATE_INDEX, h_sql, l_chg_index_name);

Line 1466: AD_DDL.DO_DDL(fnd_apps_schema, l_table_owner, AD_DDL.CREATE_INDEX, h_sql, l_chg_index_name);

1462: --bugfix 11907422 for 12.2 AD_DDL changes
1463: --EXECUTE IMMEDIATE l_chg_dynamic_sql;
1464: h_sql := l_chg_dynamic_sql;
1465: h_x := FND_INSTALLATION.Get_App_Info('FND', h_status, h_industry, fnd_apps_schema);
1466: AD_DDL.DO_DDL(fnd_apps_schema, l_table_owner, AD_DDL.CREATE_INDEX, h_sql, l_chg_index_name);
1467:
1468: END IF;--IF(p_is_chg_column_indexed IS NULL OR p_is_chg_column_indexed <> 'Y')
1469: RETURN 'Y';
1470:

Line 3733: --bugfix 11907422 for 12.2 AD_DDL changes

3729: ' AS SELECT EXTENSION_ID, '||l_pk_col_names||l_dl_col_names||l_aliased_attr_names||
3730: ' FROM '||l_attr_group_metadata_obj.EXT_TABLE_VL_NAME ||
3731: ' WHERE attr_group_id = ' || p_attr_group_id ;
3732:
3733: --bugfix 11907422 for 12.2 AD_DDL changes
3734: --l_ddl_error_message := Execute_DDL_And_Return_Err(l_user_attrs_view_ddl);
3735:
3736: h_x := FND_INSTALLATION.Get_App_Info('FND', h_status, h_industry, fnd_apps_schema);
3737: --since this is view object_owner is same as APPS

Line 3739: --l_ddl_error_message:= Execute_AD_DDL_And_Return_Err(l_user_attrs_view_ddl,'APPS',l_attr_group_metadata_obj.AGV_NAME,ad_ddl.create_view);

3735:
3736: h_x := FND_INSTALLATION.Get_App_Info('FND', h_status, h_industry, fnd_apps_schema);
3737: --since this is view object_owner is same as APPS
3738: --bug 12392423, hard code APPS as second parameter
3739: --l_ddl_error_message:= Execute_AD_DDL_And_Return_Err(l_user_attrs_view_ddl,'APPS',l_attr_group_metadata_obj.AGV_NAME,ad_ddl.create_view);
3740: begin
3741: AD_DDL.DO_DDL(fnd_apps_schema, 'APPS',ad_ddl.create_view,l_user_attrs_view_ddl, l_attr_group_metadata_obj.AGV_NAME);
3742: EXCEPTION
3743: WHEN OTHERS

Line 3741: AD_DDL.DO_DDL(fnd_apps_schema, 'APPS',ad_ddl.create_view,l_user_attrs_view_ddl, l_attr_group_metadata_obj.AGV_NAME);

3737: --since this is view object_owner is same as APPS
3738: --bug 12392423, hard code APPS as second parameter
3739: --l_ddl_error_message:= Execute_AD_DDL_And_Return_Err(l_user_attrs_view_ddl,'APPS',l_attr_group_metadata_obj.AGV_NAME,ad_ddl.create_view);
3740: begin
3741: AD_DDL.DO_DDL(fnd_apps_schema, 'APPS',ad_ddl.create_view,l_user_attrs_view_ddl, l_attr_group_metadata_obj.AGV_NAME);
3742: EXCEPTION
3743: WHEN OTHERS
3744: THEN
3745: l_ddl_error_message := SQLERRM || ad_ddl.error_buf;

Line 3745: l_ddl_error_message := SQLERRM || ad_ddl.error_buf;

3741: AD_DDL.DO_DDL(fnd_apps_schema, 'APPS',ad_ddl.create_view,l_user_attrs_view_ddl, l_attr_group_metadata_obj.AGV_NAME);
3742: EXCEPTION
3743: WHEN OTHERS
3744: THEN
3745: l_ddl_error_message := SQLERRM || ad_ddl.error_buf;
3746: END;
3747:
3748: ---------------------------------------------------------------
3749: -- If something went wrong with the DDL, we report the error --

Line 14891: --bugfix 11907422 for 12.2 AD_DDL changes

14887: --Test with this dummy Query for the validity of the view name
14888: --It should not be a reserve word
14889: l_dynamic_sql := 'CREATE OR REPLACE VIEW '|| l_agv_name ||' AS SELECT * FROM DUAL';
14890:
14891: --bugfix 11907422 for 12.2 AD_DDL changes
14892: --EXECUTE IMMEDIATE l_dynamic_sql;
14893:
14894: h_x := FND_INSTALLATION.Get_App_Info('FND', h_status, h_industry, fnd_apps_schema);
14895: --bug 12392423, hard code APPS

Line 14896: AD_DDL.DO_DDL(fnd_apps_schema, 'APPS', AD_DDL.CREATE_VIEW,l_dynamic_sql, l_agv_name);

14892: --EXECUTE IMMEDIATE l_dynamic_sql;
14893:
14894: h_x := FND_INSTALLATION.Get_App_Info('FND', h_status, h_industry, fnd_apps_schema);
14895: --bug 12392423, hard code APPS
14896: AD_DDL.DO_DDL(fnd_apps_schema, 'APPS', AD_DDL.CREATE_VIEW,l_dynamic_sql, l_agv_name);
14897:
14898: -- Syalaman - Fix for bug 5911824
14899: -- Droping the dummy view created in above statement so that
14900: -- if any error occurs while creating the actual view, this

Line 14904: --bugfix 11907422 for 12.2 AD_DDL changes

14900: -- if any error occurs while creating the actual view, this
14901: -- dummy view should not exist in the database.
14902: l_dynamic_sql := 'DROP VIEW '|| l_agv_name;
14903:
14904: --bugfix 11907422 for 12.2 AD_DDL changes
14905: -- EXECUTE IMMEDIATE l_dynamic_sql;
14906: --bug 12392423, hard code APPS
14907: AD_DDL.DO_DDL(fnd_apps_schema, 'APPS', AD_DDL.DROP_VIEW,l_dynamic_sql,l_agv_name);
14908:

Line 14907: AD_DDL.DO_DDL(fnd_apps_schema, 'APPS', AD_DDL.DROP_VIEW,l_dynamic_sql,l_agv_name);

14903:
14904: --bugfix 11907422 for 12.2 AD_DDL changes
14905: -- EXECUTE IMMEDIATE l_dynamic_sql;
14906: --bug 12392423, hard code APPS
14907: AD_DDL.DO_DDL(fnd_apps_schema, 'APPS', AD_DDL.DROP_VIEW,l_dynamic_sql,l_agv_name);
14908:
14909: -- End of fix for bug 5911824
14910:
14911: --

Line 16208: --bugfix 11907422 for 12.2 AD_DDL changes

16204: FETCH c INTO obj_name;
16205: IF c%FOUND THEN
16206: l_drop_sql := 'DROP VIEW '|| obj_name;
16207:
16208: --bugfix 11907422 for 12.2 AD_DDL changes
16209: --EXECUTE IMMEDIATE l_drop_sql;
16210:
16211: h_x := FND_INSTALLATION.Get_App_Info('FND', h_status, h_industry, fnd_apps_schema);
16212: --bug 12392423, hard code APPS as second parameter

Line 16213: AD_DDL.DO_DDL(fnd_apps_schema,'APPS', AD_DDL.DROP_VIEW,l_drop_sql,obj_name);

16209: --EXECUTE IMMEDIATE l_drop_sql;
16210:
16211: h_x := FND_INSTALLATION.Get_App_Info('FND', h_status, h_industry, fnd_apps_schema);
16212: --bug 12392423, hard code APPS as second parameter
16213: AD_DDL.DO_DDL(fnd_apps_schema,'APPS', AD_DDL.DROP_VIEW,l_drop_sql,obj_name);
16214: COMMIT;
16215: END IF;
16216: CLOSE c;
16217: END Delete_Attr_Group_Views;