APPS.AMS_PARTYIMPORT_PVT dependencies on AMS_IMP_SOURCE_LINES

Line 3494: p_table_name => 'AMS_IMP_SOURCE_LINES',

3490: --
3491: -- IMPORT_SOURCE_LINE_ID
3492: IF p_party_rec.import_source_line_id <> FND_API.g_miss_num THEN
3493: IF AMS_Utility_PVT.check_fk_exists (
3494: p_table_name => 'AMS_IMP_SOURCE_LINES',
3495: p_pk_name => 'IMPORT_SOURCE_LINE_ID',
3496: p_pk_value => p_party_rec.import_source_line_id,
3497: p_pk_data_type => AMS_Utility_PVT.g_number
3498: ) = FND_API.g_false THEN

Line 3849: FROM ams_imp_source_lines

3845: ;
3846:
3847: CURSOR c_import IS
3848: SELECT *
3849: FROM ams_imp_source_lines
3850: WHERE import_source_line_id = p_import_source_line_id
3851: ;
3852: l_import_rec c_import%ROWTYPE;
3853:

Line 4248: UPDATE ams_imp_source_lines

4244: l_party_sources_rec.col250 := l_import_rec.col250;
4245:
4246: --
4247: -- Update Interface Table
4248: UPDATE ams_imp_source_lines
4249: SET
4250: party_id = l_party_id,
4251: dedupe_key = l_dedupe_key,
4252: last_updated_by = FND_GLOBAL.user_id,

Line 4379: FROM ams_imp_source_lines

4375: l_msg_data VARCHAR2(4000);
4376:
4377: CURSOR c_import IS
4378: SELECT import_source_line_id
4379: FROM ams_imp_source_lines
4380: WHERE import_list_header_id = p_import_list_header_id
4381: ;
4382: BEGIN
4383: --