APPS.ENG_CHANGE_LINE_UTIL dependencies on ENG_CHANGE_LINES

Line 61: FROM ENG_CHANGE_LINES cl

57: , cl.cancelation_date
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

Line 62: , ENG_CHANGE_LINES_TL cltl

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') ;

Line 346: * table: ENG_CHANGE_LINES/_TL.

342: * Change Line unexposed column record
343: * Parameters OUT: Return Status
344: * Message Token Table
345: * Purpose : This procedure will insert a record in the Change Line
346: * table: ENG_CHANGE_LINES/_TL.
347: *
348: *****************************************************************************/
349: PROCEDURE Insert_Row
350: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type

Line 386: INSERT INTO ENG_CHANGE_LINES(

382:
383: FETCH c_csr INTO l_change_id;
384: END IF;
385:
386: INSERT INTO ENG_CHANGE_LINES(
387: change_line_id
388: , change_id
389: , change_type_id
390: , status_code

Line 452: INSERT INTO ENG_CHANGE_LINES_TL (

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

Line 477: FROM ENG_CHANGE_LINES_TL tl

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:

Line 563: UPDATE ENG_CHANGE_LINES

559:
560: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Performing update change line . . .') ;
561: END IF ;
562:
563: UPDATE ENG_CHANGE_LINES
564: SET last_update_date = SYSDATE
565: , last_updated_by = BOM_Globals.Get_User_Id
566: , last_update_login = BOM_Globals.Get_Login_Id
567: , change_type_id = p_change_line_unexp_rec.change_type_id

Line 584: UPDATE ENG_CHANGE_LINES_TL

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

Line 664: DELETE FROM ENG_CHANGE_LINES

660:
661: -- Need to Delete Associations ?
662:
663:
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

Line 668: DELETE FROM ENG_CHANGE_LINES_TL

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;