APPS.AMS_ACTMETRIC_PVT dependencies on AMS_LOOKUPS

Line 2629: l_object_name AMS_LOOKUPS.MEANING%TYPE;

2625: l_child_type VARCHAR2(30);
2626:
2627:
2628: --sunkumar 05/30/2003 added for seting the token in error message AMS_METR_DELETE
2629: l_object_name AMS_LOOKUPS.MEANING%TYPE;
2630: -- DMVINCEN Added check for rollup children.
2631: -- DMVINCEN 04/04/2002: Retrieve the child ids and relation ships.
2632: CURSOR c_check_child_exists(l_act_metric_id NUMBER) IS
2633: SELECT activity_metric_id, 'SUMMARY'

Line 3850: FROM ams_lookups

3846: l_lookup_type VARCHAR2(30);
3847:
3848: CURSOR c_arc_metric_usage (p_object_type IN VARCHAR2) IS
3849: SELECT 1
3850: FROM ams_lookups
3851: WHERE lookup_type IN ('AMS_METRIC_OBJECT_TYPE', 'AMS_METRIC_ROLLUP_TYPE', 'AMS_METRIC_ALLOCATION_TYPE')
3852: AND lookup_code = p_object_type
3853: ;
3854: l_dummy NUMBER;

Line 4152: l_object_name AMS_LOOKUPS.MEANING%TYPE;

4148: FROM ams_metrics_all_b
4149: WHERE metric_id = p_metric_id;
4150: l_metric_details_rec c_metric_details%ROWTYPE;
4151:
4152: l_object_name AMS_LOOKUPS.MEANING%TYPE;
4153:
4154: CURSOR c_ref_metric (p_act_metric_id NUMBER) IS
4155: SELECT func_actual_value,
4156: trans_forecasted_value,

Line 7288: l_object_name AMS_LOOKUPS.MEANING%TYPE;

7284: l_source_object_exists VARCHAR2(1) := Fnd_Api.G_FALSE;
7285: l_target_object_exists VARCHAR2(1) := Fnd_Api.G_FALSE;
7286: l_valid_object VARCHAR2(1) := Fnd_Api.G_FALSE;
7287:
7288: l_object_name AMS_LOOKUPS.MEANING%TYPE;
7289: --cursors to check for existance of various objects.
7290: CURSOR c_check_camp(id NUMBER) IS
7291: SELECT Fnd_Api.G_TRUE
7292: FROM ams_campaigns_all_b