1 PACKAGE IMC_UTILITY_PVT AS
2 /* $Header: imcvutls.pls 120.2 2006/02/20 23:40:50 vnama noship $ */
3 -- Start of Comments
4 -- Package name : IMC_UTILITY_PVT
5 -- Purpose :
6 -- History :
7 -- Colathur Vijayan (VJN) 1/7/2002, included function that would return
8 -- a html link tag which will contain the address formatted for Yahoo Maps.
9 -- Vivek Nama -- Bug 4915127: stubbing apis
10 -- GET_OVRW_MENU_PARAM()
11 -- GET_EMP_MENU_PARAM()
12 -- GET_ADMIN_FUNCTION_ID()
13 -- NOTE :
14 -- End of Comments
15 ----------------------------------------------------
16
17 -- Returns a URL of the form,
18 --
19 FUNCTION GET_YAHOO_MAP_URL(address1 IN VARCHAR2,
20 address2 IN VARCHAR2,
21 address3 IN VARCHAR2,
22 address4 IN VARCHAR2,
23 city IN VARCHAR2,
24 country IN VARCHAR2,
25 state IN VARCHAR2,
26 postal_code IN VARCHAR2)
27 RETURN VARCHAR2;
28 --
29 ------------------------------------------------------------------------------
30 --
31 -- This function will return a html link tag which will contain the address formatted for Yahoo Maps.
32 ------------------------------------------------------------------------------
33 FUNCTION GET_YAHOO_ADDRESS_LINK_TAG( address_style IN VARCHAR2,
34 address1 IN VARCHAR2,
35 address2 IN VARCHAR2,
36 address3 IN VARCHAR2,
37 address4 IN VARCHAR2,
38 city IN VARCHAR2,
39 county IN VARCHAR2,
40 state IN VARCHAR2,
41 province IN VARCHAR2,
42 postal_code IN VARCHAR2,
43 territory_short_name IN VARCHAR2,
44 country_code IN VARCHAR2,
45 customer_name IN VARCHAR2,
46 bill_to_location IN VARCHAR2,
47 first_name IN VARCHAR2,
48 last_name IN VARCHAR2,
49 mail_stop IN VARCHAR2,
50 default_country_code IN VARCHAR2,
51 default_country_desc IN VARCHAR2,
52 print_home_country_flag IN VARCHAR2,
53 width IN NUMBER,
54 height_min IN NUMBER,
55 height_max IN NUMBER
56 )
57 RETURN VARCHAR2;
58
59 ------------------------------------------------------------------------------
60 -- Bug 4915127: stubbing api
61 ------------------------------------------------------------------------------
62 FUNCTION GET_OVRW_MENU_PARAM(resp_id IN NUMBER,
63 type IN VARCHAR2)
64 RETURN VARCHAR2;
65
66 ------------------------------------------------------------------------------
67 -- Bug 4915127: stubbing api
68 ------------------------------------------------------------------------------
69 FUNCTION GET_EMP_MENU_PARAM(resp_id IN NUMBER)
70 RETURN VARCHAR2;
71
72 ------------------------------------------------------------------------------
73 -- Bug 4915127: stubbing api
74 ------------------------------------------------------------------------------
75 FUNCTION GET_ADMIN_FUNCTION_ID(p_lang IN VARCHAR2, p_respid in number, p_appid in number)
76 RETURN NUMBER;
77
78 End IMC_UTILITY_PVT;