[Home] [Help]
PACKAGE: APPS.BIS_LOV_PVT
Source
1 PACKAGE BIS_LOV_PVT AUTHID CURRENT_USER AS
2 /* $Header: BISVLOVS.pls 115.18 2002/12/16 10:25:59 rchandra ship $ */
3 -- Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA
4 -- All rights reserved.
5 --
6 -- FILENAME
7 -- BISVLOVS.pls
8 --
9 -- DESCRIPTION
10 -- Spec of list of values utilities package
11 --
12 -- HISTORY
13 --
14 -- MAR-2000 irchen created
15 --
16
17 DSP_NO_SELECTION_STRING CONSTANT VARCHAR2(10000)
18 := BIS_UTILITIES_PVT.Get_FND_Message
19 ( p_message_name => 'BIS_NO_SELECTION_MESSAGE' );
20
21 TYPE Value_Id_Record is Record (
22 Value VARCHAR2(32000)
23 , Id VARCHAR2(32000)
24 );
25 Type Value_Id_Table is table of Value_Id_Record
26 index by binary_integer;
27
28 Procedure null_alert;
29
30 Procedure Dependent_LOVFunction
31 ( p_lov_func_name in varchar2
32 , p_attribute_app_id in NUMBER
33 , p_attribute_code in varchar2
34 , p_region_app_id in number
35 , p_region_code in varchar2
36 , p_form_name in varchar2
37 , p_frame_name in varchar2 default null
38 , p_where_clause in varchar2 default null
39 , p_null_variable in varchar2 default null
40 , p_null_alert_text in varchar2 default null
41 );
42
43 Procedure get_List
44 ( p_attributes IN varchar2 default null
45 , p_name IN varchar2 default null
46 , p_selected_value IN varchar2 default null
47 , p_no_selection_flag IN varchar2 default FND_API.G_FALSE
48 , p_list IN value_id_table
49 , x_list_str OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
50 );
51
52 Procedure get_List
53 ( p_attributes IN varchar2 default null
54 , p_name IN varchar2 default null
55 , p_selected_value IN varchar2 default null
56 , p_no_selection_flag IN varchar2 default FND_API.G_FALSE
57 , p_list IN value_id_table
58 , p_label IN varchar2
59 , x_list_str OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
60 );
61 --
62 procedure Get_List
63 ( p_attribute_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
64 , p_attribute_code IN VARCHAR2
65 , p_attribute_name IN VARCHAR2
66 , p_region_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
67 , p_region_code IN VARCHAR2
68 , p_form_name IN VARCHAR2
69 , p_where_clause IN VARCHAR2 := NULL
70 , p_selected_value IN BIS_LOV_PVT.Value_id_record
71 , p_func IN VARCHAR2 DEFAULT NULL
72 , p_size IN NUMBER DEFAULT 20
73 , x_list_str OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
74 );
75
76 procedure Get_List
77 ( p_attribute_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
78 , p_attribute_code IN VARCHAR2
79 , p_attribute_name IN VARCHAR2
80 , p_region_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
81 , p_region_code IN VARCHAR2
82 , p_form_name IN VARCHAR2
83 , p_label IN VARCHAR2
84 , p_where_clause IN VARCHAR2 := NULL
85 , p_selected_value IN BIS_LOV_PVT.Value_id_record
86 , p_func IN VARCHAR2 DEFAULT NULL
87 , p_size IN NUMBER DEFAULT 20
88 , x_list_str OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
89 );
90
91 procedure Get_List
92 ( p_attribute1_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
93 , p_attribute1_code IN VARCHAR2
94 , p_attribute1_name IN VARCHAR2
95 , p_region1_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
96 , p_region1_code IN VARCHAR2
97 , p_form1_name IN VARCHAR2
98 , p_where_clause1 IN VARCHAR2 := NULL
99 , p_selected_value1 IN BIS_LOV_PVT.Value_id_record
100 , p_func1 IN VARCHAR2 DEFAULT NULL
101 , p_size1 IN NUMBER DEFAULT 20
102 , p_attribute2_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
103 , p_attribute2_code IN VARCHAR2
104 , p_attribute2_name IN VARCHAR2
105 , p_region2_app_id IN NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
106 , p_region2_code IN VARCHAR2
107 , p_form2_name IN VARCHAR2
108 , p_where_clause2 IN VARCHAR2 := NULL
109 , p_selected_value2 IN BIS_LOV_PVT.Value_id_record
110 , p_func2 IN VARCHAR2 DEFAULT NULL
111 , p_size2 IN NUMBER DEFAULT 20
112 , p_label IN VARCHAR2 := NULL
113 , p_separator IN VARCHAR2 := BIS_UTILITIES_PVT.G_BIS_SEPARATOR
114 , x_list_str OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
115 );
116
117 --
118 --
119 END BIS_LOV_PVT;