eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_METRIC_PVT dependencies on AMS_METRICS_VL

Line 1755: FROM ams_metrics_vl

1751:
1752: CURSOR c_crt_get_dup_names(p_metrics_name VARCHAR2,
1753: p_arc_metric_used_for_object VARCHAR2) IS
1754: SELECT 1
1755: FROM ams_metrics_vl
1756: WHERE UPPER(METRICS_NAME) = UPPER(p_metrics_name)
1757: AND arc_metric_used_for_object = p_arc_metric_used_for_object;
1758:
1759: CURSOR c_upd_get_dup_names(p_metrics_name VARCHAR2,

Line 1762: FROM ams_metrics_vl

1758:
1759: CURSOR c_upd_get_dup_names(p_metrics_name VARCHAR2,
1760: p_arc_metric_used_for_object VARCHAR2, p_metric_id NUMBER) IS
1761: SELECT 1
1762: FROM ams_metrics_vl
1763: WHERE UPPER(METRICS_NAME) = UPPER(p_metrics_name)
1764: AND arc_metric_used_for_object = p_arc_metric_used_for_object
1765: AND metric_id <> p_metric_id ;
1766: l_dummy NUMBER;

Line 1780: p_table_name => 'ams_metrics_vl',

1776: THEN
1777: l_where_clause := ' metric_id = '||p_metric_rec.metric_id ;
1778:
1779: IF Ams_Utility_Pvt.Check_Uniqueness(
1780: p_table_name => 'ams_metrics_vl',
1781: p_where_clause => l_where_clause
1782: ) = FND_API.g_false
1783: THEN
1784: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1814: p_table_name => 'ams_metrics_vl',

1810:
1811: END IF;
1812:
1813: IF AMS_Utility_PVT.Check_Uniqueness(
1814: p_table_name => 'ams_metrics_vl',
1815: p_where_clause => l_where_clause
1816: ) = FND_API.g_false
1817: THEN
1818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1914: SELECT 1 from ams_metrics_vl

1910:
1911: /*sunkumar 20-april-2004 removed reference to check_fk_exists of utility package*/
1912:
1913: CURSOR c_check_metric_id(p_metric_id number, p_metric_calculation varchar2) IS
1914: SELECT 1 from ams_metrics_vl
1915: WHERE METRIC_ID = p_metric_id
1916: AND metric_calculation_type = p_metric_calculation;
1917:
1918:

Line 1970: /* l_table_name := 'AMS_METRICS_VL';

1966:
1967: END IF;
1968:
1969: /*commented by sunkumar 20-april-2004 */
1970: /* l_table_name := 'AMS_METRICS_VL';
1971: l_pk_name := 'METRIC_ID';
1972: l_pk_value := l_metrics_rec.metric_parent_id;
1973: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
1974: l_additional_where_clause := ' metric_calculation_type = '''||G_ROLLUP||'''';

Line 2023: /* l_table_name := 'AMS_METRICS_VL';

2019:
2020: END IF;
2021:
2022:
2023: /* l_table_name := 'AMS_METRICS_VL';
2024: l_pk_name := 'METRIC_ID';
2025: l_pk_value := l_metrics_rec.summary_metric_id;
2026: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
2027: l_additional_where_clause := ' metric_calculation_type = '''||G_SUMMARY||'''';

Line 2461: FROM ams_metrics_vl met

2457: -- l_metrics_rec metric_rec_type := p_metric_rec ;
2458:
2459: CURSOR c_summary_metric(l_metric_id number) IS
2460: SELECT met.*
2461: FROM ams_metrics_vl met
2462: WHERE met.metric_id = l_metric_id
2463: ;
2464: l_summary_metric_rec c_summary_metric%ROWTYPE;
2465:

Line 2468: FROM ams_metrics_vl met

2464: l_summary_metric_rec c_summary_metric%ROWTYPE;
2465:
2466: CURSOR c_rollup_metric(l_metric_id number) IS
2467: SELECT met.*
2468: FROM ams_metrics_vl met
2469: WHERE met.metric_id = l_metric_id
2470: ;
2471:
2472: l_rollup_metric_rec c_rollup_metric%ROWTYPE;

Line 2479: FROM ams_metrics_vl

2475: -- Metric or Rollup Metric but not both.
2476:
2477: CURSOR c_rollup_count(l_metric_id number) IS
2478: SELECT COUNT(1)
2479: FROM ams_metrics_vl
2480: WHERE metric_parent_id = l_metric_id ;
2481:
2482: CURSOR c_summary_count(l_metric_id number) IS
2483: SELECT COUNT(1)

Line 2484: FROM ams_metrics_vl

2480: WHERE metric_parent_id = l_metric_id ;
2481:
2482: CURSOR c_summary_count(l_metric_id number) IS
2483: SELECT COUNT(1)
2484: FROM ams_metrics_vl
2485: WHERE summary_metric_id = l_metric_id ;
2486:
2487: CURSOR c_check_multiplier (l_metric_id number) IS
2488: select metric_category, ARC_METRIC_USED_FOR_OBJECT, metric_calculation_type

Line 3200: -- AMS_METRICS_VL

3196: -- IF l_metrics_rec.metric_parent_id IS NULL THEN
3197: -- l_metrics_validate_fk_rec.metric_parent_id := FND_API.G_FALSE;
3198: -- END IF;
3199: -- IF l_metrics_validate_fk_rec.metric_parent_id = FND_API.G_TRUE THEN
3200: -- AMS_METRICS_VL
3201: -- Start of the changes made by PTENDULK on 08/19/1999
3202: -- The check is modified to check whether this metric id is parent metric
3203: -- id of any other id
3204:

Line 3208: -- p_table_name => 'AMS_METRICS_VL',

3204:
3205: -- Original Code
3206:
3207: -- IF AMS_Utility_PVT.Check_FK_Exists (
3208: -- p_table_name => 'AMS_METRICS_VL',
3209: -- p_pk_name => 'METRIC_ID',
3210: -- p_pk_value => l_metrics_rec.metric_parent_id
3211: -- ) = FND_API.G_TRUE
3212: -- THEN

Line 3222: -- p_table_name => 'AMS_METRICS_VL',

3218:
3219: -- comment out the following for bug 1356700 fix
3220: -- 07/17/2000 khung
3221: -- IF AMS_Utility_PVT.Check_FK_Exists (
3222: -- p_table_name => 'AMS_METRICS_VL',
3223: -- p_pk_name => 'METRIC_PARENT_ID',
3224: -- p_pk_value => l_metric_id,
3225: -- p_pk_data_type => AMS_Utility_PVT.G_NUMBER
3226: -- ) = FND_API.G_TRUE

Line 3243: -- AMS_METRICS_VL

3239: -- IF l_metrics_rec.summary_metric_id IS NULL THEN
3240: -- l_metrics_validate_fk_rec.summary_metric_id := FND_API.G_FALSE;
3241: -- END IF;
3242: -- IF l_metrics_validate_fk_rec.summary_metric_id = FND_API.G_TRUE THEN
3243: -- AMS_METRICS_VL
3244: -- Start of the changes made by PTENDULK on 08/19/1999
3245: -- The check is modified to check whether this metric id is Summary metric
3246: -- id of any other metric id
3247: -- Original Code

Line 3249: -- p_table_name => 'AMS_METRICS_VL',

3245: -- The check is modified to check whether this metric id is Summary metric
3246: -- id of any other metric id
3247: -- Original Code
3248: -- IF AMS_Utility_PVT.Check_FK_Exists (
3249: -- p_table_name => 'AMS_METRICS_VL',
3250: -- p_pk_name => 'METRIC_ID',
3251: -- p_pk_value => l_metrics_rec.summary_metric_id
3252: -- ) = FND_API.G_TRUE
3253:

Line 3262: -- p_table_name => 'AMS_METRICS_VL',

3258:
3259: -- comment out the following for bug 1356700 fix
3260: -- 07/17/2000 khung
3261: -- IF AMS_Utility_PVT.Check_FK_Exists (
3262: -- p_table_name => 'AMS_METRICS_VL',
3263: -- p_pk_name => 'SUMMARY_METRIC_ID',
3264: -- p_pk_value => l_metric_id,
3265: -- p_pk_data_type => AMS_Utility_PVT.G_NUMBER
3266: -- ) = FND_API.G_TRUE

Line 3340: FROM ams_metrics_vl

3336: ,set_function_name
3337: ,display_type
3338: ,target_type
3339: ,denorm_code
3340: FROM ams_metrics_vl
3341: WHERE metric_id = p_metric_rec.metric_id;
3342:
3343: --l_metric_rec c_metric%ROWTYPE;
3344: BEGIN