DBA Data[Home] [Help]

APPS.ENG_DEFAULT_ECO dependencies on FND_API

Line 60: IF l_ECO_rec.attribute7 = FND_API.G_MISS_CHAR THEN

56: BEGIN
57:
58: -- In the future call Flex APIs for defaults
59:
60: IF l_ECO_rec.attribute7 = FND_API.G_MISS_CHAR THEN
61: l_ECO_rec.attribute7 := NULL;
62: END IF;
63:
64: IF l_ECO_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 64: IF l_ECO_rec.attribute8 = FND_API.G_MISS_CHAR THEN

60: IF l_ECO_rec.attribute7 = FND_API.G_MISS_CHAR THEN
61: l_ECO_rec.attribute7 := NULL;
62: END IF;
63:
64: IF l_ECO_rec.attribute8 = FND_API.G_MISS_CHAR THEN
65: l_ECO_rec.attribute8 := NULL;
66: END IF;
67:
68: IF l_ECO_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 68: IF l_ECO_rec.attribute9 = FND_API.G_MISS_CHAR THEN

64: IF l_ECO_rec.attribute8 = FND_API.G_MISS_CHAR THEN
65: l_ECO_rec.attribute8 := NULL;
66: END IF;
67:
68: IF l_ECO_rec.attribute9 = FND_API.G_MISS_CHAR THEN
69: l_ECO_rec.attribute9 := NULL;
70: END IF;
71:
72: IF l_ECO_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 72: IF l_ECO_rec.attribute10 = FND_API.G_MISS_CHAR THEN

68: IF l_ECO_rec.attribute9 = FND_API.G_MISS_CHAR THEN
69: l_ECO_rec.attribute9 := NULL;
70: END IF;
71:
72: IF l_ECO_rec.attribute10 = FND_API.G_MISS_CHAR THEN
73: l_ECO_rec.attribute10 := NULL;
74: END IF;
75:
76: IF l_ECO_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 76: IF l_ECO_rec.attribute11 = FND_API.G_MISS_CHAR THEN

72: IF l_ECO_rec.attribute10 = FND_API.G_MISS_CHAR THEN
73: l_ECO_rec.attribute10 := NULL;
74: END IF;
75:
76: IF l_ECO_rec.attribute11 = FND_API.G_MISS_CHAR THEN
77: l_ECO_rec.attribute11 := NULL;
78: END IF;
79:
80: IF l_ECO_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 80: IF l_ECO_rec.attribute12 = FND_API.G_MISS_CHAR THEN

76: IF l_ECO_rec.attribute11 = FND_API.G_MISS_CHAR THEN
77: l_ECO_rec.attribute11 := NULL;
78: END IF;
79:
80: IF l_ECO_rec.attribute12 = FND_API.G_MISS_CHAR THEN
81: l_ECO_rec.attribute12 := NULL;
82: END IF;
83:
84: IF l_ECO_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 84: IF l_ECO_rec.attribute13 = FND_API.G_MISS_CHAR THEN

80: IF l_ECO_rec.attribute12 = FND_API.G_MISS_CHAR THEN
81: l_ECO_rec.attribute12 := NULL;
82: END IF;
83:
84: IF l_ECO_rec.attribute13 = FND_API.G_MISS_CHAR THEN
85: l_ECO_rec.attribute13 := NULL;
86: END IF;
87:
88: IF l_ECO_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 88: IF l_ECO_rec.attribute14 = FND_API.G_MISS_CHAR THEN

84: IF l_ECO_rec.attribute13 = FND_API.G_MISS_CHAR THEN
85: l_ECO_rec.attribute13 := NULL;
86: END IF;
87:
88: IF l_ECO_rec.attribute14 = FND_API.G_MISS_CHAR THEN
89: l_ECO_rec.attribute14 := NULL;
90: END IF;
91:
92: IF l_ECO_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 92: IF l_ECO_rec.attribute15 = FND_API.G_MISS_CHAR THEN

88: IF l_ECO_rec.attribute14 = FND_API.G_MISS_CHAR THEN
89: l_ECO_rec.attribute14 := NULL;
90: END IF;
91:
92: IF l_ECO_rec.attribute15 = FND_API.G_MISS_CHAR THEN
93: l_ECO_rec.attribute15 := NULL;
94: END IF;
95:
96: IF l_ECO_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 96: IF l_ECO_rec.attribute_category = FND_API.G_MISS_CHAR THEN

92: IF l_ECO_rec.attribute15 = FND_API.G_MISS_CHAR THEN
93: l_ECO_rec.attribute15 := NULL;
94: END IF;
95:
96: IF l_ECO_rec.attribute_category = FND_API.G_MISS_CHAR THEN
97: l_ECO_rec.attribute_category := NULL;
98: END IF;
99:
100: IF l_ECO_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 100: IF l_ECO_rec.attribute1 = FND_API.G_MISS_CHAR THEN

96: IF l_ECO_rec.attribute_category = FND_API.G_MISS_CHAR THEN
97: l_ECO_rec.attribute_category := NULL;
98: END IF;
99:
100: IF l_ECO_rec.attribute1 = FND_API.G_MISS_CHAR THEN
101: l_ECO_rec.attribute1 := NULL;
102: END IF;
103:
104: IF l_ECO_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 104: IF l_ECO_rec.attribute2 = FND_API.G_MISS_CHAR THEN

100: IF l_ECO_rec.attribute1 = FND_API.G_MISS_CHAR THEN
101: l_ECO_rec.attribute1 := NULL;
102: END IF;
103:
104: IF l_ECO_rec.attribute2 = FND_API.G_MISS_CHAR THEN
105: l_ECO_rec.attribute2 := NULL;
106: END IF;
107:
108: IF l_ECO_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 108: IF l_ECO_rec.attribute3 = FND_API.G_MISS_CHAR THEN

104: IF l_ECO_rec.attribute2 = FND_API.G_MISS_CHAR THEN
105: l_ECO_rec.attribute2 := NULL;
106: END IF;
107:
108: IF l_ECO_rec.attribute3 = FND_API.G_MISS_CHAR THEN
109: l_ECO_rec.attribute3 := NULL;
110: END IF;
111:
112: IF l_ECO_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 112: IF l_ECO_rec.attribute4 = FND_API.G_MISS_CHAR THEN

108: IF l_ECO_rec.attribute3 = FND_API.G_MISS_CHAR THEN
109: l_ECO_rec.attribute3 := NULL;
110: END IF;
111:
112: IF l_ECO_rec.attribute4 = FND_API.G_MISS_CHAR THEN
113: l_ECO_rec.attribute4 := NULL;
114: END IF;
115:
116: IF l_ECO_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 116: IF l_ECO_rec.attribute5 = FND_API.G_MISS_CHAR THEN

112: IF l_ECO_rec.attribute4 = FND_API.G_MISS_CHAR THEN
113: l_ECO_rec.attribute4 := NULL;
114: END IF;
115:
116: IF l_ECO_rec.attribute5 = FND_API.G_MISS_CHAR THEN
117: l_ECO_rec.attribute5 := NULL;
118: END IF;
119:
120: IF l_ECO_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 120: IF l_ECO_rec.attribute6 = FND_API.G_MISS_CHAR THEN

116: IF l_ECO_rec.attribute5 = FND_API.G_MISS_CHAR THEN
117: l_ECO_rec.attribute5 := NULL;
118: END IF;
119:
120: IF l_ECO_rec.attribute6 = FND_API.G_MISS_CHAR THEN
121: l_ECO_rec.attribute6 := NULL;
122: END IF;
123:
124: x_ECO_rec := l_ECO_rec;

Line 207: IF g_ECO_rec.plm_or_erp_change='PLM' AND (g_ECO_rec.priority_code IS NULL OR g_ECO_rec.priority_code=FND_API.G_MISS_CHAR) THEN

203:
204: END IF; */
205:
206: --Bug 13721297 set default value for priority_code
207: IF g_ECO_rec.plm_or_erp_change='PLM' AND (g_ECO_rec.priority_code IS NULL OR g_ECO_rec.priority_code=FND_API.G_MISS_CHAR) THEN
208: OPEN priority_code(g_Unexp_ECO_rec.Change_Order_Type_Id);
209: fetch priority_code into l_priority_code;
210: IF priority_code%FOUND THEN
211: g_ECO_rec.priority_code :=l_priority_code.PRIORITY_CODE;

Line 216: IF g_ECO_rec.plm_or_erp_change='PLM' AND (g_ECO_rec.assignee IS NULL OR g_ECO_rec.assignee=FND_API.G_MISS_CHAR) THEN

