APPS.AS_SC_DENORM dependencies on FND_INSTALLATION

Line 84: l_schema_return := FND_INSTALLATION.get_app_info('AS', l_fnd_status, l_industry, l_oracle_schema);

80:
81: l_module CONSTANT VARCHAR2(255) := 'as.plsql.scden.Populate_as_period_days';
82:
83: BEGIN
84: l_schema_return := FND_INSTALLATION.get_app_info('AS', l_fnd_status, l_industry, l_oracle_schema);
85:
86: IF p_debug_mode = 'Y' THEN
87: G_Debug := TRUE;
88: ELSE

Line 180: l_schema_return := FND_INSTALLATION.get_app_info('AS', l_fnd_status, l_industry, l_oracle_schema);

176: and table_name in ('ASF_SCBINLD_SUMMV','ASF_SCBIN_SUMMV');
177:
178: ddl_curs integer;
179: BEGIN
180: l_schema_return := FND_INSTALLATION.get_app_info('AS', l_fnd_status, l_industry, l_oracle_schema);
181:
182: SELECT USER INTO l_apps_schema FROM DUAL;
183:
184: ddl_curs := dbms_sql.open_cursor;

Line 747: l_schema_return := FND_INSTALLATION.get_app_info('AS', l_fnd_status, l_industry, l_oracle_schema);

743: l_oracle_schema VARCHAR2(32);
744: l_schema_return BOOLEAN;
745: l_module CONSTANT VARCHAR2(255) := 'as.plsql.scden.Main';
746: BEGIN
747: l_schema_return := FND_INSTALLATION.get_app_info('AS', l_fnd_status, l_industry, l_oracle_schema);
748:
749: IF p_debug_mode = 'Y' THEN G_Debug := TRUE; ELSE G_Debug := FALSE; END IF;
750:
751: IF p_trace_mode = 'Y' THEN trace(TRUE); ELSE trace(FALSE); END IF;