[Home] [Help]
PACKAGE: APPS.PSB_WS_MATRIX
Source
1 PACKAGE PSB_WS_MATRIX AUTHID CURRENT_USER as
2 /* $Header: PSBVWSMS.pls 115.10 2003/11/28 16:51:00 vbellur ship $ */
3 ------------------------------------------------------------------------------------------
4 -- Element Lines
5 ------------------------------------------------------------------------------------------
6
7 -- Declare
8 TYPE ws_line_year_rec_type IS RECORD
9 ( stage NUMBER,
10 /*For Bug No : 1756051 Start*/
11 account_flag VARCHAR2(1),
12 /*For Bug No : 1756051 End*/
13 c1_year_id NUMBER,
14 c2_year_id NUMBER,
15 c3_year_id NUMBER,
16 c4_year_id NUMBER,
17 c5_year_id NUMBER,
18 c6_year_id NUMBER,
19 c7_year_id NUMBER,
20 c8_year_id NUMBER,
21 c9_year_id NUMBER,
22 c10_year_id NUMBER,
23 c11_year_id NUMBER,
24 c12_year_id NUMBER,
25 c1_amount_type VARCHAR2(1),
26 c2_amount_type VARCHAR2(1),
27 c3_amount_type VARCHAR2(1),
28 c4_amount_type VARCHAR2(1),
29 c5_amount_type VARCHAR2(1),
30 c6_amount_type VARCHAR2(1),
31 c7_amount_type VARCHAR2(1),
32 c8_amount_type VARCHAR2(1),
33 c9_amount_type VARCHAR2(1),
34 c10_amount_type VARCHAR2(1),
35 c11_amount_type VARCHAR2(1),
36 c12_amount_type VARCHAR2(1),
37 /*For Bug No : 2708720 Start*/
38 total_flag VARCHAR2(1));
39 /*For Bug No : 2708720 End*/
40
41 ws_line_year_rec ws_line_year_rec_type;
42
43 TYPE ws_line_period_rec_type IS RECORD
44 ( stage NUMBER,
45 period1 NUMBER,
46 period2 NUMBER,
47 period3 NUMBER,
48 period4 NUMBER,
49 period5 NUMBER,
50 period6 NUMBER,
51 period7 NUMBER,
52 period8 NUMBER,
53 period9 NUMBER,
54 period10 NUMBER,
55 period11 NUMBER,
56 period12 NUMBER );
57
58 ws_line_period_rec ws_line_period_rec_type;
59
60 PROCEDURE Set_Form_WS_Line_Years
61 (
62 /* For Bug No. 3206280, added session_id and worksheet_id parameters */
63 p_session_id IN NUMBER,
64 p_worksheet_id IN NUMBER,
65 p_modify_ws IN VARCHAR2 := 'N',
66 p_stage IN NUMBER,
67 /*For Bug No : 1756051 Start*/
68 p_account_flag IN VARCHAR2,
69 /*For Bug No : 1756051 End*/
70 p1_year_id IN NUMBER,
71 p2_year_id IN NUMBER,
72 p3_year_id IN NUMBER,
73 p4_year_id IN NUMBER,
74 p5_year_id IN NUMBER,
75 p6_year_id IN NUMBER,
76 p7_year_id IN NUMBER,
77 p8_year_id IN NUMBER,
78 p9_year_id IN NUMBER,
79 p10_year_id IN NUMBER,
80 p11_year_id IN NUMBER,
81 p12_year_id IN NUMBER,
82 p1_amount_type IN VARCHAR2,
83 p2_amount_type IN VARCHAR2,
84 p3_amount_type IN VARCHAR2,
85 p4_amount_type IN VARCHAR2,
86 p5_amount_type IN VARCHAR2,
87 p6_amount_type IN VARCHAR2,
88 p7_amount_type IN VARCHAR2,
89 p8_amount_type IN VARCHAR2,
90 p9_amount_type IN VARCHAR2,
91 p10_amount_type IN VARCHAR2,
92 p11_amount_type IN VARCHAR2,
93 p12_amount_type IN VARCHAR2,
94 p_total_flag IN VARCHAR2 := 'N'
95 );
96
97 PROCEDURE Set_WS_Line_Years
98 ( p_ws_line_year_rec IN ws_line_year_rec_type
99 );
100
101 FUNCTION Display_year_id RETURN NUMBER;
102 FUNCTION Display_year_type RETURN VARCHAR2;
103
104 FUNCTION Amount_OR_FTE
105 (p_budget_year_id IN NUMBER,
106 p_amount_type IN VARCHAR2,
107 p_rec_year_id IN NUMBER,
108 p_rec_amount_type IN VARCHAR2
109 ) RETURN VARCHAR2;
110 pragma RESTRICT_REFERENCES (Amount_OR_FTE, WNDS, WNPS );
111
112 FUNCTION Get_WS_Line_Year_ST RETURN VARCHAR2;
113 pragma RESTRICT_REFERENCES (Get_WS_Line_Year_ST, WNDS, WNPS );
114
115 -- Define Procedure to Set Variables from forms
116 -- where records are not supported.
117 -- (Forms uses older version of PL/SQL)
118
119 -- Define Functions to pass variable values to Views
120
121 FUNCTION Get_WS_Line_YearC1 (p_budget_year_id IN NUMBER, p_amount_type IN VARCHAR2) RETURN VARCHAR2;
122 pragma RESTRICT_REFERENCES ( Get_WS_Line_YearC1, WNDS, WNPS );
123
124 FUNCTION Get_WS_Line_YearC2 (p_budget_year_id IN NUMBER, p_amount_type IN VARCHAR2) RETURN VARCHAR2;
125 pragma RESTRICT_REFERENCES ( Get_WS_Line_YearC2, WNDS, WNPS );
126
127 FUNCTION Get_WS_Line_YearC3 (p_budget_year_id IN NUMBER, p_amount_type IN VARCHAR2) RETURN VARCHAR2;
128 pragma RESTRICT_REFERENCES ( Get_WS_Line_YearC3, WNDS, WNPS );
129
130 FUNCTION Get_WS_Line_YearC4 (p_budget_year_id IN NUMBER, p_amount_type IN VARCHAR2) RETURN VARCHAR2;
131 pragma RESTRICT_REFERENCES ( Get_WS_Line_YearC4, WNDS, WNPS );
132
133 FUNCTION Get_WS_Line_YearC5 (p_budget_year_id IN NUMBER, p_amount_type IN VARCHAR2) RETURN VARCHAR2;
134 pragma RESTRICT_REFERENCES ( Get_WS_Line_YearC5, WNDS, WNPS );
135
136 FUNCTION Get_WS_Line_YearC6 (p_budget_year_id IN NUMBER, p_amount_type IN VARCHAR2) RETURN VARCHAR2;
137 pragma RESTRICT_REFERENCES ( Get_WS_Line_YearC6, WNDS, WNPS );
138
139 FUNCTION Get_WS_Line_YearC7 (p_budget_year_id IN NUMBER, p_amount_type IN VARCHAR2) RETURN VARCHAR2;
140 pragma RESTRICT_REFERENCES ( Get_WS_Line_YearC7, WNDS, WNPS );
141
142 FUNCTION Get_WS_Line_YearC8 (p_budget_year_id IN NUMBER, p_amount_type IN VARCHAR2) RETURN VARCHAR2;
143 pragma RESTRICT_REFERENCES ( Get_WS_Line_YearC8, WNDS, WNPS );
144
145 FUNCTION Get_WS_Line_YearC9 (p_budget_year_id IN NUMBER, p_amount_type IN VARCHAR2) RETURN VARCHAR2;
146 pragma RESTRICT_REFERENCES ( Get_WS_Line_YearC9, WNDS, WNPS );
147
148 FUNCTION Get_WS_Line_YearC10 (p_budget_year_id IN NUMBER, p_amount_type IN VARCHAR2) RETURN VARCHAR2;
149 pragma RESTRICT_REFERENCES ( Get_WS_Line_YearC10, WNDS, WNPS );
150
151 FUNCTION Get_WS_Line_YearC11 (p_budget_year_id IN NUMBER, p_amount_type IN VARCHAR2) RETURN VARCHAR2;
152 pragma RESTRICT_REFERENCES ( Get_WS_Line_YearC11, WNDS, WNPS );
153
154 FUNCTION Get_WS_Line_YearC12 (p_budget_year_id IN NUMBER, p_amount_type IN VARCHAR2) RETURN VARCHAR2;
155 pragma RESTRICT_REFERENCES ( Get_WS_Line_YearC12, WNDS, WNPS );
156
157 PROCEDURE Set_WS_Line_Periods
158 (p_ws_line_period_rec IN ws_line_period_rec_type
159 );
160
161 PROCEDURE Set_Form_WS_Line_Periods
162 (p_stage IN NUMBER
163 );
164
165 FUNCTION Get_WS_Line_Period_ST RETURN NUMBER;
166 pragma RESTRICT_REFERENCES (Get_WS_Line_Period_ST, WNDS, WNPS );
167
168 FUNCTION Get_WS_Line_Period1 RETURN NUMBER;
169
170 FUNCTION Get_WS_Line_Period2 RETURN NUMBER;
171
172 FUNCTION Get_WS_Line_Period3 RETURN NUMBER;
173
174 FUNCTION Get_WS_Line_Period4 RETURN NUMBER;
175
176 FUNCTION Get_WS_Line_Period5 RETURN NUMBER;
177
178 FUNCTION Get_WS_Line_Period6 RETURN NUMBER;
179
180 FUNCTION Get_WS_Line_Period7 RETURN NUMBER;
181
182 FUNCTION Get_WS_Line_Period8 RETURN NUMBER;
183
184 FUNCTION Get_WS_Line_Period9 RETURN NUMBER;
185
186 FUNCTION Get_WS_Line_Period10 RETURN NUMBER;
187
188 FUNCTION Get_WS_Line_Period11 RETURN NUMBER;
189
190 FUNCTION Get_WS_Line_Period12 RETURN NUMBER;
191
192 /*For Bug No : 2708720 Start*/
193 PROCEDURE Set_Total_Flag(p_total_flag IN VARCHAR2);
194 FUNCTION Get_Total_Flag RETURN VARCHAR2;
195 /*For Bug No : 2708720 End*/
196 /*For Bug No : 1756051 Start*/
197 FUNCTION Get_Account_Flag RETURN VARCHAR2;
198 /*For Bug No : 1756051 End*/
199
200 /* Added the following procedure for bug 3206280 */
201 PROCEDURE Delete_Session_Information
202 (
203 p_worksheet_id IN NUMBER,
204 p_session_id IN NUMBER
205 );
206
207 END PSB_WS_MATRIX;