DBA Data[Home] [Help]

APPS.AMS_ACTMETRIC_PVT dependencies on AMS_ACT_LISTS

Line 7532: l_table_name := 'AMS_ACT_LISTS';

7528: ELSIF (p_arc_act_metric_used_by = 'RCAM') THEN
7529: l_table_name := 'AMS_CAMPAIGNS_ALL_B';
7530: l_pk_name := 'CAMPAIGN_ID';
7531: ELSIF (p_arc_act_metric_used_by = 'ALIST') THEN
7532: l_table_name := 'AMS_ACT_LISTS';
7533: l_pk_name := 'ACT_LIST_HEADER_ID';
7534: ELSE
7535: AMS_Utility_PVT.error_message ('AMS_INVALID_SYS_QUAL', 'SYS_QUALIFIER', p_arc_act_metric_used_by);
7536: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 7700: SELECT 1 FROM AMS_ACT_LISTS

7696: WHERE EVENT_HEADER_ID = p_event_id;
7697:
7698:
7699: CURSOR c_act_list_metric(p_act_list_id number) IS
7700: SELECT 1 FROM AMS_ACT_LISTS
7701: WHERE ACT_LIST_HEADER_ID = p_act_list_id;
7702:
7703: l_count NUMBER;
7704: BEGIN