APPS.ONT_LINE_PAYMENT_DEF_UTIL dependencies on FND_API

Line 51: IF NVL(p_record.ATTRIBUTE1, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

47: IS
48: BEGIN
49:
50: IF p_attr_code =('ATTRIBUTE1') THEN
51: IF NVL(p_record.ATTRIBUTE1, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
52: RETURN p_record.ATTRIBUTE1;
53: ELSE
54: RETURN NULL;
55: END IF;

Line 57: IF NVL(p_record.ATTRIBUTE10, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

53: ELSE
54: RETURN NULL;
55: END IF;
56: ELSIF p_attr_code =('ATTRIBUTE10') THEN
57: IF NVL(p_record.ATTRIBUTE10, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
58: RETURN p_record.ATTRIBUTE10;
59: ELSE
60: RETURN NULL;
61: END IF;

Line 63: IF NVL(p_record.ATTRIBUTE11, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

59: ELSE
60: RETURN NULL;
61: END IF;
62: ELSIF p_attr_code =('ATTRIBUTE11') THEN
63: IF NVL(p_record.ATTRIBUTE11, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
64: RETURN p_record.ATTRIBUTE11;
65: ELSE
66: RETURN NULL;
67: END IF;

Line 69: IF NVL(p_record.ATTRIBUTE12, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

65: ELSE
66: RETURN NULL;
67: END IF;
68: ELSIF p_attr_code =('ATTRIBUTE12') THEN
69: IF NVL(p_record.ATTRIBUTE12, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
70: RETURN p_record.ATTRIBUTE12;
71: ELSE
72: RETURN NULL;
73: END IF;

Line 75: IF NVL(p_record.ATTRIBUTE13, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

71: ELSE
72: RETURN NULL;
73: END IF;
74: ELSIF p_attr_code =('ATTRIBUTE13') THEN
75: IF NVL(p_record.ATTRIBUTE13, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
76: RETURN p_record.ATTRIBUTE13;
77: ELSE
78: RETURN NULL;
79: END IF;

Line 81: IF NVL(p_record.ATTRIBUTE14, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

77: ELSE
78: RETURN NULL;
79: END IF;
80: ELSIF p_attr_code =('ATTRIBUTE14') THEN
81: IF NVL(p_record.ATTRIBUTE14, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
82: RETURN p_record.ATTRIBUTE14;
83: ELSE
84: RETURN NULL;
85: END IF;

Line 87: IF NVL(p_record.ATTRIBUTE15, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

83: ELSE
84: RETURN NULL;
85: END IF;
86: ELSIF p_attr_code =('ATTRIBUTE15') THEN
87: IF NVL(p_record.ATTRIBUTE15, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
88: RETURN p_record.ATTRIBUTE15;
89: ELSE
90: RETURN NULL;
91: END IF;

Line 93: IF NVL(p_record.ATTRIBUTE2, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

89: ELSE
90: RETURN NULL;
91: END IF;
92: ELSIF p_attr_code =('ATTRIBUTE2') THEN
93: IF NVL(p_record.ATTRIBUTE2, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
94: RETURN p_record.ATTRIBUTE2;
95: ELSE
96: RETURN NULL;
97: END IF;

Line 99: IF NVL(p_record.ATTRIBUTE3, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

95: ELSE
96: RETURN NULL;
97: END IF;
98: ELSIF p_attr_code =('ATTRIBUTE3') THEN
99: IF NVL(p_record.ATTRIBUTE3, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
100: RETURN p_record.ATTRIBUTE3;
101: ELSE
102: RETURN NULL;
103: END IF;

Line 105: IF NVL(p_record.ATTRIBUTE4, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

101: ELSE
102: RETURN NULL;
103: END IF;
104: ELSIF p_attr_code =('ATTRIBUTE4') THEN
105: IF NVL(p_record.ATTRIBUTE4, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
106: RETURN p_record.ATTRIBUTE4;
107: ELSE
108: RETURN NULL;
109: END IF;

Line 111: IF NVL(p_record.ATTRIBUTE5, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

107: ELSE
108: RETURN NULL;
109: END IF;
110: ELSIF p_attr_code =('ATTRIBUTE5') THEN
111: IF NVL(p_record.ATTRIBUTE5, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
112: RETURN p_record.ATTRIBUTE5;
113: ELSE
114: RETURN NULL;
115: END IF;

Line 117: IF NVL(p_record.ATTRIBUTE6, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

113: ELSE
114: RETURN NULL;
115: END IF;
116: ELSIF p_attr_code =('ATTRIBUTE6') THEN
117: IF NVL(p_record.ATTRIBUTE6, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
118: RETURN p_record.ATTRIBUTE6;
119: ELSE
120: RETURN NULL;
121: END IF;

Line 123: IF NVL(p_record.ATTRIBUTE7, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

119: ELSE
120: RETURN NULL;
121: END IF;
122: ELSIF p_attr_code =('ATTRIBUTE7') THEN
123: IF NVL(p_record.ATTRIBUTE7, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
124: RETURN p_record.ATTRIBUTE7;
125: ELSE
126: RETURN NULL;
127: END IF;

Line 129: IF NVL(p_record.ATTRIBUTE8, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

125: ELSE
126: RETURN NULL;
127: END IF;
128: ELSIF p_attr_code =('ATTRIBUTE8') THEN
129: IF NVL(p_record.ATTRIBUTE8, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
130: RETURN p_record.ATTRIBUTE8;
131: ELSE
132: RETURN NULL;
133: END IF;

Line 135: IF NVL(p_record.ATTRIBUTE9, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

131: ELSE
132: RETURN NULL;
133: END IF;
134: ELSIF p_attr_code =('ATTRIBUTE9') THEN
135: IF NVL(p_record.ATTRIBUTE9, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
136: RETURN p_record.ATTRIBUTE9;
137: ELSE
138: RETURN NULL;
139: END IF;

Line 141: IF NVL(p_record.CHECK_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

137: ELSE
138: RETURN NULL;
139: END IF;
140: ELSIF p_attr_code =('CHECK_NUMBER') THEN
141: IF NVL(p_record.CHECK_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
142: RETURN p_record.CHECK_NUMBER;
143: ELSE
144: RETURN NULL;
145: END IF;

Line 147: IF NVL(p_record.COMMITMENT_APPLIED_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

143: ELSE
144: RETURN NULL;
145: END IF;
146: ELSIF p_attr_code =('COMMITMENT_APPLIED_AMOUNT') THEN
147: IF NVL(p_record.COMMITMENT_APPLIED_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
148: RETURN p_record.COMMITMENT_APPLIED_AMOUNT;
149: ELSE
150: RETURN NULL;
151: END IF;

Line 153: IF NVL(p_record.COMMITMENT_INTERFACED_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

149: ELSE
150: RETURN NULL;
151: END IF;
152: ELSIF p_attr_code =('COMMITMENT_INTERFACED_AMOUNT') THEN
153: IF NVL(p_record.COMMITMENT_INTERFACED_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
154: RETURN p_record.COMMITMENT_INTERFACED_AMOUNT;
155: ELSE
156: RETURN NULL;
157: END IF;

Line 159: IF NVL(p_record.CONTEXT, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

155: ELSE
156: RETURN NULL;
157: END IF;
158: ELSIF p_attr_code =('CONTEXT') THEN
159: IF NVL(p_record.CONTEXT, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
160: RETURN p_record.CONTEXT;
161: ELSE
162: RETURN NULL;
163: END IF;

Line 165: IF NVL(p_record.CREATED_BY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

161: ELSE
162: RETURN NULL;
163: END IF;
164: ELSIF p_attr_code =('CREATED_BY') THEN
165: IF NVL(p_record.CREATED_BY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
166: RETURN p_record.CREATED_BY;
167: ELSE
168: RETURN NULL;
169: END IF;

Line 171: IF NVL(p_record.CREATION_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

167: ELSE
168: RETURN NULL;
169: END IF;
170: ELSIF p_attr_code =('CREATION_DATE') THEN
171: IF NVL(p_record.CREATION_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
172: RETURN p_record.CREATION_DATE;
173: ELSE
174: RETURN NULL;
175: END IF;

Line 177: IF NVL(p_record.CREDIT_CARD_APPROVAL_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

173: ELSE
174: RETURN NULL;
175: END IF;
176: ELSIF p_attr_code =('CREDIT_CARD_APPROVAL_CODE') THEN
177: IF NVL(p_record.CREDIT_CARD_APPROVAL_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
178: RETURN p_record.CREDIT_CARD_APPROVAL_CODE;
179: ELSE
180: RETURN NULL;
181: END IF;

Line 183: IF NVL(p_record.CREDIT_CARD_APPROVAL_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

179: ELSE
180: RETURN NULL;
181: END IF;
182: ELSIF p_attr_code =('CREDIT_CARD_APPROVAL_DATE') THEN
183: IF NVL(p_record.CREDIT_CARD_APPROVAL_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
184: RETURN p_record.CREDIT_CARD_APPROVAL_DATE;
185: ELSE
186: RETURN NULL;
187: END IF;

Line 189: IF NVL(p_record.CREDIT_CARD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

185: ELSE
186: RETURN NULL;
187: END IF;
188: ELSIF p_attr_code =('CREDIT_CARD_CODE') THEN
189: IF NVL(p_record.CREDIT_CARD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
190: RETURN p_record.CREDIT_CARD_CODE;
191: ELSE
192: RETURN NULL;
193: END IF;

Line 195: IF NVL(p_record.CREDIT_CARD_EXPIRATION_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

191: ELSE
192: RETURN NULL;
193: END IF;
194: ELSIF p_attr_code =('CREDIT_CARD_EXPIRATION_DATE') THEN
195: IF NVL(p_record.CREDIT_CARD_EXPIRATION_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
196: RETURN p_record.CREDIT_CARD_EXPIRATION_DATE;
197: ELSE
198: RETURN NULL;
199: END IF;

Line 201: IF NVL(p_record.CREDIT_CARD_HOLDER_NAME, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

197: ELSE
198: RETURN NULL;
199: END IF;
200: ELSIF p_attr_code =('CREDIT_CARD_HOLDER_NAME') THEN
201: IF NVL(p_record.CREDIT_CARD_HOLDER_NAME, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
202: RETURN p_record.CREDIT_CARD_HOLDER_NAME;
203: ELSE
204: RETURN NULL;
205: END IF;

Line 207: IF NVL(p_record.CREDIT_CARD_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

203: ELSE
204: RETURN NULL;
205: END IF;
206: ELSIF p_attr_code =('CREDIT_CARD_NUMBER') THEN
207: IF NVL(p_record.CREDIT_CARD_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
208: RETURN p_record.CREDIT_CARD_NUMBER;
209: ELSE
210: RETURN NULL;
211: END IF;

Line 213: IF NVL(p_record.DB_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

209: ELSE
210: RETURN NULL;
211: END IF;
212: ELSIF p_attr_code =('DB_FLAG') THEN
213: IF NVL(p_record.DB_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
214: RETURN p_record.DB_FLAG;
215: ELSE
216: RETURN NULL;
217: END IF;

Line 219: IF NVL(p_record.HEADER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

215: ELSE
216: RETURN NULL;
217: END IF;
218: ELSIF p_attr_code =('HEADER_ID') THEN
219: IF NVL(p_record.HEADER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
220: RETURN p_record.HEADER_ID;
221: ELSE
222: RETURN NULL;
223: END IF;

Line 225: IF NVL(p_record.LAST_UPDATED_BY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

221: ELSE
222: RETURN NULL;
223: END IF;
224: ELSIF p_attr_code =('LAST_UPDATED_BY') THEN
225: IF NVL(p_record.LAST_UPDATED_BY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
226: RETURN p_record.LAST_UPDATED_BY;
227: ELSE
228: RETURN NULL;
229: END IF;

Line 231: IF NVL(p_record.LAST_UPDATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

227: ELSE
228: RETURN NULL;
229: END IF;
230: ELSIF p_attr_code =('LAST_UPDATE_DATE') THEN
231: IF NVL(p_record.LAST_UPDATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
232: RETURN p_record.LAST_UPDATE_DATE;
233: ELSE
234: RETURN NULL;
235: END IF;

Line 237: IF NVL(p_record.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

233: ELSE
234: RETURN NULL;
235: END IF;
236: ELSIF p_attr_code =('LAST_UPDATE_LOGIN') THEN
237: IF NVL(p_record.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
238: RETURN p_record.LAST_UPDATE_LOGIN;
239: ELSE
240: RETURN NULL;
241: END IF;

Line 243: IF NVL(p_record.LINE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

239: ELSE
240: RETURN NULL;
241: END IF;
242: ELSIF p_attr_code =('LINE_ID') THEN
243: IF NVL(p_record.LINE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
244: RETURN p_record.LINE_ID;
245: ELSE
246: RETURN NULL;
247: END IF;

Line 249: IF NVL(p_record.OPERATION, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

245: ELSE
246: RETURN NULL;
247: END IF;
248: ELSIF p_attr_code =('OPERATION') THEN
249: IF NVL(p_record.OPERATION, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
250: RETURN p_record.OPERATION;
251: ELSE
252: RETURN NULL;
253: END IF;

Line 255: IF NVL(p_record.PAYMENT_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

251: ELSE
252: RETURN NULL;
253: END IF;
254: ELSIF p_attr_code =('PAYMENT_AMOUNT') THEN
255: IF NVL(p_record.PAYMENT_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
256: RETURN p_record.PAYMENT_AMOUNT;
257: ELSE
258: RETURN NULL;
259: END IF;

Line 261: IF NVL(p_record.PAYMENT_COLLECTION_EVENT, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

257: ELSE
258: RETURN NULL;
259: END IF;
260: ELSIF p_attr_code =('PAYMENT_COLLECTION_EVENT') THEN
261: IF NVL(p_record.PAYMENT_COLLECTION_EVENT, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
262: RETURN p_record.PAYMENT_COLLECTION_EVENT;
263: ELSE
264: RETURN NULL;
265: END IF;

Line 267: IF NVL(p_record.PAYMENT_LEVEL_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

263: ELSE
264: RETURN NULL;
265: END IF;
266: ELSIF p_attr_code =('PAYMENT_LEVEL_CODE') THEN
267: IF NVL(p_record.PAYMENT_LEVEL_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
268: RETURN p_record.PAYMENT_LEVEL_CODE;
269: ELSE
270: RETURN NULL;
271: END IF;

Line 273: IF NVL(p_record.PAYMENT_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

269: ELSE
270: RETURN NULL;
271: END IF;
272: ELSIF p_attr_code =('PAYMENT_NUMBER') THEN
273: IF NVL(p_record.PAYMENT_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
274: RETURN p_record.PAYMENT_NUMBER;
275: ELSE
276: RETURN NULL;
277: END IF;

Line 279: IF NVL(p_record.PAYMENT_SET_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

275: ELSE
276: RETURN NULL;
277: END IF;
278: ELSIF p_attr_code =('PAYMENT_SET_ID') THEN
279: IF NVL(p_record.PAYMENT_SET_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
280: RETURN p_record.PAYMENT_SET_ID;
281: ELSE
282: RETURN NULL;
283: END IF;

Line 285: IF NVL(p_record.PAYMENT_TRX_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

281: ELSE
282: RETURN NULL;
283: END IF;
284: ELSIF p_attr_code =('PAYMENT_TRX_ID') THEN
285: IF NVL(p_record.PAYMENT_TRX_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
286: RETURN p_record.PAYMENT_TRX_ID;
287: ELSE
288: RETURN NULL;
289: END IF;

Line 291: IF NVL(p_record.PAYMENT_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

287: ELSE
288: RETURN NULL;
289: END IF;
290: ELSIF p_attr_code =('PAYMENT_TYPE_CODE') THEN
291: IF NVL(p_record.PAYMENT_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
292: RETURN p_record.PAYMENT_TYPE_CODE;
293: ELSE
294: RETURN NULL;
295: END IF;

Line 297: IF NVL(p_record.PREPAID_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

293: ELSE
294: RETURN NULL;
295: END IF;
296: ELSIF p_attr_code =('PREPAID_AMOUNT') THEN
297: IF NVL(p_record.PREPAID_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
298: RETURN p_record.PREPAID_AMOUNT;
299: ELSE
300: RETURN NULL;
301: END IF;

Line 303: IF NVL(p_record.PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

299: ELSE
300: RETURN NULL;
301: END IF;
302: ELSIF p_attr_code =('PROGRAM_APPLICATION_ID') THEN
303: IF NVL(p_record.PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
304: RETURN p_record.PROGRAM_APPLICATION_ID;
305: ELSE
306: RETURN NULL;
307: END IF;

Line 309: IF NVL(p_record.PROGRAM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

305: ELSE
306: RETURN NULL;
307: END IF;
308: ELSIF p_attr_code =('PROGRAM_ID') THEN
309: IF NVL(p_record.PROGRAM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
310: RETURN p_record.PROGRAM_ID;
311: ELSE
312: RETURN NULL;
313: END IF;

Line 315: IF NVL(p_record.PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

311: ELSE
312: RETURN NULL;
313: END IF;
314: ELSIF p_attr_code =('PROGRAM_UPDATE_DATE') THEN
315: IF NVL(p_record.PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
316: RETURN p_record.PROGRAM_UPDATE_DATE;
317: ELSE
318: RETURN NULL;
319: END IF;

Line 321: IF NVL(p_record.RECEIPT_METHOD_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

317: ELSE
318: RETURN NULL;
319: END IF;
320: ELSIF p_attr_code =('RECEIPT_METHOD_ID') THEN
321: IF NVL(p_record.RECEIPT_METHOD_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
322: RETURN p_record.RECEIPT_METHOD_ID;
323: ELSE
324: RETURN NULL;
325: END IF;

Line 327: IF NVL(p_record.REQUEST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

323: ELSE
324: RETURN NULL;
325: END IF;
326: ELSIF p_attr_code =('REQUEST_ID') THEN
327: IF NVL(p_record.REQUEST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
328: RETURN p_record.REQUEST_ID;
329: ELSE
330: RETURN NULL;
331: END IF;

Line 333: IF NVL(p_record.RETURN_STATUS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

329: ELSE
330: RETURN NULL;
331: END IF;
332: ELSIF p_attr_code =('RETURN_STATUS') THEN
333: IF NVL(p_record.RETURN_STATUS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
334: RETURN p_record.RETURN_STATUS;
335: ELSE
336: RETURN NULL;
337: END IF;

Line 339: IF NVL(p_record.TANGIBLE_ID, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

335: ELSE
336: RETURN NULL;
337: END IF;
338: ELSIF p_attr_code =('TANGIBLE_ID') THEN
339: IF NVL(p_record.TANGIBLE_ID, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
340: RETURN p_record.TANGIBLE_ID;
341: ELSE
342: RETURN NULL;
343: END IF;

Line 358: IF NVL(p_record.CREATION_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

354: IS
355: BEGIN
356:
357: IF p_attr_code =('CREATION_DATE') THEN
358: IF NVL(p_record.CREATION_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
359: RETURN p_record.CREATION_DATE;
360: ELSE
361: RETURN NULL;
362: END IF;

Line 364: IF NVL(p_record.CREDIT_CARD_APPROVAL_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

360: ELSE
361: RETURN NULL;
362: END IF;
363: ELSIF p_attr_code =('CREDIT_CARD_APPROVAL_DATE') THEN
364: IF NVL(p_record.CREDIT_CARD_APPROVAL_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
365: RETURN p_record.CREDIT_CARD_APPROVAL_DATE;
366: ELSE
367: RETURN NULL;
368: END IF;

Line 370: IF NVL(p_record.CREDIT_CARD_EXPIRATION_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

366: ELSE
367: RETURN NULL;
368: END IF;
369: ELSIF p_attr_code =('CREDIT_CARD_EXPIRATION_DATE') THEN
370: IF NVL(p_record.CREDIT_CARD_EXPIRATION_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
371: RETURN p_record.CREDIT_CARD_EXPIRATION_DATE;
372: ELSE
373: RETURN NULL;
374: END IF;

Line 376: IF NVL(p_record.LAST_UPDATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

372: ELSE
373: RETURN NULL;
374: END IF;
375: ELSIF p_attr_code =('LAST_UPDATE_DATE') THEN
376: IF NVL(p_record.LAST_UPDATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
377: RETURN p_record.LAST_UPDATE_DATE;
378: ELSE
379: RETURN NULL;
380: END IF;

Line 382: IF NVL(p_record.PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

378: ELSE
379: RETURN NULL;
380: END IF;
381: ELSIF p_attr_code =('PROGRAM_UPDATE_DATE') THEN
382: IF NVL(p_record.PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
383: RETURN p_record.PROGRAM_UPDATE_DATE;
384: ELSE
385: RETURN NULL;
386: END IF;

Line 388: IF NVL(p_record.ATTRIBUTE1, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

384: ELSE
385: RETURN NULL;
386: END IF;
387: ELSIF p_attr_code =('ATTRIBUTE1') THEN
388: IF NVL(p_record.ATTRIBUTE1, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
389: RETURN to_date(p_record.ATTRIBUTE1,'RRRR/MM/DD HH24:MI:SS');
390: ELSE
391: RETURN NULL;
392: END IF;

Line 394: IF NVL(p_record.ATTRIBUTE10, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

390: ELSE
391: RETURN NULL;
392: END IF;
393: ELSIF p_attr_code =('ATTRIBUTE10') THEN
394: IF NVL(p_record.ATTRIBUTE10, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
395: RETURN to_date(p_record.ATTRIBUTE10,'RRRR/MM/DD HH24:MI:SS');
396: ELSE
397: RETURN NULL;
398: END IF;

Line 400: IF NVL(p_record.ATTRIBUTE11, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

396: ELSE
397: RETURN NULL;
398: END IF;
399: ELSIF p_attr_code =('ATTRIBUTE11') THEN
400: IF NVL(p_record.ATTRIBUTE11, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
401: RETURN to_date(p_record.ATTRIBUTE11,'RRRR/MM/DD HH24:MI:SS');
402: ELSE
403: RETURN NULL;
404: END IF;

Line 406: IF NVL(p_record.ATTRIBUTE12, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

402: ELSE
403: RETURN NULL;
404: END IF;
405: ELSIF p_attr_code =('ATTRIBUTE12') THEN
406: IF NVL(p_record.ATTRIBUTE12, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
407: RETURN to_date(p_record.ATTRIBUTE12,'RRRR/MM/DD HH24:MI:SS');
408: ELSE
409: RETURN NULL;
410: END IF;

Line 412: IF NVL(p_record.ATTRIBUTE13, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

408: ELSE
409: RETURN NULL;
410: END IF;
411: ELSIF p_attr_code =('ATTRIBUTE13') THEN
412: IF NVL(p_record.ATTRIBUTE13, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
413: RETURN to_date(p_record.ATTRIBUTE13,'RRRR/MM/DD HH24:MI:SS');
414: ELSE
415: RETURN NULL;
416: END IF;

Line 418: IF NVL(p_record.ATTRIBUTE14, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

414: ELSE
415: RETURN NULL;
416: END IF;
417: ELSIF p_attr_code =('ATTRIBUTE14') THEN
418: IF NVL(p_record.ATTRIBUTE14, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
419: RETURN to_date(p_record.ATTRIBUTE14,'RRRR/MM/DD HH24:MI:SS');
420: ELSE
421: RETURN NULL;
422: END IF;

Line 424: IF NVL(p_record.ATTRIBUTE15, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

420: ELSE
421: RETURN NULL;
422: END IF;
423: ELSIF p_attr_code =('ATTRIBUTE15') THEN
424: IF NVL(p_record.ATTRIBUTE15, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
425: RETURN to_date(p_record.ATTRIBUTE15,'RRRR/MM/DD HH24:MI:SS');
426: ELSE
427: RETURN NULL;
428: END IF;

Line 430: IF NVL(p_record.ATTRIBUTE2, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

426: ELSE
427: RETURN NULL;
428: END IF;
429: ELSIF p_attr_code =('ATTRIBUTE2') THEN
430: IF NVL(p_record.ATTRIBUTE2, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
431: RETURN to_date(p_record.ATTRIBUTE2,'RRRR/MM/DD HH24:MI:SS');
432: ELSE
433: RETURN NULL;
434: END IF;

Line 436: IF NVL(p_record.ATTRIBUTE3, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

432: ELSE
433: RETURN NULL;
434: END IF;
435: ELSIF p_attr_code =('ATTRIBUTE3') THEN
436: IF NVL(p_record.ATTRIBUTE3, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
437: RETURN to_date(p_record.ATTRIBUTE3,'RRRR/MM/DD HH24:MI:SS');
438: ELSE
439: RETURN NULL;
440: END IF;

Line 442: IF NVL(p_record.ATTRIBUTE4, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

438: ELSE
439: RETURN NULL;
440: END IF;
441: ELSIF p_attr_code =('ATTRIBUTE4') THEN
442: IF NVL(p_record.ATTRIBUTE4, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
443: RETURN to_date(p_record.ATTRIBUTE4,'RRRR/MM/DD HH24:MI:SS');
444: ELSE
445: RETURN NULL;
446: END IF;

Line 448: IF NVL(p_record.ATTRIBUTE5, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

444: ELSE
445: RETURN NULL;
446: END IF;
447: ELSIF p_attr_code =('ATTRIBUTE5') THEN
448: IF NVL(p_record.ATTRIBUTE5, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
449: RETURN to_date(p_record.ATTRIBUTE5,'RRRR/MM/DD HH24:MI:SS');
450: ELSE
451: RETURN NULL;
452: END IF;

Line 454: IF NVL(p_record.ATTRIBUTE6, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

450: ELSE
451: RETURN NULL;
452: END IF;
453: ELSIF p_attr_code =('ATTRIBUTE6') THEN
454: IF NVL(p_record.ATTRIBUTE6, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
455: RETURN to_date(p_record.ATTRIBUTE6,'RRRR/MM/DD HH24:MI:SS');
456: ELSE
457: RETURN NULL;
458: END IF;

Line 460: IF NVL(p_record.ATTRIBUTE7, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

456: ELSE
457: RETURN NULL;
458: END IF;
459: ELSIF p_attr_code =('ATTRIBUTE7') THEN
460: IF NVL(p_record.ATTRIBUTE7, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
461: RETURN to_date(p_record.ATTRIBUTE7,'RRRR/MM/DD HH24:MI:SS');
462: ELSE
463: RETURN NULL;
464: END IF;

Line 466: IF NVL(p_record.ATTRIBUTE8, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

462: ELSE
463: RETURN NULL;
464: END IF;
465: ELSIF p_attr_code =('ATTRIBUTE8') THEN
466: IF NVL(p_record.ATTRIBUTE8, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
467: RETURN to_date(p_record.ATTRIBUTE8,'RRRR/MM/DD HH24:MI:SS');
468: ELSE
469: RETURN NULL;
470: END IF;

Line 472: IF NVL(p_record.ATTRIBUTE9, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

468: ELSE
469: RETURN NULL;
470: END IF;
471: ELSIF p_attr_code =('ATTRIBUTE9') THEN
472: IF NVL(p_record.ATTRIBUTE9, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
473: RETURN to_date(p_record.ATTRIBUTE9,'RRRR/MM/DD HH24:MI:SS');
474: ELSE
475: RETURN NULL;
476: END IF;

Line 478: IF NVL(p_record.CHECK_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

474: ELSE
475: RETURN NULL;
476: END IF;
477: ELSIF p_attr_code =('CHECK_NUMBER') THEN
478: IF NVL(p_record.CHECK_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
479: RETURN to_date(p_record.CHECK_NUMBER,'RRRR/MM/DD HH24:MI:SS');
480: ELSE
481: RETURN NULL;
482: END IF;

Line 484: IF NVL(p_record.COMMITMENT_APPLIED_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

480: ELSE
481: RETURN NULL;
482: END IF;
483: ELSIF p_attr_code =('COMMITMENT_APPLIED_AMOUNT') THEN
484: IF NVL(p_record.COMMITMENT_APPLIED_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
485: RETURN to_date(p_record.COMMITMENT_APPLIED_AMOUNT,'RRRR/MM/DD HH24:MI:SS');
486: ELSE
487: RETURN NULL;
488: END IF;

Line 490: IF NVL(p_record.COMMITMENT_INTERFACED_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

486: ELSE
487: RETURN NULL;
488: END IF;
489: ELSIF p_attr_code =('COMMITMENT_INTERFACED_AMOUNT') THEN
490: IF NVL(p_record.COMMITMENT_INTERFACED_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
491: RETURN to_date(p_record.COMMITMENT_INTERFACED_AMOUNT,'RRRR/MM/DD HH24:MI:SS');
492: ELSE
493: RETURN NULL;
494: END IF;

Line 496: IF NVL(p_record.CONTEXT, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

492: ELSE
493: RETURN NULL;
494: END IF;
495: ELSIF p_attr_code =('CONTEXT') THEN
496: IF NVL(p_record.CONTEXT, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
497: RETURN to_date(p_record.CONTEXT,'RRRR/MM/DD HH24:MI:SS');
498: ELSE
499: RETURN NULL;
500: END IF;

Line 502: IF NVL(p_record.CREATED_BY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

498: ELSE
499: RETURN NULL;
500: END IF;
501: ELSIF p_attr_code =('CREATED_BY') THEN
502: IF NVL(p_record.CREATED_BY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
503: RETURN to_date(p_record.CREATED_BY,'RRRR/MM/DD HH24:MI:SS');
504: ELSE
505: RETURN NULL;
506: END IF;

Line 508: IF NVL(p_record.CREDIT_CARD_APPROVAL_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

504: ELSE
505: RETURN NULL;
506: END IF;
507: ELSIF p_attr_code =('CREDIT_CARD_APPROVAL_CODE') THEN
508: IF NVL(p_record.CREDIT_CARD_APPROVAL_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
509: RETURN to_date(p_record.CREDIT_CARD_APPROVAL_CODE,'RRRR/MM/DD HH24:MI:SS');
510: ELSE
511: RETURN NULL;
512: END IF;

Line 514: IF NVL(p_record.CREDIT_CARD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

510: ELSE
511: RETURN NULL;
512: END IF;
513: ELSIF p_attr_code =('CREDIT_CARD_CODE') THEN
514: IF NVL(p_record.CREDIT_CARD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
515: RETURN to_date(p_record.CREDIT_CARD_CODE,'RRRR/MM/DD HH24:MI:SS');
516: ELSE
517: RETURN NULL;
518: END IF;

Line 520: IF NVL(p_record.CREDIT_CARD_HOLDER_NAME, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

516: ELSE
517: RETURN NULL;
518: END IF;
519: ELSIF p_attr_code =('CREDIT_CARD_HOLDER_NAME') THEN
520: IF NVL(p_record.CREDIT_CARD_HOLDER_NAME, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
521: RETURN to_date(p_record.CREDIT_CARD_HOLDER_NAME,'RRRR/MM/DD HH24:MI:SS');
522: ELSE
523: RETURN NULL;
524: END IF;

Line 526: IF NVL(p_record.CREDIT_CARD_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

522: ELSE
523: RETURN NULL;
524: END IF;
525: ELSIF p_attr_code =('CREDIT_CARD_NUMBER') THEN
526: IF NVL(p_record.CREDIT_CARD_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
527: RETURN to_date(p_record.CREDIT_CARD_NUMBER,'RRRR/MM/DD HH24:MI:SS');
528: ELSE
529: RETURN NULL;
530: END IF;

Line 532: IF NVL(p_record.DB_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

528: ELSE
529: RETURN NULL;
530: END IF;
531: ELSIF p_attr_code =('DB_FLAG') THEN
532: IF NVL(p_record.DB_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
533: RETURN to_date(p_record.DB_FLAG,'RRRR/MM/DD HH24:MI:SS');
534: ELSE
535: RETURN NULL;
536: END IF;

Line 538: IF NVL(p_record.HEADER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

534: ELSE
535: RETURN NULL;
536: END IF;
537: ELSIF p_attr_code =('HEADER_ID') THEN
538: IF NVL(p_record.HEADER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
539: RETURN to_date(p_record.HEADER_ID,'RRRR/MM/DD HH24:MI:SS');
540: ELSE
541: RETURN NULL;
542: END IF;

Line 544: IF NVL(p_record.LAST_UPDATED_BY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

540: ELSE
541: RETURN NULL;
542: END IF;
543: ELSIF p_attr_code =('LAST_UPDATED_BY') THEN
544: IF NVL(p_record.LAST_UPDATED_BY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
545: RETURN to_date(p_record.LAST_UPDATED_BY,'RRRR/MM/DD HH24:MI:SS');
546: ELSE
547: RETURN NULL;
548: END IF;

Line 550: IF NVL(p_record.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

546: ELSE
547: RETURN NULL;
548: END IF;
549: ELSIF p_attr_code =('LAST_UPDATE_LOGIN') THEN
550: IF NVL(p_record.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
551: RETURN to_date(p_record.LAST_UPDATE_LOGIN,'RRRR/MM/DD HH24:MI:SS');
552: ELSE
553: RETURN NULL;
554: END IF;

Line 556: IF NVL(p_record.LINE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

552: ELSE
553: RETURN NULL;
554: END IF;
555: ELSIF p_attr_code =('LINE_ID') THEN
556: IF NVL(p_record.LINE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
557: RETURN to_date(p_record.LINE_ID,'RRRR/MM/DD HH24:MI:SS');
558: ELSE
559: RETURN NULL;
560: END IF;

Line 562: IF NVL(p_record.OPERATION, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

558: ELSE
559: RETURN NULL;
560: END IF;
561: ELSIF p_attr_code =('OPERATION') THEN
562: IF NVL(p_record.OPERATION, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
563: RETURN to_date(p_record.OPERATION,'RRRR/MM/DD HH24:MI:SS');
564: ELSE
565: RETURN NULL;
566: END IF;

Line 568: IF NVL(p_record.PAYMENT_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

564: ELSE
565: RETURN NULL;
566: END IF;
567: ELSIF p_attr_code =('PAYMENT_AMOUNT') THEN
568: IF NVL(p_record.PAYMENT_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
569: RETURN to_date(p_record.PAYMENT_AMOUNT,'RRRR/MM/DD HH24:MI:SS');
570: ELSE
571: RETURN NULL;
572: END IF;

Line 574: IF NVL(p_record.PAYMENT_COLLECTION_EVENT, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

570: ELSE
571: RETURN NULL;
572: END IF;
573: ELSIF p_attr_code =('PAYMENT_COLLECTION_EVENT') THEN
574: IF NVL(p_record.PAYMENT_COLLECTION_EVENT, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
575: RETURN to_date(p_record.PAYMENT_COLLECTION_EVENT,'RRRR/MM/DD HH24:MI:SS');
576: ELSE
577: RETURN NULL;
578: END IF;

Line 580: IF NVL(p_record.PAYMENT_LEVEL_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

576: ELSE
577: RETURN NULL;
578: END IF;
579: ELSIF p_attr_code =('PAYMENT_LEVEL_CODE') THEN
580: IF NVL(p_record.PAYMENT_LEVEL_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
581: RETURN to_date(p_record.PAYMENT_LEVEL_CODE,'RRRR/MM/DD HH24:MI:SS');
582: ELSE
583: RETURN NULL;
584: END IF;

Line 586: IF NVL(p_record.PAYMENT_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

582: ELSE
583: RETURN NULL;
584: END IF;
585: ELSIF p_attr_code =('PAYMENT_NUMBER') THEN
586: IF NVL(p_record.PAYMENT_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
587: RETURN to_date(p_record.PAYMENT_NUMBER,'RRRR/MM/DD HH24:MI:SS');
588: ELSE
589: RETURN NULL;
590: END IF;

Line 592: IF NVL(p_record.PAYMENT_SET_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

588: ELSE
589: RETURN NULL;
590: END IF;
591: ELSIF p_attr_code =('PAYMENT_SET_ID') THEN
592: IF NVL(p_record.PAYMENT_SET_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
593: RETURN to_date(p_record.PAYMENT_SET_ID,'RRRR/MM/DD HH24:MI:SS');
594: ELSE
595: RETURN NULL;
596: END IF;

Line 598: IF NVL(p_record.PAYMENT_TRX_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

594: ELSE
595: RETURN NULL;
596: END IF;
597: ELSIF p_attr_code =('PAYMENT_TRX_ID') THEN
598: IF NVL(p_record.PAYMENT_TRX_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
599: RETURN to_date(p_record.PAYMENT_TRX_ID,'RRRR/MM/DD HH24:MI:SS');
600: ELSE
601: RETURN NULL;
602: END IF;

Line 604: IF NVL(p_record.PAYMENT_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

600: ELSE
601: RETURN NULL;
602: END IF;
603: ELSIF p_attr_code =('PAYMENT_TYPE_CODE') THEN
604: IF NVL(p_record.PAYMENT_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
605: RETURN to_date(p_record.PAYMENT_TYPE_CODE,'RRRR/MM/DD HH24:MI:SS');
606: ELSE
607: RETURN NULL;
608: END IF;

Line 610: IF NVL(p_record.PREPAID_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

606: ELSE
607: RETURN NULL;
608: END IF;
609: ELSIF p_attr_code =('PREPAID_AMOUNT') THEN
610: IF NVL(p_record.PREPAID_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
611: RETURN to_date(p_record.PREPAID_AMOUNT,'RRRR/MM/DD HH24:MI:SS');
612: ELSE
613: RETURN NULL;
614: END IF;

Line 616: IF NVL(p_record.PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

612: ELSE
613: RETURN NULL;
614: END IF;
615: ELSIF p_attr_code =('PROGRAM_APPLICATION_ID') THEN
616: IF NVL(p_record.PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
617: RETURN to_date(p_record.PROGRAM_APPLICATION_ID,'RRRR/MM/DD HH24:MI:SS');
618: ELSE
619: RETURN NULL;
620: END IF;

Line 622: IF NVL(p_record.PROGRAM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

618: ELSE
619: RETURN NULL;
620: END IF;
621: ELSIF p_attr_code =('PROGRAM_ID') THEN
622: IF NVL(p_record.PROGRAM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
623: RETURN to_date(p_record.PROGRAM_ID,'RRRR/MM/DD HH24:MI:SS');
624: ELSE
625: RETURN NULL;
626: END IF;

Line 628: IF NVL(p_record.RECEIPT_METHOD_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

624: ELSE
625: RETURN NULL;
626: END IF;
627: ELSIF p_attr_code =('RECEIPT_METHOD_ID') THEN
628: IF NVL(p_record.RECEIPT_METHOD_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
629: RETURN to_date(p_record.RECEIPT_METHOD_ID,'RRRR/MM/DD HH24:MI:SS');
630: ELSE
631: RETURN NULL;
632: END IF;

Line 634: IF NVL(p_record.REQUEST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

630: ELSE
631: RETURN NULL;
632: END IF;
633: ELSIF p_attr_code =('REQUEST_ID') THEN
634: IF NVL(p_record.REQUEST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
635: RETURN to_date(p_record.REQUEST_ID,'RRRR/MM/DD HH24:MI:SS');
636: ELSE
637: RETURN NULL;
638: END IF;

Line 640: IF NVL(p_record.RETURN_STATUS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

636: ELSE
637: RETURN NULL;
638: END IF;
639: ELSIF p_attr_code =('RETURN_STATUS') THEN
640: IF NVL(p_record.RETURN_STATUS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
641: RETURN to_date(p_record.RETURN_STATUS,'RRRR/MM/DD HH24:MI:SS');
642: ELSE
643: RETURN NULL;
644: END IF;

Line 646: IF NVL(p_record.TANGIBLE_ID, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

642: ELSE
643: RETURN NULL;
644: END IF;
645: ELSIF p_attr_code =('TANGIBLE_ID') THEN
646: IF NVL(p_record.TANGIBLE_ID, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
647: RETURN to_date(p_record.TANGIBLE_ID,'RRRR/MM/DD HH24:MI:SS');
648: ELSE
649: RETURN NULL;
650: END IF;

Line 683: IF (NVL(p_PAYMENT_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)

679: AND HEADER_ID = p_HEADER_ID
680: ;
681: BEGIN
682:
683: IF (NVL(p_PAYMENT_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
684: OR (NVL(p_LINE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
685: OR (NVL(p_HEADER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
686: THEN
687: RETURN 0 ;

Line 684: OR (NVL(p_LINE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)

680: ;
681: BEGIN
682:
683: IF (NVL(p_PAYMENT_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
684: OR (NVL(p_LINE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
685: OR (NVL(p_HEADER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
686: THEN
687: RETURN 0 ;
688: ELSIF (NVL(g_cached_record.PAYMENT_NUMBER,FND_API.G_MISS_NUM) <> p_PAYMENT_NUMBER)

Line 685: OR (NVL(p_HEADER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)

681: BEGIN
682:
683: IF (NVL(p_PAYMENT_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
684: OR (NVL(p_LINE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
685: OR (NVL(p_HEADER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
686: THEN
687: RETURN 0 ;
688: ELSIF (NVL(g_cached_record.PAYMENT_NUMBER,FND_API.G_MISS_NUM) <> p_PAYMENT_NUMBER)
689: OR (NVL(g_cached_record.LINE_ID,FND_API.G_MISS_NUM) <> p_LINE_ID)

Line 688: ELSIF (NVL(g_cached_record.PAYMENT_NUMBER,FND_API.G_MISS_NUM) <> p_PAYMENT_NUMBER)

684: OR (NVL(p_LINE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
685: OR (NVL(p_HEADER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
686: THEN
687: RETURN 0 ;
688: ELSIF (NVL(g_cached_record.PAYMENT_NUMBER,FND_API.G_MISS_NUM) <> p_PAYMENT_NUMBER)
689: OR (NVL(g_cached_record.LINE_ID,FND_API.G_MISS_NUM) <> p_LINE_ID)
690: OR (NVL(g_cached_record.HEADER_ID,FND_API.G_MISS_NUM) <> p_HEADER_ID)
691: THEN
692: Clear_LINE_PAYMENT_Cache;

Line 689: OR (NVL(g_cached_record.LINE_ID,FND_API.G_MISS_NUM) <> p_LINE_ID)

685: OR (NVL(p_HEADER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
686: THEN
687: RETURN 0 ;
688: ELSIF (NVL(g_cached_record.PAYMENT_NUMBER,FND_API.G_MISS_NUM) <> p_PAYMENT_NUMBER)
689: OR (NVL(g_cached_record.LINE_ID,FND_API.G_MISS_NUM) <> p_LINE_ID)
690: OR (NVL(g_cached_record.HEADER_ID,FND_API.G_MISS_NUM) <> p_HEADER_ID)
691: THEN
692: Clear_LINE_PAYMENT_Cache;
693: Open cache;

Line 690: OR (NVL(g_cached_record.HEADER_ID,FND_API.G_MISS_NUM) <> p_HEADER_ID)

686: THEN
687: RETURN 0 ;
688: ELSIF (NVL(g_cached_record.PAYMENT_NUMBER,FND_API.G_MISS_NUM) <> p_PAYMENT_NUMBER)
689: OR (NVL(g_cached_record.LINE_ID,FND_API.G_MISS_NUM) <> p_LINE_ID)
690: OR (NVL(g_cached_record.HEADER_ID,FND_API.G_MISS_NUM) <> p_HEADER_ID)
691: THEN
692: Clear_LINE_PAYMENT_Cache;
693: Open cache;
694: FETCH cache into g_cached_record;

Line 720: IF NVL(p_record.HEADER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

716:
717: BEGIN
718:
719: IF (p_foreign_database_object_name = 'OE_AK_ORDER_HEADERS_V') THEN
720: IF NVL(p_record.HEADER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
721: RETURN NULL;
722: END IF;
723: IF ONT_HEADER_Def_Util.Sync_HEADER_Cache
724: (p_HEADER_ID => p_record.HEADER_ID) = 1 then

Line 730: IF NVL(p_record.LINE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

726: (p_foreign_attr_code,ONT_HEADER_Def_Util.g_cached_record);
727: END IF;
728:
729: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_LINES_V') THEN
730: IF NVL(p_record.LINE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
731: RETURN NULL;
732: END IF;
733: IF ONT_LINE_Def_Util.Sync_LINE_Cache
734: (p_LINE_ID => p_record.LINE_ID) = 1 then

Line 753: IF NVL(p_record.HEADER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

749: IS
750: BEGIN
751:
752: IF (p_foreign_database_object_name = 'OE_AK_ORDER_HEADERS_V') THEN
753: IF NVL(p_record.HEADER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
754: RETURN NULL;
755: END IF;
756: IF ONT_HEADER_Def_Util.Sync_HEADER_Cache
757: (p_HEADER_ID => p_record.HEADER_ID) = 1 then

Line 762: IF NVL(p_record.LINE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

758: RETURN ONT_HEADER_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_HEADER_Def_Util.g_cached_record);
759: END IF;
760:
761: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_LINES_V') THEN
762: IF NVL(p_record.LINE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
763: RETURN NULL;
764: END IF;
765: IF ONT_LINE_Def_Util.Sync_LINE_Cache
766: (p_LINE_ID => p_record.LINE_ID) = 1 then

Line 930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

926: ( G_PKG_NAME ,
927: 'Update_Attr_Rules_Cache: '||l_attribute_code
928: );
929: END IF;
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
931: END Update_Attr_Rules_Cache;
932:
933:
934: PROCEDURE Get_Valid_Defaulting_Rules

Line 1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1026: ( G_PKG_NAME ,
1027: 'Get_Valid_Defaulting_Rules :'||p_attr_code
1028: );
1029: END IF;
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: END Get_Valid_Defaulting_Rules;
1032:
1033:
1034: END ONT_LINE_PAYMENT_Def_Util;