DBA Data[Home] [Help]

APPS.BOM_DEFAULT_OP_NETWORK dependencies on FND_API

Line 90: IF p_op_network_rec.attribute_category =FND_API.G_MISS_CHAR THEN

86:
87: -- In the future call Flex APIs for defaults
88: x_op_network_rec := p_op_network_rec;
89:
90: IF p_op_network_rec.attribute_category =FND_API.G_MISS_CHAR THEN
91: x_op_network_rec.attribute_category := NULL;
92: END IF;
93:
94: IF p_op_network_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 94: IF p_op_network_rec.attribute2 = FND_API.G_MISS_CHAR THEN

90: IF p_op_network_rec.attribute_category =FND_API.G_MISS_CHAR THEN
91: x_op_network_rec.attribute_category := NULL;
92: END IF;
93:
94: IF p_op_network_rec.attribute2 = FND_API.G_MISS_CHAR THEN
95: x_op_network_rec.attribute2 := NULL;
96: END IF;
97:
98: IF p_op_network_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 98: IF p_op_network_rec.attribute3 = FND_API.G_MISS_CHAR THEN

94: IF p_op_network_rec.attribute2 = FND_API.G_MISS_CHAR THEN
95: x_op_network_rec.attribute2 := NULL;
96: END IF;
97:
98: IF p_op_network_rec.attribute3 = FND_API.G_MISS_CHAR THEN
99: x_op_network_rec.attribute3 := NULL;
100: END IF;
101:
102: IF p_op_network_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 102: IF p_op_network_rec.attribute4 = FND_API.G_MISS_CHAR THEN

98: IF p_op_network_rec.attribute3 = FND_API.G_MISS_CHAR THEN
99: x_op_network_rec.attribute3 := NULL;
100: END IF;
101:
102: IF p_op_network_rec.attribute4 = FND_API.G_MISS_CHAR THEN
103: x_op_network_rec.attribute4 := NULL;
104: END IF;
105:
106: IF p_op_network_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 106: IF p_op_network_rec.attribute5 = FND_API.G_MISS_CHAR THEN

102: IF p_op_network_rec.attribute4 = FND_API.G_MISS_CHAR THEN
103: x_op_network_rec.attribute4 := NULL;
104: END IF;
105:
106: IF p_op_network_rec.attribute5 = FND_API.G_MISS_CHAR THEN
107: x_op_network_rec.attribute5 := NULL;
108: END IF;
109:
110: IF p_op_network_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 110: IF p_op_network_rec.attribute7 = FND_API.G_MISS_CHAR THEN

106: IF p_op_network_rec.attribute5 = FND_API.G_MISS_CHAR THEN
107: x_op_network_rec.attribute5 := NULL;
108: END IF;
109:
110: IF p_op_network_rec.attribute7 = FND_API.G_MISS_CHAR THEN
111: x_op_network_rec.attribute7 := NULL;
112: END IF;
113:
114: IF p_op_network_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 114: IF p_op_network_rec.attribute8 = FND_API.G_MISS_CHAR THEN

110: IF p_op_network_rec.attribute7 = FND_API.G_MISS_CHAR THEN
111: x_op_network_rec.attribute7 := NULL;
112: END IF;
113:
114: IF p_op_network_rec.attribute8 = FND_API.G_MISS_CHAR THEN
115: x_op_network_rec.attribute8 := NULL;
116: END IF;
117:
118: IF p_op_network_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 118: IF p_op_network_rec.attribute9 = FND_API.G_MISS_CHAR THEN

114: IF p_op_network_rec.attribute8 = FND_API.G_MISS_CHAR THEN
115: x_op_network_rec.attribute8 := NULL;
116: END IF;
117:
118: IF p_op_network_rec.attribute9 = FND_API.G_MISS_CHAR THEN
119: x_op_network_rec.attribute9 := NULL;
120: END IF;
121:
122: IF p_op_network_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 122: IF p_op_network_rec.attribute11 = FND_API.G_MISS_CHAR THEN

118: IF p_op_network_rec.attribute9 = FND_API.G_MISS_CHAR THEN
119: x_op_network_rec.attribute9 := NULL;
120: END IF;
121:
122: IF p_op_network_rec.attribute11 = FND_API.G_MISS_CHAR THEN
123: x_op_network_rec.attribute11 := NULL;
124: END IF;
125:
126: IF p_op_network_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 126: IF p_op_network_rec.attribute12 = FND_API.G_MISS_CHAR THEN

122: IF p_op_network_rec.attribute11 = FND_API.G_MISS_CHAR THEN
123: x_op_network_rec.attribute11 := NULL;
124: END IF;
125:
126: IF p_op_network_rec.attribute12 = FND_API.G_MISS_CHAR THEN
127: x_op_network_rec.attribute12 := NULL;
128: END IF;
129:
130: IF p_op_network_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 130: IF p_op_network_rec.attribute13 = FND_API.G_MISS_CHAR THEN

126: IF p_op_network_rec.attribute12 = FND_API.G_MISS_CHAR THEN
127: x_op_network_rec.attribute12 := NULL;
128: END IF;
129:
130: IF p_op_network_rec.attribute13 = FND_API.G_MISS_CHAR THEN
131: x_op_network_rec.attribute13 := NULL;
132: END IF;
133:
134: IF p_op_network_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 134: IF p_op_network_rec.attribute14 = FND_API.G_MISS_CHAR THEN

130: IF p_op_network_rec.attribute13 = FND_API.G_MISS_CHAR THEN
131: x_op_network_rec.attribute13 := NULL;
132: END IF;
133:
134: IF p_op_network_rec.attribute14 = FND_API.G_MISS_CHAR THEN
135: x_op_network_rec.attribute14 := NULL;
136: END IF;
137:
138: IF p_op_network_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 138: IF p_op_network_rec.attribute15 = FND_API.G_MISS_CHAR THEN

134: IF p_op_network_rec.attribute14 = FND_API.G_MISS_CHAR THEN
135: x_op_network_rec.attribute14 := NULL;
136: END IF;
137:
138: IF p_op_network_rec.attribute15 = FND_API.G_MISS_CHAR THEN
139: x_op_network_rec.attribute15 := NULL;
140: END IF;
141:
142: IF p_op_network_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 142: IF p_op_network_rec.attribute1 = FND_API.G_MISS_CHAR THEN

138: IF p_op_network_rec.attribute15 = FND_API.G_MISS_CHAR THEN
139: x_op_network_rec.attribute15 := NULL;
140: END IF;
141:
142: IF p_op_network_rec.attribute1 = FND_API.G_MISS_CHAR THEN
143: x_op_network_rec.attribute1 := NULL;
144: END IF;
145:
146: IF p_op_network_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 146: IF p_op_network_rec.attribute6 = FND_API.G_MISS_CHAR THEN

142: IF p_op_network_rec.attribute1 = FND_API.G_MISS_CHAR THEN
143: x_op_network_rec.attribute1 := NULL;
144: END IF;
145:
146: IF p_op_network_rec.attribute6 = FND_API.G_MISS_CHAR THEN
147: x_op_network_rec.attribute6 := NULL;
148: END IF;
149:
150: IF p_op_network_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 150: IF p_op_network_rec.attribute10 = FND_API.G_MISS_CHAR THEN

146: IF p_op_network_rec.attribute6 = FND_API.G_MISS_CHAR THEN
147: x_op_network_rec.attribute6 := NULL;
148: END IF;
149:
150: IF p_op_network_rec.attribute10 = FND_API.G_MISS_CHAR THEN
151: x_op_network_rec.attribute10 := NULL;
152: END IF;
153:
154: END Get_Flex_Op_Network;

Line 184: x_return_status := FND_API.G_RET_STS_SUCCESS;

180: BEGIN
181:
182: x_op_network_rec := p_op_network_rec;
183: x_op_network_unexp_rec := p_op_network_unexp_rec;
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:
186: IF x_op_network_rec.connection_type= FND_API.G_MISS_NUM
187: OR x_op_network_rec.connection_type IS NULL
188: THEN

Line 186: IF x_op_network_rec.connection_type= FND_API.G_MISS_NUM

182: x_op_network_rec := p_op_network_rec;
183: x_op_network_unexp_rec := p_op_network_unexp_rec;
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:
186: IF x_op_network_rec.connection_type= FND_API.G_MISS_NUM
187: OR x_op_network_rec.connection_type IS NULL
188: THEN
189: x_op_network_rec.connection_type := 1;
190: END IF;

Line 194: x_op_network_rec.planning_percent = FND_API.G_MISS_NUM)

190: END IF;
191:
192: IF x_op_network_rec.connection_type= 1 AND
193: ( x_op_network_rec.planning_percent IS NULL OR
194: x_op_network_rec.planning_percent = FND_API.G_MISS_NUM)
195: THEN
196: x_op_network_rec.planning_percent := 100;
197: END IF;
198:

Line 200: IF x_op_network_rec.From_X_Coordinate = FND_API.G_MISS_NUM

196: x_op_network_rec.planning_percent := 100;
197: END IF;
198:
199:
200: IF x_op_network_rec.From_X_Coordinate = FND_API.G_MISS_NUM
201: OR x_op_network_rec.From_X_Coordinate IS NULL
202: THEN
203:
204: -- Modified for Eam

Line 212: IF x_op_network_rec.To_X_Coordinate = FND_API.G_MISS_NUM

208: x_op_network_unexp_rec.from_op_seq_id) ;
209:
210: END IF;
211:
212: IF x_op_network_rec.To_X_Coordinate = FND_API.G_MISS_NUM
213: OR x_op_network_rec.To_X_Coordinate IS NULL
214: THEN
215: -- Modified for Eam
216: -- x_op_network_rec.To_X_Coordinate := 0;

Line 223: IF x_op_network_rec.From_Y_Coordinate = FND_API.G_MISS_NUM

219: x_op_network_unexp_rec.to_op_seq_id) ;
220:
221: END IF;
222:
223: IF x_op_network_rec.From_Y_Coordinate = FND_API.G_MISS_NUM
224: OR x_op_network_rec.From_Y_Coordinate IS NULL
225: THEN
226: -- Modified for Eam
227: -- x_op_network_rec.From_Y_Coordinate := 0;

Line 234: IF x_op_network_rec.To_Y_Coordinate = FND_API.G_MISS_NUM

230: x_op_network_unexp_rec.from_op_seq_id) ;
231:
232: END IF;
233:
234: IF x_op_network_rec.To_Y_Coordinate = FND_API.G_MISS_NUM
235: OR x_op_network_rec.To_Y_Coordinate IS NULL
236: THEN
237: -- Modified for Eam
238: -- x_op_network_rec.To_Y_Coordinate := 0;

Line 268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

264: , x_mesg_token_tbl => l_mesg_token_tbl
265: ) ;
266:
267: -- Return the status and message table.
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
269: x_mesg_token_tbl := l_mesg_token_tbl ;
270:
271:
272: END Attribute_Defaulting;

Line 305: x_return_status := FND_API.G_RET_STS_SUCCESS;

301:
302:
303: x_op_network_rec := p_op_network_rec;
304: x_op_network_unexp_rec := p_op_network_unexp_rec;
305: x_return_status := FND_API.G_RET_STS_SUCCESS;
306:
307: -- operation type will be defaulted for validations
308: -- this value indicate whether Lot, Process or Line Op
309: IF x_op_network_rec.operation_type IS NULL OR

Line 310: x_op_network_rec.operation_type = FND_API.G_MISS_NUM

306:
307: -- operation type will be defaulted for validations
308: -- this value indicate whether Lot, Process or Line Op
309: IF x_op_network_rec.operation_type IS NULL OR
310: x_op_network_rec.operation_type = FND_API.G_MISS_NUM
311: THEN
312: x_op_network_rec.operation_type := 1 ;
313: END IF ;
314:

Line 363: IF x_op_network_rec.original_system_reference = FND_API.G_MISS_CHAR

359: END IF ; -- eAM Operation Network Defaulting
360:
361:
362: -- Followings are added to populate null to columns by MK 05/01.
363: IF x_op_network_rec.original_system_reference = FND_API.G_MISS_CHAR
364: THEN
365: x_op_network_rec.original_system_reference := NULL ;
366: END IF;
367:

Line 369: IF x_op_network_unexp_rec.new_from_op_seq_id = FND_API.G_MISS_NUM

365: x_op_network_rec.original_system_reference := NULL ;
366: END IF;
367:
368:
369: IF x_op_network_unexp_rec.new_from_op_seq_id = FND_API.G_MISS_NUM
370: THEN
371: x_op_network_unexp_rec.new_from_op_seq_id := NULL ;
372: END IF ;
373:

Line 374: IF x_op_network_rec.new_from_op_seq_number = FND_API.G_MISS_NUM

370: THEN
371: x_op_network_unexp_rec.new_from_op_seq_id := NULL ;
372: END IF ;
373:
374: IF x_op_network_rec.new_from_op_seq_number = FND_API.G_MISS_NUM
375: THEN
376: x_op_network_rec.new_from_op_seq_number := NULL ;
377: END IF ;
378:

Line 379: IF x_op_network_rec.new_from_start_effective_date = FND_API.G_MISS_DATE

375: THEN
376: x_op_network_rec.new_from_op_seq_number := NULL ;
377: END IF ;
378:
379: IF x_op_network_rec.new_from_start_effective_date = FND_API.G_MISS_DATE
380: THEN
381: x_op_network_rec.new_from_start_effective_date := NULL ;
382: END IF ;
383:

Line 385: IF x_op_network_unexp_rec.new_to_op_seq_id = FND_API.G_MISS_NUM

381: x_op_network_rec.new_from_start_effective_date := NULL ;
382: END IF ;
383:
384:
385: IF x_op_network_unexp_rec.new_to_op_seq_id = FND_API.G_MISS_NUM
386: THEN
387: x_op_network_unexp_rec.new_to_op_seq_id := NULL ;
388:
389: END IF ;

Line 391: IF x_op_network_rec.new_to_op_seq_number = FND_API.G_MISS_NUM

387: x_op_network_unexp_rec.new_to_op_seq_id := NULL ;
388:
389: END IF ;
390:
391: IF x_op_network_rec.new_to_op_seq_number = FND_API.G_MISS_NUM
392: THEN
393: x_op_network_rec.new_to_op_seq_number := NULL ;
394: END IF ;
395:

Line 396: IF x_op_network_rec.new_to_start_effective_date = FND_API.G_MISS_DATE

392: THEN
393: x_op_network_rec.new_to_op_seq_number := NULL ;
394: END IF ;
395:
396: IF x_op_network_rec.new_to_start_effective_date = FND_API.G_MISS_DATE
397: THEN
398: x_op_network_rec.new_to_start_effective_date := NULL ;
399: END IF ;
400:

Line 403: IF x_op_network_rec.attribute_category = FND_API.G_MISS_CHAR THEN

399: END IF ;
400:
401:
402: -- FlexFields
403: IF x_op_network_rec.attribute_category = FND_API.G_MISS_CHAR THEN
404: x_op_network_rec.attribute_category := NULL ;
405: END IF;
406:
407: IF x_op_network_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 407: IF x_op_network_rec.attribute1 = FND_API.G_MISS_CHAR THEN

403: IF x_op_network_rec.attribute_category = FND_API.G_MISS_CHAR THEN
404: x_op_network_rec.attribute_category := NULL ;
405: END IF;
406:
407: IF x_op_network_rec.attribute1 = FND_API.G_MISS_CHAR THEN
408: x_op_network_rec.attribute1 := NULL ;
409: END IF;
410:
411: IF x_op_network_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 411: IF x_op_network_rec.attribute2 = FND_API.G_MISS_CHAR THEN

407: IF x_op_network_rec.attribute1 = FND_API.G_MISS_CHAR THEN
408: x_op_network_rec.attribute1 := NULL ;
409: END IF;
410:
411: IF x_op_network_rec.attribute2 = FND_API.G_MISS_CHAR THEN
412: x_op_network_rec.attribute2 := NULL ;
413: END IF;
414:
415: IF x_op_network_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 415: IF x_op_network_rec.attribute3 = FND_API.G_MISS_CHAR THEN

411: IF x_op_network_rec.attribute2 = FND_API.G_MISS_CHAR THEN
412: x_op_network_rec.attribute2 := NULL ;
413: END IF;
414:
415: IF x_op_network_rec.attribute3 = FND_API.G_MISS_CHAR THEN
416: x_op_network_rec.attribute3 := NULL ;
417: END IF;
418:
419: IF x_op_network_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 419: IF x_op_network_rec.attribute4 = FND_API.G_MISS_CHAR THEN

415: IF x_op_network_rec.attribute3 = FND_API.G_MISS_CHAR THEN
416: x_op_network_rec.attribute3 := NULL ;
417: END IF;
418:
419: IF x_op_network_rec.attribute4 = FND_API.G_MISS_CHAR THEN
420: x_op_network_rec.attribute4 := NULL ;
421: END IF;
422:
423: IF x_op_network_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 423: IF x_op_network_rec.attribute5 = FND_API.G_MISS_CHAR THEN

419: IF x_op_network_rec.attribute4 = FND_API.G_MISS_CHAR THEN
420: x_op_network_rec.attribute4 := NULL ;
421: END IF;
422:
423: IF x_op_network_rec.attribute5 = FND_API.G_MISS_CHAR THEN
424: x_op_network_rec.attribute5 := NULL ;
425: END IF;
426:
427: IF x_op_network_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 427: IF x_op_network_rec.attribute6 = FND_API.G_MISS_CHAR THEN

423: IF x_op_network_rec.attribute5 = FND_API.G_MISS_CHAR THEN
424: x_op_network_rec.attribute5 := NULL ;
425: END IF;
426:
427: IF x_op_network_rec.attribute6 = FND_API.G_MISS_CHAR THEN
428: x_op_network_rec.attribute6 := NULL ;
429: END IF;
430:
431: IF x_op_network_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 431: IF x_op_network_rec.attribute7 = FND_API.G_MISS_CHAR THEN

427: IF x_op_network_rec.attribute6 = FND_API.G_MISS_CHAR THEN
428: x_op_network_rec.attribute6 := NULL ;
429: END IF;
430:
431: IF x_op_network_rec.attribute7 = FND_API.G_MISS_CHAR THEN
432: x_op_network_rec.attribute7 := NULL ;
433: END IF;
434:
435: IF x_op_network_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 435: IF x_op_network_rec.attribute8 = FND_API.G_MISS_CHAR THEN

431: IF x_op_network_rec.attribute7 = FND_API.G_MISS_CHAR THEN
432: x_op_network_rec.attribute7 := NULL ;
433: END IF;
434:
435: IF x_op_network_rec.attribute8 = FND_API.G_MISS_CHAR THEN
436: x_op_network_rec.attribute8 := NULL ;
437: END IF;
438:
439: IF x_op_network_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 439: IF x_op_network_rec.attribute9 = FND_API.G_MISS_CHAR THEN

435: IF x_op_network_rec.attribute8 = FND_API.G_MISS_CHAR THEN
436: x_op_network_rec.attribute8 := NULL ;
437: END IF;
438:
439: IF x_op_network_rec.attribute9 = FND_API.G_MISS_CHAR THEN
440: x_op_network_rec.attribute9 := NULL ;
441: END IF;
442:
443: IF x_op_network_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 443: IF x_op_network_rec.attribute10 = FND_API.G_MISS_CHAR THEN

439: IF x_op_network_rec.attribute9 = FND_API.G_MISS_CHAR THEN
440: x_op_network_rec.attribute9 := NULL ;
441: END IF;
442:
443: IF x_op_network_rec.attribute10 = FND_API.G_MISS_CHAR THEN
444: x_op_network_rec.attribute10 := NULL ;
445: END IF;
446:
447: IF x_op_network_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 447: IF x_op_network_rec.attribute11 = FND_API.G_MISS_CHAR THEN

443: IF x_op_network_rec.attribute10 = FND_API.G_MISS_CHAR THEN
444: x_op_network_rec.attribute10 := NULL ;
445: END IF;
446:
447: IF x_op_network_rec.attribute11 = FND_API.G_MISS_CHAR THEN
448: x_op_network_rec.attribute11 := NULL ;
449: END IF;
450:
451: IF x_op_network_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 451: IF x_op_network_rec.attribute12 = FND_API.G_MISS_CHAR THEN

447: IF x_op_network_rec.attribute11 = FND_API.G_MISS_CHAR THEN
448: x_op_network_rec.attribute11 := NULL ;
449: END IF;
450:
451: IF x_op_network_rec.attribute12 = FND_API.G_MISS_CHAR THEN
452: x_op_network_rec.attribute12 := NULL ;
453: END IF;
454:
455: IF x_op_network_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 455: IF x_op_network_rec.attribute13 = FND_API.G_MISS_CHAR THEN

451: IF x_op_network_rec.attribute12 = FND_API.G_MISS_CHAR THEN
452: x_op_network_rec.attribute12 := NULL ;
453: END IF;
454:
455: IF x_op_network_rec.attribute13 = FND_API.G_MISS_CHAR THEN
456: x_op_network_rec.attribute13 := NULL ;
457: END IF;
458:
459: IF x_op_network_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 459: IF x_op_network_rec.attribute14 = FND_API.G_MISS_CHAR THEN

455: IF x_op_network_rec.attribute13 = FND_API.G_MISS_CHAR THEN
456: x_op_network_rec.attribute13 := NULL ;
457: END IF;
458:
459: IF x_op_network_rec.attribute14 = FND_API.G_MISS_CHAR THEN
460: x_op_network_rec.attribute14 := NULL ;
461: END IF;
462:
463: IF x_op_network_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 463: IF x_op_network_rec.attribute15 = FND_API.G_MISS_CHAR THEN

459: IF x_op_network_rec.attribute14 = FND_API.G_MISS_CHAR THEN
460: x_op_network_rec.attribute14 := NULL ;
461: END IF;
462:
463: IF x_op_network_rec.attribute15 = FND_API.G_MISS_CHAR THEN
464: x_op_network_rec.attribute15 := NULL ;
465: END IF;
466:
467: -- Return the status and message table.

Line 489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

485: , x_mesg_token_tbl => l_mesg_token_tbl
486: ) ;
487:
488: -- Return the status and message table.
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
490: x_mesg_token_tbl := l_mesg_token_tbl ;
491:
492:
493:

Line 526: p_op_network_rec.Connection_Type = FND_API.G_MISS_NUM

522: x_op_network_rec := p_op_network_rec;
523: x_op_network_unexp_rec := p_op_network_unexp_rec;
524:
525: IF p_op_network_rec.Connection_Type IS NULL OR
526: p_op_network_rec.Connection_Type = FND_API.G_MISS_NUM
527: THEN
528:
529: x_op_network_rec.Connection_Type:=
530: p_old_op_network_rec.Connection_Type ;

Line 535: p_op_network_rec.Planning_Percent = FND_API.G_MISS_NUM

531:
532: END IF;
533:
534: IF p_op_network_rec.Planning_Percent IS NULL OR
535: p_op_network_rec.Planning_Percent = FND_API.G_MISS_NUM
536: THEN
537:
538: x_op_network_rec.Planning_Percent :=
539: p_old_op_network_rec.Planning_Percent ;

Line 544: p_op_network_rec.From_X_Coordinate = FND_API.G_MISS_NUM

540:
541: END IF;
542:
543: IF p_op_network_rec.From_X_Coordinate IS NULL OR
544: p_op_network_rec.From_X_Coordinate = FND_API.G_MISS_NUM
545: THEN
546:
547: x_op_network_rec.From_X_Coordinate :=
548: p_old_op_network_rec.From_X_Coordinate ;

Line 553: p_op_network_rec.From_Y_Coordinate = FND_API.G_MISS_NUM

549:
550: END IF;
551:
552: IF p_op_network_rec.From_Y_Coordinate IS NULL OR
553: p_op_network_rec.From_Y_Coordinate = FND_API.G_MISS_NUM
554: THEN
555:
556: x_op_network_rec.From_Y_Coordinate :=
557: p_old_op_network_rec.From_Y_Coordinate ;

Line 562: p_op_network_rec.To_X_Coordinate = FND_API.G_MISS_NUM

558:
559: END IF;
560:
561: IF p_op_network_rec.To_X_Coordinate IS NULL OR
562: p_op_network_rec.To_X_Coordinate = FND_API.G_MISS_NUM
563: THEN
564:
565: x_op_network_rec.To_X_Coordinate :=
566: p_old_op_network_rec.To_X_Coordinate ;

Line 571: p_op_network_rec.To_Y_Coordinate = FND_API.G_MISS_NUM

567:
568: END IF;
569:
570: IF p_op_network_rec.To_Y_Coordinate IS NULL OR
571: p_op_network_rec.To_Y_Coordinate = FND_API.G_MISS_NUM
572: THEN
573:
574: x_op_network_rec.To_Y_Coordinate :=
575: p_old_op_network_rec.To_Y_Coordinate ;

Line 581: p_op_network_rec.attribute_category = FND_API.G_MISS_CHAR

577: END IF;
578:
579:
580: IF p_op_network_rec.attribute_category IS NULL OR
581: p_op_network_rec.attribute_category = FND_API.G_MISS_CHAR
582: THEN
583: x_op_network_rec.attribute_category :=
584: p_old_op_network_rec.attribute_category;
585:

Line 588: IF p_op_network_rec.attribute1 = FND_API.G_MISS_CHAR OR

584: p_old_op_network_rec.attribute_category;
585:
586: END IF;
587:
588: IF p_op_network_rec.attribute1 = FND_API.G_MISS_CHAR OR
589: p_op_network_rec.attribute1 IS NULL
590: THEN
591: x_op_network_rec.attribute1 :=
592: p_old_op_network_rec.attribute1;

Line 595: IF p_op_network_rec.attribute2 = FND_API.G_MISS_CHAR OR

591: x_op_network_rec.attribute1 :=
592: p_old_op_network_rec.attribute1;
593: END IF;
594:
595: IF p_op_network_rec.attribute2 = FND_API.G_MISS_CHAR OR
596: p_op_network_rec.attribute2 IS NULL
597: THEN
598: x_op_network_rec.attribute2 :=
599: p_old_op_network_rec.attribute2;

Line 602: IF p_op_network_rec.attribute3 = FND_API.G_MISS_CHAR OR

598: x_op_network_rec.attribute2 :=
599: p_old_op_network_rec.attribute2;
600: END IF;
601:
602: IF p_op_network_rec.attribute3 = FND_API.G_MISS_CHAR OR
603: p_op_network_rec.attribute3 IS NULL
604: THEN
605: x_op_network_rec.attribute3 :=
606: p_old_op_network_rec.attribute3;

Line 609: IF p_op_network_rec.attribute4 = FND_API.G_MISS_CHAR OR

605: x_op_network_rec.attribute3 :=
606: p_old_op_network_rec.attribute3;
607: END IF;
608:
609: IF p_op_network_rec.attribute4 = FND_API.G_MISS_CHAR OR
610: p_op_network_rec.attribute4 IS NULL
611: THEN
612: x_op_network_rec.attribute4 :=
613: p_old_op_network_rec.attribute4;

Line 616: IF p_op_network_rec.attribute5 = FND_API.G_MISS_CHAR OR

612: x_op_network_rec.attribute4 :=
613: p_old_op_network_rec.attribute4;
614: END IF;
615:
616: IF p_op_network_rec.attribute5 = FND_API.G_MISS_CHAR OR
617: p_op_network_rec.attribute5 IS NULL
618: THEN
619: x_op_network_rec.attribute5 :=
620: p_old_op_network_rec.attribute5;

Line 623: IF p_op_network_rec.attribute6 = FND_API.G_MISS_CHAR OR

619: x_op_network_rec.attribute5 :=
620: p_old_op_network_rec.attribute5;
621: END IF;
622:
623: IF p_op_network_rec.attribute6 = FND_API.G_MISS_CHAR OR
624: p_op_network_rec.attribute6 IS NULL
625: THEN
626: x_op_network_rec.attribute6 :=
627: p_old_op_network_rec.attribute6;

Line 630: IF p_op_network_rec.attribute7 = FND_API.G_MISS_CHAR OR

