DBA Data[Home] [Help]

APPS.AMS_EVENTSCHEDULE_COPY_PVT dependencies on AMS_EVENTOFFER_PVT

Line 226: l_agenda_rec AMS_EventOffer_PVT.evo_rec_type;

222: l_return_status VARCHAR2 (1);
223: x_msg_count NUMBER;
224: l_msg_data VARCHAR2 (512);
225: l_act_agenda_id NUMBER;
226: l_agenda_rec AMS_EventOffer_PVT.evo_rec_type;
227: temp_agenda_rec AMS_EventOffer_PVT.evo_rec_type;
228: l_lookup_meaning VARCHAR2 (80);
229: CURSOR agenda_cur IS
230: select

Line 227: temp_agenda_rec AMS_EventOffer_PVT.evo_rec_type;

223: x_msg_count NUMBER;
224: l_msg_data VARCHAR2 (512);
225: l_act_agenda_id NUMBER;
226: l_agenda_rec AMS_EventOffer_PVT.evo_rec_type;
227: temp_agenda_rec AMS_EventOffer_PVT.evo_rec_type;
228: l_lookup_meaning VARCHAR2 (80);
229: CURSOR agenda_cur IS
230: select
231: EVENT_OFFER_ID

Line 425: AMS_EventOffer_PVT.create_event_offer (

421: l_agenda_rec.owner_user_id:=agenda_rec.owner_user_id;
422: l_agenda_rec.event_level:='SUB';
423: l_agenda_rec.user_status_id:=agenda_rec.user_status_id;
424:
425: AMS_EventOffer_PVT.create_event_offer (
426: p_api_version => 1.0,
427: p_init_msg_list => FND_API.G_FALSE,
428: p_commit => FND_API.G_FALSE,
429: p_validation_level => FND_API.g_valid_level_full,

Line 855: p_event_offer_rec AMS_EVENTOFFER_PVT.evo_rec_type;

851: l_org_id NUMBER := FND_API.G_MISS_NUM;
852: l_event_offer_id NUMBER :=p_source_object_id;
853: l_new_event_offer_id NUMBER;
854: l_dummy NUMBER;
855: p_event_offer_rec AMS_EVENTOFFER_PVT.evo_rec_type;
856: l_evo_rec AMS_EVENTOFFER_PVT.evo_rec_type;
857: l_reference_rec AMS_EventOffer_PVT.evo_rec_type;
858: l_event_offer_rec AMS_EventOffer_PVT.evo_rec_type;
859: l_new_reference_rec AMS_EventOffer_PVT.evo_rec_type;

Line 856: l_evo_rec AMS_EVENTOFFER_PVT.evo_rec_type;

852: l_event_offer_id NUMBER :=p_source_object_id;
853: l_new_event_offer_id NUMBER;
854: l_dummy NUMBER;
855: p_event_offer_rec AMS_EVENTOFFER_PVT.evo_rec_type;
856: l_evo_rec AMS_EVENTOFFER_PVT.evo_rec_type;
857: l_reference_rec AMS_EventOffer_PVT.evo_rec_type;
858: l_event_offer_rec AMS_EventOffer_PVT.evo_rec_type;
859: l_new_reference_rec AMS_EventOffer_PVT.evo_rec_type;
860: l_return_status VARCHAR2(1);

Line 857: l_reference_rec AMS_EventOffer_PVT.evo_rec_type;

853: l_new_event_offer_id NUMBER;
854: l_dummy NUMBER;
855: p_event_offer_rec AMS_EVENTOFFER_PVT.evo_rec_type;
856: l_evo_rec AMS_EVENTOFFER_PVT.evo_rec_type;
857: l_reference_rec AMS_EventOffer_PVT.evo_rec_type;
858: l_event_offer_rec AMS_EventOffer_PVT.evo_rec_type;
859: l_new_reference_rec AMS_EventOffer_PVT.evo_rec_type;
860: l_return_status VARCHAR2(1);
861: l_errnum NUMBER;

Line 858: l_event_offer_rec AMS_EventOffer_PVT.evo_rec_type;

854: l_dummy NUMBER;
855: p_event_offer_rec AMS_EVENTOFFER_PVT.evo_rec_type;
856: l_evo_rec AMS_EVENTOFFER_PVT.evo_rec_type;
857: l_reference_rec AMS_EventOffer_PVT.evo_rec_type;
858: l_event_offer_rec AMS_EventOffer_PVT.evo_rec_type;
859: l_new_reference_rec AMS_EventOffer_PVT.evo_rec_type;
860: l_return_status VARCHAR2(1);
861: l_errnum NUMBER;
862: l_errcode VARCHAR2(30);

Line 859: l_new_reference_rec AMS_EventOffer_PVT.evo_rec_type;

855: p_event_offer_rec AMS_EVENTOFFER_PVT.evo_rec_type;
856: l_evo_rec AMS_EVENTOFFER_PVT.evo_rec_type;
857: l_reference_rec AMS_EventOffer_PVT.evo_rec_type;
858: l_event_offer_rec AMS_EventOffer_PVT.evo_rec_type;
859: l_new_reference_rec AMS_EventOffer_PVT.evo_rec_type;
860: l_return_status VARCHAR2(1);
861: l_errnum NUMBER;
862: l_errcode VARCHAR2(30);
863: l_errmsg VARCHAR2(4000);

Line 949: AMS_EVENTOFFER_PVT.init_evo_rec(p_event_offer_rec);

945:
946: -- ----------------------------
947: -- fetch source object details
948: -- ----------------------------
949: AMS_EVENTOFFER_PVT.init_evo_rec(p_event_offer_rec);
950: p_event_offer_rec.event_offer_id:=p_source_object_id;
951: p_event_offer_rec.EVENT_DELIVERY_METHOD_CODE :=NULL;
952: AMS_EVENTOFFER_PVT.complete_evo_rec(p_event_offer_rec,l_evo_rec);
953: l_event_object_type:=l_evo_rec.event_object_type;

Line 952: AMS_EVENTOFFER_PVT.complete_evo_rec(p_event_offer_rec,l_evo_rec);

948: -- ----------------------------
949: AMS_EVENTOFFER_PVT.init_evo_rec(p_event_offer_rec);
950: p_event_offer_rec.event_offer_id:=p_source_object_id;
951: p_event_offer_rec.EVENT_DELIVERY_METHOD_CODE :=NULL;
952: AMS_EVENTOFFER_PVT.complete_evo_rec(p_event_offer_rec,l_evo_rec);
953: l_event_object_type:=l_evo_rec.event_object_type;
954: l_reference_rec:=l_evo_rec;
955: l_event_offer_rec:=l_evo_rec;
956: l_event_offer_rec.event_offer_id := null;

Line 1061: AMS_EventOffer_PVT.create_event_offer (

1057: END IF;
1058:
1059: l_event_offer_rec.object_version_number := 2;
1060: -- DBMS_OUTPUT.put_line('calling create with ');
1061: AMS_EventOffer_PVT.create_event_offer (
1062: p_api_version => 1.0,
1063: p_init_msg_list => FND_API.G_FALSE,
1064: p_commit => FND_API.G_FALSE,
1065: p_validation_level => FND_API.g_valid_level_full,

Line 1227: AMS_EVENTOFFER_PVT.complete_evo_rec(p_event_offer_rec,l_new_reference_rec);

1223: RAISE FND_API.G_EXC_ERROR;
1224: END IF;
1225: END IF;
1226: p_event_offer_rec.event_offer_id:=l_new_event_offer_id;
1227: AMS_EVENTOFFER_PVT.complete_evo_rec(p_event_offer_rec,l_new_reference_rec);
1228:
1229: x_new_object_id:= l_new_event_offer_id;
1230: x_custom_setup_id:= l_new_reference_rec.custom_setup_id;
1231: