58: , cltl.name
59: , cltl.description
60: , cl.original_system_reference
61: FROM ENG_CHANGE_LINES cl
62: , ENG_CHANGE_LINES_TL cltl
63: WHERE cl.change_id = p_change_id
64: AND cl.sequence_number = p_line_sequence_number
65: AND cl.change_line_id = cltl.change_line_id
66: AND cltl.language = userenv('LANG') ;
448: ,p_change_line_rec. Start_After_Status_Code
449: );
450:
451:
452: INSERT INTO ENG_CHANGE_LINES_TL (
453: change_line_id
454: , language
455: , source_lang
456: , created_by
473: , p_change_line_rec.description
474: FROM FND_LANGUAGES lang
475: WHERE lang.installed_flag in ('I', 'B')
476: AND NOT EXISTS ( SELECT NULL
477: FROM ENG_CHANGE_LINES_TL tl
478: WHERE tl.change_line_id = p_change_line_unexp_rec.change_line_id
479: AND tl.language = lang.language_code
480: );
481:
580: , pk5_value = p_change_line_unexp_rec.pk5_value
581: , original_system_reference = p_change_line_rec.original_system_reference
582: WHERE change_line_id = p_change_line_unexp_rec.change_line_id ;
583:
584: UPDATE ENG_CHANGE_LINES_TL
585: SET last_update_date = SYSDATE
586: , last_updated_by = BOM_Globals.Get_User_Id
587: , last_update_login = BOM_Globals.Get_Login_Id
588: , name = p_change_line_rec.name
664: DELETE FROM ENG_CHANGE_LINES
665: WHERE change_line_id = l_change_line_unexp_rec.change_line_id ;
666:
667:
668: DELETE FROM ENG_CHANGE_LINES_TL
669: WHERE change_line_id = l_change_line_unexp_rec.change_line_id ;
670:
671: -- Return the status and message table.
672: x_return_status := l_return_status;