eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ONT_ORDER_TYPE_DEF_UTIL dependencies on FND_API

Line 38: IF NVL(p_record.ACCOUNTING_CREDIT_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 140: IF NVL(p_record.NON_DELIVERY_INVOICE_SOURCE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 146: IF NVL(p_record.ORDER_NUMBER_SOURCE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

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

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

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

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

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

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

Line 170: IF NVL(p_record.SCHEDULING_LEVEL_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

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

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

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

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

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

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

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

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

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

209: IS
210: BEGIN
211:
212: IF p_attr_code =('ACCOUNTING_CREDIT_METHOD_CODE') THEN
213: IF NVL(p_record.ACCOUNTING_CREDIT_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
214: RETURN to_date(p_record.ACCOUNTING_CREDIT_METHOD_CODE,'RRRR/MM/DD HH24:MI:SS');
215: ELSE
216: RETURN NULL;
217: END IF;

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

215: ELSE
216: RETURN NULL;
217: END IF;
218: ELSIF p_attr_code =('ACCOUNTING_RULE_ID') THEN
219: IF NVL(p_record.ACCOUNTING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
220: RETURN to_date(p_record.ACCOUNTING_RULE_ID,'RRRR/MM/DD HH24:MI:SS');
221: ELSE
222: RETURN NULL;
223: END IF;

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

221: ELSE
222: RETURN NULL;
223: END IF;
224: ELSIF p_attr_code =('AGREEMENT_TYPE_CODE') THEN
225: IF NVL(p_record.AGREEMENT_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
226: RETURN to_date(p_record.AGREEMENT_TYPE_CODE,'RRRR/MM/DD HH24:MI:SS');
227: ELSE
228: RETURN NULL;
229: END IF;

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

227: ELSE
228: RETURN NULL;
229: END IF;
230: ELSIF p_attr_code =('CONVERSION_TYPE_CODE') THEN
231: IF NVL(p_record.CONVERSION_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
232: RETURN to_date(p_record.CONVERSION_TYPE_CODE,'RRRR/MM/DD HH24:MI:SS');
233: ELSE
234: RETURN NULL;
235: END IF;

Line 237: IF NVL(p_record.COST_OF_GOODS_SOLD_ACCOUNT, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

233: ELSE
234: RETURN NULL;
235: END IF;
236: ELSIF p_attr_code =('COST_OF_GOODS_SOLD_ACCOUNT') THEN
237: IF NVL(p_record.COST_OF_GOODS_SOLD_ACCOUNT, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
238: RETURN to_date(p_record.COST_OF_GOODS_SOLD_ACCOUNT,'RRRR/MM/DD HH24:MI:SS');
239: ELSE
240: RETURN NULL;
241: END IF;

Line 243: IF NVL(p_record.CUST_TRX_TYPE_ID, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

239: ELSE
240: RETURN NULL;
241: END IF;
242: ELSIF p_attr_code =('CUST_TRXN_TYPE_ID') THEN
243: IF NVL(p_record.CUST_TRX_TYPE_ID, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
244: RETURN to_date(p_record.CUST_TRX_TYPE_ID,'RRRR/MM/DD HH24:MI:SS');
245: ELSE
246: RETURN NULL;
247: END IF;

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

245: ELSE
246: RETURN NULL;
247: END IF;
248: ELSIF p_attr_code =('DEFAULT_FULFILLMENT_SET') THEN
249: IF NVL(p_record.DEFAULT_FULFILLMENT_SET, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
250: RETURN to_date(p_record.DEFAULT_FULFILLMENT_SET,'RRRR/MM/DD HH24:MI:SS');
251: ELSE
252: RETURN NULL;
253: END IF;

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

251: ELSE
252: RETURN NULL;
253: END IF;
254: ELSIF p_attr_code =('DEFAULT_INBOUND_LINE_TYPE_ID') THEN
255: IF NVL(p_record.DEFAULT_INBOUND_LINE_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
256: RETURN to_date(p_record.DEFAULT_INBOUND_LINE_TYPE_ID,'RRRR/MM/DD HH24:MI:SS');
257: ELSE
258: RETURN NULL;
259: END IF;

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

257: ELSE
258: RETURN NULL;
259: END IF;
260: ELSIF p_attr_code =('DEFAULT_LINE_SET') THEN
261: IF NVL(p_record.DEFAULT_LINE_SET_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
262: RETURN to_date(p_record.DEFAULT_LINE_SET_CODE,'RRRR/MM/DD HH24:MI:SS');
263: ELSE
264: RETURN NULL;
265: END IF;

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

263: ELSE
264: RETURN NULL;
265: END IF;
266: ELSIF p_attr_code =('DEFAULT_OUTBOUND_LINE_TYPE_ID') THEN
267: IF NVL(p_record.DEFAULT_OUTBOUND_LINE_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
268: RETURN to_date(p_record.DEFAULT_OUTBOUND_LINE_TYPE_ID,'RRRR/MM/DD HH24:MI:SS');
269: ELSE
270: RETURN NULL;
271: END IF;

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

269: ELSE
270: RETURN NULL;
271: END IF;
272: ELSIF p_attr_code =('DEF_TRANSACTION_PHASE_CODE') THEN
273: IF NVL(p_record.DEF_TRANSACTION_PHASE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
274: RETURN to_date(p_record.DEF_TRANSACTION_PHASE_CODE,'RRRR/MM/DD HH24:MI:SS');
275: ELSE
276: RETURN NULL;
277: END IF;

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

275: ELSE
276: RETURN NULL;
277: END IF;
278: ELSIF p_attr_code =('DEMAND_CLASS_CODE') THEN
279: IF NVL(p_record.DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
280: RETURN to_date(p_record.DEMAND_CLASS_CODE,'RRRR/MM/DD HH24:MI:SS');
281: ELSE
282: RETURN NULL;
283: END IF;

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

281: ELSE
282: RETURN NULL;
283: END IF;
284: ELSIF p_attr_code =('FOB_POINT_CODE') THEN
285: IF NVL(p_record.FOB_POINT_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
286: RETURN to_date(p_record.FOB_POINT_CODE,'RRRR/MM/DD HH24:MI:SS');
287: ELSE
288: RETURN NULL;
289: END IF;

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

287: ELSE
288: RETURN NULL;
289: END IF;
290: ELSIF p_attr_code =('FREIGHT_TERMS_CODE') THEN
291: IF NVL(p_record.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
292: RETURN to_date(p_record.FREIGHT_TERMS_CODE,'RRRR/MM/DD HH24:MI:SS');
293: ELSE
294: RETURN NULL;
295: END IF;

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

293: ELSE
294: RETURN NULL;
295: END IF;
296: ELSIF p_attr_code =('INVOICE_SOURCE_ID') THEN
297: IF NVL(p_record.INVOICE_SOURCE_ID, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
298: RETURN to_date(p_record.INVOICE_SOURCE_ID,'RRRR/MM/DD HH24:MI:SS');
299: ELSE
300: RETURN NULL;
301: END IF;

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

299: ELSE
300: RETURN NULL;
301: END IF;
302: ELSIF p_attr_code =('INVOICING_CREDIT_METHOD_CODE') THEN
303: IF NVL(p_record.INVOICING_CREDIT_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
304: RETURN to_date(p_record.INVOICING_CREDIT_METHOD_CODE,'RRRR/MM/DD HH24:MI:SS');
305: ELSE
306: RETURN NULL;
307: END IF;

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

305: ELSE
306: RETURN NULL;
307: END IF;
308: ELSIF p_attr_code =('INVOICING_RULE_ID') THEN
309: IF NVL(p_record.INVOICING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
310: RETURN to_date(p_record.INVOICING_RULE_ID,'RRRR/MM/DD HH24:MI:SS');
311: ELSE
312: RETURN NULL;
313: END IF;

Line 315: IF NVL(p_record.NON_DELIVERY_INVOICE_SOURCE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

311: ELSE
312: RETURN NULL;
313: END IF;
314: ELSIF p_attr_code =('NON_DELIVERY_INVOICE_SOURCE_ID') THEN
315: IF NVL(p_record.NON_DELIVERY_INVOICE_SOURCE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
316: RETURN to_date(p_record.NON_DELIVERY_INVOICE_SOURCE_ID,'RRRR/MM/DD HH24:MI:SS');
317: ELSE
318: RETURN NULL;
319: END IF;

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

317: ELSE
318: RETURN NULL;
319: END IF;
320: ELSIF p_attr_code =('OERDER_NUMBER_SOURCE_ID') THEN
321: IF NVL(p_record.ORDER_NUMBER_SOURCE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
322: RETURN to_date(p_record.ORDER_NUMBER_SOURCE_ID,'RRRR/MM/DD HH24:MI:SS');
323: ELSE
324: RETURN NULL;
325: END IF;

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

323: ELSE
324: RETURN NULL;
325: END IF;
326: ELSIF p_attr_code =('ORDER_CATEGORY_CODE') THEN
327: IF NVL(p_record.ORDER_CATEGORY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
328: RETURN to_date(p_record.ORDER_CATEGORY_CODE,'RRRR/MM/DD HH24:MI:SS');
329: ELSE
330: RETURN NULL;
331: END IF;

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

329: ELSE
330: RETURN NULL;
331: END IF;
332: ELSIF p_attr_code =('ORDER_TYPE_ID') THEN
333: IF NVL(p_record.ORDER_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
334: RETURN to_date(p_record.ORDER_TYPE_ID,'RRRR/MM/DD HH24:MI:SS');
335: ELSE
336: RETURN NULL;
337: END IF;

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

335: ELSE
336: RETURN NULL;
337: END IF;
338: ELSIF p_attr_code =('PRICE_LIST_ID') THEN
339: IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
340: RETURN to_date(p_record.PRICE_LIST_ID,'RRRR/MM/DD HH24:MI:SS');
341: ELSE
342: RETURN NULL;
343: END IF;

Line 345: IF NVL(p_record.SCHEDULING_LEVEL_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

341: ELSE
342: RETURN NULL;
343: END IF;
344: ELSIF p_attr_code =('SCHEDULING_LEVEL_CODE') THEN
345: IF NVL(p_record.SCHEDULING_LEVEL_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
346: RETURN to_date(p_record.SCHEDULING_LEVEL_CODE,'RRRR/MM/DD HH24:MI:SS');
347: ELSE
348: RETURN NULL;
349: END IF;

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

347: ELSE
348: RETURN NULL;
349: END IF;
350: ELSIF p_attr_code =('SHIPMENT_PRIORITY_CODE') THEN
351: IF NVL(p_record.SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
352: RETURN to_date(p_record.SHIPMENT_PRIORITY_CODE,'RRRR/MM/DD HH24:MI:SS');
353: ELSE
354: RETURN NULL;
355: END IF;

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

353: ELSE
354: RETURN NULL;
355: END IF;
356: ELSIF p_attr_code =('SHIPPING_METHOD_CODE') THEN
357: IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
358: RETURN to_date(p_record.SHIPPING_METHOD_CODE,'RRRR/MM/DD HH24:MI:SS');
359: ELSE
360: RETURN NULL;
361: END IF;

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

359: ELSE
360: RETURN NULL;
361: END IF;
362: ELSIF p_attr_code =('SHIP_FROM_ORG_ID') THEN
363: IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
364: RETURN to_date(p_record.SHIP_FROM_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
365: ELSE
366: RETURN NULL;
367: END IF;

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

365: ELSE
366: RETURN NULL;
367: END IF;
368: ELSIF p_attr_code =('TRANSACTIONAL_CURR_CODE') THEN
369: IF NVL(p_record.CURRENCY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
370: RETURN to_date(p_record.CURRENCY_CODE,'RRRR/MM/DD HH24:MI:SS');
371: ELSE
372: RETURN NULL;
373: END IF;

Line 400: IF (NVL(p_ORDER_TYPE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)

396: WHERE ORDER_TYPE_ID = p_ORDER_TYPE_ID
397: ;
398: BEGIN
399:
400: IF (NVL(p_ORDER_TYPE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
401: THEN
402: RETURN 0 ;
403: ELSIF (NVL(g_cached_record.ORDER_TYPE_ID,FND_API.G_MISS_NUM) <> p_ORDER_TYPE_ID)
404: THEN

Line 403: ELSIF (NVL(g_cached_record.ORDER_TYPE_ID,FND_API.G_MISS_NUM) <> p_ORDER_TYPE_ID)

399:
400: IF (NVL(p_ORDER_TYPE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
401: THEN
402: RETURN 0 ;
403: ELSIF (NVL(g_cached_record.ORDER_TYPE_ID,FND_API.G_MISS_NUM) <> p_ORDER_TYPE_ID)
404: THEN
405: Clear_ORDER_TYPE_Cache;
406: Open cache;
407: FETCH cache into g_cached_record;