[Home] [Help]
PACKAGE: APPS.QP_QP_FORM_LIMIT_BALANCES
Source
1 PACKAGE QP_QP_Form_Limit_Balances AUTHID CURRENT_USER AS
2 /* $Header: QPXFLMBS.pls 120.1 2005/06/13 03:35:25 appldev $ */
3
4 -- Procedure : Default_Attributes
5 --
6
7 PROCEDURE Default_Attributes
8 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
9 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
10 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
11 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
12 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
13 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
14 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
16 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
17 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
18 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
19 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
21 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
22 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
24 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26 , x_available_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
27 , x_consumed_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
28 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
29 , x_limit_balance_id OUT NOCOPY /* file.sql.39 change */ NUMBER
30 , x_limit_id OUT NOCOPY /* file.sql.39 change */ NUMBER
31 , x_multival_attr1_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
32 , x_multival_attr1_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33 , x_multival_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
34 , x_multival_attr1_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2
35 , x_multival_attr1_datatype OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36 , x_multival_attr2_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
37 , x_multival_attr2_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
38 , x_multival_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39 , x_multival_attr2_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2
40 , x_multival_attr2_datatype OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41 , x_organization_attr_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42 , x_organization_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2
43 , x_organization_attr_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2
44 , x_reserved_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
45 , x_limit_balance OUT NOCOPY /* file.sql.39 change */ VARCHAR2
46 , x_limit OUT NOCOPY /* file.sql.39 change */ VARCHAR2
47 );
48
49 -- Procedure : Change_Attribute
50 --
51
52 PROCEDURE Change_Attribute
53 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
54 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
55 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
56 , p_limit_balance_id IN NUMBER
57 , p_attr_id IN NUMBER
58 , p_attr_value IN VARCHAR2
59 , p_attribute1 IN VARCHAR2
60 , p_attribute10 IN VARCHAR2
61 , p_attribute11 IN VARCHAR2
62 , p_attribute12 IN VARCHAR2
63 , p_attribute13 IN VARCHAR2
64 , p_attribute14 IN VARCHAR2
65 , p_attribute15 IN VARCHAR2
66 , p_attribute2 IN VARCHAR2
67 , p_attribute3 IN VARCHAR2
68 , p_attribute4 IN VARCHAR2
69 , p_attribute5 IN VARCHAR2
70 , p_attribute6 IN VARCHAR2
71 , p_attribute7 IN VARCHAR2
72 , p_attribute8 IN VARCHAR2
73 , p_attribute9 IN VARCHAR2
74 , p_context IN VARCHAR2
75 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
76 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
78 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
79 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
80 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
81 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
83 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
87 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
88 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
89 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90 , x_available_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
91 , x_consumed_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
92 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
93 , x_limit_balance_id OUT NOCOPY /* file.sql.39 change */ NUMBER
94 , x_limit_id OUT NOCOPY /* file.sql.39 change */ NUMBER
95 , x_multival_attr1_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96 , x_multival_attr1_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97 , x_multival_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
98 , x_multival_attr1_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2
99 , x_multival_attr1_datatype OUT NOCOPY /* file.sql.39 change */ VARCHAR2
100 , x_multival_attr2_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
101 , x_multival_attr2_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102 , x_multival_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
103 , x_multival_attr2_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104 , x_multival_attr2_datatype OUT NOCOPY /* file.sql.39 change */ VARCHAR2
105 , x_organization_attr_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
106 , x_organization_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2
107 , x_organization_attr_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108 , x_reserved_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
109 , x_limit_balance OUT NOCOPY /* file.sql.39 change */ VARCHAR2
110 , x_limit OUT NOCOPY /* file.sql.39 change */ VARCHAR2
111 );
112
113 -- Procedure Validate_And_Write
114 --
115
116 PROCEDURE Validate_And_Write
117 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
118 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
119 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
120 , p_limit_balance_id IN NUMBER
121 , x_creation_date OUT NOCOPY /* file.sql.39 change */ DATE
122 , x_created_by OUT NOCOPY /* file.sql.39 change */ NUMBER
123 , x_last_update_date OUT NOCOPY /* file.sql.39 change */ DATE
124 , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
125 , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
126 );
127
128 -- Procedure Delete_Row
129 --
130
131 PROCEDURE Delete_Row
132 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
133 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
134 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
135 , p_limit_balance_id IN NUMBER
136 );
137
138 -- Procedure Process_Entity
139 --
140
141 PROCEDURE Process_Entity
142 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
143 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
144 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
145 );
146
147 -- Procedure lock_Row
148 --
149
150 PROCEDURE Lock_Row
151 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
152 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
153 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
154 , p_attribute1 IN VARCHAR2
155 , p_attribute10 IN VARCHAR2
156 , p_attribute11 IN VARCHAR2
157 , p_attribute12 IN VARCHAR2
158 , p_attribute13 IN VARCHAR2
159 , p_attribute14 IN VARCHAR2
160 , p_attribute15 IN VARCHAR2
161 , p_attribute2 IN VARCHAR2
162 , p_attribute3 IN VARCHAR2
163 , p_attribute4 IN VARCHAR2
164 , p_attribute5 IN VARCHAR2
165 , p_attribute6 IN VARCHAR2
166 , p_attribute7 IN VARCHAR2
167 , p_attribute8 IN VARCHAR2
168 , p_attribute9 IN VARCHAR2
169 , p_available_amount IN NUMBER
170 , p_consumed_amount IN NUMBER
171 , p_context IN VARCHAR2
172 , p_created_by IN NUMBER
173 , p_creation_date IN DATE
174 , p_last_updated_by IN NUMBER
175 , p_last_update_date IN DATE
176 , p_last_update_login IN NUMBER
177 , p_limit_balance_id IN NUMBER
178 , p_limit_id IN NUMBER
179 , p_multival_attr1_type IN VARCHAR2
180 , p_multival_attr1_context IN VARCHAR2
181 , p_multival_attribute1 IN VARCHAR2
182 , p_multival_attr1_value IN VARCHAR2
183 , p_multival_attr1_datatype IN VARCHAR2
184 , p_multival_attr2_type IN VARCHAR2
185 , p_multival_attr2_context IN VARCHAR2
186 , p_multival_attribute2 IN VARCHAR2
187 , p_multival_attr2_value IN VARCHAR2
188 , p_multival_attr2_datatype IN VARCHAR2
189 , p_organization_attr_context IN VARCHAR2
190 , p_organization_attribute IN VARCHAR2
191 , p_organization_attr_value IN VARCHAR2
192 , p_program_application_id IN NUMBER
193 , p_program_id IN NUMBER
194 , p_program_update_date IN DATE
195 , p_request_id IN NUMBER
196 , p_reserved_amount IN NUMBER
197 );
198
199 END QP_QP_Form_Limit_Balances;