212: END IF;
213: CLOSE priority_code;
214: END IF;
215: --Bug 13721297 set default value for assignee
216: IF g_ECO_rec.plm_or_erp_change='PLM' AND (g_ECO_rec.assignee IS NULL OR g_ECO_rec.assignee=FND_API.G_MISS_CHAR) THEN
217: OPEN assignee(g_Unexp_ECO_rec.Change_Order_Type_Id);
218: fetch assignee into l_assignee;
219: IF assignee%FOUND THEN
220: g_Unexp_ECO_rec.assignee_id :=l_assignee.default_assignee_id;

Line 261: /* IF g_unexp_eco_rec.project_id = FND_API.G_MISS_NUM

257: g_Unexp_ECO_rec.cancellation_date := SYSDATE;
258: END IF;
259: */
260:
261: /* IF g_unexp_eco_rec.project_id = FND_API.G_MISS_NUM
262: THEN
263: g_unexp_eco_rec.project_id := NULL;
264: END IF;
265:

Line 266: IF g_unexp_eco_rec.task_id = FND_API.G_MISS_NUM

262: THEN
263: g_unexp_eco_rec.project_id := NULL;
264: END IF;
265:
266: IF g_unexp_eco_rec.task_id = FND_API.G_MISS_NUM
267: THEN
268: g_unexp_eco_rec.task_id := NULL;
269: END IF;
270: */

Line 275: g_ECO_rec.hierarchy_flag = FND_API.G_MISS_NUM

271: /* Added by MK on 11/29/00 Bug #1508078
272: -- Defaulting hierarchy_flag and organization_hierarchy
273: --
274: IF g_ECO_rec.hierarchy_flag IS NULL OR
275: g_ECO_rec.hierarchy_flag = FND_API.G_MISS_NUM
276: THEN
277: g_ECO_rec.hierarchy_flag := 2 ; -- 2 : No
278: END IF;
279: */

Line 281: IF g_ECO_rec.organization_hierarchy = FND_API.G_MISS_CHAR THEN

277: g_ECO_rec.hierarchy_flag := 2 ; -- 2 : No
278: END IF;
279: */
280:
281: IF g_ECO_rec.organization_hierarchy = FND_API.G_MISS_CHAR THEN
282: g_ECO_rec.organization_hierarchy := NULL ;
283: END IF;
284:
285:

Line 287: IF g_unexp_eco_rec.change_mgmt_type_code = FND_API.G_MISS_CHAR

283: END IF;
284:
285:
286: -- Eng Change
287: IF g_unexp_eco_rec.change_mgmt_type_code = FND_API.G_MISS_CHAR
288: OR g_unexp_eco_rec.change_mgmt_type_code IS NULL
289: THEN
290: g_unexp_eco_rec.change_mgmt_type_code := Eng_Globals.G_CHANGE_ORDER ;
291: END IF;

Line 293: IF g_unexp_eco_rec.assignee_id = FND_API.G_MISS_NUM

289: THEN
290: g_unexp_eco_rec.change_mgmt_type_code := Eng_Globals.G_CHANGE_ORDER ;
291: END IF;
292:
293: IF g_unexp_eco_rec.assignee_id = FND_API.G_MISS_NUM
294: THEN
295: g_unexp_eco_rec.assignee_id := NULL;
296: END IF;
297:

Line 298: IF g_unexp_eco_rec.source_type_code = FND_API.G_MISS_CHAR

294: THEN
295: g_unexp_eco_rec.assignee_id := NULL;
296: END IF;
297:
298: IF g_unexp_eco_rec.source_type_code = FND_API.G_MISS_CHAR
299: OR g_unexp_eco_rec.source_type_code IS NULL
300: THEN
301: g_unexp_eco_rec.source_type_code := NULL ;
302: END IF;

Line 304: IF g_unexp_eco_rec.source_id = FND_API.G_MISS_NUM

300: THEN
301: g_unexp_eco_rec.source_type_code := NULL ;
302: END IF;
303:
304: IF g_unexp_eco_rec.source_id = FND_API.G_MISS_NUM
305: THEN
306: g_unexp_eco_rec.source_id := NULL;
307: END IF;
308:

Line 310: g_ECO_rec.internal_use_only = FND_API.G_MISS_NUM

306: g_unexp_eco_rec.source_id := NULL;
307: END IF;
308:
309: IF g_ECO_rec.internal_use_only IS NULL OR
310: g_ECO_rec.internal_use_only = FND_API.G_MISS_NUM
311: THEN
312: g_ECO_rec.internal_use_only := 1 ; -- 1 : Yes
313: END IF;
314:

Line 315: IF g_ECO_rec.need_by_date = FND_API.G_MISS_DATE THEN

311: THEN
312: g_ECO_rec.internal_use_only := 1 ; -- 1 : Yes
313: END IF;
314:
315: IF g_ECO_rec.need_by_date = FND_API.G_MISS_DATE THEN
316: g_ECO_rec.need_by_date := NULL ;
317: END IF;
318:
319: IF g_ECO_rec.effort = FND_API.G_MISS_NUM

Line 319: IF g_ECO_rec.effort = FND_API.G_MISS_NUM

315: IF g_ECO_rec.need_by_date = FND_API.G_MISS_DATE THEN
316: g_ECO_rec.need_by_date := NULL ;
317: END IF;
318:
319: IF g_ECO_rec.effort = FND_API.G_MISS_NUM
320: THEN
321: g_ECO_rec.effort := NULL ;
322: END IF;
323:

Line 379: x_return_status := FND_API.G_RET_STS_SUCCESS;

375:
376: l_token_tbl(1).token_name := 'ECO_NAME';
377: l_token_tbl(1).token_value := p_ECO_Rec.ECO_Name;
378:
379: x_return_status := FND_API.G_RET_STS_SUCCESS;
380:
381: IF l_ECO_rec.priority_code = FND_API.G_MISS_CHAR
382: THEN
383: l_ECO_rec.priority_code := NULL;

Line 381: IF l_ECO_rec.priority_code = FND_API.G_MISS_CHAR

377: l_token_tbl(1).token_value := p_ECO_Rec.ECO_Name;
378:
379: x_return_status := FND_API.G_RET_STS_SUCCESS;
380:
381: IF l_ECO_rec.priority_code = FND_API.G_MISS_CHAR
382: THEN
383: l_ECO_rec.priority_code := NULL;
384: END IF;
385:

Line 386: IF l_ECO_rec.approval_list_name = FND_API.G_MISS_CHAR

382: THEN
383: l_ECO_rec.priority_code := NULL;
384: END IF;
385:
386: IF l_ECO_rec.approval_list_name = FND_API.G_MISS_CHAR
387: THEN
388: l_ECO_rec.approval_list_name := NULL;
389: END IF;
390:

Line 391: IF l_ECO_rec.ECO_department_name = FND_API.G_MISS_CHAR

387: THEN
388: l_ECO_rec.approval_list_name := NULL;
389: END IF;
390:
391: IF l_ECO_rec.ECO_department_name = FND_API.G_MISS_CHAR
392: THEN
393: l_ECO_rec.ECO_Department_name := NULL;
394: END IF;
395:

Line 396: IF l_Unexp_ECO_rec.status_type = FND_API.G_MISS_NUM

392: THEN
393: l_ECO_rec.ECO_Department_name := NULL;
394: END IF;
395:
396: IF l_Unexp_ECO_rec.status_type = FND_API.G_MISS_NUM
397: THEN
398: l_Unexp_ECO_rec.status_type := NULL;
399: END IF;
400:

Line 401: IF l_Unexp_ECO_rec.approval_status_type = FND_API.G_MISS_NUM

397: THEN
398: l_Unexp_ECO_rec.status_type := NULL;
399: END IF;
400:
401: IF l_Unexp_ECO_rec.approval_status_type = FND_API.G_MISS_NUM
402: THEN
403: l_Unexp_ECO_rec.approval_status_type := NULL;
404: END IF;
405:

Line 406: IF l_ECO_rec.reason_code = FND_API.G_MISS_CHAR

402: THEN
403: l_Unexp_ECO_rec.approval_status_type := NULL;
404: END IF;
405:
406: IF l_ECO_rec.reason_code = FND_API.G_MISS_CHAR
407: THEN
408: l_ECO_rec.reason_code := NULL;
409: END IF;
410:

Line 411: IF l_ECO_rec.eng_implementation_cost = FND_API.G_MISS_NUM

407: THEN
408: l_ECO_rec.reason_code := NULL;
409: END IF;
410:
411: IF l_ECO_rec.eng_implementation_cost = FND_API.G_MISS_NUM
412: THEN
413: l_ECO_rec.eng_implementation_cost := NULL;
414: END IF;
415:

Line 416: IF l_ECO_rec.mfg_implementation_cost = FND_API.G_MISS_NUM

412: THEN
413: l_ECO_rec.eng_implementation_cost := NULL;
414: END IF;
415:
416: IF l_ECO_rec.mfg_implementation_cost = FND_API.G_MISS_NUM
417: THEN
418: l_ECO_rec.mfg_implementation_cost := NULL;
419: END IF;
420:

Line 421: IF l_ECO_rec.cancellation_comments = FND_API.G_MISS_CHAR

417: THEN
418: l_ECO_rec.mfg_implementation_cost := NULL;
419: END IF;
420:
421: IF l_ECO_rec.cancellation_comments = FND_API.G_MISS_CHAR
422: THEN
423: l_ECO_rec.cancellation_comments := NULL;
424: END IF;
425:

Line 426: IF l_ECO_rec.requestor = FND_API.G_MISS_CHAR

422: THEN
423: l_ECO_rec.cancellation_comments := NULL;
424: END IF;
425:
426: IF l_ECO_rec.requestor = FND_API.G_MISS_CHAR
427: THEN
428: l_ECO_rec.requestor := NULL;
429: END IF;
430:

Line 431: IF l_ECO_rec.description = FND_API.G_MISS_CHAR

427: THEN
428: l_ECO_rec.requestor := NULL;
429: END IF;
430:
431: IF l_ECO_rec.description = FND_API.G_MISS_CHAR
432: THEN
433: l_ECO_rec.description := NULL;
434: END IF;
435:

Line 441: IF l_Unexp_ECO_rec.initiation_date = FND_API.G_MISS_DATE

437: -- Entity Defaulting
438: -- Set null to unexposed data columns
439: --
440: */
441: IF l_Unexp_ECO_rec.initiation_date = FND_API.G_MISS_DATE
442: THEN
443: l_Unexp_ECO_rec.initiation_date := NULL ;
444: END IF ;
445:

Line 446: IF l_Unexp_ECO_rec.implementation_date = FND_API.G_MISS_DATE

442: THEN
443: l_Unexp_ECO_rec.initiation_date := NULL ;
444: END IF ;
445:
446: IF l_Unexp_ECO_rec.implementation_date = FND_API.G_MISS_DATE
447: THEN
448: l_Unexp_ECO_rec.implementation_date := NULL ;
449: END IF ;
450:

Line 451: IF l_Unexp_ECO_rec.cancellation_date = FND_API.G_MISS_DATE

447: THEN
448: l_Unexp_ECO_rec.implementation_date := NULL ;
449: END IF ;
450:
451: IF l_Unexp_ECO_rec.cancellation_date = FND_API.G_MISS_DATE
452: THEN
453: l_Unexp_ECO_rec.cancellation_date := NULL ;
454: END IF ;
455:

Line 456: IF l_ECO_rec.approval_date = FND_API.G_MISS_DATE

452: THEN
453: l_Unexp_ECO_rec.cancellation_date := NULL ;
454: END IF ;
455:
456: IF l_ECO_rec.approval_date = FND_API.G_MISS_DATE
457: THEN
458: l_ECO_rec.approval_date := NULL ;
459: END IF ;
460:

Line 461: IF l_ECO_rec.approval_request_date = FND_API.G_MISS_DATE

457: THEN
458: l_ECO_rec.approval_date := NULL ;
459: END IF ;
460:
461: IF l_ECO_rec.approval_request_date = FND_API.G_MISS_DATE
462: THEN
463: l_ECO_rec.approval_request_date := NULL ;
464: END IF ;
465:

Line 467: IF l_ECO_rec.change_management_type = FND_API.G_MISS_CHAR

463: l_ECO_rec.approval_request_date := NULL ;
464: END IF ;
465:
466: -- Eng Change
467: IF l_ECO_rec.change_management_type = FND_API.G_MISS_CHAR
468: THEN
469: l_ECO_rec.change_management_type := NULL;
470: END IF;
471:

Line 473: IF l_Unexp_ECO_rec.change_mgmt_type_code = FND_API.G_MISS_CHAR

469: l_ECO_rec.change_management_type := NULL;
470: END IF;
471:
472: -- Eng Change
473: IF l_Unexp_ECO_rec.change_mgmt_type_code = FND_API.G_MISS_CHAR
474: THEN
475: l_Unexp_ECO_rec.change_mgmt_type_code := NULL;
476: END IF;
477:

