APPS.AMS_LISTGENERATION_PKG dependencies on AMS_LIST_ENTRIES

Line 154: From ams_list_entries

150: --Retrieve the number of list entries for each list action, excluding entries which are
151: --marked as duplicates.
152: Cursor C_Action_Entry_Count(p_list_header_id ams_list_headers_all.list_header_id%type)
153: IS Select list_select_action_id,count(*)
154: From ams_list_entries
155: where list_header_id = p_list_header_id
156: and marked_as_duplicate_flag ='N'
157: group by list_select_action_id
158: order by list_select_action_id;

Line 434: ,p_object_name VARCHAR2 := 'AMS_LIST_ENTRIES'

430: PROCEDURE Execute_Remote_Dedupe_List
431: (p_list_header_id AMS_LIST_HEADERS_ALL.LIST_HEADER_ID%TYPE
432: ,p_enable_word_replacement_flag AMS_LIST_HEADERS_ALL.ENABLE_WORD_REPLACEMENT_FLAG%TYPE
433: ,p_send_to_log VARCHAR2 := 'N'
434: ,p_object_name VARCHAR2 := 'AMS_LIST_ENTRIES'
435: );
436:
437: PROCEDURE migrate_lists_from_remote(
438: Errbuf OUT NOCOPY VARCHAR2,