DBA Data[Home] [Help]

PACKAGE: APPS.HR_FORM_TAB_PAGE_INFO

Source


1 PACKAGE hr_form_tab_page_info
2 /* $Header: hrftpinf.pkh 120.0 2005/05/31 00:30:47 appldev noship $ */
3 AS
4   --
5   -- Global types
6   --
7   TYPE t_form_tab_page IS RECORD
8     (form_tab_page_id               hr_form_tab_pages_b.form_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_form_tab_pages IS TABLE OF t_form_tab_page;
48 --
49 -- -----------------------------------------------------------------------------
50 -- |-----------------------------< form_tab_pages >----------------------------|
51 -- -----------------------------------------------------------------------------
52 -- {Start of Comments}
53 --
54 -- Description
55 --   This function returns a table containing the details of all tab pages for a
56 --   form.
57 --
58 -- Prerequisites
59 --   None.
60 --
61 -- In Parameters
62 --   p_application_id               Y number   Application identifier
63 --   p_form_id                      Y number   Form identifier
64 --
65 -- Post Success
66 --   A table containing the details of the form 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 form_tab_pages
77   (p_application_id               IN     fnd_application.application_id%TYPE
78   ,p_form_id                      IN     fnd_form.form_id%TYPE
79   )
80 RETURN t_form_tab_pages;
81 --
82 END hr_form_tab_page_info;