APPS.AMS_LISTGENERATION_UTIL_PKG dependencies on AMS_LIST_HEADERS_ALL

Line 172: from ams_list_headers_all

168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169:
170: -- If p_listheader_rec.list_type = 'TARGET'
171: select generation_type into l_gen_type
172: from ams_list_headers_all
173: where list_header_id = p_list_header_id;
174:
175: -- If p_listheader_rec.generation_type = 'STANDARD' then
176: If l_gen_type = 'STANDARD' then

Line 245: update ams_list_headers_all

241: Currently, I don't see the remote list header table getting updated.
242: Endif
243: */
244:
245: update ams_list_headers_all
246: set --WORKFLOW_ITEM_KEY = NULL,
247: status_code = 'DRAFT',
248: ctrl_status_code = 'DRAFT',
249: user_status_id = 311,

Line 294: from ams_list_headers_all

290: l_result VARCHAR2(1000);
291:
292: cursor wf_item_key(p_list_header_id NUMBER) IS
293: select workflow_item_key
294: from ams_list_headers_all
295: where list_header_id = p_list_header_id;
296:
297: Begin
298: -- Get the work flow item key

Line 358: from ams_list_headers_all

354: where list_header_id = p_list_header_id ;
355:
356: cursor c_list_header_info is
357: select list_type, ctrl_gen_mode
358: from ams_list_headers_all
359: where list_header_id = p_list_header_id;
360:
361: l_no_of_rows_in_list number;
362: l_no_of_rows_active number;

Line 391: update ams_list_headers_all

387: application => 'AMS',
388: program => 'AMSCGSP',
389: argument1 => p_LIST_HEADER_id);
390:
391: update ams_list_headers_all
392: set ctrl_conc_job_id = l_request_id,
393: last_update_date = sysdate
394: where list_header_id = p_list_header_id;
395: commit;

Line 400: update ams_list_headers_all

396:
397:
398: exception
399: when others then
400: update ams_list_headers_all
401: set ctrl_status_code = 'FAILED',
402: status_code = status_code_old,
403: status_code_old = null,
404: last_update_date = sysdate,

Line 415: from ams_list_headers_all

411: (p_list_header_id in number) IS
412:
413: cursor c1 is
414: select ctrl_conc_job_id,status_code_old,status_code
415: from ams_list_headers_all
416: where list_header_id = p_list_header_id;
417:
418: cursor c_user_status(p_status_code in varchar2) is
419: select user_status_id

Line 451: update ams_list_headers_all

447: end if;
448:
449: l_cancel_status := fnd_concurrent.cancel_request(l_request_id,l_msg_text);
450:
451: update ams_list_headers_all
452: set ctrl_status_code = 'DRAFT',
453: status_code = nvl(status_code_old,status_code),
454: last_update_date = sysdate,
455: user_status_id = l_old_status_id

Line 477: from ams_list_src_types stypes, ams_list_headers_all list

473:
474:
475: cursor c_remote_list is
476: select nvl(stypes.remote_flag,'N') ,database_link
477: from ams_list_src_types stypes, ams_list_headers_all list
478: where list.list_source_type = stypes.source_type_code
479: and list_header_id = p_list_header_id;
480:
481: l_remote_flag varchar2(1) := 'N';