APPS.ENG_VAL_TO_ID dependencies on ENG_CHANGE_STATUSES_VL

Line 583: SELECT status_code into l_result from eng_change_statuses_vl

579: RETURN NUMBER
580: IS
581: l_result NUMBER;
582: BEGIN
583: SELECT status_code into l_result from eng_change_statuses_vl
584: where status_name = p_status_name;
585:
586: return l_result;
587: EXCEPTION

Line 609: from eng_change_statuses_vl

605: BEGIN
606: x_return_status := FND_API.G_RET_STS_SUCCESS;
607: if p_plm_or_erp ='PLM' then
608: SELECT status_code ,status_type into l_st_code,l_st_type
609: from eng_change_statuses_vl
610: where status_name = p_status_name
611: and ((status_code in (select status_code from eng_lifecycle_statuses
612: where entity_name='ENG_CHANGE_TYPE'
613: and entity_id1 = p_change_order_type_id)

Line 619: from eng_change_statuses_vl

615: OR status_type =0);
616: else
617: SELECT status_code ,status_code into l_st_code,l_st_type
618: /* Changed the above line from SELECT status_code ,status_type into l_st_code,l_st_type for Bug 8823124*/
619: from eng_change_statuses_vl
620: where status_name = p_status_name;
621: -- and status_code =status_type;//commented for bug 3332992
622: end if;
623:

Line 659: /* Status will not be saved in FND table anymore but in eng_change_statuses_vl

655: RETURN VARCHAR2
656: IS
657: l_result VARCHAR2(30);
658: BEGIN
659: /* Status will not be saved in FND table anymore but in eng_change_statuses_vl
660: SELECT lookup_code INTO l_result
661: FROM fnd_lookup_values
662: where lookup_type = 'ENG_CHANGE_LINE_STATUSES'
663: AND meaning = p_status_name AND language = userenv('LANG'); */

Line 666: SELECT status_code into l_result from eng_change_statuses_vl

662: where lookup_type = 'ENG_CHANGE_LINE_STATUSES'
663: AND meaning = p_status_name AND language = userenv('LANG'); */
664: -- Bug 2908248
665:
666: SELECT status_code into l_result from eng_change_statuses_vl
667: where status_name = p_status_name;
668:
669: return l_result;
670: EXCEPTION