DBA Data[Home] [Help]

APPS.PV_LOCATOR dependencies on FND_PROFILE

Line 26: g_input_content_type CONSTANT VARCHAR2(100):= nvl(fnd_profile.value('PV_LOCATOR_XML_CONTENT_TYPE'), 'application/x-www-form-urlencoded');

22:
23: type party_address_rec_tbl is TABLE OF party_address_rec_type INDEX BY BINARY_INTEGER;
24:
25: --getting some profile values related to tcp proticol like proxy, sontent types
26: g_input_content_type CONSTANT VARCHAR2(100):= nvl(fnd_profile.value('PV_LOCATOR_XML_CONTENT_TYPE'), 'application/x-www-form-urlencoded');
27: --g_proxy_server CONSTANT VARCHAR2(120):=nvl(fnd_profile.value('PV_LOCATOR_PROXY_SERVER'), 'www-proxy.us.oracle.com');
28: --g_proxy_port CONSTANT NUMBER:=to_number(nvl(fnd_profile.value('PV_LOCATOR_PROXY_PORT'), '80'));
29:
30:

Line 27: --g_proxy_server CONSTANT VARCHAR2(120):=nvl(fnd_profile.value('PV_LOCATOR_PROXY_SERVER'), 'www-proxy.us.oracle.com');

23: type party_address_rec_tbl is TABLE OF party_address_rec_type INDEX BY BINARY_INTEGER;
24:
25: --getting some profile values related to tcp proticol like proxy, sontent types
26: g_input_content_type CONSTANT VARCHAR2(100):= nvl(fnd_profile.value('PV_LOCATOR_XML_CONTENT_TYPE'), 'application/x-www-form-urlencoded');
27: --g_proxy_server CONSTANT VARCHAR2(120):=nvl(fnd_profile.value('PV_LOCATOR_PROXY_SERVER'), 'www-proxy.us.oracle.com');
28: --g_proxy_port CONSTANT NUMBER:=to_number(nvl(fnd_profile.value('PV_LOCATOR_PROXY_PORT'), '80'));
29:
30:
31: g_proxy_server CONSTANT VARCHAR2(120):=fnd_profile.value('PV_LOCATOR_PROXY_SERVER');

Line 28: --g_proxy_port CONSTANT NUMBER:=to_number(nvl(fnd_profile.value('PV_LOCATOR_PROXY_PORT'), '80'));

24:
25: --getting some profile values related to tcp proticol like proxy, sontent types
26: g_input_content_type CONSTANT VARCHAR2(100):= nvl(fnd_profile.value('PV_LOCATOR_XML_CONTENT_TYPE'), 'application/x-www-form-urlencoded');
27: --g_proxy_server CONSTANT VARCHAR2(120):=nvl(fnd_profile.value('PV_LOCATOR_PROXY_SERVER'), 'www-proxy.us.oracle.com');
28: --g_proxy_port CONSTANT NUMBER:=to_number(nvl(fnd_profile.value('PV_LOCATOR_PROXY_PORT'), '80'));
29:
30:
31: g_proxy_server CONSTANT VARCHAR2(120):=fnd_profile.value('PV_LOCATOR_PROXY_SERVER');
32: g_proxy_port CONSTANT NUMBER:=to_number(fnd_profile.value('PV_LOCATOR_PROXY_PORT'));

Line 31: g_proxy_server CONSTANT VARCHAR2(120):=fnd_profile.value('PV_LOCATOR_PROXY_SERVER');

27: --g_proxy_server CONSTANT VARCHAR2(120):=nvl(fnd_profile.value('PV_LOCATOR_PROXY_SERVER'), 'www-proxy.us.oracle.com');
28: --g_proxy_port CONSTANT NUMBER:=to_number(nvl(fnd_profile.value('PV_LOCATOR_PROXY_PORT'), '80'));
29:
30:
31: g_proxy_server CONSTANT VARCHAR2(120):=fnd_profile.value('PV_LOCATOR_PROXY_SERVER');
32: g_proxy_port CONSTANT NUMBER:=to_number(fnd_profile.value('PV_LOCATOR_PROXY_PORT'));
33:
34: --g_route_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL_MULTI'), 'http://nh2p1.us.oracle.com:8888/servlet/routem');
35: g_geocode_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL'), 'http://elocation.us.oracle.com/servlets/lbs');

