DBA Data[Home] [Help]

APPS.FEM_DATABASE_UTIL_PKG dependencies on FND_INSTALLATION

Line 683: -- FND_INSTALLATION.Get_App_Info function.

679: v_sql_statement VARCHAR2(32767);
680: v_sqlerrm VARCHAR2(255);
681:
682: v_fnd_schema VARCHAR2(30); -- the schema name returned by the
683: -- FND_INSTALLATION.Get_App_Info function.
684: -- Also required for the FND_INSTALLATION.Get_App_Info function, but the return
685: -- values are not actually used.
686: v_fnd_status VARCHAR2(100);
687: v_fnd_industry VARCHAR2(100);

Line 684: -- Also required for the FND_INSTALLATION.Get_App_Info function, but the return

680: v_sqlerrm VARCHAR2(255);
681:
682: v_fnd_schema VARCHAR2(30); -- the schema name returned by the
683: -- FND_INSTALLATION.Get_App_Info function.
684: -- Also required for the FND_INSTALLATION.Get_App_Info function, but the return
685: -- values are not actually used.
686: v_fnd_status VARCHAR2(100);
687: v_fnd_industry VARCHAR2(100);
688:

Line 819: IF FND_INSTALLATION.Get_App_Info (

815: ' PCTINCREASE 0)' ||
816: ' INITRANS 10 MAXTRANS 255 PCTFREE 10 ';
817:
818: -- Get the schema name for the FEM application
819: IF FND_INSTALLATION.Get_App_Info (
820: APPLICATION_SHORT_NAME => 'FEM',
821: STATUS => v_fnd_status,
822: INDUSTRY => v_fnd_industry,
823: ORACLE_SCHEMA => v_fnd_schema) THEN

Line 1044: -- FND_INSTALLATION.Get_App_Info function.

1040: v_sql_statement VARCHAR2(32767);
1041: v_sqlerrm VARCHAR2(255);
1042:
1043: v_fnd_schema VARCHAR2(30); -- the schema name returned by the
1044: -- FND_INSTALLATION.Get_App_Info function.
1045: -- Also required for the FND_INSTALLATION.Get_App_Info function, but the return
1046: -- values are not actually used.
1047: v_fnd_status VARCHAR2(100);
1048: v_fnd_industry VARCHAR2(100);

Line 1045: -- Also required for the FND_INSTALLATION.Get_App_Info function, but the return

1041: v_sqlerrm VARCHAR2(255);
1042:
1043: v_fnd_schema VARCHAR2(30); -- the schema name returned by the
1044: -- FND_INSTALLATION.Get_App_Info function.
1045: -- Also required for the FND_INSTALLATION.Get_App_Info function, but the return
1046: -- values are not actually used.
1047: v_fnd_status VARCHAR2(100);
1048: v_fnd_industry VARCHAR2(100);
1049:

Line 1184: IF FND_INSTALLATION.Get_App_Info (

1180: v_unique := '';
1181: END IF;
1182:
1183: -- Get the schema name for the FEM application
1184: IF FND_INSTALLATION.Get_App_Info (
1185: APPLICATION_SHORT_NAME => 'FEM',
1186: STATUS => v_fnd_status,
1187: INDUSTRY => v_fnd_industry,
1188: ORACLE_SCHEMA => v_fnd_schema) THEN

Line 1573: -- FND_INSTALLATION.Get_App_Info function.

1569: v_sql_statement VARCHAR2(100);
1570: v_sqlerrm VARCHAR2(255);
1571:
1572: v_fnd_schema VARCHAR2(30); -- the schema name returned by the
1573: -- FND_INSTALLATION.Get_App_Info function.
1574: -- Also required for the FND_INSTALLATION.Get_App_Info function, but the return
1575: -- values are not actually used.
1576: v_fnd_status VARCHAR2(100);
1577: v_fnd_industry VARCHAR2(100);

Line 1574: -- Also required for the FND_INSTALLATION.Get_App_Info function, but the return

1570: v_sqlerrm VARCHAR2(255);
1571:
1572: v_fnd_schema VARCHAR2(30); -- the schema name returned by the
1573: -- FND_INSTALLATION.Get_App_Info function.
1574: -- Also required for the FND_INSTALLATION.Get_App_Info function, but the return
1575: -- values are not actually used.
1576: v_fnd_status VARCHAR2(100);
1577: v_fnd_industry VARCHAR2(100);
1578:

Line 1647: IF FND_INSTALLATION.Get_App_Info (

1643: v_ddl_logging := 'OFF';
1644: END IF;
1645:
1646: -- Get the schema name for the FEM application
1647: IF FND_INSTALLATION.Get_App_Info (
1648: APPLICATION_SHORT_NAME => 'FEM',
1649: STATUS => v_fnd_status,
1650: INDUSTRY => v_fnd_industry,
1651: ORACLE_SCHEMA => v_fnd_schema) THEN