PACKAGE: APPS.PSB_WS_ELEMENT_SETUP

Source

1 PACKAGE PSB_WS_ELEMENT_SETUP AUTHID CURRENT_USER as
2 /* $Header: PSBVWSES.pls 115.3 2002/11/22 07:39:20 pmamdaba ship $ */
3 ------------------------------------------------------------------------------------------
4 -- Element Lines
5 ------------------------------------------------------------------------------------------
6 
7 --  Declare
8 	c1_year	Number;
9 	c2_year	Number;
10 	c3_year	Number;
11 	c4_year	Number;
12 	c5_year	Number;
13 	c6_year	Number;
14 	c7_year	Number;
15 	c8_year	Number;
16 	c9_year	Number;
17 	c10_year	Number;
18 	c11_year	Number;
19 	c12_year	Number;
20 
21 --  Define Procedure to Set Variables from forms
22 --  where records are not supported.
23 --  (Forms uses older version of PL/SQL)
24 
25   PROCEDURE  Set_Form_WS_Element_Years
26   (
27     p1_year      IN     Number,
28     p2_year      IN     Number,
29     p3_year      IN     Number,
30     p4_year      IN     Number,
31     p5_year      IN     Number,
32     p6_year      IN     Number,
33     p7_year      IN     Number,
34     p8_year      IN     Number,
35     p9_year      IN     Number,
36     p10_year     IN     Number,
37     p11_year     IN     Number,
38     p12_year     IN     Number
39   );
40 
41  -- Define Functions to pass variable values to Views
42 
43    FUNCTION Get_WS_Element_YearC1	RETURN Number;
44      pragma RESTRICT_REFERENCES  ( Get_WS_Element_YearC1, WNDS, WNPS );
45 
46    FUNCTION Get_WS_Element_YearC2	RETURN Number;
47      pragma RESTRICT_REFERENCES  ( Get_WS_Element_YearC2, WNDS, WNPS );
48 
49    FUNCTION Get_WS_Element_YearC3	RETURN Number;
50      pragma RESTRICT_REFERENCES  ( Get_WS_Element_YearC3, WNDS, WNPS );
51 
52    FUNCTION Get_WS_Element_YearC4	RETURN Number;
53      pragma RESTRICT_REFERENCES  ( Get_WS_Element_YearC4, WNDS, WNPS );
54 
55    FUNCTION Get_WS_Element_YearC5	RETURN Number;
56      pragma RESTRICT_REFERENCES  ( Get_WS_Element_YearC5, WNDS, WNPS );
57 
58    FUNCTION Get_WS_Element_YearC6	RETURN Number;
59      pragma RESTRICT_REFERENCES  ( Get_WS_Element_YearC6, WNDS, WNPS );
60 
61    FUNCTION Get_WS_Element_YearC7	RETURN Number;
62      pragma RESTRICT_REFERENCES  ( Get_WS_Element_YearC7, WNDS, WNPS );
63 
64    FUNCTION Get_WS_Element_YearC8	RETURN Number;
65      pragma RESTRICT_REFERENCES  ( Get_WS_Element_YearC8, WNDS, WNPS );
66 
67    FUNCTION Get_WS_Element_YearC9	RETURN Number;
68      pragma RESTRICT_REFERENCES  ( Get_WS_Element_YearC9, WNDS, WNPS );
69 
70    FUNCTION Get_WS_Element_YearC10	RETURN Number;
71      pragma RESTRICT_REFERENCES  ( Get_WS_Element_YearC10, WNDS, WNPS );
72 
73    FUNCTION Get_WS_Element_YearC11	RETURN Number;
74      pragma RESTRICT_REFERENCES  ( Get_WS_Element_YearC11, WNDS, WNPS );
75 
76    FUNCTION Get_WS_Element_YearC12	RETURN Number;
77      pragma RESTRICT_REFERENCES  ( Get_WS_Element_YearC12, WNDS, WNPS );
78 
79 End psb_ws_element_setup;