Line 32: g_proxy_port CONSTANT NUMBER:=to_number(fnd_profile.value('PV_LOCATOR_PROXY_PORT'));

28: --g_proxy_port CONSTANT NUMBER:=to_number(nvl(fnd_profile.value('PV_LOCATOR_PROXY_PORT'), '80'));
29:
30:
31: g_proxy_server CONSTANT VARCHAR2(120):=fnd_profile.value('PV_LOCATOR_PROXY_SERVER');
32: g_proxy_port CONSTANT NUMBER:=to_number(fnd_profile.value('PV_LOCATOR_PROXY_PORT'));
33:
34: --g_route_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL_MULTI'), 'http://nh2p1.us.oracle.com:8888/servlet/routem');
35: g_geocode_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL'), 'http://elocation.us.oracle.com/servlets/lbs');
36: g_route_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL'), 'http://elocation.us.oracle.com/servlets/lbs');

Line 34: --g_route_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL_MULTI'), 'http://nh2p1.us.oracle.com:8888/servlet/routem');

30:
31: g_proxy_server CONSTANT VARCHAR2(120):=fnd_profile.value('PV_LOCATOR_PROXY_SERVER');
32: g_proxy_port CONSTANT NUMBER:=to_number(fnd_profile.value('PV_LOCATOR_PROXY_PORT'));
33:
34: --g_route_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL_MULTI'), 'http://nh2p1.us.oracle.com:8888/servlet/routem');
35: g_geocode_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL'), 'http://elocation.us.oracle.com/servlets/lbs');
36: g_route_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL'), 'http://elocation.us.oracle.com/servlets/lbs');
37: --getting server related profile values
38: g_skip_server CONSTANT VARCHAR(1) :=nvl(fnd_profile.value('PV_SKIP_ELOCATION_FOR_MATCHING'), 'N');

Line 35: g_geocode_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL'), 'http://elocation.us.oracle.com/servlets/lbs');

31: g_proxy_server CONSTANT VARCHAR2(120):=fnd_profile.value('PV_LOCATOR_PROXY_SERVER');
32: g_proxy_port CONSTANT NUMBER:=to_number(fnd_profile.value('PV_LOCATOR_PROXY_PORT'));
33:
34: --g_route_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL_MULTI'), 'http://nh2p1.us.oracle.com:8888/servlet/routem');
35: g_geocode_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL'), 'http://elocation.us.oracle.com/servlets/lbs');
36: g_route_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL'), 'http://elocation.us.oracle.com/servlets/lbs');
37: --getting server related profile values
38: g_skip_server CONSTANT VARCHAR(1) :=nvl(fnd_profile.value('PV_SKIP_ELOCATION_FOR_MATCHING'), 'N');
39:

Line 36: g_route_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL'), 'http://elocation.us.oracle.com/servlets/lbs');

32: g_proxy_port CONSTANT NUMBER:=to_number(fnd_profile.value('PV_LOCATOR_PROXY_PORT'));
33:
34: --g_route_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL_MULTI'), 'http://nh2p1.us.oracle.com:8888/servlet/routem');
35: g_geocode_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL'), 'http://elocation.us.oracle.com/servlets/lbs');
36: g_route_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL'), 'http://elocation.us.oracle.com/servlets/lbs');
37: --getting server related profile values
38: g_skip_server CONSTANT VARCHAR(1) :=nvl(fnd_profile.value('PV_SKIP_ELOCATION_FOR_MATCHING'), 'N');
39:
40: g_distance_unit_mile CONSTANT VARCHAR2(30) :='mile';

