DBA Data[Home] [Help]

APPS.AMS_ACTIVATE_EVENTSCHED_PVT dependencies on AMS_EVENTOFFER_PVT

Line 112: l_evo_rec AMS_EVENTOFFER_PVT.evo_rec_type;

108:
109: l_api_version CONSTANT NUMBER := 1.0 ;
110: l_api_name CONSTANT VARCHAR2(30) := 'Activate_Event_Schedule';
111:
112: l_evo_rec AMS_EVENTOFFER_PVT.evo_rec_type;
113: l_evo_rec_oneoff AMS_EVENTOFFER_PVT.evo_rec_type;
114: l_evo_rec_eveo AMS_EVENTOFFER_PVT.evo_rec_type;
115:
116: BEGIN

Line 113: l_evo_rec_oneoff AMS_EVENTOFFER_PVT.evo_rec_type;

109: l_api_version CONSTANT NUMBER := 1.0 ;
110: l_api_name CONSTANT VARCHAR2(30) := 'Activate_Event_Schedule';
111:
112: l_evo_rec AMS_EVENTOFFER_PVT.evo_rec_type;
113: l_evo_rec_oneoff AMS_EVENTOFFER_PVT.evo_rec_type;
114: l_evo_rec_eveo AMS_EVENTOFFER_PVT.evo_rec_type;
115:
116: BEGIN
117: --

Line 114: l_evo_rec_eveo AMS_EVENTOFFER_PVT.evo_rec_type;

110: l_api_name CONSTANT VARCHAR2(30) := 'Activate_Event_Schedule';
111:
112: l_evo_rec AMS_EVENTOFFER_PVT.evo_rec_type;
113: l_evo_rec_oneoff AMS_EVENTOFFER_PVT.evo_rec_type;
114: l_evo_rec_eveo AMS_EVENTOFFER_PVT.evo_rec_type;
115:
116: BEGIN
117: --
118: -- Standard Start of API savepoint

Line 200: AMS_EVENTOFFER_PVT.init_evo_rec(l_evo_rec_eveo);

196: END IF;
197:
198: IF l_parent_system_status_code = 'ACTIVE' THEN*/
199:
200: AMS_EVENTOFFER_PVT.init_evo_rec(l_evo_rec_eveo);
201: l_evo_rec_eveo.event_offer_id := l_schedule_id;
202: l_evo_rec_eveo.object_version_number := l_obj_version;
203: l_evo_rec_eveo.system_status_code := 'ACTIVE';
204: l_evo_rec_eveo.last_status_date := SYSDATE;

Line 208: AMS_EventOffer_PVT.update_event_offer (

204: l_evo_rec_eveo.last_status_date := SYSDATE;
205: l_evo_rec_eveo.user_status_id := l_status_id;
206: l_evo_rec_eveo.event_level := l_event_level;
207:
208: AMS_EventOffer_PVT.update_event_offer (
209: p_api_version => 1.0,
210: p_init_msg_list => FND_API.G_FALSE,
211: p_commit => FND_API.G_FALSE,
212: p_validation_level => FND_API.g_valid_level_full,

Line 277: AMS_EVENTOFFER_PVT.init_evo_rec(l_evo_rec_oneoff);

273: user_status_id = l_status_id,
274: object_version_number = l_obj_version + 1
275: WHERE event_offer_id = l_schedule_id ;*/
276:
277: AMS_EVENTOFFER_PVT.init_evo_rec(l_evo_rec_oneoff);
278: l_evo_rec_oneoff.event_offer_id := l_schedule_id;
279: l_evo_rec_oneoff.object_version_number := l_obj_version;
280: l_evo_rec_oneoff.system_status_code := 'ACTIVE';
281: l_evo_rec_oneoff.last_status_date := SYSDATE;

Line 287: AMS_EventOffer_PVT.update_event_offer (

283: --batoleti changed the foll stmt.. Ref bug# 4404567.
284: --l_evo_rec_oneoff.user_status_id := l_event_level;
285: l_evo_rec_oneoff.event_level := l_event_level;
286:
287: AMS_EventOffer_PVT.update_event_offer (
288: p_api_version => 1.0,
289: p_init_msg_list => FND_API.G_FALSE,
290: p_commit => FND_API.G_FALSE,
291: p_validation_level => FND_API.g_valid_level_full,

Line 368: AMS_EVENTOFFER_PVT.init_evo_rec( l_evo_rec);

364: -- EXIT WHEN c_completed_schedule%NOTFOUND ;
365: FETCH c_completed_schedule_convdate INTO l_schedule_id, l_obj_version,l_event_level ;
366: EXIT WHEN c_completed_schedule_convdate%NOTFOUND ;
367:
368: AMS_EVENTOFFER_PVT.init_evo_rec( l_evo_rec);
369: l_evo_rec.event_offer_id := l_schedule_id;
370: l_evo_rec.object_version_number := l_obj_version ;
371: l_evo_rec.system_status_code := 'COMPLETED';
372: l_evo_rec.last_status_date := SYSDATE;

Line 376: AMS_EventOffer_PVT.update_event_offer (

372: l_evo_rec.last_status_date := SYSDATE;
373: l_evo_rec.user_status_id := l_status_id;
374: l_evo_rec.event_level := l_event_level;
375:
376: AMS_EventOffer_PVT.update_event_offer (
377: p_api_version => 1.0,
378: p_init_msg_list => FND_API.G_FALSE,
379: p_commit => FND_API.G_FALSE,
380: p_validation_level => FND_API.g_valid_level_full,