APPS.ONT_BLANKET_LINE_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_LINE_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_LINE_MAX_AMOUNT') THEN
164: IF NVL(p_record.BLANKET_LINE_MAX_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
165: RETURN p_record.BLANKET_LINE_MAX_AMOUNT;
166: ELSE
167: RETURN NULL;
168: END IF;

Line 170: IF NVL(p_record.BLANKET_LINE_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_LINE_MIN_AMOUNT') THEN
170: IF NVL(p_record.BLANKET_LINE_MIN_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
171: RETURN p_record.BLANKET_LINE_MIN_AMOUNT;
172: ELSE
173: RETURN NULL;
174: END IF;

Line 176: IF NVL(p_record.BLANKET_MAX_QUANTITY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

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

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

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

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

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

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

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

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

Line 206: IF NVL(p_record.DISCOUNT_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

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

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

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

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

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

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

Line 230: IF NVL(p_record.ENFORCE_FREIGHT_TERM_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 =('ENFORCE_FREIGHT_TERM_FLAG') THEN
230: IF NVL(p_record.ENFORCE_FREIGHT_TERM_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
231: RETURN p_record.ENFORCE_FREIGHT_TERM_FLAG;
232: ELSE
233: RETURN NULL;
234: END IF;

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

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

Line 242: IF NVL(p_record.ENFORCE_INVOICING_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_INVOICING_RULE_FLAG') THEN
242: IF NVL(p_record.ENFORCE_INVOICING_RULE_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
243: RETURN p_record.ENFORCE_INVOICING_RULE_FLAG;
244: ELSE
245: RETURN NULL;
246: END IF;

Line 248: IF NVL(p_record.ENFORCE_PAYMENT_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_PAYMENT_TERM_FLAG') THEN
248: IF NVL(p_record.ENFORCE_PAYMENT_TERM_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
249: RETURN p_record.ENFORCE_PAYMENT_TERM_FLAG;
250: ELSE
251: RETURN NULL;
252: END IF;

Line 254: IF NVL(p_record.ENFORCE_PRICE_LIST_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_PRICE_LIST_FLAG') THEN
254: IF NVL(p_record.ENFORCE_PRICE_LIST_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
255: RETURN p_record.ENFORCE_PRICE_LIST_FLAG;
256: ELSE
257: RETURN NULL;
258: END IF;

Line 260: IF NVL(p_record.ENFORCE_SHIPPING_METHOD_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_SHIPPING_METHOD_FLAG') THEN
260: IF NVL(p_record.ENFORCE_SHIPPING_METHOD_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
261: RETURN p_record.ENFORCE_SHIPPING_METHOD_FLAG;
262: ELSE
263: RETURN NULL;
264: END IF;

Line 266: IF NVL(p_record.ENFORCE_SHIP_TO_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_SHIP_TO_FLAG') THEN
266: IF NVL(p_record.ENFORCE_SHIP_TO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
267: RETURN p_record.ENFORCE_SHIP_TO_FLAG;
268: ELSE
269: RETURN NULL;
270: END IF;

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

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

Line 278: IF NVL(p_record.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 326: IF NVL(p_record.MIN_RELEASE_QUANTITY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 332: IF NVL(p_record.MODIFIER_LIST_LINE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

328: ELSE
329: RETURN NULL;
330: END IF;
331: ELSIF p_attr_code =('MODIFIER_LIST_LINE_ID') THEN
332: IF NVL(p_record.MODIFIER_LIST_LINE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
333: RETURN p_record.MODIFIER_LIST_LINE_ID;
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_QUANTITY_UOM, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

Line 350: IF NVL(p_record.OVERRIDE_BLANKET_CONTROLS_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_BLANKET_CONTROLS_FLAG') THEN
350: IF NVL(p_record.OVERRIDE_BLANKET_CONTROLS_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
351: RETURN p_record.OVERRIDE_BLANKET_CONTROLS_FLAG;
352: ELSE
353: RETURN NULL;
354: END IF;

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

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

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

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

Line 368: IF NVL(p_record.PAYMENT_TERM_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 =('PAYMENT_TERM_ID') THEN
368: IF NVL(p_record.PAYMENT_TERM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
369: RETURN p_record.PAYMENT_TERM_ID;
370: ELSE
371: RETURN NULL;
372: END IF;

Line 374: IF NVL(p_record.PREFERRED_GRADE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

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

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

Line 386: IF NVL(p_record.PRICING_QUANTITY_UOM, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

382: ELSE
383: RETURN NULL;
384: END IF;
385: ELSIF p_attr_code =('PRICING_QUANTITY_UOM') THEN
386: IF NVL(p_record.PRICING_QUANTITY_UOM, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
387: RETURN p_record.PRICING_QUANTITY_UOM;
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.SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

Line 404: IF NVL(p_record.SHIPPING_METHOD_CODE, 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_METHOD_CODE') THEN
404: IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
405: RETURN p_record.SHIPPING_METHOD_CODE;
406: ELSE
407: RETURN NULL;
408: END IF;

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

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

Line 416: IF NVL(p_record.SHIP_TO_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_TO_ORG_ID') THEN
416: IF NVL(p_record.SHIP_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
417: RETURN p_record.SHIP_TO_ORG_ID;
418: ELSE
419: RETURN NULL;
420: END IF;

Line 422: IF NVL(p_record.SOURCE_DOCUMENT_TYPE_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 =('SOURCE_DOCUMENT_TYPE_ID') THEN
422: IF NVL(p_record.SOURCE_DOCUMENT_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
423: RETURN p_record.SOURCE_DOCUMENT_TYPE_ID;
424: ELSE
425: RETURN NULL;
426: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 609: IF NVL(p_record.BLANKET_LINE_MIN_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 615: IF NVL(p_record.BLANKET_MAX_QUANTITY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

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

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

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

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

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

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

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

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

Line 645: IF NVL(p_record.DISCOUNT_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 651: IF NVL(p_record.DISCOUNT_PERCENT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 711: IF NVL(p_record.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

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

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

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

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

Line 729: IF NVL(p_record.ITEM_IDENTIFIER_TYPE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

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

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

Line 741: IF NVL(p_record.MAX_RELEASE_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

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

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

Line 753: IF NVL(p_record.MIN_RELEASE_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

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

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

Line 765: IF NVL(p_record.MODIFIER_LIST_LINE_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 =('MODIFIER_LIST_LINE_ID') THEN
765: IF NVL(p_record.MODIFIER_LIST_LINE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
766: RETURN to_date(p_record.MODIFIER_LIST_LINE_ID,'RRRR/MM/DD HH24:MI:SS');
767: ELSE
768: RETURN NULL;
769: END IF;

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

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

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

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

Line 783: IF NVL(p_record.OVERRIDE_BLANKET_CONTROLS_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 =('OVERRIDE_BLANKET_CONTROLS_FLAG') THEN
783: IF NVL(p_record.OVERRIDE_BLANKET_CONTROLS_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
784: RETURN to_date(p_record.OVERRIDE_BLANKET_CONTROLS_FLAG,'RRRR/MM/DD HH24:MI:SS');
785: ELSE
786: RETURN NULL;
787: END IF;

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

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

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

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

Line 801: IF NVL(p_record.PAYMENT_TERM_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 =('PAYMENT_TERM_ID') THEN
801: IF NVL(p_record.PAYMENT_TERM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
802: RETURN to_date(p_record.PAYMENT_TERM_ID,'RRRR/MM/DD HH24:MI:SS');
803: ELSE
804: RETURN NULL;
805: END IF;

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

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

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

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

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

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

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

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

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

Line 837: IF NVL(p_record.SHIPPING_METHOD_CODE, 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_METHOD_CODE') THEN
837: IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
838: RETURN to_date(p_record.SHIPPING_METHOD_CODE,'RRRR/MM/DD HH24:MI:SS');
839: ELSE
840: RETURN NULL;
841: END IF;

Line 843: IF NVL(p_record.SHIP_FROM_ORG_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 =('SHIP_FROM_ORG_ID') THEN
843: IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
844: RETURN to_date(p_record.SHIP_FROM_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
845: ELSE
846: RETURN NULL;
847: END IF;

Line 849: IF NVL(p_record.SHIP_TO_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_TO_ORG_ID') THEN
849: IF NVL(p_record.SHIP_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
850: RETURN to_date(p_record.SHIP_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
851: ELSE
852: RETURN NULL;
853: END IF;

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

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

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

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

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

863: ELSE
864: RETURN NULL;
865: END IF;
866: ELSIF p_attr_code =('TRANSACTION_PHASE_CODE') THEN
867: IF NVL(p_record.TRANSACTION_PHASE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
868: RETURN to_date(p_record.TRANSACTION_PHASE_CODE,'RRRR/MM/DD HH24:MI:SS');
869: ELSE
870: RETURN NULL;
871: END IF;

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

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

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

903: AND LINE_NUMBER = p_LINE_NUMBER
904: ;
905: BEGIN
906:
907: IF (NVL(p_ORDER_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
908: OR (NVL(p_LINE_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
909: THEN
910: RETURN 0 ;
911: ELSIF (NVL(g_cached_record.ORDER_NUMBER,FND_API.G_MISS_NUM) <> p_ORDER_NUMBER)

Line 908: OR (NVL(p_LINE_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)

904: ;
905: BEGIN
906:
907: IF (NVL(p_ORDER_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
908: OR (NVL(p_LINE_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
909: THEN
910: RETURN 0 ;
911: ELSIF (NVL(g_cached_record.ORDER_NUMBER,FND_API.G_MISS_NUM) <> p_ORDER_NUMBER)
912: OR (NVL(g_cached_record.LINE_NUMBER,FND_API.G_MISS_NUM) <> p_LINE_NUMBER)

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

907: IF (NVL(p_ORDER_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
908: OR (NVL(p_LINE_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
909: THEN
910: RETURN 0 ;
911: ELSIF (NVL(g_cached_record.ORDER_NUMBER,FND_API.G_MISS_NUM) <> p_ORDER_NUMBER)
912: OR (NVL(g_cached_record.LINE_NUMBER,FND_API.G_MISS_NUM) <> p_LINE_NUMBER)
913: THEN
914: Clear_BLANKET_LINE_Cache;
915: Open cache;

Line 912: OR (NVL(g_cached_record.LINE_NUMBER,FND_API.G_MISS_NUM) <> p_LINE_NUMBER)

908: OR (NVL(p_LINE_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
909: THEN
910: RETURN 0 ;
911: ELSIF (NVL(g_cached_record.ORDER_NUMBER,FND_API.G_MISS_NUM) <> p_ORDER_NUMBER)
912: OR (NVL(g_cached_record.LINE_NUMBER,FND_API.G_MISS_NUM) <> p_LINE_NUMBER)
913: THEN
914: Clear_BLANKET_LINE_Cache;
915: Open cache;
916: FETCH cache into g_cached_record;