[Home] [Help]
357: -- dependent objects have any top level metrics, this procedure creates or
358: -- refreshes the association metric for the master object.
359: --
360: -- NOTES
361: -- Tables used: ams_object_associations,ams_metric_accruals,ams_act_metrics_all
362: -- This algorithm is driven on ams_metric_accruals table.
363: -- HISTORY
364: -- 10/04/2000 sveerave Created.
365: -- 08/16/2001 dmvincen Not all cursors were being closed.
358: -- refreshes the association metric for the master object.
359: --
360: -- NOTES
361: -- Tables used: ams_object_associations,ams_metric_accruals,ams_act_metrics_all
362: -- This algorithm is driven on ams_metric_accruals table.
363: -- HISTORY
364: -- 10/04/2000 sveerave Created.
365: -- 08/16/2001 dmvincen Not all cursors were being closed.
366:
372:
373: -- Get accrual metric details
374: CURSOR c_get_accr_met_details(l_accr_met_acc_id NUMBER) IS
375: SELECT using_object, used_object, metric_id, metric_type_id
376: FROM ams_metric_accruals
377: WHERE ams_metric_acc_id = l_accr_met_acc_id;
378: l_accr_met_rec c_get_accr_met_details%ROWTYPE;
379: l_accr_found VARCHAR2(1) := Fnd_Api.G_FALSE;
380:
561: -- dependent objects have any top level metrics, this procedure creates
562: -- or refreshes the association metric for the master object.
563: --
564: -- NOTES
565: -- Tables used: ams_object_associations,ams_metric_accruals,ams_metrics_all_b,ams_act_metrics_all
566: -- This procedure is called in Refresh_metrics for each distinct combination
567: -- of parent_object_id, parent_object_type
568: -- This method only creates act metric accruals and calls
569: -- refresh_assoc_metrics for creation/update of activity metrics.
624: CURSOR c_get_metric_accrual( l_master_object_type VARCHAR2,
625: l_child_object_type VARCHAR2,
626: l_metric_type_id NUMBER) IS
627: SELECT accr.ams_metric_acc_id
628: FROM ams_metric_accruals accr, ams_metrics_all_b met
629: WHERE accr.using_object = l_master_object_type
630: AND accr.used_object = l_child_object_type
631: AND accr.metric_type_id = l_metric_type_id
632: AND accr.metric_id = met.metric_id;
639: FROM ams_categories_vl
640: WHERE category_id = l_category_id;
641:
642: CURSOR c_next_metric_accrual_id IS
643: SELECT ams_metric_accruals_s.NEXTVAL
644: FROM dual;
645:
646: l_act_metric_rec Ams_Actmetric_Pvt.act_metric_rec_type;
647: l_metric_rec Ams_Metric_Pvt.metric_rec_type;
683: END IF;
684: CLOSE c_get_metric_accrual;
685: IF l_metric_accr_found = Fnd_Api.G_FALSE THEN
686: -- Create new accrual metric in metrics table and register it in
687: -- ams_metric_accruals populate accrual metric name as child
688: -- object name + - + metrics type get metric type name from
689: -- the category id
690: OPEN c_get_category_name(
691: l_child_summary_actmet_rec.child_metric_type_id);
757: OPEN c_next_metric_accrual_id;
758: FETCH c_next_metric_accrual_id INTO l_accrual_metric_id;
759: CLOSE c_next_metric_accrual_id;
760:
761: -- Register the metric in ams_metric_accruals by creating a row.
762: INSERT INTO ams_metric_accruals(
763: AMS_METRIC_ACC_ID,
764: LAST_UPDATE_DATE,
765: LAST_UPDATED_BY,
758: FETCH c_next_metric_accrual_id INTO l_accrual_metric_id;
759: CLOSE c_next_metric_accrual_id;
760:
761: -- Register the metric in ams_metric_accruals by creating a row.
762: INSERT INTO ams_metric_accruals(
763: AMS_METRIC_ACC_ID,
764: LAST_UPDATE_DATE,
765: LAST_UPDATED_BY,
766: CREATION_DATE,
1797: -- Cursor to identify that it is an association activity metric.
1798: -------------------------------------------------------
1799: CURSOR c_check_assoc_metric(l_metric_id NUMBER) IS
1800: SELECT 1
1801: FROM ams_metric_accruals
1802: WHERE metric_id = l_metric_id;
1803: l_flag NUMBER;
1804: l_current_date DATE := SYSDATE;
1805: