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 618: from eng_change_statuses_vl

614: AND status_type <> 0)
615: OR status_type =0);
616: else
617: SELECT status_code ,status_type into l_st_code,l_st_type
618: from eng_change_statuses_vl
619: where status_name = p_status_name;
620: -- and status_code =status_type;//commented for bug 3332992
621: end if;
622:

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

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

Line 665: SELECT status_code into l_result from eng_change_statuses_vl

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