APPS.AMS_LISTIMPORT_PVT dependencies on AMS_IMP_SOURCE_LINES_S

Line 4865: from ams_imp_list_headers_all hd, ams_imp_source_lines sr

4861:
4862:
4863: cursor b2borb2c is
4864: select hd.import_type, hd.rented_list_flag, hd.import_list_header_id
4865: from ams_imp_list_headers_all hd, ams_imp_source_lines sr
4866: where hd.import_list_header_id = sr.import_list_header_id
4867: and sr.party_id = p_party_id;
4868:
4869: cursor c_relationship is

Line 17821: ams_imp_source_lines_s.nextval, -- IMPORT_SOURCE_LINE_ID,

17817: orig_system_reference
17818: )
17819: VALUES
17820: (
17821: ams_imp_source_lines_s.nextval, -- IMPORT_SOURCE_LINE_ID,
17822: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
17823: SYSDATE, -- LAST_UPDATE_DATE,
17824: SYSDATE, -- CREATION_DATE,
17825: FND_GLOBAL.User_ID, -- CREATED_BY,

Line 18175: ams_imp_source_lines_s.nextval, -- IMPORT_SOURCE_LINE_ID,

18171: rent_owned_indicator
18172: )
18173: VALUES
18174: (
18175: ams_imp_source_lines_s.nextval, -- IMPORT_SOURCE_LINE_ID,
18176: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
18177: SYSDATE, -- LAST_UPDATE_DATE,
18178: SYSDATE, -- CREATION_DATE,
18179: FND_GLOBAL.User_ID, -- CREATED_BY,

Line 18510: update ams_imp_source_lines set load_status = 'ERROR'

18506: p_log_used_by_id => p_import_list_header_id,
18507: p_msg_data => FND_MESSAGE.get,
18508: p_msg_type => 'DEBUG'
18509: );
18510: update ams_imp_source_lines set load_status = 'ERROR'
18511: where import_list_header_id = p_import_list_header_id
18512: and load_status in ('ACTIVE','RELOAD');
18513:
18514: AMS_List_Import_PUB.error_capture (