DBA Data[Home] [Help]

APPS.PV_MATCH_V2_PUB dependencies on PV_LOCATOR

Line 94: l_customer_address pv_locator.party_address_rec_type;

90:
91: l_prefered_partner_distance NUMBER;
92:
93: l_distance_uom VARCHAR2(100);
94: l_customer_address pv_locator.party_address_rec_type;
95: --x_distance_uom_returned VARCHAR2(30);
96:
97: l_no_of_prefered_pts NUMBER := 0;
98: l_prefered_pt_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 240: Debug('Calling pv_locator.Get_Partners..........................');

236: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
237: Debug('Location ID: ' || l_customer_address.location_id);
238:
239: Debug('..........................................................');
240: Debug('Calling pv_locator.Get_Partners..........................');
241: Debug('# of Partners Sent: ' || l_matched_id.COUNT);
242:
243: for i in 1 .. x_matched_id.count
244: loop

Line 254: l_distance_uom := pv_locator.g_distance_unit_mile;

250: -- Execute geo proximity API.
251: -- -------------------------------------------------------------
252:
253: -- Default to mile?
254: l_distance_uom := pv_locator.g_distance_unit_mile;
255: pv_locator.Get_Partners (
256: p_api_version => 1.0,
257: p_init_msg_list => FND_API.g_false,
258: p_commit => FND_API.g_false,

Line 255: pv_locator.Get_Partners (

251: -- -------------------------------------------------------------
252:
253: -- Default to mile?
254: l_distance_uom := pv_locator.g_distance_unit_mile;
255: pv_locator.Get_Partners (
256: p_api_version => 1.0,
257: p_init_msg_list => FND_API.g_false,
258: p_commit => FND_API.g_false,
259: p_validation_level => FND_API.g_valid_level_full,

Line 281: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN

277: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
278: RAISE FND_API.g_exc_unexpected_error;
279: END IF;
280:
281: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN
282: x_distance_uom_returned := 'KILOMETERS';
283:
284: ELSIF (x_distance_uom_returned = pv_locator.g_distance_unit_mile) THEN
285: x_distance_uom_returned := 'MILES';

Line 284: ELSIF (x_distance_uom_returned = pv_locator.g_distance_unit_mile) THEN

280:
281: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN
282: x_distance_uom_returned := 'KILOMETERS';
283:
284: ELSIF (x_distance_uom_returned = pv_locator.g_distance_unit_mile) THEN
285: x_distance_uom_returned := 'MILES';
286: END IF;
287:
288: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 525: l_customer_address pv_locator.party_address_rec_type;

521: l_api_version_number CONSTANT NUMBER := 1.0;
522:
523: -- pklin
524: l_distance_uom VARCHAR2(30);
525: l_customer_address pv_locator.party_address_rec_type;
526: --x_distance_uom_returned VARCHAR2(30);
527:
528: l_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
529: l_no_of_prefered_pts NUMBER := 0;