APPS.AMS_LISTHEADER_PVT dependencies on AMS_LIST_ENTRIES

Line 1885: DELETE FROM ams_list_entries

1881:
1882: ----------------------------------------------
1883: --Delete all existing entries for this list.--
1884: ----------------------------------------------
1885: DELETE FROM ams_list_entries
1886: WHERE list_header_id =l_listheader_rec.list_header_id;
1887:
1888: ------------------------------------------------------------------------------
1889: --Delete all entries in the ams_list_src_type_usages table. --

Line 2147: -- Ams_List_Entries,

2143: --
2144: -- NOTES
2145: -- Deletes from The following tables Ams_List_Src_Type_Usages,
2146: -- Ams_List_Rule_Usages,
2147: -- Ams_List_Entries,
2148: -- Ams_List_Select_Actions
2149: -- Ams_List_Headers_All.
2150: --
2151: -- HISTORY

Line 2223: DELETE FROM ams_list_entries

2219:
2220: DELETE FROM ams_list_rule_usages
2221: WHERE list_header_id = l_list_header_id;
2222:
2223: DELETE FROM ams_list_entries
2224: WHERE list_header_id = l_list_header_id;
2225:
2226: DELETE FROM ams_list_select_actions
2227: WHERE list_header_id = l_list_header_id;

Line 2989: from ams_list_entries

2985: sum(decode(marked_as_duplicate_flag,'Y',1,0)),
2986: sum(decode(manually_entered_flag,
2987: 'Y',decode(enabled_flag,'Y','1',0),
2988: 0))
2989: from ams_list_entries
2990: where list_header_id = cur_p_list_header_id ;
2991:
2992: l_no_of_rows_duplicates number;
2993: l_no_of_rows_in_list number;

Line 3149: from ams_list_entries

3145:
3146:
3147: cursor c_count_list_entries(cur_p_list_header_id number) is
3148: select count(LAST_CONTACTED_DATE)
3149: from ams_list_entries
3150: where list_header_id = cur_p_list_header_id
3151: and enabled_flag = 'Y'
3152: and LAST_CONTACTED_DATE is not null;
3153:

Line 3169: update ams_list_entries

3165: into l_list_header_id ;
3166: close c_get_list_header_id;
3167:
3168: --only update entries which have not been updated already
3169: update ams_list_entries
3170: set LAST_CONTACTED_DATE = p_last_contacted_date,
3171: last_update_date = sysdate
3172: WHERE list_header_id = l_list_header_id
3173: and enabled_flag = 'Y'

Line 3416: AMS_List_Entries_PVT.Copy_List_Entries

3412:
3413:
3414: IF p_copy_list_entries = 'Y' THEN
3415: -- call api to copy list entries
3416: AMS_List_Entries_PVT.Copy_List_Entries
3417: (
3418: l_api_version,
3419: p_init_msg_list,
3420: p_commit,