Line 479: IF l_ECO_rec.assignee = FND_API.G_MISS_CHAR

475: l_Unexp_ECO_rec.change_mgmt_type_code := NULL;
476: END IF;
477:
478: -- Eng Change
479: IF l_ECO_rec.assignee = FND_API.G_MISS_CHAR
480: THEN
481: l_ECO_rec.assignee := NULL;
482: END IF;
483:

Line 485: IF l_ECO_rec.assignee_company_name = FND_API.G_MISS_CHAR

481: l_ECO_rec.assignee := NULL;
482: END IF;
483:
484: /* -- Eng Change
485: IF l_ECO_rec.assignee_company_name = FND_API.G_MISS_CHAR
486: THEN
487: l_ECO_rec.assignee := NULL;
488: END IF;
489: */

Line 491: IF l_Unexp_ECO_rec.assignee_id = FND_API.G_MISS_NUM

487: l_ECO_rec.assignee := NULL;
488: END IF;
489: */
490: -- Eng Change
491: IF l_Unexp_ECO_rec.assignee_id = FND_API.G_MISS_NUM
492: THEN
493: l_Unexp_ECO_rec.assignee_id := NULL;
494: END IF;
495:

Line 496: IF l_ECO_rec.source_type = FND_API.G_MISS_CHAR

492: THEN
493: l_Unexp_ECO_rec.assignee_id := NULL;
494: END IF;
495:
496: IF l_ECO_rec.source_type = FND_API.G_MISS_CHAR
497: THEN
498: l_ECO_rec.source_type := NULL;
499: END IF;
500:

Line 501: IF l_Unexp_ECO_rec.source_type_code = FND_API.G_MISS_CHAR

497: THEN
498: l_ECO_rec.source_type := NULL;
499: END IF;
500:
501: IF l_Unexp_ECO_rec.source_type_code = FND_API.G_MISS_CHAR
502: THEN
503: l_Unexp_ECO_rec.source_type_code := NULL ;
504: END IF;
505:

Line 506: IF l_ECO_rec.source_name = FND_API.G_MISS_CHAR

502: THEN
503: l_Unexp_ECO_rec.source_type_code := NULL ;
504: END IF;
505:
506: IF l_ECO_rec.source_name = FND_API.G_MISS_CHAR
507: THEN
508: l_ECO_rec.source_name := NULL;
509: END IF;
510:

Line 511: IF g_unexp_eco_rec.source_id = FND_API.G_MISS_NUM

507: THEN
508: l_ECO_rec.source_name := NULL;
509: END IF;
510:
511: IF g_unexp_eco_rec.source_id = FND_API.G_MISS_NUM
512: THEN
513: g_unexp_eco_rec.source_id := NULL;
514: END IF;
515:

Line 516: IF g_ECO_rec.effort = FND_API.G_MISS_NUM

512: THEN
513: g_unexp_eco_rec.source_id := NULL;
514: END IF;
515:
516: IF g_ECO_rec.effort = FND_API.G_MISS_NUM
517: THEN
518: g_ECO_rec.effort := NULL ;
519: END IF;
520:

Line 522: l_ECO_rec.internal_use_only = FND_API.G_MISS_NUM

518: g_ECO_rec.effort := NULL ;
519: END IF;
520:
521: IF l_ECO_rec.internal_use_only IS NULL OR
522: l_ECO_rec.internal_use_only = FND_API.G_MISS_NUM
523: THEN
524: l_ECO_rec.internal_use_only := 1 ; -- 1 : Yes
525: END IF;
526:

Line 527: IF l_ECO_rec.need_by_date = FND_API.G_MISS_DATE THEN

523: THEN
524: l_ECO_rec.internal_use_only := 1 ; -- 1 : Yes
525: END IF;
526:
527: IF l_ECO_rec.need_by_date = FND_API.G_MISS_DATE THEN
528: l_ECO_rec.need_by_date := NULL ;
529: END IF;
530:
531:

Line 552: NVL(p_control_rec.validation_controller, FND_API.G_MISS_CHAR) =

548: -- Added by AS on 10/07/99 to facilitate ECO form re-architecture.
549: **********************************************************************/
550:
551: IF (p_control_rec.caller_type = 'FORM' AND
552: NVL(p_control_rec.validation_controller, FND_API.G_MISS_CHAR) =
553: 'PROCESS')
554: OR
555: l_ECO_rec.transaction_type = ENG_Globals.G_OPR_UPDATE
556: THEN

