1 PACKAGE OE_OE_Form_Line_Payment AS
2 /* $Header: OEXFLPMS.pls 120.2 2005/09/16 09:05:09 ksurendr noship $ */
3
4 --R12 CC Encryption
5 --The table types are introduced to handle
6 --change attributes for multiple attributes
7 --in a single call
8 TYPE Number_Tbl_Type IS TABLE OF NUMBER
9 INDEX BY BINARY_INTEGER;
10
11 TYPE Varchar2_Tbl_Type IS TABLE OF Varchar2(2000)
12 INDEX BY BINARY_INTEGER;
13
14
15 -- Procedure : Default_Attributes
16 --
17
18 PROCEDURE Default_Attributes
19 ( x_return_status OUT NOCOPY VARCHAR2
20 , x_msg_count OUT NOCOPY NUMBER
21 , x_msg_data OUT NOCOPY VARCHAR2
22 , p_payment_number IN NUMBER
23 , p_line_id IN NUMBER
24 , x_payment_number OUT NOCOPY NUMBER
25 , x_attribute1 OUT NOCOPY VARCHAR2
26 , x_attribute2 OUT NOCOPY VARCHAR2
27 , x_attribute3 OUT NOCOPY VARCHAR2
28 , x_attribute4 OUT NOCOPY VARCHAR2
29 , x_attribute5 OUT NOCOPY VARCHAR2
30 , x_attribute6 OUT NOCOPY VARCHAR2
31 , x_attribute7 OUT NOCOPY VARCHAR2
32 , x_attribute8 OUT NOCOPY VARCHAR2
33 , x_attribute9 OUT NOCOPY VARCHAR2
34 , x_attribute10 OUT NOCOPY VARCHAR2
35 , x_attribute11 OUT NOCOPY VARCHAR2
36 , x_attribute12 OUT NOCOPY VARCHAR2
37 , x_attribute13 OUT NOCOPY VARCHAR2
38 , x_attribute14 OUT NOCOPY VARCHAR2
39 , x_attribute15 OUT NOCOPY VARCHAR2
40 , x_context OUT NOCOPY VARCHAR2
41 , x_header_id OUT NOCOPY NUMBER
42 , x_line_id OUT NOCOPY NUMBER
43 , x_check_number OUT NOCOPY VARCHAR2
44 , x_credit_card_approval_code OUT NOCOPY VARCHAR2
45 , x_credit_card_approval_date OUT NOCOPY DATE
46 , x_credit_card_code OUT NOCOPY VARCHAR2
47 , x_credit_card_expiration_date OUT NOCOPY DATE
48 , x_credit_card_holder_name OUT NOCOPY VARCHAR2
49 , x_credit_card_number OUT NOCOPY VARCHAR2
50 , x_payment_level_code OUT NOCOPY VARCHAR2
51 , x_commitment_applied_amount OUT NOCOPY NUMBER
52 , x_commitment_interfaced_amount OUT NOCOPY NUMBER
53 , x_payment_amount OUT NOCOPY NUMBER
54 , x_payment_collection_event OUT NOCOPY VARCHAR2
55 , x_payment_trx_id OUT NOCOPY NUMBER
56 , x_payment_type_code OUT NOCOPY VARCHAR2
57 , x_payment_set_id OUT NOCOPY NUMBER
58 , x_prepaid_amount OUT NOCOPY NUMBER
59 , x_receipt_method_id OUT NOCOPY NUMBER
60 , x_tangible_id OUT NOCOPY VARCHAR2
61 , x_receipt_method OUT NOCOPY VARCHAR2
62 , x_pmt_collection_event_name OUT NOCOPY VARCHAR2
63 , x_payment_type OUT NOCOPY VARCHAR2
64 , x_defer_processing_flag OUT NOCOPY VARCHAR2
65 , x_trxn_extension_id OUT NOCOPY NUMBER --R12 process order api changes
66 , x_instrument_security_code OUT NOCOPY VARCHAR2 --R12 CC Encryption
67 );
68
69 -- Procedure : Change_Attribute
70 --
71
72 PROCEDURE Change_Attribute
73 ( x_return_status OUT NOCOPY VARCHAR2
74 , x_msg_count OUT NOCOPY NUMBER
75 , x_msg_data OUT NOCOPY VARCHAR2
76 , p_payment_number IN NUMBER
77 , p_line_id IN NUMBER
78 , p_header_id IN NUMBER
79 , p_attr_id IN NUMBER
80 , p_attr_value IN VARCHAR2
81 , p_attr_id_tbl IN Number_Tbl_Type --R12 CC Encryption
82 , p_attr_value_tbl IN Varchar2_Tbl_Type --R12 CC Encryption
83 , p_attribute1 IN VARCHAR2
84 , p_attribute2 IN VARCHAR2
85 , p_attribute3 IN VARCHAR2
86 , p_attribute4 IN VARCHAR2
87 , p_attribute5 IN VARCHAR2
88 , p_attribute6 IN VARCHAR2
89 , p_attribute7 IN VARCHAR2
90 , p_attribute8 IN VARCHAR2
91 , p_attribute9 IN VARCHAR2
92 , p_attribute10 IN VARCHAR2
93 , p_attribute11 IN VARCHAR2
94 , p_attribute12 IN VARCHAR2
95 , p_attribute13 IN VARCHAR2
96 , p_attribute14 IN VARCHAR2
97 , p_attribute15 IN VARCHAR2
98 , p_context IN VARCHAR2
99 , x_attribute1 OUT NOCOPY VARCHAR2
100 , x_attribute2 OUT NOCOPY VARCHAR2
101 , x_attribute3 OUT NOCOPY VARCHAR2
102 , x_attribute4 OUT NOCOPY VARCHAR2
103 , x_attribute5 OUT NOCOPY VARCHAR2
104 , x_attribute6 OUT NOCOPY VARCHAR2
105 , x_attribute7 OUT NOCOPY VARCHAR2
106 , x_attribute8 OUT NOCOPY VARCHAR2
107 , x_attribute9 OUT NOCOPY VARCHAR2
108 , x_attribute10 OUT NOCOPY VARCHAR2
109 , x_attribute11 OUT NOCOPY VARCHAR2
110 , x_attribute12 OUT NOCOPY VARCHAR2
111 , x_attribute13 OUT NOCOPY VARCHAR2
112 , x_attribute14 OUT NOCOPY VARCHAR2
113 , x_attribute15 OUT NOCOPY VARCHAR2
114 , x_context OUT NOCOPY VARCHAR2
115 , x_payment_number OUT NOCOPY NUMBER
116 , x_header_id OUT NOCOPY NUMBER
117 , x_line_id OUT NOCOPY NUMBER
118 , x_check_number OUT NOCOPY VARCHAR2
119 , x_credit_card_approval_code OUT NOCOPY VARCHAR2
120 , x_credit_card_approval_date OUT NOCOPY DATE
121 , x_credit_card_code OUT NOCOPY VARCHAR2
122 , x_credit_card_expiration_date OUT NOCOPY DATE
123 , x_credit_card_holder_name OUT NOCOPY VARCHAR2
124 , x_credit_card_number OUT NOCOPY VARCHAR2
125 , x_payment_level_code OUT NOCOPY VARCHAR2
126 , x_commitment_applied_amount OUT NOCOPY NUMBER
127 , x_commitment_interfaced_amount OUT NOCOPY NUMBER
128 , x_payment_amount OUT NOCOPY NUMBER
129 , x_payment_collection_event OUT NOCOPY VARCHAR2
130 , x_payment_trx_id OUT NOCOPY NUMBER
131 , x_payment_type_code OUT NOCOPY VARCHAR2
132 , x_payment_set_id OUT NOCOPY NUMBER
133 , x_prepaid_amount OUT NOCOPY NUMBER
134 , x_receipt_method_id OUT NOCOPY NUMBER
135 , x_tangible_id OUT NOCOPY VARCHAR2
136 , x_receipt_method OUT NOCOPY VARCHAR2
137 , x_pmt_collection_event_name OUT NOCOPY VARCHAR2
138 , x_payment_type OUT NOCOPY VARCHAR2
139 , x_defer_processing_flag OUT NOCOPY VARCHAR2
140 , x_instrument_security_code OUT NOCOPY VARCHAR2 --R12 CC Encryption
141 );
142
143 -- Procedure Validate_And_Write
144 --
145
146 PROCEDURE Validate_And_Write
147 ( x_return_status OUT NOCOPY VARCHAR2
148 , x_msg_count OUT NOCOPY NUMBER
149 , x_msg_data OUT NOCOPY VARCHAR2
150 , p_payment_number IN NUMBER
151 , p_line_id IN NUMBER
152 , p_header_id IN NUMBER
153 , x_creation_date OUT NOCOPY DATE
154 , x_created_by OUT NOCOPY NUMBER
155 , x_last_update_date OUT NOCOPY DATE
156 , x_last_updated_by OUT NOCOPY NUMBER
157 , x_last_update_login OUT NOCOPY NUMBER
158 , x_program_id OUT NOCOPY NUMBER
159 , x_program_application_id OUT NOCOPY NUMBER
160 , x_program_update_date OUT NOCOPY DATE
161 , x_request_id OUT NOCOPY NUMBER
162 , x_lock_control OUT NOCOPY NUMBER
163 );
164
165 -- Procedure Delete_Row
166 --
167
168 PROCEDURE Delete_Row
169 ( x_return_status OUT NOCOPY VARCHAR2
170 , x_msg_count OUT NOCOPY NUMBER
171 , x_msg_data OUT NOCOPY VARCHAR2
172 , p_payment_number IN NUMBER
173 , p_line_id IN NUMBER
174 , p_header_id IN NUMBER
175 );
176
177 -- Procedure Process_Entity
178 --
179
180 PROCEDURE Process_Entity
181 ( x_return_status OUT NOCOPY VARCHAR2
182 , x_msg_count OUT NOCOPY NUMBER
183 , x_msg_data OUT NOCOPY VARCHAR2
184 );
185
186 -- Procedure lock_Row
187 --
188
189
190 PROCEDURE Lock_Row
191 ( x_return_status OUT NOCOPY VARCHAR2
192 , x_msg_count OUT NOCOPY NUMBER
193 , x_msg_data OUT NOCOPY VARCHAR2
194 , p_payment_number IN NUMBER
195 , p_line_id IN NUMBER
196 , p_header_id IN NUMBER
197 , p_lock_control IN NUMBER
198 );
199
200 -- Procedure Copy_attribute_to_Rec
201 -- R12 CC Encryption
202 PROCEDURE Copy_Attribute_To_Rec
203 ( p_attr_id IN NUMBER
204 , p_attr_value IN VARCHAR2
205 , x_line_payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_PAYMENT_Tbl_Type
206 , x_old_line_payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_PAYMENT_Tbl_Type
207 , p_attribute1 IN VARCHAR2
208 , p_attribute2 IN VARCHAR2
209 , p_attribute3 IN VARCHAR2
210 , p_attribute4 IN VARCHAR2
211 , p_attribute5 IN VARCHAR2
212 , p_attribute6 IN VARCHAR2
213 , p_attribute7 IN VARCHAR2
214 , p_attribute8 IN VARCHAR2
215 , p_attribute9 IN VARCHAR2
216 , p_attribute10 IN VARCHAR2
217 , p_attribute11 IN VARCHAR2
218 , p_attribute12 IN VARCHAR2
219 , p_attribute13 IN VARCHAR2
220 , p_attribute14 IN VARCHAR2
221 , p_attribute15 IN VARCHAR2
222 , p_context IN VARCHAR2
223 );
224
225
226
227 END OE_OE_Form_Line_Payment;