PACKAGE: APPS.PV_ATTRIBUTE_UTIL

Source

1 PACKAGE PV_ATTRIBUTE_UTIL AUTHID CURRENT_USER AS
2 /* $Header: pvxvauts.pls 120.1 2005/09/01 12:55:44 appldev ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          PV_ATTRIBUTE_UTIL
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15 
16 
17 
18 
19 ---------------------------------------------------------------------
20 -- FUNCTION
21 --    GET_ATTR_VALUES_HISTORY
22 --
23 -- PURPOSE
24 --    Based on the attribute_id, entity, entity_id, This function returns the attribute values appended with comma.
25 --
26 -- PARAMETERS
27 --    attribute_id, entity, entity_id
28 --    returns values separated by comma as varchar2
29 --
30 -- NOTES
31 --
32 ---------------------------------------------------------------------
33 
34 TYPE lov_data_rec_type IS RECORD
35 (
36 	code		VARCHAR2(30) ,
37 	meaning		VARCHAR2(4000),
38 	description	VARCHAR2(240)
39 
40 );
41 
42 g_miss_lov_data_rec          lov_data_rec_type;
43 TYPE  lov_data_tbl_type      IS TABLE OF lov_data_rec_type INDEX BY BINARY_INTEGER;
44 g_miss_lov_data_tbl          lov_data_tbl_type;
45 
46 g_user_currency_code       CONSTANT VARCHAR(30)	:=nvl(fnd_profile.value('ICX_PREFERRED_CURRENCY'), 'USD');
47 
48 FUNCTION GET_ATTR_VALUES_HISTORY (      p_attribute_id     NUMBER,
49                                         p_entity   VARCHAR2,
50                                         p_entity_id     NUMBER,
51 					p_version	NUMBER,
52 					p_attr_data_type VARCHAR2,
53 					p_lov_string	VARCHAR2,
54 					p_user_date_format VARCHAR2
55 				 )
56 RETURN VARCHAR2 DETERMINISTIC;
57 
58 
59 FUNCTION GET_ATTR_VALUES (		p_attribute_id     NUMBER,
60                                         p_entity   VARCHAR2,
61                                         p_entity_id     NUMBER,
62 					p_attr_data_type VARCHAR2,
63 					p_lov_string	VARCHAR2,
64 					p_is_snap_shot	VARCHAR2,
65 					p_snap_shot_date	VARCHAR2,
66 					p_user_date_format  VARCHAR2
67 				 )
68 RETURN VARCHAR2 DETERMINISTIC;
69 
70 
71 
72 END PV_ATTRIBUTE_UTIL;