[Home] [Help]
PACKAGE: APPS.GHR_EXTRA_INFO
Source
1 PACKAGE GHR_EXTRA_INFO AUTHID CURRENT_USER AS
2 /* $Header: ghexinfo.pkh 115.1 99/10/18 00:56:29 porting ship $ */
3 g_records_fetched NUMBER;
4 g_current_record NUMBER;
5
6
7 TYPE r_extra_info_type IS RECORD (
8 extra_info_id per_position_extra_info.position_extra_info_id%type
9 ,id per_position_extra_info.position_id%type
10 ,information_type per_position_extra_info.information_type%type
11 ,request_id per_position_extra_info.request_id%type
12 ,program_application_id per_position_extra_info.program_application_id%type
13 ,program_id per_position_extra_info.program_id%type
14 ,program_update_date per_position_extra_info.program_update_date%type
15 ,attribute_category per_position_extra_info.poei_attribute_category%type
16 ,attribute1 per_position_extra_info.poei_attribute1%type
17 ,attribute2 per_position_extra_info.poei_attribute2%type
18 ,attribute3 per_position_extra_info.poei_attribute3%type
19 ,attribute4 per_position_extra_info.poei_attribute4%type
20 ,attribute5 per_position_extra_info.poei_attribute5%type
21 ,attribute6 per_position_extra_info.poei_attribute6%type
22 ,attribute7 per_position_extra_info.poei_attribute7%type
23 ,attribute8 per_position_extra_info.poei_attribute8%type
24 ,attribute9 per_position_extra_info.poei_attribute9%type
25 ,attribute10 per_position_extra_info.poei_attribute10%type
26 ,attribute11 per_position_extra_info.poei_attribute11%type
27 ,attribute12 per_position_extra_info.poei_attribute12%type
28 ,attribute13 per_position_extra_info.poei_attribute13%type
29 ,attribute14 per_position_extra_info.poei_attribute14%type
30 ,attribute15 per_position_extra_info.poei_attribute15%type
31 ,attribute16 per_position_extra_info.poei_attribute16%type
32 ,attribute17 per_position_extra_info.poei_attribute17%type
33 ,attribute18 per_position_extra_info.poei_attribute18%type
34 ,attribute19 per_position_extra_info.poei_attribute19%type
35 ,attribute20 per_position_extra_info.poei_attribute20%type
36 ,information_category per_position_extra_info.poei_information_category%type
37 ,information1 per_position_extra_info.poei_information1%type
38 ,information2 per_position_extra_info.poei_information2%type
39 ,information3 per_position_extra_info.poei_information3%type
40 ,information4 per_position_extra_info.poei_information4%type
41 ,information5 per_position_extra_info.poei_information5%type
42 ,information6 per_position_extra_info.poei_information6%type
43 ,information7 per_position_extra_info.poei_information7%type
44 ,information8 per_position_extra_info.poei_information8%type
45 ,information9 per_position_extra_info.poei_information9%type
46 ,information10 per_position_extra_info.poei_information10%type
47 ,information11 per_position_extra_info.poei_information11%type
48 ,information12 per_position_extra_info.poei_information12%type
49 ,information13 per_position_extra_info.poei_information13%type
50 ,information14 per_position_extra_info.poei_information14%type
51 ,information15 per_position_extra_info.poei_information15%type
52 ,information16 per_position_extra_info.poei_information16%type
53 ,information17 per_position_extra_info.poei_information17%type
54 ,information18 per_position_extra_info.poei_information18%type
55 ,information19 per_position_extra_info.poei_information19%type
56 ,information20 per_position_extra_info.poei_information20%type
57 ,information21 per_position_extra_info.poei_information21%type
58 ,information22 per_position_extra_info.poei_information22%type
59 ,information23 per_position_extra_info.poei_information23%type
60 ,information24 per_position_extra_info.poei_information24%type
61 ,information25 per_position_extra_info.poei_information25%type
62 ,information26 per_position_extra_info.poei_information26%type
63 ,information27 per_position_extra_info.poei_information27%type
64 ,information28 per_position_extra_info.poei_information28%type
65 ,information29 per_position_extra_info.poei_information29%type
66 ,information30 per_position_extra_info.poei_information30%type
67 ,object_version_number per_position_extra_info.object_version_number%type
68 ,last_update_date per_position_extra_info.last_update_date%type
69 ,last_updated_by per_position_extra_info.last_updated_by%type
70 ,last_update_login per_position_extra_info.last_update_login%type
71 ,created_by per_position_extra_info.created_by%type
72 ,creation_date per_position_extra_info.creation_date%type
73 );
74 TYPE r_short_extra_info_type IS RECORD (
75 extra_info_id per_position_extra_info.position_extra_info_id%type
76 ,id per_position_extra_info.position_id%type
77 ,information_type per_position_extra_info.information_type%type
78 ,object_version_number per_position_extra_info.object_version_number%type
79 ,last_update_date per_position_extra_info.last_update_date%type
80 ,last_updated_by per_position_extra_info.last_updated_by%type
81 ,last_update_login per_position_extra_info.last_update_login%type
82 ,created_by per_position_extra_info.created_by%type
83 ,creation_date per_position_extra_info.creation_date%type
84 );
85
86 TYPE c_extra_info_type IS REF CURSOR RETURN r_short_extra_info_type;
87
88 TYPE r_extra_info_tab_type IS TABLE OF r_extra_info_type
89 INDEX BY BINARY_INTEGER;
90 r_extra_info_tab r_extra_info_tab_type;
91
92 -- -----------------------
93 FUNCTION OPEN_FETCH_CURSOR (
94 -- -----------------------
95 p_form_name in varchar2
96 ,p_date_effective in out date
97 ,p_id in out number
98 ,p_information_type in out varchar2
99 )
100 RETURN NUMBER;
101
102 -- -----------------------
103 FUNCTION FETCH_CURSOR(
104 -- -----------------------
105 p_extra_info_id out number
106 ,p_id out number
107 ,p_information_type out varchar2
108 ,p_request_id out number
109 ,p_program_application_id out number
110 ,p_program_id out number
111 ,p_program_update_date out date
112 ,p_attribute_category out varchar2
113 ,p_attribute1 out varchar2
114 ,p_attribute2 out varchar2
115 ,p_attribute3 out varchar2
116 ,p_attribute4 out varchar2
117 ,p_attribute5 out varchar2
118 ,p_attribute6 out varchar2
119 ,p_attribute7 out varchar2
120 ,p_attribute8 out varchar2
121 ,p_attribute9 out varchar2
122 ,p_attribute10 out varchar2
123 ,p_attribute11 out varchar2
124 ,p_attribute12 out varchar2
125 ,p_attribute13 out varchar2
126 ,p_attribute14 out varchar2
127 ,p_attribute15 out varchar2
128 ,p_attribute16 out varchar2
129 ,p_attribute17 out varchar2
130 ,p_attribute18 out varchar2
131 ,p_attribute19 out varchar2
132 ,p_attribute20 out varchar2
133 ,p_information_category out varchar2
134 ,p_information1 out varchar2
135 ,p_information2 out varchar2
136 ,p_information3 out varchar2
137 ,p_information4 out varchar2
138 ,p_information5 out varchar2
139 ,p_information6 out varchar2
140 ,p_information7 out varchar2
141 ,p_information8 out varchar2
142 ,p_information9 out varchar2
143 ,p_information10 out varchar2
144 ,p_information11 out varchar2
145 ,p_information12 out varchar2
146 ,p_information13 out varchar2
147 ,p_information14 out varchar2
148 ,p_information15 out varchar2
149 ,p_information16 out varchar2
150 ,p_information17 out varchar2
151 ,p_information18 out varchar2
152 ,p_information19 out varchar2
153 ,p_information20 out varchar2
154 ,p_information21 out varchar2
155 ,p_information22 out varchar2
156 ,p_information23 out varchar2
157 ,p_information24 out varchar2
158 ,p_information25 out varchar2
159 ,p_information26 out varchar2
160 ,p_information27 out varchar2
161 ,p_information28 out varchar2
162 ,p_information29 out varchar2
163 ,p_information30 out varchar2
164 ,p_object_version_number out number
165 ,p_last_update_date out date
166 ,p_last_updated_by out number
167 ,p_last_update_login out number
168 ,p_created_by out number
169 ,p_creation_date out date
170 )
171 RETURN VARCHAR2;
172 -- -----------------------
173 PROCEDURE CLOSE_CURSOR(
174 -- -----------------------
175 c_extra_info IN OUT c_extra_info_type
176 );
177 END;