[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ams_party_sources_s.NEXTVAL
FROM dual;
SELECT 1
FROM dual
WHERE EXISTS (SELECT 1
FROM ams_party_sources
WHERE party_sources_id = x_id);
AMS_Utility_PVT.debug_message (l_full_name || ': Insert');
INSERT INTO ams_party_sources (
party_sources_id,
party_id,
import_source_line_id,
object_version_number,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
import_list_header_id,
list_source_type_id,
used_flag,
overlay_flag,
overlay_date,
col1,
col2,
col3,
col4,
col5,
col6,
col7,
col8,
col9,
col10,
col11,
col12,
col13,
col14,
col15,
col16,
col17,
col18,
col19,
col20,
col21,
col22,
col23,
col24,
col25,
col26,
col27,
col28,
col29,
col30,
col31,
col32,
col33,
col34,
col35,
col36,
col37,
col38,
col39,
col40,
col41,
col42,
col43,
col44,
col45,
col46,
col47,
col48,
col49,
col50,
col51,
col52,
col53,
col54,
col55,
col56,
col57,
col58,
col59,
col60,
col61,
col62,
col63,
col64,
col65,
col66,
col67,
col68,
col69,
col70,
col71,
col72,
col73,
col74,
col75,
col76,
col77,
col78,
col79,
col80,
col81,
col82,
col83,
col84,
col85,
col86,
col87,
col88,
col89,
col90,
col91,
col92,
col93,
col94,
col95,
col96,
col97,
col98,
col99,
col100,
col101,
col102,
col103,
col104,
col105,
col106,
col107,
col108,
col109,
col110,
col111,
col112,
col113,
col114,
col115,
col116,
col117,
col118,
col119,
col120,
col121,
col122,
col123,
col124,
col125,
col126,
col127,
col128,
col129,
col130,
col131,
col132,
col133,
col134,
col135,
col136,
col137,
col138,
col139,
col140,
col141,
col142,
col143,
col144,
col145,
col146,
col147,
col148,
col149,
col150,
col151,
col152,
col153,
col154,
col155,
col156,
col157,
col158,
col159,
col160,
col161,
col162,
col163,
col164,
col165,
col166,
col167,
col168,
col169,
col170,
col171,
col172,
col173,
col174,
col175,
col176,
col177,
col178,
col179,
col180,
col181,
col182,
col183,
col184,
col185,
col186,
col187,
col188,
col189,
col190,
col191,
col192,
col193,
col194,
col195,
col196,
col197,
col198,
col199,
col200,
col201,
col202,
col203,
col204,
col205,
col206,
col207,
col208,
col209,
col210,
col211,
col212,
col213,
col214,
col215,
col216,
col217,
col218,
col219,
col220,
col221,
col222,
col223,
col224,
col225,
col226,
col227,
col228,
col229,
col230,
col231,
col232,
col233,
col234,
col235,
col236,
col237,
col238,
col239,
col240,
col241,
col242,
col243,
col244,
col245,
col246,
col247,
col248,
col249,
col250
)
VALUES (
l_party_rec.party_sources_id,
l_party_rec.party_id,
l_party_rec.import_source_line_id,
1, -- object_version_number
SYSDATE, -- last_update_date
FND_GLOBAL.user_id, -- last_updated_by
SYSDATE, -- creation_date
FND_GLOBAL.user_id, -- created_by
FND_GLOBAL.conc_login_id, -- last_update_login
l_party_rec.import_list_header_id,
l_party_rec.list_source_type_id,
NVL (l_party_rec.used_flag, 'N'), -- Default to 'N'
NVL (l_party_rec.overlay_flag, 'N'), -- Default to 'N'
l_party_rec.overlay_date,
l_party_rec.col1,
l_party_rec.col2,
l_party_rec.col3,
l_party_rec.col4,
l_party_rec.col5,
l_party_rec.col6,
l_party_rec.col7,
l_party_rec.col8,
l_party_rec.col9,
l_party_rec.col10,
l_party_rec.col11,
l_party_rec.col12,
l_party_rec.col13,
l_party_rec.col14,
l_party_rec.col15,
l_party_rec.col16,
l_party_rec.col17,
l_party_rec.col18,
l_party_rec.col19,
l_party_rec.col20,
l_party_rec.col21,
l_party_rec.col22,
l_party_rec.col23,
l_party_rec.col24,
l_party_rec.col25,
l_party_rec.col26,
l_party_rec.col27,
l_party_rec.col28,
l_party_rec.col29,
l_party_rec.col30,
l_party_rec.col31,
l_party_rec.col32,
l_party_rec.col33,
l_party_rec.col34,
l_party_rec.col35,
l_party_rec.col36,
l_party_rec.col37,
l_party_rec.col38,
l_party_rec.col39,
l_party_rec.col40,
l_party_rec.col41,
l_party_rec.col42,
l_party_rec.col43,
l_party_rec.col44,
l_party_rec.col45,
l_party_rec.col46,
l_party_rec.col47,
l_party_rec.col48,
l_party_rec.col49,
l_party_rec.col50,
l_party_rec.col51,
l_party_rec.col52,
l_party_rec.col53,
l_party_rec.col54,
l_party_rec.col55,
l_party_rec.col56,
l_party_rec.col57,
l_party_rec.col58,
l_party_rec.col59,
l_party_rec.col60,
l_party_rec.col61,
l_party_rec.col62,
l_party_rec.col63,
l_party_rec.col64,
l_party_rec.col65,
l_party_rec.col66,
l_party_rec.col67,
l_party_rec.col68,
l_party_rec.col69,
l_party_rec.col70,
l_party_rec.col71,
l_party_rec.col72,
l_party_rec.col73,
l_party_rec.col74,
l_party_rec.col75,
l_party_rec.col76,
l_party_rec.col77,
l_party_rec.col78,
l_party_rec.col79,
l_party_rec.col80,
l_party_rec.col81,
l_party_rec.col82,
l_party_rec.col83,
l_party_rec.col84,
l_party_rec.col85,
l_party_rec.col86,
l_party_rec.col87,
l_party_rec.col88,
l_party_rec.col89,
l_party_rec.col90,
l_party_rec.col91,
l_party_rec.col92,
l_party_rec.col93,
l_party_rec.col94,
l_party_rec.col95,
l_party_rec.col96,
l_party_rec.col97,
l_party_rec.col98,
l_party_rec.col99,
l_party_rec.col100,
l_party_rec.col101,
l_party_rec.col102,
l_party_rec.col103,
l_party_rec.col104,
l_party_rec.col105,
l_party_rec.col106,
l_party_rec.col107,
l_party_rec.col108,
l_party_rec.col109,
l_party_rec.col110,
l_party_rec.col111,
l_party_rec.col112,
l_party_rec.col113,
l_party_rec.col114,
l_party_rec.col115,
l_party_rec.col116,
l_party_rec.col117,
l_party_rec.col118,
l_party_rec.col119,
l_party_rec.col120,
l_party_rec.col121,
l_party_rec.col122,
l_party_rec.col123,
l_party_rec.col124,
l_party_rec.col125,
l_party_rec.col126,
l_party_rec.col127,
l_party_rec.col128,
l_party_rec.col129,
l_party_rec.col130,
l_party_rec.col131,
l_party_rec.col132,
l_party_rec.col133,
l_party_rec.col134,
l_party_rec.col135,
l_party_rec.col136,
l_party_rec.col137,
l_party_rec.col138,
l_party_rec.col139,
l_party_rec.col140,
l_party_rec.col141,
l_party_rec.col142,
l_party_rec.col143,
l_party_rec.col144,
l_party_rec.col145,
l_party_rec.col146,
l_party_rec.col147,
l_party_rec.col148,
l_party_rec.col149,
l_party_rec.col150,
l_party_rec.col151,
l_party_rec.col152,
l_party_rec.col153,
l_party_rec.col154,
l_party_rec.col155,
l_party_rec.col156,
l_party_rec.col157,
l_party_rec.col158,
l_party_rec.col159,
l_party_rec.col160,
l_party_rec.col161,
l_party_rec.col162,
l_party_rec.col163,
l_party_rec.col164,
l_party_rec.col165,
l_party_rec.col166,
l_party_rec.col167,
l_party_rec.col168,
l_party_rec.col169,
l_party_rec.col170,
l_party_rec.col171,
l_party_rec.col172,
l_party_rec.col173,
l_party_rec.col174,
l_party_rec.col175,
l_party_rec.col176,
l_party_rec.col177,
l_party_rec.col178,
l_party_rec.col179,
l_party_rec.col180,
l_party_rec.col181,
l_party_rec.col182,
l_party_rec.col183,
l_party_rec.col184,
l_party_rec.col185,
l_party_rec.col186,
l_party_rec.col187,
l_party_rec.col188,
l_party_rec.col189,
l_party_rec.col190,
l_party_rec.col191,
l_party_rec.col192,
l_party_rec.col193,
l_party_rec.col194,
l_party_rec.col195,
l_party_rec.col196,
l_party_rec.col197,
l_party_rec.col198,
l_party_rec.col199,
l_party_rec.col200,
l_party_rec.col201,
l_party_rec.col202,
l_party_rec.col203,
l_party_rec.col204,
l_party_rec.col205,
l_party_rec.col206,
l_party_rec.col207,
l_party_rec.col208,
l_party_rec.col209,
l_party_rec.col210,
l_party_rec.col211,
l_party_rec.col212,
l_party_rec.col213,
l_party_rec.col214,
l_party_rec.col215,
l_party_rec.col216,
l_party_rec.col217,
l_party_rec.col218,
l_party_rec.col219,
l_party_rec.col220,
l_party_rec.col221,
l_party_rec.col222,
l_party_rec.col223,
l_party_rec.col224,
l_party_rec.col225,
l_party_rec.col226,
l_party_rec.col227,
l_party_rec.col228,
l_party_rec.col229,
l_party_rec.col230,
l_party_rec.col231,
l_party_rec.col232,
l_party_rec.col233,
l_party_rec.col234,
l_party_rec.col235,
l_party_rec.col236,
l_party_rec.col237,
l_party_rec.col238,
l_party_rec.col239,
l_party_rec.col240,
l_party_rec.col241,
l_party_rec.col242,
l_party_rec.col243,
l_party_rec.col244,
l_party_rec.col245,
l_party_rec.col246,
l_party_rec.col247,
l_party_rec.col248,
l_party_rec.col249,
l_party_rec.col250
);
PROCEDURE Delete_Party (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.g_false,
p_commit IN VARCHAR2 := FND_API.g_false,
p_validation_level IN NUMBER := FND_API.g_valid_level_full,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_party_sources_id IN NUMBER,
p_object_version IN NUMBER
)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Party';
SAVEPOINT Delete_Party;
DELETE FROM ams_party_sources
WHERE party_sources_id = p_party_sources_id
AND object_version_number = p_object_version;
ROLLBACK TO Delete_Party;
ROLLBACK TO Delete_Party;
ROLLBACK TO Delete_Party;
END Delete_Party;
SELECT object_version_number
FROM ams_party_sources
WHERE party_sources_id = p_party_sources_id
AND object_version_number = p_object_version
FOR UPDATE NOWAIT;
PROCEDURE Update_Party (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.g_false,
p_commit IN VARCHAR2 := FND_API.g_false,
p_validation_level IN NUMBER := FND_API.g_valid_level_full,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_party_rec IN Party_Rec_Type
)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'Update_Party';
SAVEPOINT Update_Party;
p_validation_mode => JTF_PLSQL_API.g_update,
x_return_status => l_return_status
);
UPDATE ams_party_sources
SET
party_sources_id = l_party_rec.party_sources_id,
party_id = l_party_rec.party_id,
import_source_line_id = l_party_rec.import_source_line_id,
object_version_number = l_party_rec.object_version_number,
last_update_date = SYSDATE,
last_updated_by = FND_GLOBAL.user_id,
last_update_login = FND_GLOBAL.conc_login_id,
import_list_header_id = l_party_rec.import_list_header_id,
list_source_type_id = l_party_rec.list_source_type_id,
used_flag = NVL (l_party_rec.used_flag, 'N'),
overlay_flag = NVL (l_party_rec.overlay_flag, 'N'),
overlay_date = l_party_rec.overlay_date,
col1 = l_party_rec.col1,
col2 = l_party_rec.col2,
col3 = l_party_rec.col3,
col4 = l_party_rec.col4,
col5 = l_party_rec.col5,
col6 = l_party_rec.col6,
col7 = l_party_rec.col7,
col8 = l_party_rec.col8,
col9 = l_party_rec.col9,
col10 = l_party_rec.col10,
col11 = l_party_rec.col11,
col12 = l_party_rec.col12,
col13 = l_party_rec.col13,
col14 = l_party_rec.col14,
col15 = l_party_rec.col15,
col16 = l_party_rec.col16,
col17 = l_party_rec.col17,
col18 = l_party_rec.col18,
col19 = l_party_rec.col19,
col20 = l_party_rec.col20,
col21 = l_party_rec.col21,
col22 = l_party_rec.col22,
col23 = l_party_rec.col23,
col24 = l_party_rec.col24,
col25 = l_party_rec.col25,
col26 = l_party_rec.col26,
col27 = l_party_rec.col27,
col28 = l_party_rec.col28,
col29 = l_party_rec.col29,
col30 = l_party_rec.col30,
col31 = l_party_rec.col31,
col32 = l_party_rec.col32,
col33 = l_party_rec.col33,
col34 = l_party_rec.col34,
col35 = l_party_rec.col35,
col36 = l_party_rec.col36,
col37 = l_party_rec.col37,
col38 = l_party_rec.col38,
col39 = l_party_rec.col39,
col40 = l_party_rec.col40,
col41 = l_party_rec.col41,
col42 = l_party_rec.col42,
col43 = l_party_rec.col43,
col44 = l_party_rec.col44,
col45 = l_party_rec.col45,
col46 = l_party_rec.col46,
col47 = l_party_rec.col47,
col48 = l_party_rec.col48,
col49 = l_party_rec.col49,
col50 = l_party_rec.col50,
col51 = l_party_rec.col51,
col52 = l_party_rec.col52,
col53 = l_party_rec.col53,
col54 = l_party_rec.col54,
col55 = l_party_rec.col55,
col56 = l_party_rec.col56,
col57 = l_party_rec.col57,
col58 = l_party_rec.col58,
col59 = l_party_rec.col59,
col60 = l_party_rec.col60,
col61 = l_party_rec.col61,
col62 = l_party_rec.col62,
col63 = l_party_rec.col63,
col64 = l_party_rec.col64,
col65 = l_party_rec.col65,
col66 = l_party_rec.col66,
col67 = l_party_rec.col67,
col68 = l_party_rec.col68,
col69 = l_party_rec.col69,
col70 = l_party_rec.col70,
col71 = l_party_rec.col71,
col72 = l_party_rec.col72,
col73 = l_party_rec.col73,
col74 = l_party_rec.col74,
col75 = l_party_rec.col75,
col76 = l_party_rec.col76,
col77 = l_party_rec.col77,
col78 = l_party_rec.col78,
col79 = l_party_rec.col79,
col80 = l_party_rec.col80,
col81 = l_party_rec.col81,
col82 = l_party_rec.col82,
col83 = l_party_rec.col83,
col84 = l_party_rec.col84,
col85 = l_party_rec.col85,
col86 = l_party_rec.col86,
col87 = l_party_rec.col87,
col88 = l_party_rec.col88,
col89 = l_party_rec.col89,
col90 = l_party_rec.col90,
col91 = l_party_rec.col91,
col92 = l_party_rec.col92,
col93 = l_party_rec.col93,
col94 = l_party_rec.col94,
col95 = l_party_rec.col95,
col96 = l_party_rec.col96,
col97 = l_party_rec.col97,
col98 = l_party_rec.col98,
col99 = l_party_rec.col99,
col100 = l_party_rec.col100,
col101 = l_party_rec.col101,
col102 = l_party_rec.col102,
col103 = l_party_rec.col103,
col104 = l_party_rec.col104,
col105 = l_party_rec.col105,
col106 = l_party_rec.col106,
col107 = l_party_rec.col107,
col108 = l_party_rec.col108,
col109 = l_party_rec.col109,
col110 = l_party_rec.col110,
col111 = l_party_rec.col111,
col112 = l_party_rec.col112,
col113 = l_party_rec.col113,
col114 = l_party_rec.col114,
col115 = l_party_rec.col115,
col116 = l_party_rec.col116,
col117 = l_party_rec.col117,
col118 = l_party_rec.col118,
col119 = l_party_rec.col119,
col120 = l_party_rec.col120,
col121 = l_party_rec.col121,
col122 = l_party_rec.col122,
col123 = l_party_rec.col123,
col124 = l_party_rec.col124,
col125 = l_party_rec.col125,
col126 = l_party_rec.col126,
col127 = l_party_rec.col127,
col128 = l_party_rec.col128,
col129 = l_party_rec.col129,
col130 = l_party_rec.col130,
col131 = l_party_rec.col131,
col132 = l_party_rec.col132,
col133 = l_party_rec.col133,
col134 = l_party_rec.col134,
col135 = l_party_rec.col135,
col136 = l_party_rec.col136,
col137 = l_party_rec.col137,
col138 = l_party_rec.col138,
col139 = l_party_rec.col139,
col140 = l_party_rec.col140,
col141 = l_party_rec.col141,
col142 = l_party_rec.col142,
col143 = l_party_rec.col143,
col144 = l_party_rec.col144,
col145 = l_party_rec.col145,
col146 = l_party_rec.col146,
col147 = l_party_rec.col147,
col148 = l_party_rec.col148,
col149 = l_party_rec.col149,
col150 = l_party_rec.col150,
col151 = l_party_rec.col151,
col152 = l_party_rec.col152,
col153 = l_party_rec.col153,
col154 = l_party_rec.col154,
col155 = l_party_rec.col155,
col156 = l_party_rec.col156,
col157 = l_party_rec.col157,
col158 = l_party_rec.col158,
col159 = l_party_rec.col159,
col160 = l_party_rec.col160,
col161 = l_party_rec.col161,
col162 = l_party_rec.col162,
col163 = l_party_rec.col163,
col164 = l_party_rec.col164,
col165 = l_party_rec.col165,
col166 = l_party_rec.col166,
col167 = l_party_rec.col167,
col168 = l_party_rec.col168,
col169 = l_party_rec.col169,
col170 = l_party_rec.col170,
col171 = l_party_rec.col171,
col172 = l_party_rec.col172,
col173 = l_party_rec.col173,
col174 = l_party_rec.col174,
col175 = l_party_rec.col175,
col176 = l_party_rec.col176,
col177 = l_party_rec.col177,
col178 = l_party_rec.col178,
col179 = l_party_rec.col179,
col180 = l_party_rec.col180,
col181 = l_party_rec.col181,
col182 = l_party_rec.col182,
col183 = l_party_rec.col183,
col184 = l_party_rec.col184,
col185 = l_party_rec.col185,
col186 = l_party_rec.col186,
col187 = l_party_rec.col187,
col188 = l_party_rec.col188,
col189 = l_party_rec.col189,
col190 = l_party_rec.col190,
col191 = l_party_rec.col191,
col192 = l_party_rec.col192,
col193 = l_party_rec.col193,
col194 = l_party_rec.col194,
col195 = l_party_rec.col195,
col196 = l_party_rec.col196,
col197 = l_party_rec.col197,
col198 = l_party_rec.col198,
col199 = l_party_rec.col199,
col200 = l_party_rec.col200,
col201 = l_party_rec.col201,
col202 = l_party_rec.col202,
col203 = l_party_rec.col203,
col204 = l_party_rec.col204,
col205 = l_party_rec.col205,
col206 = l_party_rec.col206,
col207 = l_party_rec.col207,
col208 = l_party_rec.col208,
col209 = l_party_rec.col209,
col210 = l_party_rec.col210,
col211 = l_party_rec.col211,
col212 = l_party_rec.col212,
col213 = l_party_rec.col213,
col214 = l_party_rec.col214,
col215 = l_party_rec.col215,
col216 = l_party_rec.col216,
col217 = l_party_rec.col217,
col218 = l_party_rec.col218,
col219 = l_party_rec.col219,
col220 = l_party_rec.col220,
col221 = l_party_rec.col221,
col222 = l_party_rec.col222,
col223 = l_party_rec.col223,
col224 = l_party_rec.col224,
col225 = l_party_rec.col225,
col226 = l_party_rec.col226,
col227 = l_party_rec.col227,
col228 = l_party_rec.col228,
col229 = l_party_rec.col229,
col230 = l_party_rec.col230,
col231 = l_party_rec.col231,
col232 = l_party_rec.col232,
col233 = l_party_rec.col233,
col234 = l_party_rec.col234,
col235 = l_party_rec.col235,
col236 = l_party_rec.col236,
col237 = l_party_rec.col237,
col238 = l_party_rec.col238,
col239 = l_party_rec.col239,
col240 = l_party_rec.col240,
col241 = l_party_rec.col241,
col242 = l_party_rec.col242,
col243 = l_party_rec.col243,
col244 = l_party_rec.col244,
col245 = l_party_rec.col245,
col246 = l_party_rec.col246,
col247 = l_party_rec.col247,
col248 = l_party_rec.col248,
col249 = l_party_rec.col249,
col250 = l_party_rec.col250
WHERE party_sources_id = l_party_rec.party_sources_id
AND object_version_number = l_party_rec.object_version_number;
ROLLBACK TO Update_Party;
ROLLBACK TO Update_Party;
ROLLBACK TO Update_Party;
END Update_Party;
x_party_rec.last_update_date := FND_API.g_miss_date;
x_party_rec.last_updated_by := FND_API.g_miss_num;
x_party_rec.last_update_login := FND_API.g_miss_num;
SELECT *
FROM ams_party_sources
WHERE party_sources_id = p_party_rec.party_sources_id;
IF p_party_rec.last_update_date = FND_API.g_miss_date THEN
x_complete_rec.last_update_date := l_party_rec.last_update_date;
IF p_party_rec.last_updated_by = FND_API.g_miss_num THEN
x_complete_rec.last_updated_by := l_party_rec.last_updated_by;
IF p_party_rec.last_update_login = FND_API.g_miss_num THEN
x_complete_rec.last_update_login := l_party_rec.last_update_login;
DELETE FROM ams_party_dedupe;
INSERT INTO ams_party_dedupe (
party_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
object_version_number
)
SELECT party_id,
SYSDATE, -- last_update_date
FND_GLOBAL.user_id, -- last_updated_by
SYSDATE, -- creation_date
FND_GLOBAL.user_id, -- created_by
FND_GLOBAL.conc_login_id, -- last_update_login
1 -- object_version_number
FROM hz_parties
;
SELECT list_rule_id
FROM ams_list_rules_all
WHERE list_rule_name = x_rule_name
;
SELECT party_id
FROM ams_party_dedupe
WHERE dedupe_key IS NULL
FOR UPDATE NOWAIT
;
UPDATE ams_party_dedupe
SET
dedupe_key = l_dedupe_key,
last_update_date = SYSDATE,
last_updated_by = FND_GLOBAL.user_id,
last_update_login = FND_GLOBAL.conc_login_id,
object_version_number = object_version_number + 1
WHERE party_id = l_party_id;
SELECT list_rule_id
FROM ams_list_rules_all
WHERE list_rule_name = x_rule_name
;
SELECT *
FROM ams_imp_source_lines
WHERE import_source_line_id = p_import_source_line_id
;
SELECT list_source_type_id
FROM ams_imp_list_headers_all
WHERE import_list_header_id = l_import_rec.import_list_header_id
;
UPDATE ams_imp_source_lines
SET
party_id = l_party_id,
dedupe_key = l_dedupe_key,
last_updated_by = FND_GLOBAL.user_id,
last_update_date = SYSDATE,
last_update_login = FND_GLOBAL.conc_login_id,
object_version_number = object_version_number + 1
WHERE import_source_line_id = p_import_source_line_id;
SELECT party_id
FROM ams_party_dedupe
WHERE dedupe_key = p_dedupe_key
;
SELECT import_source_line_id
FROM ams_imp_source_lines
WHERE import_list_header_id = p_import_list_header_id
;