APPS.AMS_ACTMETRIC_PVT dependencies on AMS_LOOKUPS

Line 2621: l_object_name AMS_LOOKUPS.MEANING%TYPE;

2617: l_child_type VARCHAR2(30);
2618:
2619:
2620: --sunkumar 05/30/2003 added for seting the token in error message AMS_METR_DELETE
2621: l_object_name AMS_LOOKUPS.MEANING%TYPE;
2622: -- DMVINCEN Added check for rollup children.
2623: -- DMVINCEN 04/04/2002: Retrieve the child ids and relation ships.
2624: CURSOR c_check_child_exists(l_act_metric_id NUMBER) IS
2625: SELECT activity_metric_id, 'SUMMARY'

Line 3842: FROM ams_lookups

3838: l_lookup_type VARCHAR2(30);
3839:
3840: CURSOR c_arc_metric_usage (p_object_type IN VARCHAR2) IS
3841: SELECT 1
3842: FROM ams_lookups
3843: WHERE lookup_type IN ('AMS_METRIC_OBJECT_TYPE', 'AMS_METRIC_ROLLUP_TYPE', 'AMS_METRIC_ALLOCATION_TYPE')
3844: AND lookup_code = p_object_type
3845: ;
3846: l_dummy NUMBER;

Line 4144: l_object_name AMS_LOOKUPS.MEANING%TYPE;

4140: FROM ams_metrics_all_b
4141: WHERE metric_id = p_metric_id;
4142: l_metric_details_rec c_metric_details%ROWTYPE;
4143:
4144: l_object_name AMS_LOOKUPS.MEANING%TYPE;
4145:
4146: CURSOR c_ref_metric (p_act_metric_id NUMBER) IS
4147: SELECT func_actual_value,
4148: trans_forecasted_value,

Line 7280: l_object_name AMS_LOOKUPS.MEANING%TYPE;

7276: l_source_object_exists VARCHAR2(1) := Fnd_Api.G_FALSE;
7277: l_target_object_exists VARCHAR2(1) := Fnd_Api.G_FALSE;
7278: l_valid_object VARCHAR2(1) := Fnd_Api.G_FALSE;
7279:
7280: l_object_name AMS_LOOKUPS.MEANING%TYPE;
7281: --cursors to check for existance of various objects.
7282: CURSOR c_check_camp(id NUMBER) IS
7283: SELECT Fnd_Api.G_TRUE
7284: FROM ams_campaigns_all_b