APPS.AMS_LISTIMPORT_PVT dependencies on AS_IMPORT_INTERFACE_S

Line 2348: select as_import_interface_s.nextval into l_batch_id from dual;

2344: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2345: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2346: system_status_code = 'STAGED' and default_flag = 'Y';
2347:
2348: select as_import_interface_s.nextval into l_batch_id from dual;
2349:
2350: UPDATE ams_imp_list_headers_all
2351: set status_code = l_lookup_code,
2352: user_status_id = l_user_status_id,

Line 13806: select as_import_interface_s.nextval into l_batch_id from dual;

13802: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
13803: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
13804: system_status_code = 'STAGED' and default_flag = 'Y';
13805:
13806: select as_import_interface_s.nextval into l_batch_id from dual;
13807:
13808: UPDATE ams_imp_list_headers_all
13809: set status_code = l_lookup_code,
13810: user_status_id = l_user_status_id,