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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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;
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;
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;
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:
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: */
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: */
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:
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;
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:
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;
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:
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:
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
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:
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;
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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: */
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:
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:
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:
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:
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:
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:
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:
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:
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
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;
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:
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:
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: */
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:
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:
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:
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;