Line 38: g_skip_server CONSTANT VARCHAR(1) :=nvl(fnd_profile.value('PV_SKIP_ELOCATION_FOR_MATCHING'), 'N');

34: --g_route_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL_MULTI'), 'http://nh2p1.us.oracle.com:8888/servlet/routem');
35: g_geocode_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL'), 'http://elocation.us.oracle.com/servlets/lbs');
36: g_route_url CONSTANT VARCHAR2(128) := nvl(fnd_profile.value('PV_LOCATOR_URL'), 'http://elocation.us.oracle.com/servlets/lbs');
37: --getting server related profile values
38: g_skip_server CONSTANT VARCHAR(1) :=nvl(fnd_profile.value('PV_SKIP_ELOCATION_FOR_MATCHING'), 'N');
39:
40: g_distance_unit_mile CONSTANT VARCHAR2(30) :='mile';
41: g_distance_unit_km CONSTANT VARCHAR2(30) :='km';
42: g_distance_unit_meter CONSTANT VARCHAR2(30) :='meter';

Line 44: --g_distance_unit_mile CONSTANT VARCHAR2(30) :=nvl(fnd_profile.value('PV_LOCATOR_DISTANCE_UNIT_MILE'), 'mile');

40: g_distance_unit_mile CONSTANT VARCHAR2(30) :='mile';
41: g_distance_unit_km CONSTANT VARCHAR2(30) :='km';
42: g_distance_unit_meter CONSTANT VARCHAR2(30) :='meter';
43:
44: --g_distance_unit_mile CONSTANT VARCHAR2(30) :=nvl(fnd_profile.value('PV_LOCATOR_DISTANCE_UNIT_MILE'), 'mile');
45: --g_distance_unit_km CONSTANT VARCHAR2(30) :=nvl(fnd_profile.value('PV_LOCATOR_DISTANCE_UNIT_KM'), 'km');
46: --g_distance_unit_meter CONSTANT VARCHAR2(30) :=nvl(fnd_profile.value('PV_LOCATOR_DISTANCE_UNIT_METER'), 'meter');
47:
48:

Line 45: --g_distance_unit_km CONSTANT VARCHAR2(30) :=nvl(fnd_profile.value('PV_LOCATOR_DISTANCE_UNIT_KM'), 'km');

41: g_distance_unit_km CONSTANT VARCHAR2(30) :='km';
42: g_distance_unit_meter CONSTANT VARCHAR2(30) :='meter';
43:
44: --g_distance_unit_mile CONSTANT VARCHAR2(30) :=nvl(fnd_profile.value('PV_LOCATOR_DISTANCE_UNIT_MILE'), 'mile');
45: --g_distance_unit_km CONSTANT VARCHAR2(30) :=nvl(fnd_profile.value('PV_LOCATOR_DISTANCE_UNIT_KM'), 'km');
46: --g_distance_unit_meter CONSTANT VARCHAR2(30) :=nvl(fnd_profile.value('PV_LOCATOR_DISTANCE_UNIT_METER'), 'meter');
47:
48:
49:

Line 46: --g_distance_unit_meter CONSTANT VARCHAR2(30) :=nvl(fnd_profile.value('PV_LOCATOR_DISTANCE_UNIT_METER'), 'meter');

42: g_distance_unit_meter CONSTANT VARCHAR2(30) :='meter';
43:
44: --g_distance_unit_mile CONSTANT VARCHAR2(30) :=nvl(fnd_profile.value('PV_LOCATOR_DISTANCE_UNIT_MILE'), 'mile');
45: --g_distance_unit_km CONSTANT VARCHAR2(30) :=nvl(fnd_profile.value('PV_LOCATOR_DISTANCE_UNIT_KM'), 'km');
46: --g_distance_unit_meter CONSTANT VARCHAR2(30) :=nvl(fnd_profile.value('PV_LOCATOR_DISTANCE_UNIT_METER'), 'meter');
47:
48:
49:
50: --getting some geometry related profile values that will be used in making geometry object