DBA Data[Home] [Help]

APPS.AMS_LISTIMPORT_PVT dependencies on AS_IMPORT_INTERFACE_S

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

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

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

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