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 911: l_schema_return := FND_INSTALLATION.get_app_info('AS', l_fnd_status, l_industry, l_oracle_schema);

907: l_oracle_schema VARCHAR2(32);
908: l_schema_return BOOLEAN;
909: l_module CONSTANT VARCHAR2(255) := 'as.plsql.scden.Main';
910: BEGIN
911: l_schema_return := FND_INSTALLATION.get_app_info('AS', l_fnd_status, l_industry, l_oracle_schema);
912:
913: IF p_debug_mode = 'Y' THEN G_Debug := TRUE; ELSE G_Debug := FALSE; END IF;
914:
915: IF p_trace_mode = 'Y' THEN trace(TRUE); ELSE trace(FALSE); END IF;