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 321: FROM ams_metrics_all_b

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

Line 325: SELECT ams_metrics_all_b_s.NEXTVAL

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

Line 434: INSERT INTO ams_metrics_all_b (

430:
431: --
432: -- Insert into the base table.
433: --
434: INSERT INTO ams_metrics_all_b (
435: metric_id,
436:
437: creation_date,
438: created_by,

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

604: -- NAME
605: -- Update_Metric
606: --
607: -- PURPOSE
608: -- Updates a metric in AMS_METRICS_ALL_B given the
609: -- record for the metrics.
610: --
611: -- NOTES
612: --

Line 787: -- Update AMS_METRICS_ALL_B

783: RAISE FND_API.G_EXC_ERROR;
784: END IF;
785: END IF;
786:
787: -- Update AMS_METRICS_ALL_B
788: UPDATE ams_metrics_all_b
789: SET object_version_number = l_metrics_rec.object_version_number + 1,
790: application_id = l_metrics_rec.application_id,
791: arc_metric_used_for_object =l_metrics_rec.arc_metric_used_for_object,

Line 788: UPDATE ams_metrics_all_b

784: END IF;
785: END IF;
786:
787: -- Update AMS_METRICS_ALL_B
788: UPDATE ams_metrics_all_b
789: SET object_version_number = l_metrics_rec.object_version_number + 1,
790: application_id = l_metrics_rec.application_id,
791: arc_metric_used_for_object =l_metrics_rec.arc_metric_used_for_object,
792: metric_calculation_type = l_metrics_rec.metric_calculation_type,

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

912: -- NAME
913: -- Delete_Metric
914: --
915: -- PURPOSE
916: -- Deletes a metric in AMS_METRICS_ALL_B given the
917: -- key identifier for the metric.
918: --
919: -- NOTES
920: --

Line 948: FROM ams_metrics_all_b

944: l_return_status VARCHAR2(1);
945:
946: CURSOR c_child_met_id (l_met_id NUMBER) IS
947: SELECT metric_id
948: FROM ams_metrics_all_b
949: WHERE metric_parent_id = l_met_id;
950:
951: --huili added on 08/14/2001
952: CURSOR c_check_depend_met (l_met_id NUMBER) IS

Line 954: FROM ams_metrics_all_b

950:
951: --huili added on 08/14/2001
952: CURSOR c_check_depend_met (l_met_id NUMBER) IS
953: SELECT metric_id
954: FROM ams_metrics_all_b
955: WHERE COMPUTE_USING_FUNCTION = TO_CHAR(l_met_id);
956:
957: CURSOR c_sum_met_id (l_met_id NUMBER) IS
958: SELECT metric_id

Line 959: FROM ams_metrics_all_b

955: WHERE COMPUTE_USING_FUNCTION = TO_CHAR(l_met_id);
956:
957: CURSOR c_sum_met_id (l_met_id NUMBER) IS
958: SELECT metric_id
959: FROM ams_metrics_all_b
960: WHERE SUMMARY_METRIC_ID = l_met_id;
961:
962: l_sum_met_id NUMBER := NULL;
963: l_dep_met_id NUMBER := NULL;

Line 1081: DELETE FROM ams_metrics_all_b

1077:
1078: -- Debug message.
1079: Ams_Utility_Pvt.debug_message(l_full_name ||': delete with Validation');
1080:
1081: DELETE FROM ams_metrics_all_b
1082: WHERE metric_id = p_metric_id
1083: AND object_version_number = p_object_version_number;
1084:
1085:

Line 1203: FROM ams_metrics_all_b

1199: l_metric_id NUMBER;
1200:
1201: CURSOR c_metrics_info IS
1202: SELECT metric_id
1203: FROM ams_metrics_all_b
1204: WHERE metric_id = p_metric_id
1205: AND object_version_number = p_object_version_number
1206: FOR UPDATE OF metric_id NOWAIT;
1207:

Line 2482: from ams_metrics_all_b

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
2482: from ams_metrics_all_b
2483: where metric_id = l_metric_id;
2484:
2485: CURSOR c_get_category_name (l_category_id number) is
2486: SELECT category_name