APPS.AMS_LISTIMPORT_PVT dependencies on AMS_IMP_SOURCE_LINES_S

Line 4864: from ams_imp_list_headers_all hd, ams_imp_source_lines sr

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

Line 17820: ams_imp_source_lines_s.nextval, -- IMPORT_SOURCE_LINE_ID,

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

Line 18174: ams_imp_source_lines_s.nextval, -- IMPORT_SOURCE_LINE_ID,

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

Line 18509: update ams_imp_source_lines set load_status = 'ERROR'

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