APPS.ONT_HEADER_DEF_UTIL dependencies on FND_API

Line 51: IF NVL(p_record.ACCOUNTING_RULE_DURATION, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 57: IF NVL(p_record.ACCOUNTING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 63: IF NVL(p_record.AGREEMENT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 189: IF NVL(p_record.BLANKET_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 195: IF NVL(p_record.BOOKED_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 =('BOOKED_DATE') THEN
195: IF NVL(p_record.BOOKED_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
196: RETURN p_record.BOOKED_DATE;
197: ELSE
198: RETURN NULL;
199: END IF;

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

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

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

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

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

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

Line 219: IF NVL(p_record.CHANGE_REASON, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

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

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

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

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

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

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

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

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

Line 249: IF NVL(p_record.CONVERSION_RATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

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

Line 255: IF NVL(p_record.CONVERSION_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 303: IF NVL(p_record.CUSTOMER_SIGNATURE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

Line 309: IF NVL(p_record.CUSTOMER_SIGNATURE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

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

Line 315: IF NVL(p_record.CUST_PO_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

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

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

Line 327: IF NVL(p_record.DEFAULT_FULFILLMENT_SET, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

Line 333: IF NVL(p_record.DEFAULT_INBOUND_LINE_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

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

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

Line 345: IF NVL(p_record.DEFAULT_OUTBOUND_LINE_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

341: ELSE
342: RETURN NULL;
343: END IF;
344: ELSIF p_attr_code =('DEFAULT_OUTBOUND_LINE_TYPE_ID') THEN
345: IF NVL(p_record.DEFAULT_OUTBOUND_LINE_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
346: RETURN p_record.DEFAULT_OUTBOUND_LINE_TYPE_ID;
347: ELSE
348: RETURN NULL;
349: END IF;

Line 351: IF NVL(p_record.DELIVER_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

347: ELSE
348: RETURN NULL;
349: END IF;
350: ELSIF p_attr_code =('DELIVER_TO_CONTACT_ID') THEN
351: IF NVL(p_record.DELIVER_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
352: RETURN p_record.DELIVER_TO_CONTACT_ID;
353: ELSE
354: RETURN NULL;
355: END IF;

Line 357: IF NVL(p_record.DELIVER_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

353: ELSE
354: RETURN NULL;
355: END IF;
356: ELSIF p_attr_code =('DELIVER_TO_ORG_ID') THEN
357: IF NVL(p_record.DELIVER_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
358: RETURN p_record.DELIVER_TO_ORG_ID;
359: ELSE
360: RETURN NULL;
361: END IF;

Line 363: IF NVL(p_record.DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

Line 369: IF NVL(p_record.DRAFT_SUBMITTED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

Line 375: IF NVL(p_record.EARLIEST_SCHEDULE_LIMIT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 381: IF NVL(p_record.END_CUSTOMER_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 387: IF NVL(p_record.END_CUSTOMER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

383: ELSE
384: RETURN NULL;
385: END IF;
386: ELSIF p_attr_code =('END_CUSTOMER_ID') THEN
387: IF NVL(p_record.END_CUSTOMER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
388: RETURN p_record.END_CUSTOMER_ID;
389: ELSE
390: RETURN NULL;
391: END IF;

Line 393: IF NVL(p_record.END_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

389: ELSE
390: RETURN NULL;
391: END IF;
392: ELSIF p_attr_code =('END_CUSTOMER_SITE_USE_ID') THEN
393: IF NVL(p_record.END_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
394: RETURN p_record.END_CUSTOMER_SITE_USE_ID;
395: ELSE
396: RETURN NULL;
397: END IF;

Line 399: IF NVL(p_record.EXPIRATION_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

395: ELSE
396: RETURN NULL;
397: END IF;
398: ELSIF p_attr_code =('EXPIRATION_DATE') THEN
399: IF NVL(p_record.EXPIRATION_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
400: RETURN p_record.EXPIRATION_DATE;
401: ELSE
402: RETURN NULL;
403: END IF;

Line 405: IF NVL(p_record.FIRST_ACK_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

401: ELSE
402: RETURN NULL;
403: END IF;
404: ELSIF p_attr_code =('FIRST_ACK_CODE') THEN
405: IF NVL(p_record.FIRST_ACK_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
406: RETURN p_record.FIRST_ACK_CODE;
407: ELSE
408: RETURN NULL;
409: END IF;

Line 411: IF NVL(p_record.FIRST_ACK_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

407: ELSE
408: RETURN NULL;
409: END IF;
410: ELSIF p_attr_code =('FIRST_ACK_DATE') THEN
411: IF NVL(p_record.FIRST_ACK_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
412: RETURN p_record.FIRST_ACK_DATE;
413: ELSE
414: RETURN NULL;
415: END IF;

Line 417: IF NVL(p_record.FLOW_STATUS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

413: ELSE
414: RETURN NULL;
415: END IF;
416: ELSIF p_attr_code =('FLOW_STATUS_CODE') THEN
417: IF NVL(p_record.FLOW_STATUS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
418: RETURN p_record.FLOW_STATUS_CODE;
419: ELSE
420: RETURN NULL;
421: END IF;

Line 423: IF NVL(p_record.FOB_POINT_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

419: ELSE
420: RETURN NULL;
421: END IF;
422: ELSIF p_attr_code =('FOB_POINT_CODE') THEN
423: IF NVL(p_record.FOB_POINT_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
424: RETURN p_record.FOB_POINT_CODE;
425: ELSE
426: RETURN NULL;
427: END IF;

Line 429: IF NVL(p_record.FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

425: ELSE
426: RETURN NULL;
427: END IF;
428: ELSIF p_attr_code =('FREIGHT_CARRIER_CODE') THEN
429: IF NVL(p_record.FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
430: RETURN p_record.FREIGHT_CARRIER_CODE;
431: ELSE
432: RETURN NULL;
433: END IF;

Line 435: IF NVL(p_record.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

431: ELSE
432: RETURN NULL;
433: END IF;
434: ELSIF p_attr_code =('FREIGHT_TERMS_CODE') THEN
435: IF NVL(p_record.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
436: RETURN p_record.FREIGHT_TERMS_CODE;
437: ELSE
438: RETURN NULL;
439: END IF;

Line 441: IF NVL(p_record.GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

437: ELSE
438: RETURN NULL;
439: END IF;
440: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE1') THEN
441: IF NVL(p_record.GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
442: RETURN p_record.GLOBAL_ATTRIBUTE1;
443: ELSE
444: RETURN NULL;
445: END IF;

Line 447: IF NVL(p_record.GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

443: ELSE
444: RETURN NULL;
445: END IF;
446: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE10') THEN
447: IF NVL(p_record.GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
448: RETURN p_record.GLOBAL_ATTRIBUTE10;
449: ELSE
450: RETURN NULL;
451: END IF;

Line 453: IF NVL(p_record.GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

449: ELSE
450: RETURN NULL;
451: END IF;
452: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE11') THEN
453: IF NVL(p_record.GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
454: RETURN p_record.GLOBAL_ATTRIBUTE11;
455: ELSE
456: RETURN NULL;
457: END IF;

Line 459: IF NVL(p_record.GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

455: ELSE
456: RETURN NULL;
457: END IF;
458: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE12') THEN
459: IF NVL(p_record.GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
460: RETURN p_record.GLOBAL_ATTRIBUTE12;
461: ELSE
462: RETURN NULL;
463: END IF;

Line 465: IF NVL(p_record.GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

461: ELSE
462: RETURN NULL;
463: END IF;
464: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE13') THEN
465: IF NVL(p_record.GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
466: RETURN p_record.GLOBAL_ATTRIBUTE13;
467: ELSE
468: RETURN NULL;
469: END IF;

Line 471: IF NVL(p_record.GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

467: ELSE
468: RETURN NULL;
469: END IF;
470: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE14') THEN
471: IF NVL(p_record.GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
472: RETURN p_record.GLOBAL_ATTRIBUTE14;
473: ELSE
474: RETURN NULL;
475: END IF;

Line 477: IF NVL(p_record.GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

473: ELSE
474: RETURN NULL;
475: END IF;
476: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE15') THEN
477: IF NVL(p_record.GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
478: RETURN p_record.GLOBAL_ATTRIBUTE15;
479: ELSE
480: RETURN NULL;
481: END IF;

Line 483: IF NVL(p_record.GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

479: ELSE
480: RETURN NULL;
481: END IF;
482: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE16') THEN
483: IF NVL(p_record.GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
484: RETURN p_record.GLOBAL_ATTRIBUTE16;
485: ELSE
486: RETURN NULL;
487: END IF;

Line 489: IF NVL(p_record.GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

485: ELSE
486: RETURN NULL;
487: END IF;
488: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE17') THEN
489: IF NVL(p_record.GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
490: RETURN p_record.GLOBAL_ATTRIBUTE17;
491: ELSE
492: RETURN NULL;
493: END IF;

Line 495: IF NVL(p_record.GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

491: ELSE
492: RETURN NULL;
493: END IF;
494: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE18') THEN
495: IF NVL(p_record.GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
496: RETURN p_record.GLOBAL_ATTRIBUTE18;
497: ELSE
498: RETURN NULL;
499: END IF;

Line 501: IF NVL(p_record.GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

497: ELSE
498: RETURN NULL;
499: END IF;
500: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE19') THEN
501: IF NVL(p_record.GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
502: RETURN p_record.GLOBAL_ATTRIBUTE19;
503: ELSE
504: RETURN NULL;
505: END IF;

Line 507: IF NVL(p_record.GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

503: ELSE
504: RETURN NULL;
505: END IF;
506: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE2') THEN
507: IF NVL(p_record.GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
508: RETURN p_record.GLOBAL_ATTRIBUTE2;
509: ELSE
510: RETURN NULL;
511: END IF;

Line 513: IF NVL(p_record.GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

509: ELSE
510: RETURN NULL;
511: END IF;
512: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE20') THEN
513: IF NVL(p_record.GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
514: RETURN p_record.GLOBAL_ATTRIBUTE20;
515: ELSE
516: RETURN NULL;
517: END IF;

Line 519: IF NVL(p_record.GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

515: ELSE
516: RETURN NULL;
517: END IF;
518: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE3') THEN
519: IF NVL(p_record.GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
520: RETURN p_record.GLOBAL_ATTRIBUTE3;
521: ELSE
522: RETURN NULL;
523: END IF;

Line 525: IF NVL(p_record.GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

521: ELSE
522: RETURN NULL;
523: END IF;
524: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE4') THEN
525: IF NVL(p_record.GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
526: RETURN p_record.GLOBAL_ATTRIBUTE4;
527: ELSE
528: RETURN NULL;
529: END IF;

Line 531: IF NVL(p_record.GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

527: ELSE
528: RETURN NULL;
529: END IF;
530: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE5') THEN
531: IF NVL(p_record.GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
532: RETURN p_record.GLOBAL_ATTRIBUTE5;
533: ELSE
534: RETURN NULL;
535: END IF;

Line 537: IF NVL(p_record.GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

533: ELSE
534: RETURN NULL;
535: END IF;
536: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE6') THEN
537: IF NVL(p_record.GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
538: RETURN p_record.GLOBAL_ATTRIBUTE6;
539: ELSE
540: RETURN NULL;
541: END IF;

Line 543: IF NVL(p_record.GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

539: ELSE
540: RETURN NULL;
541: END IF;
542: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE7') THEN
543: IF NVL(p_record.GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
544: RETURN p_record.GLOBAL_ATTRIBUTE7;
545: ELSE
546: RETURN NULL;
547: END IF;

Line 549: IF NVL(p_record.GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

545: ELSE
546: RETURN NULL;
547: END IF;
548: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE8') THEN
549: IF NVL(p_record.GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
550: RETURN p_record.GLOBAL_ATTRIBUTE8;
551: ELSE
552: RETURN NULL;
553: END IF;

Line 555: IF NVL(p_record.GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

551: ELSE
552: RETURN NULL;
553: END IF;
554: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE9') THEN
555: IF NVL(p_record.GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
556: RETURN p_record.GLOBAL_ATTRIBUTE9;
557: ELSE
558: RETURN NULL;
559: END IF;

Line 561: IF NVL(p_record.GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

557: ELSE
558: RETURN NULL;
559: END IF;
560: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE_CATEGORY') THEN
561: IF NVL(p_record.GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
562: RETURN p_record.GLOBAL_ATTRIBUTE_CATEGORY;
563: ELSE
564: RETURN NULL;
565: END IF;

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

563: ELSE
564: RETURN NULL;
565: END IF;
566: ELSIF p_attr_code =('HEADER_ID') THEN
567: IF NVL(p_record.HEADER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
568: RETURN p_record.HEADER_ID;
569: ELSE
570: RETURN NULL;
571: END IF;

Line 573: IF NVL(p_record.IB_CURRENT_LOCATION, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

569: ELSE
570: RETURN NULL;
571: END IF;
572: ELSIF p_attr_code =('IB_CURRENT_LOCATION') THEN
573: IF NVL(p_record.IB_CURRENT_LOCATION, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
574: RETURN p_record.IB_CURRENT_LOCATION;
575: ELSE
576: RETURN NULL;
577: END IF;

Line 579: IF NVL(p_record.IB_INSTALLED_AT_LOCATION, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

575: ELSE
576: RETURN NULL;
577: END IF;
578: ELSIF p_attr_code =('IB_INSTALLED_AT_LOCATION') THEN
579: IF NVL(p_record.IB_INSTALLED_AT_LOCATION, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
580: RETURN p_record.IB_INSTALLED_AT_LOCATION;
581: ELSE
582: RETURN NULL;
583: END IF;

Line 585: IF NVL(p_record.IB_OWNER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

581: ELSE
582: RETURN NULL;
583: END IF;
584: ELSIF p_attr_code =('IB_OWNER') THEN
585: IF NVL(p_record.IB_OWNER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
586: RETURN p_record.IB_OWNER;
587: ELSE
588: RETURN NULL;
589: END IF;

Line 591: IF NVL(p_record.INVOICE_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

587: ELSE
588: RETURN NULL;
589: END IF;
590: ELSIF p_attr_code =('INVOICE_TO_CONTACT_ID') THEN
591: IF NVL(p_record.INVOICE_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
592: RETURN p_record.INVOICE_TO_CONTACT_ID;
593: ELSE
594: RETURN NULL;
595: END IF;

Line 597: IF NVL(p_record.INVOICE_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

593: ELSE
594: RETURN NULL;
595: END IF;
596: ELSIF p_attr_code =('INVOICE_TO_ORG_ID') THEN
597: IF NVL(p_record.INVOICE_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
598: RETURN p_record.INVOICE_TO_ORG_ID;
599: ELSE
600: RETURN NULL;
601: END IF;

Line 603: IF NVL(p_record.INVOICING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

599: ELSE
600: RETURN NULL;
601: END IF;
602: ELSIF p_attr_code =('INVOICING_RULE_ID') THEN
603: IF NVL(p_record.INVOICING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
604: RETURN p_record.INVOICING_RULE_ID;
605: ELSE
606: RETURN NULL;
607: END IF;

Line 609: IF NVL(p_record.LAST_ACK_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

605: ELSE
606: RETURN NULL;
607: END IF;
608: ELSIF p_attr_code =('LAST_ACK_CODE') THEN
609: IF NVL(p_record.LAST_ACK_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
610: RETURN p_record.LAST_ACK_CODE;
611: ELSE
612: RETURN NULL;
613: END IF;

Line 615: IF NVL(p_record.LAST_ACK_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

611: ELSE
612: RETURN NULL;
613: END IF;
614: ELSIF p_attr_code =('LAST_ACK_DATE') THEN
615: IF NVL(p_record.LAST_ACK_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
616: RETURN p_record.LAST_ACK_DATE;
617: ELSE
618: RETURN NULL;
619: END IF;

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

617: ELSE
618: RETURN NULL;
619: END IF;
620: ELSIF p_attr_code =('LAST_UPDATED_BY') THEN
621: IF NVL(p_record.LAST_UPDATED_BY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
622: RETURN p_record.LAST_UPDATED_BY;
623: ELSE
624: RETURN NULL;
625: END IF;

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

623: ELSE
624: RETURN NULL;
625: END IF;
626: ELSIF p_attr_code =('LAST_UPDATE_DATE') THEN
627: IF NVL(p_record.LAST_UPDATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
628: RETURN p_record.LAST_UPDATE_DATE;
629: ELSE
630: RETURN NULL;
631: END IF;

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

629: ELSE
630: RETURN NULL;
631: END IF;
632: ELSIF p_attr_code =('LAST_UPDATE_LOGIN') THEN
633: IF NVL(p_record.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
634: RETURN p_record.LAST_UPDATE_LOGIN;
635: ELSE
636: RETURN NULL;
637: END IF;

Line 639: IF NVL(p_record.LATEST_SCHEDULE_LIMIT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

635: ELSE
636: RETURN NULL;
637: END IF;
638: ELSIF p_attr_code =('LATEST_SCHEDULE_LIMIT') THEN
639: IF NVL(p_record.LATEST_SCHEDULE_LIMIT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
640: RETURN p_record.LATEST_SCHEDULE_LIMIT;
641: ELSE
642: RETURN NULL;
643: END IF;

Line 645: IF NVL(p_record.OPEN_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

641: ELSE
642: RETURN NULL;
643: END IF;
644: ELSIF p_attr_code =('OPEN_FLAG') THEN
645: IF NVL(p_record.OPEN_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
646: RETURN p_record.OPEN_FLAG;
647: ELSE
648: RETURN NULL;
649: END IF;

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

647: ELSE
648: RETURN NULL;
649: END IF;
650: ELSIF p_attr_code =('OPERATION') THEN
651: IF NVL(p_record.OPERATION, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
652: RETURN p_record.OPERATION;
653: ELSE
654: RETURN NULL;
655: END IF;

Line 657: IF NVL(p_record.ORDERED_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

653: ELSE
654: RETURN NULL;
655: END IF;
656: ELSIF p_attr_code =('ORDERED_DATE') THEN
657: IF NVL(p_record.ORDERED_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
658: RETURN p_record.ORDERED_DATE;
659: ELSE
660: RETURN NULL;
661: END IF;

Line 663: IF NVL(p_record.ORDER_CATEGORY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

659: ELSE
660: RETURN NULL;
661: END IF;
662: ELSIF p_attr_code =('ORDER_CATEGORY_CODE') THEN
663: IF NVL(p_record.ORDER_CATEGORY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
664: RETURN p_record.ORDER_CATEGORY_CODE;
665: ELSE
666: RETURN NULL;
667: END IF;

Line 669: IF NVL(p_record.ORDER_DATE_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

665: ELSE
666: RETURN NULL;
667: END IF;
668: ELSIF p_attr_code =('ORDER_DATE_TYPE_CODE') THEN
669: IF NVL(p_record.ORDER_DATE_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
670: RETURN p_record.ORDER_DATE_TYPE_CODE;
671: ELSE
672: RETURN NULL;
673: END IF;

Line 675: IF NVL(p_record.ORDER_FIRMED_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

671: ELSE
672: RETURN NULL;
673: END IF;
674: ELSIF p_attr_code =('ORDER_FIRMED_DATE') THEN
675: IF NVL(p_record.ORDER_FIRMED_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
676: RETURN p_record.ORDER_FIRMED_DATE;
677: ELSE
678: RETURN NULL;
679: END IF;

Line 681: IF NVL(p_record.ORDER_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

677: ELSE
678: RETURN NULL;
679: END IF;
680: ELSIF p_attr_code =('ORDER_NUMBER') THEN
681: IF NVL(p_record.ORDER_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
682: RETURN p_record.ORDER_NUMBER;
683: ELSE
684: RETURN NULL;
685: END IF;

Line 687: IF NVL(p_record.ORDER_SOURCE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

683: ELSE
684: RETURN NULL;
685: END IF;
686: ELSIF p_attr_code =('ORDER_SOURCE_ID') THEN
687: IF NVL(p_record.ORDER_SOURCE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
688: RETURN p_record.ORDER_SOURCE_ID;
689: ELSE
690: RETURN NULL;
691: END IF;

Line 693: IF NVL(p_record.ORDER_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

689: ELSE
690: RETURN NULL;
691: END IF;
692: ELSIF p_attr_code =('ORDER_TYPE_ID') THEN
693: IF NVL(p_record.ORDER_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
694: RETURN p_record.ORDER_TYPE_ID;
695: ELSE
696: RETURN NULL;
697: END IF;

Line 699: IF NVL(p_record.ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

695: ELSE
696: RETURN NULL;
697: END IF;
698: ELSIF p_attr_code =('ORG_ID') THEN
699: IF NVL(p_record.ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
700: RETURN p_record.ORG_ID;
701: ELSE
702: RETURN NULL;
703: END IF;

Line 705: IF NVL(p_record.ORIG_SYS_DOCUMENT_REF, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

701: ELSE
702: RETURN NULL;
703: END IF;
704: ELSIF p_attr_code =('ORIG_SYS_DOCUMENT_REF') THEN
705: IF NVL(p_record.ORIG_SYS_DOCUMENT_REF, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
706: RETURN p_record.ORIG_SYS_DOCUMENT_REF;
707: ELSE
708: RETURN NULL;
709: END IF;

Line 711: IF NVL(p_record.PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

707: ELSE
708: RETURN NULL;
709: END IF;
710: ELSIF p_attr_code =('PACKING_INSTRUCTIONS') THEN
711: IF NVL(p_record.PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
712: RETURN p_record.PACKING_INSTRUCTIONS;
713: ELSE
714: RETURN NULL;
715: END IF;

Line 717: IF NVL(p_record.PARTIAL_SHIPMENTS_ALLOWED, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

713: ELSE
714: RETURN NULL;
715: END IF;
716: ELSIF p_attr_code =('PARTIAL_SHIPMENTS_ALLOWED') THEN
717: IF NVL(p_record.PARTIAL_SHIPMENTS_ALLOWED, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
718: RETURN p_record.PARTIAL_SHIPMENTS_ALLOWED;
719: ELSE
720: RETURN NULL;
721: END IF;

Line 723: IF NVL(p_record.PARTY_TYPE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

719: ELSE
720: RETURN NULL;
721: END IF;
722: ELSIF p_attr_code =('PARTY_TYPE') THEN
723: IF NVL(p_record.PARTY_TYPE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
724: RETURN p_record.PARTY_TYPE;
725: ELSE
726: RETURN NULL;
727: END IF;

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

725: ELSE
726: RETURN NULL;
727: END IF;
728: ELSIF p_attr_code =('PAYMENT_AMOUNT') THEN
729: IF NVL(p_record.PAYMENT_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
730: RETURN p_record.PAYMENT_AMOUNT;
731: ELSE
732: RETURN NULL;
733: END IF;

Line 735: IF NVL(p_record.PAYMENT_TERM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

731: ELSE
732: RETURN NULL;
733: END IF;
734: ELSIF p_attr_code =('PAYMENT_TERM_ID') THEN
735: IF NVL(p_record.PAYMENT_TERM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
736: RETURN p_record.PAYMENT_TERM_ID;
737: ELSE
738: RETURN NULL;
739: END IF;

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

737: ELSE
738: RETURN NULL;
739: END IF;
740: ELSIF p_attr_code =('PAYMENT_TYPE_CODE') THEN
741: IF NVL(p_record.PAYMENT_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
742: RETURN p_record.PAYMENT_TYPE_CODE;
743: ELSE
744: RETURN NULL;
745: END IF;

Line 747: IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

743: ELSE
744: RETURN NULL;
745: END IF;
746: ELSIF p_attr_code =('PRICE_LIST_ID') THEN
747: IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
748: RETURN p_record.PRICE_LIST_ID;
749: ELSE
750: RETURN NULL;
751: END IF;

Line 753: IF NVL(p_record.PRICING_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

749: ELSE
750: RETURN NULL;
751: END IF;
752: ELSIF p_attr_code =('PRICING_DATE') THEN
753: IF NVL(p_record.PRICING_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
754: RETURN p_record.PRICING_DATE;
755: ELSE
756: RETURN NULL;
757: END IF;

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

755: ELSE
756: RETURN NULL;
757: END IF;
758: ELSIF p_attr_code =('PROGRAM_APPLICATION_ID') THEN
759: IF NVL(p_record.PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
760: RETURN p_record.PROGRAM_APPLICATION_ID;
761: ELSE
762: RETURN NULL;
763: END IF;

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

761: ELSE
762: RETURN NULL;
763: END IF;
764: ELSIF p_attr_code =('PROGRAM_ID') THEN
765: IF NVL(p_record.PROGRAM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
766: RETURN p_record.PROGRAM_ID;
767: ELSE
768: RETURN NULL;
769: END IF;

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

767: ELSE
768: RETURN NULL;
769: END IF;
770: ELSIF p_attr_code =('PROGRAM_UPDATE_DATE') THEN
771: IF NVL(p_record.PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
772: RETURN p_record.PROGRAM_UPDATE_DATE;
773: ELSE
774: RETURN NULL;
775: END IF;

Line 777: IF NVL(p_record.QUOTE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

773: ELSE
774: RETURN NULL;
775: END IF;
776: ELSIF p_attr_code =('QUOTE_DATE') THEN
777: IF NVL(p_record.QUOTE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
778: RETURN p_record.QUOTE_DATE;
779: ELSE
780: RETURN NULL;
781: END IF;

Line 783: IF NVL(p_record.QUOTE_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

779: ELSE
780: RETURN NULL;
781: END IF;
782: ELSIF p_attr_code =('QUOTE_NUMBER') THEN
783: IF NVL(p_record.QUOTE_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
784: RETURN p_record.QUOTE_NUMBER;
785: ELSE
786: RETURN NULL;
787: END IF;

Line 789: IF NVL(p_record.REQUEST_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

785: ELSE
786: RETURN NULL;
787: END IF;
788: ELSIF p_attr_code =('REQUEST_DATE') THEN
789: IF NVL(p_record.REQUEST_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
790: RETURN p_record.REQUEST_DATE;
791: ELSE
792: RETURN NULL;
793: END IF;

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

791: ELSE
792: RETURN NULL;
793: END IF;
794: ELSIF p_attr_code =('REQUEST_ID') THEN
795: IF NVL(p_record.REQUEST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
796: RETURN p_record.REQUEST_ID;
797: ELSE
798: RETURN NULL;
799: END IF;

Line 801: IF NVL(p_record.RETURN_REASON_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

797: ELSE
798: RETURN NULL;
799: END IF;
800: ELSIF p_attr_code =('RETURN_REASON_CODE') THEN
801: IF NVL(p_record.RETURN_REASON_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
802: RETURN p_record.RETURN_REASON_CODE;
803: ELSE
804: RETURN NULL;
805: END IF;

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

803: ELSE
804: RETURN NULL;
805: END IF;
806: ELSIF p_attr_code =('RETURN_STATUS') THEN
807: IF NVL(p_record.RETURN_STATUS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
808: RETURN p_record.RETURN_STATUS;
809: ELSE
810: RETURN NULL;
811: END IF;

Line 813: IF NVL(p_record.SALESREP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

809: ELSE
810: RETURN NULL;
811: END IF;
812: ELSIF p_attr_code =('SALESREP_ID') THEN
813: IF NVL(p_record.SALESREP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
814: RETURN p_record.SALESREP_ID;
815: ELSE
816: RETURN NULL;
817: END IF;

Line 819: IF NVL(p_record.SALES_CHANNEL_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

815: ELSE
816: RETURN NULL;
817: END IF;
818: ELSIF p_attr_code =('SALES_CHANNEL_CODE') THEN
819: IF NVL(p_record.SALES_CHANNEL_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
820: RETURN p_record.SALES_CHANNEL_CODE;
821: ELSE
822: RETURN NULL;
823: END IF;

Line 825: IF NVL(p_record.SALES_DOCUMENT_NAME, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

821: ELSE
822: RETURN NULL;
823: END IF;
824: ELSIF p_attr_code =('SALES_DOCUMENT_NAME') THEN
825: IF NVL(p_record.SALES_DOCUMENT_NAME, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
826: RETURN p_record.SALES_DOCUMENT_NAME;
827: ELSE
828: RETURN NULL;
829: END IF;

Line 831: IF NVL(p_record.SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

827: ELSE
828: RETURN NULL;
829: END IF;
830: ELSIF p_attr_code =('SHIPMENT_PRIORITY_CODE') THEN
831: IF NVL(p_record.SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
832: RETURN p_record.SHIPMENT_PRIORITY_CODE;
833: ELSE
834: RETURN NULL;
835: END IF;

Line 837: IF NVL(p_record.SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

833: ELSE
834: RETURN NULL;
835: END IF;
836: ELSIF p_attr_code =('SHIPPING_INSTRUCTIONS') THEN
837: IF NVL(p_record.SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
838: RETURN p_record.SHIPPING_INSTRUCTIONS;
839: ELSE
840: RETURN NULL;
841: END IF;

Line 843: IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

839: ELSE
840: RETURN NULL;
841: END IF;
842: ELSIF p_attr_code =('SHIPPING_METHOD_CODE') THEN
843: IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
844: RETURN p_record.SHIPPING_METHOD_CODE;
845: ELSE
846: RETURN NULL;
847: END IF;

Line 849: IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

845: ELSE
846: RETURN NULL;
847: END IF;
848: ELSIF p_attr_code =('SHIP_FROM_ORG_ID') THEN
849: IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
850: RETURN p_record.SHIP_FROM_ORG_ID;
851: ELSE
852: RETURN NULL;
853: END IF;

Line 855: IF NVL(p_record.SHIP_TOLERANCE_ABOVE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

851: ELSE
852: RETURN NULL;
853: END IF;
854: ELSIF p_attr_code =('SHIP_TOLERANCE_ABOVE') THEN
855: IF NVL(p_record.SHIP_TOLERANCE_ABOVE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
856: RETURN p_record.SHIP_TOLERANCE_ABOVE;
857: ELSE
858: RETURN NULL;
859: END IF;

Line 861: IF NVL(p_record.SHIP_TOLERANCE_BELOW, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

857: ELSE
858: RETURN NULL;
859: END IF;
860: ELSIF p_attr_code =('SHIP_TOLERANCE_BELOW') THEN
861: IF NVL(p_record.SHIP_TOLERANCE_BELOW, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
862: RETURN p_record.SHIP_TOLERANCE_BELOW;
863: ELSE
864: RETURN NULL;
865: END IF;

Line 867: IF NVL(p_record.SHIP_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

863: ELSE
864: RETURN NULL;
865: END IF;
866: ELSIF p_attr_code =('SHIP_TO_CONTACT_ID') THEN
867: IF NVL(p_record.SHIP_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
868: RETURN p_record.SHIP_TO_CONTACT_ID;
869: ELSE
870: RETURN NULL;
871: END IF;

Line 873: IF NVL(p_record.SHIP_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

869: ELSE
870: RETURN NULL;
871: END IF;
872: ELSIF p_attr_code =('SHIP_TO_ORG_ID') THEN
873: IF NVL(p_record.SHIP_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
874: RETURN p_record.SHIP_TO_ORG_ID;
875: ELSE
876: RETURN NULL;
877: END IF;

Line 879: IF NVL(p_record.SOLD_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

875: ELSE
876: RETURN NULL;
877: END IF;
878: ELSIF p_attr_code =('SOLD_FROM_ORG_ID') THEN
879: IF NVL(p_record.SOLD_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
880: RETURN p_record.SOLD_FROM_ORG_ID;
881: ELSE
882: RETURN NULL;
883: END IF;

Line 885: IF NVL(p_record.SOLD_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

881: ELSE
882: RETURN NULL;
883: END IF;
884: ELSIF p_attr_code =('SOLD_TO_CONTACT_ID') THEN
885: IF NVL(p_record.SOLD_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
886: RETURN p_record.SOLD_TO_CONTACT_ID;
887: ELSE
888: RETURN NULL;
889: END IF;

Line 891: IF NVL(p_record.SOLD_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

887: ELSE
888: RETURN NULL;
889: END IF;
890: ELSIF p_attr_code =('SOLD_TO_ORG_ID') THEN
891: IF NVL(p_record.SOLD_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
892: RETURN p_record.SOLD_TO_ORG_ID;
893: ELSE
894: RETURN NULL;
895: END IF;

Line 897: IF NVL(p_record.SOLD_TO_SITE_USE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

893: ELSE
894: RETURN NULL;
895: END IF;
896: ELSIF p_attr_code =('SOLD_TO_SITE_USE_ID') THEN
897: IF NVL(p_record.SOLD_TO_SITE_USE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
898: RETURN p_record.SOLD_TO_SITE_USE_ID;
899: ELSE
900: RETURN NULL;
901: END IF;

Line 903: IF NVL(p_record.SOURCE_DOCUMENT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

899: ELSE
900: RETURN NULL;
901: END IF;
902: ELSIF p_attr_code =('SOURCE_DOCUMENT_ID') THEN
903: IF NVL(p_record.SOURCE_DOCUMENT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
904: RETURN p_record.SOURCE_DOCUMENT_ID;
905: ELSE
906: RETURN NULL;
907: END IF;

Line 909: IF NVL(p_record.SOURCE_DOCUMENT_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

905: ELSE
906: RETURN NULL;
907: END IF;
908: ELSIF p_attr_code =('SOURCE_DOCUMENT_TYPE_ID') THEN
909: IF NVL(p_record.SOURCE_DOCUMENT_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
910: RETURN p_record.SOURCE_DOCUMENT_TYPE_ID;
911: ELSE
912: RETURN NULL;
913: END IF;

Line 915: IF NVL(p_record.SOURCE_DOCUMENT_VERSION_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

911: ELSE
912: RETURN NULL;
913: END IF;
914: ELSIF p_attr_code =('SOURCE_DOCUMENT_VERSION_NUMBER') THEN
915: IF NVL(p_record.SOURCE_DOCUMENT_VERSION_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
916: RETURN p_record.SOURCE_DOCUMENT_VERSION_NUMBER;
917: ELSE
918: RETURN NULL;
919: END IF;

Line 921: IF NVL(p_record.SUPPLIER_SIGNATURE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

917: ELSE
918: RETURN NULL;
919: END IF;
920: ELSIF p_attr_code =('SUPPLIER_SIGNATURE') THEN
921: IF NVL(p_record.SUPPLIER_SIGNATURE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
922: RETURN p_record.SUPPLIER_SIGNATURE;
923: ELSE
924: RETURN NULL;
925: END IF;

Line 927: IF NVL(p_record.SUPPLIER_SIGNATURE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

923: ELSE
924: RETURN NULL;
925: END IF;
926: ELSIF p_attr_code =('SUPPLIER_SIGNATURE_DATE') THEN
927: IF NVL(p_record.SUPPLIER_SIGNATURE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
928: RETURN p_record.SUPPLIER_SIGNATURE_DATE;
929: ELSE
930: RETURN NULL;
931: END IF;

Line 933: IF NVL(p_record.TAX_EXEMPT_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

929: ELSE
930: RETURN NULL;
931: END IF;
932: ELSIF p_attr_code =('TAX_EXEMPT_FLAG') THEN
933: IF NVL(p_record.TAX_EXEMPT_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
934: RETURN p_record.TAX_EXEMPT_FLAG;
935: ELSE
936: RETURN NULL;
937: END IF;

Line 939: IF NVL(p_record.TAX_EXEMPT_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

935: ELSE
936: RETURN NULL;
937: END IF;
938: ELSIF p_attr_code =('TAX_EXEMPT_NUMBER') THEN
939: IF NVL(p_record.TAX_EXEMPT_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
940: RETURN p_record.TAX_EXEMPT_NUMBER;
941: ELSE
942: RETURN NULL;
943: END IF;

Line 945: IF NVL(p_record.TAX_EXEMPT_REASON_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

941: ELSE
942: RETURN NULL;
943: END IF;
944: ELSIF p_attr_code =('TAX_EXEMPT_REASON_CODE') THEN
945: IF NVL(p_record.TAX_EXEMPT_REASON_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
946: RETURN p_record.TAX_EXEMPT_REASON_CODE;
947: ELSE
948: RETURN NULL;
949: END IF;

Line 951: IF NVL(p_record.TAX_POINT_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

947: ELSE
948: RETURN NULL;
949: END IF;
950: ELSIF p_attr_code =('TAX_POINT_CODE') THEN
951: IF NVL(p_record.TAX_POINT_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
952: RETURN p_record.TAX_POINT_CODE;
953: ELSE
954: RETURN NULL;
955: END IF;

Line 957: IF NVL(p_record.TRANSACTIONAL_CURR_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

953: ELSE
954: RETURN NULL;
955: END IF;
956: ELSIF p_attr_code =('TRANSACTIONAL_CURR_CODE') THEN
957: IF NVL(p_record.TRANSACTIONAL_CURR_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
958: RETURN p_record.TRANSACTIONAL_CURR_CODE;
959: ELSE
960: RETURN NULL;
961: END IF;

Line 963: IF NVL(p_record.TRANSACTION_PHASE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

959: ELSE
960: RETURN NULL;
961: END IF;
962: ELSIF p_attr_code =('TRANSACTION_PHASE_CODE') THEN
963: IF NVL(p_record.TRANSACTION_PHASE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
964: RETURN p_record.TRANSACTION_PHASE_CODE;
965: ELSE
966: RETURN NULL;
967: END IF;

Line 969: IF NVL(p_record.UPGRADED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

965: ELSE
966: RETURN NULL;
967: END IF;
968: ELSIF p_attr_code =('UPGRADED_FLAG') THEN
969: IF NVL(p_record.UPGRADED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
970: RETURN p_record.UPGRADED_FLAG;
971: ELSE
972: RETURN NULL;
973: END IF;

Line 975: IF NVL(p_record.USER_STATUS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

971: ELSE
972: RETURN NULL;
973: END IF;
974: ELSIF p_attr_code =('USER_STATUS_CODE') THEN
975: IF NVL(p_record.USER_STATUS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
976: RETURN p_record.USER_STATUS_CODE;
977: ELSE
978: RETURN NULL;
979: END IF;

Line 981: IF NVL(p_record.VERSION_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

977: ELSE
978: RETURN NULL;
979: END IF;
980: ELSIF p_attr_code =('VERSION_NUMBER') THEN
981: IF NVL(p_record.VERSION_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
982: RETURN p_record.VERSION_NUMBER;
983: ELSE
984: RETURN NULL;
985: END IF;

Line 1000: IF NVL(p_record.BOOKED_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

996: IS
997: BEGIN
998:
999: IF p_attr_code =('BOOKED_DATE') THEN
1000: IF NVL(p_record.BOOKED_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
1001: RETURN p_record.BOOKED_DATE;
1002: ELSE
1003: RETURN NULL;
1004: END IF;

Line 1006: IF NVL(p_record.CONVERSION_RATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

1002: ELSE
1003: RETURN NULL;
1004: END IF;
1005: ELSIF p_attr_code =('CONVERSION_RATE_DATE') THEN
1006: IF NVL(p_record.CONVERSION_RATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
1007: RETURN p_record.CONVERSION_RATE_DATE;
1008: ELSE
1009: RETURN NULL;
1010: END IF;

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

1008: ELSE
1009: RETURN NULL;
1010: END IF;
1011: ELSIF p_attr_code =('CREATION_DATE') THEN
1012: IF NVL(p_record.CREATION_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
1013: RETURN p_record.CREATION_DATE;
1014: ELSE
1015: RETURN NULL;
1016: END IF;

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

1014: ELSE
1015: RETURN NULL;
1016: END IF;
1017: ELSIF p_attr_code =('CREDIT_CARD_EXPIRATION_DATE') THEN
1018: IF NVL(p_record.CREDIT_CARD_EXPIRATION_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
1019: RETURN p_record.CREDIT_CARD_EXPIRATION_DATE;
1020: ELSE
1021: RETURN NULL;
1022: END IF;

Line 1024: IF NVL(p_record.CUSTOMER_SIGNATURE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

1020: ELSE
1021: RETURN NULL;
1022: END IF;
1023: ELSIF p_attr_code =('CUSTOMER_SIGNATURE_DATE') THEN
1024: IF NVL(p_record.CUSTOMER_SIGNATURE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
1025: RETURN p_record.CUSTOMER_SIGNATURE_DATE;
1026: ELSE
1027: RETURN NULL;
1028: END IF;

Line 1030: IF NVL(p_record.EXPIRATION_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

1026: ELSE
1027: RETURN NULL;
1028: END IF;
1029: ELSIF p_attr_code =('EXPIRATION_DATE') THEN
1030: IF NVL(p_record.EXPIRATION_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
1031: RETURN p_record.EXPIRATION_DATE;
1032: ELSE
1033: RETURN NULL;
1034: END IF;

Line 1036: IF NVL(p_record.FIRST_ACK_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

1032: ELSE
1033: RETURN NULL;
1034: END IF;
1035: ELSIF p_attr_code =('FIRST_ACK_DATE') THEN
1036: IF NVL(p_record.FIRST_ACK_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
1037: RETURN p_record.FIRST_ACK_DATE;
1038: ELSE
1039: RETURN NULL;
1040: END IF;

Line 1042: IF NVL(p_record.LAST_ACK_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

1038: ELSE
1039: RETURN NULL;
1040: END IF;
1041: ELSIF p_attr_code =('LAST_ACK_DATE') THEN
1042: IF NVL(p_record.LAST_ACK_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
1043: RETURN p_record.LAST_ACK_DATE;
1044: ELSE
1045: RETURN NULL;
1046: END IF;

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

1044: ELSE
1045: RETURN NULL;
1046: END IF;
1047: ELSIF p_attr_code =('LAST_UPDATE_DATE') THEN
1048: IF NVL(p_record.LAST_UPDATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
1049: RETURN p_record.LAST_UPDATE_DATE;
1050: ELSE
1051: RETURN NULL;
1052: END IF;

Line 1054: IF NVL(p_record.ORDERED_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

1050: ELSE
1051: RETURN NULL;
1052: END IF;
1053: ELSIF p_attr_code =('ORDERED_DATE') THEN
1054: IF NVL(p_record.ORDERED_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
1055: RETURN p_record.ORDERED_DATE;
1056: ELSE
1057: RETURN NULL;
1058: END IF;

Line 1060: IF NVL(p_record.ORDER_FIRMED_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

1056: ELSE
1057: RETURN NULL;
1058: END IF;
1059: ELSIF p_attr_code =('ORDER_FIRMED_DATE') THEN
1060: IF NVL(p_record.ORDER_FIRMED_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
1061: RETURN p_record.ORDER_FIRMED_DATE;
1062: ELSE
1063: RETURN NULL;
1064: END IF;

Line 1066: IF NVL(p_record.PRICING_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

1062: ELSE
1063: RETURN NULL;
1064: END IF;
1065: ELSIF p_attr_code =('PRICING_DATE') THEN
1066: IF NVL(p_record.PRICING_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
1067: RETURN p_record.PRICING_DATE;
1068: ELSE
1069: RETURN NULL;
1070: END IF;

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

1068: ELSE
1069: RETURN NULL;
1070: END IF;
1071: ELSIF p_attr_code =('PROGRAM_UPDATE_DATE') THEN
1072: IF NVL(p_record.PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
1073: RETURN p_record.PROGRAM_UPDATE_DATE;
1074: ELSE
1075: RETURN NULL;
1076: END IF;

Line 1078: IF NVL(p_record.QUOTE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

1074: ELSE
1075: RETURN NULL;
1076: END IF;
1077: ELSIF p_attr_code =('QUOTE_DATE') THEN
1078: IF NVL(p_record.QUOTE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
1079: RETURN p_record.QUOTE_DATE;
1080: ELSE
1081: RETURN NULL;
1082: END IF;

Line 1084: IF NVL(p_record.REQUEST_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

1080: ELSE
1081: RETURN NULL;
1082: END IF;
1083: ELSIF p_attr_code =('REQUEST_DATE') THEN
1084: IF NVL(p_record.REQUEST_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
1085: RETURN p_record.REQUEST_DATE;
1086: ELSE
1087: RETURN NULL;
1088: END IF;

Line 1090: IF NVL(p_record.SUPPLIER_SIGNATURE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

1086: ELSE
1087: RETURN NULL;
1088: END IF;
1089: ELSIF p_attr_code =('SUPPLIER_SIGNATURE_DATE') THEN
1090: IF NVL(p_record.SUPPLIER_SIGNATURE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
1091: RETURN p_record.SUPPLIER_SIGNATURE_DATE;
1092: ELSE
1093: RETURN NULL;
1094: END IF;

Line 1096: IF NVL(p_record.ACCOUNTING_RULE_DURATION, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1092: ELSE
1093: RETURN NULL;
1094: END IF;
1095: ELSIF p_attr_code =('ACCOUNTING_RULE_DURATION') THEN
1096: IF NVL(p_record.ACCOUNTING_RULE_DURATION, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1097: RETURN to_date(p_record.ACCOUNTING_RULE_DURATION,'RRRR/MM/DD HH24:MI:SS');
1098: ELSE
1099: RETURN NULL;
1100: END IF;

Line 1102: IF NVL(p_record.ACCOUNTING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1098: ELSE
1099: RETURN NULL;
1100: END IF;
1101: ELSIF p_attr_code =('ACCOUNTING_RULE_ID') THEN
1102: IF NVL(p_record.ACCOUNTING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1103: RETURN to_date(p_record.ACCOUNTING_RULE_ID,'RRRR/MM/DD HH24:MI:SS');
1104: ELSE
1105: RETURN NULL;
1106: END IF;

Line 1108: IF NVL(p_record.AGREEMENT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1104: ELSE
1105: RETURN NULL;
1106: END IF;
1107: ELSIF p_attr_code =('AGREEMENT_ID') THEN
1108: IF NVL(p_record.AGREEMENT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1109: RETURN to_date(p_record.AGREEMENT_ID,'RRRR/MM/DD HH24:MI:SS');
1110: ELSE
1111: RETURN NULL;
1112: END IF;

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

1110: ELSE
1111: RETURN NULL;
1112: END IF;
1113: ELSIF p_attr_code =('ATTRIBUTE1') THEN
1114: IF NVL(p_record.ATTRIBUTE1, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1115: RETURN to_date(p_record.ATTRIBUTE1,'RRRR/MM/DD HH24:MI:SS');
1116: ELSE
1117: RETURN NULL;
1118: END IF;

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

1116: ELSE
1117: RETURN NULL;
1118: END IF;
1119: ELSIF p_attr_code =('ATTRIBUTE10') THEN
1120: IF NVL(p_record.ATTRIBUTE10, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1121: RETURN to_date(p_record.ATTRIBUTE10,'RRRR/MM/DD HH24:MI:SS');
1122: ELSE
1123: RETURN NULL;
1124: END IF;

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

1122: ELSE
1123: RETURN NULL;
1124: END IF;
1125: ELSIF p_attr_code =('ATTRIBUTE11') THEN
1126: IF NVL(p_record.ATTRIBUTE11, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1127: RETURN to_date(p_record.ATTRIBUTE11,'RRRR/MM/DD HH24:MI:SS');
1128: ELSE
1129: RETURN NULL;
1130: END IF;

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

1128: ELSE
1129: RETURN NULL;
1130: END IF;
1131: ELSIF p_attr_code =('ATTRIBUTE12') THEN
1132: IF NVL(p_record.ATTRIBUTE12, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1133: RETURN to_date(p_record.ATTRIBUTE12,'RRRR/MM/DD HH24:MI:SS');
1134: ELSE
1135: RETURN NULL;
1136: END IF;

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

1134: ELSE
1135: RETURN NULL;
1136: END IF;
1137: ELSIF p_attr_code =('ATTRIBUTE13') THEN
1138: IF NVL(p_record.ATTRIBUTE13, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1139: RETURN to_date(p_record.ATTRIBUTE13,'RRRR/MM/DD HH24:MI:SS');
1140: ELSE
1141: RETURN NULL;
1142: END IF;

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

1140: ELSE
1141: RETURN NULL;
1142: END IF;
1143: ELSIF p_attr_code =('ATTRIBUTE14') THEN
1144: IF NVL(p_record.ATTRIBUTE14, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1145: RETURN to_date(p_record.ATTRIBUTE14,'RRRR/MM/DD HH24:MI:SS');
1146: ELSE
1147: RETURN NULL;
1148: END IF;

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

1146: ELSE
1147: RETURN NULL;
1148: END IF;
1149: ELSIF p_attr_code =('ATTRIBUTE15') THEN
1150: IF NVL(p_record.ATTRIBUTE15, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1151: RETURN to_date(p_record.ATTRIBUTE15,'RRRR/MM/DD HH24:MI:SS');
1152: ELSE
1153: RETURN NULL;
1154: END IF;

Line 1156: IF NVL(p_record.ATTRIBUTE16, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1152: ELSE
1153: RETURN NULL;
1154: END IF;
1155: ELSIF p_attr_code =('ATTRIBUTE16') THEN
1156: IF NVL(p_record.ATTRIBUTE16, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1157: RETURN to_date(p_record.ATTRIBUTE16,'RRRR/MM/DD HH24:MI:SS');
1158: ELSE
1159: RETURN NULL;
1160: END IF;

Line 1162: IF NVL(p_record.ATTRIBUTE17, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1158: ELSE
1159: RETURN NULL;
1160: END IF;
1161: ELSIF p_attr_code =('ATTRIBUTE17') THEN
1162: IF NVL(p_record.ATTRIBUTE17, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1163: RETURN to_date(p_record.ATTRIBUTE17,'RRRR/MM/DD HH24:MI:SS');
1164: ELSE
1165: RETURN NULL;
1166: END IF;

Line 1168: IF NVL(p_record.ATTRIBUTE18, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1164: ELSE
1165: RETURN NULL;
1166: END IF;
1167: ELSIF p_attr_code =('ATTRIBUTE18') THEN
1168: IF NVL(p_record.ATTRIBUTE18, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1169: RETURN to_date(p_record.ATTRIBUTE18,'RRRR/MM/DD HH24:MI:SS');
1170: ELSE
1171: RETURN NULL;
1172: END IF;

Line 1174: IF NVL(p_record.ATTRIBUTE19, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1170: ELSE
1171: RETURN NULL;
1172: END IF;
1173: ELSIF p_attr_code =('ATTRIBUTE19') THEN
1174: IF NVL(p_record.ATTRIBUTE19, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1175: RETURN to_date(p_record.ATTRIBUTE19,'RRRR/MM/DD HH24:MI:SS');
1176: ELSE
1177: RETURN NULL;
1178: END IF;

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

1176: ELSE
1177: RETURN NULL;
1178: END IF;
1179: ELSIF p_attr_code =('ATTRIBUTE2') THEN
1180: IF NVL(p_record.ATTRIBUTE2, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1181: RETURN to_date(p_record.ATTRIBUTE2,'RRRR/MM/DD HH24:MI:SS');
1182: ELSE
1183: RETURN NULL;
1184: END IF;

Line 1186: IF NVL(p_record.ATTRIBUTE20, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1182: ELSE
1183: RETURN NULL;
1184: END IF;
1185: ELSIF p_attr_code =('ATTRIBUTE20') THEN
1186: IF NVL(p_record.ATTRIBUTE20, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1187: RETURN to_date(p_record.ATTRIBUTE20,'RRRR/MM/DD HH24:MI:SS');
1188: ELSE
1189: RETURN NULL;
1190: END IF;

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

1188: ELSE
1189: RETURN NULL;
1190: END IF;
1191: ELSIF p_attr_code =('ATTRIBUTE3') THEN
1192: IF NVL(p_record.ATTRIBUTE3, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1193: RETURN to_date(p_record.ATTRIBUTE3,'RRRR/MM/DD HH24:MI:SS');
1194: ELSE
1195: RETURN NULL;
1196: END IF;

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

1194: ELSE
1195: RETURN NULL;
1196: END IF;
1197: ELSIF p_attr_code =('ATTRIBUTE4') THEN
1198: IF NVL(p_record.ATTRIBUTE4, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1199: RETURN to_date(p_record.ATTRIBUTE4,'RRRR/MM/DD HH24:MI:SS');
1200: ELSE
1201: RETURN NULL;
1202: END IF;

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

1200: ELSE
1201: RETURN NULL;
1202: END IF;
1203: ELSIF p_attr_code =('ATTRIBUTE5') THEN
1204: IF NVL(p_record.ATTRIBUTE5, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1205: RETURN to_date(p_record.ATTRIBUTE5,'RRRR/MM/DD HH24:MI:SS');
1206: ELSE
1207: RETURN NULL;
1208: END IF;

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

1206: ELSE
1207: RETURN NULL;
1208: END IF;
1209: ELSIF p_attr_code =('ATTRIBUTE6') THEN
1210: IF NVL(p_record.ATTRIBUTE6, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1211: RETURN to_date(p_record.ATTRIBUTE6,'RRRR/MM/DD HH24:MI:SS');
1212: ELSE
1213: RETURN NULL;
1214: END IF;

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

1212: ELSE
1213: RETURN NULL;
1214: END IF;
1215: ELSIF p_attr_code =('ATTRIBUTE7') THEN
1216: IF NVL(p_record.ATTRIBUTE7, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1217: RETURN to_date(p_record.ATTRIBUTE7,'RRRR/MM/DD HH24:MI:SS');
1218: ELSE
1219: RETURN NULL;
1220: END IF;

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

1218: ELSE
1219: RETURN NULL;
1220: END IF;
1221: ELSIF p_attr_code =('ATTRIBUTE8') THEN
1222: IF NVL(p_record.ATTRIBUTE8, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1223: RETURN to_date(p_record.ATTRIBUTE8,'RRRR/MM/DD HH24:MI:SS');
1224: ELSE
1225: RETURN NULL;
1226: END IF;

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

1224: ELSE
1225: RETURN NULL;
1226: END IF;
1227: ELSIF p_attr_code =('ATTRIBUTE9') THEN
1228: IF NVL(p_record.ATTRIBUTE9, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1229: RETURN to_date(p_record.ATTRIBUTE9,'RRRR/MM/DD HH24:MI:SS');
1230: ELSE
1231: RETURN NULL;
1232: END IF;

Line 1234: IF NVL(p_record.BLANKET_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1230: ELSE
1231: RETURN NULL;
1232: END IF;
1233: ELSIF p_attr_code =('BLANKET_NUMBER') THEN
1234: IF NVL(p_record.BLANKET_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1235: RETURN to_date(p_record.BLANKET_NUMBER,'RRRR/MM/DD HH24:MI:SS');
1236: ELSE
1237: RETURN NULL;
1238: END IF;

Line 1240: IF NVL(p_record.BOOKED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1236: ELSE
1237: RETURN NULL;
1238: END IF;
1239: ELSIF p_attr_code =('BOOKED_FLAG') THEN
1240: IF NVL(p_record.BOOKED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1241: RETURN to_date(p_record.BOOKED_FLAG,'RRRR/MM/DD HH24:MI:SS');
1242: ELSE
1243: RETURN NULL;
1244: END IF;

Line 1246: IF NVL(p_record.CANCELLED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1242: ELSE
1243: RETURN NULL;
1244: END IF;
1245: ELSIF p_attr_code =('CANCELLED_FLAG') THEN
1246: IF NVL(p_record.CANCELLED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1247: RETURN to_date(p_record.CANCELLED_FLAG,'RRRR/MM/DD HH24:MI:SS');
1248: ELSE
1249: RETURN NULL;
1250: END IF;

Line 1252: IF NVL(p_record.CHANGE_COMMENTS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1248: ELSE
1249: RETURN NULL;
1250: END IF;
1251: ELSIF p_attr_code =('CHANGE_COMMENTS') THEN
1252: IF NVL(p_record.CHANGE_COMMENTS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1253: RETURN to_date(p_record.CHANGE_COMMENTS,'RRRR/MM/DD HH24:MI:SS');
1254: ELSE
1255: RETURN NULL;
1256: END IF;

Line 1258: IF NVL(p_record.CHANGE_REASON, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1254: ELSE
1255: RETURN NULL;
1256: END IF;
1257: ELSIF p_attr_code =('CHANGE_REASON') THEN
1258: IF NVL(p_record.CHANGE_REASON, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1259: RETURN to_date(p_record.CHANGE_REASON,'RRRR/MM/DD HH24:MI:SS');
1260: ELSE
1261: RETURN NULL;
1262: END IF;

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

1260: ELSE
1261: RETURN NULL;
1262: END IF;
1263: ELSIF p_attr_code =('CHECK_NUMBER') THEN
1264: IF NVL(p_record.CHECK_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1265: RETURN to_date(p_record.CHECK_NUMBER,'RRRR/MM/DD HH24:MI:SS');
1266: ELSE
1267: RETURN NULL;
1268: END IF;

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

1266: ELSE
1267: RETURN NULL;
1268: END IF;
1269: ELSIF p_attr_code =('CONTEXT') THEN
1270: IF NVL(p_record.CONTEXT, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1271: RETURN to_date(p_record.CONTEXT,'RRRR/MM/DD HH24:MI:SS');
1272: ELSE
1273: RETURN NULL;
1274: END IF;

Line 1276: IF NVL(p_record.CONTRACT_TERMS, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1272: ELSE
1273: RETURN NULL;
1274: END IF;
1275: ELSIF p_attr_code =('CONTRACT_TERMS') THEN
1276: IF NVL(p_record.CONTRACT_TERMS, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1277: RETURN to_date(p_record.CONTRACT_TERMS,'RRRR/MM/DD HH24:MI:SS');
1278: ELSE
1279: RETURN NULL;
1280: END IF;

Line 1282: IF NVL(p_record.CONVERSION_RATE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1278: ELSE
1279: RETURN NULL;
1280: END IF;
1281: ELSIF p_attr_code =('CONVERSION_RATE') THEN
1282: IF NVL(p_record.CONVERSION_RATE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1283: RETURN to_date(p_record.CONVERSION_RATE,'RRRR/MM/DD HH24:MI:SS');
1284: ELSE
1285: RETURN NULL;
1286: END IF;

Line 1288: IF NVL(p_record.CONVERSION_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1284: ELSE
1285: RETURN NULL;
1286: END IF;
1287: ELSIF p_attr_code =('CONVERSION_TYPE_CODE') THEN
1288: IF NVL(p_record.CONVERSION_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1289: RETURN to_date(p_record.CONVERSION_TYPE_CODE,'RRRR/MM/DD HH24:MI:SS');
1290: ELSE
1291: RETURN NULL;
1292: END IF;

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

1290: ELSE
1291: RETURN NULL;
1292: END IF;
1293: ELSIF p_attr_code =('CREATED_BY') THEN
1294: IF NVL(p_record.CREATED_BY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1295: RETURN to_date(p_record.CREATED_BY,'RRRR/MM/DD HH24:MI:SS');
1296: ELSE
1297: RETURN NULL;
1298: END IF;

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

1296: ELSE
1297: RETURN NULL;
1298: END IF;
1299: ELSIF p_attr_code =('CREDIT_CARD_APPROVAL_CODE') THEN
1300: IF NVL(p_record.CREDIT_CARD_APPROVAL_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1301: RETURN to_date(p_record.CREDIT_CARD_APPROVAL_CODE,'RRRR/MM/DD HH24:MI:SS');
1302: ELSE
1303: RETURN NULL;
1304: END IF;

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

1302: ELSE
1303: RETURN NULL;
1304: END IF;
1305: ELSIF p_attr_code =('CREDIT_CARD_CODE') THEN
1306: IF NVL(p_record.CREDIT_CARD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1307: RETURN to_date(p_record.CREDIT_CARD_CODE,'RRRR/MM/DD HH24:MI:SS');
1308: ELSE
1309: RETURN NULL;
1310: END IF;

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

1308: ELSE
1309: RETURN NULL;
1310: END IF;
1311: ELSIF p_attr_code =('CREDIT_CARD_HOLDER_NAME') THEN
1312: IF NVL(p_record.CREDIT_CARD_HOLDER_NAME, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1313: RETURN to_date(p_record.CREDIT_CARD_HOLDER_NAME,'RRRR/MM/DD HH24:MI:SS');
1314: ELSE
1315: RETURN NULL;
1316: END IF;

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

1314: ELSE
1315: RETURN NULL;
1316: END IF;
1317: ELSIF p_attr_code =('CREDIT_CARD_NUMBER') THEN
1318: IF NVL(p_record.CREDIT_CARD_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1319: RETURN to_date(p_record.CREDIT_CARD_NUMBER,'RRRR/MM/DD HH24:MI:SS');
1320: ELSE
1321: RETURN NULL;
1322: END IF;

Line 1324: IF NVL(p_record.CUSTOMER_SIGNATURE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1320: ELSE
1321: RETURN NULL;
1322: END IF;
1323: ELSIF p_attr_code =('CUSTOMER_SIGNATURE') THEN
1324: IF NVL(p_record.CUSTOMER_SIGNATURE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1325: RETURN to_date(p_record.CUSTOMER_SIGNATURE,'RRRR/MM/DD HH24:MI:SS');
1326: ELSE
1327: RETURN NULL;
1328: END IF;

Line 1330: IF NVL(p_record.CUST_PO_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1326: ELSE
1327: RETURN NULL;
1328: END IF;
1329: ELSIF p_attr_code =('CUST_PO_NUMBER') THEN
1330: IF NVL(p_record.CUST_PO_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1331: RETURN to_date(p_record.CUST_PO_NUMBER,'RRRR/MM/DD HH24:MI:SS');
1332: ELSE
1333: RETURN NULL;
1334: END IF;

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

1332: ELSE
1333: RETURN NULL;
1334: END IF;
1335: ELSIF p_attr_code =('DB_FLAG') THEN
1336: IF NVL(p_record.DB_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1337: RETURN to_date(p_record.DB_FLAG,'RRRR/MM/DD HH24:MI:SS');
1338: ELSE
1339: RETURN NULL;
1340: END IF;

Line 1342: IF NVL(p_record.DEFAULT_FULFILLMENT_SET, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1338: ELSE
1339: RETURN NULL;
1340: END IF;
1341: ELSIF p_attr_code =('DEFAULT_FULFILLMENT_SET') THEN
1342: IF NVL(p_record.DEFAULT_FULFILLMENT_SET, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1343: RETURN to_date(p_record.DEFAULT_FULFILLMENT_SET,'RRRR/MM/DD HH24:MI:SS');
1344: ELSE
1345: RETURN NULL;
1346: END IF;

Line 1348: IF NVL(p_record.DEFAULT_INBOUND_LINE_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1344: ELSE
1345: RETURN NULL;
1346: END IF;
1347: ELSIF p_attr_code =('DEFAULT_INBOUND_LINE_TYPE_ID') THEN
1348: IF NVL(p_record.DEFAULT_INBOUND_LINE_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1349: RETURN to_date(p_record.DEFAULT_INBOUND_LINE_TYPE_ID,'RRRR/MM/DD HH24:MI:SS');
1350: ELSE
1351: RETURN NULL;
1352: END IF;

Line 1354: IF NVL(p_record.CUSTOMER_PREFERENCE_SET_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1350: ELSE
1351: RETURN NULL;
1352: END IF;
1353: ELSIF p_attr_code =('DEFAULT_LINE_SET') THEN
1354: IF NVL(p_record.CUSTOMER_PREFERENCE_SET_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1355: RETURN to_date(p_record.CUSTOMER_PREFERENCE_SET_CODE,'RRRR/MM/DD HH24:MI:SS');
1356: ELSE
1357: RETURN NULL;
1358: END IF;

Line 1360: IF NVL(p_record.DEFAULT_OUTBOUND_LINE_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1356: ELSE
1357: RETURN NULL;
1358: END IF;
1359: ELSIF p_attr_code =('DEFAULT_OUTBOUND_LINE_TYPE_ID') THEN
1360: IF NVL(p_record.DEFAULT_OUTBOUND_LINE_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1361: RETURN to_date(p_record.DEFAULT_OUTBOUND_LINE_TYPE_ID,'RRRR/MM/DD HH24:MI:SS');
1362: ELSE
1363: RETURN NULL;
1364: END IF;

Line 1366: IF NVL(p_record.DELIVER_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1362: ELSE
1363: RETURN NULL;
1364: END IF;
1365: ELSIF p_attr_code =('DELIVER_TO_CONTACT_ID') THEN
1366: IF NVL(p_record.DELIVER_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1367: RETURN to_date(p_record.DELIVER_TO_CONTACT_ID,'RRRR/MM/DD HH24:MI:SS');
1368: ELSE
1369: RETURN NULL;
1370: END IF;

Line 1372: IF NVL(p_record.DELIVER_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1368: ELSE
1369: RETURN NULL;
1370: END IF;
1371: ELSIF p_attr_code =('DELIVER_TO_ORG_ID') THEN
1372: IF NVL(p_record.DELIVER_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1373: RETURN to_date(p_record.DELIVER_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
1374: ELSE
1375: RETURN NULL;
1376: END IF;

Line 1378: IF NVL(p_record.DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1374: ELSE
1375: RETURN NULL;
1376: END IF;
1377: ELSIF p_attr_code =('DEMAND_CLASS_CODE') THEN
1378: IF NVL(p_record.DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1379: RETURN to_date(p_record.DEMAND_CLASS_CODE,'RRRR/MM/DD HH24:MI:SS');
1380: ELSE
1381: RETURN NULL;
1382: END IF;

Line 1384: IF NVL(p_record.DRAFT_SUBMITTED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1380: ELSE
1381: RETURN NULL;
1382: END IF;
1383: ELSIF p_attr_code =('DRAFT_SUBMITTED_FLAG') THEN
1384: IF NVL(p_record.DRAFT_SUBMITTED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1385: RETURN to_date(p_record.DRAFT_SUBMITTED_FLAG,'RRRR/MM/DD HH24:MI:SS');
1386: ELSE
1387: RETURN NULL;
1388: END IF;

Line 1390: IF NVL(p_record.EARLIEST_SCHEDULE_LIMIT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1386: ELSE
1387: RETURN NULL;
1388: END IF;
1389: ELSIF p_attr_code =('EARLIEST_SCHEDULE_LIMIT') THEN
1390: IF NVL(p_record.EARLIEST_SCHEDULE_LIMIT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1391: RETURN to_date(p_record.EARLIEST_SCHEDULE_LIMIT,'RRRR/MM/DD HH24:MI:SS');
1392: ELSE
1393: RETURN NULL;
1394: END IF;

Line 1396: IF NVL(p_record.END_CUSTOMER_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1392: ELSE
1393: RETURN NULL;
1394: END IF;
1395: ELSIF p_attr_code =('END_CUSTOMER_CONTACT_ID') THEN
1396: IF NVL(p_record.END_CUSTOMER_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1397: RETURN to_date(p_record.END_CUSTOMER_CONTACT_ID,'RRRR/MM/DD HH24:MI:SS');
1398: ELSE
1399: RETURN NULL;
1400: END IF;

Line 1402: IF NVL(p_record.END_CUSTOMER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1398: ELSE
1399: RETURN NULL;
1400: END IF;
1401: ELSIF p_attr_code =('END_CUSTOMER_ID') THEN
1402: IF NVL(p_record.END_CUSTOMER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1403: RETURN to_date(p_record.END_CUSTOMER_ID,'RRRR/MM/DD HH24:MI:SS');
1404: ELSE
1405: RETURN NULL;
1406: END IF;

Line 1408: IF NVL(p_record.END_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1404: ELSE
1405: RETURN NULL;
1406: END IF;
1407: ELSIF p_attr_code =('END_CUSTOMER_SITE_USE_ID') THEN
1408: IF NVL(p_record.END_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1409: RETURN to_date(p_record.END_CUSTOMER_SITE_USE_ID,'RRRR/MM/DD HH24:MI:SS');
1410: ELSE
1411: RETURN NULL;
1412: END IF;

Line 1414: IF NVL(p_record.FIRST_ACK_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1410: ELSE
1411: RETURN NULL;
1412: END IF;
1413: ELSIF p_attr_code =('FIRST_ACK_CODE') THEN
1414: IF NVL(p_record.FIRST_ACK_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1415: RETURN to_date(p_record.FIRST_ACK_CODE,'RRRR/MM/DD HH24:MI:SS');
1416: ELSE
1417: RETURN NULL;
1418: END IF;

Line 1420: IF NVL(p_record.FLOW_STATUS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1416: ELSE
1417: RETURN NULL;
1418: END IF;
1419: ELSIF p_attr_code =('FLOW_STATUS_CODE') THEN
1420: IF NVL(p_record.FLOW_STATUS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1421: RETURN to_date(p_record.FLOW_STATUS_CODE,'RRRR/MM/DD HH24:MI:SS');
1422: ELSE
1423: RETURN NULL;
1424: END IF;

Line 1426: IF NVL(p_record.FOB_POINT_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1422: ELSE
1423: RETURN NULL;
1424: END IF;
1425: ELSIF p_attr_code =('FOB_POINT_CODE') THEN
1426: IF NVL(p_record.FOB_POINT_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1427: RETURN to_date(p_record.FOB_POINT_CODE,'RRRR/MM/DD HH24:MI:SS');
1428: ELSE
1429: RETURN NULL;
1430: END IF;

Line 1432: IF NVL(p_record.FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1428: ELSE
1429: RETURN NULL;
1430: END IF;
1431: ELSIF p_attr_code =('FREIGHT_CARRIER_CODE') THEN
1432: IF NVL(p_record.FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1433: RETURN to_date(p_record.FREIGHT_CARRIER_CODE,'RRRR/MM/DD HH24:MI:SS');
1434: ELSE
1435: RETURN NULL;
1436: END IF;

Line 1438: IF NVL(p_record.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1434: ELSE
1435: RETURN NULL;
1436: END IF;
1437: ELSIF p_attr_code =('FREIGHT_TERMS_CODE') THEN
1438: IF NVL(p_record.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1439: RETURN to_date(p_record.FREIGHT_TERMS_CODE,'RRRR/MM/DD HH24:MI:SS');
1440: ELSE
1441: RETURN NULL;
1442: END IF;

Line 1444: IF NVL(p_record.GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1440: ELSE
1441: RETURN NULL;
1442: END IF;
1443: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE1') THEN
1444: IF NVL(p_record.GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1445: RETURN to_date(p_record.GLOBAL_ATTRIBUTE1,'RRRR/MM/DD HH24:MI:SS');
1446: ELSE
1447: RETURN NULL;
1448: END IF;

Line 1450: IF NVL(p_record.GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1446: ELSE
1447: RETURN NULL;
1448: END IF;
1449: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE10') THEN
1450: IF NVL(p_record.GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1451: RETURN to_date(p_record.GLOBAL_ATTRIBUTE10,'RRRR/MM/DD HH24:MI:SS');
1452: ELSE
1453: RETURN NULL;
1454: END IF;

Line 1456: IF NVL(p_record.GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1452: ELSE
1453: RETURN NULL;
1454: END IF;
1455: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE11') THEN
1456: IF NVL(p_record.GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1457: RETURN to_date(p_record.GLOBAL_ATTRIBUTE11,'RRRR/MM/DD HH24:MI:SS');
1458: ELSE
1459: RETURN NULL;
1460: END IF;

Line 1462: IF NVL(p_record.GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1458: ELSE
1459: RETURN NULL;
1460: END IF;
1461: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE12') THEN
1462: IF NVL(p_record.GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1463: RETURN to_date(p_record.GLOBAL_ATTRIBUTE12,'RRRR/MM/DD HH24:MI:SS');
1464: ELSE
1465: RETURN NULL;
1466: END IF;

Line 1468: IF NVL(p_record.GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1464: ELSE
1465: RETURN NULL;
1466: END IF;
1467: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE13') THEN
1468: IF NVL(p_record.GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1469: RETURN to_date(p_record.GLOBAL_ATTRIBUTE13,'RRRR/MM/DD HH24:MI:SS');
1470: ELSE
1471: RETURN NULL;
1472: END IF;

Line 1474: IF NVL(p_record.GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1470: ELSE
1471: RETURN NULL;
1472: END IF;
1473: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE14') THEN
1474: IF NVL(p_record.GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1475: RETURN to_date(p_record.GLOBAL_ATTRIBUTE14,'RRRR/MM/DD HH24:MI:SS');
1476: ELSE
1477: RETURN NULL;
1478: END IF;

Line 1480: IF NVL(p_record.GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1476: ELSE
1477: RETURN NULL;
1478: END IF;
1479: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE15') THEN
1480: IF NVL(p_record.GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1481: RETURN to_date(p_record.GLOBAL_ATTRIBUTE15,'RRRR/MM/DD HH24:MI:SS');
1482: ELSE
1483: RETURN NULL;
1484: END IF;

Line 1486: IF NVL(p_record.GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1482: ELSE
1483: RETURN NULL;
1484: END IF;
1485: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE16') THEN
1486: IF NVL(p_record.GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1487: RETURN to_date(p_record.GLOBAL_ATTRIBUTE16,'RRRR/MM/DD HH24:MI:SS');
1488: ELSE
1489: RETURN NULL;
1490: END IF;

Line 1492: IF NVL(p_record.GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1488: ELSE
1489: RETURN NULL;
1490: END IF;
1491: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE17') THEN
1492: IF NVL(p_record.GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1493: RETURN to_date(p_record.GLOBAL_ATTRIBUTE17,'RRRR/MM/DD HH24:MI:SS');
1494: ELSE
1495: RETURN NULL;
1496: END IF;

Line 1498: IF NVL(p_record.GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1494: ELSE
1495: RETURN NULL;
1496: END IF;
1497: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE18') THEN
1498: IF NVL(p_record.GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1499: RETURN to_date(p_record.GLOBAL_ATTRIBUTE18,'RRRR/MM/DD HH24:MI:SS');
1500: ELSE
1501: RETURN NULL;
1502: END IF;

Line 1504: IF NVL(p_record.GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1500: ELSE
1501: RETURN NULL;
1502: END IF;
1503: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE19') THEN
1504: IF NVL(p_record.GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1505: RETURN to_date(p_record.GLOBAL_ATTRIBUTE19,'RRRR/MM/DD HH24:MI:SS');
1506: ELSE
1507: RETURN NULL;
1508: END IF;

Line 1510: IF NVL(p_record.GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1506: ELSE
1507: RETURN NULL;
1508: END IF;
1509: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE2') THEN
1510: IF NVL(p_record.GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1511: RETURN to_date(p_record.GLOBAL_ATTRIBUTE2,'RRRR/MM/DD HH24:MI:SS');
1512: ELSE
1513: RETURN NULL;
1514: END IF;

Line 1516: IF NVL(p_record.GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1512: ELSE
1513: RETURN NULL;
1514: END IF;
1515: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE20') THEN
1516: IF NVL(p_record.GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1517: RETURN to_date(p_record.GLOBAL_ATTRIBUTE20,'RRRR/MM/DD HH24:MI:SS');
1518: ELSE
1519: RETURN NULL;
1520: END IF;

Line 1522: IF NVL(p_record.GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1518: ELSE
1519: RETURN NULL;
1520: END IF;
1521: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE3') THEN
1522: IF NVL(p_record.GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1523: RETURN to_date(p_record.GLOBAL_ATTRIBUTE3,'RRRR/MM/DD HH24:MI:SS');
1524: ELSE
1525: RETURN NULL;
1526: END IF;

Line 1528: IF NVL(p_record.GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1524: ELSE
1525: RETURN NULL;
1526: END IF;
1527: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE4') THEN
1528: IF NVL(p_record.GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1529: RETURN to_date(p_record.GLOBAL_ATTRIBUTE4,'RRRR/MM/DD HH24:MI:SS');
1530: ELSE
1531: RETURN NULL;
1532: END IF;

Line 1534: IF NVL(p_record.GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1530: ELSE
1531: RETURN NULL;
1532: END IF;
1533: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE5') THEN
1534: IF NVL(p_record.GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1535: RETURN to_date(p_record.GLOBAL_ATTRIBUTE5,'RRRR/MM/DD HH24:MI:SS');
1536: ELSE
1537: RETURN NULL;
1538: END IF;

Line 1540: IF NVL(p_record.GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1536: ELSE
1537: RETURN NULL;
1538: END IF;
1539: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE6') THEN
1540: IF NVL(p_record.GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1541: RETURN to_date(p_record.GLOBAL_ATTRIBUTE6,'RRRR/MM/DD HH24:MI:SS');
1542: ELSE
1543: RETURN NULL;
1544: END IF;

Line 1546: IF NVL(p_record.GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1542: ELSE
1543: RETURN NULL;
1544: END IF;
1545: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE7') THEN
1546: IF NVL(p_record.GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1547: RETURN to_date(p_record.GLOBAL_ATTRIBUTE7,'RRRR/MM/DD HH24:MI:SS');
1548: ELSE
1549: RETURN NULL;
1550: END IF;

Line 1552: IF NVL(p_record.GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1548: ELSE
1549: RETURN NULL;
1550: END IF;
1551: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE8') THEN
1552: IF NVL(p_record.GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1553: RETURN to_date(p_record.GLOBAL_ATTRIBUTE8,'RRRR/MM/DD HH24:MI:SS');
1554: ELSE
1555: RETURN NULL;
1556: END IF;

Line 1558: IF NVL(p_record.GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1554: ELSE
1555: RETURN NULL;
1556: END IF;
1557: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE9') THEN
1558: IF NVL(p_record.GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1559: RETURN to_date(p_record.GLOBAL_ATTRIBUTE9,'RRRR/MM/DD HH24:MI:SS');
1560: ELSE
1561: RETURN NULL;
1562: END IF;

Line 1564: IF NVL(p_record.GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1560: ELSE
1561: RETURN NULL;
1562: END IF;
1563: ELSIF p_attr_code =('GLOBAL_ATTRIBUTE_CATEGORY') THEN
1564: IF NVL(p_record.GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1565: RETURN to_date(p_record.GLOBAL_ATTRIBUTE_CATEGORY,'RRRR/MM/DD HH24:MI:SS');
1566: ELSE
1567: RETURN NULL;
1568: END IF;

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

1566: ELSE
1567: RETURN NULL;
1568: END IF;
1569: ELSIF p_attr_code =('HEADER_ID') THEN
1570: IF NVL(p_record.HEADER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1571: RETURN to_date(p_record.HEADER_ID,'RRRR/MM/DD HH24:MI:SS');
1572: ELSE
1573: RETURN NULL;
1574: END IF;

Line 1576: IF NVL(p_record.IB_CURRENT_LOCATION, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1572: ELSE
1573: RETURN NULL;
1574: END IF;
1575: ELSIF p_attr_code =('IB_CURRENT_LOCATION') THEN
1576: IF NVL(p_record.IB_CURRENT_LOCATION, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1577: RETURN to_date(p_record.IB_CURRENT_LOCATION,'RRRR/MM/DD HH24:MI:SS');
1578: ELSE
1579: RETURN NULL;
1580: END IF;

Line 1582: IF NVL(p_record.IB_INSTALLED_AT_LOCATION, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1578: ELSE
1579: RETURN NULL;
1580: END IF;
1581: ELSIF p_attr_code =('IB_INSTALLED_AT_LOCATION') THEN
1582: IF NVL(p_record.IB_INSTALLED_AT_LOCATION, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1583: RETURN to_date(p_record.IB_INSTALLED_AT_LOCATION,'RRRR/MM/DD HH24:MI:SS');
1584: ELSE
1585: RETURN NULL;
1586: END IF;

Line 1588: IF NVL(p_record.IB_OWNER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1584: ELSE
1585: RETURN NULL;
1586: END IF;
1587: ELSIF p_attr_code =('IB_OWNER') THEN
1588: IF NVL(p_record.IB_OWNER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1589: RETURN to_date(p_record.IB_OWNER,'RRRR/MM/DD HH24:MI:SS');
1590: ELSE
1591: RETURN NULL;
1592: END IF;

Line 1594: IF NVL(p_record.INVOICE_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1590: ELSE
1591: RETURN NULL;
1592: END IF;
1593: ELSIF p_attr_code =('INVOICE_TO_CONTACT_ID') THEN
1594: IF NVL(p_record.INVOICE_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1595: RETURN to_date(p_record.INVOICE_TO_CONTACT_ID,'RRRR/MM/DD HH24:MI:SS');
1596: ELSE
1597: RETURN NULL;
1598: END IF;

Line 1600: IF NVL(p_record.INVOICE_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1596: ELSE
1597: RETURN NULL;
1598: END IF;
1599: ELSIF p_attr_code =('INVOICE_TO_ORG_ID') THEN
1600: IF NVL(p_record.INVOICE_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1601: RETURN to_date(p_record.INVOICE_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
1602: ELSE
1603: RETURN NULL;
1604: END IF;

Line 1606: IF NVL(p_record.INVOICING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1602: ELSE
1603: RETURN NULL;
1604: END IF;
1605: ELSIF p_attr_code =('INVOICING_RULE_ID') THEN
1606: IF NVL(p_record.INVOICING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1607: RETURN to_date(p_record.INVOICING_RULE_ID,'RRRR/MM/DD HH24:MI:SS');
1608: ELSE
1609: RETURN NULL;
1610: END IF;

Line 1612: IF NVL(p_record.LAST_ACK_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1608: ELSE
1609: RETURN NULL;
1610: END IF;
1611: ELSIF p_attr_code =('LAST_ACK_CODE') THEN
1612: IF NVL(p_record.LAST_ACK_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1613: RETURN to_date(p_record.LAST_ACK_CODE,'RRRR/MM/DD HH24:MI:SS');
1614: ELSE
1615: RETURN NULL;
1616: END IF;

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

1614: ELSE
1615: RETURN NULL;
1616: END IF;
1617: ELSIF p_attr_code =('LAST_UPDATED_BY') THEN
1618: IF NVL(p_record.LAST_UPDATED_BY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1619: RETURN to_date(p_record.LAST_UPDATED_BY,'RRRR/MM/DD HH24:MI:SS');
1620: ELSE
1621: RETURN NULL;
1622: END IF;

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

1620: ELSE
1621: RETURN NULL;
1622: END IF;
1623: ELSIF p_attr_code =('LAST_UPDATE_LOGIN') THEN
1624: IF NVL(p_record.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1625: RETURN to_date(p_record.LAST_UPDATE_LOGIN,'RRRR/MM/DD HH24:MI:SS');
1626: ELSE
1627: RETURN NULL;
1628: END IF;

Line 1630: IF NVL(p_record.LATEST_SCHEDULE_LIMIT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1626: ELSE
1627: RETURN NULL;
1628: END IF;
1629: ELSIF p_attr_code =('LATEST_SCHEDULE_LIMIT') THEN
1630: IF NVL(p_record.LATEST_SCHEDULE_LIMIT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1631: RETURN to_date(p_record.LATEST_SCHEDULE_LIMIT,'RRRR/MM/DD HH24:MI:SS');
1632: ELSE
1633: RETURN NULL;
1634: END IF;

Line 1636: IF NVL(p_record.OPEN_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1632: ELSE
1633: RETURN NULL;
1634: END IF;
1635: ELSIF p_attr_code =('OPEN_FLAG') THEN
1636: IF NVL(p_record.OPEN_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1637: RETURN to_date(p_record.OPEN_FLAG,'RRRR/MM/DD HH24:MI:SS');
1638: ELSE
1639: RETURN NULL;
1640: END IF;

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

1638: ELSE
1639: RETURN NULL;
1640: END IF;
1641: ELSIF p_attr_code =('OPERATION') THEN
1642: IF NVL(p_record.OPERATION, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1643: RETURN to_date(p_record.OPERATION,'RRRR/MM/DD HH24:MI:SS');
1644: ELSE
1645: RETURN NULL;
1646: END IF;

Line 1648: IF NVL(p_record.ORDER_CATEGORY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1644: ELSE
1645: RETURN NULL;
1646: END IF;
1647: ELSIF p_attr_code =('ORDER_CATEGORY_CODE') THEN
1648: IF NVL(p_record.ORDER_CATEGORY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1649: RETURN to_date(p_record.ORDER_CATEGORY_CODE,'RRRR/MM/DD HH24:MI:SS');
1650: ELSE
1651: RETURN NULL;
1652: END IF;

Line 1654: IF NVL(p_record.ORDER_DATE_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1650: ELSE
1651: RETURN NULL;
1652: END IF;
1653: ELSIF p_attr_code =('ORDER_DATE_TYPE_CODE') THEN
1654: IF NVL(p_record.ORDER_DATE_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1655: RETURN to_date(p_record.ORDER_DATE_TYPE_CODE,'RRRR/MM/DD HH24:MI:SS');
1656: ELSE
1657: RETURN NULL;
1658: END IF;

Line 1660: IF NVL(p_record.ORDER_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1656: ELSE
1657: RETURN NULL;
1658: END IF;
1659: ELSIF p_attr_code =('ORDER_NUMBER') THEN
1660: IF NVL(p_record.ORDER_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1661: RETURN to_date(p_record.ORDER_NUMBER,'RRRR/MM/DD HH24:MI:SS');
1662: ELSE
1663: RETURN NULL;
1664: END IF;

Line 1666: IF NVL(p_record.ORDER_SOURCE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1662: ELSE
1663: RETURN NULL;
1664: END IF;
1665: ELSIF p_attr_code =('ORDER_SOURCE_ID') THEN
1666: IF NVL(p_record.ORDER_SOURCE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1667: RETURN to_date(p_record.ORDER_SOURCE_ID,'RRRR/MM/DD HH24:MI:SS');
1668: ELSE
1669: RETURN NULL;
1670: END IF;

Line 1672: IF NVL(p_record.ORDER_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1668: ELSE
1669: RETURN NULL;
1670: END IF;
1671: ELSIF p_attr_code =('ORDER_TYPE_ID') THEN
1672: IF NVL(p_record.ORDER_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1673: RETURN to_date(p_record.ORDER_TYPE_ID,'RRRR/MM/DD HH24:MI:SS');
1674: ELSE
1675: RETURN NULL;
1676: END IF;

Line 1678: IF NVL(p_record.ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1674: ELSE
1675: RETURN NULL;
1676: END IF;
1677: ELSIF p_attr_code =('ORG_ID') THEN
1678: IF NVL(p_record.ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1679: RETURN to_date(p_record.ORG_ID,'RRRR/MM/DD HH24:MI:SS');
1680: ELSE
1681: RETURN NULL;
1682: END IF;

Line 1684: IF NVL(p_record.ORIG_SYS_DOCUMENT_REF, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1680: ELSE
1681: RETURN NULL;
1682: END IF;
1683: ELSIF p_attr_code =('ORIG_SYS_DOCUMENT_REF') THEN
1684: IF NVL(p_record.ORIG_SYS_DOCUMENT_REF, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1685: RETURN to_date(p_record.ORIG_SYS_DOCUMENT_REF,'RRRR/MM/DD HH24:MI:SS');
1686: ELSE
1687: RETURN NULL;
1688: END IF;

Line 1690: IF NVL(p_record.PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1686: ELSE
1687: RETURN NULL;
1688: END IF;
1689: ELSIF p_attr_code =('PACKING_INSTRUCTIONS') THEN
1690: IF NVL(p_record.PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1691: RETURN to_date(p_record.PACKING_INSTRUCTIONS,'RRRR/MM/DD HH24:MI:SS');
1692: ELSE
1693: RETURN NULL;
1694: END IF;

Line 1696: IF NVL(p_record.PARTIAL_SHIPMENTS_ALLOWED, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1692: ELSE
1693: RETURN NULL;
1694: END IF;
1695: ELSIF p_attr_code =('PARTIAL_SHIPMENTS_ALLOWED') THEN
1696: IF NVL(p_record.PARTIAL_SHIPMENTS_ALLOWED, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1697: RETURN to_date(p_record.PARTIAL_SHIPMENTS_ALLOWED,'RRRR/MM/DD HH24:MI:SS');
1698: ELSE
1699: RETURN NULL;
1700: END IF;

Line 1702: IF NVL(p_record.PARTY_TYPE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1698: ELSE
1699: RETURN NULL;
1700: END IF;
1701: ELSIF p_attr_code =('PARTY_TYPE') THEN
1702: IF NVL(p_record.PARTY_TYPE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1703: RETURN to_date(p_record.PARTY_TYPE,'RRRR/MM/DD HH24:MI:SS');
1704: ELSE
1705: RETURN NULL;
1706: END IF;

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

1704: ELSE
1705: RETURN NULL;
1706: END IF;
1707: ELSIF p_attr_code =('PAYMENT_AMOUNT') THEN
1708: IF NVL(p_record.PAYMENT_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1709: RETURN to_date(p_record.PAYMENT_AMOUNT,'RRRR/MM/DD HH24:MI:SS');
1710: ELSE
1711: RETURN NULL;
1712: END IF;

Line 1714: IF NVL(p_record.PAYMENT_TERM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1710: ELSE
1711: RETURN NULL;
1712: END IF;
1713: ELSIF p_attr_code =('PAYMENT_TERM_ID') THEN
1714: IF NVL(p_record.PAYMENT_TERM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1715: RETURN to_date(p_record.PAYMENT_TERM_ID,'RRRR/MM/DD HH24:MI:SS');
1716: ELSE
1717: RETURN NULL;
1718: END IF;

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

1716: ELSE
1717: RETURN NULL;
1718: END IF;
1719: ELSIF p_attr_code =('PAYMENT_TYPE_CODE') THEN
1720: IF NVL(p_record.PAYMENT_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1721: RETURN to_date(p_record.PAYMENT_TYPE_CODE,'RRRR/MM/DD HH24:MI:SS');
1722: ELSE
1723: RETURN NULL;
1724: END IF;

Line 1726: IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1722: ELSE
1723: RETURN NULL;
1724: END IF;
1725: ELSIF p_attr_code =('PRICE_LIST_ID') THEN
1726: IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1727: RETURN to_date(p_record.PRICE_LIST_ID,'RRRR/MM/DD HH24:MI:SS');
1728: ELSE
1729: RETURN NULL;
1730: END IF;

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

1728: ELSE
1729: RETURN NULL;
1730: END IF;
1731: ELSIF p_attr_code =('PROGRAM_APPLICATION_ID') THEN
1732: IF NVL(p_record.PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1733: RETURN to_date(p_record.PROGRAM_APPLICATION_ID,'RRRR/MM/DD HH24:MI:SS');
1734: ELSE
1735: RETURN NULL;
1736: END IF;

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

1734: ELSE
1735: RETURN NULL;
1736: END IF;
1737: ELSIF p_attr_code =('PROGRAM_ID') THEN
1738: IF NVL(p_record.PROGRAM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1739: RETURN to_date(p_record.PROGRAM_ID,'RRRR/MM/DD HH24:MI:SS');
1740: ELSE
1741: RETURN NULL;
1742: END IF;

Line 1744: IF NVL(p_record.QUOTE_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1740: ELSE
1741: RETURN NULL;
1742: END IF;
1743: ELSIF p_attr_code =('QUOTE_NUMBER') THEN
1744: IF NVL(p_record.QUOTE_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1745: RETURN to_date(p_record.QUOTE_NUMBER,'RRRR/MM/DD HH24:MI:SS');
1746: ELSE
1747: RETURN NULL;
1748: END IF;

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

1746: ELSE
1747: RETURN NULL;
1748: END IF;
1749: ELSIF p_attr_code =('REQUEST_ID') THEN
1750: IF NVL(p_record.REQUEST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1751: RETURN to_date(p_record.REQUEST_ID,'RRRR/MM/DD HH24:MI:SS');
1752: ELSE
1753: RETURN NULL;
1754: END IF;

Line 1756: IF NVL(p_record.RETURN_REASON_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1752: ELSE
1753: RETURN NULL;
1754: END IF;
1755: ELSIF p_attr_code =('RETURN_REASON_CODE') THEN
1756: IF NVL(p_record.RETURN_REASON_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1757: RETURN to_date(p_record.RETURN_REASON_CODE,'RRRR/MM/DD HH24:MI:SS');
1758: ELSE
1759: RETURN NULL;
1760: END IF;

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

1758: ELSE
1759: RETURN NULL;
1760: END IF;
1761: ELSIF p_attr_code =('RETURN_STATUS') THEN
1762: IF NVL(p_record.RETURN_STATUS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1763: RETURN to_date(p_record.RETURN_STATUS,'RRRR/MM/DD HH24:MI:SS');
1764: ELSE
1765: RETURN NULL;
1766: END IF;

Line 1768: IF NVL(p_record.SALESREP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1764: ELSE
1765: RETURN NULL;
1766: END IF;
1767: ELSIF p_attr_code =('SALESREP_ID') THEN
1768: IF NVL(p_record.SALESREP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1769: RETURN to_date(p_record.SALESREP_ID,'RRRR/MM/DD HH24:MI:SS');
1770: ELSE
1771: RETURN NULL;
1772: END IF;

Line 1774: IF NVL(p_record.SALES_CHANNEL_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1770: ELSE
1771: RETURN NULL;
1772: END IF;
1773: ELSIF p_attr_code =('SALES_CHANNEL_CODE') THEN
1774: IF NVL(p_record.SALES_CHANNEL_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1775: RETURN to_date(p_record.SALES_CHANNEL_CODE,'RRRR/MM/DD HH24:MI:SS');
1776: ELSE
1777: RETURN NULL;
1778: END IF;

Line 1780: IF NVL(p_record.SALES_DOCUMENT_NAME, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1776: ELSE
1777: RETURN NULL;
1778: END IF;
1779: ELSIF p_attr_code =('SALES_DOCUMENT_NAME') THEN
1780: IF NVL(p_record.SALES_DOCUMENT_NAME, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1781: RETURN to_date(p_record.SALES_DOCUMENT_NAME,'RRRR/MM/DD HH24:MI:SS');
1782: ELSE
1783: RETURN NULL;
1784: END IF;

Line 1786: IF NVL(p_record.SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1782: ELSE
1783: RETURN NULL;
1784: END IF;
1785: ELSIF p_attr_code =('SHIPMENT_PRIORITY_CODE') THEN
1786: IF NVL(p_record.SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1787: RETURN to_date(p_record.SHIPMENT_PRIORITY_CODE,'RRRR/MM/DD HH24:MI:SS');
1788: ELSE
1789: RETURN NULL;
1790: END IF;

Line 1792: IF NVL(p_record.SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1788: ELSE
1789: RETURN NULL;
1790: END IF;
1791: ELSIF p_attr_code =('SHIPPING_INSTRUCTIONS') THEN
1792: IF NVL(p_record.SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1793: RETURN to_date(p_record.SHIPPING_INSTRUCTIONS,'RRRR/MM/DD HH24:MI:SS');
1794: ELSE
1795: RETURN NULL;
1796: END IF;

Line 1798: IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1794: ELSE
1795: RETURN NULL;
1796: END IF;
1797: ELSIF p_attr_code =('SHIPPING_METHOD_CODE') THEN
1798: IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1799: RETURN to_date(p_record.SHIPPING_METHOD_CODE,'RRRR/MM/DD HH24:MI:SS');
1800: ELSE
1801: RETURN NULL;
1802: END IF;

Line 1804: IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1800: ELSE
1801: RETURN NULL;
1802: END IF;
1803: ELSIF p_attr_code =('SHIP_FROM_ORG_ID') THEN
1804: IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1805: RETURN to_date(p_record.SHIP_FROM_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
1806: ELSE
1807: RETURN NULL;
1808: END IF;

Line 1810: IF NVL(p_record.SHIP_TOLERANCE_ABOVE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1806: ELSE
1807: RETURN NULL;
1808: END IF;
1809: ELSIF p_attr_code =('SHIP_TOLERANCE_ABOVE') THEN
1810: IF NVL(p_record.SHIP_TOLERANCE_ABOVE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1811: RETURN to_date(p_record.SHIP_TOLERANCE_ABOVE,'RRRR/MM/DD HH24:MI:SS');
1812: ELSE
1813: RETURN NULL;
1814: END IF;

Line 1816: IF NVL(p_record.SHIP_TOLERANCE_BELOW, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1812: ELSE
1813: RETURN NULL;
1814: END IF;
1815: ELSIF p_attr_code =('SHIP_TOLERANCE_BELOW') THEN
1816: IF NVL(p_record.SHIP_TOLERANCE_BELOW, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1817: RETURN to_date(p_record.SHIP_TOLERANCE_BELOW,'RRRR/MM/DD HH24:MI:SS');
1818: ELSE
1819: RETURN NULL;
1820: END IF;

Line 1822: IF NVL(p_record.SHIP_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1818: ELSE
1819: RETURN NULL;
1820: END IF;
1821: ELSIF p_attr_code =('SHIP_TO_CONTACT_ID') THEN
1822: IF NVL(p_record.SHIP_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1823: RETURN to_date(p_record.SHIP_TO_CONTACT_ID,'RRRR/MM/DD HH24:MI:SS');
1824: ELSE
1825: RETURN NULL;
1826: END IF;

Line 1828: IF NVL(p_record.SHIP_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1824: ELSE
1825: RETURN NULL;
1826: END IF;
1827: ELSIF p_attr_code =('SHIP_TO_ORG_ID') THEN
1828: IF NVL(p_record.SHIP_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1829: RETURN to_date(p_record.SHIP_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
1830: ELSE
1831: RETURN NULL;
1832: END IF;

Line 1834: IF NVL(p_record.SOLD_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1830: ELSE
1831: RETURN NULL;
1832: END IF;
1833: ELSIF p_attr_code =('SOLD_FROM_ORG_ID') THEN
1834: IF NVL(p_record.SOLD_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1835: RETURN to_date(p_record.SOLD_FROM_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
1836: ELSE
1837: RETURN NULL;
1838: END IF;

Line 1840: IF NVL(p_record.SOLD_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1836: ELSE
1837: RETURN NULL;
1838: END IF;
1839: ELSIF p_attr_code =('SOLD_TO_CONTACT_ID') THEN
1840: IF NVL(p_record.SOLD_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1841: RETURN to_date(p_record.SOLD_TO_CONTACT_ID,'RRRR/MM/DD HH24:MI:SS');
1842: ELSE
1843: RETURN NULL;
1844: END IF;

Line 1846: IF NVL(p_record.SOLD_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1842: ELSE
1843: RETURN NULL;
1844: END IF;
1845: ELSIF p_attr_code =('SOLD_TO_ORG_ID') THEN
1846: IF NVL(p_record.SOLD_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1847: RETURN to_date(p_record.SOLD_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
1848: ELSE
1849: RETURN NULL;
1850: END IF;

Line 1852: IF NVL(p_record.SOLD_TO_SITE_USE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1848: ELSE
1849: RETURN NULL;
1850: END IF;
1851: ELSIF p_attr_code =('SOLD_TO_SITE_USE_ID') THEN
1852: IF NVL(p_record.SOLD_TO_SITE_USE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1853: RETURN to_date(p_record.SOLD_TO_SITE_USE_ID,'RRRR/MM/DD HH24:MI:SS');
1854: ELSE
1855: RETURN NULL;
1856: END IF;

Line 1858: IF NVL(p_record.SOURCE_DOCUMENT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1854: ELSE
1855: RETURN NULL;
1856: END IF;
1857: ELSIF p_attr_code =('SOURCE_DOCUMENT_ID') THEN
1858: IF NVL(p_record.SOURCE_DOCUMENT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1859: RETURN to_date(p_record.SOURCE_DOCUMENT_ID,'RRRR/MM/DD HH24:MI:SS');
1860: ELSE
1861: RETURN NULL;
1862: END IF;

Line 1864: IF NVL(p_record.SOURCE_DOCUMENT_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1860: ELSE
1861: RETURN NULL;
1862: END IF;
1863: ELSIF p_attr_code =('SOURCE_DOCUMENT_TYPE_ID') THEN
1864: IF NVL(p_record.SOURCE_DOCUMENT_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1865: RETURN to_date(p_record.SOURCE_DOCUMENT_TYPE_ID,'RRRR/MM/DD HH24:MI:SS');
1866: ELSE
1867: RETURN NULL;
1868: END IF;

Line 1870: IF NVL(p_record.SOURCE_DOCUMENT_VERSION_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1866: ELSE
1867: RETURN NULL;
1868: END IF;
1869: ELSIF p_attr_code =('SOURCE_DOCUMENT_VERSION_NUMBER') THEN
1870: IF NVL(p_record.SOURCE_DOCUMENT_VERSION_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1871: RETURN to_date(p_record.SOURCE_DOCUMENT_VERSION_NUMBER,'RRRR/MM/DD HH24:MI:SS');
1872: ELSE
1873: RETURN NULL;
1874: END IF;

Line 1876: IF NVL(p_record.SUPPLIER_SIGNATURE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1872: ELSE
1873: RETURN NULL;
1874: END IF;
1875: ELSIF p_attr_code =('SUPPLIER_SIGNATURE') THEN
1876: IF NVL(p_record.SUPPLIER_SIGNATURE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1877: RETURN to_date(p_record.SUPPLIER_SIGNATURE,'RRRR/MM/DD HH24:MI:SS');
1878: ELSE
1879: RETURN NULL;
1880: END IF;

Line 1882: IF NVL(p_record.TAX_EXEMPT_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1878: ELSE
1879: RETURN NULL;
1880: END IF;
1881: ELSIF p_attr_code =('TAX_EXEMPT_FLAG') THEN
1882: IF NVL(p_record.TAX_EXEMPT_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1883: RETURN to_date(p_record.TAX_EXEMPT_FLAG,'RRRR/MM/DD HH24:MI:SS');
1884: ELSE
1885: RETURN NULL;
1886: END IF;

Line 1888: IF NVL(p_record.TAX_EXEMPT_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1884: ELSE
1885: RETURN NULL;
1886: END IF;
1887: ELSIF p_attr_code =('TAX_EXEMPT_NUMBER') THEN
1888: IF NVL(p_record.TAX_EXEMPT_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1889: RETURN to_date(p_record.TAX_EXEMPT_NUMBER,'RRRR/MM/DD HH24:MI:SS');
1890: ELSE
1891: RETURN NULL;
1892: END IF;

Line 1894: IF NVL(p_record.TAX_EXEMPT_REASON_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1890: ELSE
1891: RETURN NULL;
1892: END IF;
1893: ELSIF p_attr_code =('TAX_EXEMPT_REASON_CODE') THEN
1894: IF NVL(p_record.TAX_EXEMPT_REASON_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1895: RETURN to_date(p_record.TAX_EXEMPT_REASON_CODE,'RRRR/MM/DD HH24:MI:SS');
1896: ELSE
1897: RETURN NULL;
1898: END IF;

Line 1900: IF NVL(p_record.TAX_POINT_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1896: ELSE
1897: RETURN NULL;
1898: END IF;
1899: ELSIF p_attr_code =('TAX_POINT_CODE') THEN
1900: IF NVL(p_record.TAX_POINT_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1901: RETURN to_date(p_record.TAX_POINT_CODE,'RRRR/MM/DD HH24:MI:SS');
1902: ELSE
1903: RETURN NULL;
1904: END IF;

Line 1906: IF NVL(p_record.TRANSACTIONAL_CURR_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1902: ELSE
1903: RETURN NULL;
1904: END IF;
1905: ELSIF p_attr_code =('TRANSACTIONAL_CURR_CODE') THEN
1906: IF NVL(p_record.TRANSACTIONAL_CURR_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1907: RETURN to_date(p_record.TRANSACTIONAL_CURR_CODE,'RRRR/MM/DD HH24:MI:SS');
1908: ELSE
1909: RETURN NULL;
1910: END IF;

Line 1912: IF NVL(p_record.TRANSACTION_PHASE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1908: ELSE
1909: RETURN NULL;
1910: END IF;
1911: ELSIF p_attr_code =('TRANSACTION_PHASE_CODE') THEN
1912: IF NVL(p_record.TRANSACTION_PHASE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1913: RETURN to_date(p_record.TRANSACTION_PHASE_CODE,'RRRR/MM/DD HH24:MI:SS');
1914: ELSE
1915: RETURN NULL;
1916: END IF;

Line 1918: IF NVL(p_record.UPGRADED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1914: ELSE
1915: RETURN NULL;
1916: END IF;
1917: ELSIF p_attr_code =('UPGRADED_FLAG') THEN
1918: IF NVL(p_record.UPGRADED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1919: RETURN to_date(p_record.UPGRADED_FLAG,'RRRR/MM/DD HH24:MI:SS');
1920: ELSE
1921: RETURN NULL;
1922: END IF;

Line 1924: IF NVL(p_record.USER_STATUS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1920: ELSE
1921: RETURN NULL;
1922: END IF;
1923: ELSIF p_attr_code =('USER_STATUS_CODE') THEN
1924: IF NVL(p_record.USER_STATUS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1925: RETURN to_date(p_record.USER_STATUS_CODE,'RRRR/MM/DD HH24:MI:SS');
1926: ELSE
1927: RETURN NULL;
1928: END IF;

Line 1930: IF NVL(p_record.VERSION_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1926: ELSE
1927: RETURN NULL;
1928: END IF;
1929: ELSIF p_attr_code =('VERSION_NUMBER') THEN
1930: IF NVL(p_record.VERSION_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1931: RETURN to_date(p_record.VERSION_NUMBER,'RRRR/MM/DD HH24:MI:SS');
1932: ELSE
1933: RETURN NULL;
1934: END IF;

Line 1961: IF (NVL(p_HEADER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)

1957: WHERE HEADER_ID = p_HEADER_ID
1958: ;
1959: BEGIN
1960:
1961: IF (NVL(p_HEADER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
1962: THEN
1963: RETURN 0 ;
1964: ELSIF (NVL(g_cached_record.HEADER_ID,FND_API.G_MISS_NUM) <> p_HEADER_ID)
1965: THEN

Line 1964: ELSIF (NVL(g_cached_record.HEADER_ID,FND_API.G_MISS_NUM) <> p_HEADER_ID)

1960:
1961: IF (NVL(p_HEADER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
1962: THEN
1963: RETURN 0 ;
1964: ELSIF (NVL(g_cached_record.HEADER_ID,FND_API.G_MISS_NUM) <> p_HEADER_ID)
1965: THEN
1966: Clear_HEADER_Cache;
1967: Open cache;
1968: FETCH cache into g_cached_record;

Line 1994: IF NVL(p_record.BLANKET_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

1990:
1991: BEGIN
1992:
1993: IF (p_foreign_database_object_name = 'OE_AK_BLANKET_HEADERS_V') THEN
1994: IF NVL(p_record.BLANKET_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
1995: RETURN NULL;
1996: END IF;
1997: IF ONT_BLANKET_HEADER_Def_Util.Sync_BLANKET_HEADER_Cache
1998: (p_ORDER_NUMBER => p_record.BLANKET_NUMBER) = 1 then

Line 2004: IF NVL(p_record.LATEST_SCHEDULE_LIMIT,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2000: (p_foreign_attr_code,ONT_BLANKET_HEADER_Def_Util.g_cached_record);
2001: END IF;
2002:
2003: ELSIF (p_foreign_database_object_name = 'OE_AK_LAT_SCH_LIMIT_V') THEN
2004: IF NVL(p_record.LATEST_SCHEDULE_LIMIT,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2005: RETURN NULL;
2006: END IF;
2007: IF ONT_LAT_SCH_LIMIT_Def_Util.Sync_LAT_SCH_LIMIT_Cache
2008: (p_LATEST_SCHEDULE_LIMIT => p_record.LATEST_SCHEDULE_LIMIT) = 1 then

Line 2014: IF NVL(p_record.EARLIEST_SCHEDULE_LIMIT,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2010: (p_foreign_attr_code,ONT_LAT_SCH_LIMIT_Def_Util.g_cached_record);
2011: END IF;
2012:
2013: ELSIF (p_foreign_database_object_name = 'OE_AK_EAR_SCH_LIMIT_V') THEN
2014: IF NVL(p_record.EARLIEST_SCHEDULE_LIMIT,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2015: RETURN NULL;
2016: END IF;
2017: IF ONT_EAR_SCH_LIMIT_Def_Util.Sync_EAR_SCH_LIMIT_Cache
2018: (p_EARLIEST_SCHEDULE_LIMIT => p_record.EARLIEST_SCHEDULE_LIMIT) = 1 then

Line 2024: IF NVL(p_record.SALES_CHANNEL_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2020: (p_foreign_attr_code,ONT_EAR_SCH_LIMIT_Def_Util.g_cached_record);
2021: END IF;
2022:
2023: ELSIF (p_foreign_database_object_name = 'OE_AK_SALES_CHANNEL_V') THEN
2024: IF NVL(p_record.SALES_CHANNEL_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2025: RETURN NULL;
2026: END IF;
2027: IF ONT_SALES_CHANNEL_Def_Util.Sync_SALES_CHANNEL_Cache
2028: (p_SALES_CHANNEL_CODE => p_record.SALES_CHANNEL_CODE) = 1 then

Line 2034: IF NVL(p_record.ORDER_DATE_TYPE_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2030: (p_foreign_attr_code,ONT_SALES_CHANNEL_Def_Util.g_cached_record);
2031: END IF;
2032:
2033: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_DATE_TYPE_V') THEN
2034: IF NVL(p_record.ORDER_DATE_TYPE_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2035: RETURN NULL;
2036: END IF;
2037: IF ONT_ORD_DATE_TYPE_Def_Util.Sync_ORD_DATE_TYPE_Cache
2038: (p_ORDER_DATE_TYPE_CODE => p_record.ORDER_DATE_TYPE_CODE) = 1 then

Line 2044: IF NVL(p_record.DEFAULT_FULFILLMENT_SET,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2040: (p_foreign_attr_code,ONT_ORD_DATE_TYPE_Def_Util.g_cached_record);
2041: END IF;
2042:
2043: ELSIF (p_foreign_database_object_name = 'OE_AK_DEFAULT_FULFILMENT_SET_V') THEN
2044: IF NVL(p_record.DEFAULT_FULFILLMENT_SET,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2045: RETURN NULL;
2046: END IF;
2047: IF ONT_DEF_FULFILL_Def_Util.Sync_DEF_FULFILL_Cache
2048: (p_DEFAULT_FULFILLMENT_SET => p_record.DEFAULT_FULFILLMENT_SET) = 1 then

Line 2054: IF NVL(p_record.CUSTOMER_PREFERENCE_SET_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2050: (p_foreign_attr_code,ONT_DEF_FULFILL_Def_Util.g_cached_record);
2051: END IF;
2052:
2053: ELSIF (p_foreign_database_object_name = 'OE_AK_DEFAULT_LINE_SET_V') THEN
2054: IF NVL(p_record.CUSTOMER_PREFERENCE_SET_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2055: RETURN NULL;
2056: END IF;
2057: IF ONT_DEF_LINESET_Def_Util.Sync_DEF_LINESET_Cache
2058: (p_DEFAULT_LINE_SET => p_record.CUSTOMER_PREFERENCE_SET_CODE) = 1 then

Line 2064: IF NVL(p_record.SOLD_TO_SITE_USE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2060: (p_foreign_attr_code,ONT_DEF_LINESET_Def_Util.g_cached_record);
2061: END IF;
2062:
2063: ELSIF (p_foreign_database_object_name = 'OE_AK_SOLD_TO_SITE_USES_V') THEN
2064: IF NVL(p_record.SOLD_TO_SITE_USE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2065: RETURN NULL;
2066: END IF;
2067: IF ONT_SOLD_TO_SU_Def_Util.Sync_SOLD_TO_SU_Cache
2068: (p_SOLD_TO_SITE_USE_ID => p_record.SOLD_TO_SITE_USE_ID) = 1 then

Line 2074: IF NVL(p_record.TRANSACTION_PHASE_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2070: (p_foreign_attr_code,ONT_SOLD_TO_SU_Def_Util.g_cached_record);
2071: END IF;
2072:
2073: ELSIF (p_foreign_database_object_name = 'OE_AK_TRXN_PHASE_V') THEN
2074: IF NVL(p_record.TRANSACTION_PHASE_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2075: RETURN NULL;
2076: END IF;
2077: IF ONT_TRXN_PHASE_Def_Util.Sync_TRXN_PHASE_Cache
2078: (p_TRANSACTION_PHASE_CODE => p_record.TRANSACTION_PHASE_CODE) = 1 then

Line 2084: IF NVL(p_record.END_CUSTOMER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2080: (p_foreign_attr_code,ONT_TRXN_PHASE_Def_Util.g_cached_record);
2081: END IF;
2082:
2083: ELSIF (p_foreign_database_object_name = 'OE_AK_END_CUS_V') THEN
2084: IF NVL(p_record.END_CUSTOMER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2085: RETURN NULL;
2086: END IF;
2087: IF ONT_END_CUSTOMER_Def_Util.Sync_END_CUSTOMER_Cache
2088: (p_END_CUSTOMER_ID => p_record.END_CUSTOMER_ID) = 1 then

Line 2094: IF NVL(p_record.END_CUSTOMER_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2090: (p_foreign_attr_code,ONT_END_CUSTOMER_Def_Util.g_cached_record);
2091: END IF;
2092:
2093: ELSIF (p_foreign_database_object_name = 'OE_AK_END_CUS_CONT_V') THEN
2094: IF NVL(p_record.END_CUSTOMER_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2095: RETURN NULL;
2096: END IF;
2097: IF ONT_EC_CONTACT_Def_Util.Sync_EC_CONTACT_Cache
2098: (p_END_CUSTOMER_CONTACT_ID => p_record.END_CUSTOMER_CONTACT_ID) = 1 then

Line 2104: IF NVL(p_record.END_CUSTOMER_SITE_USE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2100: (p_foreign_attr_code,ONT_EC_CONTACT_Def_Util.g_cached_record);
2101: END IF;
2102:
2103: ELSIF (p_foreign_database_object_name = 'OE_AK_END_CUS_SITEUSE_V') THEN
2104: IF NVL(p_record.END_CUSTOMER_SITE_USE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2105: RETURN NULL;
2106: END IF;
2107: IF ONT_EC_LOCATION_Def_Util.Sync_EC_LOCATION_Cache
2108: (p_END_CUSTOMER_SITE_USE_ID => p_record.END_CUSTOMER_SITE_USE_ID) = 1 then

Line 2114: IF NVL(p_record.IB_OWNER,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2110: (p_foreign_attr_code,ONT_EC_LOCATION_Def_Util.g_cached_record);
2111: END IF;
2112:
2113: ELSIF (p_foreign_database_object_name = 'OE_AK_IB_OWNER_V') THEN
2114: IF NVL(p_record.IB_OWNER,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2115: RETURN NULL;
2116: END IF;
2117: IF ONT_IB_OWNER_Def_Util.Sync_IB_OWNER_Cache
2118: (p_IB_OWNER => p_record.IB_OWNER) = 1 then

Line 2124: IF NVL(p_record.IB_INSTALLED_AT_LOCATION,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2120: (p_foreign_attr_code,ONT_IB_OWNER_Def_Util.g_cached_record);
2121: END IF;
2122:
2123: ELSIF (p_foreign_database_object_name = 'OE_AK_IB_INSTALL_LOC_V') THEN
2124: IF NVL(p_record.IB_INSTALLED_AT_LOCATION,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2125: RETURN NULL;
2126: END IF;
2127: IF ONT_IB_INSTALL_LOC_Def_Util.Sync_IB_INSTALL_LOC_Cache
2128: (p_IB_INSTALLED_AT_LOCATION => p_record.IB_INSTALLED_AT_LOCATION) = 1 then

Line 2134: IF NVL(p_record.IB_CURRENT_LOCATION,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2130: (p_foreign_attr_code,ONT_IB_INSTALL_LOC_Def_Util.g_cached_record);
2131: END IF;
2132:
2133: ELSIF (p_foreign_database_object_name = 'OE_AK_IB_CURR_LOC_V') THEN
2134: IF NVL(p_record.IB_CURRENT_LOCATION,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2135: RETURN NULL;
2136: END IF;
2137: IF ONT_IB_CURR_LOC_Def_Util.Sync_IB_CURR_LOC_Cache
2138: (p_IB_CURRENT_LOCATION => p_record.IB_CURRENT_LOCATION) = 1 then

Line 2144: IF NVL(p_record.ORDER_FIRMED_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN

2140: (p_foreign_attr_code,ONT_IB_CURR_LOC_Def_Util.g_cached_record);
2141: END IF;
2142:
2143: ELSIF (p_foreign_database_object_name = 'OE_AK_ORD_FIRMED_DATE_V') THEN
2144: IF NVL(p_record.ORDER_FIRMED_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
2145: RETURN NULL;
2146: END IF;
2147: IF ONT_ORD_FIRMED_DATE_Def_Util.Sync_ORD_FIRMED_DATE_Cache
2148: (p_ORDER_FIRMED_DATE => p_record.ORDER_FIRMED_DATE) = 1 then

Line 2154: IF NVL(p_record.CONVERSION_TYPE_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2150: (p_foreign_attr_code,ONT_ORD_FIRMED_DATE_Def_Util.g_cached_record);
2151: END IF;
2152:
2153: ELSIF (p_foreign_database_object_name = 'OE_AK_CONVERSION_TYPES_V') THEN
2154: IF NVL(p_record.CONVERSION_TYPE_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2155: RETURN NULL;
2156: END IF;
2157: IF ONT_CONV_TYPE_Def_Util.Sync_CONV_TYPE_Cache
2158: (p_CONVERSION_TYPE_CODE => p_record.CONVERSION_TYPE_CODE) = 1 then

Line 2164: IF NVL(p_record.AGREEMENT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2160: (p_foreign_attr_code,ONT_CONV_TYPE_Def_Util.g_cached_record);
2161: END IF;
2162:
2163: ELSIF (p_foreign_database_object_name = 'OE_AGREEMENTS_V') THEN
2164: IF NVL(p_record.AGREEMENT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2165: RETURN NULL;
2166: END IF;
2167: IF ONT_AGREEMENT_Def_Util.Sync_AGREEMENT_Cache
2168: (p_AGREEMENT_ID => p_record.AGREEMENT_ID) = 1 then

Line 2174: IF NVL(p_record.DELIVER_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2170: (p_foreign_attr_code,ONT_AGREEMENT_Def_Util.g_cached_record);
2171: END IF;
2172:
2173: ELSIF (p_foreign_database_object_name = 'OE_AK_DEL_TO_CONTACT_V') THEN
2174: IF NVL(p_record.DELIVER_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2175: RETURN NULL;
2176: END IF;
2177: IF ONT_DEL_TO_CON_Def_Util.Sync_DEL_TO_CON_Cache
2178: (p_CONTACT_ID => p_record.DELIVER_TO_CONTACT_ID) = 1 then

Line 2184: IF NVL(p_record.DEMAND_CLASS_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2180: (p_foreign_attr_code,ONT_DEL_TO_CON_Def_Util.g_cached_record);
2181: END IF;
2182:
2183: ELSIF (p_foreign_database_object_name = 'OE_AK_DEMAND_CLASS_V') THEN
2184: IF NVL(p_record.DEMAND_CLASS_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2185: RETURN NULL;
2186: END IF;
2187: IF ONT_DEM_CLASS_Def_Util.Sync_DEM_CLASS_Cache
2188: (p_DEMAND_CLASS_CODE => p_record.DEMAND_CLASS_CODE) = 1 then

Line 2194: IF NVL(p_record.FOB_POINT_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2190: (p_foreign_attr_code,ONT_DEM_CLASS_Def_Util.g_cached_record);
2191: END IF;
2192:
2193: ELSIF (p_foreign_database_object_name = 'OE_AK_FOB_POINT_V') THEN
2194: IF NVL(p_record.FOB_POINT_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2195: RETURN NULL;
2196: END IF;
2197: IF ONT_FOB_Def_Util.Sync_FOB_Cache
2198: (p_FOB_POINT_CODE => p_record.FOB_POINT_CODE) = 1 then

Line 2204: IF NVL(p_record.FREIGHT_TERMS_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2200: (p_foreign_attr_code,ONT_FOB_Def_Util.g_cached_record);
2201: END IF;
2202:
2203: ELSIF (p_foreign_database_object_name = 'OE_AK_FREIGHT_TERMS_V') THEN
2204: IF NVL(p_record.FREIGHT_TERMS_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2205: RETURN NULL;
2206: END IF;
2207: IF ONT_FR_TERM_Def_Util.Sync_FR_TERM_Cache
2208: (p_FREIGHT_TERMS_CODE => p_record.FREIGHT_TERMS_CODE) = 1 then

Line 2214: IF NVL(p_record.INVOICE_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2210: (p_foreign_attr_code,ONT_FR_TERM_Def_Util.g_cached_record);
2211: END IF;
2212:
2213: ELSIF (p_foreign_database_object_name = 'OE_AK_INV_TO_CONTACT_V') THEN
2214: IF NVL(p_record.INVOICE_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2215: RETURN NULL;
2216: END IF;
2217: IF ONT_INV_TO_CON_Def_Util.Sync_INV_TO_CON_Cache
2218: (p_CONTACT_ID => p_record.INVOICE_TO_CONTACT_ID) = 1 then

Line 2224: IF NVL(p_record.ACCOUNTING_RULE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2220: (p_foreign_attr_code,ONT_INV_TO_CON_Def_Util.g_cached_record);
2221: END IF;
2222:
2223: ELSIF (p_foreign_database_object_name = 'OE_AK_ACC_RULES_V') THEN
2224: IF NVL(p_record.ACCOUNTING_RULE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2225: RETURN NULL;
2226: END IF;
2227: IF ONT_ACC_RULE_Def_Util.Sync_ACC_RULE_Cache
2228: (p_ACCOUNTING_RULE_ID => p_record.ACCOUNTING_RULE_ID) = 1 then

Line 2234: IF NVL(p_record.DELIVER_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2230: (p_foreign_attr_code,ONT_ACC_RULE_Def_Util.g_cached_record);
2231: END IF;
2232:
2233: ELSIF (p_foreign_database_object_name = 'OE_AK_DELIVER_TO_ORGS_V') THEN
2234: IF NVL(p_record.DELIVER_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2235: RETURN NULL;
2236: END IF;
2237: IF ONT_DEL_TO_ORG_Def_Util.Sync_DEL_TO_ORG_Cache
2238: (p_ORGANIZATION_ID => p_record.DELIVER_TO_ORG_ID) = 1 then

Line 2244: IF NVL(p_record.INVOICE_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2240: (p_foreign_attr_code,ONT_DEL_TO_ORG_Def_Util.g_cached_record);
2241: END IF;
2242:
2243: ELSIF (p_foreign_database_object_name = 'OE_AK_INVOICE_TO_ORGS_V') THEN
2244: IF NVL(p_record.INVOICE_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2245: RETURN NULL;
2246: END IF;
2247: IF ONT_INV_ORG_Def_Util.Sync_INV_ORG_Cache
2248: (p_ORGANIZATION_ID => p_record.INVOICE_TO_ORG_ID) = 1 then

Line 2254: IF NVL(p_record.INVOICING_RULE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2250: (p_foreign_attr_code,ONT_INV_ORG_Def_Util.g_cached_record);
2251: END IF;
2252:
2253: ELSIF (p_foreign_database_object_name = 'OE_AK_INV_RULES_V') THEN
2254: IF NVL(p_record.INVOICING_RULE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2255: RETURN NULL;
2256: END IF;
2257: IF ONT_INV_RULE_Def_Util.Sync_INV_RULE_Cache
2258: (p_INVOICING_RULE_ID => p_record.INVOICING_RULE_ID) = 1 then

Line 2264: IF NVL(p_record.SHIP_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2260: (p_foreign_attr_code,ONT_INV_RULE_Def_Util.g_cached_record);
2261: END IF;
2262:
2263: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TO_ORGS_V') THEN
2264: IF NVL(p_record.SHIP_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2265: RETURN NULL;
2266: END IF;
2267: IF ONT_SHIP_TO_ORG_Def_Util.Sync_SHIP_TO_ORG_Cache
2268: (p_ORGANIZATION_ID => p_record.SHIP_TO_ORG_ID) = 1 then

Line 2274: IF ( NVL(p_record.SOLD_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )

2270: (p_foreign_attr_code,ONT_SHIP_TO_ORG_Def_Util.g_cached_record);
2271: END IF;
2272:
2273: ELSIF (p_foreign_database_object_name = 'OE_AK_SOLD_TO_ORGS_V') THEN
2274: IF ( NVL(p_record.SOLD_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )
2275: OR ( NVL(p_record.ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )
2276: THEN
2277: RETURN NULL;
2278: END IF;

Line 2275: OR ( NVL(p_record.ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )

2271: END IF;
2272:
2273: ELSIF (p_foreign_database_object_name = 'OE_AK_SOLD_TO_ORGS_V') THEN
2274: IF ( NVL(p_record.SOLD_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )
2275: OR ( NVL(p_record.ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )
2276: THEN
2277: RETURN NULL;
2278: END IF;
2279: IF ONT_SOLD_TO_ORG_Def_Util.Sync_SOLD_TO_ORG_Cache(p_ORGANIZATION_ID => p_record.SOLD_TO_ORG_ID,

Line 2285: IF NVL(p_record.ORDER_TYPE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2281: RETURN ONT_SOLD_TO_ORG_Def_Util.Get_Attr_Val_Varchar2(p_foreign_attr_code,ONT_SOLD_TO_ORG_Def_Util.g_cached_record);
2282: END IF;
2283:
2284: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_TYPES_V') THEN
2285: IF NVL(p_record.ORDER_TYPE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2286: RETURN NULL;
2287: END IF;
2288: IF ONT_ORDER_TYPE_Def_Util.Sync_ORDER_TYPE_Cache
2289: (p_ORDER_TYPE_ID => p_record.ORDER_TYPE_ID) = 1 then

Line 2295: IF NVL(p_record.PAYMENT_TERM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2291: (p_foreign_attr_code,ONT_ORDER_TYPE_Def_Util.g_cached_record);
2292: END IF;
2293:
2294: ELSIF (p_foreign_database_object_name = 'OE_AK_PAYMENT_TERM_V') THEN
2295: IF NVL(p_record.PAYMENT_TERM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2296: RETURN NULL;
2297: END IF;
2298: IF ONT_PAY_TERM_Def_Util.Sync_PAY_TERM_Cache
2299: (p_PAYMENT_TERM_ID => p_record.PAYMENT_TERM_ID) = 1 then

Line 2305: IF NVL(p_record.PRICE_LIST_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2301: (p_foreign_attr_code,ONT_PAY_TERM_Def_Util.g_cached_record);
2302: END IF;
2303:
2304: ELSIF (p_foreign_database_object_name = 'OE_PRICE_LISTS_V') THEN
2305: IF NVL(p_record.PRICE_LIST_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2306: RETURN NULL;
2307: END IF;
2308: IF ONT_PRICE_LIST_Def_Util.Sync_PRICE_LIST_Cache
2309: (p_PRICE_LIST_ID => p_record.PRICE_LIST_ID) = 1 then

Line 2315: IF NVL(p_record.REQUEST_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN

2311: (p_foreign_attr_code,ONT_PRICE_LIST_Def_Util.g_cached_record);
2312: END IF;
2313:
2314: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
2315: IF NVL(p_record.REQUEST_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
2316: RETURN NULL;
2317: END IF;
2318: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
2319: (p_REQUEST_DATE => p_record.REQUEST_DATE) = 1 then

Line 2325: IF NVL(p_record.SHIPMENT_PRIORITY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2321: (p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
2322: END IF;
2323:
2324: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_PRIORITIES_V') THEN
2325: IF NVL(p_record.SHIPMENT_PRIORITY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2326: RETURN NULL;
2327: END IF;
2328: IF ONT_SHIP_PR_Def_Util.Sync_SHIP_PR_Cache
2329: (p_SHIPMENT_PRIORITY_CODE => p_record.SHIPMENT_PRIORITY_CODE) = 1 then

Line 2335: IF NVL(p_record.SHIPPING_METHOD_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2331: (p_foreign_attr_code,ONT_SHIP_PR_Def_Util.g_cached_record);
2332: END IF;
2333:
2334: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIPPING_METHOD_V') THEN
2335: IF NVL(p_record.SHIPPING_METHOD_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2336: RETURN NULL;
2337: END IF;
2338: IF ONT_SHIP_METHOD_Def_Util.Sync_SHIP_METHOD_Cache
2339: (p_SHIPPING_METHOD_CODE => p_record.SHIPPING_METHOD_CODE) = 1 then

Line 2345: IF NVL(p_record.SHIP_FROM_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2341: (p_foreign_attr_code,ONT_SHIP_METHOD_Def_Util.g_cached_record);
2342: END IF;
2343:
2344: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_FROM_ORGS_V') THEN
2345: IF NVL(p_record.SHIP_FROM_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2346: RETURN NULL;
2347: END IF;
2348: IF ONT_SHIP_FROM_ORG_Def_Util.Sync_SHIP_FROM_ORG_Cache
2349: (p_ORGANIZATION_ID => p_record.SHIP_FROM_ORG_ID) = 1 then

Line 2355: IF NVL(p_record.PARTIAL_SHIPMENTS_ALLOWED,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2351: (p_foreign_attr_code,ONT_SHIP_FROM_ORG_Def_Util.g_cached_record);
2352: END IF;
2353:
2354: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_PARTIAL_V') THEN
2355: IF NVL(p_record.PARTIAL_SHIPMENTS_ALLOWED,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2356: RETURN NULL;
2357: END IF;
2358: IF ONT_SHIP_PARTIAL_Def_Util.Sync_SHIP_PARTIAL_Cache
2359: (p_SHIP_PARTIAL_ALLOWED => p_record.PARTIAL_SHIPMENTS_ALLOWED) = 1 then

Line 2365: IF NVL(p_record.SHIP_TOLERANCE_ABOVE,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2361: (p_foreign_attr_code,ONT_SHIP_PARTIAL_Def_Util.g_cached_record);
2362: END IF;
2363:
2364: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TOL_ABOVE_V') THEN
2365: IF NVL(p_record.SHIP_TOLERANCE_ABOVE,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2366: RETURN NULL;
2367: END IF;
2368: IF ONT_S_TOL_ABOVE_Def_Util.Sync_S_TOL_ABOVE_Cache
2369: (p_SHIP_TOLERANCE_ABOVE => p_record.SHIP_TOLERANCE_ABOVE) = 1 then

Line 2375: IF NVL(p_record.SHIP_TOLERANCE_BELOW,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2371: (p_foreign_attr_code,ONT_S_TOL_ABOVE_Def_Util.g_cached_record);
2372: END IF;
2373:
2374: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TOL_BELOW_V') THEN
2375: IF NVL(p_record.SHIP_TOLERANCE_BELOW,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2376: RETURN NULL;
2377: END IF;
2378: IF ONT_S_TOL_BELOW_Def_Util.Sync_S_TOL_BELOW_Cache
2379: (p_SHIP_TOLERANCE_BELOW => p_record.SHIP_TOLERANCE_BELOW) = 1 then

Line 2385: IF NVL(p_record.SHIP_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2381: (p_foreign_attr_code,ONT_S_TOL_BELOW_Def_Util.g_cached_record);
2382: END IF;
2383:
2384: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TO_CONTACT_V') THEN
2385: IF NVL(p_record.SHIP_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2386: RETURN NULL;
2387: END IF;
2388: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2389: (p_CONTACT_ID => p_record.SHIP_TO_CONTACT_ID) = 1 then

Line 2395: IF NVL(p_record.TAX_EXEMPT_REASON_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2391: (p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2392: END IF;
2393:
2394: ELSIF (p_foreign_database_object_name = 'OE_AK_T_EXEMPT_REASON_V') THEN
2395: IF NVL(p_record.TAX_EXEMPT_REASON_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2396: RETURN NULL;
2397: END IF;
2398: IF ONT_T_EXEMPT_REASON_Def_Util.Sync_T_EXEMPT_REASON_Cache
2399: (p_TAX_EXEMPT_REASON_CODE => p_record.TAX_EXEMPT_REASON_CODE) = 1 then

Line 2405: IF NVL(p_record.TAX_EXEMPT_FLAG,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2401: (p_foreign_attr_code,ONT_T_EXEMPT_REASON_Def_Util.g_cached_record);
2402: END IF;
2403:
2404: ELSIF (p_foreign_database_object_name = 'OE_AK_TAX_EXEMPT_V') THEN
2405: IF NVL(p_record.TAX_EXEMPT_FLAG,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2406: RETURN NULL;
2407: END IF;
2408: IF ONT_TAX_EXEMPT_Def_Util.Sync_TAX_EXEMPT_Cache
2409: (p_TAX_EXEMPT_FLAG => p_record.TAX_EXEMPT_FLAG) = 1 then

Line 2415: IF NVL(p_record.TAX_POINT_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2411: (p_foreign_attr_code,ONT_TAX_EXEMPT_Def_Util.g_cached_record);
2412: END IF;
2413:
2414: ELSIF (p_foreign_database_object_name = 'OE_AK_TAX_POINT_V') THEN
2415: IF NVL(p_record.TAX_POINT_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2416: RETURN NULL;
2417: END IF;
2418: IF ONT_TAX_POINT_Def_Util.Sync_TAX_POINT_Cache
2419: (p_TAX_POINT_CODE => p_record.TAX_POINT_CODE) = 1 then

Line 2425: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2421: (p_foreign_attr_code,ONT_TAX_POINT_Def_Util.g_cached_record);
2422: END IF;
2423:
2424: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
2425: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2426: RETURN NULL;
2427: END IF;
2428: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2429: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then

Line 2435: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2431: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2432: END IF;
2433:
2434: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
2435: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2436: RETURN NULL;
2437: END IF;
2438: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2439: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then

Line 2445: IF NVL(p_record.PACKING_INSTRUCTIONS,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2441: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2442: END IF;
2443:
2444: ELSIF (p_foreign_database_object_name = 'OE_AK_PACK_INST_V') THEN
2445: IF NVL(p_record.PACKING_INSTRUCTIONS,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2446: RETURN NULL;
2447: END IF;
2448: IF ONT_PACK_INST_Def_Util.Sync_PACK_INST_Cache
2449: (p_PACKING_INSTRUCTIONS => p_record.PACKING_INSTRUCTIONS) = 1 then

Line 2455: IF NVL(p_record.RETURN_REASON_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2451: (p_foreign_attr_code,ONT_PACK_INST_Def_Util.g_cached_record);
2452: END IF;
2453:
2454: ELSIF (p_foreign_database_object_name = 'OE_AK_RETURN_REASON_V') THEN
2455: IF NVL(p_record.RETURN_REASON_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2456: RETURN NULL;
2457: END IF;
2458: IF ONT_RET_REASON_Def_Util.Sync_RET_REASON_Cache
2459: (p_RETURN_REASON_CODE => p_record.RETURN_REASON_CODE) = 1 then

Line 2465: IF NVL(p_record.CUST_PO_NUMBER,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2461: (p_foreign_attr_code,ONT_RET_REASON_Def_Util.g_cached_record);
2462: END IF;
2463:
2464: ELSIF (p_foreign_database_object_name = 'OE_AK_CUST_PO_NUMBER_V') THEN
2465: IF NVL(p_record.CUST_PO_NUMBER,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2466: RETURN NULL;
2467: END IF;
2468: IF ONT_CUST_PO_Def_Util.Sync_CUST_PO_Cache
2469: (p_CUSTOMER_PO_NUMBER => p_record.CUST_PO_NUMBER) = 1 then

Line 2475: IF NVL(p_record.SHIPPING_INSTRUCTIONS,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2471: (p_foreign_attr_code,ONT_CUST_PO_Def_Util.g_cached_record);
2472: END IF;
2473:
2474: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_INST_V') THEN
2475: IF NVL(p_record.SHIPPING_INSTRUCTIONS,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2476: RETURN NULL;
2477: END IF;
2478: IF ONT_SHIP_INST_Def_Util.Sync_SHIP_INST_Cache
2479: (p_SHIPPING_INSTRUCTIONS => p_record.SHIPPING_INSTRUCTIONS) = 1 then

Line 2485: IF NVL(p_record.SALESREP_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2481: (p_foreign_attr_code,ONT_SHIP_INST_Def_Util.g_cached_record);
2482: END IF;
2483:
2484: ELSIF (p_foreign_database_object_name = 'OE_AK_SALESREPS_V') THEN
2485: IF NVL(p_record.SALESREP_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2486: RETURN NULL;
2487: END IF;
2488: IF ONT_SALESREP_Def_Util.Sync_SALESREP_Cache
2489: (p_SALESREP_ID => p_record.SALESREP_ID) = 1 then

Line 2495: IF NVL(p_record.DEFAULT_INBOUND_LINE_TYPE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2491: (p_foreign_attr_code,ONT_SALESREP_Def_Util.g_cached_record);
2492: END IF;
2493:
2494: ELSIF (p_foreign_database_object_name = 'OE_AK_LINE_TYPES_V') THEN
2495: IF NVL(p_record.DEFAULT_INBOUND_LINE_TYPE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2496: RETURN NULL;
2497: END IF;
2498: IF ONT_LINE_TYPE_Def_Util.Sync_LINE_TYPE_Cache
2499: (p_LINE_TYPE_ID => p_record.DEFAULT_INBOUND_LINE_TYPE_ID) = 1 then

Line 2505: IF NVL(p_record.DEFAULT_OUTBOUND_LINE_TYPE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2501: (p_foreign_attr_code,ONT_LINE_TYPE_Def_Util.g_cached_record);
2502: END IF;
2503:
2504: ELSIF (p_foreign_database_object_name = 'OE_AK_LINE_TYPES_V') THEN
2505: IF NVL(p_record.DEFAULT_OUTBOUND_LINE_TYPE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2506: RETURN NULL;
2507: END IF;
2508: IF ONT_LINE_TYPE_Def_Util.Sync_LINE_TYPE_Cache
2509: (p_LINE_TYPE_ID => p_record.DEFAULT_OUTBOUND_LINE_TYPE_ID) = 1 then

Line 2515: IF NVL(p_record.TRANSACTIONAL_CURR_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2511: (p_foreign_attr_code,ONT_LINE_TYPE_Def_Util.g_cached_record);
2512: END IF;
2513:
2514: ELSIF (p_foreign_database_object_name = 'OE_FND_CURRENCIES_V') THEN
2515: IF NVL(p_record.TRANSACTIONAL_CURR_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2516: RETURN NULL;
2517: END IF;
2518: IF ONT_CURR_CODE_Def_Util.Sync_CURR_CODE_Cache
2519: (p_CURRENCY_CODE => p_record.TRANSACTIONAL_CURR_CODE) = 1 then

Line 2525: IF NVL(p_record.SOLD_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2521: (p_foreign_attr_code,ONT_CURR_CODE_Def_Util.g_cached_record);
2522: END IF;
2523:
2524: ELSIF (p_foreign_database_object_name = 'OE_AK_INV_TO_CONTACT_V') THEN
2525: IF NVL(p_record.SOLD_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2526: RETURN NULL;
2527: END IF;
2528: IF ONT_INV_TO_CON_Def_Util.Sync_INV_TO_CON_Cache
2529: (p_CONTACT_ID => p_record.SOLD_TO_CONTACT_ID) = 1 then

Line 2535: IF NVL(p_record.SOLD_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2531: (p_foreign_attr_code,ONT_INV_TO_CON_Def_Util.g_cached_record);
2532: END IF;
2533:
2534: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TO_CONTACT_V') THEN
2535: IF NVL(p_record.SOLD_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2536: RETURN NULL;
2537: END IF;
2538: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2539: (p_CONTACT_ID => p_record.SOLD_TO_CONTACT_ID) = 1 then

Line 2545: IF NVL(p_record.ORDERED_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN

2541: (p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2542: END IF;
2543:
2544: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
2545: IF NVL(p_record.ORDERED_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
2546: RETURN NULL;
2547: END IF;
2548: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
2549: (p_REQUEST_DATE => p_record.ORDERED_DATE) = 1 then

Line 2568: IF NVL(p_record.BLANKET_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2564: IS
2565: BEGIN
2566:
2567: IF (p_foreign_database_object_name = 'OE_AK_BLANKET_HEADERS_V') THEN
2568: IF NVL(p_record.BLANKET_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2569: RETURN NULL;
2570: END IF;
2571: IF ONT_BLANKET_HEADER_Def_Util.Sync_BLANKET_HEADER_Cache
2572: (p_ORDER_NUMBER => p_record.BLANKET_NUMBER) = 1 then

Line 2577: IF NVL(p_record.LATEST_SCHEDULE_LIMIT,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2573: RETURN ONT_BLANKET_HEADER_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_BLANKET_HEADER_Def_Util.g_cached_record);
2574: END IF;
2575:
2576: ELSIF (p_foreign_database_object_name = 'OE_AK_LAT_SCH_LIMIT_V') THEN
2577: IF NVL(p_record.LATEST_SCHEDULE_LIMIT,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2578: RETURN NULL;
2579: END IF;
2580: IF ONT_LAT_SCH_LIMIT_Def_Util.Sync_LAT_SCH_LIMIT_Cache
2581: (p_LATEST_SCHEDULE_LIMIT => p_record.LATEST_SCHEDULE_LIMIT) = 1 then

Line 2586: IF NVL(p_record.EARLIEST_SCHEDULE_LIMIT,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2582: RETURN ONT_LAT_SCH_LIMIT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_LAT_SCH_LIMIT_Def_Util.g_cached_record);
2583: END IF;
2584:
2585: ELSIF (p_foreign_database_object_name = 'OE_AK_EAR_SCH_LIMIT_V') THEN
2586: IF NVL(p_record.EARLIEST_SCHEDULE_LIMIT,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2587: RETURN NULL;
2588: END IF;
2589: IF ONT_EAR_SCH_LIMIT_Def_Util.Sync_EAR_SCH_LIMIT_Cache
2590: (p_EARLIEST_SCHEDULE_LIMIT => p_record.EARLIEST_SCHEDULE_LIMIT) = 1 then

Line 2595: IF NVL(p_record.SALES_CHANNEL_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2591: RETURN ONT_EAR_SCH_LIMIT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_EAR_SCH_LIMIT_Def_Util.g_cached_record);
2592: END IF;
2593:
2594: ELSIF (p_foreign_database_object_name = 'OE_AK_SALES_CHANNEL_V') THEN
2595: IF NVL(p_record.SALES_CHANNEL_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2596: RETURN NULL;
2597: END IF;
2598: IF ONT_SALES_CHANNEL_Def_Util.Sync_SALES_CHANNEL_Cache
2599: (p_SALES_CHANNEL_CODE => p_record.SALES_CHANNEL_CODE) = 1 then

Line 2604: IF NVL(p_record.ORDER_DATE_TYPE_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2600: RETURN ONT_SALES_CHANNEL_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SALES_CHANNEL_Def_Util.g_cached_record);
2601: END IF;
2602:
2603: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_DATE_TYPE_V') THEN
2604: IF NVL(p_record.ORDER_DATE_TYPE_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2605: RETURN NULL;
2606: END IF;
2607: IF ONT_ORD_DATE_TYPE_Def_Util.Sync_ORD_DATE_TYPE_Cache
2608: (p_ORDER_DATE_TYPE_CODE => p_record.ORDER_DATE_TYPE_CODE) = 1 then

Line 2613: IF NVL(p_record.DEFAULT_FULFILLMENT_SET,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2609: RETURN ONT_ORD_DATE_TYPE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORD_DATE_TYPE_Def_Util.g_cached_record);
2610: END IF;
2611:
2612: ELSIF (p_foreign_database_object_name = 'OE_AK_DEFAULT_FULFILMENT_SET_V') THEN
2613: IF NVL(p_record.DEFAULT_FULFILLMENT_SET,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2614: RETURN NULL;
2615: END IF;
2616: IF ONT_DEF_FULFILL_Def_Util.Sync_DEF_FULFILL_Cache
2617: (p_DEFAULT_FULFILLMENT_SET => p_record.DEFAULT_FULFILLMENT_SET) = 1 then

Line 2622: IF NVL(p_record.CUSTOMER_PREFERENCE_SET_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2618: RETURN ONT_DEF_FULFILL_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_DEF_FULFILL_Def_Util.g_cached_record);
2619: END IF;
2620:
2621: ELSIF (p_foreign_database_object_name = 'OE_AK_DEFAULT_LINE_SET_V') THEN
2622: IF NVL(p_record.CUSTOMER_PREFERENCE_SET_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2623: RETURN NULL;
2624: END IF;
2625: IF ONT_DEF_LINESET_Def_Util.Sync_DEF_LINESET_Cache
2626: (p_DEFAULT_LINE_SET => p_record.CUSTOMER_PREFERENCE_SET_CODE) = 1 then

Line 2631: IF NVL(p_record.SOLD_TO_SITE_USE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2627: RETURN ONT_DEF_LINESET_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_DEF_LINESET_Def_Util.g_cached_record);
2628: END IF;
2629:
2630: ELSIF (p_foreign_database_object_name = 'OE_AK_SOLD_TO_SITE_USES_V') THEN
2631: IF NVL(p_record.SOLD_TO_SITE_USE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2632: RETURN NULL;
2633: END IF;
2634: IF ONT_SOLD_TO_SU_Def_Util.Sync_SOLD_TO_SU_Cache
2635: (p_SOLD_TO_SITE_USE_ID => p_record.SOLD_TO_SITE_USE_ID) = 1 then

Line 2640: IF NVL(p_record.TRANSACTION_PHASE_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2636: RETURN ONT_SOLD_TO_SU_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SOLD_TO_SU_Def_Util.g_cached_record);
2637: END IF;
2638:
2639: ELSIF (p_foreign_database_object_name = 'OE_AK_TRXN_PHASE_V') THEN
2640: IF NVL(p_record.TRANSACTION_PHASE_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2641: RETURN NULL;
2642: END IF;
2643: IF ONT_TRXN_PHASE_Def_Util.Sync_TRXN_PHASE_Cache
2644: (p_TRANSACTION_PHASE_CODE => p_record.TRANSACTION_PHASE_CODE) = 1 then

Line 2649: IF NVL(p_record.END_CUSTOMER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2645: RETURN ONT_TRXN_PHASE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_TRXN_PHASE_Def_Util.g_cached_record);
2646: END IF;
2647:
2648: ELSIF (p_foreign_database_object_name = 'OE_AK_END_CUS_V') THEN
2649: IF NVL(p_record.END_CUSTOMER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2650: RETURN NULL;
2651: END IF;
2652: IF ONT_END_CUSTOMER_Def_Util.Sync_END_CUSTOMER_Cache
2653: (p_END_CUSTOMER_ID => p_record.END_CUSTOMER_ID) = 1 then

Line 2658: IF NVL(p_record.END_CUSTOMER_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2654: RETURN ONT_END_CUSTOMER_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_END_CUSTOMER_Def_Util.g_cached_record);
2655: END IF;
2656:
2657: ELSIF (p_foreign_database_object_name = 'OE_AK_END_CUS_CONT_V') THEN
2658: IF NVL(p_record.END_CUSTOMER_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2659: RETURN NULL;
2660: END IF;
2661: IF ONT_EC_CONTACT_Def_Util.Sync_EC_CONTACT_Cache
2662: (p_END_CUSTOMER_CONTACT_ID => p_record.END_CUSTOMER_CONTACT_ID) = 1 then

Line 2667: IF NVL(p_record.END_CUSTOMER_SITE_USE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2663: RETURN ONT_EC_CONTACT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_EC_CONTACT_Def_Util.g_cached_record);
2664: END IF;
2665:
2666: ELSIF (p_foreign_database_object_name = 'OE_AK_END_CUS_SITEUSE_V') THEN
2667: IF NVL(p_record.END_CUSTOMER_SITE_USE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2668: RETURN NULL;
2669: END IF;
2670: IF ONT_EC_LOCATION_Def_Util.Sync_EC_LOCATION_Cache
2671: (p_END_CUSTOMER_SITE_USE_ID => p_record.END_CUSTOMER_SITE_USE_ID) = 1 then

Line 2676: IF NVL(p_record.IB_OWNER,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2672: RETURN ONT_EC_LOCATION_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_EC_LOCATION_Def_Util.g_cached_record);
2673: END IF;
2674:
2675: ELSIF (p_foreign_database_object_name = 'OE_AK_IB_OWNER_V') THEN
2676: IF NVL(p_record.IB_OWNER,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2677: RETURN NULL;
2678: END IF;
2679: IF ONT_IB_OWNER_Def_Util.Sync_IB_OWNER_Cache
2680: (p_IB_OWNER => p_record.IB_OWNER) = 1 then

Line 2685: IF NVL(p_record.IB_INSTALLED_AT_LOCATION,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2681: RETURN ONT_IB_OWNER_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_IB_OWNER_Def_Util.g_cached_record);
2682: END IF;
2683:
2684: ELSIF (p_foreign_database_object_name = 'OE_AK_IB_INSTALL_LOC_V') THEN
2685: IF NVL(p_record.IB_INSTALLED_AT_LOCATION,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2686: RETURN NULL;
2687: END IF;
2688: IF ONT_IB_INSTALL_LOC_Def_Util.Sync_IB_INSTALL_LOC_Cache
2689: (p_IB_INSTALLED_AT_LOCATION => p_record.IB_INSTALLED_AT_LOCATION) = 1 then

Line 2694: IF NVL(p_record.IB_CURRENT_LOCATION,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2690: RETURN ONT_IB_INSTALL_LOC_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_IB_INSTALL_LOC_Def_Util.g_cached_record);
2691: END IF;
2692:
2693: ELSIF (p_foreign_database_object_name = 'OE_AK_IB_CURR_LOC_V') THEN
2694: IF NVL(p_record.IB_CURRENT_LOCATION,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2695: RETURN NULL;
2696: END IF;
2697: IF ONT_IB_CURR_LOC_Def_Util.Sync_IB_CURR_LOC_Cache
2698: (p_IB_CURRENT_LOCATION => p_record.IB_CURRENT_LOCATION) = 1 then

Line 2703: IF NVL(p_record.ORDER_FIRMED_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN

2699: RETURN ONT_IB_CURR_LOC_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_IB_CURR_LOC_Def_Util.g_cached_record);
2700: END IF;
2701:
2702: ELSIF (p_foreign_database_object_name = 'OE_AK_ORD_FIRMED_DATE_V') THEN
2703: IF NVL(p_record.ORDER_FIRMED_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
2704: RETURN NULL;
2705: END IF;
2706: IF ONT_ORD_FIRMED_DATE_Def_Util.Sync_ORD_FIRMED_DATE_Cache
2707: (p_ORDER_FIRMED_DATE => p_record.ORDER_FIRMED_DATE) = 1 then

Line 2712: IF NVL(p_record.CONVERSION_TYPE_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2708: RETURN ONT_ORD_FIRMED_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORD_FIRMED_DATE_Def_Util.g_cached_record);
2709: END IF;
2710:
2711: ELSIF (p_foreign_database_object_name = 'OE_AK_CONVERSION_TYPES_V') THEN
2712: IF NVL(p_record.CONVERSION_TYPE_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2713: RETURN NULL;
2714: END IF;
2715: IF ONT_CONV_TYPE_Def_Util.Sync_CONV_TYPE_Cache
2716: (p_CONVERSION_TYPE_CODE => p_record.CONVERSION_TYPE_CODE) = 1 then

Line 2721: IF NVL(p_record.AGREEMENT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2717: RETURN ONT_CONV_TYPE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_CONV_TYPE_Def_Util.g_cached_record);
2718: END IF;
2719:
2720: ELSIF (p_foreign_database_object_name = 'OE_AGREEMENTS_V') THEN
2721: IF NVL(p_record.AGREEMENT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2722: RETURN NULL;
2723: END IF;
2724: IF ONT_AGREEMENT_Def_Util.Sync_AGREEMENT_Cache
2725: (p_AGREEMENT_ID => p_record.AGREEMENT_ID) = 1 then

Line 2730: IF NVL(p_record.DELIVER_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2726: RETURN ONT_AGREEMENT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_AGREEMENT_Def_Util.g_cached_record);
2727: END IF;
2728:
2729: ELSIF (p_foreign_database_object_name = 'OE_AK_DEL_TO_CONTACT_V') THEN
2730: IF NVL(p_record.DELIVER_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2731: RETURN NULL;
2732: END IF;
2733: IF ONT_DEL_TO_CON_Def_Util.Sync_DEL_TO_CON_Cache
2734: (p_CONTACT_ID => p_record.DELIVER_TO_CONTACT_ID) = 1 then

Line 2739: IF NVL(p_record.DEMAND_CLASS_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2735: RETURN ONT_DEL_TO_CON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_DEL_TO_CON_Def_Util.g_cached_record);
2736: END IF;
2737:
2738: ELSIF (p_foreign_database_object_name = 'OE_AK_DEMAND_CLASS_V') THEN
2739: IF NVL(p_record.DEMAND_CLASS_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2740: RETURN NULL;
2741: END IF;
2742: IF ONT_DEM_CLASS_Def_Util.Sync_DEM_CLASS_Cache
2743: (p_DEMAND_CLASS_CODE => p_record.DEMAND_CLASS_CODE) = 1 then

Line 2748: IF NVL(p_record.FOB_POINT_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2744: RETURN ONT_DEM_CLASS_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_DEM_CLASS_Def_Util.g_cached_record);
2745: END IF;
2746:
2747: ELSIF (p_foreign_database_object_name = 'OE_AK_FOB_POINT_V') THEN
2748: IF NVL(p_record.FOB_POINT_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2749: RETURN NULL;
2750: END IF;
2751: IF ONT_FOB_Def_Util.Sync_FOB_Cache
2752: (p_FOB_POINT_CODE => p_record.FOB_POINT_CODE) = 1 then

Line 2757: IF NVL(p_record.FREIGHT_TERMS_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2753: RETURN ONT_FOB_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_FOB_Def_Util.g_cached_record);
2754: END IF;
2755:
2756: ELSIF (p_foreign_database_object_name = 'OE_AK_FREIGHT_TERMS_V') THEN
2757: IF NVL(p_record.FREIGHT_TERMS_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2758: RETURN NULL;
2759: END IF;
2760: IF ONT_FR_TERM_Def_Util.Sync_FR_TERM_Cache
2761: (p_FREIGHT_TERMS_CODE => p_record.FREIGHT_TERMS_CODE) = 1 then

Line 2766: IF NVL(p_record.INVOICE_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2762: RETURN ONT_FR_TERM_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_FR_TERM_Def_Util.g_cached_record);
2763: END IF;
2764:
2765: ELSIF (p_foreign_database_object_name = 'OE_AK_INV_TO_CONTACT_V') THEN
2766: IF NVL(p_record.INVOICE_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2767: RETURN NULL;
2768: END IF;
2769: IF ONT_INV_TO_CON_Def_Util.Sync_INV_TO_CON_Cache
2770: (p_CONTACT_ID => p_record.INVOICE_TO_CONTACT_ID) = 1 then

Line 2775: IF NVL(p_record.ACCOUNTING_RULE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2771: RETURN ONT_INV_TO_CON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_INV_TO_CON_Def_Util.g_cached_record);
2772: END IF;
2773:
2774: ELSIF (p_foreign_database_object_name = 'OE_AK_ACC_RULES_V') THEN
2775: IF NVL(p_record.ACCOUNTING_RULE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2776: RETURN NULL;
2777: END IF;
2778: IF ONT_ACC_RULE_Def_Util.Sync_ACC_RULE_Cache
2779: (p_ACCOUNTING_RULE_ID => p_record.ACCOUNTING_RULE_ID) = 1 then

Line 2784: IF NVL(p_record.DELIVER_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2780: RETURN ONT_ACC_RULE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ACC_RULE_Def_Util.g_cached_record);
2781: END IF;
2782:
2783: ELSIF (p_foreign_database_object_name = 'OE_AK_DELIVER_TO_ORGS_V') THEN
2784: IF NVL(p_record.DELIVER_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2785: RETURN NULL;
2786: END IF;
2787: IF ONT_DEL_TO_ORG_Def_Util.Sync_DEL_TO_ORG_Cache
2788: (p_ORGANIZATION_ID => p_record.DELIVER_TO_ORG_ID) = 1 then

Line 2793: IF NVL(p_record.INVOICE_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2789: RETURN ONT_DEL_TO_ORG_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_DEL_TO_ORG_Def_Util.g_cached_record);
2790: END IF;
2791:
2792: ELSIF (p_foreign_database_object_name = 'OE_AK_INVOICE_TO_ORGS_V') THEN
2793: IF NVL(p_record.INVOICE_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2794: RETURN NULL;
2795: END IF;
2796: IF ONT_INV_ORG_Def_Util.Sync_INV_ORG_Cache
2797: (p_ORGANIZATION_ID => p_record.INVOICE_TO_ORG_ID) = 1 then

Line 2802: IF NVL(p_record.INVOICING_RULE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2798: RETURN ONT_INV_ORG_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_INV_ORG_Def_Util.g_cached_record);
2799: END IF;
2800:
2801: ELSIF (p_foreign_database_object_name = 'OE_AK_INV_RULES_V') THEN
2802: IF NVL(p_record.INVOICING_RULE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2803: RETURN NULL;
2804: END IF;
2805: IF ONT_INV_RULE_Def_Util.Sync_INV_RULE_Cache
2806: (p_INVOICING_RULE_ID => p_record.INVOICING_RULE_ID) = 1 then

Line 2811: IF NVL(p_record.SHIP_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2807: RETURN ONT_INV_RULE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_INV_RULE_Def_Util.g_cached_record);
2808: END IF;
2809:
2810: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TO_ORGS_V') THEN
2811: IF NVL(p_record.SHIP_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2812: RETURN NULL;
2813: END IF;
2814: IF ONT_SHIP_TO_ORG_Def_Util.Sync_SHIP_TO_ORG_Cache
2815: (p_ORGANIZATION_ID => p_record.SHIP_TO_ORG_ID) = 1 then

Line 2820: IF ( NVL(p_record.SOLD_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )

2816: RETURN ONT_SHIP_TO_ORG_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_TO_ORG_Def_Util.g_cached_record);
2817: END IF;
2818:
2819: ELSIF (p_foreign_database_object_name = 'OE_AK_SOLD_TO_ORGS_V') THEN
2820: IF ( NVL(p_record.SOLD_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )
2821: OR ( NVL(p_record.ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )
2822: THEN
2823: RETURN NULL;
2824: END IF;

Line 2821: OR ( NVL(p_record.ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )

2817: END IF;
2818:
2819: ELSIF (p_foreign_database_object_name = 'OE_AK_SOLD_TO_ORGS_V') THEN
2820: IF ( NVL(p_record.SOLD_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )
2821: OR ( NVL(p_record.ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )
2822: THEN
2823: RETURN NULL;
2824: END IF;
2825: IF ONT_SOLD_TO_ORG_Def_Util.Sync_SOLD_TO_ORG_Cache(p_ORGANIZATION_ID => p_record.SOLD_TO_ORG_ID,

Line 2831: IF NVL(p_record.ORDER_TYPE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2827: RETURN ONT_SOLD_TO_ORG_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SOLD_TO_ORG_Def_Util.g_cached_record);
2828: END IF;
2829:
2830: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_TYPES_V') THEN
2831: IF NVL(p_record.ORDER_TYPE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2832: RETURN NULL;
2833: END IF;
2834: IF ONT_ORDER_TYPE_Def_Util.Sync_ORDER_TYPE_Cache
2835: (p_ORDER_TYPE_ID => p_record.ORDER_TYPE_ID) = 1 then

Line 2840: IF NVL(p_record.PAYMENT_TERM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2836: RETURN ONT_ORDER_TYPE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_TYPE_Def_Util.g_cached_record);
2837: END IF;
2838:
2839: ELSIF (p_foreign_database_object_name = 'OE_AK_PAYMENT_TERM_V') THEN
2840: IF NVL(p_record.PAYMENT_TERM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2841: RETURN NULL;
2842: END IF;
2843: IF ONT_PAY_TERM_Def_Util.Sync_PAY_TERM_Cache
2844: (p_PAYMENT_TERM_ID => p_record.PAYMENT_TERM_ID) = 1 then

Line 2849: IF NVL(p_record.PRICE_LIST_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2845: RETURN ONT_PAY_TERM_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_PAY_TERM_Def_Util.g_cached_record);
2846: END IF;
2847:
2848: ELSIF (p_foreign_database_object_name = 'OE_PRICE_LISTS_V') THEN
2849: IF NVL(p_record.PRICE_LIST_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2850: RETURN NULL;
2851: END IF;
2852: IF ONT_PRICE_LIST_Def_Util.Sync_PRICE_LIST_Cache
2853: (p_PRICE_LIST_ID => p_record.PRICE_LIST_ID) = 1 then

Line 2858: IF NVL(p_record.REQUEST_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN

2854: RETURN ONT_PRICE_LIST_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_PRICE_LIST_Def_Util.g_cached_record);
2855: END IF;
2856:
2857: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
2858: IF NVL(p_record.REQUEST_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
2859: RETURN NULL;
2860: END IF;
2861: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
2862: (p_REQUEST_DATE => p_record.REQUEST_DATE) = 1 then

Line 2867: IF NVL(p_record.SHIPMENT_PRIORITY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2863: RETURN ONT_REQ_DATE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_REQ_DATE_Def_Util.g_cached_record);
2864: END IF;
2865:
2866: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_PRIORITIES_V') THEN
2867: IF NVL(p_record.SHIPMENT_PRIORITY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2868: RETURN NULL;
2869: END IF;
2870: IF ONT_SHIP_PR_Def_Util.Sync_SHIP_PR_Cache
2871: (p_SHIPMENT_PRIORITY_CODE => p_record.SHIPMENT_PRIORITY_CODE) = 1 then

Line 2876: IF NVL(p_record.SHIPPING_METHOD_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2872: RETURN ONT_SHIP_PR_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_PR_Def_Util.g_cached_record);
2873: END IF;
2874:
2875: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIPPING_METHOD_V') THEN
2876: IF NVL(p_record.SHIPPING_METHOD_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2877: RETURN NULL;
2878: END IF;
2879: IF ONT_SHIP_METHOD_Def_Util.Sync_SHIP_METHOD_Cache
2880: (p_SHIPPING_METHOD_CODE => p_record.SHIPPING_METHOD_CODE) = 1 then

Line 2885: IF NVL(p_record.SHIP_FROM_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2881: RETURN ONT_SHIP_METHOD_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_METHOD_Def_Util.g_cached_record);
2882: END IF;
2883:
2884: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_FROM_ORGS_V') THEN
2885: IF NVL(p_record.SHIP_FROM_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2886: RETURN NULL;
2887: END IF;
2888: IF ONT_SHIP_FROM_ORG_Def_Util.Sync_SHIP_FROM_ORG_Cache
2889: (p_ORGANIZATION_ID => p_record.SHIP_FROM_ORG_ID) = 1 then

Line 2894: IF NVL(p_record.PARTIAL_SHIPMENTS_ALLOWED,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2890: RETURN ONT_SHIP_FROM_ORG_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_FROM_ORG_Def_Util.g_cached_record);
2891: END IF;
2892:
2893: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_PARTIAL_V') THEN
2894: IF NVL(p_record.PARTIAL_SHIPMENTS_ALLOWED,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2895: RETURN NULL;
2896: END IF;
2897: IF ONT_SHIP_PARTIAL_Def_Util.Sync_SHIP_PARTIAL_Cache
2898: (p_SHIP_PARTIAL_ALLOWED => p_record.PARTIAL_SHIPMENTS_ALLOWED) = 1 then

Line 2903: IF NVL(p_record.SHIP_TOLERANCE_ABOVE,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2899: RETURN ONT_SHIP_PARTIAL_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_PARTIAL_Def_Util.g_cached_record);
2900: END IF;
2901:
2902: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TOL_ABOVE_V') THEN
2903: IF NVL(p_record.SHIP_TOLERANCE_ABOVE,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2904: RETURN NULL;
2905: END IF;
2906: IF ONT_S_TOL_ABOVE_Def_Util.Sync_S_TOL_ABOVE_Cache
2907: (p_SHIP_TOLERANCE_ABOVE => p_record.SHIP_TOLERANCE_ABOVE) = 1 then

Line 2912: IF NVL(p_record.SHIP_TOLERANCE_BELOW,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2908: RETURN ONT_S_TOL_ABOVE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_S_TOL_ABOVE_Def_Util.g_cached_record);
2909: END IF;
2910:
2911: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TOL_BELOW_V') THEN
2912: IF NVL(p_record.SHIP_TOLERANCE_BELOW,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2913: RETURN NULL;
2914: END IF;
2915: IF ONT_S_TOL_BELOW_Def_Util.Sync_S_TOL_BELOW_Cache
2916: (p_SHIP_TOLERANCE_BELOW => p_record.SHIP_TOLERANCE_BELOW) = 1 then

Line 2921: IF NVL(p_record.SHIP_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

2917: RETURN ONT_S_TOL_BELOW_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_S_TOL_BELOW_Def_Util.g_cached_record);
2918: END IF;
2919:
2920: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TO_CONTACT_V') THEN
2921: IF NVL(p_record.SHIP_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2922: RETURN NULL;
2923: END IF;
2924: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
2925: (p_CONTACT_ID => p_record.SHIP_TO_CONTACT_ID) = 1 then

Line 2930: IF NVL(p_record.TAX_EXEMPT_REASON_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2926: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
2927: END IF;
2928:
2929: ELSIF (p_foreign_database_object_name = 'OE_AK_T_EXEMPT_REASON_V') THEN
2930: IF NVL(p_record.TAX_EXEMPT_REASON_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2931: RETURN NULL;
2932: END IF;
2933: IF ONT_T_EXEMPT_REASON_Def_Util.Sync_T_EXEMPT_REASON_Cache
2934: (p_TAX_EXEMPT_REASON_CODE => p_record.TAX_EXEMPT_REASON_CODE) = 1 then

Line 2939: IF NVL(p_record.TAX_EXEMPT_FLAG,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2935: RETURN ONT_T_EXEMPT_REASON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_T_EXEMPT_REASON_Def_Util.g_cached_record);
2936: END IF;
2937:
2938: ELSIF (p_foreign_database_object_name = 'OE_AK_TAX_EXEMPT_V') THEN
2939: IF NVL(p_record.TAX_EXEMPT_FLAG,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2940: RETURN NULL;
2941: END IF;
2942: IF ONT_TAX_EXEMPT_Def_Util.Sync_TAX_EXEMPT_Cache
2943: (p_TAX_EXEMPT_FLAG => p_record.TAX_EXEMPT_FLAG) = 1 then

Line 2948: IF NVL(p_record.TAX_POINT_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2944: RETURN ONT_TAX_EXEMPT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_TAX_EXEMPT_Def_Util.g_cached_record);
2945: END IF;
2946:
2947: ELSIF (p_foreign_database_object_name = 'OE_AK_TAX_POINT_V') THEN
2948: IF NVL(p_record.TAX_POINT_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2949: RETURN NULL;
2950: END IF;
2951: IF ONT_TAX_POINT_Def_Util.Sync_TAX_POINT_Cache
2952: (p_TAX_POINT_CODE => p_record.TAX_POINT_CODE) = 1 then

Line 2957: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2953: RETURN ONT_TAX_POINT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_TAX_POINT_Def_Util.g_cached_record);
2954: END IF;
2955:
2956: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
2957: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2958: RETURN NULL;
2959: END IF;
2960: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2961: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then

Line 2966: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2962: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2963: END IF;
2964:
2965: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
2966: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2967: RETURN NULL;
2968: END IF;
2969: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2970: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then

Line 2975: IF NVL(p_record.PACKING_INSTRUCTIONS,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2971: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2972: END IF;
2973:
2974: ELSIF (p_foreign_database_object_name = 'OE_AK_PACK_INST_V') THEN
2975: IF NVL(p_record.PACKING_INSTRUCTIONS,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2976: RETURN NULL;
2977: END IF;
2978: IF ONT_PACK_INST_Def_Util.Sync_PACK_INST_Cache
2979: (p_PACKING_INSTRUCTIONS => p_record.PACKING_INSTRUCTIONS) = 1 then

Line 2984: IF NVL(p_record.RETURN_REASON_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2980: RETURN ONT_PACK_INST_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_PACK_INST_Def_Util.g_cached_record);
2981: END IF;
2982:
2983: ELSIF (p_foreign_database_object_name = 'OE_AK_RETURN_REASON_V') THEN
2984: IF NVL(p_record.RETURN_REASON_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2985: RETURN NULL;
2986: END IF;
2987: IF ONT_RET_REASON_Def_Util.Sync_RET_REASON_Cache
2988: (p_RETURN_REASON_CODE => p_record.RETURN_REASON_CODE) = 1 then

Line 2993: IF NVL(p_record.CUST_PO_NUMBER,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2989: RETURN ONT_RET_REASON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_RET_REASON_Def_Util.g_cached_record);
2990: END IF;
2991:
2992: ELSIF (p_foreign_database_object_name = 'OE_AK_CUST_PO_NUMBER_V') THEN
2993: IF NVL(p_record.CUST_PO_NUMBER,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2994: RETURN NULL;
2995: END IF;
2996: IF ONT_CUST_PO_Def_Util.Sync_CUST_PO_Cache
2997: (p_CUSTOMER_PO_NUMBER => p_record.CUST_PO_NUMBER) = 1 then

Line 3002: IF NVL(p_record.SHIPPING_INSTRUCTIONS,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2998: RETURN ONT_CUST_PO_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_CUST_PO_Def_Util.g_cached_record);
2999: END IF;
3000:
3001: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_INST_V') THEN
3002: IF NVL(p_record.SHIPPING_INSTRUCTIONS,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
3003: RETURN NULL;
3004: END IF;
3005: IF ONT_SHIP_INST_Def_Util.Sync_SHIP_INST_Cache
3006: (p_SHIPPING_INSTRUCTIONS => p_record.SHIPPING_INSTRUCTIONS) = 1 then

Line 3011: IF NVL(p_record.SALESREP_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

3007: RETURN ONT_SHIP_INST_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_INST_Def_Util.g_cached_record);
3008: END IF;
3009:
3010: ELSIF (p_foreign_database_object_name = 'OE_AK_SALESREPS_V') THEN
3011: IF NVL(p_record.SALESREP_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
3012: RETURN NULL;
3013: END IF;
3014: IF ONT_SALESREP_Def_Util.Sync_SALESREP_Cache
3015: (p_SALESREP_ID => p_record.SALESREP_ID) = 1 then

Line 3020: IF NVL(p_record.DEFAULT_INBOUND_LINE_TYPE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

3016: RETURN ONT_SALESREP_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SALESREP_Def_Util.g_cached_record);
3017: END IF;
3018:
3019: ELSIF (p_foreign_database_object_name = 'OE_AK_LINE_TYPES_V') THEN
3020: IF NVL(p_record.DEFAULT_INBOUND_LINE_TYPE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
3021: RETURN NULL;
3022: END IF;
3023: IF ONT_LINE_TYPE_Def_Util.Sync_LINE_TYPE_Cache
3024: (p_LINE_TYPE_ID => p_record.DEFAULT_INBOUND_LINE_TYPE_ID) = 1 then

Line 3029: IF NVL(p_record.DEFAULT_OUTBOUND_LINE_TYPE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

3025: RETURN ONT_LINE_TYPE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_LINE_TYPE_Def_Util.g_cached_record);
3026: END IF;
3027:
3028: ELSIF (p_foreign_database_object_name = 'OE_AK_LINE_TYPES_V') THEN
3029: IF NVL(p_record.DEFAULT_OUTBOUND_LINE_TYPE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
3030: RETURN NULL;
3031: END IF;
3032: IF ONT_LINE_TYPE_Def_Util.Sync_LINE_TYPE_Cache
3033: (p_LINE_TYPE_ID => p_record.DEFAULT_OUTBOUND_LINE_TYPE_ID) = 1 then

Line 3038: IF NVL(p_record.TRANSACTIONAL_CURR_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

3034: RETURN ONT_LINE_TYPE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_LINE_TYPE_Def_Util.g_cached_record);
3035: END IF;
3036:
3037: ELSIF (p_foreign_database_object_name = 'OE_FND_CURRENCIES_V') THEN
3038: IF NVL(p_record.TRANSACTIONAL_CURR_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
3039: RETURN NULL;
3040: END IF;
3041: IF ONT_CURR_CODE_Def_Util.Sync_CURR_CODE_Cache
3042: (p_CURRENCY_CODE => p_record.TRANSACTIONAL_CURR_CODE) = 1 then

Line 3047: IF NVL(p_record.SOLD_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

3043: RETURN ONT_CURR_CODE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_CURR_CODE_Def_Util.g_cached_record);
3044: END IF;
3045:
3046: ELSIF (p_foreign_database_object_name = 'OE_AK_INV_TO_CONTACT_V') THEN
3047: IF NVL(p_record.SOLD_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
3048: RETURN NULL;
3049: END IF;
3050: IF ONT_INV_TO_CON_Def_Util.Sync_INV_TO_CON_Cache
3051: (p_CONTACT_ID => p_record.SOLD_TO_CONTACT_ID) = 1 then

Line 3056: IF NVL(p_record.SOLD_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

3052: RETURN ONT_INV_TO_CON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_INV_TO_CON_Def_Util.g_cached_record);
3053: END IF;
3054:
3055: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TO_CONTACT_V') THEN
3056: IF NVL(p_record.SOLD_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
3057: RETURN NULL;
3058: END IF;
3059: IF ONT_SHIP_TO_CON_Def_Util.Sync_SHIP_TO_CON_Cache
3060: (p_CONTACT_ID => p_record.SOLD_TO_CONTACT_ID) = 1 then

Line 3065: IF NVL(p_record.ORDERED_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN

3061: RETURN ONT_SHIP_TO_CON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_TO_CON_Def_Util.g_cached_record);
3062: END IF;
3063:
3064: ELSIF (p_foreign_database_object_name = 'OE_AK_REQUEST_DATE_V') THEN
3065: IF NVL(p_record.ORDERED_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
3066: RETURN NULL;
3067: END IF;
3068: IF ONT_REQ_DATE_Def_Util.Sync_REQ_DATE_Cache
3069: (p_REQUEST_DATE => p_record.ORDERED_DATE) = 1 then

Line 3233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3229: ( G_PKG_NAME ,
3230: 'Update_Attr_Rules_Cache: '||l_attribute_code
3231: );
3232: END IF;
3233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3234: END Update_Attr_Rules_Cache;
3235:
3236:
3237: PROCEDURE Get_Valid_Defaulting_Rules

Line 3333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3329: ( G_PKG_NAME ,
3330: 'Get_Valid_Defaulting_Rules :'||p_attr_code
3331: );
3332: END IF;
3333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3334: END Get_Valid_Defaulting_Rules;
3335:
3336:
3337: END ONT_HEADER_Def_Util;