134: return l_return_type_name;
135: ELSIF (p_rule_type_code = 12) THEN -- Bug : 6682436
136: SELECT meaning
137: INTO l_return_type_name
138: FROM mfg_lookups_v
139: WHERE lookup_type = 'WMS_CARTONIZATION_ALGORITHMS'
140: AND lookup_code = p_return_type_id;
141: return l_return_type_name;
142: END IF;
506: Begin
507:
508: select ml.meaning
509: into l_transaction_action_name
510: from mfg_lookups ml
511: where ml.lookup_type = 'MTL_TRANSACTION_ACTION'
512: and ml.lookup_code = p_transaction_action_id ;
513:
514: Return l_transaction_action_name;