[Home] [Help]
PACKAGE: APPS.OE_LINE_PAYMENT_UTIL
Source
1 PACKAGE OE_Line_Payment_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXULPMS.pls 120.2.12010000.1 2008/07/25 07:56:40 appldev ship $ */
3
4 -- Attributes global constants
5
6 G_ATTRIBUTE1 CONSTANT NUMBER := 1;
7 G_ATTRIBUTE10 CONSTANT NUMBER := 2;
8 G_ATTRIBUTE11 CONSTANT NUMBER := 3;
9 G_ATTRIBUTE12 CONSTANT NUMBER := 4;
10 G_ATTRIBUTE13 CONSTANT NUMBER := 5;
11 G_ATTRIBUTE14 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE15 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE2 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE3 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE4 CONSTANT NUMBER := 10;
16 G_ATTRIBUTE5 CONSTANT NUMBER := 11;
17 G_ATTRIBUTE6 CONSTANT NUMBER := 12;
18 G_ATTRIBUTE7 CONSTANT NUMBER := 13;
19 G_ATTRIBUTE8 CONSTANT NUMBER := 14;
20 G_ATTRIBUTE9 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_HEADER CONSTANT NUMBER := 19;
25 G_LAST_UPDATED_BY CONSTANT NUMBER := 20;
26 G_LAST_UPDATE_DATE CONSTANT NUMBER := 21;
27 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 22;
28 G_LINE CONSTANT NUMBER := 23;
29 G_CHECK_NUMBER CONSTANT NUMBER := 24;
30 G_CREDIT_CARD_APPROVAL_CODE CONSTANT NUMBER := 25;
31 G_CREDIT_CARD_APPROVAL_DATE CONSTANT NUMBER := 26;
32 G_CREDIT_CARD_CODE CONSTANT NUMBER := 27;
33 G_CREDIT_CARD_EXPIRATION_DATE CONSTANT NUMBER := 28;
34 G_CREDIT_CARD_HOLDER_NAME CONSTANT NUMBER := 29;
35 G_CREDIT_CARD_NUMBER CONSTANT NUMBER := 30;
36 G_PAYMENT_LEVEL_CODE CONSTANT NUMBER := 31;
37 G_COMMITMENT_APPLIED_AMOUNT CONSTANT NUMBER := 32;
38 G_COMMITMENT_INTERFACED_AMOUNT 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
62 FUNCTION G_MISS_OE_AK_LPAYMENT_REC
63 RETURN OE_AK_LINE_PAYMENTS_V%ROWTYPE;
64
65 PROCEDURE API_Rec_To_Rowtype_Rec
66 ( p_LINE_PAYMENT_rec IN OE_Order_PUB.LINE_PAYMENT_Rec_Type
67 , x_rowtype_rec IN OUT NOCOPY OE_AK_LINE_PAYMENTS_V%ROWTYPE
68 );
69
70 PROCEDURE Rowtype_Rec_To_API_Rec
71 ( p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
72 , x_api_rec IN OUT NOCOPY OE_Order_PUB.LINE_PAYMENT_Rec_Type
73 );
74
75 -- Procedure Clear_Dependent_Attr: Overloaded for VIEW%ROWTYPE parameters
76
77 PROCEDURE Clear_Dependent_Attr
78 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
79 , p_x_Line_Payment_rec IN OUT NOCOPY OE_AK_LINE_PAYMENTS_V%ROWTYPE
80 , p_old_Line_Payment_rec IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
81 := G_MISS_OE_AK_LPAYMENT_REC
82 , p_x_instrument_id IN NUMBER DEFAULT NULL --R12 CC Encryption
83 , p_old_instrument_id IN NUMBER DEFAULT NULL
84 );
85
86 -- Procedure Clear_Dependent_Attr
87
88 PROCEDURE Clear_Dependent_Attr
89 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
90 , p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
91 , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
92 OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
93 );
94
95 -- Procedure Apply_Attribute_Changes
96
97 PROCEDURE Apply_Attribute_Changes
98 ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
99 , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
100 OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
101 );
102
103 -- Function Complete_Record
104
105 PROCEDURE Complete_Record
106 ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
107 , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type
108 ) ;
109
110 -- Function Convert_Miss_To_Null
111
112 PROCEDURE Convert_Miss_To_Null
113 ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
114 ) ;
115
116 -- Procedure Update_Row
117
118 PROCEDURE Update_Row
119 ( p_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
120 );
121
122 -- Procedure Insert_Row
123
124 PROCEDURE Insert_Row
125 ( p_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
126 );
127
128 -- Procedure Delete_Row
129
130 PROCEDURE Delete_Row
131 ( p_payment_number IN NUMBER :=
132 FND_API.G_MISS_NUM
133 , p_line_id 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_line_id IN NUMBER,
144 p_header_id IN NUMBER :=
145 FND_API.G_MISS_NUM,
146 x_Line_Payment_Rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
147 ) ;
148
149 -- Function Query_Rows
150
151 --
152
153 PROCEDURE Query_Rows
154 ( p_payment_number IN NUMBER :=
155 FND_API.G_MISS_NUM
156 , p_line_id IN NUMBER :=
157 FND_API.G_MISS_NUM
158 , p_header_id IN NUMBER :=
159 FND_API.G_MISS_NUM
160 , x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_tbl_Type
161
162 );
163
164 -- Procedure lock_Row
165 --
166
167 PROCEDURE Lock_Row
168 ( x_return_status OUT NOCOPY VARCHAR2
169
170 , p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
171 , p_payment_number IN NUMBER
172 := FND_API.G_MISS_NUM
173 , p_line_id IN NUMBER
174 := FND_API.G_MISS_NUM
175 );
176
177 PROCEDURE Lock_Rows
178 ( p_payment_number IN NUMBER :=
179 FND_API.G_MISS_NUM
180 , p_line_id IN NUMBER :=
181 FND_API.G_MISS_NUM
182 , p_header_id IN NUMBER :=
183 FND_API.G_MISS_NUM
184 , x_Line_Payment_tbl OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
185 , x_return_status OUT NOCOPY VARCHAR2
186
187 );
188
189 -- Function Get_Values
190
191 FUNCTION Get_Values
192 ( p_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type
193 , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
194 OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
195 ) RETURN OE_Order_PUB.Line_Payment_Val_Rec_Type;
196
197 -- Function Get_Ids
198
199 PROCEDURE Get_Ids
200 ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
201 , p_Line_Payment_val_rec IN OE_Order_PUB.Line_Payment_Val_Rec_Type
202 ) ;
203
204 PROCEDURE Pre_Write_Process
205 ( p_x_Line_Payment_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Payment_rec_type,
206 p_old_Line_Payment_rec IN OE_ORDER_PUB.Line_Payment_rec_type := OE_ORDER_PUB.G_MISS_LINE_PAYMENT_REC );
207
208 END OE_Line_Payment_Util;