APPS.AMS_LIST_MAINT_PVT dependencies on AMS_LIST_HEADERS_ALL

Line 20: --This Variable stores a record from the AMS_LIST_HEADERS_ALL table. --

16: g_sqlerrm varchar2(500);
17: g_sqlcode varchar2(500);
18:
19: ----------------------------------------------------------------------------
20: --This Variable stores a record from the AMS_LIST_HEADERS_ALL table. --
21: ----------------------------------------------------------------------------
22: g_listheader_rec AMS_LISTHEADER_PVT.list_header_rec_type;
23:
24: ----------------------------------------------------------------------------

Line 229: update ams_list_headers_all

225: argument7 => p_arc_list_used_by,
226: argument8 => p_name,
227: argument9 => p_copy_entries );
228: if(x_schedule_id <>0)then
229: update ams_list_headers_all
230: set status_code = 'PENDING', status_date = sysdate
231: where list_header_id = p_list_header_id;
232:
233: end if;

Line 669: --This Cursor retreves the list header details from the AMS_LIST_HEADERS_ALL table.-

665: l_api_name CONSTANT VARCHAR2(30) := 'COPY_LIST';
666: l_api_version CONSTANT NUMBER := 1.0;
667:
668: ------------------------------------------------------------------------------------
669: --This Cursor retreves the list header details from the AMS_LIST_HEADERS_ALL table.-
670: ------------------------------------------------------------------------------------
671: Cursor C_ListHeader_Dets(p_list_header_id NUMBER) IS
672: SELECT
673: list_header_id

Line 762: FROM ams_list_headers_all

758: ,attribute14
759: ,attribute15
760: ,timezone_id
761: ,user_entered_start_time
762: FROM ams_list_headers_all
763: WHERE list_header_id = p_list_header_id;
764:
765:
766: ------------------------------------------------------------------------------------

Line 808: FROM ams_list_headers_all

804: ---------------------------------------------------------------
805: CURSOR C_Repeat_Lists(p_source_list_id number,p_current_list_id number)IS
806: SELECT list_header_Id,
807: list_name
808: FROM ams_list_headers_all
809: WHERE repeat_source_list_header_id = p_source_list_id
810: AND list_header_id <> p_current_list_id
811: ORDER BY list_header_id;
812:

Line 816: TYPE t_list_header_id is TABLE OF ams_list_headers_all.list_header_id%type;

812:
813: ----------------------------------------------------------------------------
814: --These table records will store a set of list header and list name fields--
815: ----------------------------------------------------------------------------
816: TYPE t_list_header_id is TABLE OF ams_list_headers_all.list_header_id%type;
817: TYPE t_list_name is TABLE OF ams_list_headers_all.list_name%type;
818:
819: ----------------------------------------------------------------------------
820: --These variables will store the results of cursor c_repeat_lists. --

Line 817: TYPE t_list_name is TABLE OF ams_list_headers_all.list_name%type;

813: ----------------------------------------------------------------------------
814: --These table records will store a set of list header and list name fields--
815: ----------------------------------------------------------------------------
816: TYPE t_list_header_id is TABLE OF ams_list_headers_all.list_header_id%type;
817: TYPE t_list_name is TABLE OF ams_list_headers_all.list_name%type;
818:
819: ----------------------------------------------------------------------------
820: --These variables will store the results of cursor c_repeat_lists. --
821: ----------------------------------------------------------------------------

Line 825: l_list_name ams_list_headers_all.list_name%type;

821: ----------------------------------------------------------------------------
822: l_repeat_list_header_id t_list_header_id;
823: l_repeat_list_name t_list_name;
824:
825: l_list_name ams_list_headers_all.list_name%type;
826: l_list_header_id NUMBER;
827: l_action_id NUMBER;
828:
829: ----------------------------------------------------------------------------

Line 1063: FROM ams_list_headers_all

1059: --getting the number of times a repeated list header has been created.--
1060: ------------------------------------------------------------------------
1061: SELECT COUNT(*)
1062: INTO l_repeat_list_count
1063: FROM ams_list_headers_all
1064: WHERE repeat_source_list_Header_id = p_list_id;
1065:
1066: IF(l_repeat_list_count >0)THEN
1067: ------------------------------------------------------------------------