1 PACKAGE flm_seq_id2name AS
2 /* $Header: FLMSQIDS.pls 120.0.12000000.1 2007/01/19 09:30:58 appldev ship $ */
3
4 TYPE ID2Name_t IS RECORD (
5 table_name VARCHAR2(40),
6 column_name VARCHAR2(40),
7 query_string VARCHAR2(2000)
8 );
9
10 TYPE ID2Name_TABLE_t IS TABLE OF ID2Name_t INDEX BY BINARY_INTEGER;
11
12 ID2Name_Table ID2Name_TABLE_t;
13
14
15 /******************************************************************
16 * Initialize ID2Name_Table if it is not initialized. *
17 ******************************************************************/
18 PROCEDURE ID2NameInit;
19
20 /******************************************************************
21 * To check whether given attribute needs ID2Name translation *
22 ******************************************************************/
23 PROCEDURE ID2Name( p_attribute_id IN NUMBER,
24 p_init_msg_list IN VARCHAR2,
25 x_id2name OUT NOCOPY VARCHAR2,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2
29 );
30
31 /*****************************************************
32 * To return a LOV query for given ID column. *
33 *****************************************************/
34 PROCEDURE ID2NameLovQuery( p_attribute_id IN NUMBER,
35 p_init_msg_list IN VARCHAR2,
36 x_query OUT NOCOPY VARCHAR2,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2);
40
41 /******************************************************************
42 * To check whether given table.column needs ID2Name translation *
43 ******************************************************************/
44 PROCEDURE ID2Name( p_table IN VARCHAR2,
45 p_column IN VARCHAR2,
46 p_init_msg_list IN VARCHAR2,
47 x_id2name OUT NOCOPY VARCHAR2,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2
51 );
52
53 /*****************************************************
54 * To return a LOV query for given ID column. *
55 *****************************************************/
56 PROCEDURE ID2NameLovQuery( p_table IN VARCHAR2,
57 p_column IN VARCHAR2,
58 p_init_msg_list IN VARCHAR2,
59 x_query OUT NOCOPY VARCHAR2,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2);
63
64
65 /*****************************************************
66 * To return a name for given ID column and ID value *
67 *****************************************************/
68 PROCEDURE ID2NameAttributeValue(
69 p_table IN VARCHAR2,
70 p_column IN VARCHAR2,
71 p_org_id IN NUMBER,
72 p_value IN NUMBER,
73 p_init_msg_list IN VARCHAR2,
74 x_name OUT NOCOPY VARCHAR2,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2);
78
79
80 END flm_seq_id2name;