[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_campaign_schedules(
x_errbuf OUT NOCOPY VARCHAR2,
x_retcode OUT NOCOPY NUMBER,
p_upload_batch_id IN NUMBER,
p_ui_instance_id IN NUMBER := 0
)
IS
PRAGMA AUTONOMOUS_TRANSACTION;
L_API_NAME CONSTANT VARCHAR2(30) := 'update_campaign_schedules';
select a.object_id,a.object_name,a.parent_object_id,a.source_code,a.start_date,a.end_date,a.start_time,a.end_time,
a.marketing_medium_id,a.country_id,a.owner_user_id,a.timezone_id,a.objective,a.approval_action_code,a.user_status_id,a.status_code,
a.attribute1,a.attribute2,a.attribute3,a.attribute4,a.attribute5,a.attribute6,a.attribute7,a.attribute8,
a.attribute9,a.attribute10,a.attribute11,a.attribute12,a.attribute13,a.attribute14,a.attribute15,
a.activity_attribute1,a.activity_attribute2,a.activity_attribute3,a.activity_attribute4,a.activity_attribute5,
a.activity_attribute6,a.activity_attribute7,a.activity_attribute8,a.activity_attribute9,a.activity_attribute10,
a.activity_attribute11,a.activity_attribute12,a.activity_attribute13,a.activity_attribute14,a.activity_attribute15,
a.activity_attribute_category,a.object_version_number,a.currency_code,a.actual_activity_id,b.media_type_code
from ams_adi_campaigns_interface a, ams_media_b b
where a.upload_batch_id = l_upload_batch_id
and a.actual_activity_id = b.media_id(+)
and b.enabled_flag(+) = 'Y';
select user_status_id into l_avail_default_user_status
from ams_user_statuses_vl
where system_status_type = 'AMS_CAMPAIGN_SCHEDULE_STATUS'
and system_status_code = 'AVAILABLE'
and default_flag = 'Y';
AMS_UTILITY_PVT.debug_message('Calling AMS_Camp_Schedule_PUB.Update_Camp_Schedule');
AMS_Camp_Schedule_PUB.Update_Camp_Schedule(
1.0,
FND_API.G_FALSE,
FND_API.G_FALSE,
FND_API.g_valid_level_full,
l_return_status,
l_msg_count,
l_msg_data,
l_schedule_rec,
l_object_version_number
);
AMS_UTILITY_PVT.debug_message('Return Status from Update_Camp_Schedule '||l_return_status);
AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name || ' Schedule Update before Approval was successful '||TO_CHAR(l_objectIds(i)));
AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name || ' Now calling AMS_ScheduleRules_PVT.Update_Schedule_Status');
AMS_ScheduleRules_PVT.Update_Schedule_Status( p_schedule_id => l_objectIds(i),
p_campaign_id => l_parentIds(i),
p_user_status_id => AMS_UTILITY_PVT.get_default_user_status
(p_status_type => 'AMS_CAMPAIGN_SCHEDULE_STATUS',
p_status_code => 'AVAILABLE'),
p_budget_amount => null
);
' Return Status from AMS_ScheduleRules_PVT.Update_Schedule_Status API '||l_return_status);
END update_campaign_schedules;
SELECT
object_name, source_code, parent_object_id, start_date, end_date,
start_time, end_time, template_id, actual_activity_id, marketing_medium_id,
purpose, country_id, owner_user_id, timezone_id, currency_code,
objective, approval_action_code, rep_sched_freq_code, rep_sched_frequency, rep_sched_tg_exclude_flag,
product_id1, product_id2, product_category_id1, product_category_id2, cover_letter_id,
collab_citem_id1, collab_citem_id2, collab_citem_id3, collab_script_id,
notes, pretty_url_website, additional_url_param,
wp_application_id, wp_placement_id, wp_placement_title, wp_citem_id,
ctd_action, ctd_param1, ctd_param2, ctd_param3, ctd_param4, ctd_url_text,
ctd_adhoc_param1, ctd_adhoc_param_val1, ctd_adhoc_param2, ctd_adhoc_param_val2, ctd_adhoc_param3,
ctd_adhoc_param_val3, ctd_adhoc_param4, ctd_adhoc_param_val4, ctd_adhoc_param5, ctd_adhoc_param_val5,
attribute_category, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8,
attribute9, attribute10, attribute11, attribute12, attribute13, attribute14, attribute15,
activity_attribute1, activity_attribute2, activity_attribute3, activity_attribute4, activity_attribute5,
activity_attribute6, activity_attribute7, activity_attribute8, activity_attribute9, activity_attribute10,
activity_attribute11, activity_attribute12, activity_attribute13, activity_attribute14, activity_attribute15
--last_update_date, last_updated_by, creation_date, created_by, last_update_login
FROM
AMS_ADI_CAMPAIGNS_INTERFACE
where
upload_batch_id = l_upload_batch_id and
operation_status = 'NEW' and
operation_type = 'IMPORT' and
object_type = 'CSCH' and
parent_object_type = 'CAMP';
select
1
from
IBC_CONTENT_ITEMS
where
content_item_id = p_covlett_id;
SELECT
1 into l_temp_num
FROM
AMS_ADI_CAMPAIGNS_INTERFACE
WHERE
upload_batch_id = p_upload_batch_id and
operation_status = 'NEW' and
operation_type = 'IMPORT' and
object_type = 'CSCH' and
parent_object_type = 'CAMP' and
parent_object_id = l_campIds(i) and
object_name = l_objectNames(i);
l_schedule_rec.last_update_date := sysdate;
l_schedule_rec.last_updated_by := FND_GLOBAL.USER_ID;
l_schedule_rec.last_update_login := FND_GLOBAL.USER_ID;
AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now calling IBC_CITEM_ADMIN_GRP.insert_associations API');
IBC_CITEM_ADMIN_GRP.insert_associations(
p_content_item_id => l_covLettIds(i)
,p_assoc_type_codes => l_assoc_type_codes
,p_assoc_objects1 => l_assoc_objects1
,p_commit => FND_API.g_false
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
);
p_last_updated_by => FND_GLOBAL.USER_ID,
x_jtf_note_id => l_note_id ,
p_note_type => '', -- fnd_lookup JTF_NOTE_TYPE
p_last_update_date => sysdate ,
p_creation_date => sysdate ) ;
' Now calling AMS_ScheduleRules_PVT.Update_Schedule_Status');
AMS_ScheduleRules_PVT.Update_Schedule_Status(
p_schedule_id => l_schedule_id,
p_campaign_id => l_campIds(i),
p_user_status_id => AMS_UTILITY_PVT.get_default_user_status
(p_status_type => 'AMS_CAMPAIGN_SCHEDULE_STATUS',
p_status_code => 'AVAILABLE'),
p_budget_amount => null
);
' Return Status from AMS_ScheduleRules_PVT.Update_Schedule_Status API '||l_return_status);
SELECT MEDIA_TYPE_CODE
FROM AMS_MEDIA_B
WHERE media_id = p_activity_id;
SELECT
source_code
FROM
ams_source_codes
WHERE
ARC_SOURCE_CODE_FOR = p_object_type and
SOURCE_CODE_FOR_ID = p_object_id and
active_flag = 'Y';