DBA Data[Home] [Help]

APPS.AMS_EVENTOFFER_PVT dependencies on AMS_ACTDELVMETHOD_PVT

Line 302: l_dlv_rec AMS_ActDelvMethod_PVT.act_DelvMethod_rec_type;

298: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
299:
300: l_return_status VARCHAR2(1);
301: l_evo_rec evo_rec_type;
302: l_dlv_rec AMS_ActDelvMethod_PVT.act_DelvMethod_rec_type;
303: -- location_rec hz_location_pub.location_rec_type;
304: location_rec hz_location_v2pub.location_rec_type;
305: l_dlv_id NUMBER := null;
306: l_evo_count NUMBER;

Line 592: AMS_ActDelvMethod_PVT.Create_Act_DelvMethod(

588: l_dlv_rec.ARC_ACT_DELIVERY_USED_BY := 'EVEO';
589: l_dlv_rec.ACT_DELIVERY_METHOD_USED_BY_ID := l_evo_rec.event_offer_id;
590: l_dlv_rec.DELIVERY_MEDIA_TYPE_CODE := l_evo_rec.EVENT_DELIVERY_METHOD_CODE;
591: END IF;
592: AMS_ActDelvMethod_PVT.Create_Act_DelvMethod(
593: p_api_version => l_api_version,
594: p_init_msg_list => FND_API.g_false,
595: p_commit => FND_API.g_false,
596: p_validation_level => FND_API.g_valid_level_full,

Line 1505: l_dlv_rec AMS_ActDelvMethod_PVT.act_DelvMethod_rec_type;

1501:
1502: l_evo_rec evo_rec_type;
1503: l_global_flag VARCHAR2(25);
1504: l_source_code VARCHAR2(30);
1505: l_dlv_rec AMS_ActDelvMethod_PVT.act_DelvMethod_rec_type;
1506: -- location_rec hz_location_pub.location_rec_type;
1507: location_rec hz_location_v2pub.location_rec_type;
1508: l_dlv_code VARCHAR2(30);
1509: l_dlv_id NUMBER := null;

Line 2067: AMS_ActDelvMethod_PVT.init_act_DelvMethod_rec (l_dlv_rec);

2063: AND l_evo_rec.event_delivery_method_code IS NOT NULL THEN
2064:
2065: IF l_dlv_id is NOT NULL then
2066: IF l_evo_rec.EVENT_DELIVERY_METHOD_CODE <> l_dlv_code THEN
2067: AMS_ActDelvMethod_PVT.init_act_DelvMethod_rec (l_dlv_rec);
2068: l_dlv_rec.ACTIVITY_DELIVERY_METHOD_ID := l_dlv_id;
2069: l_dlv_rec.DELIVERY_MEDIA_TYPE_CODE := l_evo_rec.EVENT_DELIVERY_METHOD_CODE;
2070: l_dlv_rec.object_version_number := l_dlv_ver;
2071:

Line 2072: AMS_ActDelvMethod_PVT.Update_Act_DelvMethod(

2068: l_dlv_rec.ACTIVITY_DELIVERY_METHOD_ID := l_dlv_id;
2069: l_dlv_rec.DELIVERY_MEDIA_TYPE_CODE := l_evo_rec.EVENT_DELIVERY_METHOD_CODE;
2070: l_dlv_rec.object_version_number := l_dlv_ver;
2071:
2072: AMS_ActDelvMethod_PVT.Update_Act_DelvMethod(
2073: p_api_version => l_api_version,
2074: p_init_msg_list => FND_API.g_false,
2075: p_commit => FND_API.g_false,
2076: p_validation_level => FND_API.g_valid_level_full,

Line 2098: AMS_ActDelvMethod_PVT.Create_Act_DelvMethod(

2094: l_dlv_rec.ARC_ACT_DELIVERY_USED_BY := 'EVEO';
2095: l_dlv_rec.ACT_DELIVERY_METHOD_USED_BY_ID := l_evo_rec.event_offer_id;
2096: l_dlv_rec.DELIVERY_MEDIA_TYPE_CODE := l_evo_rec.EVENT_DELIVERY_METHOD_CODE;
2097: END IF;
2098: AMS_ActDelvMethod_PVT.Create_Act_DelvMethod(
2099: p_api_version => l_api_version,
2100: p_init_msg_list => FND_API.g_false,
2101: p_commit => FND_API.g_false,
2102: p_validation_level => FND_API.g_valid_level_full,

Line 2123: AMS_ActDelvMethod_PVT.Delete_Act_DelvMethod(

2119: -- added sugupta 07/26/2000 if delv code passed as null and delv id exists, then we delete act_del_id
2120: -- from both act_delv table as well as eveo table
2121:
2122: IF l_dlv_id is NOT NULL then
2123: AMS_ActDelvMethod_PVT.Delete_Act_DelvMethod(
2124: p_api_version => l_api_version,
2125: p_init_msg_list => FND_API.g_false,
2126: p_commit => FND_API.g_false,
2127: p_validation_level => FND_API.g_valid_level_full,