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_ALL_B

Line 184: FROM ams_metrics_all_b

180: )
181: IS
182: CURSOR c_metric IS
183: SELECT metric_id, metric_calculation_type, metric_category, accrual_type
184: FROM ams_metrics_all_b
185: WHERE metric_id = p_metric_rec.metric_id;
186:
187: l_metric_rec c_metric%ROWTYPE;
188:

Line 191: FROM ams_metrics_all_b

187: l_metric_rec c_metric%ROWTYPE;
188:
189: CURSOR c_check_rollup_children (p_met_id NUMBER) IS
190: SELECT 1
191: FROM ams_metrics_all_b
192: WHERE metric_parent_id = p_met_id;
193:
194: CURSOR c_check_summary_children (p_met_id NUMBER) IS
195: SELECT metric_id

Line 196: FROM ams_metrics_all_b

192: WHERE metric_parent_id = p_met_id;
193:
194: CURSOR c_check_summary_children (p_met_id NUMBER) IS
195: SELECT metric_id
196: FROM ams_metrics_all_b
197: WHERE summary_metric_id = p_met_id;
198:
199: l_check_children NUMBER;
200:

Line 203: FROM ams_metrics_all_b

199: l_check_children NUMBER;
200:
201: CURSOR c_check_variable_met (p_met_id NUMBER) IS
202: SELECT metric_id
203: FROM ams_metrics_all_b
204: WHERE to_number(compute_using_function) = p_met_id;
205:
206: BEGIN
207: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 279: -- Creates a metric in AMS_METRICS_ALL_B given the

275: -- NAME
276: -- Create_Metric
277: --
278: -- PURPOSE
279: -- Creates a metric in AMS_METRICS_ALL_B given the
280: -- record for the metrics.
281: --
282: -- NOTES
283: --

Line 323: FROM ams_metrics_all_b

319:
320:
321: CURSOR c_metr_count(l_metric_id IN NUMBER) IS
322: SELECT COUNT(1)
323: FROM ams_metrics_all_b
324: WHERE metric_id = l_metric_id;
325:
326: CURSOR c_metric_id IS
327: SELECT ams_metrics_all_b_s.NEXTVAL

Line 327: SELECT ams_metrics_all_b_s.NEXTVAL

323: FROM ams_metrics_all_b
324: WHERE metric_id = l_metric_id;
325:
326: CURSOR c_metric_id IS
327: SELECT ams_metrics_all_b_s.NEXTVAL
328: FROM dual;
329: BEGIN
330: --
331: -- Initialize savepoint.

Line 441: INSERT INTO ams_metrics_all_b (

437:
438: --
439: -- Insert into the base table.
440: --
441: INSERT INTO ams_metrics_all_b (
442: metric_id,
443:
444: creation_date,
445: created_by,

Line 615: -- Updates a metric in AMS_METRICS_ALL_B given the

611: -- NAME
612: -- Update_Metric
613: --
614: -- PURPOSE
615: -- Updates a metric in AMS_METRICS_ALL_B given the
616: -- record for the metrics.
617: --
618: -- NOTES
619: --

Line 794: -- Update AMS_METRICS_ALL_B

790: RAISE FND_API.G_EXC_ERROR;
791: END IF;
792: END IF;
793:
794: -- Update AMS_METRICS_ALL_B
795: UPDATE ams_metrics_all_b
796: SET object_version_number = l_metrics_rec.object_version_number + 1,
797: application_id = l_metrics_rec.application_id,
798: arc_metric_used_for_object =l_metrics_rec.arc_metric_used_for_object,

Line 795: UPDATE ams_metrics_all_b

791: END IF;
792: END IF;
793:
794: -- Update AMS_METRICS_ALL_B
795: UPDATE ams_metrics_all_b
796: SET object_version_number = l_metrics_rec.object_version_number + 1,
797: application_id = l_metrics_rec.application_id,
798: arc_metric_used_for_object =l_metrics_rec.arc_metric_used_for_object,
799: metric_calculation_type = l_metrics_rec.metric_calculation_type,

Line 923: -- Deletes a metric in AMS_METRICS_ALL_B given the

919: -- NAME
920: -- Delete_Metric
921: --
922: -- PURPOSE
923: -- Deletes a metric in AMS_METRICS_ALL_B given the
924: -- key identifier for the metric.
925: --
926: -- NOTES
927: --

Line 955: FROM ams_metrics_all_b

951: l_return_status VARCHAR2(1);
952:
953: CURSOR c_child_met_id (l_met_id NUMBER) IS
954: SELECT metric_id
955: FROM ams_metrics_all_b
956: WHERE metric_parent_id = l_met_id;
957:
958: --huili added on 08/14/2001
959: CURSOR c_check_depend_met (l_met_id NUMBER) IS

Line 961: FROM ams_metrics_all_b

957:
958: --huili added on 08/14/2001
959: CURSOR c_check_depend_met (l_met_id NUMBER) IS
960: SELECT metric_id
961: FROM ams_metrics_all_b
962: WHERE COMPUTE_USING_FUNCTION = TO_CHAR(l_met_id);
963:
964: CURSOR c_sum_met_id (l_met_id NUMBER) IS
965: SELECT metric_id

Line 966: FROM ams_metrics_all_b

962: WHERE COMPUTE_USING_FUNCTION = TO_CHAR(l_met_id);
963:
964: CURSOR c_sum_met_id (l_met_id NUMBER) IS
965: SELECT metric_id
966: FROM ams_metrics_all_b
967: WHERE SUMMARY_METRIC_ID = l_met_id;
968:
969: l_sum_met_id NUMBER := NULL;
970: l_dep_met_id NUMBER := NULL;

Line 1088: DELETE FROM ams_metrics_all_b

1084:
1085: -- Debug message.
1086: Ams_Utility_Pvt.debug_message(l_full_name ||': delete with Validation');
1087:
1088: DELETE FROM ams_metrics_all_b
1089: WHERE metric_id = p_metric_id
1090: AND object_version_number = p_object_version_number;
1091:
1092:

Line 1210: FROM ams_metrics_all_b

1206: l_metric_id NUMBER;
1207:
1208: CURSOR c_metrics_info IS
1209: SELECT metric_id
1210: FROM ams_metrics_all_b
1211: WHERE metric_id = p_metric_id
1212: AND object_version_number = p_object_version_number
1213: FOR UPDATE OF metric_id NOWAIT;
1214:

Line 2489: from ams_metrics_all_b

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
2489: from ams_metrics_all_b
2490: where metric_id = l_metric_id;
2491:
2492: CURSOR c_get_category_name (l_category_id number) is
2493: SELECT category_name