1129: end if;
1130: end if;
1131:
1132: SELECT PARAMETER_VALUE INTO l_value
1133: FROM AMW_PARAMETERS
1134: WHERE PARAMETER_NAME = p_param_name
1135: AND PK1 = p_org_id;
1136: return l_value;
1137: EXCEPTION
2047: l_param_values tvalues;
2048: l_pk_values tn;
2049: begin
2050: select pk1, parameter_value bulk collect into l_pk_values,l_param_values
2051: from amw_parameters
2052: where parameter_name = 'PROCESS_APPROVAL_OPTION';
2053:
2054: for i in l_pk_values.first .. l_pk_values.last loop
2055: g_appr_opt_val(l_pk_values(i)) := l_param_values(i);