[Home] [Help]
PACKAGE: APPS.HR_TEMPLATE_ITEM_INFO
Source
1 PACKAGE hr_template_item_info
2 /* $Header: hrtiminf.pkh 120.0 2005/05/31 03:14:07 appldev noship $ */
3 AS
4 --
5 -- Global types
6 --
7 TYPE t_template_item IS RECORD
8 (template_item_id hr_template_items_b.template_item_id%TYPE
9 ,full_item_name hr_form_items_b.full_item_name%TYPE
10 ,item_type hr_form_items_b.item_type%TYPE
11 ,window_name hr_form_windows_b.window_name%TYPE
12 ,canvas_name hr_form_canvases_b.canvas_name%TYPE
13 ,tab_page_name hr_form_tab_pages_b.tab_page_name%TYPE
14 ,radio_button_name hr_form_items_b.radio_button_name%TYPE
15 ,alignment hr_item_properties_b.alignment%TYPE
16 ,bevel hr_item_properties_b.bevel%TYPE
17 ,case_restriction hr_item_properties_b.case_restriction%TYPE
18 ,default_value hr_item_properties_tl.default_value%TYPE
19 ,enabled hr_item_properties_b.enabled%TYPE
20 ,format_mask hr_item_properties_b.format_mask%TYPE
21 ,height hr_item_properties_b.height%TYPE
22 ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
23 ,information_parameter_item1 hr_form_items_b.full_item_name%TYPE
24 ,information_parameter_item2 hr_form_items_b.full_item_name%TYPE
25 ,information_parameter_item3 hr_form_items_b.full_item_name%TYPE
26 ,information_parameter_item4 hr_form_items_b.full_item_name%TYPE
27 ,information_parameter_item5 hr_form_items_b.full_item_name%TYPE
28 ,information_prompt hr_item_properties_tl.information_prompt%TYPE
29 ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
30 ,label hr_item_properties_tl.label%TYPE
31 ,next_navigation_item hr_form_items_b.full_item_name%TYPE
32 ,previous_navigation_item hr_form_items_b.full_item_name%TYPE
33 ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
34 ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
35 ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
36 ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
37 ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
38 ,prompt_text hr_item_properties_tl.prompt_text%TYPE
39 ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
40 ,query_allowed hr_item_properties_b.query_allowed%TYPE
41 ,required hr_item_properties_b.required%TYPE
42 ,tooltip_text hr_item_properties_tl.tooltip_text%TYPE
43 ,update_allowed hr_item_properties_b.update_allowed%TYPE
44 ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
45 ,validation_parameter_item1 hr_form_items_b.full_item_name%TYPE
46 ,validation_parameter_item2 hr_form_items_b.full_item_name%TYPE
47 ,validation_parameter_item3 hr_form_items_b.full_item_name%TYPE
48 ,validation_parameter_item4 hr_form_items_b.full_item_name%TYPE
49 ,validation_parameter_item5 hr_form_items_b.full_item_name%TYPE
50 ,visible hr_item_properties_b.visible%TYPE
51 ,width hr_item_properties_b.width%TYPE
52 ,x_position hr_item_properties_b.x_position%TYPE
53 ,y_position hr_item_properties_b.y_position%TYPE
54 ,information_category hr_item_properties_b.information_category%TYPE
55 ,information1 hr_item_properties_b.information1%TYPE
56 ,information2 hr_item_properties_b.information2%TYPE
57 ,information3 hr_item_properties_b.information3%TYPE
58 ,information4 hr_item_properties_b.information4%TYPE
59 ,information5 hr_item_properties_b.information5%TYPE
60 ,information6 hr_item_properties_b.information6%TYPE
61 ,information7 hr_item_properties_b.information7%TYPE
62 ,information8 hr_item_properties_b.information8%TYPE
63 ,information9 hr_item_properties_b.information9%TYPE
64 ,information10 hr_item_properties_b.information10%TYPE
65 ,information11 hr_item_properties_b.information11%TYPE
66 ,information12 hr_item_properties_b.information12%TYPE
67 ,information13 hr_item_properties_b.information13%TYPE
68 ,information14 hr_item_properties_b.information14%TYPE
69 ,information15 hr_item_properties_b.information15%TYPE
70 ,information16 hr_item_properties_b.information16%TYPE
71 ,information17 hr_item_properties_b.information17%TYPE
72 ,information18 hr_item_properties_b.information18%TYPE
73 ,information19 hr_item_properties_b.information19%TYPE
74 ,information20 hr_item_properties_b.information20%TYPE
75 ,information21 hr_item_properties_b.information21%TYPE
76 ,information22 hr_item_properties_b.information22%TYPE
77 ,information23 hr_item_properties_b.information23%TYPE
78 ,information24 hr_item_properties_b.information24%TYPE
79 ,information25 hr_item_properties_b.information25%TYPE
80 ,information26 hr_item_properties_b.information26%TYPE
81 ,information27 hr_item_properties_b.information27%TYPE
82 ,information28 hr_item_properties_b.information28%TYPE
83 ,information29 hr_item_properties_b.information29%TYPE
84 ,information30 hr_item_properties_b.information30%TYPE
85 );
86 TYPE t_template_items IS TABLE OF t_template_item;
87 TYPE t_template_items_pst IS TABLE OF t_template_item INDEX BY BINARY_INTEGER;
88 --
89 -- -----------------------------------------------------------------------------
90 -- |-----------------------------< template_items >----------------------------|
91 -- -----------------------------------------------------------------------------
92 -- {Start of Comments}
93 --
94 -- Description
95 -- This function returns a table containing the details of all items for a
96 -- template.
97 --
98 -- Prerequisites
99 -- None.
100 --
101 -- In Parameters
102 -- p_form_template_id Y number Form template identifier
103 --
104 -- Post Success
105 -- A table containing the details of the template items is returned
106 --
107 -- Post Failure
108 -- An error is raised
109 --
110 -- Access Status
111 -- Internal Development Use Only
112 --
113 -- {End of Comments}
114 -- -----------------------------------------------------------------------------
115 FUNCTION template_items
116 (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
117 )
118 RETURN t_template_items;
119 --
120 -- -----------------------------------------------------------------------------
121 -- |---------------------------< template_items_pst >--------------------------|
122 -- -----------------------------------------------------------------------------
123 -- {Start of Comments}
124 --
125 -- Description
126 -- This function returns a table containing the details of all items for a
127 -- template. A PL/SQL table is returned so it may be correctly retrieved by
128 -- procedures within a Forms Application. Forms 6 cannot retrieve nested
129 -- tables from server-side packages.
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 items 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_items_pst
149 (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
150 )
151 RETURN t_template_items_pst;
152 --
153 END hr_template_item_info;