[Home] [Help]
PACKAGE: APPS.HR_FORM_ITEM_INFO
Source
1 PACKAGE hr_form_item_info
2 /* $Header: hrfiminf.pkh 115.4 2003/03/10 11:41:58 adhunter ship $ */
3 AUTHID CURRENT_USER AS
4 --
5 -- Global types
6 --
7 TYPE t_form_item IS RECORD
8 (form_item_id hr_form_items_b.form_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 ,canvas_name hr_form_canvases_b.canvas_name%TYPE
12 ,tab_page_name hr_form_tab_pages_b.tab_page_name%TYPE
13 ,radio_button_name hr_form_items_b.radio_button_name%TYPE
14 ,alignment hr_item_properties_b.alignment%TYPE
15 ,bevel hr_item_properties_b.bevel%TYPE
16 ,case_restriction hr_item_properties_b.case_restriction%TYPE
17 ,default_value hr_item_properties_tl.default_value%TYPE
18 ,enabled hr_item_properties_b.enabled%TYPE
19 ,format_mask hr_item_properties_b.format_mask%TYPE
20 ,height hr_item_properties_b.height%TYPE
21 ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
22 ,information_parameter_item1 hr_form_items_b.full_item_name%TYPE
23 ,information_parameter_item2 hr_form_items_b.full_item_name%TYPE
24 ,information_parameter_item3 hr_form_items_b.full_item_name%TYPE
25 ,information_parameter_item4 hr_form_items_b.full_item_name%TYPE
26 ,information_parameter_item5 hr_form_items_b.full_item_name%TYPE
27 ,information_prompt hr_item_properties_tl.information_prompt%TYPE
28 ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
29 ,label hr_item_properties_tl.label%TYPE
30 ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
31 ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
32 ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
33 ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
34 ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
35 ,prompt_text hr_item_properties_tl.prompt_text%TYPE
36 ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
37 ,query_allowed hr_item_properties_b.query_allowed%TYPE
38 ,required hr_item_properties_b.required%TYPE
39 ,tooltip_text hr_item_properties_tl.tooltip_text%TYPE
40 ,update_allowed hr_item_properties_b.update_allowed%TYPE
41 ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
42 ,validation_parameter_item1 hr_form_items_b.full_item_name%TYPE
43 ,validation_parameter_item2 hr_form_items_b.full_item_name%TYPE
44 ,validation_parameter_item3 hr_form_items_b.full_item_name%TYPE
45 ,validation_parameter_item4 hr_form_items_b.full_item_name%TYPE
46 ,validation_parameter_item5 hr_form_items_b.full_item_name%TYPE
47 ,visible hr_item_properties_b.visible%TYPE
48 ,width hr_item_properties_b.width%TYPE
49 ,x_position hr_item_properties_b.x_position%TYPE
50 ,y_position hr_item_properties_b.y_position%TYPE
51 ,information_category hr_item_properties_b.information_category%TYPE
52 ,information1 hr_item_properties_b.information1%TYPE
53 ,information2 hr_item_properties_b.information2%TYPE
54 ,information3 hr_item_properties_b.information3%TYPE
55 ,information4 hr_item_properties_b.information4%TYPE
56 ,information5 hr_item_properties_b.information5%TYPE
57 ,information6 hr_item_properties_b.information6%TYPE
58 ,information7 hr_item_properties_b.information7%TYPE
59 ,information8 hr_item_properties_b.information8%TYPE
60 ,information9 hr_item_properties_b.information9%TYPE
61 ,information10 hr_item_properties_b.information10%TYPE
62 ,information11 hr_item_properties_b.information11%TYPE
63 ,information12 hr_item_properties_b.information12%TYPE
64 ,information13 hr_item_properties_b.information13%TYPE
65 ,information14 hr_item_properties_b.information14%TYPE
66 ,information15 hr_item_properties_b.information15%TYPE
67 ,information16 hr_item_properties_b.information16%TYPE
68 ,information17 hr_item_properties_b.information17%TYPE
69 ,information18 hr_item_properties_b.information18%TYPE
70 ,information19 hr_item_properties_b.information19%TYPE
71 ,information20 hr_item_properties_b.information20%TYPE
72 ,information21 hr_item_properties_b.information21%TYPE
73 ,information22 hr_item_properties_b.information22%TYPE
74 ,information23 hr_item_properties_b.information23%TYPE
75 ,information24 hr_item_properties_b.information24%TYPE
76 ,information25 hr_item_properties_b.information25%TYPE
77 ,information26 hr_item_properties_b.information26%TYPE
78 ,information27 hr_item_properties_b.information27%TYPE
79 ,information28 hr_item_properties_b.information28%TYPE
80 ,information29 hr_item_properties_b.information29%TYPE
81 ,information30 hr_item_properties_b.information30%TYPE
82 );
83 TYPE t_form_items IS TABLE OF t_form_item;
84 --
85 -- -----------------------------------------------------------------------------
86 -- |-------------------------------< form_items >------------------------------|
87 -- -----------------------------------------------------------------------------
88 -- {Start of Comments}
89 --
90 -- Description
91 -- This function returns a table containing the details of all items for a
92 -- form.
93 --
94 -- Prerequisites
95 -- None.
96 --
97 -- In Parameters
98 -- p_application_id Y number Application identifier
99 -- p_form_id Y number Form identifier
100 --
101 -- Post Success
102 -- A table containing the details of the form items is returned
103 --
104 -- Post Failure
105 -- An error is raised
106 --
107 -- Access Status
108 -- Internal Development Use Only
109 --
110 -- {End of Comments}
111 -- -----------------------------------------------------------------------------
112 FUNCTION form_items
113 (p_application_id IN fnd_application.application_id%TYPE
114 ,p_form_id IN fnd_form.form_id%TYPE
115 )
116 RETURN t_form_items;
117 --
118 -- -----------------------------------------------------------------------------
119 -- |-----------------------------< full_item_name >----------------------------|
120 -- -----------------------------------------------------------------------------
121 -- {Start of Comments}
122 --
123 -- Description
124 -- This function returns the full item name for a form item.
125 --
126 -- Prerequisites
127 -- None.
128 --
129 -- In Parameters
130 -- p_form_item_id Y number Form item identifier
131 --
132 -- Post Success
133 -- The full item name of the form item is returned
134 --
135 -- Post Failure
136 -- An error is raised
137 --
138 -- Access Status
139 -- Internal Development Use Only
140 --
141 -- {End of Comments}
142 -- -----------------------------------------------------------------------------
143 FUNCTION full_item_name
144 (p_form_item_id IN hr_form_items_b.form_item_id%TYPE
145 )
146 RETURN hr_form_items_b.full_item_name%TYPE;
147 --
148 END hr_form_item_info;