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.

[Home] [Help]

APPS.AMS_METRIC_PVT dependencies on AMS_METRICS_VL

Line 1748: FROM ams_metrics_vl

1744:
1745: CURSOR c_crt_get_dup_names(p_metrics_name VARCHAR2,
1746: p_arc_metric_used_for_object VARCHAR2) IS
1747: SELECT 1
1748: FROM ams_metrics_vl
1749: WHERE UPPER(METRICS_NAME) = UPPER(p_metrics_name)
1750: AND arc_metric_used_for_object = p_arc_metric_used_for_object;
1751:
1752: CURSOR c_upd_get_dup_names(p_metrics_name VARCHAR2,

Line 1755: FROM ams_metrics_vl

1751:
1752: CURSOR c_upd_get_dup_names(p_metrics_name VARCHAR2,
1753: p_arc_metric_used_for_object VARCHAR2, p_metric_id NUMBER) 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: AND metric_id <> p_metric_id ;
1759: l_dummy NUMBER;

Line 1773: p_table_name => 'ams_metrics_vl',

1769: THEN
1770: l_where_clause := ' metric_id = '||p_metric_rec.metric_id ;
1771:
1772: IF Ams_Utility_Pvt.Check_Uniqueness(
1773: p_table_name => 'ams_metrics_vl',
1774: p_where_clause => l_where_clause
1775: ) = FND_API.g_false
1776: THEN
1777: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1807: p_table_name => 'ams_metrics_vl',

1803:
1804: END IF;
1805:
1806: IF AMS_Utility_PVT.Check_Uniqueness(
1807: p_table_name => 'ams_metrics_vl',
1808: p_where_clause => l_where_clause
1809: ) = FND_API.g_false
1810: THEN
1811: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1907: SELECT 1 from ams_metrics_vl

1903:
1904: /*sunkumar 20-april-2004 removed reference to check_fk_exists of utility package*/
1905:
1906: CURSOR c_check_metric_id(p_metric_id number, p_metric_calculation varchar2) IS
1907: SELECT 1 from ams_metrics_vl
1908: WHERE METRIC_ID = p_metric_id
1909: AND metric_calculation_type = p_metric_calculation;
1910:
1911:

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

1959:
1960: END IF;
1961:
1962: /*commented by sunkumar 20-april-2004 */
1963: /* l_table_name := 'AMS_METRICS_VL';
1964: l_pk_name := 'METRIC_ID';
1965: l_pk_value := l_metrics_rec.metric_parent_id;
1966: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
1967: l_additional_where_clause := ' metric_calculation_type = '''||G_ROLLUP||'''';

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

2012:
2013: END IF;
2014:
2015:
2016: /* l_table_name := 'AMS_METRICS_VL';
2017: l_pk_name := 'METRIC_ID';
2018: l_pk_value := l_metrics_rec.summary_metric_id;
2019: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
2020: l_additional_where_clause := ' metric_calculation_type = '''||G_SUMMARY||'''';

Line 2454: FROM ams_metrics_vl met

2450: -- l_metrics_rec metric_rec_type := p_metric_rec ;
2451:
2452: CURSOR c_summary_metric(l_metric_id number) IS
2453: SELECT met.*
2454: FROM ams_metrics_vl met
2455: WHERE met.metric_id = l_metric_id
2456: ;
2457: l_summary_metric_rec c_summary_metric%ROWTYPE;
2458:

Line 2461: FROM ams_metrics_vl met

2457: l_summary_metric_rec c_summary_metric%ROWTYPE;
2458:
2459: CURSOR c_rollup_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:
2465: l_rollup_metric_rec c_rollup_metric%ROWTYPE;

Line 2472: FROM ams_metrics_vl

2468: -- Metric or Rollup Metric but not both.
2469:
2470: CURSOR c_rollup_count(l_metric_id number) IS
2471: SELECT COUNT(1)
2472: FROM ams_metrics_vl
2473: WHERE metric_parent_id = l_metric_id ;
2474:
2475: CURSOR c_summary_count(l_metric_id number) IS
2476: SELECT COUNT(1)

Line 2477: FROM ams_metrics_vl

2473: WHERE metric_parent_id = l_metric_id ;
2474:
2475: CURSOR c_summary_count(l_metric_id number) IS
2476: SELECT COUNT(1)
2477: FROM ams_metrics_vl
2478: WHERE summary_metric_id = l_metric_id ;
2479:
2480: CURSOR c_check_multiplier (l_metric_id number) IS
2481: select metric_category, ARC_METRIC_USED_FOR_OBJECT, metric_calculation_type

Line 3193: -- AMS_METRICS_VL

3189: -- IF l_metrics_rec.metric_parent_id IS NULL THEN
3190: -- l_metrics_validate_fk_rec.metric_parent_id := FND_API.G_FALSE;
3191: -- END IF;
3192: -- IF l_metrics_validate_fk_rec.metric_parent_id = FND_API.G_TRUE THEN
3193: -- AMS_METRICS_VL
3194: -- Start of the changes made by PTENDULK on 08/19/1999
3195: -- The check is modified to check whether this metric id is parent metric
3196: -- id of any other id
3197:

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

3197:
3198: -- Original Code
3199:
3200: -- IF AMS_Utility_PVT.Check_FK_Exists (
3201: -- p_table_name => 'AMS_METRICS_VL',
3202: -- p_pk_name => 'METRIC_ID',
3203: -- p_pk_value => l_metrics_rec.metric_parent_id
3204: -- ) = FND_API.G_TRUE
3205: -- THEN

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

3211:
3212: -- comment out the following for bug 1356700 fix
3213: -- 07/17/2000 khung
3214: -- IF AMS_Utility_PVT.Check_FK_Exists (
3215: -- p_table_name => 'AMS_METRICS_VL',
3216: -- p_pk_name => 'METRIC_PARENT_ID',
3217: -- p_pk_value => l_metric_id,
3218: -- p_pk_data_type => AMS_Utility_PVT.G_NUMBER
3219: -- ) = FND_API.G_TRUE

Line 3236: -- AMS_METRICS_VL

3232: -- IF l_metrics_rec.summary_metric_id IS NULL THEN
3233: -- l_metrics_validate_fk_rec.summary_metric_id := FND_API.G_FALSE;
3234: -- END IF;
3235: -- IF l_metrics_validate_fk_rec.summary_metric_id = FND_API.G_TRUE THEN
3236: -- AMS_METRICS_VL
3237: -- Start of the changes made by PTENDULK on 08/19/1999
3238: -- The check is modified to check whether this metric id is Summary metric
3239: -- id of any other metric id
3240: -- Original Code

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

3238: -- The check is modified to check whether this metric id is Summary metric
3239: -- id of any other metric id
3240: -- Original Code
3241: -- IF AMS_Utility_PVT.Check_FK_Exists (
3242: -- p_table_name => 'AMS_METRICS_VL',
3243: -- p_pk_name => 'METRIC_ID',
3244: -- p_pk_value => l_metrics_rec.summary_metric_id
3245: -- ) = FND_API.G_TRUE
3246:

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

3251:
3252: -- comment out the following for bug 1356700 fix
3253: -- 07/17/2000 khung
3254: -- IF AMS_Utility_PVT.Check_FK_Exists (
3255: -- p_table_name => 'AMS_METRICS_VL',
3256: -- p_pk_name => 'SUMMARY_METRIC_ID',
3257: -- p_pk_value => l_metric_id,
3258: -- p_pk_data_type => AMS_Utility_PVT.G_NUMBER
3259: -- ) = FND_API.G_TRUE

Line 3333: FROM ams_metrics_vl

3329: ,set_function_name
3330: ,display_type
3331: ,target_type
3332: ,denorm_code
3333: FROM ams_metrics_vl
3334: WHERE metric_id = p_metric_rec.metric_id;
3335:
3336: --l_metric_rec c_metric%ROWTYPE;
3337: BEGIN