876:
877: -- list header sequence #
878: CURSOR listheader_seq IS
879: SELECT ams_list_headers_all_s.nextval
880: FROM DUAL;
881:
882: BEGIN
883:
884: -- Initialize API/Procedure return status to success
1206: l_main_gen_time DATE := null;
1207:
1208: CURSOR c_list_seq IS
1209: SELECT ams_list_headers_all_s.NEXTVAL
1210: FROM DUAL;
1211:
1212: CURSOR c_list_count(p_list_header_id IN NUMBER) IS
1213: SELECT COUNT(*)
1214: FROM ams_list_headers_all