APPS.AMS_METRIC_PVT dependencies on AMS_LOOKUPS

Line 1895: select count(1) from ams_lookups

1891: l_additional_where_clause VARCHAR2(4000); -- Used by Check_FK_Exists.
1892: l_lookup_type VARCHAR2(30);
1893:
1894: Cursor c_check_object_type(l_arc_metric_used_for_object VARCHAR2) is
1895: select count(1) from ams_lookups
1896: where lookup_type in ('AMS_METRIC_ROLLUP_TYPE', 'AMS_METRIC_OBJECT_TYPE', 'AMS_METRIC_ALLOCATION_TYPE')
1897: and lookup_code = l_arc_metric_used_for_object;
1898:
1899: Cursor c_check_special_type(l_arc_metric_used_for_object VARCHAR2) is

Line 1900: select count(1) from ams_lookups

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

Line 1905: select count(1) from ams_lookups

1901: where lookup_type in ('AMS_METRIC_SPECIAL_TYPE')
1902: and lookup_code = l_arc_metric_used_for_object;
1903:
1904: Cursor c_check_all_type(l_arc_metric_used_for_object VARCHAR2) is
1905: select count(1) from ams_lookups
1906: where lookup_type in ('AMS_METRIC_SPECIAL_TYPE', 'AMS_METRIC_ROLLUP_TYPE',
1907: 'AMS_METRIC_OBJECT_TYPE', 'AMS_METRIC_ALLOCATION_TYPE')
1908: and lookup_code = l_arc_metric_used_for_object;
1909:

Line 2198: p_lookup_table_name => 'AMS_LOOKUPS'

2194: -- ACCRUAL_TYPE
2195: IF l_metrics_rec.accrual_type <> FND_API.G_MISS_CHAR THEN
2196: l_lookup_type := 'AMS_METRIC_ACCRUAL_TYPE';
2197: IF Ams_Utility_Pvt.Check_Lookup_Exists (
2198: p_lookup_table_name => 'AMS_LOOKUPS'
2199: ,p_lookup_type => l_lookup_type
2200: ,p_lookup_code => l_metrics_rec.accrual_type
2201: ) = FND_API.G_FALSE
2202: THEN

Line 2219: p_lookup_table_name => 'AMS_LOOKUPS'

2215: IF l_metrics_rec.metric_calculation_type <> FND_API.G_MISS_CHAR THEN
2216: l_lookup_type := 'AMS_METRIC_CALCULATION_TYPE';
2217: IF -- l_metrics_rec.metric_calculation_type <> G_SUMMARY AND
2218: Ams_Utility_Pvt.Check_Lookup_Exists (
2219: p_lookup_table_name => 'AMS_LOOKUPS'
2220: ,p_lookup_type => l_lookup_type
2221: ,p_lookup_code => l_metrics_rec.metric_calculation_type
2222: ) = FND_API.G_FALSE
2223: THEN

Line 2239: p_lookup_table_name => 'AMS_LOOKUPS'

2235: -- VALUE_TYPE
2236: IF l_metrics_rec.DISPLAY_TYPE <> FND_API.G_MISS_CHAR THEN
2237: l_lookup_type := 'AMS_METRIC_DISPLAY_TYPE';
2238: IF Ams_Utility_Pvt.Check_Lookup_Exists (
2239: p_lookup_table_name => 'AMS_LOOKUPS'
2240: ,p_lookup_type => l_lookup_type
2241: ,p_lookup_code => l_metrics_rec.DISPLAY_TYPE
2242: ) = FND_API.G_FALSE
2243: THEN

Line 2259: p_lookup_table_name => 'AMS_LOOKUPS'

2255: -- VALUE_TYPE
2256: IF l_metrics_rec.value_type <> FND_API.G_MISS_CHAR THEN
2257: l_lookup_type := 'AMS_METRIC_VALUE_TYPE';
2258: IF Ams_Utility_Pvt.Check_Lookup_Exists (
2259: p_lookup_table_name => 'AMS_LOOKUPS'
2260: ,p_lookup_type => l_lookup_type
2261: ,p_lookup_code => l_metrics_rec.value_type
2262: ) = FND_API.G_FALSE
2263: THEN

Line 2309: -- p_lookup_table_name => 'AMS_LOOKUPS'

2305: AND l_metrics_rec.metric_calculation_type in (G_ROLLUP, G_SUMMARY))
2306:
2307: -- l_lookup_type := 'AMS_SYS_ARC_QUALIFIER';
2308: -- IF AMS_Utility_PVT.Check_Lookup_Exists (
2309: -- p_lookup_table_name => 'AMS_LOOKUPS'
2310: -- ,p_lookup_type => l_lookup_type
2311: -- ,p_lookup_code => l_metrics_rec.arc_metric_used_for_object
2312: -- ) = FND_API.G_FALSE
2313: THEN

Line 2518: l_name ams_lookups.meaning%TYPE;

2514:
2515: l_category_id number;
2516: l_object_type varchar2(30);
2517: l_calculation_type varchar2(30);
2518: l_name ams_lookups.meaning%TYPE;
2519:
2520: l_count NUMBER := 0;
2521: l_valid_chld_flag VARCHAR2(1);
2522: