[Home] [Help]
PACKAGE: APPS.JTF_TERR_JSP_LOV_RECS_PUB
Source
1 Package JTF_TERR_JSP_LOV_RECS_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfpjlvs.pls 120.0 2005/06/02 18:20:42 appldev ship $ */
3 ---------------------------------------------------------
4 -- Start of Comments
5 -- ---------------------------------------------------
6 -- PACKAGE NAME: JTF_TERR_JSP_LOV_RECS_PUB
7 -- ---------------------------------------------------
8 -- PURPOSE
9 -- JTF/A Territories LOV Package
10 -- NOTES
11 -- This package is publicly available for use
12 --
13 -- HISTORY
14 -- 05/18/2001 EIHSU Created
15 -- End of Comments
16 --
17
18 -- RESOURCE RECORDS
19 TYPE lov_inout_rec_type IS record
20 (column1 varchar2(2000),
21 column2 varchar2(2000),
22 column3 varchar2(2000),
23 column4 varchar2(2000),
24 column5 varchar2(2000),
25 column6 varchar2(2000),
26 column7 varchar2(2000),
27 column8 varchar2(2000),
28 column9 varchar2(2000),
29 column10 varchar2(2000),
30 column11 varchar2(2000),
31 column12 varchar2(2000),
32 column13 varchar2(2000),
33 column14 varchar2(2000),
34 column15 varchar2(2000),
35 -------------------------------
36 filter1 varchar2(2000),
37 filter2 varchar2(2000),
38 filter3 varchar2(2000),
39 filter4 varchar2(2000),
40 filter5 varchar2(2000)
41 );
42
43 TYPE lov_disp_format_rec_type IS record
44 (column_number number,
45 column_display_enable varchar2(1),
46 column_search_enable varchar2(1)
47 );
48
49
50 TYPE lov_output_tbl_type IS table OF lov_inout_rec_type
51 INDEX BY binary_integer;
52
53 TYPE lov_disp_format_tbl_type IS table OF lov_disp_format_rec_type
54 INDEX BY binary_integer;
55
56
57 -- ***************************************************
58 -- start of comments
59 -- ***************************************************
60 -- api name : Get_LOV_Records
61 -- type : public.
62 -- function :
63 -- pre-reqs :
64 -- parameters :
65 -- end of comments
66
67 procedure Get_LOV_Records
68 ( p_range_low IN NUMBER,
69 p_range_high IN NUMBER,
70 p_record_group_name IN VARCHAR2, -- name of the data to fetch
71 p_in_filter_lov_rec IN lov_inout_rec_type,
72 x_total_rows OUT NOCOPY NUMBER,
73 x_more_data_flag OUT NOCOPY VARCHAR2,
74 x_lov_ak_region OUT NOCOPY VARCHAR2,
75 x_result_tbl OUT NOCOPY lov_output_tbl_type,
76 x_disp_format_tbl OUT NOCOPY lov_disp_format_tbl_type
77 );
78
79
80 END JTF_TERR_JSP_LOV_RECS_PUB;