APPS.ONT_LINE_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.DEMAND_CLASS_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 =('DEMAND_CLASS_CODE') THEN
56: IF NVL(p_record.DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
57: RETURN p_record.DEMAND_CLASS_CODE;
58: ELSE
59: RETURN NULL;
60: END IF;

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

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

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

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

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

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

Line 80: IF NVL(p_record.INVOICING_RULE_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 =('INVOICING_RULE_ID') THEN
80: IF NVL(p_record.INVOICING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
81: RETURN p_record.INVOICING_RULE_ID;
82: ELSE
83: RETURN NULL;
84: END IF;

Line 86: IF NVL(p_record.ORDER_CATEGORY_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 =('LINE_TRXN_CATEGORY_CODE') THEN
86: IF NVL(p_record.ORDER_CATEGORY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
87: RETURN p_record.ORDER_CATEGORY_CODE;
88: ELSE
89: RETURN NULL;
90: END IF;

Line 92: IF NVL(p_record.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 =('LINE_TYPE_ID') THEN
92: IF NVL(p_record.LINE_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
93: RETURN p_record.LINE_TYPE_ID;
94: ELSE
95: RETURN NULL;
96: END IF;

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

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

Line 104: IF NVL(p_record.SHIPMENT_PRIORITY_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 =('SHIPMENT_PRIORITY_CODE') THEN
104: IF NVL(p_record.SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
105: RETURN p_record.SHIPMENT_PRIORITY_CODE;
106: ELSE
107: RETURN NULL;
108: END IF;

Line 110: IF NVL(p_record.SHIPPING_METHOD_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 =('SHIPPING_METHOD_CODE') THEN
110: IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
111: RETURN p_record.SHIPPING_METHOD_CODE;
112: ELSE
113: RETURN NULL;
114: END IF;

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

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

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

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

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

137: IS
138: BEGIN
139:
140: IF p_attr_code =('ACCOUNTING_CREDIT_METHOD_CODE') THEN
141: IF NVL(p_record.ACCOUNTING_CREDIT_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
142: RETURN to_date(p_record.ACCOUNTING_CREDIT_METHOD_CODE,'RRRR/MM/DD HH24:MI:SS');
143: ELSE
144: RETURN NULL;
145: END IF;

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

143: ELSE
144: RETURN NULL;
145: END IF;
146: ELSIF p_attr_code =('ACCOUNTING_RULE_ID') THEN
147: IF NVL(p_record.ACCOUNTING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
148: RETURN to_date(p_record.ACCOUNTING_RULE_ID,'RRRR/MM/DD HH24:MI:SS');
149: ELSE
150: RETURN NULL;
151: END IF;

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

149: ELSE
150: RETURN NULL;
151: END IF;
152: ELSIF p_attr_code =('AGREEMENT_TYPE_CODE') THEN
153: IF NVL(p_record.AGREEMENT_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
154: RETURN to_date(p_record.AGREEMENT_TYPE_CODE,'RRRR/MM/DD HH24:MI:SS');
155: ELSE
156: RETURN NULL;
157: END IF;

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

155: ELSE
156: RETURN NULL;
157: END IF;
158: ELSIF p_attr_code =('DEMAND_CLASS_CODE') THEN
159: IF NVL(p_record.DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
160: RETURN to_date(p_record.DEMAND_CLASS_CODE,'RRRR/MM/DD HH24:MI:SS');
161: ELSE
162: RETURN NULL;
163: END IF;

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

161: ELSE
162: RETURN NULL;
163: END IF;
164: ELSIF p_attr_code =('FOB_POINT_CODE') THEN
165: IF NVL(p_record.FOB_POINT_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
166: RETURN to_date(p_record.FOB_POINT_CODE,'RRRR/MM/DD HH24:MI:SS');
167: ELSE
168: RETURN NULL;
169: END IF;

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

167: ELSE
168: RETURN NULL;
169: END IF;
170: ELSIF p_attr_code =('FREIGHT_TERMS_CODE') THEN
171: IF NVL(p_record.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
172: RETURN to_date(p_record.FREIGHT_TERMS_CODE,'RRRR/MM/DD HH24:MI:SS');
173: ELSE
174: RETURN NULL;
175: END IF;

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

173: ELSE
174: RETURN NULL;
175: END IF;
176: ELSIF p_attr_code =('INVOICING_CREDIT_METHOD_CODE') THEN
177: IF NVL(p_record.INVOICING_CREDIT_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
178: RETURN to_date(p_record.INVOICING_CREDIT_METHOD_CODE,'RRRR/MM/DD HH24:MI:SS');
179: ELSE
180: RETURN NULL;
181: END IF;

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

179: ELSE
180: RETURN NULL;
181: END IF;
182: ELSIF p_attr_code =('INVOICING_RULE_ID') THEN
183: IF NVL(p_record.INVOICING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
184: RETURN to_date(p_record.INVOICING_RULE_ID,'RRRR/MM/DD HH24:MI:SS');
185: ELSE
186: RETURN NULL;
187: END IF;

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

185: ELSE
186: RETURN NULL;
187: END IF;
188: ELSIF p_attr_code =('LINE_TRXN_CATEGORY_CODE') THEN
189: IF NVL(p_record.ORDER_CATEGORY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
190: RETURN to_date(p_record.ORDER_CATEGORY_CODE,'RRRR/MM/DD HH24:MI:SS');
191: ELSE
192: RETURN NULL;
193: END IF;

Line 195: IF NVL(p_record.LINE_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

191: ELSE
192: RETURN NULL;
193: END IF;
194: ELSIF p_attr_code =('LINE_TYPE_ID') THEN
195: IF NVL(p_record.LINE_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
196: RETURN to_date(p_record.LINE_TYPE_ID,'RRRR/MM/DD HH24:MI:SS');
197: ELSE
198: RETURN NULL;
199: END IF;

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

197: ELSE
198: RETURN NULL;
199: END IF;
200: ELSIF p_attr_code =('PRICE_LIST_ID') THEN
201: IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
202: RETURN to_date(p_record.PRICE_LIST_ID,'RRRR/MM/DD HH24:MI:SS');
203: ELSE
204: RETURN NULL;
205: END IF;

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

203: ELSE
204: RETURN NULL;
205: END IF;
206: ELSIF p_attr_code =('SHIPMENT_PRIORITY_CODE') THEN
207: IF NVL(p_record.SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
208: RETURN to_date(p_record.SHIPMENT_PRIORITY_CODE,'RRRR/MM/DD HH24:MI:SS');
209: ELSE
210: RETURN NULL;
211: END IF;

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

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

Line 219: IF NVL(p_record.SHIP_FROM_ORG_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 =('SHIP_FROM_ORG_ID') THEN
219: IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
220: RETURN to_date(p_record.SHIP_FROM_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
221: ELSE
222: RETURN NULL;
223: END IF;

Line 225: IF NVL(p_record.SHIP_SOURCE_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 =('SOURCE_TYPE_CODE') THEN
225: IF NVL(p_record.SHIP_SOURCE_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
226: RETURN to_date(p_record.SHIP_SOURCE_TYPE_CODE,'RRRR/MM/DD HH24:MI:SS');
227: ELSE
228: RETURN NULL;
229: END IF;

Line 256: IF (NVL(p_LINE_TYPE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)

252: WHERE LINE_TYPE_ID = p_LINE_TYPE_ID
253: ;
254: BEGIN
255:
256: IF (NVL(p_LINE_TYPE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
257: THEN
258: RETURN 0 ;
259: ELSIF (NVL(g_cached_record.LINE_TYPE_ID,FND_API.G_MISS_NUM) <> p_LINE_TYPE_ID)
260: THEN

Line 259: ELSIF (NVL(g_cached_record.LINE_TYPE_ID,FND_API.G_MISS_NUM) <> p_LINE_TYPE_ID)

255:
256: IF (NVL(p_LINE_TYPE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
257: THEN
258: RETURN 0 ;
259: ELSIF (NVL(g_cached_record.LINE_TYPE_ID,FND_API.G_MISS_NUM) <> p_LINE_TYPE_ID)
260: THEN
261: Clear_LINE_TYPE_Cache;
262: Open cache;
263: FETCH cache into g_cached_record;