Line 568: NVL(p_control_rec.validation_controller, FND_API.G_MISS_CHAR) =

564: , x_processed => l_processed
565: , x_err_text => l_err_text
566: );
567: ELSIF (p_control_rec.caller_type = 'FORM' AND
568: NVL(p_control_rec.validation_controller, FND_API.G_MISS_CHAR) =
569: 'PROCESS' AND
570: l_Unexp_ECO_rec.approval_status_type not in (1,3))
571: THEN
572: l_processed := TRUE;

Line 828: l_ECO_rec.hierarchy_flag = FND_API.G_MISS_NUM

824: /* Added by MK on 11/29/00 Bug #1508078
825: -- Entity Defaulting hierarchy_flag and organization_hierarchy
826: --
827: IF l_ECO_rec.hierarchy_flag IS NULL OR
828: l_ECO_rec.hierarchy_flag = FND_API.G_MISS_NUM
829: THEN
830: l_ECO_rec.hierarchy_flag := 2 ; -- 2 : No
831: END IF ;
832:

Line 839: IF l_ECO_rec.organization_hierarchy = FND_API.G_MISS_CHAR

835: l_ECO_rec.organization_hierarchy := NULL ;
836: END IF ;
837: */
838:
839: IF l_ECO_rec.organization_hierarchy = FND_API.G_MISS_CHAR
840: THEN
841: l_ECO_rec.organization_hierarchy := NULL ;
842: END IF ;
843:

Line 1047: OR l_ECO_rec.hierarchy_flag = FND_API.G_MISS_NUM

1043: -- Modified populating hierarchy_flag and organization_hierarchy
1044: -- when these are miss values
1045:
1046: IF l_ECO_rec.hierarchy_flag IS NULL
1047: OR l_ECO_rec.hierarchy_flag = FND_API.G_MISS_NUM
1048: THEN
1049: l_ECO_rec.hierarchy_flag := p_old_ECO_rec.hierarchy_flag;
1050: END IF;
1051: */

Line 1054: OR l_ECO_rec.organization_hierarchy = FND_API.G_MISS_CHAR

1050: END IF;
1051: */
1052:
1053: IF l_ECO_rec.organization_hierarchy IS NULL
1054: OR l_ECO_rec.organization_hierarchy = FND_API.G_MISS_CHAR
1055: THEN
1056: l_ECO_rec.organization_hierarchy := p_old_ECO_rec.organization_hierarchy;
1057: END IF;
1058:

Line 1061: OR l_unexp_ECO_rec.hierarchy_id = FND_API.G_MISS_NUM

1057: END IF;
1058:
1059: --bug 10108394, populating hierarchy_id
1060: IF l_unexp_ECO_rec.hierarchy_id IS NULL
1061: OR l_unexp_ECO_rec.hierarchy_id = FND_API.G_MISS_NUM
1062: THEN
1063: l_unexp_ECO_rec.hierarchy_id := p_old_unexp_ECO_rec.hierarchy_id;
1064: END IF;
1065:

Line 1068: OR l_Unexp_ECO_rec.change_mgmt_type_code = FND_API.G_MISS_CHAR

1064: END IF;
1065:
1066: -- Eng Change
1067: IF l_Unexp_ECO_rec.change_mgmt_type_code IS NULL
1068: OR l_Unexp_ECO_rec.change_mgmt_type_code = FND_API.G_MISS_CHAR
1069: THEN
1070: l_Unexp_ECO_rec.change_mgmt_type_code := p_Old_Unexp_ECO_rec.change_mgmt_type_code ;
1071: END IF;
1072:

Line 1076: OR ( l_Unexp_ECO_rec.assignee_id = FND_API.G_MISS_NUM

1072:
1073: -- Eng Change
1074: -- User should be able to null out assignee
1075: IF l_Unexp_ECO_rec.assignee_id IS NULL
1076: OR ( l_Unexp_ECO_rec.assignee_id = FND_API.G_MISS_NUM
1077: AND p_Old_Unexp_ECO_rec.assignee_id IS NULL )
1078: THEN
1079: l_Unexp_ECO_rec.assignee_id := p_Old_Unexp_ECO_rec.assignee_id ;
1080: END IF;