1 PACKAGE OE_OE_Form_Header_Payment AUTHID CURRENT_USER AS
2 /* $Header: OEXFHPMS.pls 120.2 2005/09/16 08:47:58 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_header_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_header_id IN NUMBER
78 , p_attr_id IN NUMBER
79 , p_attr_value IN VARCHAR2
80 , p_attr_id_tbl IN Number_Tbl_Type --R12 CC Encryption
81 , p_attr_value_tbl IN Varchar2_Tbl_Type --R12 CC Encryption
82 , p_attribute1 IN VARCHAR2
83 , p_attribute2 IN VARCHAR2
84 , p_attribute3 IN VARCHAR2
85 , p_attribute4 IN VARCHAR2
86 , p_attribute5 IN VARCHAR2
87 , p_attribute6 IN VARCHAR2
88 , p_attribute7 IN VARCHAR2
89 , p_attribute8 IN VARCHAR2
90 , p_attribute9 IN VARCHAR2
91 , p_attribute10 IN VARCHAR2
92 , p_attribute11 IN VARCHAR2
93 , p_attribute12 IN VARCHAR2
94 , p_attribute13 IN VARCHAR2
95 , p_attribute14 IN VARCHAR2
96 , p_attribute15 IN VARCHAR2
97 , p_context IN VARCHAR2
98 , x_attribute1 OUT NOCOPY VARCHAR2
99 , x_attribute2 OUT NOCOPY VARCHAR2
100 , x_attribute3 OUT NOCOPY VARCHAR2
101 , x_attribute4 OUT NOCOPY VARCHAR2
102 , x_attribute5 OUT NOCOPY VARCHAR2
103 , x_attribute6 OUT NOCOPY VARCHAR2
104 , x_attribute7 OUT NOCOPY VARCHAR2
105 , x_attribute8 OUT NOCOPY VARCHAR2
106 , x_attribute9 OUT NOCOPY VARCHAR2
107 , x_attribute10 OUT NOCOPY VARCHAR2
108 , x_attribute11 OUT NOCOPY VARCHAR2
109 , x_attribute12 OUT NOCOPY VARCHAR2
110 , x_attribute13 OUT NOCOPY VARCHAR2
111 , x_attribute14 OUT NOCOPY VARCHAR2
112 , x_attribute15 OUT NOCOPY VARCHAR2
113 , x_context OUT NOCOPY VARCHAR2
114 , x_payment_number OUT NOCOPY NUMBER
115 , x_header_id OUT NOCOPY NUMBER
116 , x_line_id OUT NOCOPY NUMBER
117 , x_check_number OUT NOCOPY VARCHAR2
118 , x_credit_card_approval_code OUT NOCOPY VARCHAR2
119 , x_credit_card_approval_date OUT NOCOPY DATE
120 , x_credit_card_code OUT NOCOPY VARCHAR2
121 , x_credit_card_expiration_date OUT NOCOPY DATE
122 , x_credit_card_holder_name OUT NOCOPY VARCHAR2
123 , x_credit_card_number OUT NOCOPY VARCHAR2
124 , x_payment_level_code OUT NOCOPY VARCHAR2
125 , x_commitment_applied_amount OUT NOCOPY NUMBER
126 , x_commitment_interfaced_amount OUT NOCOPY NUMBER
127 , x_payment_amount OUT NOCOPY NUMBER
128 , x_payment_collection_event OUT NOCOPY VARCHAR2
129 , x_payment_trx_id OUT NOCOPY NUMBER
130 , x_payment_type_code OUT NOCOPY VARCHAR2
131 , x_payment_set_id OUT NOCOPY NUMBER
132 , x_prepaid_amount OUT NOCOPY NUMBER
133 , x_receipt_method_id OUT NOCOPY NUMBER
134 , x_tangible_id OUT NOCOPY VARCHAR2
135 , x_receipt_method OUT NOCOPY VARCHAR2
136 , x_pmt_collection_event_name OUT NOCOPY VARCHAR2
137 , x_payment_type OUT NOCOPY VARCHAR2
138 , x_defer_processing_flag OUT NOCOPY VARCHAR2
139 , x_instrument_security_code OUT NOCOPY VARCHAR2 --R12 CC Encryption
140 );
141
142 -- Procedure Validate_And_Write
143 --
144
145 PROCEDURE Validate_And_Write
146 ( x_return_status OUT NOCOPY VARCHAR2
147 , x_msg_count OUT NOCOPY NUMBER
148 , x_msg_data OUT NOCOPY VARCHAR2
149 , p_payment_number IN NUMBER
150 , p_header_id IN NUMBER
151 , x_creation_date OUT NOCOPY DATE
152 , x_created_by OUT NOCOPY NUMBER
153 , x_last_update_date OUT NOCOPY DATE
154 , x_last_updated_by OUT NOCOPY NUMBER
155 , x_last_update_login OUT NOCOPY NUMBER
156 , x_program_id OUT NOCOPY NUMBER
157 , x_program_application_id OUT NOCOPY NUMBER
158 , x_program_update_date OUT NOCOPY DATE
159 , x_request_id OUT NOCOPY NUMBER
160 , x_lock_control OUT NOCOPY NUMBER
161 );
162
163 -- Procedure Delete_Row
164 --
165
166 PROCEDURE Delete_Row
167 ( x_return_status OUT NOCOPY VARCHAR2
168 , x_msg_count OUT NOCOPY NUMBER
169 , x_msg_data OUT NOCOPY VARCHAR2
170 , p_payment_number IN NUMBER
171 , p_header_id IN NUMBER
172 );
173
174 -- Procedure Process_Entity
175 --
176
177 PROCEDURE Process_Entity
178 ( x_return_status OUT NOCOPY VARCHAR2
179 , x_msg_count OUT NOCOPY NUMBER
180 , x_msg_data OUT NOCOPY VARCHAR2
181 );
182
183 -- Procedure lock_Row
184 --
185
186
187 PROCEDURE Lock_Row
188 ( x_return_status OUT NOCOPY VARCHAR2
189 , x_msg_count OUT NOCOPY NUMBER
190 , x_msg_data OUT NOCOPY VARCHAR2
191 , p_payment_number IN NUMBER
192 , p_header_id IN NUMBER
193 , p_lock_control IN NUMBER
194 );
195
196
197 -- Procedure Copy_attribute_to_Rec
198 -- R12 CC Encryption
199 PROCEDURE Copy_Attribute_To_Rec
200 ( p_attr_id IN NUMBER
201 , p_attr_value IN VARCHAR2
202 , x_header_payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_PAYMENT_Tbl_Type
203 , x_old_header_payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_PAYMENT_Tbl_Type
204 , p_attribute1 IN VARCHAR2
205 , p_attribute2 IN VARCHAR2
206 , p_attribute3 IN VARCHAR2
207 , p_attribute4 IN VARCHAR2
208 , p_attribute5 IN VARCHAR2
209 , p_attribute6 IN VARCHAR2
210 , p_attribute7 IN VARCHAR2
211 , p_attribute8 IN VARCHAR2
212 , p_attribute9 IN VARCHAR2
213 , p_attribute10 IN VARCHAR2
214 , p_attribute11 IN VARCHAR2
215 , p_attribute12 IN VARCHAR2
216 , p_attribute13 IN VARCHAR2
217 , p_attribute14 IN VARCHAR2
218 , p_attribute15 IN VARCHAR2
219 , p_context IN VARCHAR2
220 );
221
222
223 END OE_OE_Form_Header_Payment;