[Home] [Help]
PACKAGE: APPS.HR_TEMPLATE_ITEM_CONTEXT_INFO
Source
1 PACKAGE hr_template_item_context_info
2 /* $Header: hrticinf.pkh 120.0 2005/05/31 03:10:04 appldev noship $ */
3 AS
4 --
5 -- Global types
6 --
7 TYPE t_template_item_context IS RECORD
8 (template_item_context_id hr_template_item_contexts_b.template_item_context_id%TYPE
9 ,template_item_id hr_template_items_b.template_item_id%TYPE
10 ,full_item_name hr_form_items_b.full_item_name%TYPE
11 ,item_type hr_form_items_b.item_type%TYPE
12 ,window_name hr_form_windows_b.window_name%TYPE
13 ,canvas_name hr_form_canvases_b.canvas_name%TYPE
14 ,tab_page_name hr_form_tab_pages_b.tab_page_name%TYPE
15 ,radio_button_name hr_form_items_b.radio_button_name%TYPE
16 ,context_type hr_template_item_contexts_b.context_type%TYPE
17 ,segment1 hr_item_contexts.segment1%TYPE
18 ,segment2 hr_item_contexts.segment2%TYPE
19 ,segment3 hr_item_contexts.segment3%TYPE
20 ,segment4 hr_item_contexts.segment4%TYPE
21 ,segment5 hr_item_contexts.segment5%TYPE
22 ,segment6 hr_item_contexts.segment6%TYPE
23 ,segment7 hr_item_contexts.segment7%TYPE
24 ,segment8 hr_item_contexts.segment8%TYPE
25 ,segment9 hr_item_contexts.segment9%TYPE
26 ,segment10 hr_item_contexts.segment10%TYPE
27 ,segment11 hr_item_contexts.segment11%TYPE
28 ,segment12 hr_item_contexts.segment12%TYPE
29 ,segment13 hr_item_contexts.segment13%TYPE
30 ,segment14 hr_item_contexts.segment14%TYPE
31 ,segment15 hr_item_contexts.segment15%TYPE
32 ,segment16 hr_item_contexts.segment16%TYPE
33 ,segment17 hr_item_contexts.segment17%TYPE
34 ,segment18 hr_item_contexts.segment18%TYPE
35 ,segment19 hr_item_contexts.segment19%TYPE
36 ,segment20 hr_item_contexts.segment20%TYPE
37 ,segment21 hr_item_contexts.segment21%TYPE
38 ,segment22 hr_item_contexts.segment22%TYPE
39 ,segment23 hr_item_contexts.segment23%TYPE
40 ,segment24 hr_item_contexts.segment24%TYPE
41 ,segment25 hr_item_contexts.segment25%TYPE
42 ,segment26 hr_item_contexts.segment26%TYPE
43 ,segment27 hr_item_contexts.segment27%TYPE
44 ,segment28 hr_item_contexts.segment28%TYPE
45 ,segment29 hr_item_contexts.segment29%TYPE
46 ,segment30 hr_item_contexts.segment30%TYPE
47 ,alignment hr_item_properties_b.alignment%TYPE
48 ,bevel hr_item_properties_b.bevel%TYPE
49 ,case_restriction hr_item_properties_b.case_restriction%TYPE
50 ,default_value hr_item_properties_tl.default_value%TYPE
51 ,enabled hr_item_properties_b.enabled%TYPE
52 ,format_mask hr_item_properties_b.format_mask%TYPE
53 ,height hr_item_properties_b.height%TYPE
54 ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
55 ,information_parameter_item1 hr_form_items_b.full_item_name%TYPE
56 ,information_parameter_item2 hr_form_items_b.full_item_name%TYPE
57 ,information_parameter_item3 hr_form_items_b.full_item_name%TYPE
58 ,information_parameter_item4 hr_form_items_b.full_item_name%TYPE
59 ,information_parameter_item5 hr_form_items_b.full_item_name%TYPE
60 ,information_prompt hr_item_properties_tl.information_prompt%TYPE
61 ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
62 ,label hr_item_properties_tl.label%TYPE
63 ,next_navigation_item hr_form_items_b.full_item_name%TYPE
64 ,previous_navigation_item hr_form_items_b.full_item_name%TYPE
65 ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
66 ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
67 ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
68 ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
69 ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
70 ,prompt_text hr_item_properties_tl.prompt_text%TYPE
71 ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
72 ,query_allowed hr_item_properties_b.query_allowed%TYPE
73 ,required hr_item_properties_b.required%TYPE
74 ,tooltip_text hr_item_properties_tl.tooltip_text%TYPE
75 ,update_allowed hr_item_properties_b.update_allowed%TYPE
76 ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
77 ,validation_parameter_item1 hr_form_items_b.full_item_name%TYPE
78 ,validation_parameter_item2 hr_form_items_b.full_item_name%TYPE
79 ,validation_parameter_item3 hr_form_items_b.full_item_name%TYPE
80 ,validation_parameter_item4 hr_form_items_b.full_item_name%TYPE
81 ,validation_parameter_item5 hr_form_items_b.full_item_name%TYPE
82 ,visible hr_item_properties_b.visible%TYPE
83 ,width hr_item_properties_b.width%TYPE
84 ,x_position hr_item_properties_b.x_position%TYPE
85 ,y_position hr_item_properties_b.y_position%TYPE
86 ,information_category hr_item_properties_b.information_category%TYPE
87 ,information1 hr_item_properties_b.information1%TYPE
88 ,information2 hr_item_properties_b.information2%TYPE
89 ,information3 hr_item_properties_b.information3%TYPE
90 ,information4 hr_item_properties_b.information4%TYPE
91 ,information5 hr_item_properties_b.information5%TYPE
92 ,information6 hr_item_properties_b.information6%TYPE
93 ,information7 hr_item_properties_b.information7%TYPE
94 ,information8 hr_item_properties_b.information8%TYPE
95 ,information9 hr_item_properties_b.information9%TYPE
96 ,information10 hr_item_properties_b.information10%TYPE
97 ,information11 hr_item_properties_b.information11%TYPE
98 ,information12 hr_item_properties_b.information12%TYPE
99 ,information13 hr_item_properties_b.information13%TYPE
100 ,information14 hr_item_properties_b.information14%TYPE
101 ,information15 hr_item_properties_b.information15%TYPE
102 ,information16 hr_item_properties_b.information16%TYPE
103 ,information17 hr_item_properties_b.information17%TYPE
104 ,information18 hr_item_properties_b.information18%TYPE
105 ,information19 hr_item_properties_b.information19%TYPE
106 ,information20 hr_item_properties_b.information20%TYPE
107 ,information21 hr_item_properties_b.information21%TYPE
108 ,information22 hr_item_properties_b.information22%TYPE
109 ,information23 hr_item_properties_b.information23%TYPE
110 ,information24 hr_item_properties_b.information24%TYPE
111 ,information25 hr_item_properties_b.information25%TYPE
112 ,information26 hr_item_properties_b.information26%TYPE
113 ,information27 hr_item_properties_b.information27%TYPE
114 ,information28 hr_item_properties_b.information28%TYPE
115 ,information29 hr_item_properties_b.information29%TYPE
116 ,information30 hr_item_properties_b.information30%TYPE
117 ,deleted hr_form_items_b.full_item_name%TYPE
118 );
119 TYPE t_template_item_contexts IS TABLE OF t_template_item_context;
120 TYPE t_template_item_contexts_pst IS TABLE OF t_template_item_context INDEX BY BINARY_INTEGER;
121 --
122 -- -----------------------------------------------------------------------------
123 -- |-------------------------< template_item_contexts >------------------------|
124 -- -----------------------------------------------------------------------------
125 -- {Start of Comments}
126 --
127 -- Description
128 -- This function returns a table containing the details of all item contexts
129 -- for a template.
130 --
131 -- Prerequisites
132 -- None.
133 --
134 -- In Parameters
135 -- p_form_template_id Y number Form template identifier
136 --
137 -- Post Success
138 -- A table containing the details of the template item contexts is returned
139 --
140 -- Post Failure
141 -- An error is raised
142 --
143 -- Access Status
144 -- Internal Development Use Only
145 --
146 -- {End of Comments}
147 -- -----------------------------------------------------------------------------
148 FUNCTION template_item_contexts
149 (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
150 )
151 RETURN t_template_item_contexts;
152 --
153 -- -----------------------------------------------------------------------------
154 -- |-----------------------< template_item_contexts_pst >----------------------|
155 -- -----------------------------------------------------------------------------
156 -- {Start of Comments}
157 --
158 -- Description
159 -- This function returns a table containing the details of all item contexts
160 -- for a template. A PL/SQL table is returned so it may be correctly retrieved
161 -- by procedures within a Forms Application. Forms 6 cannot retrieve nested
162 -- tables from server-side packages.
163 --
164 -- Prerequisites
165 -- None.
166 --
167 -- In Parameters
168 -- p_form_template_id Y number Form template identifier
169 --
170 -- Post Success
171 -- A table containing the details of the template item contexts is returned
172 --
173 -- Post Failure
174 -- An error is raised
175 --
176 -- Access Status
177 -- Internal Development Use Only
178 --
179 -- {End of Comments}
180 -- -----------------------------------------------------------------------------
181 FUNCTION template_item_contexts_pst
182 (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
183 )
184 RETURN t_template_item_contexts_pst;
185 --
186 END hr_template_item_context_info;