APPS.AMS_LISTHEADER_PVT dependencies on AMS_LIST_ENTRIES

Line 1898: DELETE FROM ams_list_entries

1894:
1895: ----------------------------------------------
1896: --Delete all existing entries for this list.--
1897: ----------------------------------------------
1898: DELETE FROM ams_list_entries
1899: WHERE list_header_id =l_listheader_rec.list_header_id;
1900:
1901: ------------------------------------------------------------------------------
1902: --Delete all entries in the ams_list_src_type_usages table. --

Line 2160: -- Ams_List_Entries,

2156: --
2157: -- NOTES
2158: -- Deletes from The following tables Ams_List_Src_Type_Usages,
2159: -- Ams_List_Rule_Usages,
2160: -- Ams_List_Entries,
2161: -- Ams_List_Select_Actions
2162: -- Ams_List_Headers_All.
2163: --
2164: -- HISTORY

Line 2236: DELETE FROM ams_list_entries

2232:
2233: DELETE FROM ams_list_rule_usages
2234: WHERE list_header_id = l_list_header_id;
2235:
2236: DELETE FROM ams_list_entries
2237: WHERE list_header_id = l_list_header_id;
2238:
2239: DELETE FROM ams_list_select_actions
2240: WHERE list_header_id = l_list_header_id;

Line 3002: from ams_list_entries

2998: sum(decode(marked_as_duplicate_flag,'Y',1,0)),
2999: sum(decode(manually_entered_flag,
3000: 'Y',decode(enabled_flag,'Y','1',0),
3001: 0))
3002: from ams_list_entries
3003: where list_header_id = cur_p_list_header_id ;
3004:
3005: l_no_of_rows_duplicates number;
3006: l_no_of_rows_in_list number;

Line 3162: from ams_list_entries

3158:
3159:
3160: cursor c_count_list_entries(cur_p_list_header_id number) is
3161: select count(LAST_CONTACTED_DATE)
3162: from ams_list_entries
3163: where list_header_id = cur_p_list_header_id
3164: and enabled_flag = 'Y'
3165: and LAST_CONTACTED_DATE is not null;
3166:

Line 3182: update ams_list_entries

3178: into l_list_header_id ;
3179: close c_get_list_header_id;
3180:
3181: --only update entries which have not been updated already
3182: update ams_list_entries
3183: set LAST_CONTACTED_DATE = p_last_contacted_date,
3184: last_update_date = sysdate
3185: WHERE list_header_id = l_list_header_id
3186: and enabled_flag = 'Y'

Line 3429: AMS_List_Entries_PVT.Copy_List_Entries

3425:
3426:
3427: IF p_copy_list_entries = 'Y' THEN
3428: -- call api to copy list entries
3429: AMS_List_Entries_PVT.Copy_List_Entries
3430: (
3431: l_api_version,
3432: p_init_msg_list,
3433: p_commit,