APPS.AMS_LIST_WF dependencies on AMS_LIST_HEADERS_ALL

Line 140: update ams_list_headers_all

136: AMS_ListHeader_PVT.Complete_ListHeader_rec(
137: p_listheader_rec => l_listheader_rec,
138: x_complete_rec => l_clistheader_rec
139: ) ;
140: update ams_list_headers_all
141: set object_version_number = object_version_number + 1
142: where list_header_id = p_list_header_id;
143:
144: --dbms_output.put_line('list->' || l_clistheader_rec.list_header_id);

Line 355: update ams_list_headers_all

351: (itemtype => itemtype,
352: itemkey => itemkey,
353: aname => 'WAITING_TIME');
354: if l_gen_date > sysdate then
355: update ams_list_headers_all
356: set status_code = 'SCHEDULED',
357: user_status_id = 301,
358: status_date = sysdate,
359: last_update_date = sysdate

Line 365: update ams_list_headers_all

361:
362: result := 'COMPLETE:AMS_SCH_TRUE' ;
363: RETURN;
364: else
365: update ams_list_headers_all
366: set status_code = 'GENERATING',
367: user_status_id = 302,
368: status_date = sysdate,
369: last_update_date = sysdate

Line 426: update ams_list_headers_all

422: l_list_type := WF_ENGINE.getItemAttrText
423: (itemtype => itemtype,
424: itemkey => itemkey,
425: aname => 'LIST_TYPE');
426: update ams_list_headers_all
427: set status_code = 'GENERATING',
428: user_status_id = 302,
429: status_date = sysdate,
430: last_update_date = sysdate

Line 645: update ams_list_headers_all set WORKFLOW_ITEM_KEY = l_new_item_key

641: l_sys_start_time := SYSDATE;
642: END IF;
643: AMS_Utility_PVT.debug_message('Raise Business event-- Start');
644: /*
645: update ams_list_headers_all set WORKFLOW_ITEM_KEY = l_new_item_key
646: where list_header_id = p_list_header_id;
647: */
648: update ams_list_headers_all
649: set status_code = 'SCHEDULED',

Line 648: update ams_list_headers_all

644: /*
645: update ams_list_headers_all set WORKFLOW_ITEM_KEY = l_new_item_key
646: where list_header_id = p_list_header_id;
647: */
648: update ams_list_headers_all
649: set status_code = 'SCHEDULED',
650: user_status_id = 301,
651: status_date = sysdate,
652: last_update_date = sysdate,

Line 734: update ams_list_headers_all

730: AMS_ListHeader_PVT.Complete_ListHeader_rec(
731: p_listheader_rec => l_listheader_rec,
732: x_complete_rec => l_clistheader_rec
733: ) ;
734: update ams_list_headers_all
735: set object_version_number = object_version_number + 1
736: where list_header_id = l_list_header_id;
737: /*
738: WF_ENGINE.CreateProcess (itemtype => 'AMSLISTG', --itemtype,

Line 853: select status_code into l_status_code from ams_list_headers_all

849: and item_key like p_list_header_id|| '%'
850: and activity_status in ('ERROR','ACTIVE');
851:
852: Begin
853: select status_code into l_status_code from ams_list_headers_all
854: where list_header_id = p_list_header_id;
855: if l_status_code <> 'DRAFT' then
856: update ams_list_headers_all
857: set WORKFLOW_ITEM_KEY = null,

Line 856: update ams_list_headers_all

852: Begin
853: select status_code into l_status_code from ams_list_headers_all
854: where list_header_id = p_list_header_id;
855: if l_status_code <> 'DRAFT' then
856: update ams_list_headers_all
857: set WORKFLOW_ITEM_KEY = null,
858: status_code = 'FAILED',
859: user_status_id = 311,
860: last_update_date = sysdate,

Line 896: from ams_list_headers_all where list_header_id = l_list_header_id;

892: l_return_status VARCHAR2(1);
893:
894: CURSOR c_item_key_name IS
895: select WORKFLOW_ITEM_KEY
896: from ams_list_headers_all where list_header_id = l_list_header_id;
897:
898: BEGIN
899: -- RUN mode - Normal Process Execution
900: IF (funcmode = 'RUN')