APPS.AMS_DMSOURCE_PVT dependencies on FND_ORACLE_SCHEMA

Line 1397: l_odm_schema := FND_ORACLE_SCHEMA.GetOuValue('ODMSCHEMA');

1393: END IF;
1394:
1395: -- changed rosharma 18-nov-2003
1396: --l_odm_schema := FND_PROFILE.value ('AMS_ODM_OUTPUT_SCHEMA');
1397: l_odm_schema := FND_ORACLE_SCHEMA.GetOuValue('ODMSCHEMA');
1398: IF (AMS_DEBUG_HIGH_ON) THEN
1399: AMS_Utility_PVT.debug_message (L_API_NAME || ' - ODM output schema: ' || l_odm_schema);
1400: END IF;
1401: -- end change rosharma 18-nov-2003

Line 1485: l_odm_schema := fnd_oracle_schema.GetOuValue(G_ODM_SCHEMA_LOOKUP);

1481: AMS_Utility_PVT.debug_message (L_API_NAME || ': BEGIN');
1482: END IF;
1483:
1484: -- Get the ODM schema name that willbe used later for GRANTS and SYNONYMS
1485: l_odm_schema := fnd_oracle_schema.GetOuValue(G_ODM_SCHEMA_LOOKUP);
1486: IF l_odm_schema IS NULL THEN
1487: l_odm_schema := G_ODM_SCHEMA_NAME;
1488: END IF;
1489:

Line 1891: l_odm_schema := fnd_oracle_schema.GetOuValue(G_ODM_SCHEMA_LOOKUP);

1887: AMS_Utility_PVT.debug_message ('create_build_views BEGIN' );
1888: END IF;
1889:
1890: -- Get the ODM schema name that willbe used later for GRANTS and SYNONYMS
1891: l_odm_schema := fnd_oracle_schema.GetOuValue(G_ODM_SCHEMA_LOOKUP);
1892: IF l_odm_schema IS NULL THEN
1893: l_odm_schema := G_ODM_SCHEMA_NAME;
1894: END IF;
1895:

Line 1964: l_odm_schema := fnd_oracle_schema.GetOuValue(G_ODM_SCHEMA_LOOKUP);

1960: AMS_Utility_PVT.debug_message ('create_apply_views BEGIN' );
1961: END IF;
1962:
1963: -- Get the ODM schema name that willbe used later for GRANTS and SYNONYMS
1964: l_odm_schema := fnd_oracle_schema.GetOuValue(G_ODM_SCHEMA_LOOKUP);
1965: IF l_odm_schema IS NULL THEN
1966: l_odm_schema := G_ODM_SCHEMA_NAME;
1967: END IF;
1968: