The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
list_entry_id ,
list_header_id ,
last_update_date ,
last_updated_by ,
creation_date ,
created_by ,
last_update_login ,
object_version_number ,
list_select_action_id ,
arc_list_select_action_from ,
list_select_action_from_name ,
source_code ,
arc_list_used_by_source ,
source_code_for_id ,
pin_code ,
list_entry_source_system_id ,
list_entry_source_system_type ,
view_application_id ,
manually_entered_flag ,
marked_as_duplicate_flag ,
marked_as_random_flag ,
part_of_control_group_flag ,
exclude_in_triggered_list_flag ,
enabled_flag ,
cell_code ,
dedupe_key ,
randomly_generated_number ,
campaign_id ,
media_id ,
channel_id ,
channel_schedule_id ,
event_offer_id ,
customer_id ,
market_segment_id ,
vendor_id ,
transfer_flag ,
transfer_status ,
list_source ,
duplicate_master_entry_id ,
marked_flag ,
lead_id ,
letter_id ,
picking_header_id ,
batch_id ,
suffix ,
first_name ,
last_name ,
customer_name ,
title ,
address_line1 ,
address_line2 ,
city ,
state ,
zipcode ,
country ,
fax ,
phone ,
email_address ,
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 ,
COL251 ,
COL252 ,
COL253 ,
COL254 ,
COL255 ,
COL256 ,
COL257 ,
COL258 ,
COL259 ,
COL260 ,
COL261 ,
COL262 ,
COL263 ,
COL264 ,
COL265 ,
COL266 ,
COL267 ,
COL268 ,
COL269 ,
COL270 ,
COL271 ,
COL272 ,
COL273 ,
COL274 ,
COL275 ,
COL276 ,
COL277 ,
COL278 ,
COL279 ,
COL280 ,
COL281 ,
COL282 ,
COL283 ,
COL284 ,
COL285 ,
COL286 ,
COL287 ,
COL288 ,
COL289 ,
COL290 ,
COL291 ,
COL292 ,
COL293 ,
COL294 ,
COL295 ,
COL296 ,
COL297 ,
COL298 ,
COL299 ,
COL300 ,
CURR_CP_COUNTRY_CODE ,
CURR_CP_PHONE_NUMBER ,
CURR_CP_RAW_PHONE_NUMBER ,
CURR_CP_AREA_CODE ,
CURR_CP_ID ,
CURR_CP_INDEX ,
CURR_CP_TIME_ZONE ,
CURR_CP_TIME_ZONE_AUX ,
party_id ,
parent_party_id ,
imp_source_line_id ,
usage_restriction ,
next_call_time ,
callback_flag ,
do_not_use_flag ,
do_not_use_reason ,
record_out_flag ,
record_release_time ,
group_code ,
newly_updated_flag ,
outcome_id ,
result_id ,
reason_id ,
notes ,
VEHICLE_RESPONSE_CODE ,
SALES_AGENT_EMAIL_ADDRESS ,
RESOURCE_ID ,
LOCATION_ID ,
CONTACT_POINT_ID ,
last_contacted_date
FROM ams_list_entries
WHERE list_entry_id = p_list_entries_rec.list_entry_id;
IF p_list_entries_rec.LAST_UPDATE_DATE = FND_API.g_miss_date THEN
x_complete_rec.LAST_UPDATE_DATE := l_listentries_rec.LAST_UPDATE_DATE ;
IF p_list_entries_rec.LAST_UPDATED_BY = FND_API.g_miss_num THEN
x_complete_rec.LAST_UPDATED_BY := l_listentries_rec.LAST_UPDATED_BY ;
IF p_list_entries_rec.LAST_UPDATE_LOGIN = FND_API.g_miss_num THEN
x_complete_rec.LAST_UPDATE_LOGIN := l_listentries_rec.LAST_UPDATE_LOGIN ;
IF p_list_entries_rec.LIST_SELECT_ACTION_ID = FND_API.g_miss_num THEN
x_complete_rec.LIST_SELECT_ACTION_ID := l_listentries_rec.LIST_SELECT_ACTION_ID ;
IF p_list_entries_rec.ARC_LIST_SELECT_ACTION_FROM = FND_API.g_miss_char THEN
x_complete_rec.ARC_LIST_SELECT_ACTION_FROM := l_listentries_rec.ARC_LIST_SELECT_ACTION_FROM ;
IF p_list_entries_rec.LIST_SELECT_ACTION_FROM_NAME = FND_API.g_miss_char THEN
x_complete_rec.LIST_SELECT_ACTION_FROM_NAME := l_listentries_rec.LIST_SELECT_ACTION_FROM_NAME ;
IF p_list_entries_rec.newly_updated_flag = FND_API.g_miss_char THEN
x_complete_rec.newly_updated_flag := l_listentries_rec.newly_updated_flag;
SELECT AMS_LIST_ENTRIES_s.NEXTVAL
FROM dual;
SELECT 1 FROM dual
WHERE EXISTS (SELECT 1 FROM AMS_LIST_ENTRIES
WHERE LIST_ENTRY_ID = l_id);
SELECT created_by
FROM ams_list_headers_all
WHERE list_header_id= x_list_header_id;
AMS_LIST_ENTRIES_PKG.Insert_Row(
px_list_entry_id => l_list_entry_id,
p_list_header_id => p_list_entries_rec.list_header_id,
p_last_update_date => SYSDATE,
p_last_updated_by => FND_GLOBAL.USER_ID,
p_creation_date => SYSDATE,
p_created_by => nvl(l_created_by, FND_GLOBAL.USER_ID),
p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
px_object_version_number => l_object_version_number,
p_list_select_action_id => p_list_entries_rec.list_select_action_id,
p_arc_list_select_action_from => p_list_entries_rec.arc_list_select_action_from,
p_list_select_action_from_name => p_list_entries_rec.list_select_action_from_name,
p_source_code => p_list_entries_rec.source_code,
p_arc_list_used_by_source => p_list_entries_rec.arc_list_used_by_source,
p_source_code_for_id => p_list_entries_rec.source_code_for_id,
p_pin_code => l_list_entry_id,
p_list_entry_source_system_id => p_list_entries_rec.list_entry_source_system_id,
p_list_entry_source_system_tp => p_list_entries_rec.list_entry_source_system_type,
p_view_application_id => p_list_entries_rec.view_application_id,
p_manually_entered_flag => p_list_entries_rec.manually_entered_flag,
p_marked_as_duplicate_flag => p_list_entries_rec.marked_as_duplicate_flag,
p_marked_as_random_flag => p_list_entries_rec.marked_as_random_flag,
p_part_of_control_group_flag => p_list_entries_rec.part_of_control_group_flag,
p_exclude_in_triggered_list_fg => p_list_entries_rec.exclude_in_triggered_list_flag,
p_enabled_flag => p_list_entries_rec.enabled_flag,
p_cell_code => p_list_entries_rec.cell_code,
p_dedupe_key => p_list_entries_rec.dedupe_key,
p_randomly_generated_number => p_list_entries_rec.randomly_generated_number,
p_campaign_id => p_list_entries_rec.campaign_id,
p_media_id => p_list_entries_rec.media_id,
p_channel_id => p_list_entries_rec.channel_id,
p_channel_schedule_id => p_list_entries_rec.channel_schedule_id,
p_event_offer_id => p_list_entries_rec.event_offer_id,
p_customer_id => p_list_entries_rec.customer_id,
p_market_segment_id => p_list_entries_rec.market_segment_id,
p_vendor_id => p_list_entries_rec.vendor_id,
p_transfer_flag => p_list_entries_rec.transfer_flag,
p_transfer_status => p_list_entries_rec.transfer_status,
p_list_source => p_list_entries_rec.list_source,
p_duplicate_master_entry_id => p_list_entries_rec.duplicate_master_entry_id,
p_marked_flag => p_list_entries_rec.marked_flag,
p_lead_id => p_list_entries_rec.lead_id,
p_letter_id => p_list_entries_rec.letter_id,
p_picking_header_id => p_list_entries_rec.picking_header_id,
p_batch_id => p_list_entries_rec.batch_id,
p_suffix => p_list_entries_rec.suffix,
p_first_name => p_list_entries_rec.first_name,
p_last_name => p_list_entries_rec.last_name,
p_customer_name => p_list_entries_rec.customer_name,
p_title => p_list_entries_rec.title,
p_address_line1 => p_list_entries_rec.address_line1,
p_address_line2 => p_list_entries_rec.address_line2,
p_city => p_list_entries_rec.city,
p_state => p_list_entries_rec.state,
p_zipcode => p_list_entries_rec.zipcode,
p_country => p_list_entries_rec.country,
p_fax => p_list_entries_rec.fax,
p_phone => p_list_entries_rec.phone,
p_email_address => p_list_entries_rec.email_address,
p_col1 => p_list_entries_rec.col1,
p_col2 => p_list_entries_rec.col2,
p_col3 => p_list_entries_rec.col3,
p_col4 => p_list_entries_rec.col4,
p_col5 => p_list_entries_rec.col5,
p_col6 => p_list_entries_rec.col6,
p_col7 => p_list_entries_rec.col7,
p_col8 => p_list_entries_rec.col8,
p_col9 => p_list_entries_rec.col9,
p_col10 => p_list_entries_rec.col10,
p_col11 => p_list_entries_rec.col11,
p_col12 => p_list_entries_rec.col12,
p_col13 => p_list_entries_rec.col13,
p_col14 => p_list_entries_rec.col14,
p_col15 => p_list_entries_rec.col15,
p_col16 => p_list_entries_rec.col16,
p_col17 => p_list_entries_rec.col17,
p_col18 => p_list_entries_rec.col18,
p_col19 => p_list_entries_rec.col19,
p_col20 => p_list_entries_rec.col20,
p_col21 => p_list_entries_rec.col21,
p_col22 => p_list_entries_rec.col22,
p_col23 => p_list_entries_rec.col23,
p_col24 => p_list_entries_rec.col24,
p_col25 => p_list_entries_rec.col25,
p_col26 => p_list_entries_rec.col26,
p_col27 => p_list_entries_rec.col27,
p_col28 => p_list_entries_rec.col28,
p_col29 => p_list_entries_rec.col29,
p_col30 => p_list_entries_rec.col30,
p_col31 => p_list_entries_rec.col31,
p_col32 => p_list_entries_rec.col32,
p_col33 => p_list_entries_rec.col33,
p_col34 => p_list_entries_rec.col34,
p_col35 => p_list_entries_rec.col35,
p_col36 => p_list_entries_rec.col36,
p_col37 => p_list_entries_rec.col37,
p_col38 => p_list_entries_rec.col38,
p_col39 => p_list_entries_rec.col39,
p_col40 => p_list_entries_rec.col40,
p_col41 => p_list_entries_rec.col41,
p_col42 => p_list_entries_rec.col42,
p_col43 => p_list_entries_rec.col43,
p_col44 => p_list_entries_rec.col44,
p_col45 => p_list_entries_rec.col45,
p_col46 => p_list_entries_rec.col46,
p_col47 => p_list_entries_rec.col47,
p_col48 => p_list_entries_rec.col48,
p_col49 => p_list_entries_rec.col49,
p_col50 => p_list_entries_rec.col50,
p_col51 => p_list_entries_rec.col51,
p_col52 => p_list_entries_rec.col52,
p_col53 => p_list_entries_rec.col53,
p_col54 => p_list_entries_rec.col54,
p_col55 => p_list_entries_rec.col55,
p_col56 => p_list_entries_rec.col56,
p_col57 => p_list_entries_rec.col57,
p_col58 => p_list_entries_rec.col58,
p_col59 => p_list_entries_rec.col59,
p_col60 => p_list_entries_rec.col60,
p_col61 => p_list_entries_rec.col61,
p_col62 => p_list_entries_rec.col62,
p_col63 => p_list_entries_rec.col63,
p_col64 => p_list_entries_rec.col64,
p_col65 => p_list_entries_rec.col65,
p_col66 => p_list_entries_rec.col66,
p_col67 => p_list_entries_rec.col67,
p_col68 => p_list_entries_rec.col68,
p_col69 => p_list_entries_rec.col69,
p_col70 => p_list_entries_rec.col70,
p_col71 => p_list_entries_rec.col71,
p_col72 => p_list_entries_rec.col72,
p_col73 => p_list_entries_rec.col73,
p_col74 => p_list_entries_rec.col74,
p_col75 => p_list_entries_rec.col75,
p_col76 => p_list_entries_rec.col76,
p_col77 => p_list_entries_rec.col77,
p_col78 => p_list_entries_rec.col78,
p_col79 => p_list_entries_rec.col79,
p_col80 => p_list_entries_rec.col80,
p_col81 => p_list_entries_rec.col81,
p_col82 => p_list_entries_rec.col82,
p_col83 => p_list_entries_rec.col83,
p_col84 => p_list_entries_rec.col84,
p_col85 => p_list_entries_rec.col85,
p_col86 => p_list_entries_rec.col86,
p_col87 => p_list_entries_rec.col87,
p_col88 => p_list_entries_rec.col88,
p_col89 => p_list_entries_rec.col89,
p_col90 => p_list_entries_rec.col90,
p_col91 => p_list_entries_rec.col91,
p_col92 => p_list_entries_rec.col92,
p_col93 => p_list_entries_rec.col93,
p_col94 => p_list_entries_rec.col94,
p_col95 => p_list_entries_rec.col95,
p_col96 => p_list_entries_rec.col96,
p_col97 => p_list_entries_rec.col97,
p_col98 => p_list_entries_rec.col98,
p_col99 => p_list_entries_rec.col99,
p_col100 => p_list_entries_rec.col100,
p_col101 => p_list_entries_rec.col101,
p_col102 => p_list_entries_rec.col102,
p_col103 => p_list_entries_rec.col103,
p_col104 => p_list_entries_rec.col104,
p_col105 => p_list_entries_rec.col105,
p_col106 => p_list_entries_rec.col106,
p_col107 => p_list_entries_rec.col107,
p_col108 => p_list_entries_rec.col108,
p_col109 => p_list_entries_rec.col109,
p_col110 => p_list_entries_rec.col110,
p_col111 => p_list_entries_rec.col111,
p_col112 => p_list_entries_rec.col112,
p_col113 => p_list_entries_rec.col113,
p_col114 => p_list_entries_rec.col114,
p_col115 => p_list_entries_rec.col115,
p_col116 => p_list_entries_rec.col116,
p_col117 => p_list_entries_rec.col117,
p_col118 => p_list_entries_rec.col118,
p_col119 => p_list_entries_rec.col119,
p_col120 => p_list_entries_rec.col120,
p_col121 => p_list_entries_rec.col121,
p_col122 => p_list_entries_rec.col122,
p_col123 => p_list_entries_rec.col123,
p_col124 => p_list_entries_rec.col124,
p_col125 => p_list_entries_rec.col125,
p_col126 => p_list_entries_rec.col126,
p_col127 => p_list_entries_rec.col127,
p_col128 => p_list_entries_rec.col128,
p_col129 => p_list_entries_rec.col129,
p_col130 => p_list_entries_rec.col130,
p_col131 => p_list_entries_rec.col131,
p_col132 => p_list_entries_rec.col132,
p_col133 => p_list_entries_rec.col133,
p_col134 => p_list_entries_rec.col134,
p_col135 => p_list_entries_rec.col135,
p_col136 => p_list_entries_rec.col136,
p_col137 => p_list_entries_rec.col137,
p_col138 => p_list_entries_rec.col138,
p_col139 => p_list_entries_rec.col139,
p_col140 => p_list_entries_rec.col140,
p_col141 => p_list_entries_rec.col141,
p_col142 => p_list_entries_rec.col142,
p_col143 => p_list_entries_rec.col143,
p_col144 => p_list_entries_rec.col144,
p_col145 => p_list_entries_rec.col145,
p_col146 => p_list_entries_rec.col146,
p_col147 => p_list_entries_rec.col147,
p_col148 => p_list_entries_rec.col148,
p_col149 => p_list_entries_rec.col149,
p_col150 => p_list_entries_rec.col150,
p_col151 => p_list_entries_rec.col151,
p_col152 => p_list_entries_rec.col152,
p_col153 => p_list_entries_rec.col153,
p_col154 => p_list_entries_rec.col154,
p_col155 => p_list_entries_rec.col155,
p_col156 => p_list_entries_rec.col156,
p_col157 => p_list_entries_rec.col157,
p_col158 => p_list_entries_rec.col158,
p_col159 => p_list_entries_rec.col159,
p_col160 => p_list_entries_rec.col160,
p_col161 => p_list_entries_rec.col161,
p_col162 => p_list_entries_rec.col162,
p_col163 => p_list_entries_rec.col163,
p_col164 => p_list_entries_rec.col164,
p_col165 => p_list_entries_rec.col165,
p_col166 => p_list_entries_rec.col166,
p_col167 => p_list_entries_rec.col167,
p_col168 => p_list_entries_rec.col168,
p_col169 => p_list_entries_rec.col169,
p_col170 => p_list_entries_rec.col170,
p_col171 => p_list_entries_rec.col171,
p_col172 => p_list_entries_rec.col172,
p_col173 => p_list_entries_rec.col173,
p_col174 => p_list_entries_rec.col174,
p_col175 => p_list_entries_rec.col175,
p_col176 => p_list_entries_rec.col176,
p_col177 => p_list_entries_rec.col177,
p_col178 => p_list_entries_rec.col178,
p_col179 => p_list_entries_rec.col179,
p_col180 => p_list_entries_rec.col180,
p_col181 => p_list_entries_rec.col181,
p_col182 => p_list_entries_rec.col182,
p_col183 => p_list_entries_rec.col183,
p_col184 => p_list_entries_rec.col184,
p_col185 => p_list_entries_rec.col185,
p_col186 => p_list_entries_rec.col186,
p_col187 => p_list_entries_rec.col187,
p_col188 => p_list_entries_rec.col188,
p_col189 => p_list_entries_rec.col189,
p_col190 => p_list_entries_rec.col190,
p_col191 => p_list_entries_rec.col191,
p_col192 => p_list_entries_rec.col192,
p_col193 => p_list_entries_rec.col193,
p_col194 => p_list_entries_rec.col194,
p_col195 => p_list_entries_rec.col195,
p_col196 => p_list_entries_rec.col196,
p_col197 => p_list_entries_rec.col197,
p_col198 => p_list_entries_rec.col198,
p_col199 => p_list_entries_rec.col199,
p_col200 => p_list_entries_rec.col200,
p_col201 => p_list_entries_rec.col201,
p_col202 => p_list_entries_rec.col202,
p_col203 => p_list_entries_rec.col203,
p_col204 => p_list_entries_rec.col204,
p_col205 => p_list_entries_rec.col205,
p_col206 => p_list_entries_rec.col206,
p_col207 => p_list_entries_rec.col207,
p_col208 => p_list_entries_rec.col208,
p_col209 => p_list_entries_rec.col209,
p_col210 => p_list_entries_rec.col210,
p_col211 => p_list_entries_rec.col211,
p_col212 => p_list_entries_rec.col212,
p_col213 => p_list_entries_rec.col213,
p_col214 => p_list_entries_rec.col214,
p_col215 => p_list_entries_rec.col215,
p_col216 => p_list_entries_rec.col216,
p_col217 => p_list_entries_rec.col217,
p_col218 => p_list_entries_rec.col218,
p_col219 => p_list_entries_rec.col219,
p_col220 => p_list_entries_rec.col220,
p_col221 => p_list_entries_rec.col221,
p_col222 => p_list_entries_rec.col222,
p_col223 => p_list_entries_rec.col223,
p_col224 => p_list_entries_rec.col224,
p_col225 => p_list_entries_rec.col225,
p_col226 => p_list_entries_rec.col226,
p_col227 => p_list_entries_rec.col227,
p_col228 => p_list_entries_rec.col228,
p_col229 => p_list_entries_rec.col229,
p_col230 => p_list_entries_rec.col230,
p_col231 => p_list_entries_rec.col231,
p_col232 => p_list_entries_rec.col232,
p_col233 => p_list_entries_rec.col233,
p_col234 => p_list_entries_rec.col234,
p_col235 => p_list_entries_rec.col235,
p_col236 => p_list_entries_rec.col236,
p_col237 => p_list_entries_rec.col237,
p_col238 => p_list_entries_rec.col238,
p_col239 => p_list_entries_rec.col239,
p_col240 => p_list_entries_rec.col240,
p_col241 => p_list_entries_rec.col241,
p_col242 => p_list_entries_rec.col242,
p_col243 => p_list_entries_rec.col243,
p_col244 => p_list_entries_rec.col244,
p_col245 => p_list_entries_rec.col245,
p_col246 => p_list_entries_rec.col246,
p_col247 => p_list_entries_rec.col247,
p_col248 => p_list_entries_rec.col248,
p_col249 => p_list_entries_rec.col249,
p_col250 => p_list_entries_rec.col250,
p_col251 => p_list_entries_rec.col251,
p_col252 => p_list_entries_rec.col252,
p_col253 => p_list_entries_rec.col253,
p_col254 => p_list_entries_rec.col254,
p_col255 => p_list_entries_rec.col255,
p_col256 => p_list_entries_rec.col256,
p_col257 => p_list_entries_rec.col257,
p_col258 => p_list_entries_rec.col258,
p_col259 => p_list_entries_rec.col259,
p_col260 => p_list_entries_rec.col260,
p_col261 => p_list_entries_rec.col261,
p_col262 => p_list_entries_rec.col262,
p_col263 => p_list_entries_rec.col263,
p_col264 => p_list_entries_rec.col264,
p_col265 => p_list_entries_rec.col265,
p_col266 => p_list_entries_rec.col266,
p_col267 => p_list_entries_rec.col267,
p_col268 => p_list_entries_rec.col268,
p_col269 => p_list_entries_rec.col269,
p_col270 => p_list_entries_rec.col270,
p_col271 => p_list_entries_rec.col271,
p_col272 => p_list_entries_rec.col272,
p_col273 => p_list_entries_rec.col273,
p_col274 => p_list_entries_rec.col274,
p_col275 => p_list_entries_rec.col275,
p_col276 => p_list_entries_rec.col276,
p_col277 => p_list_entries_rec.col277,
p_col278 => p_list_entries_rec.col278,
p_col279 => p_list_entries_rec.col279,
p_col280 => p_list_entries_rec.col280,
p_col281 => p_list_entries_rec.col281,
p_col282 => p_list_entries_rec.col282,
p_col283 => p_list_entries_rec.col283,
p_col284 => p_list_entries_rec.col284,
p_col285 => p_list_entries_rec.col285,
p_col286 => p_list_entries_rec.col286,
p_col287 => p_list_entries_rec.col287,
p_col288 => p_list_entries_rec.col288,
p_col289 => p_list_entries_rec.col289,
p_col290 => p_list_entries_rec.col290,
p_col291 => p_list_entries_rec.col291,
p_col292 => p_list_entries_rec.col292,
p_col293 => p_list_entries_rec.col293,
p_col294 => p_list_entries_rec.col294,
p_col295 => p_list_entries_rec.col295,
p_col296 => p_list_entries_rec.col296,
p_col297 => p_list_entries_rec.col297,
p_col298 => p_list_entries_rec.col298,
p_col299 => p_list_entries_rec.col299,
p_col300 => p_list_entries_rec.col300,
p_party_id => p_list_entries_rec.party_id,
p_parent_party_id => p_list_entries_rec.parent_party_id,
p_imp_source_line_id => p_list_entries_rec.imp_source_line_id,
p_usage_restriction => p_list_entries_rec.usage_restriction,
p_next_call_time => p_list_entries_rec.next_call_time,
p_callback_flag => p_list_entries_rec.callback_flag,
p_do_not_use_flag => p_list_entries_rec.do_not_use_flag,
p_do_not_use_reason => p_list_entries_rec.do_not_use_reason,
p_record_out_flag => p_list_entries_rec.record_out_flag,
p_record_release_time => p_list_entries_rec.record_release_time,
p_group_code => p_list_entries_rec.group_code,
p_newly_updated_flag => p_list_entries_rec.newly_updated_flag,
p_outcome_id => p_list_entries_rec.outcome_id,
p_result_id => p_list_entries_rec.result_id ,
p_reason_id => p_list_entries_rec.reason_id,
p_notes => p_list_entries_rec.notes ,
p_VEHICLE_RESPONSE_CODE => p_list_entries_rec.VEHICLE_RESPONSE_CODE ,
p_SALES_AGENT_EMAIL_ADDRESS => p_list_entries_rec.SALES_AGENT_EMAIL_ADDRESS ,
p_RESOURCE_ID => p_list_entries_rec.RESOURCE_ID ,
p_LOCATION_ID => p_list_entries_rec.location_id,
p_CONTACT_POINT_ID => p_list_entries_rec.contact_point_id,
p_last_contacted_date => p_list_entries_rec.last_contacted_date
);
PROCEDURE Update_List_Entries
(
p_api_version_number 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_list_entries_rec IN list_entries_rec_type,
x_object_version_number OUT NOCOPY NUMBER
) IS
CURSOR c_get_list_entries(lc_list_entry_id NUMBER) IS
SELECT *
FROM AMS_LIST_ENTRIES
WHERE list_entry_id = lc_list_entry_id ;
L_API_NAME CONSTANT VARCHAR2(30) := 'Update_List_Entries';
SELECT created_by
FROM ams_list_headers_all
WHERE list_header_id= x_list_header_id;
SAVEPOINT UPDATE_List_Entries_PVT;
AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
p_token_name => 'INFO',
p_token_value => 'List_Entries' || P_list_entries_rec.list_entry_id) ;
p_validation_mode => JTF_PLSQL_API.g_update,
p_list_entries_rec => x_list_entries_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
AMS_LIST_ENTRIES_PKG.Update_Row(
p_list_entry_id => x_list_entries_rec.list_entry_id,
p_list_header_id => x_list_entries_rec.list_header_id,
p_last_update_date => SYSDATE,
p_last_updated_by => FND_GLOBAL.USER_ID,
p_creation_date => SYSDATE,
p_created_by => nvl(l_created_by, FND_GLOBAL.USER_ID),
p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
p_object_version_number => x_list_entries_rec.object_version_number,
p_list_select_action_id => x_list_entries_rec.list_select_action_id,
p_arc_list_select_action_from => x_list_entries_rec.arc_list_select_action_from,
p_list_select_action_from_name => x_list_entries_rec.list_select_action_from_name,
p_source_code => x_list_entries_rec.source_code,
p_arc_list_used_by_source => x_list_entries_rec.arc_list_used_by_source,
p_source_code_for_id => x_list_entries_rec.source_code_for_id,
p_pin_code => x_list_entries_rec.pin_code,
p_list_entry_source_system_id => x_list_entries_rec.list_entry_source_system_id,
p_list_entry_source_system_tp => x_list_entries_rec.list_entry_source_system_type,
p_view_application_id => x_list_entries_rec.view_application_id,
p_manually_entered_flag => x_list_entries_rec.manually_entered_flag,
p_marked_as_duplicate_flag => x_list_entries_rec.marked_as_duplicate_flag,
p_marked_as_random_flag => x_list_entries_rec.marked_as_random_flag,
p_part_of_control_group_flag => x_list_entries_rec.part_of_control_group_flag,
p_exclude_in_triggered_list_fg => x_list_entries_rec.exclude_in_triggered_list_flag,
p_enabled_flag => x_list_entries_rec.enabled_flag,
p_cell_code => x_list_entries_rec.cell_code,
p_dedupe_key => x_list_entries_rec.dedupe_key,
p_randomly_generated_number => x_list_entries_rec.randomly_generated_number,
p_campaign_id => x_list_entries_rec.campaign_id,
p_media_id => x_list_entries_rec.media_id,
p_channel_id => x_list_entries_rec.channel_id,
p_channel_schedule_id => x_list_entries_rec.channel_schedule_id,
p_event_offer_id => x_list_entries_rec.event_offer_id,
p_customer_id => x_list_entries_rec.customer_id,
p_market_segment_id => x_list_entries_rec.market_segment_id,
p_vendor_id => x_list_entries_rec.vendor_id,
p_transfer_flag => x_list_entries_rec.transfer_flag,
p_transfer_status => x_list_entries_rec.transfer_status,
p_list_source => x_list_entries_rec.list_source,
p_duplicate_master_entry_id => x_list_entries_rec.duplicate_master_entry_id,
p_marked_flag => x_list_entries_rec.marked_flag,
p_lead_id => x_list_entries_rec.lead_id,
p_letter_id => x_list_entries_rec.letter_id,
p_picking_header_id => x_list_entries_rec.picking_header_id,
p_batch_id => x_list_entries_rec.batch_id,
p_suffix => x_list_entries_rec.suffix,
p_first_name => x_list_entries_rec.first_name,
p_last_name => x_list_entries_rec.last_name,
p_customer_name => x_list_entries_rec.customer_name,
p_title => x_list_entries_rec.title,
p_address_line1 => x_list_entries_rec.address_line1,
p_address_line2 => x_list_entries_rec.address_line2,
p_city => x_list_entries_rec.city,
p_state => x_list_entries_rec.state,
p_zipcode => x_list_entries_rec.zipcode,
p_country => x_list_entries_rec.country,
p_fax => x_list_entries_rec.fax,
p_phone => x_list_entries_rec.phone,
p_email_address => x_list_entries_rec.email_address,
p_col1 => x_list_entries_rec.col1,
p_col2 => x_list_entries_rec.col2,
p_col3 => x_list_entries_rec.col3,
p_col4 => x_list_entries_rec.col4,
p_col5 => x_list_entries_rec.col5,
p_col6 => x_list_entries_rec.col6,
p_col7 => x_list_entries_rec.col7,
p_col8 => x_list_entries_rec.col8,
p_col9 => x_list_entries_rec.col9,
p_col10 => x_list_entries_rec.col10,
p_col11 => x_list_entries_rec.col11,
p_col12 => x_list_entries_rec.col12,
p_col13 => x_list_entries_rec.col13,
p_col14 => x_list_entries_rec.col14,
p_col15 => x_list_entries_rec.col15,
p_col16 => x_list_entries_rec.col16,
p_col17 => x_list_entries_rec.col17,
p_col18 => x_list_entries_rec.col18,
p_col19 => x_list_entries_rec.col19,
p_col20 => x_list_entries_rec.col20,
p_col21 => x_list_entries_rec.col21,
p_col22 => x_list_entries_rec.col22,
p_col23 => x_list_entries_rec.col23,
p_col24 => x_list_entries_rec.col24,
p_col25 => x_list_entries_rec.col25,
p_col26 => x_list_entries_rec.col26,
p_col27 => x_list_entries_rec.col27,
p_col28 => x_list_entries_rec.col28,
p_col29 => x_list_entries_rec.col29,
p_col30 => x_list_entries_rec.col30,
p_col31 => x_list_entries_rec.col31,
p_col32 => x_list_entries_rec.col32,
p_col33 => x_list_entries_rec.col33,
p_col34 => x_list_entries_rec.col34,
p_col35 => x_list_entries_rec.col35,
p_col36 => x_list_entries_rec.col36,
p_col37 => x_list_entries_rec.col37,
p_col38 => x_list_entries_rec.col38,
p_col39 => x_list_entries_rec.col39,
p_col40 => x_list_entries_rec.col40,
p_col41 => x_list_entries_rec.col41,
p_col42 => x_list_entries_rec.col42,
p_col43 => x_list_entries_rec.col43,
p_col44 => x_list_entries_rec.col44,
p_col45 => x_list_entries_rec.col45,
p_col46 => x_list_entries_rec.col46,
p_col47 => x_list_entries_rec.col47,
p_col48 => x_list_entries_rec.col48,
p_col49 => x_list_entries_rec.col49,
p_col50 => x_list_entries_rec.col50,
p_col51 => x_list_entries_rec.col51,
p_col52 => x_list_entries_rec.col52,
p_col53 => x_list_entries_rec.col53,
p_col54 => x_list_entries_rec.col54,
p_col55 => x_list_entries_rec.col55,
p_col56 => x_list_entries_rec.col56,
p_col57 => x_list_entries_rec.col57,
p_col58 => x_list_entries_rec.col58,
p_col59 => x_list_entries_rec.col59,
p_col60 => x_list_entries_rec.col60,
p_col61 => x_list_entries_rec.col61,
p_col62 => x_list_entries_rec.col62,
p_col63 => x_list_entries_rec.col63,
p_col64 => x_list_entries_rec.col64,
p_col65 => x_list_entries_rec.col65,
p_col66 => x_list_entries_rec.col66,
p_col67 => x_list_entries_rec.col67,
p_col68 => x_list_entries_rec.col68,
p_col69 => x_list_entries_rec.col69,
p_col70 => x_list_entries_rec.col70,
p_col71 => x_list_entries_rec.col71,
p_col72 => x_list_entries_rec.col72,
p_col73 => x_list_entries_rec.col73,
p_col74 => x_list_entries_rec.col74,
p_col75 => x_list_entries_rec.col75,
p_col76 => x_list_entries_rec.col76,
p_col77 => x_list_entries_rec.col77,
p_col78 => x_list_entries_rec.col78,
p_col79 => x_list_entries_rec.col79,
p_col80 => x_list_entries_rec.col80,
p_col81 => x_list_entries_rec.col81,
p_col82 => x_list_entries_rec.col82,
p_col83 => x_list_entries_rec.col83,
p_col84 => x_list_entries_rec.col84,
p_col85 => x_list_entries_rec.col85,
p_col86 => x_list_entries_rec.col86,
p_col87 => x_list_entries_rec.col87,
p_col88 => x_list_entries_rec.col88,
p_col89 => x_list_entries_rec.col89,
p_col90 => x_list_entries_rec.col90,
p_col91 => x_list_entries_rec.col91,
p_col92 => x_list_entries_rec.col92,
p_col93 => x_list_entries_rec.col93,
p_col94 => x_list_entries_rec.col94,
p_col95 => x_list_entries_rec.col95,
p_col96 => x_list_entries_rec.col96,
p_col97 => x_list_entries_rec.col97,
p_col98 => x_list_entries_rec.col98,
p_col99 => x_list_entries_rec.col99,
p_col100 => x_list_entries_rec.col100,
p_col101 => x_list_entries_rec.col101,
p_col102 => x_list_entries_rec.col102,
p_col103 => x_list_entries_rec.col103,
p_col104 => x_list_entries_rec.col104,
p_col105 => x_list_entries_rec.col105,
p_col106 => x_list_entries_rec.col106,
p_col107 => x_list_entries_rec.col107,
p_col108 => x_list_entries_rec.col108,
p_col109 => x_list_entries_rec.col109,
p_col110 => x_list_entries_rec.col110,
p_col111 => x_list_entries_rec.col111,
p_col112 => x_list_entries_rec.col112,
p_col113 => x_list_entries_rec.col113,
p_col114 => x_list_entries_rec.col114,
p_col115 => x_list_entries_rec.col115,
p_col116 => x_list_entries_rec.col116,
p_col117 => x_list_entries_rec.col117,
p_col118 => x_list_entries_rec.col118,
p_col119 => x_list_entries_rec.col119,
p_col120 => x_list_entries_rec.col120,
p_col121 => x_list_entries_rec.col121,
p_col122 => x_list_entries_rec.col122,
p_col123 => x_list_entries_rec.col123,
p_col124 => x_list_entries_rec.col124,
p_col125 => x_list_entries_rec.col125,
p_col126 => x_list_entries_rec.col126,
p_col127 => x_list_entries_rec.col127,
p_col128 => x_list_entries_rec.col128,
p_col129 => x_list_entries_rec.col129,
p_col130 => x_list_entries_rec.col130,
p_col131 => x_list_entries_rec.col131,
p_col132 => x_list_entries_rec.col132,
p_col133 => x_list_entries_rec.col133,
p_col134 => x_list_entries_rec.col134,
p_col135 => x_list_entries_rec.col135,
p_col136 => x_list_entries_rec.col136,
p_col137 => x_list_entries_rec.col137,
p_col138 => x_list_entries_rec.col138,
p_col139 => x_list_entries_rec.col139,
p_col140 => x_list_entries_rec.col140,
p_col141 => x_list_entries_rec.col141,
p_col142 => x_list_entries_rec.col142,
p_col143 => x_list_entries_rec.col143,
p_col144 => x_list_entries_rec.col144,
p_col145 => x_list_entries_rec.col145,
p_col146 => x_list_entries_rec.col146,
p_col147 => x_list_entries_rec.col147,
p_col148 => x_list_entries_rec.col148,
p_col149 => x_list_entries_rec.col149,
p_col150 => x_list_entries_rec.col150,
p_col151 => x_list_entries_rec.col151,
p_col152 => x_list_entries_rec.col152,
p_col153 => x_list_entries_rec.col153,
p_col154 => x_list_entries_rec.col154,
p_col155 => x_list_entries_rec.col155,
p_col156 => x_list_entries_rec.col156,
p_col157 => x_list_entries_rec.col157,
p_col158 => x_list_entries_rec.col158,
p_col159 => x_list_entries_rec.col159,
p_col160 => x_list_entries_rec.col160,
p_col161 => x_list_entries_rec.col161,
p_col162 => x_list_entries_rec.col162,
p_col163 => x_list_entries_rec.col163,
p_col164 => x_list_entries_rec.col164,
p_col165 => x_list_entries_rec.col165,
p_col166 => x_list_entries_rec.col166,
p_col167 => x_list_entries_rec.col167,
p_col168 => x_list_entries_rec.col168,
p_col169 => x_list_entries_rec.col169,
p_col170 => x_list_entries_rec.col170,
p_col171 => x_list_entries_rec.col171,
p_col172 => x_list_entries_rec.col172,
p_col173 => x_list_entries_rec.col173,
p_col174 => x_list_entries_rec.col174,
p_col175 => x_list_entries_rec.col175,
p_col176 => x_list_entries_rec.col176,
p_col177 => x_list_entries_rec.col177,
p_col178 => x_list_entries_rec.col178,
p_col179 => x_list_entries_rec.col179,
p_col180 => x_list_entries_rec.col180,
p_col181 => x_list_entries_rec.col181,
p_col182 => x_list_entries_rec.col182,
p_col183 => x_list_entries_rec.col183,
p_col184 => x_list_entries_rec.col184,
p_col185 => x_list_entries_rec.col185,
p_col186 => x_list_entries_rec.col186,
p_col187 => x_list_entries_rec.col187,
p_col188 => x_list_entries_rec.col188,
p_col189 => x_list_entries_rec.col189,
p_col190 => x_list_entries_rec.col190,
p_col191 => x_list_entries_rec.col191,
p_col192 => x_list_entries_rec.col192,
p_col193 => x_list_entries_rec.col193,
p_col194 => x_list_entries_rec.col194,
p_col195 => x_list_entries_rec.col195,
p_col196 => x_list_entries_rec.col196,
p_col197 => x_list_entries_rec.col197,
p_col198 => x_list_entries_rec.col198,
p_col199 => x_list_entries_rec.col199,
p_col200 => x_list_entries_rec.col200,
p_col201 => p_list_entries_rec.col201,
p_col202 => p_list_entries_rec.col202,
p_col203 => p_list_entries_rec.col203,
p_col204 => p_list_entries_rec.col204,
p_col205 => p_list_entries_rec.col205,
p_col206 => p_list_entries_rec.col206,
p_col207 => p_list_entries_rec.col207,
p_col208 => p_list_entries_rec.col208,
p_col209 => p_list_entries_rec.col209,
p_col210 => p_list_entries_rec.col210,
p_col211 => p_list_entries_rec.col211,
p_col212 => p_list_entries_rec.col212,
p_col213 => p_list_entries_rec.col213,
p_col214 => p_list_entries_rec.col214,
p_col215 => p_list_entries_rec.col215,
p_col216 => p_list_entries_rec.col216,
p_col217 => p_list_entries_rec.col217,
p_col218 => p_list_entries_rec.col218,
p_col219 => p_list_entries_rec.col219,
p_col220 => p_list_entries_rec.col220,
p_col221 => p_list_entries_rec.col221,
p_col222 => p_list_entries_rec.col222,
p_col223 => p_list_entries_rec.col223,
p_col224 => p_list_entries_rec.col224,
p_col225 => p_list_entries_rec.col225,
p_col226 => p_list_entries_rec.col226,
p_col227 => p_list_entries_rec.col227,
p_col228 => p_list_entries_rec.col228,
p_col229 => p_list_entries_rec.col229,
p_col230 => p_list_entries_rec.col230,
p_col231 => p_list_entries_rec.col231,
p_col232 => p_list_entries_rec.col232,
p_col233 => p_list_entries_rec.col233,
p_col234 => p_list_entries_rec.col234,
p_col235 => p_list_entries_rec.col235,
p_col236 => p_list_entries_rec.col236,
p_col237 => p_list_entries_rec.col237,
p_col238 => p_list_entries_rec.col238,
p_col239 => p_list_entries_rec.col239,
p_col240 => p_list_entries_rec.col240,
p_col241 => p_list_entries_rec.col241,
p_col242 => p_list_entries_rec.col242,
p_col243 => p_list_entries_rec.col243,
p_col244 => p_list_entries_rec.col244,
p_col245 => p_list_entries_rec.col245,
p_col246 => p_list_entries_rec.col246,
p_col247 => p_list_entries_rec.col247,
p_col248 => p_list_entries_rec.col248,
p_col249 => p_list_entries_rec.col249,
p_col250 => p_list_entries_rec.col250,
p_col251 => p_list_entries_rec.col251,
p_col252 => p_list_entries_rec.col252,
p_col253 => p_list_entries_rec.col253,
p_col254 => p_list_entries_rec.col254,
p_col255 => p_list_entries_rec.col255,
p_col256 => p_list_entries_rec.col256,
p_col257 => p_list_entries_rec.col257,
p_col258 => p_list_entries_rec.col258,
p_col259 => p_list_entries_rec.col259,
p_col260 => p_list_entries_rec.col260,
p_col261 => p_list_entries_rec.col261,
p_col262 => p_list_entries_rec.col262,
p_col263 => p_list_entries_rec.col263,
p_col264 => p_list_entries_rec.col264,
p_col265 => p_list_entries_rec.col265,
p_col266 => p_list_entries_rec.col266,
p_col267 => p_list_entries_rec.col267,
p_col268 => p_list_entries_rec.col268,
p_col269 => p_list_entries_rec.col269,
p_col270 => p_list_entries_rec.col270,
p_col271 => p_list_entries_rec.col271,
p_col272 => p_list_entries_rec.col272,
p_col273 => p_list_entries_rec.col273,
p_col274 => p_list_entries_rec.col274,
p_col275 => p_list_entries_rec.col275,
p_col276 => p_list_entries_rec.col276,
p_col277 => p_list_entries_rec.col277,
p_col278 => p_list_entries_rec.col278,
p_col279 => p_list_entries_rec.col279,
p_col280 => p_list_entries_rec.col280,
p_col281 => p_list_entries_rec.col281,
p_col282 => p_list_entries_rec.col282,
p_col283 => p_list_entries_rec.col283,
p_col284 => p_list_entries_rec.col284,
p_col285 => p_list_entries_rec.col285,
p_col286 => p_list_entries_rec.col286,
p_col287 => p_list_entries_rec.col287,
p_col288 => p_list_entries_rec.col288,
p_col289 => p_list_entries_rec.col289,
p_col290 => p_list_entries_rec.col290,
p_col291 => p_list_entries_rec.col291,
p_col292 => p_list_entries_rec.col292,
p_col293 => p_list_entries_rec.col293,
p_col294 => p_list_entries_rec.col294,
p_col295 => p_list_entries_rec.col295,
p_col296 => p_list_entries_rec.col296,
p_col297 => p_list_entries_rec.col297,
p_col298 => p_list_entries_rec.col298,
p_col299 => p_list_entries_rec.col299,
p_col300 => p_list_entries_rec.col300,
p_party_id => x_list_entries_rec.party_id,
p_parent_party_id => x_list_entries_rec.parent_party_id,
--p_geometry => x_list_entries_rec.geometry,
p_imp_source_line_id => x_list_entries_rec.imp_source_line_id,
p_usage_restriction => x_list_entries_rec.usage_restriction,
p_next_call_time => x_list_entries_rec.next_call_time,
p_callback_flag => x_list_entries_rec.callback_flag,
p_do_not_use_flag => x_list_entries_rec.do_not_use_flag,
p_do_not_use_reason => x_list_entries_rec.do_not_use_reason,
p_record_out_flag => x_list_entries_rec.record_out_flag,
p_record_release_time => x_list_entries_rec.record_release_time,
p_group_code => p_list_entries_rec.group_code,
p_newly_updated_flag => p_list_entries_rec.newly_updated_flag,
p_outcome_id => p_list_entries_rec.outcome_id,
p_result_id => p_list_entries_rec.result_id ,
p_reason_id => p_list_entries_rec.reason_id,
p_notes => p_list_entries_rec.notes ,
p_VEHICLE_RESPONSE_CODE => p_list_entries_rec.VEHICLE_RESPONSE_CODE ,
p_SALES_AGENT_EMAIL_ADDRESS => p_list_entries_rec.SALES_AGENT_EMAIL_ADDRESS ,
p_RESOURCE_ID => p_list_entries_rec.RESOURCE_ID ,
p_LOCATION_ID => p_list_entries_rec.location_id,
p_CONTACT_POINT_ID => p_list_entries_rec.contact_point_id,
p_last_contacted_date => p_list_entries_rec.last_contacted_date
);
ROLLBACK TO UPDATE_List_Entries_PVT;
ROLLBACK TO UPDATE_List_Entries_PVT;
ROLLBACK TO UPDATE_List_Entries_PVT;
End Update_List_Entries;
PROCEDURE Delete_List_Entries(
p_api_version_number 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_list_entry_id IN NUMBER,
p_object_version_number IN NUMBER
)
IS
L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_List_Entries';
SAVEPOINT DELETE_List_Entries_PVT;
AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
AMS_LIST_ENTRIES_PKG.Delete_Row(
p_LIST_ENTRY_ID => p_LIST_ENTRY_ID);
ROLLBACK TO DELETE_List_Entries_PVT;
ROLLBACK TO DELETE_List_Entries_PVT;
ROLLBACK TO DELETE_List_Entries_PVT;
End Delete_List_Entries;
SELECT LIST_ENTRY_ID
FROM AMS_LIST_ENTRIES
WHERE LIST_ENTRY_ID = p_LIST_ENTRY_ID
AND object_version_number = p_object_version
FOR UPDATE NOWAIT;
IF p_list_entries_rec.list_select_action_id = FND_API.g_miss_num OR p_list_entries_rec.list_select_action_id IS NULL THEN
AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_select_action_id');
IF p_list_entries_rec.arc_list_select_action_from = FND_API.g_miss_char OR p_list_entries_rec.arc_list_select_action_from IS NULL THEN
AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'arc_list_select_action_from');
IF p_list_entries_rec.list_select_action_from_name = FND_API.g_miss_char OR p_list_entries_rec.list_select_action_from_name IS NULL THEN
AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_select_action_from_name');
IF p_list_entries_rec.last_update_date IS NULL THEN
AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'last_update_date');
IF p_list_entries_rec.last_updated_by IS NULL THEN
AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'last_updated_by');
IF p_list_entries_rec.list_select_action_id IS NULL THEN
AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_select_action_id');
IF p_list_entries_rec.arc_list_select_action_from IS NULL THEN
AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'arc_list_select_action_from');
IF p_list_entries_rec.list_select_action_from_name IS NULL THEN
AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_select_action_from_name');
select 'x'
from jtf_ih_outcomes_vl
where outcome_id = cur_outcome_id ;
select 'x'
from jtf_ih_outcome_results
where outcome_id = cur_outcome_id
and result_id = cur_result_id;
select 'x'
from jtf_ih_result_reasons
where reason_id = cur_reason_id
and result_id = cur_result_id;
IF ( p_list_entries_rec.newly_updated_flag = 'Y' OR
p_list_entries_rec.newly_updated_flag = 'N' OR
p_list_entries_rec.newly_updated_flag is NULL OR
p_list_entries_rec.newly_updated_flag = fnd_api.g_miss_char
)
THEN
null;
AMS_Utility_PVT.Error_Message('AMS_API_INVALID_FLAG','INVALID_FLAG','newly_updated_flag');
p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_update,
p_list_entries_rec IN list_entries_rec_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
)
IS
L_API_NAME CONSTANT VARCHAR2(30) := 'Validate_List_Entries';
x_entry_rec.LAST_UPDATE_DATE := FND_API.g_miss_date;
x_entry_rec.LAST_UPDATED_BY := FND_API.g_miss_num;
x_entry_rec.LAST_UPDATE_LOGIN := FND_API.g_miss_num;
x_entry_rec.LIST_SELECT_ACTION_ID := FND_API.g_miss_num;
x_entry_rec.ARC_LIST_SELECT_ACTION_FROM := FND_API.g_miss_char;
x_entry_rec.LIST_SELECT_ACTION_FROM_NAME := FND_API.g_miss_char;
x_entry_rec.NEWLY_UPDATED_FLAG := FND_API.g_miss_char;
INSERT INTO AMS_lIST_ENTRIES(list_entry_id ,
list_header_id ,
last_update_date ,
last_updated_by ,
creation_date ,
created_by ,
last_update_login ,
object_version_number ,
list_select_action_id ,
arc_list_select_action_from ,
list_select_action_from_name ,
source_code ,
arc_list_used_by_source ,
source_code_for_id ,
pin_code ,
list_entry_source_system_id ,
list_entry_source_system_type ,
view_application_id ,
manually_entered_flag ,
marked_as_duplicate_flag ,
marked_as_random_flag ,
part_of_control_group_flag ,
exclude_in_triggered_list_flag ,
enabled_flag ,
cell_code ,
dedupe_key ,
randomly_generated_number ,
campaign_id ,
media_id ,
channel_id ,
channel_schedule_id ,
event_offer_id ,
customer_id ,
market_segment_id ,
vendor_id ,
transfer_flag ,
transfer_status ,
list_source ,
duplicate_master_entry_id ,
marked_flag ,
lead_id ,
letter_id ,
picking_header_id ,
batch_id ,
suffix ,
first_name ,
last_name ,
customer_name ,
title ,
address_line1 ,
address_line2 ,
city ,
state ,
zipcode ,
country ,
fax ,
phone ,
email_address ,
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 ,
col251 ,
col252 ,
col253 ,
col254 ,
col255 ,
col256 ,
col257 ,
col258 ,
col259 ,
col260 ,
col261 ,
col262 ,
col263 ,
col264 ,
col265 ,
col266 ,
col267 ,
col268 ,
col269 ,
col270 ,
col271 ,
col272 ,
col273 ,
col274 ,
col275 ,
col276 ,
col277 ,
col278 ,
col279 ,
col280 ,
col281 ,
col282 ,
col283 ,
col284 ,
col285 ,
col286 ,
col287 ,
col288 ,
col289 ,
col290 ,
col291 ,
col292 ,
col293 ,
col294 ,
col295 ,
col296 ,
col297 ,
col298 ,
col299 ,
col300 ,
party_id ,
parent_party_id ,
-- geometry ,
imp_source_line_id ,
group_code ,
newly_updated_flag ,
outcome_id ,
result_id ,
reason_id
)
select ams_list_entries_s.nextval ,
p_new_list_header_id ,
SYSDATE ,
FND_GLOBAL.user_id ,
SYSDATE ,
FND_GLOBAL.user_id ,
FND_GLOBAL.conc_login_id ,
1 ,
0 ,--put select action id as 0 for now
arc_list_select_action_from ,
list_select_action_from_name ,
'NONE' ,
'NONE' ,
0 ,
ams_list_entries_s.currval ,
list_entry_source_system_id ,
list_entry_source_system_type ,
view_application_id ,
manually_entered_flag ,
marked_as_duplicate_flag ,
marked_as_random_flag ,
part_of_control_group_flag ,
exclude_in_triggered_list_flag ,
enabled_flag ,
cell_code ,
dedupe_key ,
randomly_generated_number ,
campaign_id ,
media_id ,
channel_id ,
channel_schedule_id ,
event_offer_id ,
customer_id ,
market_segment_id ,
vendor_id ,
transfer_flag ,
transfer_status ,
list_source ,
duplicate_master_entry_id ,
marked_flag ,
lead_id ,
letter_id ,
picking_header_id ,
batch_id ,
suffix ,
first_name ,
last_name ,
customer_name ,
title ,
address_line1 ,
address_line2 ,
city ,
state ,
zipcode ,
country ,
fax ,
phone ,
email_address ,
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 ,
col251 ,
col252 ,
col253 ,
col254 ,
col255 ,
col256 ,
col257 ,
col258 ,
col259 ,
col260 ,
col261 ,
col262 ,
col263 ,
col264 ,
col265 ,
col266 ,
col267 ,
col268 ,
col269 ,
col270 ,
col271 ,
col272 ,
col273 ,
col274 ,
col275 ,
col276 ,
col277 ,
col278 ,
col279 ,
col280 ,
col281 ,
col282 ,
col283 ,
col284 ,
col285 ,
col286 ,
col287 ,
col288 ,
col289 ,
col290 ,
col291 ,
col292 ,
col293 ,
col294 ,
col295 ,
col296 ,
col297 ,
col298 ,
col299 ,
col300 ,
party_id ,
parent_party_id ,
-- geometry ,
imp_source_line_id ,
group_code ,
newly_updated_flag ,
outcome_id ,
result_id ,
reason_id
FROM ams_list_entries
WHERE list_header_id = p_list_header_id ;