APPS.AMS_METRIC_PVT dependencies on AMS_LOOKUPS

Line 1888: select count(1) from ams_lookups

1884: l_additional_where_clause VARCHAR2(4000); -- Used by Check_FK_Exists.
1885: l_lookup_type VARCHAR2(30);
1886:
1887: Cursor c_check_object_type(l_arc_metric_used_for_object VARCHAR2) is
1888: select count(1) from ams_lookups
1889: where lookup_type in ('AMS_METRIC_ROLLUP_TYPE', 'AMS_METRIC_OBJECT_TYPE', 'AMS_METRIC_ALLOCATION_TYPE')
1890: and lookup_code = l_arc_metric_used_for_object;
1891:
1892: Cursor c_check_special_type(l_arc_metric_used_for_object VARCHAR2) is

Line 1893: select count(1) from ams_lookups

1889: where lookup_type in ('AMS_METRIC_ROLLUP_TYPE', 'AMS_METRIC_OBJECT_TYPE', 'AMS_METRIC_ALLOCATION_TYPE')
1890: and lookup_code = l_arc_metric_used_for_object;
1891:
1892: Cursor c_check_special_type(l_arc_metric_used_for_object VARCHAR2) is
1893: select count(1) from ams_lookups
1894: where lookup_type in ('AMS_METRIC_SPECIAL_TYPE')
1895: and lookup_code = l_arc_metric_used_for_object;
1896:
1897: Cursor c_check_all_type(l_arc_metric_used_for_object VARCHAR2) is

Line 1898: select count(1) from ams_lookups

1894: where lookup_type in ('AMS_METRIC_SPECIAL_TYPE')
1895: and lookup_code = l_arc_metric_used_for_object;
1896:
1897: Cursor c_check_all_type(l_arc_metric_used_for_object VARCHAR2) is
1898: select count(1) from ams_lookups
1899: where lookup_type in ('AMS_METRIC_SPECIAL_TYPE', 'AMS_METRIC_ROLLUP_TYPE',
1900: 'AMS_METRIC_OBJECT_TYPE', 'AMS_METRIC_ALLOCATION_TYPE')
1901: and lookup_code = l_arc_metric_used_for_object;
1902:

Line 2191: p_lookup_table_name => 'AMS_LOOKUPS'

2187: -- ACCRUAL_TYPE
2188: IF l_metrics_rec.accrual_type <> FND_API.G_MISS_CHAR THEN
2189: l_lookup_type := 'AMS_METRIC_ACCRUAL_TYPE';
2190: IF Ams_Utility_Pvt.Check_Lookup_Exists (
2191: p_lookup_table_name => 'AMS_LOOKUPS'
2192: ,p_lookup_type => l_lookup_type
2193: ,p_lookup_code => l_metrics_rec.accrual_type
2194: ) = FND_API.G_FALSE
2195: THEN

Line 2212: p_lookup_table_name => 'AMS_LOOKUPS'

2208: IF l_metrics_rec.metric_calculation_type <> FND_API.G_MISS_CHAR THEN
2209: l_lookup_type := 'AMS_METRIC_CALCULATION_TYPE';
2210: IF -- l_metrics_rec.metric_calculation_type <> G_SUMMARY AND
2211: Ams_Utility_Pvt.Check_Lookup_Exists (
2212: p_lookup_table_name => 'AMS_LOOKUPS'
2213: ,p_lookup_type => l_lookup_type
2214: ,p_lookup_code => l_metrics_rec.metric_calculation_type
2215: ) = FND_API.G_FALSE
2216: THEN

Line 2232: p_lookup_table_name => 'AMS_LOOKUPS'

2228: -- VALUE_TYPE
2229: IF l_metrics_rec.DISPLAY_TYPE <> FND_API.G_MISS_CHAR THEN
2230: l_lookup_type := 'AMS_METRIC_DISPLAY_TYPE';
2231: IF Ams_Utility_Pvt.Check_Lookup_Exists (
2232: p_lookup_table_name => 'AMS_LOOKUPS'
2233: ,p_lookup_type => l_lookup_type
2234: ,p_lookup_code => l_metrics_rec.DISPLAY_TYPE
2235: ) = FND_API.G_FALSE
2236: THEN

Line 2252: p_lookup_table_name => 'AMS_LOOKUPS'

2248: -- VALUE_TYPE
2249: IF l_metrics_rec.value_type <> FND_API.G_MISS_CHAR THEN
2250: l_lookup_type := 'AMS_METRIC_VALUE_TYPE';
2251: IF Ams_Utility_Pvt.Check_Lookup_Exists (
2252: p_lookup_table_name => 'AMS_LOOKUPS'
2253: ,p_lookup_type => l_lookup_type
2254: ,p_lookup_code => l_metrics_rec.value_type
2255: ) = FND_API.G_FALSE
2256: THEN

Line 2302: -- p_lookup_table_name => 'AMS_LOOKUPS'

2298: AND l_metrics_rec.metric_calculation_type in (G_ROLLUP, G_SUMMARY))
2299:
2300: -- l_lookup_type := 'AMS_SYS_ARC_QUALIFIER';
2301: -- IF AMS_Utility_PVT.Check_Lookup_Exists (
2302: -- p_lookup_table_name => 'AMS_LOOKUPS'
2303: -- ,p_lookup_type => l_lookup_type
2304: -- ,p_lookup_code => l_metrics_rec.arc_metric_used_for_object
2305: -- ) = FND_API.G_FALSE
2306: THEN

Line 2511: l_name ams_lookups.meaning%TYPE;

2507:
2508: l_category_id number;
2509: l_object_type varchar2(30);
2510: l_calculation_type varchar2(30);
2511: l_name ams_lookups.meaning%TYPE;
2512:
2513: l_count NUMBER := 0;
2514: l_valid_chld_flag VARCHAR2(1);
2515: