APPS.ENG_VALIDATE dependencies on MFG_LOOKUPS

Line 247: FROM mfg_lookups

243: END IF;
244:
245: SELECT 'VALID'
246: INTO l_dummy
247: FROM mfg_lookups
248: WHERE lookup_type = 'ENG_ECN_APPROVAL_STATUS'
249: AND lookup_code = p_approval_status_type;
250:
251: RETURN TRUE;

Line 500: --FROM mfg_lookups

496: END IF;
497:
498: --SELECT 'VALID'
499: --INTO l_dummy
500: --FROM mfg_lookups
501: --WHERE lookup_type = 'ECG_ECN_STATUS'
502: -- and lookup_code = p_status_type;
503:
504: SELECT 'VALID'

Line 774: FROM mfg_lookups

770: END IF;
771:
772: SELECT 'VALID'
773: INTO l_dummy
774: FROM mfg_lookups
775: WHERE lookup_type = 'ECG_MATERIAL_DISPOSITION'
776: and lookup_code = p_disposition_type;
777:
778: RETURN TRUE;

Line 1047: * in the Table MFG_LOOKUPS with a Lookup Type of 'WIP_SUPPLY'

1043: * Parameters OUT: Error Text which will be populated in case of an
1044: * unexpected error.
1045: * Returns : True if the Wip_supply_Type exist in the Lookup else False
1046: * Purpose : Verify that the value of Wip_Supply_Type is valid, by looking
1047: * in the Table MFG_LOOKUPS with a Lookup Type of 'WIP_SUPPLY'
1048: *****************************************************************************/
1049: FUNCTION Wip_Supply_Type ( p_wip_supply_type IN NUMBER
1050: , x_err_text OUT NOCOPY VARCHAR2 )
1051: RETURN BOOLEAN

Line 1064: FROM mfg_lookups

1060: END IF;
1061:
1062: SELECT 'VALID'
1063: INTO l_dummy
1064: FROM mfg_lookups
1065: WHERE lookup_code = p_wip_supply_type
1066: AND lookup_type = 'WIP_SUPPLY' ;
1067:
1068: RETURN TRUE;