5040: x_spec_type OUT NOCOPY VARCHAR2) IS
5041:
5042: CURSOR c IS
5043: SELECT meaning
5044: FROM mfg_lookups
5045: WHERE lookup_type = 'QA_SPEC_TYPE'
5046: AND lookup_code =
5047: ( SELECT assignment_type
5048: FROM qa_specs
5252: AND transaction_type_name = p_value;
5253:
5254: CURSOR C1 IS
5255: SELECT 1
5256: FROM MFG_LOOKUPS
5257: WHERE lookup_type ='WIP_MOVE_TRANSACTION_TYPE'
5258: AND meaning = p_value;
5259:
5260: CURSOR C_MOBILE(p_lookup_type VARCHAR2) IS