DBA Data[Home] [Help]

PACKAGE: APPS.OE_LINE_ADJ_SECURITY

Source


1 PACKAGE OE_Line_Adj_Security AUTHID CURRENT_USER AS
2 /* $Header: OEXXLADS.pls 120.0 2005/06/01 02:52:19 appldev noship $ */
3 
4 
5 -- Package Globals
6 g_check_all_cols_constraint VARCHAR2(1) := 'Y';
7 g_is_caller_defaulting      VARCHAR2(1) := 'N';
8 -- Entity global record that is used in APIs for validation templates
9 -- and the generated validation packages to access attribute values
10 -- on the entity record
11 g_record				   OE_AK_LINE_PRCADJS_V%ROWTYPE;
12 
13 FUNCTION ATTRIBUTE1
14 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
15 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
16 , x_on_operation_action OUT NOCOPY NUMBER
17 
18 ) RETURN NUMBER;
19 
20 FUNCTION ATTRIBUTE10
21 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
22 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
23 , x_on_operation_action OUT NOCOPY NUMBER
24 
25 ) RETURN NUMBER;
26 
27 FUNCTION ATTRIBUTE11
28 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
29 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
30 , x_on_operation_action OUT NOCOPY NUMBER
31 
32 ) RETURN NUMBER;
33 
34 FUNCTION ATTRIBUTE12
35 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
36 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
37 , x_on_operation_action OUT NOCOPY NUMBER
38 
39 ) RETURN NUMBER;
40 
41 FUNCTION ATTRIBUTE13
42 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
43 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
44 , x_on_operation_action OUT NOCOPY NUMBER
45 
46 ) RETURN NUMBER;
47 
48 FUNCTION ATTRIBUTE14
49 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
50 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
51 , x_on_operation_action OUT NOCOPY NUMBER
52 
53 ) RETURN NUMBER;
54 
55 FUNCTION ATTRIBUTE15
56 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
57 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
58 , x_on_operation_action OUT NOCOPY NUMBER
59 
60 ) RETURN NUMBER;
61 
62 FUNCTION ATTRIBUTE2
63 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
64 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
65 , x_on_operation_action OUT NOCOPY NUMBER
66 
67 ) RETURN NUMBER;
68 
69 FUNCTION ATTRIBUTE3
70 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
71 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
72 , x_on_operation_action OUT NOCOPY NUMBER
73 
74 ) RETURN NUMBER;
75 
76 FUNCTION ATTRIBUTE4
77 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
78 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
79 , x_on_operation_action OUT NOCOPY NUMBER
80 
81 ) RETURN NUMBER;
82 
83 FUNCTION ATTRIBUTE5
84 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
85 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
86 , x_on_operation_action OUT NOCOPY NUMBER
87 
88 ) RETURN NUMBER;
89 
90 FUNCTION ATTRIBUTE6
91 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
92 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
93 , x_on_operation_action OUT NOCOPY NUMBER
94 
95 ) RETURN NUMBER;
96 
97 FUNCTION ATTRIBUTE7
98 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
99 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
100 , x_on_operation_action OUT NOCOPY NUMBER
101 
102 ) RETURN NUMBER;
103 
104 FUNCTION ATTRIBUTE8
105 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
106 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
107 , x_on_operation_action OUT NOCOPY NUMBER
108 
109 ) RETURN NUMBER;
110 
111 FUNCTION ATTRIBUTE9
112 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
113 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
114 , x_on_operation_action OUT NOCOPY NUMBER
115 
116 ) RETURN NUMBER;
117 
118 FUNCTION AUTOMATIC
119 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
120 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
121 , x_on_operation_action OUT NOCOPY NUMBER
122 
123 ) RETURN NUMBER;
124 
125 FUNCTION CONTEXT
126 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
127 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
128 , x_on_operation_action OUT NOCOPY NUMBER
129 
130 ) RETURN NUMBER;
131 
132 FUNCTION CREATED_BY
133 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
134 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
135 , x_on_operation_action OUT NOCOPY NUMBER
136 
137 ) RETURN NUMBER;
138 
139 FUNCTION CREATION_DATE
140 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
141 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
142 , x_on_operation_action OUT NOCOPY NUMBER
143 
144 ) RETURN NUMBER;
145 
146 FUNCTION DISCOUNT
147 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
148 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
149 , x_on_operation_action OUT NOCOPY NUMBER
150 
151 ) RETURN NUMBER;
152 
153 FUNCTION DISCOUNT_LINE
154 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
155 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
156 , x_on_operation_action OUT NOCOPY NUMBER
157 
158 ) RETURN NUMBER;
159 
160 FUNCTION HEADER
161 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
162 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
163 , x_on_operation_action OUT NOCOPY NUMBER
164 
165 ) RETURN NUMBER;
166 
167 FUNCTION LAST_UPDATED_BY
168 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
169 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
170 , x_on_operation_action OUT NOCOPY NUMBER
171 
172 ) RETURN NUMBER;
173 
174 FUNCTION LAST_UPDATE_DATE
175 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
176 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
177 , x_on_operation_action OUT NOCOPY NUMBER
178 
179 ) RETURN NUMBER;
180 
181 FUNCTION LAST_UPDATE_LOGIN
182 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
183 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
184 , x_on_operation_action OUT NOCOPY NUMBER
185 
186 ) RETURN NUMBER;
187 
188 FUNCTION LINE
189 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
190 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
191 , x_on_operation_action OUT NOCOPY NUMBER
192 
193 ) RETURN NUMBER;
194 
195 FUNCTION PERCENT
196 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
197 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
198 , x_on_operation_action OUT NOCOPY NUMBER
199 
200 ) RETURN NUMBER;
201 
202 FUNCTION PRICE_ADJUSTMENT
203 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
204 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
205 , x_on_operation_action OUT NOCOPY NUMBER
206 
207 ) RETURN NUMBER;
208 
209 FUNCTION PROGRAM_APPLICATION
210 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
211 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
212 , x_on_operation_action OUT NOCOPY NUMBER
213 
214 ) RETURN NUMBER;
215 
216 FUNCTION PROGRAM
217 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
218 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
219 , x_on_operation_action OUT NOCOPY NUMBER
220 
221 ) RETURN NUMBER;
222 
223 FUNCTION PROGRAM_UPDATE_DATE
224 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
225 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
226 , x_on_operation_action OUT NOCOPY NUMBER
227 
228 ) RETURN NUMBER;
229 
230 FUNCTION REQUEST
231 (   p_operation                     IN  VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
232 ,   p_record                        IN  OE_AK_LINE_PRCADJS_V%ROWTYPE
233 , x_on_operation_action OUT NOCOPY NUMBER
234 
235 ) RETURN NUMBER;
236 
237 PROCEDURE Entity
238 (   p_LINE_ADJ_rec                  IN  OE_Order_PUB.LINE_ADJ_Rec_Type
239 , x_result OUT NOCOPY NUMBER
240 
241 , x_return_status OUT NOCOPY VARCHAR2
242 
243 );
244 
245 PROCEDURE Attributes
246 (   p_LINE_ADJ_rec                  IN  OE_Order_PUB.LINE_ADJ_Rec_Type
247 ,   p_old_LINE_ADJ_rec              IN  OE_Order_PUB.LINE_ADJ_Rec_Type := OE_Order_PUB.G_MISS_LINE_ADJ_REC
248 , x_result OUT NOCOPY NUMBER
249 
250 , x_return_status OUT NOCOPY VARCHAR2
251 
252 );
253 
254 
255 END OE_Line_Adj_Security;