[Home] [Help]
PACKAGE: APPS.OE_HEADER_PAYMENT_UTIL
Source
1 PACKAGE OE_Header_Payment_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXUHPMS.pls 120.4.12020000.1 2012/06/26 09:33:54 appldev ship $ */
3
4 -- Attributes global constants
5
6 G_ATTRIBUTE1 CONSTANT NUMBER := 1;
7 G_ATTRIBUTE2 CONSTANT NUMBER := 2;
8 G_ATTRIBUTE3 CONSTANT NUMBER := 3;
9 G_ATTRIBUTE4 CONSTANT NUMBER := 4;
10 G_ATTRIBUTE5 CONSTANT NUMBER := 5;
11 G_ATTRIBUTE6 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE7 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE8 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE9 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE10 CONSTANT NUMBER := 10;
16 G_ATTRIBUTE11 CONSTANT NUMBER := 11;
17 G_ATTRIBUTE12 CONSTANT NUMBER := 12;
18 G_ATTRIBUTE13 CONSTANT NUMBER := 13;
19 G_ATTRIBUTE14 CONSTANT NUMBER := 14;
20 G_ATTRIBUTE15 CONSTANT NUMBER := 15;
21 G_CONTEXT CONSTANT NUMBER := 16;
22 G_CREATED_BY CONSTANT NUMBER := 17;
23 G_CREATION_DATE CONSTANT NUMBER := 18;
24 G_LAST_UPDATED_BY CONSTANT NUMBER := 19;
25 G_LAST_UPDATE_DATE CONSTANT NUMBER := 20;
26 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 21;
27 G_CHECK_NUMBER CONSTANT NUMBER := 22;
28 G_CREDIT_CARD_APPROVAL_CODE CONSTANT NUMBER := 23;
29 G_CREDIT_CARD_APPROVAL_DATE CONSTANT NUMBER := 24;
30 G_CREDIT_CARD_CODE CONSTANT NUMBER := 25;
31 G_CREDIT_CARD_EXPIRATION_DATE CONSTANT NUMBER := 26;
32 G_CREDIT_CARD_HOLDER_NAME CONSTANT NUMBER := 27;
33 G_CREDIT_CARD_NUMBER CONSTANT NUMBER := 28;
34 G_PAYMENT_LEVEL_CODE CONSTANT NUMBER := 29;
35 G_COMMITMENT_APPLIED_AMOUNT CONSTANT NUMBER := 30;
36 G_COMMITMENT_INTERFACED_AMOUNT CONSTANT NUMBER := 31;
37 G_HEADER CONSTANT NUMBER := 32;
38 G_LINE CONSTANT NUMBER := 33;
39 G_PAYMENT_AMOUNT CONSTANT NUMBER := 34;
40 G_PAYMENT_COLLECTION_EVENT CONSTANT NUMBER := 35;
41 G_PAYMENT_TRX_ID CONSTANT NUMBER := 36;
42 G_PAYMENT_TYPE_CODE CONSTANT NUMBER := 37;
43 G_PAYMENT_SET_ID CONSTANT NUMBER := 38;
44 G_PREPAID_AMOUNT CONSTANT NUMBER := 39;
45 G_PROGRAM_APPLICATION_ID CONSTANT NUMBER := 40;
46 G_PROGRAM_ID CONSTANT NUMBER := 41;
47 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 42;
48 G_RECEIPT_METHOD_ID CONSTANT NUMBER := 43;
49 G_REQUEST_ID CONSTANT NUMBER := 44;
50 G_TANGIBLE_ID CONSTANT NUMBER := 45;
51 G_PAYMENT_NUMBER CONSTANT NUMBER := 46;
52 G_LOCK_CONTROL CONSTANT NUMBER := 47;
53 G_DEFER_PROCESSING_FLAG CONSTANT NUMBER := 48;
54 --R12 CC Encryption
55 G_TRXN_EXTENSION_ID CONSTANT NUMBER := 49;
56 G_INSTRUMENT_SECURITY_CODE CONSTANT NUMBER := 50;
57 G_CC_INSTRUMENT_ID CONSTANT NUMBER := 51;
58 G_CC_INSTRUMENT_ASSIGNMENT_ID CONSTANT NUMBER := 52;
59 --R12 CC Encryption
60 G_MAX_ATTR_ID CONSTANT NUMBER := 53;
61 G_PAYMENT_PERCENTAGE CONSTANT NUMBER := 54; -- Added for bug 8478559
62
63
64 FUNCTION G_MISS_OE_AK_HPAYMENT_REC
65 RETURN OE_AK_HEADER_PAYMENTS_V%ROWTYPE;
66
67 PROCEDURE API_Rec_To_Rowtype_Rec
68 ( p_HEADER_PAYMENT_rec IN OE_Order_PUB.HEADER_PAYMENT_Rec_Type
69 , x_rowtype_rec IN OUT NOCOPY OE_AK_HEADER_PAYMENTS_V%ROWTYPE
70 );
71
72 PROCEDURE Rowtype_Rec_To_API_Rec
73 ( p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
74 , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_PAYMENT_Rec_Type
75 );
76
77 -- Procedure Clear_Dependent_Attr: Overloaded for VIEW%ROWTYPE parameters
78
79 PROCEDURE Clear_Dependent_Attr
80 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
81 , p_x_Header_Payment_rec IN OUT NOCOPY OE_AK_HEADER_PAYMENTS_V%ROWTYPE
82 , p_old_Header_Payment_rec IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
83 := G_MISS_OE_AK_HPAYMENT_REC
84 , p_x_instrument_id IN NUMBER DEFAULT NULL
85 , p_old_instrument_id IN NUMBER DEFAULT NULL
86 );
87
88 -- Procedure Clear_Dependent_Attr
89
90 PROCEDURE Clear_Dependent_Attr
91 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
92 , p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
93 , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
94 OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC
95 );
96
97 -- Procedure Apply_Attribute_Changes
98
99 PROCEDURE Apply_Attribute_Changes
100 ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
101 , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
102 OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC
103 );
104
105 -- Function Complete_Record
106
107 PROCEDURE Complete_Record
108 ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
109 , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
110 ) ;
111
112 -- Function Convert_Miss_To_Null
113
114 PROCEDURE Convert_Miss_To_Null
115 ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
116 ) ;
117
118 -- Procedure Update_Row
119
120 PROCEDURE Update_Row
121 ( p_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
122 );
123
124 -- Procedure Insert_Row
125
126 PROCEDURE Insert_Row
127 ( p_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
128 );
129
130 -- Procedure Delete_Row
131
132 PROCEDURE Delete_Row
133 ( p_payment_number IN NUMBER :=
134 FND_API.G_MISS_NUM
135 , p_header_id IN NUMBER :=
136 FND_API.G_MISS_NUM
137 );
138
139 -- Function Query_Row
140
141 PROCEDURE Query_Row
142 ( p_payment_number IN NUMBER,
143 p_header_id IN NUMBER,
144 x_Header_Payment_Rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
145 ) ;
146
147 -- Function Query_Rows
148
149 --
150
151 PROCEDURE Query_Rows
152 ( p_payment_number IN NUMBER :=
153 FND_API.G_MISS_NUM
154 , p_header_id IN NUMBER :=
155 FND_API.G_MISS_NUM
156 , x_Header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_tbl_Type
157
158 );
159
160 -- Procedure lock_Row
161 --
162
163 PROCEDURE Lock_Row
164 ( x_return_status OUT NOCOPY VARCHAR2
165
166 , p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
167 , p_payment_number IN NUMBER
168 := FND_API.G_MISS_NUM
169 , p_header_id IN NUMBER
170 := FND_API.G_MISS_NUM
171 );
172
173 PROCEDURE Lock_Rows
174 ( p_payment_number IN NUMBER :=
175 FND_API.G_MISS_NUM
176 , p_header_id IN NUMBER :=
177 FND_API.G_MISS_NUM
178 , x_header_Payment_tbl OUT NOCOPY OE_Order_PUB.header_Payment_Tbl_Type
179 , x_return_status OUT NOCOPY VARCHAR2
180
181 );
182
183 -- Function Get_Values
184
185 FUNCTION Get_Values
186 ( p_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
187 , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
188 OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC
189 ) RETURN OE_Order_PUB.Header_Payment_Val_Rec_Type;
190
191 -- Function Get_Ids
192
193 PROCEDURE Get_Ids
194 ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
195 , p_Header_Payment_val_rec IN OE_Order_PUB.Header_Payment_Val_Rec_Type
196 ) ;
197
198 PROCEDURE Pre_Write_Process
199 ( p_x_header_Payment_rec IN OUT NOCOPY OE_ORDER_PUB.header_Payment_rec_type,
200 p_old_header_Payment_rec IN OE_ORDER_PUB.header_Payment_rec_type := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC );
201
202 END OE_Header_Payment_Util;