APPS.AMS_METRIC_PVT dependencies on AMS_CATEGORIES_VL

Line 1925: SELECT 1 from AMS_CATEGORIES_VL

1921: WHERE UOM_CLASS = p_uom_type;
1922:
1923:
1924: CURSOR c_check_category(p_category_id number) IS
1925: SELECT 1 from AMS_CATEGORIES_VL
1926: WHERE CATEGORY_ID = p_category_id
1927: AND enabled_flag = 'Y'
1928: AND arc_category_created_for = 'METR';
1929:

Line 2119: /*l_table_name := 'AMS_CATEGORIES_VL';

2115:
2116: END IF;
2117:
2118:
2119: /*l_table_name := 'AMS_CATEGORIES_VL';
2120: l_pk_name := 'CATEGORY_ID';
2121: l_pk_value := l_metrics_rec.metric_category;
2122: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
2123: l_additional_where_clause := ' enabled_flag = ''Y'''||

Line 2494: FROM ams_categories_vl

2490: where metric_id = l_metric_id;
2491:
2492: CURSOR c_get_category_name (l_category_id number) is
2493: SELECT category_name
2494: FROM ams_categories_vl
2495: where category_id = l_category_id;
2496:
2497:
2498: /*sunkumar 20 april 2004*/

Line 2500: SELECT 1 from AMS_CATEGORIES_VL

2496:
2497:
2498: /*sunkumar 20 april 2004*/
2499: CURSOR c_check_subcategory(p_category_id number,p_parent_category_id number ) IS
2500: SELECT 1 from AMS_CATEGORIES_VL
2501: WHERE CATEGORY_ID = p_category_id
2502: AND enabled_flag = 'Y'
2503: AND arc_category_created_for = 'METR'
2504: AND parent_category_id = p_parent_category_id;

Line 2582: /*l_table_name := 'AMS_CATEGORIES_VL';

2578:
2579: END IF; -- default_uom_code is not null
2580:
2581:
2582: /*l_table_name := 'AMS_CATEGORIES_VL';
2583: l_pk_name := 'CATEGORY_ID';
2584: l_pk_value := p_complete_rec.metric_sub_category;
2585: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
2586: l_additional_where_clause := ' enabled_flag = ''Y'''||