[Home] [Help]
212: -- API name : Update_List_Status
213: -- Type : Public
214: -- Pre-reqs : None
215: -- Function : Updates the Advanced Outbound list status, and
216: -- makes call to AMS_LISTHEADER_PVT.UpdateListheader
217: -- to update the Marketing list status as well.
218: -- Accepts a parameter p_api_init_flag that is used
219: -- to flag whether or not a call to a public api
220: -- initiated the status change (i.e. start purge).
238: )
239: IS
240: PRAGMA AUTONOMOUS_TRANSACTION;
241: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_LIST_STATUS';
242: l_list_rec AMS_LISTHEADER_PVT.list_header_rec_type;
243: l_api_version CONSTANT NUMBER := 1.0;
244: l_msg_count NUMBER;
245: l_msg_data VARCHAR2(4000);
246: l_return_code VARCHAR2(1);
381:
382: ----------------------------------------------------------------
383: -- We need to grab an empty list header rec from marketing.
384: ----------------------------------------------------------------
385: AMS_LISTHEADER_PVT.Init_ListHeader_rec(x_listheader_rec => l_list_rec);
386:
387: ----------------------------------------------------------------
388: -- We modify the header id and user status id fields to indicate
389: -- that the status is what we want to modify on this list.
395: -- Call the AMS api to execute the list header modification for
396: -- us. FUTURE: we might have to use their public api in the
397: -- future.
398: ----------------------------------------------------------------
399: AMS_LISTHEADER_PVT.Update_ListHeader
400: ( p_api_version => l_api_version,
401: p_init_msg_list => FND_API.G_TRUE,
402: p_commit => FND_API.G_FALSE,
403: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
465: -- API name : Update_List_Status
466: -- Type : Public
467: -- Pre-reqs : None
468: -- Function : Updates the Advanced Outbound list status, and
469: -- makes call to AMS_LISTHEADER_PVT.UpdateListheader
470: -- to update the Marketing list status as well.
471: --
472: -- Parameters : p_list_id IN NUMBER Required
473: -- p_status IN VARCHAR2 Required