1 Package JTF_RS_JSP_LOV_RECS_PUB AS
2 /* $Header: jtfrsjls.pls 120.0 2005/05/11 08:20:25 appldev ship $ */
3 /*#
4 * This package contains procedures for getting records
5 * to be displayed in an generic LOV for a given criteria
6 * @rep:scope private
7 * @rep:product JTF
8 * @rep:displayname Generic LOV Package
9 * @rep:category BUSINESS_ENTITY JTF_RS_RESOURCE_LOV
10 */
11
12
13 ---------------------------------------------------------
14 -- Start of Comments
15 -- ---------------------------------------------------
16 -- PACKAGE NAME: JTF_RS_JSP_LOV_RECS_PUB
17 -- ---------------------------------------------------
18 -- PURPOSE
19 -- Get resource details for JSP LOV Screens
20 -- NOTES
21 -- This package is publicly available for use
22 --
23 -- HISTORY
24 -- 05/18/2001 EIHSU Created
25 -- End of Comments
26 --
27
28 -- RESOURCE RECORDS
29 TYPE lov_input_rec_type IS record
30 (display_value varchar2(2000),
31 code_value varchar2(100),
32 aux_value1 varchar2(2000),
33 aux_value2 varchar2(2000),
34 aux_value3 varchar2(2000)
35 );
36
37 TYPE lov_output_rec_type IS record
38 (display_value varchar2(2000),
39 code_value varchar2(100),
40 aux_value1 varchar2(2000),
41 aux_value2 varchar2(2000),
42 aux_value3 varchar2(2000),
43 ext_value1 varchar2(2000),
44 ext_value2 varchar2(2000),
45 ext_value3 varchar2(2000),
46 ext_value4 varchar2(2000),
47 ext_value5 varchar2(2000)
48 );
49
50 TYPE lov_output_tbl_type IS table OF lov_output_rec_type
51 INDEX BY binary_integer;
52
53 -- ***************************************************
54 -- start of comments
55 -- ***************************************************
56 -- api name : Get_LOV_Records
57 -- type : public.
58 -- function :
59 -- pre-reqs :
60 -- parameters :
61 -- end of comments
62
63 /*#
64 * Get LOV Records for a given criteria
65 * @param p_range_low Lower range for record set
66 * @param p_range_high Higher range for record set
67 * @param p_record_group_name Indicated type of LOV
68 * @param p_in_filter_lov_rec Record containing filter condition
69 * @param p_in_filter1 Key to exclude a record
70 * @param p_in_filter2 Key to exclude a record
71 * @param x_total_rows Output parameter containing total rows returned
72 * @param x_more_data_flag Output parameter containing indicator if there are more records possible
73 * @param x_lov_ak_region Output parameter containing name of AK region containing LOV table column titles
74 * @param x_result_tbl Output parameter containing PL/SQL Table containing the result set
75 * @param x_ext_col_cnt Output parameter containing count of ext_value fields used in x_result_tbl
76 * @rep:scope private
77 * @rep:displayname Get LOV Records
78 */
79 PROCEDURE Get_LOV_Records
80 ( p_range_low IN NUMBER,
81 p_range_high IN NUMBER,
82 p_record_group_name IN VARCHAR2, -- name of the data to fetch
83 p_in_filter_lov_rec IN lov_input_rec_type,
84 p_in_filter1 IN VARCHAR2, -- to restrict the data fetched
85 p_in_filter2 IN VARCHAR2,
86 x_total_rows OUT NOCOPY NUMBER,
87 x_more_data_flag OUT NOCOPY VARCHAR2,
88 x_lov_ak_region OUT NOCOPY VARCHAR2,
89 x_result_tbl OUT NOCOPY lov_output_tbl_type,
90 x_ext_col_cnt OUT NOCOPY NUMBER);
91
92
93 END JTF_RS_JSP_LOV_RECS_PUB;