APPS.ONT_BLANKET_HEADER_DEF_UTIL dependencies on FND_API

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

34: IS
35: BEGIN
36:
37: IF p_attr_code =('ACCOUNTING_RULE_ID') THEN
38: IF NVL(p_record.ACCOUNTING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
39: RETURN p_record.ACCOUNTING_RULE_ID;
40: ELSE
41: RETURN NULL;
42: END IF;

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

40: ELSE
41: RETURN NULL;
42: END IF;
43: ELSIF p_attr_code =('ATTRIBUTE1') THEN
44: IF NVL(p_record.ATTRIBUTE1, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
45: RETURN p_record.ATTRIBUTE1;
46: ELSE
47: RETURN NULL;
48: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 164: IF NVL(p_record.BLANKET_MAX_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 170: IF NVL(p_record.BLANKET_MIN_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 212: IF NVL(p_record.DEFAULT_DISCOUNT_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 218: IF NVL(p_record.DEFAULT_DISCOUNT_PERCENT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

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

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

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

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

Line 236: IF NVL(p_record.END_DATE_ACTIVE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

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

Line 242: IF NVL(p_record.ENFORCE_ACCOUNTING_RULE_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

Line 248: IF NVL(p_record.ENFORCE_FREIGHT_TERM_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

Line 254: IF NVL(p_record.ENFORCE_INVOICE_TO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

Line 260: IF NVL(p_record.ENFORCE_INVOICING_RULE_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

Line 266: IF NVL(p_record.ENFORCE_PAYMENT_TERM_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

Line 272: IF NVL(p_record.ENFORCE_PRICE_LIST_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

Line 278: IF NVL(p_record.ENFORCE_SHIPPING_METHOD_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

Line 284: IF NVL(p_record.ENFORCE_SHIP_TO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

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

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

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

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

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

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

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

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

Line 314: IF NVL(p_record.NEW_MODIFIER_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 320: IF NVL(p_record.NEW_PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 326: IF NVL(p_record.ON_HOLD_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

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

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

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

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

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

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

Line 350: IF NVL(p_record.OVERRIDE_AMOUNT_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

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

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

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

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

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

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

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

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

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

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

Line 386: IF NVL(p_record.REVISION_CHANGE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 458: IF NVL(p_record.START_DATE_ACTIVE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 519: IF NVL(p_record.END_DATE_ACTIVE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

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

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

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

Line 531: IF NVL(p_record.REVISION_CHANGE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

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

Line 537: IF NVL(p_record.START_DATE_ACTIVE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

647: ELSE
648: RETURN NULL;
649: END IF;
650: ELSIF p_attr_code =('ATTRIBUTE6') THEN
651: IF NVL(p_record.ATTRIBUTE6, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
652: RETURN to_date(p_record.ATTRIBUTE6,'RRRR/MM/DD HH24:MI:SS');
653: ELSE
654: RETURN NULL;
655: END IF;

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

653: ELSE
654: RETURN NULL;
655: END IF;
656: ELSIF p_attr_code =('ATTRIBUTE7') THEN
657: IF NVL(p_record.ATTRIBUTE7, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
658: RETURN to_date(p_record.ATTRIBUTE7,'RRRR/MM/DD HH24:MI:SS');
659: ELSE
660: RETURN NULL;
661: END IF;

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

659: ELSE
660: RETURN NULL;
661: END IF;
662: ELSIF p_attr_code =('ATTRIBUTE8') THEN
663: IF NVL(p_record.ATTRIBUTE8, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
664: RETURN to_date(p_record.ATTRIBUTE8,'RRRR/MM/DD HH24:MI:SS');
665: ELSE
666: RETURN NULL;
667: END IF;

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

665: ELSE
666: RETURN NULL;
667: END IF;
668: ELSIF p_attr_code =('ATTRIBUTE9') THEN
669: IF NVL(p_record.ATTRIBUTE9, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
670: RETURN to_date(p_record.ATTRIBUTE9,'RRRR/MM/DD HH24:MI:SS');
671: ELSE
672: RETURN NULL;
673: END IF;

Line 675: IF NVL(p_record.BLANKET_MAX_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

671: ELSE
672: RETURN NULL;
673: END IF;
674: ELSIF p_attr_code =('BLANKET_MAX_AMOUNT') THEN
675: IF NVL(p_record.BLANKET_MAX_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
676: RETURN to_date(p_record.BLANKET_MAX_AMOUNT,'RRRR/MM/DD HH24:MI:SS');
677: ELSE
678: RETURN NULL;
679: END IF;

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

677: ELSE
678: RETURN NULL;
679: END IF;
680: ELSIF p_attr_code =('BLANKET_MIN_AMOUNT') THEN
681: IF NVL(p_record.BLANKET_MIN_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
682: RETURN to_date(p_record.BLANKET_MIN_AMOUNT,'RRRR/MM/DD HH24:MI:SS');
683: ELSE
684: RETURN NULL;
685: END IF;

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

683: ELSE
684: RETURN NULL;
685: END IF;
686: ELSIF p_attr_code =('CONTEXT') THEN
687: IF NVL(p_record.CONTEXT, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
688: RETURN to_date(p_record.CONTEXT,'RRRR/MM/DD HH24:MI:SS');
689: ELSE
690: RETURN NULL;
691: END IF;

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

689: ELSE
690: RETURN NULL;
691: END IF;
692: ELSIF p_attr_code =('CONTRACT_TERMS') THEN
693: IF NVL(p_record.CONTRACT_TERMS, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
694: RETURN to_date(p_record.CONTRACT_TERMS,'RRRR/MM/DD HH24:MI:SS');
695: ELSE
696: RETURN NULL;
697: END IF;

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

695: ELSE
696: RETURN NULL;
697: END IF;
698: ELSIF p_attr_code =('CONVERSION_TYPE_CODE') THEN
699: IF NVL(p_record.CONVERSION_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
700: RETURN to_date(p_record.CONVERSION_TYPE_CODE,'RRRR/MM/DD HH24:MI:SS');
701: ELSE
702: RETURN NULL;
703: END IF;

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

701: ELSE
702: RETURN NULL;
703: END IF;
704: ELSIF p_attr_code =('CUSTOMER_SIGNATURE') THEN
705: IF NVL(p_record.CUSTOMER_SIGNATURE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
706: RETURN to_date(p_record.CUSTOMER_SIGNATURE,'RRRR/MM/DD HH24:MI:SS');
707: ELSE
708: RETURN NULL;
709: END IF;

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

707: ELSE
708: RETURN NULL;
709: END IF;
710: ELSIF p_attr_code =('CUST_PO_NUMBER') THEN
711: IF NVL(p_record.CUST_PO_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
712: RETURN to_date(p_record.CUST_PO_NUMBER,'RRRR/MM/DD HH24:MI:SS');
713: ELSE
714: RETURN NULL;
715: END IF;

Line 717: IF NVL(p_record.DEFAULT_DISCOUNT_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

713: ELSE
714: RETURN NULL;
715: END IF;
716: ELSIF p_attr_code =('DEFAULT_DISCOUNT_AMOUNT') THEN
717: IF NVL(p_record.DEFAULT_DISCOUNT_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
718: RETURN to_date(p_record.DEFAULT_DISCOUNT_AMOUNT,'RRRR/MM/DD HH24:MI:SS');
719: ELSE
720: RETURN NULL;
721: END IF;

Line 723: IF NVL(p_record.DEFAULT_DISCOUNT_PERCENT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

719: ELSE
720: RETURN NULL;
721: END IF;
722: ELSIF p_attr_code =('DEFAULT_DISCOUNT_PERCENT') THEN
723: IF NVL(p_record.DEFAULT_DISCOUNT_PERCENT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
724: RETURN to_date(p_record.DEFAULT_DISCOUNT_PERCENT,'RRRR/MM/DD HH24:MI:SS');
725: ELSE
726: RETURN NULL;
727: END IF;

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

725: ELSE
726: RETURN NULL;
727: END IF;
728: ELSIF p_attr_code =('DELIVER_TO_ORG_ID') THEN
729: IF NVL(p_record.DELIVER_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
730: RETURN to_date(p_record.DELIVER_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
731: ELSE
732: RETURN NULL;
733: END IF;

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

731: ELSE
732: RETURN NULL;
733: END IF;
734: ELSIF p_attr_code =('DRAFT_SUBMITTED_FLAG') THEN
735: IF NVL(p_record.DRAFT_SUBMITTED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
736: RETURN to_date(p_record.DRAFT_SUBMITTED_FLAG,'RRRR/MM/DD HH24:MI:SS');
737: ELSE
738: RETURN NULL;
739: END IF;

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

737: ELSE
738: RETURN NULL;
739: END IF;
740: ELSIF p_attr_code =('ENFORCE_ACCOUNTING_RULE_FLAG') THEN
741: IF NVL(p_record.ENFORCE_ACCOUNTING_RULE_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
742: RETURN to_date(p_record.ENFORCE_ACCOUNTING_RULE_FLAG,'RRRR/MM/DD HH24:MI:SS');
743: ELSE
744: RETURN NULL;
745: END IF;

Line 747: IF NVL(p_record.ENFORCE_FREIGHT_TERM_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

743: ELSE
744: RETURN NULL;
745: END IF;
746: ELSIF p_attr_code =('ENFORCE_FREIGHT_TERM_FLAG') THEN
747: IF NVL(p_record.ENFORCE_FREIGHT_TERM_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
748: RETURN to_date(p_record.ENFORCE_FREIGHT_TERM_FLAG,'RRRR/MM/DD HH24:MI:SS');
749: ELSE
750: RETURN NULL;
751: END IF;

Line 753: IF NVL(p_record.ENFORCE_INVOICE_TO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

749: ELSE
750: RETURN NULL;
751: END IF;
752: ELSIF p_attr_code =('ENFORCE_INVOICE_TO_FLAG') THEN
753: IF NVL(p_record.ENFORCE_INVOICE_TO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
754: RETURN to_date(p_record.ENFORCE_INVOICE_TO_FLAG,'RRRR/MM/DD HH24:MI:SS');
755: ELSE
756: RETURN NULL;
757: END IF;

Line 759: IF NVL(p_record.ENFORCE_INVOICING_RULE_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

755: ELSE
756: RETURN NULL;
757: END IF;
758: ELSIF p_attr_code =('ENFORCE_INVOICING_RULE_FLAG') THEN
759: IF NVL(p_record.ENFORCE_INVOICING_RULE_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
760: RETURN to_date(p_record.ENFORCE_INVOICING_RULE_FLAG,'RRRR/MM/DD HH24:MI:SS');
761: ELSE
762: RETURN NULL;
763: END IF;

Line 765: IF NVL(p_record.ENFORCE_PAYMENT_TERM_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

761: ELSE
762: RETURN NULL;
763: END IF;
764: ELSIF p_attr_code =('ENFORCE_PAYMENT_TERM_FLAG') THEN
765: IF NVL(p_record.ENFORCE_PAYMENT_TERM_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
766: RETURN to_date(p_record.ENFORCE_PAYMENT_TERM_FLAG,'RRRR/MM/DD HH24:MI:SS');
767: ELSE
768: RETURN NULL;
769: END IF;

Line 771: IF NVL(p_record.ENFORCE_PRICE_LIST_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

767: ELSE
768: RETURN NULL;
769: END IF;
770: ELSIF p_attr_code =('ENFORCE_PRICE_LIST_FLAG') THEN
771: IF NVL(p_record.ENFORCE_PRICE_LIST_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
772: RETURN to_date(p_record.ENFORCE_PRICE_LIST_FLAG,'RRRR/MM/DD HH24:MI:SS');
773: ELSE
774: RETURN NULL;
775: END IF;

Line 777: IF NVL(p_record.ENFORCE_SHIPPING_METHOD_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

773: ELSE
774: RETURN NULL;
775: END IF;
776: ELSIF p_attr_code =('ENFORCE_SHIPPING_METHOD_FLAG') THEN
777: IF NVL(p_record.ENFORCE_SHIPPING_METHOD_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
778: RETURN to_date(p_record.ENFORCE_SHIPPING_METHOD_FLAG,'RRRR/MM/DD HH24:MI:SS');
779: ELSE
780: RETURN NULL;
781: END IF;

Line 783: IF NVL(p_record.ENFORCE_SHIP_TO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

779: ELSE
780: RETURN NULL;
781: END IF;
782: ELSIF p_attr_code =('ENFORCE_SHIP_TO_FLAG') THEN
783: IF NVL(p_record.ENFORCE_SHIP_TO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
784: RETURN to_date(p_record.ENFORCE_SHIP_TO_FLAG,'RRRR/MM/DD HH24:MI:SS');
785: ELSE
786: RETURN NULL;
787: END IF;

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

785: ELSE
786: RETURN NULL;
787: END IF;
788: ELSIF p_attr_code =('FLOW_STATUS_CODE') THEN
789: IF NVL(p_record.FLOW_STATUS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
790: RETURN to_date(p_record.FLOW_STATUS_CODE,'RRRR/MM/DD HH24:MI:SS');
791: ELSE
792: RETURN NULL;
793: END IF;

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

791: ELSE
792: RETURN NULL;
793: END IF;
794: ELSIF p_attr_code =('FREIGHT_TERMS_CODE') THEN
795: IF NVL(p_record.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
796: RETURN to_date(p_record.FREIGHT_TERMS_CODE,'RRRR/MM/DD HH24:MI:SS');
797: ELSE
798: RETURN NULL;
799: END IF;

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

797: ELSE
798: RETURN NULL;
799: END IF;
800: ELSIF p_attr_code =('INVOICE_TO_ORG_ID') THEN
801: IF NVL(p_record.INVOICE_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
802: RETURN to_date(p_record.INVOICE_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
803: ELSE
804: RETURN NULL;
805: END IF;

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

803: ELSE
804: RETURN NULL;
805: END IF;
806: ELSIF p_attr_code =('INVOICING_RULE_ID') THEN
807: IF NVL(p_record.INVOICING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
808: RETURN to_date(p_record.INVOICING_RULE_ID,'RRRR/MM/DD HH24:MI:SS');
809: ELSE
810: RETURN NULL;
811: END IF;

Line 813: IF NVL(p_record.NEW_MODIFIER_LIST_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 =('NEW_MODIFIER_LIST_ID') THEN
813: IF NVL(p_record.NEW_MODIFIER_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
814: RETURN to_date(p_record.NEW_MODIFIER_LIST_ID,'RRRR/MM/DD HH24:MI:SS');
815: ELSE
816: RETURN NULL;
817: END IF;

Line 819: IF NVL(p_record.NEW_PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

815: ELSE
816: RETURN NULL;
817: END IF;
818: ELSIF p_attr_code =('NEW_PRICE_LIST_ID') THEN
819: IF NVL(p_record.NEW_PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
820: RETURN to_date(p_record.NEW_PRICE_LIST_ID,'RRRR/MM/DD HH24:MI:SS');
821: ELSE
822: RETURN NULL;
823: END IF;

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

821: ELSE
822: RETURN NULL;
823: END IF;
824: ELSIF p_attr_code =('ON_HOLD_FLAG') THEN
825: IF NVL(p_record.ON_HOLD_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
826: RETURN to_date(p_record.ON_HOLD_FLAG,'RRRR/MM/DD HH24:MI:SS');
827: ELSE
828: RETURN NULL;
829: END IF;

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

827: ELSE
828: RETURN NULL;
829: END IF;
830: ELSIF p_attr_code =('OPEN_FLAG') THEN
831: IF NVL(p_record.OPEN_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
832: RETURN to_date(p_record.OPEN_FLAG,'RRRR/MM/DD HH24:MI:SS');
833: ELSE
834: RETURN NULL;
835: END IF;

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

833: ELSE
834: RETURN NULL;
835: END IF;
836: ELSIF p_attr_code =('ORDER_NUMBER') THEN
837: IF NVL(p_record.ORDER_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
838: RETURN to_date(p_record.ORDER_NUMBER,'RRRR/MM/DD HH24:MI:SS');
839: ELSE
840: RETURN NULL;
841: END IF;

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

839: ELSE
840: RETURN NULL;
841: END IF;
842: ELSIF p_attr_code =('ORDER_TYPE_ID') THEN
843: IF NVL(p_record.ORDER_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
844: RETURN to_date(p_record.ORDER_TYPE_ID,'RRRR/MM/DD HH24:MI:SS');
845: ELSE
846: RETURN NULL;
847: END IF;

Line 849: IF NVL(p_record.OVERRIDE_AMOUNT_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

845: ELSE
846: RETURN NULL;
847: END IF;
848: ELSIF p_attr_code =('OVERRIDE_AMOUNT_FLAG') THEN
849: IF NVL(p_record.OVERRIDE_AMOUNT_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
850: RETURN to_date(p_record.OVERRIDE_AMOUNT_FLAG,'RRRR/MM/DD HH24:MI:SS');
851: ELSE
852: RETURN NULL;
853: END IF;

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

851: ELSE
852: RETURN NULL;
853: END IF;
854: ELSIF p_attr_code =('PACKING_INSTRUCTIONS') THEN
855: IF NVL(p_record.PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
856: RETURN to_date(p_record.PACKING_INSTRUCTIONS,'RRRR/MM/DD HH24:MI:SS');
857: ELSE
858: RETURN NULL;
859: END IF;

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

857: ELSE
858: RETURN NULL;
859: END IF;
860: ELSIF p_attr_code =('PAYMENT_TERM_ID') THEN
861: IF NVL(p_record.PAYMENT_TERM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
862: RETURN to_date(p_record.PAYMENT_TERM_ID,'RRRR/MM/DD HH24:MI:SS');
863: ELSE
864: RETURN NULL;
865: END IF;

Line 867: IF NVL(p_record.PRICE_LIST_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 =('PRICE_LIST_ID') THEN
867: IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
868: RETURN to_date(p_record.PRICE_LIST_ID,'RRRR/MM/DD HH24:MI:SS');
869: ELSE
870: RETURN NULL;
871: END IF;

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

869: ELSE
870: RETURN NULL;
871: END IF;
872: ELSIF p_attr_code =('QUOTE_NUMBER') THEN
873: IF NVL(p_record.QUOTE_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
874: RETURN to_date(p_record.QUOTE_NUMBER,'RRRR/MM/DD HH24:MI:SS');
875: ELSE
876: RETURN NULL;
877: END IF;

Line 879: IF NVL(p_record.SALESREP_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 =('SALESREP_ID') THEN
879: IF NVL(p_record.SALESREP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
880: RETURN to_date(p_record.SALESREP_ID,'RRRR/MM/DD HH24:MI:SS');
881: ELSE
882: RETURN NULL;
883: END IF;

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

881: ELSE
882: RETURN NULL;
883: END IF;
884: ELSIF p_attr_code =('SALES_DOCUMENT_NAME') THEN
885: IF NVL(p_record.SALES_DOCUMENT_NAME, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
886: RETURN to_date(p_record.SALES_DOCUMENT_NAME,'RRRR/MM/DD HH24:MI:SS');
887: ELSE
888: RETURN NULL;
889: END IF;

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

887: ELSE
888: RETURN NULL;
889: END IF;
890: ELSIF p_attr_code =('SHIPPING_INSTRUCTIONS') THEN
891: IF NVL(p_record.SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
892: RETURN to_date(p_record.SHIPPING_INSTRUCTIONS,'RRRR/MM/DD HH24:MI:SS');
893: ELSE
894: RETURN NULL;
895: END IF;

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

893: ELSE
894: RETURN NULL;
895: END IF;
896: ELSIF p_attr_code =('SHIPPING_METHOD_CODE') THEN
897: IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
898: RETURN to_date(p_record.SHIPPING_METHOD_CODE,'RRRR/MM/DD HH24:MI:SS');
899: ELSE
900: RETURN NULL;
901: END IF;

Line 903: IF NVL(p_record.SHIP_FROM_ORG_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 =('SHIP_FROM_ORG_ID') THEN
903: IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
904: RETURN to_date(p_record.SHIP_FROM_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
905: ELSE
906: RETURN NULL;
907: END IF;

Line 909: IF NVL(p_record.SHIP_TO_ORG_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 =('SHIP_TO_ORG_ID') THEN
909: IF NVL(p_record.SHIP_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
910: RETURN to_date(p_record.SHIP_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
911: ELSE
912: RETURN NULL;
913: END IF;

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

911: ELSE
912: RETURN NULL;
913: END IF;
914: ELSIF p_attr_code =('SOLD_TO_CONTACT_ID') THEN
915: IF NVL(p_record.SOLD_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
916: RETURN to_date(p_record.SOLD_TO_CONTACT_ID,'RRRR/MM/DD HH24:MI:SS');
917: ELSE
918: RETURN NULL;
919: END IF;

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

917: ELSE
918: RETURN NULL;
919: END IF;
920: ELSIF p_attr_code =('SOLD_TO_ORG_ID') THEN
921: IF NVL(p_record.SOLD_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
922: RETURN to_date(p_record.SOLD_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
923: ELSE
924: RETURN NULL;
925: END IF;

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

923: ELSE
924: RETURN NULL;
925: END IF;
926: ELSIF p_attr_code =('SOLD_TO_SITE_USE_ID') THEN
927: IF NVL(p_record.SOLD_TO_SITE_USE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
928: RETURN to_date(p_record.SOLD_TO_SITE_USE_ID,'RRRR/MM/DD HH24:MI:SS');
929: ELSE
930: RETURN NULL;
931: END IF;

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

929: ELSE
930: RETURN NULL;
931: END IF;
932: ELSIF p_attr_code =('SOURCE_DOCUMENT_TYPE_ID') THEN
933: IF NVL(p_record.SOURCE_DOCUMENT_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
934: RETURN to_date(p_record.SOURCE_DOCUMENT_TYPE_ID,'RRRR/MM/DD HH24:MI:SS');
935: ELSE
936: RETURN NULL;
937: END IF;

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

935: ELSE
936: RETURN NULL;
937: END IF;
938: ELSIF p_attr_code =('SOURCE_DOCUMENT_VERSION_NUMBER') THEN
939: IF NVL(p_record.SOURCE_DOCUMENT_VERSION_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
940: RETURN to_date(p_record.SOURCE_DOCUMENT_VERSION_NUMBER,'RRRR/MM/DD HH24:MI:SS');
941: ELSE
942: RETURN NULL;
943: END IF;

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

941: ELSE
942: RETURN NULL;
943: END IF;
944: ELSIF p_attr_code =('SUPPLIER_SIGNATURE') THEN
945: IF NVL(p_record.SUPPLIER_SIGNATURE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
946: RETURN to_date(p_record.SUPPLIER_SIGNATURE,'RRRR/MM/DD HH24:MI:SS');
947: ELSE
948: RETURN NULL;
949: END IF;

Line 951: IF NVL(p_record.TRANSACTIONAL_CURR_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 =('TRANSACTIONAL_CURR_CODE') THEN
951: IF NVL(p_record.TRANSACTIONAL_CURR_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
952: RETURN to_date(p_record.TRANSACTIONAL_CURR_CODE,'RRRR/MM/DD HH24:MI:SS');
953: ELSE
954: RETURN NULL;
955: END IF;

Line 957: IF NVL(p_record.TRANSACTION_PHASE_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 =('TRANSACTION_PHASE_CODE') THEN
957: IF NVL(p_record.TRANSACTION_PHASE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
958: RETURN to_date(p_record.TRANSACTION_PHASE_CODE,'RRRR/MM/DD HH24:MI:SS');
959: ELSE
960: RETURN NULL;
961: END IF;

Line 963: IF NVL(p_record.USER_STATUS_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 =('USER_STATUS_CODE') THEN
963: IF NVL(p_record.USER_STATUS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
964: RETURN to_date(p_record.USER_STATUS_CODE,'RRRR/MM/DD HH24:MI:SS');
965: ELSE
966: RETURN NULL;
967: END IF;

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

965: ELSE
966: RETURN NULL;
967: END IF;
968: ELSIF p_attr_code =('VERSION_NUMBER') THEN
969: IF NVL(p_record.VERSION_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
970: RETURN to_date(p_record.VERSION_NUMBER,'RRRR/MM/DD HH24:MI:SS');
971: ELSE
972: RETURN NULL;
973: END IF;

Line 1000: IF (NVL(p_ORDER_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)

996: WHERE ORDER_NUMBER = p_ORDER_NUMBER
997: ;
998: BEGIN
999:
1000: IF (NVL(p_ORDER_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
1001: THEN
1002: RETURN 0 ;
1003: ELSIF (NVL(g_cached_record.ORDER_NUMBER,FND_API.G_MISS_NUM) <> p_ORDER_NUMBER)
1004: THEN

Line 1003: ELSIF (NVL(g_cached_record.ORDER_NUMBER,FND_API.G_MISS_NUM) <> p_ORDER_NUMBER)

999:
1000: IF (NVL(p_ORDER_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
1001: THEN
1002: RETURN 0 ;
1003: ELSIF (NVL(g_cached_record.ORDER_NUMBER,FND_API.G_MISS_NUM) <> p_ORDER_NUMBER)
1004: THEN
1005: Clear_BLANKET_HEADER_Cache;
1006: Open cache;
1007: FETCH cache into g_cached_record;