DBA Data[Home] [Help]

APPS.AMS_EVENTOFFER_PVT dependencies on HZ_LOCATION_V2PUB

Line 304: location_rec hz_location_v2pub.location_rec_type;

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;
307: l_start_time DATE;
308: l_end_time DATE;

Line 655: hz_location_v2pub.create_location(

651: location_rec.address1 := ' ';
652: location_rec.ORIG_SYSTEM_REFERENCE := -1;
653: location_rec.content_source_type := 'USER_ENTERED';
654: location_rec.created_by_module := 'AMS_EVENT';
655: hz_location_v2pub.create_location(
656: p_init_msg_list => p_init_msg_list,
657: p_location_rec => location_rec,
658: x_return_status => l_return_status,
659: x_msg_count => x_msg_count,

Line 1507: location_rec hz_location_v2pub.location_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;
1510: l_dlv_ver NUMBER;
1511: l_return_status VARCHAR2(1);

Line 1535: l_location_rec HZ_LOCATION_V2PUB.Location_Rec_Type;

1531: l_resource_id NUMBER;
1532: l_obj_num NUMBER;
1533:
1534: -- l_location_rec HZ_LOCATION_PUB.Location_Rec_Type;
1535: l_location_rec HZ_LOCATION_V2PUB.Location_Rec_Type;
1536: l_location_id NUMBER;
1537: l_address1 VARCHAR2(240);
1538: l_address2 VARCHAR2(240);
1539: l_city VARCHAR2(60);

Line 2269: HZ_LOCATION_V2PUB.Create_Location(

2265: l_location_rec.country := l_evo_rec.country;
2266: l_location_rec.ORIG_SYSTEM_REFERENCE := -1;
2267: l_location_rec.CONTENT_SOURCE_TYPE := 'USER_ENTERED';
2268: l_location_rec.created_by_module := 'AMS_EVENT';
2269: HZ_LOCATION_V2PUB.Create_Location(
2270: p_init_msg_list => FND_API.g_false,
2271: p_location_rec => l_location_rec,
2272: x_return_status => l_return_status,
2273: x_msg_count => x_msg_count,