[Home] [Help]
PACKAGE: APPS.HR_TEMPLATE_TAB_PAGE_INFO
Source
1 PACKAGE hr_template_tab_page_info
2 /* $Header: hrttpinf.pkh 120.0 2005/05/31 03:33:54 appldev noship $ */
3 AS
4 --
5 -- Global types
6 --
7 TYPE t_template_tab_page IS RECORD
8 (template_tab_page_id hr_template_tab_pages_b.template_tab_page_id%TYPE
9 ,tab_page_name hr_form_tab_pages_b.tab_page_name%TYPE
10 ,canvas_name hr_form_canvases_b.canvas_name%TYPE
11 ,display_order hr_form_tab_pages_b.display_order%TYPE
12 ,label hr_tab_page_properties_tl.label%TYPE
13 ,navigation_direction hr_tab_page_properties_b.navigation_direction%TYPE
14 ,visible hr_tab_page_properties_b.visible%TYPE
15 ,information_category hr_tab_page_properties_b.information_category%TYPE
16 ,information1 hr_tab_page_properties_b.information1%TYPE
17 ,information2 hr_tab_page_properties_b.information2%TYPE
18 ,information3 hr_tab_page_properties_b.information3%TYPE
19 ,information4 hr_tab_page_properties_b.information4%TYPE
20 ,information5 hr_tab_page_properties_b.information5%TYPE
21 ,information6 hr_tab_page_properties_b.information6%TYPE
22 ,information7 hr_tab_page_properties_b.information7%TYPE
23 ,information8 hr_tab_page_properties_b.information8%TYPE
24 ,information9 hr_tab_page_properties_b.information9%TYPE
25 ,information10 hr_tab_page_properties_b.information10%TYPE
26 ,information11 hr_tab_page_properties_b.information11%TYPE
27 ,information12 hr_tab_page_properties_b.information12%TYPE
28 ,information13 hr_tab_page_properties_b.information13%TYPE
29 ,information14 hr_tab_page_properties_b.information14%TYPE
30 ,information15 hr_tab_page_properties_b.information15%TYPE
31 ,information16 hr_tab_page_properties_b.information16%TYPE
32 ,information17 hr_tab_page_properties_b.information17%TYPE
33 ,information18 hr_tab_page_properties_b.information18%TYPE
34 ,information19 hr_tab_page_properties_b.information19%TYPE
35 ,information20 hr_tab_page_properties_b.information20%TYPE
36 ,information21 hr_tab_page_properties_b.information21%TYPE
37 ,information22 hr_tab_page_properties_b.information22%TYPE
38 ,information23 hr_tab_page_properties_b.information23%TYPE
39 ,information24 hr_tab_page_properties_b.information24%TYPE
40 ,information25 hr_tab_page_properties_b.information25%TYPE
41 ,information26 hr_tab_page_properties_b.information26%TYPE
42 ,information27 hr_tab_page_properties_b.information27%TYPE
43 ,information28 hr_tab_page_properties_b.information28%TYPE
44 ,information29 hr_tab_page_properties_b.information29%TYPE
45 ,information30 hr_tab_page_properties_b.information30%TYPE
46 );
47 TYPE t_template_tab_pages IS TABLE OF t_template_tab_page;
48 TYPE t_template_tab_pages_pst IS TABLE OF t_template_tab_page INDEX BY BINARY_INTEGER;
49 --
50 -- -----------------------------------------------------------------------------
51 -- |---------------------------< template_tab_pages >--------------------------|
52 -- -----------------------------------------------------------------------------
53 -- {Start of Comments}
54 --
55 -- Description
56 -- This function returns a table containing the details of all tab pages for a
57 -- template.
58 --
59 -- Prerequisites
60 -- None.
61 --
62 -- In Parameters
63 -- p_form_template_id Y number Form template identifier
64 --
65 -- Post Success
66 -- A table containing the details of the template tab pages is returned
67 --
68 -- Post Failure
69 -- An error is raised
70 --
71 -- Access Status
72 -- Internal Development Use Only
73 --
74 -- {End of Comments}
75 -- -----------------------------------------------------------------------------
76 FUNCTION template_tab_pages
77 (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
78 )
79 RETURN t_template_tab_pages;
80 --
81 -- -----------------------------------------------------------------------------
82 -- |-------------------------< template_tab_pages_pst >------------------------|
83 -- -----------------------------------------------------------------------------
84 -- {Start of Comments}
85 --
86 -- Description
87 -- This function returns a table containing the details of all tab pages for
88 -- a template. A PL/SQL table is returned so it may be correctly retrieved by
89 -- procedures within a Forms Application. Forms 6 cannot retrieve nested
90 -- tables from server-side packages.
91 --
92 -- Prerequisites
93 -- None.
94 --
95 -- In Parameters
96 -- p_form_template_id Y number Form template identifier
97 --
98 -- Post Success
99 -- A table containing the details of the template tab pages is returned
100 --
101 -- Post Failure
102 -- An error is raised
103 --
104 -- Access Status
105 -- Internal Development Use Only
106 --
107 -- {End of Comments}
108 -- -----------------------------------------------------------------------------
109 FUNCTION template_tab_pages_pst
110 (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
111 )
112 RETURN t_template_tab_pages_pst;
113 --
114 END hr_template_tab_page_info;