626: x_op_network_rec.attribute6 :=
627: p_old_op_network_rec.attribute6;
628: END IF;
629:
630: IF p_op_network_rec.attribute7 = FND_API.G_MISS_CHAR OR
631: p_op_network_rec.attribute7 IS NULL
632: THEN
633: x_op_network_rec.attribute7 :=
634: p_old_op_network_rec.attribute7;

Line 637: IF p_op_network_rec.attribute8 = FND_API.G_MISS_CHAR OR

633: x_op_network_rec.attribute7 :=
634: p_old_op_network_rec.attribute7;
635: END IF;
636:
637: IF p_op_network_rec.attribute8 = FND_API.G_MISS_CHAR OR
638: p_op_network_rec.attribute8 IS NULL
639: THEN
640: x_op_network_rec.attribute8 :=
641: p_old_op_network_rec.attribute8;

Line 644: IF p_op_network_rec.attribute9 = FND_API.G_MISS_CHAR OR

640: x_op_network_rec.attribute8 :=
641: p_old_op_network_rec.attribute8;
642: END IF;
643:
644: IF p_op_network_rec.attribute9 = FND_API.G_MISS_CHAR OR
645: p_op_network_rec.attribute9 IS NULL
646: THEN
647: x_op_network_rec.attribute9 :=
648: p_old_op_network_rec.attribute9;

Line 651: IF p_op_network_rec.attribute10 = FND_API.G_MISS_CHAR OR

647: x_op_network_rec.attribute9 :=
648: p_old_op_network_rec.attribute9;
649: END IF;
650:
651: IF p_op_network_rec.attribute10 = FND_API.G_MISS_CHAR OR
652: p_op_network_rec.attribute10 IS NULL
653: THEN
654: x_op_network_rec.attribute10 :=
655: p_old_op_network_rec.attribute10;

Line 658: IF p_op_network_rec.attribute11 = FND_API.G_MISS_CHAR OR

654: x_op_network_rec.attribute10 :=
655: p_old_op_network_rec.attribute10;
656: END IF;
657:
658: IF p_op_network_rec.attribute11 = FND_API.G_MISS_CHAR OR
659: p_op_network_rec.attribute11 IS NULL
660: THEN
661: x_op_network_rec.attribute11 :=
662: p_old_op_network_rec.attribute11;

Line 665: IF p_op_network_rec.attribute12 = FND_API.G_MISS_CHAR OR

661: x_op_network_rec.attribute11 :=
662: p_old_op_network_rec.attribute11;
663: END IF;
664:
665: IF p_op_network_rec.attribute12 = FND_API.G_MISS_CHAR OR
666: p_op_network_rec.attribute12 IS NULL
667: THEN
668: x_op_network_rec.attribute12 :=
669: p_old_op_network_rec.attribute12;

Line 672: IF p_op_network_rec.attribute13 = FND_API.G_MISS_CHAR OR

668: x_op_network_rec.attribute12 :=
669: p_old_op_network_rec.attribute12;
670: END IF;
671:
672: IF p_op_network_rec.attribute13 = FND_API.G_MISS_CHAR OR
673: p_op_network_rec.attribute13 IS NULL
674: THEN
675: x_op_network_rec.attribute13 :=
676: p_old_op_network_rec.attribute13;

Line 679: IF p_op_network_rec.attribute14 = FND_API.G_MISS_CHAR OR

675: x_op_network_rec.attribute13 :=
676: p_old_op_network_rec.attribute13;
677: END IF;
678:
679: IF p_op_network_rec.attribute14 = FND_API.G_MISS_CHAR OR
680: p_op_network_rec.attribute14 IS NULL
681: THEN
682: x_op_network_rec.attribute14 :=
683: p_old_op_network_rec.attribute14;

Line 686: IF p_op_network_rec.attribute15 = FND_API.G_MISS_CHAR OR

682: x_op_network_rec.attribute14 :=
683: p_old_op_network_rec.attribute14;
684: END IF;
685:
686: IF p_op_network_rec.attribute15 = FND_API.G_MISS_CHAR OR
687: p_op_network_rec.attribute15 IS NULL
688: THEN
689: x_op_network_rec.attribute15 :=
690: p_old_op_network_rec.attribute15;