1 PACKAGE hr_form_stack_canvas_info
2 /* $Header: hrfscinf.pkh 120.0 2005/05/31 00:28:07 appldev noship $ */
3 AUTHID CURRENT_USER AS
4 --
5 -- Global types
6 --
7 TYPE t_form_stack_canvas IS RECORD
8 (form_stack_canvas_id hr_form_tab_stacked_canvases.form_tab_stacked_canvas_id%TYPE
9 ,canvas_name hr_form_canvases_b.canvas_name%TYPE
10 ,tab_page_name hr_form_tab_pages_b.tab_page_name%TYPE
11 ,stack_canvas_name hr_form_canvases_b.canvas_name%TYPE
12 );
13 TYPE t_form_stack_canvases IS TABLE OF t_form_stack_canvas;
14 --
15 -- -----------------------------------------------------------------------------
16 -- |--------------------------< form_stack_canvases >--------------------------|
17 -- -----------------------------------------------------------------------------
18 -- {Start of Comments}
19 --
20 -- Description
21 -- This function returns a table containing the details of all stacked
22 -- canvases for a form.
23 --
24 -- Prerequisites
25 -- None.
26 --
27 -- In Parameters
28 -- p_application_id Y number Application identifier
29 -- p_form_id Y number Form identifier
30 --
31 -- Post Success
32 -- A table containing the details of the form stacked canvases is returned
33 --
34 -- Post Failure
35 -- An error is raised
36 --
37 -- Access Status
38 -- Internal Development Use Only
39 --
40 -- {End of Comments}
41 -- -----------------------------------------------------------------------------
42 FUNCTION form_stack_canvases
43 (p_application_id IN fnd_application.application_id%TYPE
44 ,p_form_id IN fnd_form.form_id%TYPE
45 )
46 RETURN t_form_stack_canvases;
47 --
48 END hr_form_stack_canvas_info;