DBA Data[Home] [Help]

APPS.AMS_ACTMETRIC_PVT dependencies on AMS_ACT_LISTS

Line 7524: l_table_name := 'AMS_ACT_LISTS';

7520: ELSIF (p_arc_act_metric_used_by = 'RCAM') THEN
7521: l_table_name := 'AMS_CAMPAIGNS_ALL_B';
7522: l_pk_name := 'CAMPAIGN_ID';
7523: ELSIF (p_arc_act_metric_used_by = 'ALIST') THEN
7524: l_table_name := 'AMS_ACT_LISTS';
7525: l_pk_name := 'ACT_LIST_HEADER_ID';
7526: ELSE
7527: AMS_Utility_PVT.error_message ('AMS_INVALID_SYS_QUAL', 'SYS_QUALIFIER', p_arc_act_metric_used_by);
7528: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 7692: SELECT 1 FROM AMS_ACT_LISTS

7688: WHERE EVENT_HEADER_ID = p_event_id;
7689:
7690:
7691: CURSOR c_act_list_metric(p_act_list_id number) IS
7692: SELECT 1 FROM AMS_ACT_LISTS
7693: WHERE ACT_LIST_HEADER_ID = p_act_list_id;
7694:
7695: l_count NUMBER;
7696: BEGIN