1 PACKAGE HXC_SEEDDATA_PKG AS
2 /* $Header: hxcseeddatapkg.pkh 120.1 2005/06/28 23:44:26 dragarwa noship $ */
3
4
5
6 TYPE r_rec is RECORD (
7 object_id NUMBER (15),
8 object_type VARCHAR2 (80),
9 owner_application_id NUMBER (15),
10 VALUE VARCHAR2 (150),
11 application_name VARCHAR2 (240),
12 code_level_required VARCHAR2 (80),
13 HXC_REQUIRED VARCHAR2(30),
14 created_by NUMBER(15),
15 creation_date DATE,
16 last_updated_by number(15),
17 last_update_date date,
18 last_update_login number(15)
19 );
20
21 TYPE t_rec IS TABLE OF r_rec INDEX BY BINARY_INTEGER;
22
23
24 -- The get_query function just returns the query as a string. The query depends on
25 -- the object_type passed.
26
27 FUNCTION get_query(p_object_type in varchar2)
28 RETURN VARCHAR2;
29
30
31 --The get_value function takes the object type and finds the query using get_query.
32 --It then makes use of p_object_id to find the value corresponding to the object_id
33 --This function is used by hxcseed.lct loader for its download section
34
35 FUNCTION get_value ( p_object_id in number,
36 p_object_type in varchar2 )
37 RETURN varchar2;
38
39
40 --The get_legislation_code function returns the legislation code based on the
41 --object_id and object_type. This function is also used by hxcseed.lct lader for its
42 --download section
43
44 FUNCTION get_legislation_code(p_object_id in number,
45 p_object_type in varchar2 )
46 RETURN varchar2;
47
48
49 --The HXC_SEEDDATA_BY_LEVEL block of the HXCSEEDDATA form is based on
50 --the stored procedure hxc_seeddata_by_level_query.
51
52 PROCEDURE hxc_seeddata_by_level_query
53 (p_seeddata_by_level_data in out NOCOPY t_rec,
54 p_object_type in varchar2,
55 p_value in varchar2,
56 p_application_name in varchar2,
57 p_code_level_required in varchar2,
58 p_count out NOCOPY number);
59
60
61 END HXC_SEEDDATA_PKG;