APPS.OZF_ACTMETRIC_PVT dependencies on OZF_ACT_METRICS_ALL

Line 81: LOCK TABLE OZF_ACT_METRICS_ALL IN EXCLUSIVE MODE;

77:
78: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
79: x_activity_metric_id := NULL;
80:
81: LOCK TABLE OZF_ACT_METRICS_ALL IN EXCLUSIVE MODE;
82:
83: Create_ActMetric2 (
84: p_api_version => p_api_version,
85: p_init_msg_list => p_init_msg_list,

Line 276: -- object by creating a record in OZF_ACT_METRICS_ALL.

272: --
273: --
274: -- PURPOSE
275: -- Creates an association of a metric to a business
276: -- object by creating a record in OZF_ACT_METRICS_ALL.
277: --
278: -- NOTES
279: --
280: -- HISTORY

Line 320: FROM ozf_act_metrics_all

316:
317:
318: CURSOR c_act_metr_count(l_act_metric_id IN NUMBER) IS
319: SELECT COUNT(1)
320: FROM ozf_act_metrics_all
321: WHERE activity_metric_id = l_act_metric_id;
322:
323: CURSOR c_act_met_id IS
324: SELECT ozf_act_metrics_all_s.NEXTVAL

Line 324: SELECT ozf_act_metrics_all_s.NEXTVAL

320: FROM ozf_act_metrics_all
321: WHERE activity_metric_id = l_act_metric_id;
322:
323: CURSOR c_act_met_id IS
324: SELECT ozf_act_metrics_all_s.NEXTVAL
325: FROM dual;
326:
327:
328: BEGIN

Line 453: INSERT INTO ozf_act_metrics_all (

449:
450: --
451: -- Insert into the base table.
452: --
453: INSERT INTO ozf_act_metrics_all (
454: activity_metric_id,
455: creation_date,
456: created_by,
457: last_update_date,

Line 696: -- Updates a metric in OZF_ACT_METRICS_ALL given the

692: -- NAME
693: -- Update_ActMetric
694: --
695: -- PURPOSE
696: -- Updates a metric in OZF_ACT_METRICS_ALL given the
697: -- record for the metrics.
698: --
699: -- NOTES
700: --

Line 839: -- Update OZF_ACT_METRICS_ALL

835: IF (OZF_DEBUG_HIGH_ON) THEN
836: ozf_utility_pvt.debug_message(l_full_name ||': update Activity Metrics Table');
837: END IF;
838:
839: -- Update OZF_ACT_METRICS_ALL
840: UPDATE ozf_act_metrics_all
841: SET object_version_number= object_version_number + 1,
842: act_metric_used_by_id = l_actmet_rec.act_metric_used_by_id,
843: arc_act_metric_used_by = l_actmet_rec.arc_act_metric_used_by,

Line 840: UPDATE ozf_act_metrics_all

836: ozf_utility_pvt.debug_message(l_full_name ||': update Activity Metrics Table');
837: END IF;
838:
839: -- Update OZF_ACT_METRICS_ALL
840: UPDATE ozf_act_metrics_all
841: SET object_version_number= object_version_number + 1,
842: act_metric_used_by_id = l_actmet_rec.act_metric_used_by_id,
843: arc_act_metric_used_by = l_actmet_rec.arc_act_metric_used_by,
844: purchase_req_raised_flag = l_actmet_rec.purchase_req_raised_flag,

Line 1314: AND NOT EXISTS (SELECT 'x' FROM ozf_act_metrics_all a

1310: SELECT 'x'
1311: FROM ams_metrics_all_b b
1312: WHERE metric_id = l_metric_id
1313: AND ((metric_calculation_type = 'FUNCTION'
1314: AND NOT EXISTS (SELECT 'x' FROM ozf_act_metrics_all a
1315: WHERE a.metric_id = b.metric_id
1316: AND a.arc_act_metric_used_by = l_arc_act_metric_used_by
1317: AND a.act_metric_used_by_id = l_act_metric_used_by_id
1318: AND NVL(a.arc_function_used_by,'') = NVL(l_arc_function_used_by,'')

Line 1335: p_table_name => 'ozf_act_metrics_all',

1331: THEN
1332: l_where_clause := ' activity_metric_id = '||p_act_metric_rec.activity_metric_id ;
1333:
1334: IF ozf_utility_pvt.Check_Uniqueness(
1335: p_table_name => 'ozf_act_metrics_all',
1336: p_where_clause => l_where_clause
1337: ) = Fnd_Api.g_false
1338: THEN
1339: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)

Line 1860: FROM ozf_act_metrics_all

1856:
1857: CURSOR c_ref_metric (p_act_metric_id NUMBER) IS
1858: SELECT func_actual_value,
1859: trans_forecasted_value
1860: FROM ozf_act_metrics_all
1861: WHERE activity_metric_id = p_act_metric_id;
1862: l_ref_metric_rec c_ref_metric%ROWTYPE;
1863: BEGIN
1864:

Line 2085: FROM ozf_act_metrics_all

2081: )
2082: IS
2083: CURSOR c_act_metric IS
2084: SELECT *
2085: FROM ozf_act_metrics_all
2086: WHERE activity_metric_id = p_act_metric_rec.activity_metric_id;
2087:
2088: l_act_metric_rec c_act_metric%ROWTYPE;
2089: BEGIN